public class DBconn {
private DataSource ds=null;
Connection conn = null;
PreparedStatement pstmt=null;
ResultSet rs = null;
public DBconn()
{
try
{
Context initCtx = new InitialContext();
Context ctx = (Context)initCtx.lookup("java:comp/env");Object obj = (Object)ctx.lookup("jdbc/jiheinfo");
javax.sql.DataSource ds = (javax.sql.DataSource)obj;
conn = ds.getConnection();}
catch(NamingException e)
{
System.out.println("从数据池取得数据库连接时出错;\r\n错误为:" + e);
}
catch(SQLException e)
{
System.out.println("从数据池取得数据库连接时出错;\r\n错误为:" + e);
}
}
public ResultSet executeQuery(String sql){
try{pstmt=conn.prepareStatement(sql,ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
rs=pstmt.executeQuery();
}catch(SQLException e){
System.err.println(e.getMessage());
}return rs;}
请执教?
private DataSource ds=null;
Connection conn = null;
PreparedStatement pstmt=null;
ResultSet rs = null;
public DBconn()
{
try
{
Context initCtx = new InitialContext();
Context ctx = (Context)initCtx.lookup("java:comp/env");Object obj = (Object)ctx.lookup("jdbc/jiheinfo");
javax.sql.DataSource ds = (javax.sql.DataSource)obj;
conn = ds.getConnection();}
catch(NamingException e)
{
System.out.println("从数据池取得数据库连接时出错;\r\n错误为:" + e);
}
catch(SQLException e)
{
System.out.println("从数据池取得数据库连接时出错;\r\n错误为:" + e);
}
}
public ResultSet executeQuery(String sql){
try{pstmt=conn.prepareStatement(sql,ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
rs=pstmt.executeQuery();
}catch(SQLException e){
System.err.println(e.getMessage());
}return rs;}
请执教?
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货