推荐!一个通用的javaBean很方便的实现连接数据库、查询、插入、修改功能

这是一个通用的javaBean,能够很方便的实现连接数据库、查询、插入、修改功能。、

package com.common;
import java.sql.*;
public class DataBaseConn {
 public  Connection conn = null;
 
 public void createConn(){
  String DRIVER = "org.gjt.mm.mysql.Driver";
  String url="jdbc:mysql://localhost/xin126?user=root&password=789456&useUnicode=true&characterEncoding=GB2312";
  if(conn == null){
   try{
    Class.forName(DRIVER).newInstance();
    conn = DriverManager.getConnection(url);
   }catch(Exception e){
    e.printStackTrace();
   }
  }
 }
 public  Connection getConn(){
  if(conn == null){
   createConn();
  }
  return conn;
 }
 
 public  void closeConn(){
  if(conn != null){
   try {
    conn.close();
    conn = null;
   } catch (Exception e) {
    e.printStackTrace();
   }
  }
 }
 public ResultSet executeQuery(String sql) {
  ResultSet rs = null;
  if (conn == null) {
   createConn();
  }
  try {
   Statement stmt = conn.createStatement();
   rs = stmt.executeQuery(sql);
  } catch (Exception e) {
   e.printStackTrace();
  }
  return rs;
 }

 public void executeUpdate(String sql) {
  if (conn == null) {
   createConn();
  }
  try {
   Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
   stmt.executeUpdate(sql);
  } catch (Exception e) {
   e.printStackTrace();
  }
 }
}
相关文章:

125jz网原创文章。发布者:江山如画,转载请注明出处:http://www.125jz.com/9009.html

发表评论

登录后才能评论