javabean来实现与数据库的连接以及对数据库的增删改

我们在做jsp开发的时候，经常需要对数据库进行查询及增删改，而这些操作使用的又是非常频繁，因此，我写了一个javabean，来实现与数据库的连接以及对数据库的增删改。现在拿出来与大家共享，希望大家尊重作者的劳动，使用时保留作者信息以及版本信息等等，谢谢！ 

 来源：Matrix    作者：chris

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(); 
} 
} 
}