review_bean.java~26~

FAQ管理全源代码,可以实现一般的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{
    try{
      rs = stmt.executeQuery(
          "SELECT COUNT(*) AS eee FROM [user] WHERE (password = '" + password +
          "') AND ([user] = '" + user + "')");
      rs.next();
    }catch(Exception e){System.out.println("errorerror");}
    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;
    }
  }

}