dbbean.java~7~

外挂制作教程,vb编写和WPE使用教程. (2008-- 外挂8。0破解版

package login;
import java.sql.*;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.*;

public class DBBean {
    private Connection con=null;
    private PreparedStatement pstmt=null;
    private ResultSet rs=null;
    private String loginname=null;
    private String username=null;
    private String password=null;
    private int age=0;
    private String address=null;

    public DBBean() {
    }

    public void setLoginname(String loginname) {
        this.loginname = loginname;
    }

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

    public void setPassword(String password) {
        this.password = password;
    }

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

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

    public String getLoginname() {
        return loginname;
    }

    public String getUsername() {
        return username;
    }

    public String getPassword() {
        return password;
    }

    public int getAge() {
        return age;
    }

    public String getAddress() {
        return address;
    }
    //连接数据库
 public void getConnection(){
    try {
        Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
        con = DriverManager.getConnection("Jdbc:Odbc:LocalServer", "sa", "");
    } catch (Exception ex) {
        ex.printStackTrace();
    }
   
 }
 //关闭连接
    public void closeConnection(){
        try {
            if (rs != null) {
                rs.close();
                rs = null;
            }
            if (pstmt != null) {
                pstmt.close();
                pstmt = null;
            }
            if (con != null) {
                con.close();
                con = null;
            }
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
    }
    //查询用户的方法
    public List getAll(){
        List list=new ArrayList();
        //获取连接
        getConnection();
           pstmt = con.prepareStatement( "select * from UserInfo where LoginName=? and PassWord=?");
           rs=pstmt.executeQuery();
           while(rs.next()){
               DBBean db=new DBBean();
               db.setLoginname(rs.getString(1));
               db.setPassword(rs.getString(2));
               list.add(db);
           }

        
//        try {
//            getConnection();
//            pstmt = con.prepareStatement(
//                    "select * from UserInfo where LoginName=? and PassWord=?");
//            pstmt.setString(1, this.getLoginname());
//            pstmt.setString(2, this.getPassword());
//            rs = pstmt.executeQuery();
//            boolean flag = rs.next();
//            if (flag) {
//                System.out.println("登陆成功");
//            } else {
//                System.out.println("登陆失败 ");
//            }
//        } catch (SQLException ex) {
//        }

        return list;
    }


}