sqlbean.java~3~

system1为用户注册模块 system2为在线聊天系统 system3为在线投票系统 system4为在线考试系统 system5为新闻发布模块

package database;
import java.sql.*;
public class sqlbean
{
  public String query_statement; /*定义sql语句*/
  public ResultSet result=null; /*查询结果*/
  public Connection conn;

  //设置SQL查询语句
  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;
  }
    }