dbbean.java

来自「基于jsp+javabean+tomcat+eclipse+SQLServer2」· Java 代码 · 共 71 行

package DB;
import java.sql.*;
public class DBBean {
  String sDBDriver="sun.jdbc.odbc.JdbcOdbcDriver";
   String sConnStr="jdbc:odbc:LocalServer";
  ResultSet rs=null;
  Connection conn=null;
  String user=""; 
  String password=""; 
  public DBBean() {
    try{
   Class.forName(sDBDriver);
 }
    catch(Exception e){
   		e.printStackTrace();
   }
//处理异常


}
public ResultSet executeQuery(String sql){
   rs=null;
    try{
        
     conn=DriverManager.getConnection(sConnStr,user,password);
     Statement stmt=conn.createStatement();
   rs=stmt.executeQuery(sql);
   }
   catch(SQLException ex)
   {
     System.err.println("aq.executeQuery:"+ex.getMessage());
     // System.out.println("connectfailure!");
   }
   return rs;
 }
 public  int executeUpdate(String sql){
    int rs=0;
     try{
     conn=DriverManager.getConnection(sConnStr,user,password);
     Statement stmt=conn.createStatement();
    rs=stmt.executeUpdate(sql);
    }
    catch(SQLException ex)
    {
      System.err.println("aq.executeUpdate:"+ex.getMessage());
    // System.out.println("runfailure!");
    }
    return rs;
  }
  
  public String doWithQuote(String sStr) { 
  if (sStr == null || sStr.equals("")) { 
  return sStr; 
  } 
  StringBuffer sTmp1 = new StringBuffer(); 
  int i = 0; 
  while (i <= sStr.length()-1) { 
  if (sStr.charAt(i) == '\'') { 
  sTmp1 = sTmp1.append("''"); 
  }else
  { 
  sTmp1 = sTmp1.append(sStr.substring(i,i+1)); 
  } 
  i++; 
  } 
  String S2;
  S2=sTmp1.toString();
  return S2; 
  }  

}