利用javabean实现对数据库的连接

       我们在做jsp开发的时候，经常需要对数据库进行查询及增删改，而这些操作使用的又是非常频繁，因此，我写了一个javabean，来实现与数据库的连接以及对数据库的增删改。现在拿出来与大家共享，希望大家尊重作者的劳动，使用时保留作者信息以及版本信息等等，谢谢！ QueryBean.java: pacakage operate_db; /**  * Title:        select insert update and delete  * Description:  select insert update and delete  * Copyright:    Copyright (c) 2001  * @author Lci21  * @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[i]);             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[i]);             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[i]);                 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[i]);                 delete_stm.executeUpdate();                 delete_stm.close();                 conn.commit();             }             catch(Exception e)             {                 System.out.println(e);                 conn.rollback();             }         }     } 来源:http://www.daima.com.cn/Info/55/Info15729/