public Connection OpenConnection() {
Connection conn = null;
try {
Context cx = new InitialContext();
DataSource data = (DataSource) cx // 获取数据源
.lookup("java:comp/env/jdbc/News");
conn = data.getConnection();
} catch (Exception e) {
e.printStackTrace();
}
return conn;
}
// 关闭连接
public void CloseConnection(Connection conn, PreparedStatement pare,
ResultSet result) throws SQLException {
if (conn != null) {
conn.close();
}
if (pare != null) {
pare.close();
}
if (result != null) {
result.close();
}
Connection conn = null;
try {
Context cx = new InitialContext();
DataSource data = (DataSource) cx // 获取数据源
.lookup("java:comp/env/jdbc/News");
conn = data.getConnection();
} catch (Exception e) {
e.printStackTrace();
}
return conn;
}
// 关闭连接
public void CloseConnection(Connection conn, PreparedStatement pare,
ResultSet result) throws SQLException {
if (conn != null) {
conn.close();
}
if (pare != null) {
pare.close();
}
if (result != null) {
result.close();
}
}
//context 文件配置
<Environment name="tjndi" value="Hello JNDI" type="java.lang.String" />
<Resource name="jdbc/News"
auth="Container"
type="javax.sql.DataSource"
username="sa"
password="bdqn"
driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver"
url="jdbc:sqlserver://127.0.0.1:1433;DataBaseName=QNLunganue"
maxActive="8"
maxIdle="4"
maxWait="10000"/>