java 连接池 单例_连接池 ----单例模式

packagecom.phone.shuyinghengxie;importjava.sql.PreparedStatement;importjava.sql.ResultSet;importjava.sql.SQLException;importjava.util.ArrayList;importjava.util.List;importorg.junit.Test;public classComboPooledDataSourceDemoTest1 {public static voidmain(String[] args)

{

ComboPooledDataSourceDemo cp=ComboPooledDataSourceDemo.getInstance() ;

List list = new ArrayList<>() ;

cp.getConnection() ;

String sql= "select * from person ";try{

PreparedStatement pt=cp.getConnection().prepareStatement(sql) ;

ResultSet rt=pt.executeQuery() ;while(rt.next())

{

Person p= newPerson();

p.setName(rt.getString("name"));

p.setAge(rt.getString("age"));

p.setSex(rt.getString("sex"));

p.setTelNum(rt.getString("telNum"));

p.setAddress(rt.getString("address"));

list.add(p) ;

}for(Person p : list)

{

System.out.println(p);

}

System.out.println("哈哈");

}catch(SQLException e) {//TODO 自动生成的 catch 块

e.printStackTrace();

}

}

}

}