bean_to_database.java

JSP同学录JSP+SQL基于B/S结构

package bean;
import java.sql.*;
public class Bean_to_DataBase{
  //声明全局变量
  Connection con;
  Statement stmt;
  ResultSet rs;
  
  //装载驱动程序
  public Bean_to_DataBase(){
    try{
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    }
    catch(ClassNotFoundException e){
      System.out.println(e.toString());
    }
  }

  //删除的方法
  public boolean delete(String sql){
    try{
      con=DriverManager.getConnection("jdbc:odbc:message_manager","","");
      stmt=con.createStatement();
      sql=this.toChinese(sql);
      stmt.executeUpdate(sql);
      return(true);
    }
    catch(SQLException e1){
      System.out.println(e1.toString());
      return(false);
    } 
  }

  //添加的方法
  public boolean add(String sql){
    try{
      con=DriverManager.getConnection("jdbc:odbc:message_manager","","");
      stmt=con.createStatement();
      //sql=this.toChinese(sql);
      stmt.executeUpdate(sql);
      return(true);
    }
    catch(SQLException e2){
      System.out.println(e2.toString());
      return(false);
    } 
  }

  //查询的方法
  public ResultSet query(String sql){
    try{
      con=DriverManager.getConnection("jdbc:odbc:message_manager","","");
      stmt=con.createStatement();
      //sql=this.toChinese(sql);
      rs= stmt.executeQuery(sql);
     
    }
    catch(SQLException e3){
      System.out.println(e3.toString());
    }  
     return rs; 
  }
  public  static String toChinese(String str){
  	try{
  	  if(str==null)
  	    return null;
  		
  	  else
  	   str=new String(str.getBytes("ISO8859-1"),"GBK");
  	   return str;
  	}  
  	catch(Exception e){
  		return e.toString();
  		
  		}
  	
  	
  	}
}

//这里没有关闭连接和容器
//删除的方法和添加的方法一样是否可以合并