dbbean.java~5~

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

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=?");
        pstmt.setString(1,this.getLoginname());
        pstmt.setString(2,this.getPassword());
        rs=pstmt.executeQuery();
        boolean flag=rs.next();
 if(flag){
   out.println("登陆成功");
 }
 else{
   out.println("登陆失败 ");
 }

        return list;
    }


}