package java7b.aone.db;
import java.io.IOException;
import snaq.db.ConnectionPoolManager;
public class DBConn {
private static ConnectionPoolManager cpm = null;
private DBConn(){
}
public static ConnectionPoolManager getCpm(){
if( null == cpm){
try {
cpm = ConnectionPoolManager.getInstance("dbpool.properties");
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
return cpm;
}
public static void release(){
cpm.release();
}
}
//
package java7b.aone.db;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class DBDao {
private static Connection conn = null;
private static Statement stmt = null;
private static ResultSet rs = null;
/**
* 获取连接
*/
public static Connection getConn(){
try {
conn = DBConn.getCpm().getConnection("pooltest");
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return conn;
}
/**
* 关闭连接
*/
public void closeConn(){
if( conn != null){
try {
conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
public static void main(String []args){
DBDao.getConn();
}
}
import java.io.IOException;
import snaq.db.ConnectionPoolManager;
public class DBConn {
private static ConnectionPoolManager cpm = null;
private DBConn(){
}
public static ConnectionPoolManager getCpm(){
if( null == cpm){
try {
cpm = ConnectionPoolManager.getInstance("dbpool.properties");
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
return cpm;
}
public static void release(){
cpm.release();
}
}
//
package java7b.aone.db;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class DBDao {
private static Connection conn = null;
private static Statement stmt = null;
private static ResultSet rs = null;
/**
* 获取连接
*/
public static Connection getConn(){
try {
conn = DBConn.getCpm().getConnection("pooltest");
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return conn;
}
/**
* 关闭连接
*/
public void closeConn(){
if( conn != null){
try {
conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
public static void main(String []args){
DBDao.getConn();
}
}