参照wmdfd
导入Java.SQL.connection;
导入Java.SQL.driver manager;
导入Java.SQL.prepared statement;
import java.sql.ResultSet;
导入Java.SQL.sqlexception;
//*
公共金融类MySQL dbutils {
privatestaticstringurl=' JDBC : MySQL ://192.168.200.16133603306/cerp ';
私有静态字符串用户=' root ';
私有静态字符串PSW=' 123456 ';
私密静态连接连接;
静态{
try {
class.forname (com.MySQL.JDBC.driver );
}catch(classnotfoundexceptione ) )
e .打印堆栈跟踪(;
thrownewruntimeexception(e;
}
}
私密MySQL dbutils
}
//*
publicstaticconnectiongetconnection (
if(null==Conn ) {
try {
conn=驱动程序管理器. getconnection (URL,user,psw );
}catch(sqlexceptione ) {
e .打印堆栈跟踪(;
thrownewruntimeexception(e;
}
}
返回连接;
}
//*
publicstaticvoidcloseresources (连接连接,平静的溪流,
if (空!=RS({ (
try {
rs.close (;
}catch(sqlexceptione ) {
e .打印堆栈跟踪(;
thrownewruntimeexception(e;
} finally {
if (空!=pstmt ) {
try {
pstmt.close (;
}catch(sqlexceptione ) {
e .打印堆栈跟踪(;
thrownewruntimeexception(e;
} finally {
if (空!=conn
try {
conn.close (;
}catch(sqlexceptione ) {
e .打印堆栈跟踪(;
thrownewruntimeexception(e;
}
}
}
}
}
}
}
}