review_bean.java~28~

来自「FAQ管理全源代码,可以实现一般的FAQ管理功能,界面简洁而明快,占用资源不大.」· JAVA~28~ 代码 · 共 62 行

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 {
    System.out.println("rs is OK");
    rs = stmt.executeQuery(
        "SELECT COUNT(*) AS eee FROM [user] WHERE (password = '" + password +
        "') AND ([user] = '" + user + "')");
    rs.next();
    System.out.println("true" + rs.getInt(1));
    if (rs.getInt(1) == 0) {
      return false;
    }
    else {
      return true;
    }
  }

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

}