粘贴自己用
public class DBUtil {
/**
* 通过连接池获取数据库的链接
* @return
*/
public static Connection getConnection()
{
try {
Context context=new InitialContext();
DataSource ds=(DataSource)context.lookup("java:/comp/env/guestbook");
Connection conn=ds.getConnection();
return conn;
} catch (NamingException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return null;
}
/**
* 关闭数据库的链接
* @param conn
* @param st
* @param rs
*/
public void close(Connection conn,Statement st,ResultSet rs)
{
try {
if(rs!=null)
{
rs.close();
}
if(st!=null)
{
st.close();
}
if(rs!=null)
{
rs.close();
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}