sqlbean.java

一个jsp开发的基本连接数据库的范例

package database;
  import java.sql.*;
  public class sqlbean
{
  public String query_statement;
  public ResultSet result=null;
  public Connection conn;

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);
result=select_stm.executeQuery();
}
catch(Exception e)
{
  System.out.println(e);
}
return result;
}
}