review_bean.java

FAQ管理全源代码

package faq_project;

import java.sql.*;
import java.util.*;

public class review_Bean {
  private Connection con;
  private ResultSet rs, r;
  private Statement stmt;
  private String question;

  public review_Bean() throws Exception {
    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    DriverManager.setLoginTimeout(3);
    con = DriverManager.getConnection("jdbc:odbc:asdf", "sa", "");
    stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
                               ResultSet.CONCUR_UPDATABLE);
  }

  public void setQuestion(String id) throws Exception {
    this.question = question;
    rs = stmt.executeQuery("SELECT * FROM review where id=" + id);
  }

  public void addrevied(String id, String user, String title) throws Exception {
    stmt.executeUpdate("Insert into review values(" + id + ",'" + user + "','" +
                       title + "')");
  }

  public boolean user(String user, String password) throws Exception {
    rs = stmt.executeQuery(
        "SELECT COUNT(*) AS eee FROM [user] WHERE (password = '" + password +
        "') AND ([user] = '" + user + "')");
    rs.next();
    if (rs.getInt(1) == 1) {
      return true;
    }
    else {
      return false;
    }
  }

  public List getLists() throws Exception {
    List lst = new ArrayList();
    lst.add(rs.getString(2));
    lst.add(rs.getString(3));
    return lst;
  }

  public boolean next() throws Exception {
    if (rs.next()) {
      return true;
    }
    else {
      return false;
    }
  }

}