[java]代码库
package cg.dao;
import java.sql.*;
public class MysqlDao {
private MysqlDao(){}
private static Connection conn = null;
public static Connection getConn(){
try{
DriverManager.registerDriver(new com.mysql.jdbc.Driver());
String url = "jdbc:mysql://localhost:3306/testdb?user=root&password=root";
conn = DriverManager.getConnection(url);
}catch(Exception e){
System.out.println(e);
}
return conn;
}
public static void closeConn(Statement stm,ResultSet rs){
try{
if(conn != null)
conn.close();
if(stm != null)
stm.close();
if(rs != null)
rs.close();
}catch(Exception e){
e.printStackTrace();
}
}
}
初级程序员
by: XL 发表于:2014-06-07 10:49:19 顶(0) | 踩(0) 回复
注册只需一次就可以,放在静态代码块里比较好
回复评论