81,092
社区成员
发帖
与我相关
我的任务
分享
public class Pool {
protected Connection conn;
protected Statement stmt;
protected ResultSet rs;
protected String sql;
public Connection getConnection(){
Connection conn = null;
try {
Context c = new InitialContext();
DataSource ds = (DataSource)c.lookup("java:comp/env/jdbc/jlbzy");
conn = ds.getConnection();
} catch (NamingException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
return conn;
}
//释放资源
public void free(ResultSet rs, PreparedStatement pstmt, Connection conn) {
try {
if (rs != null)
rs.close();
} catch (SQLException e) {
e.printStackTrace();
} finally {
try {
if (pstmt != null)
pstmt.close();
} catch (SQLException e) {
e.printStackTrace();
} finally {
try {
if (conn != null){
conn.close();}
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}
数据库操作类如下:
public class AdminDao{
Connection conn;
PreparedStatement pstmt;
ResultSet rs;
String sql ;
Pool pool = new Pool();
public boolean login(String userName,String userPass){
conn = pool.getConnection();
boolean flag = false;
sql = "select * from admin where userName = ? and userPass = ?";
try {
pstmt = conn.prepareStatement(sql);
pstmt.setString(1, userName);
pstmt.setString(2, userPass);
rs = pstmt.executeQuery();
if(rs.next()){
flag = true;
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
pool.free(rs, pstmt, conn);
}
return flag;
}
}