access_dbconnect.java

来自「这是一个关于jsp的学习文档.为学习jsp的朋友提供方便」· Java 代码 · 共 49 行

package access;
import java.sql.*;

public class access_dbconnect
  {
   String sDBDriver="sun.jdbc.odbc.JdbcOdbcDriver";
   String sConnStr="jdbc:odbc:sqlodbc";
   Connection conn=null;
   ResultSet rs=null;
   
   public access_dbconnect()
   {
    try{
        Class.forName(sDBDriver);
       }  
   catch(java.lang.ClassNotFoundException e)
       {
        System.err.println("not found1");
       } 
   }
   
 public ResultSet executeQuery(String sql)
   {
    rs=null;
    try{
        conn=DriverManager.getConnection(sConnStr);
        Statement stmt=conn.createStatement();
        rs=stmt.executeQuery(sql);
       }
   catch(SQLException ex){
   	  System.err.println("aq.executeQuery:"+ex.getMessage());
   	  }  
   return rs;  
}
 
  public ResultSet executeUpdate(String sql)
   {
    rs=null;
    try{
        conn=DriverManager.getConnection(sConnStr);
        Statement stmt=conn.createStatement();
        stmt.executeUpdate(sql);
       }
   catch(SQLException ex){
   	  System.err.println("not found3:"+ex.getMessage());
   	  }  
   return rs;  
}
}