MyEclipse,数据库是MySql;
数据库连接代码:
private static DataSource ds;
private static final ThreadLocal<Connection> connLocal=new ThreadLocal<Connection>();
static {
Properties props = new Properties();
try {
props.load(DBUtil.class.getClassLoader().getResourceAsStream("db.properties"));
ds =BasicDataSourceFactory.createDataSource(props);
} catch (Exception e) {
// TODO: handle exception
e.printStackTrace();
}
}
public static Connection getConnection()throws SQLException{
Connection conn =connLocal.get();
if(conn ==null){
conn =ds.getConnection();
connLocal.set(conn);
}
return conn;
}
public static void closeConnection()throws SQLException{