import java.sql.connection;
import java.sql.drivermanager;
import java.sql.preparedstatement;
import java.sql.resultset;
public class dbutil {
connection conn = null;
preparedstatement stmt = null;
string driver = com.mysql.jdbc.driver;
string url = jdbc:mysql://10.137.5.23/mcip?useunicode=true&characterencoding=gbk;
string user = mcip;
string password = mcip;
resultset rs = null;
//完成连接的创建
public connection getconnection() throws exception{
class.forname(driver);
if(conn == null){
conn = drivermanager.getconnection(url, user, password);
}
return conn;
}
//创建语句对象
public preparedstatement createstatement(string sql) throws exception{
stmt = getconnection().preparestatement(sql);
return stmt;
}
//执行有结果集返回的方法
public resultset excutequery() throws exception{
rs = stmt.executequery();
return rs;
}
//执行没有结果集返回的方法
public int excuteupdate() throws exception{
return stmt.executeupdate();
}
//关闭对象
public void close(){
if(rs != null)try{rs.close();}catch(exception e){}
if(stmt != null)try{stmt.close();}catch(exception e){}
if(conn != null)try{conn.close();}catch(exception e){}
}
} bitscn.com