这是一个通用的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
微信扫一扫 
支付宝扫一扫 