81,092
社区成员
发帖
与我相关
我的任务
分享
<?xml version="1.0" encoding="UTF-8"?>
<Context>
<Resource
name="JDBC/DBpool"
auth="Container"
type="javax.sql.DataSource"
driverClassName="sun.jdbc.odbc.JdbcOdbcDriver"
url="jdbc:odbc:Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=F:/abc.accdb"
maxAction="20"
maxldle="10"
maxWait="-1"
/>
</Context>
import java.sql.*;
import javax.naming.*;
import javax.sql.DataSource;
//连接池类
public class DbPool {
private static Connection conn;//声明数据库连接对象
public void createConn() {
try {
//声明数据源
Context initCtx = new javax.naming.InitialContext();
Context envCtx = (Context) initCtx.lookup("java:comp/env");
DataSource ds = (DataSource) envCtx.lookup("JDBC/DBpool");
//获取数据源
conn = ds.getConnection();
System.out.println("db connect success");
} catch (Exception e) {
System.out.println("db connect error");
e.printStackTrace();
}
}
//执行sql语句,返回result
public ResultSet executeQuery(String sql) {
ResultSet rs = null;
if (conn == null) {
createConn();
}
try {
Statement st = conn.createStatement();
rs = st.executeQuery(sql);
} catch (Exception e) {
e.printStackTrace();
}
return rs;
}
}