dbconn.java

一本jsp自学教材

package test;
import java.sql.*;
import javax.sql.*;
import javax.naming.*;
public class DBConn{
  private Connection conn;
  private Statement stmt;
  private PreparedStatement pstmt;
  public DBConn(String dsName)
   {
     try{
     Context initCtx = new InitialContext(); 
     Context ctx = (Context) initCtx.lookup("java:comp/env"); 
     //获取连接池对象 
     DataSource ds =(DataSource)ctx.lookup(dsName); 
     //创建连接
     conn = ds.getConnection(); 
    }
    catch(Exception e)
    {
      System.out.print(e.toString()); 
    } 
  }
  public synchronized Statement getStmt()throws Exception
   {
     stmt=conn.createStatement();
     return stmt;
   }
  public synchronized PreparedStatement getPstmt(String sql)throws Exception
   {
     pstmt=conn.prepareStatement(sql);
     return pstmt;
   }
}