loginfunc.java~9~

c++通信编程学习1

package com.j2ee.func.login;
//import com.app.function.*;

public class Loginfunc{
        //若为多个视图类，在此生成实例，并完成构造函数处理
        Logininfo logininfo = new Logininfo();
        String sqlstr = "";
        //默认构造函数：对应的初始化参数为视图类
public Loginfunc(Logininfo login) {
            this.logininfo = login;
        }

        //生成标准SQL语句
private String produceSQL() {
            if(logininfo.getusertype().equals("0"))
                sqlstr = "select id from usergrhy where username='" + logininfo.getname() +
                     "' and password= '" + logininfo.getpassword()+"'";
        if(logininfo.getusertype().equals("1"))
            sqlstr = "select id from company where admin='" + logininfo.getname() +
                 "'  and password= '" +logininfo.getpassword() + "'";
        return sqlstr;

        }

    //判断是否是正确用户,是否登录成功
    public boolean isloginAccess() {
        boolean islogin = false;
        String sqlstr = produceSQL();
        Loginbean loginbean = new Loginbean();
        islogin = loginbean.isloginSuccess(sqlstr);
     //   this.dex = loginbean.dex;
        return islogin;
    }
}
    //得到当前登录用户的基本信息
    //public int getFlag(ViewLogin viewlogin) {
 //       DBLoginBean dbloginBean = new DBLoginBean();
 //       if(viewlogin.getUsertype().equals("company"))
 //           sqlstr="select flag from company where admin='"+viewlogin.getUsername()+"'";
 //       else
 //           sqlstr="select flag from username where username='"+viewlogin.getUsername()+"'";
 //       int flag = dbloginBean.getFlag(sqlstr);
 //       this.dex = dbloginBean.dex;
 //       return flag;

    //得到当前登录用户的基本信息
  /*  public ViewLogin getLoginInfo(ViewLogin vlogin) {
        DBLoginBean dbloginBean = new DBLoginBean();
        ViewLogin viewlogin=new ViewLogin();
        viewlogin = dbloginBean.getLoginInfo(vlogin);
        this.dex = dbloginBean.dex;
        return viewlogin;
    }
    public boolean updateuserip(ViewLogin viewlogin){
        boolean bsuc=false;
        DBLoginBean dbloginBean = new DBLoginBean();
        if(viewlogin.getUsertype().equals("company"))
            sqlstr="update company set user_ip='"+viewlogin.getUserip()+"',logintime=now() where admin='"+viewlogin.getUsername()+"'";
        else
            sqlstr="update username set userlastip='"+viewlogin.getUserip()+"',logintime=now() where username='"+viewlogin.getUsername()+"'";
        bsuc = dbloginBean.update(sqlstr);
        this.dex = dbloginBean.dex;
        return bsuc;
    }
}*/