opendb.java

来自「本系统为六合彩网上投注系统」· Java 代码 · 共 48 行

package opendb;

import java.sql.*;
import sun.jdbc.odbc.JdbcOdbcDriver;
import java.sql.PreparedStatement;

public class opendb
{
  private final String url = "jdbc:mysql://localhost:3306/liuhecai";
  private String sql;
  private Connection conn;
  private Statement stmt;
  private PreparedStatement pstmt;
  protected ResultSet rs;

  public opendb()
  {
  }

  public String login(String username,String password) throws Exception
  {
    String status = null;
    sql = "select * from UserInfo where username='" + username + "'and password='" + password + "'";
    Class.forName("org.gjt.mm.mysql.Driver");
    conn = DriverManager.getConnection(url);
    stmt = conn.createStatement();
    rs = stmt.executeQuery(sql);
    if(rs.next())
    {
      status = "success";
      return status;
    }
    else
    {
      status = "error";
      return status;
    }
  }
  public ResultSet queryUser(String username) throws ClassNotFoundException,
      SQLException {
    String sql = "select * from UserInfo where username='" + username + "'";
    Class.forName("org.gjt.mm.mysql.Driver");
    conn = DriverManager.getConnection(url);
    stmt = conn.createStatement();
    ResultSet rs = stmt.executeQuery(sql);
    return rs;
  }
}