dbconnection.java~21~

来自「外挂制作教程,vb编写和WPE使用教程. (2008-- 外挂8。0破解版」· JAVA~21~ 代码 · 共 89 行

package login;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.ResultSet;
import java.util.List;
import java.util.ArrayList;

public class DBConnection {
    private String LoginName;
    private String username;
    private String PassWord;
    private int Age;
    private String Address;

   Connection con=null;
   PreparedStatement pstmt;

   public DBConnection (){
   }
    public String getLoginName() {
        return LoginName;
    }

    public void setLoginName(String LoginName) {
        this.LoginName = LoginName;
    }

    public void setUsername(String username) {
        this.username = username;
    }

    public void setAddress(String Address) {
        this.Address = Address;
    }

    public void setAge(int Age) {
        this.Age = Age;
    }

    public void setPassWord(String PassWord) {
        this.PassWord = PassWord;
    }

    public String getUsername() {
        return username;
    }

    public String getAddress() {
        return Address;
    }

    public int getAge() {
        return Age;
    }

    public String getPassWord() {
        return PassWord;
    }

    public List sqlvalidate(DBConnection db) throws SQLException {
         List list = new ArrayList();
        try {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            con = DriverManager.getConnection("Jdbc:Odbc:test", "sa", "");
            String strSql="select * from UserInfo where LoginName=? and PassWord=?";
            pstmt=con.prepareStatement(strSql);
            pstmt.setString(1,getLoginName());
            pstmt.setString(2,getPassWord());
            ResultSet rs=pstmt.executeQuery();
            while(rs.next())
            {
               db.setLoginName(rs.getString("LoginName"));
               db.setUsername(rs.getString("username"));
               db.setPassWord(rs.getString("PassWord"));
               db.setAge(Integer.parseInt(rs.getString("Age")));
               db.setAddress(rs.getString("Address"));
               list.add(db);
            }
        } catch (ClassNotFoundException ex) {
            ex.printStackTrace();
        }
       return list;
    }

}