package *.dao;
import java.sql.*;
import java.util.Hashtable;
import javax.naming.Context;
import javax.naming.InitialContext;
import javax.sql.DataSource;
import linktop.pj5api.tools.XmlUtil;
public class BaseDao {
/**
* 开启连接池
*
* @return connection
*/
public Connection getConn() {
Connection conn = null;
try {
Context context = new InitialContext(); \\由tomcat、weblogic等发放Context
DataSource ds = (DataSource) context.lookup("jdbc/jads");
conn = ds.getConnection();
} catch (Exception e) {
e.printStackTrace();
}
return conn;
}
/**
* 关闭连接池
*
* @param conn
* @param sta
* @param rs
*/
public void getClose(Connection conn, PreparedStatement sta, ResultSet rs) {
try {
if (rs != null) {
rs.close();
}
if (sta != null) {
sta.close();
}
if (conn != null) {
if (conn.isClosed() == false) {
conn.close();
}
}
} catch (Exception e) {
e.printStackTrace();
}
}
}
jndi数据库连接方式
最新推荐文章于 2020-11-25 11:48:10 发布