loginbean.java~1~

c++通信编程学习1

package com.j2ee.func.login;
import com.j2ee.database.*;
import java.sql.*;
public class Loginbean extends J2eeDBbean {
    public Loginbean() {
    }
    //是否登录成功？
    //参数：输入为用户名和密码，输出为布尔型
    public boolean isloginSuccess(String sqlstr) {
        Loginbean db = new Loginbean();
        boolean islogin = false;
        islogin = db.isExitInDB(sqlstr);
        this.dex = db.dex;
        db.closeDB();
        return islogin;
    }
    //获取当前登录用户的基本信息
    public int getFlag(String sqlstr) {
        DBLoginBean db = new DBLoginBean();
        ViewLogin viewlogin = new ViewLogin();
        int flag=-1;
        try {
            db.researchDB(sqlstr);
            while (db.rs.next()) {
                flag=db.rs.getInt("flag");
            }
        } catch (SQLException ex) {
            //日志处理
            this.dex = ex;
            db.closeDB();
            return 0;
        }
        this.dex = db.dex;
        db.closeDB();
        return flag;
    }
    //获取当前登录用户的基本信息
    public ViewLogin getLoginInfo(ViewLogin vlogin) {
        DBLoginBean db = new DBLoginBean();
        ViewLogin viewlogin = new ViewLogin();
        String sqlstr=new String();
        if(vlogin.getUsertype().equals("company"))
            sqlstr="select * from company where admin='"+vlogin.getUsername()+"'";
        else
            sqlstr="select * from username where username='"+vlogin.getUsername()+"'";
        int flag=-1;
        try {
            db.researchDB(sqlstr);
            if (db.rs.next()) {
                if(vlogin.getUsertype().equals("company")){
                    viewlogin.setId(db.rs.getInt("id"));
                    viewlogin.setFlag(db.rs.getInt("flag"));
                    viewlogin.setUserip(db.rs.getString("user_ip"));
                    viewlogin.setUsername(db.rs.getString("admin"));
                    viewlogin.setCompanyname(db.rs.getString("companyname"));
                    viewlogin.setSendtime(db.rs.getTimestamp("sendtime"));
                    viewlogin.setUsertype(vlogin.getUsertype());
                }else{
                    viewlogin.setId(db.rs.getInt("id"));
                    viewlogin.setFlag(db.rs.getInt("flag"));
                    viewlogin.setUserip(db.rs.getString("userlastip"));
                    viewlogin.setUsername(db.rs.getString("username"));
                    viewlogin.setTruename(db.rs.getString("truename"));
                    viewlogin.setSendtime(db.rs.getTimestamp("sendtime"));
                    viewlogin.setUsertype(vlogin.getUsertype());

                }
            }
        } catch (SQLException ex) {
            //日志处理
            this.dex = ex;
            db.closeDB();
            return null;
        }
        this.dex = db.dex;
        db.closeDB();
        return viewlogin;
    }

}