regiter_bean.java

FAQ管理全源代码

package faq_project;

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

public class regiter_Bean {
  private Connection con;
  private ResultSet rs;
  private Statement stmt;
  private PreparedStatement addstmt;

  //连接SQL
  public regiter_Bean() throws Exception {
    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    con = DriverManager.getConnection("jdbc:odbc:asdf", "sa", "");
    stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
                               ResultSet.CONCUR_UPDATABLE);
    addstmt = con.prepareStatement(
        "INSERT INTO users VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?)");

    rs = stmt.executeQuery("Select * from users");
  }

  public void flushName(String name) throws Exception {
    rs = stmt.executeQuery("Select * from users where username='" + name + "'");
  }

  //设置添加记录信息后提交
  public void commit() throws Exception {
    addstmt.executeUpdate();
  }
}