我在写jsp页面时,遇到dao层连接数据库,我看了很多博客,发现可以直接写一个工具,我现在分享出来,这个工具代码,在框架中是用不上的,只限于jsp页面。
在框架中会用到c3p0连接池,直接简化了代码,我的代码如下
public class newsdao {
public ArrayList select(){
ArrayList al=new ArrayList();
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:ORCL","scott","tiger");
Statement stmt=conn.createStatement();
ResultSet rs = stmt.executeQuery("select * from news");
while(rs.next()){
news l=new news();
l.setBiaoti(rs.getString("biaoti"));
l.setNeirong(rs.getString("neirong"));
l.setFoot(rs.getString("foot"));
al.add(l);
}
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
closeAll();
return al;
}
private void closeAll() {
// TODO Auto-generated method stub
}
}
仅供大家参考!!!