logon.java

设备管理系统：三种管理员：普通员工、设备管理员、超级管理员。可进行设备添加删除维修等基本操作。运行此需要netbeans+sql2005

/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

package dba;

/**
 *
 * @author Sunyu
 */
import java.sql.*;
public class Logon {
	private String username;
	private String userpassword;
	private Checkstr check=new Checkstr();
	public Logon(){}
	public void setUsername(String username){
		this.username=check.dostring(username);
	}
	public String getUsername(){
		return this.username;
	}
	public void setUserpassword(String userpassword){
		this.userpassword=check.dostring(userpassword);
	}
	public String getUserpassword(){
		return this.userpassword;
	}
    public String checklogon(){
    	String backmess="";
    	boolean mark=true;
    	if(this.username.equals("")){
    		mark=false;
    		backmess+="<li>请输入<b>用户名！</b></li><br>";
    	}
    	if(this.userpassword.equals("")){
    		mark=false;
    		backmess+="<li>请输入<b>密&nbsp;&nbsp;码！</li></b>";
    	}
    	if(!mark){
    		return backmess;
    	}
    	String sql="select * from usertable where userName='"+this.username+"' and userps='"+this.userpassword+"'" +"and usersta='ma'";
    	DB db=new DB();
    	ResultSet rs=db.search(sql);
    	try{
    		if(rs.next()){
    			backmess="Hello!Manager!";
    		}
    		else {
                sql="select * from usertable where userName='"+this.username+"' and userps='"+this.userpassword+"'" +"and usersta='em'";
                DB db1=new DB();
    	        ResultSet rs1=db1.search(sql);
                  if(rs1.next()){
                   backmess="Hello!User!";
                  }
                  else{
                    sql="select * from usertable where userName='"+this.username+"' and userps='"+this.userpassword+"'" +"and usersta='sp'";
                      DB db2=new DB();
    	              ResultSet rs2=db2.search(sql);
                     if(rs2.next()){
                       backmess="Hello!Super!";
                       }
                     else
                          backmess="fail";
                  }
                      
 	  		}

    	}
    	catch(Exception e){
    		e.printStackTrace();
    		backmess="操作失败！";
    	}
    	db.closed();
    	return backmess;
    }
}