谁知道jsp+bean对数据库增删改查的通用做法

[tyrones]

数据库不限，但应该都是MYSQL AND ORACLE的吧

查询了一些资料，感觉页面代码太复杂

[Smilings]

把下面代码放进WEB-INF/classes中
这是一个连接数据库的bean，你可以通过调用这个bean来访问数据库。

import java.sql.*;
public class conn
{
String sDBDriver="oracle.jdbc.driver.OracleDriver";
String sConnStr="jdbc:odbc:db";
private Connection connect = null;
private Statement stmt = null;
ResultSet rs = null;
public conn()
{
try
{
Class.forName(sDBDriver);
}
catch(java.lang.ClassNotFoundException e)
{
System.err.println("error occured here:"+ e.getMessage());
}
try{
connect = DriverManager.getConnection(sConnStr, "system", "manager");
}
catch(SQLException ex){
System.err.println("执行SQL语句出错: " + ex.getMessage());
}
}
//执行Select语句
public ResultSet executeQuery(String sql)
{
rs = null;
try
{
stmt = connect.createStatement();
rs = stmt.executeQuery(sql);
}
catch(SQLException ex)
{
System.err.println(ex.getMessage());
}
return rs;
}
//执行Insert,Update,Delete语句
public void executeUpdate(String sql)
{
try
{
stmt = connect.createStatement();
stmt.executeUpdate(sql);
stmt.close();
}
catch(SQLException ex)
{
System.err.println("执行SQL语句出错: " + ex.getMessage());
}
}
public void closeStmt(){
try
{
stmt.close();
}
catch(SQLException e)
{
e.printStackTrace();
}
}

public void closeConn(){
try
{
connect.close();
}
catch(SQLException e)
{
e.printStackTrace();
}
}
}