记性不如烂笔头22-JAVA数据库连接池C3P0(二)
2015-07-24 11:33:39
·
作者:
·
浏览: 11
();
Stringsql = " select sysdate from dual ";
PreparedStatementps = con.prepareStatement(sql);
rs= ps.executeQuery();
while(rs.next()) {
Stringvalue = rs.getString("sysdate");
System.out.println(value+ ",数据库连接成功");
}
}catch (Exception e) {
e.printStackTrace();
}finally {
//释放资源
EasyC3p0.close(con,st, rs);
}
}
}
5、运行结果
2015-02-03 16:16:27.0,数据库连接成功
?