利用javabean轻松实现对数据库的连接、查询以及增删改

在做jsp开发的时候，经常需要对数据库进行查询及增删改，而这些操作使用的又是非常频繁
写了一个javabean，来实现与数据库的连接以及对数据库的增删改

QueryBean.java:

pacakage operate_db;
/**
* Title: select insert update and delete
* Description: select insert update and delete
* Copyright: zhizhilizi
* @authorzhizhilizi
* @version 1.0
*/

import java.sql.*;
public class QueryBean
{
public String query_statement; /*定义sql语句*/
public String param[]; /*查询条件,或者是新的记录*/
public ResultSet result=null;
public Connection conn;

public void setParam(String[] param)
{
      this.param=param;
}
public void setQuerystatement(String query_statement)
{
       this.query_statement=query_statement;
}
public void setConnection(String driverName,String jdbcURL,String username,String passwd) throws Exception
{
      Connection conn1;
      Class.forName(driverName);
      conn1=DriverManager.getConnection(jdbcURL,username,passwd);
      conn1.setAutoCommit(false);
      this.conn = conn1;
}
/*获取查询结果*/
public ResultSet getResult()
{
       try
     {
        PreparedStatement select_stm=conn.prepareStatement  (query_statement,java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE,java.sql.ResultSet.CONCUR_READ_ONLY);
        if (param!=null)
          for(int i=0;i<param.length;i++)
         select_stm.setString(i+1,param);
          result=select_stm.executeQuery();
     }catch(Exception e){System.out.println(e);}
  
     return result;
}

/*对数据库进行增加记录操作*/
public void insertRecord() throws SQLException,java.io.UnsupportedEncodingException
{
       try
          {
             PreparedStatement insert_stm=conn.prepareStatement(query_statement);
             if (param!=null)
             for(int i=0;i<param.length;i++)
             insert_stm.setString(i+1,param);
             insert_stm.executeUpdate();
             insert_stm.close();
             conn.commit();
           }
       catch(Exception e)
          {
             System.out.println(e);
             conn.rollback();
          }
}

/*对数据记录进行更改操作*/
public void updateRecord() throws SQLException,java.io.UnsupportedEncodingException
{
           try
              {
               PreparedStatement update_stm=conn.prepareStatement(query_statement);
              if (param!=null)
              for (int i=0;i<param.length;i++)
              update_stm.setString(i+1,param);
              update_stm.executeUpdate();
              update_stm.close();
              conn.commit();
              }
             catch(Exception e)
             {
              System.out.println(e);
               conn.rollback();
             }
}
/*删除数据记录*/
public void deleteRecord() throws SQLException,java.io.UnsupportedEncodingException
{
     try
       {
          PreparedStatement delete_stm=conn.prepareStatement(query_statement);
          if (param!=null)
           for (int i=0;i<param.length;i++)
           delete_stm.setString(i+1,param);
            delete_stm.executeUpdate();
            delete_stm.close();
            conn.commit();
       }
    catch(Exception e)
        {
          System.out.println(e);
            conn.rollback();
        }
}
}