administratorobj.java

java课程的资料以及实验的代码

package com.hesj.mod;

import java.sql.*;
import com.hesj.db.*;

public class AdministratorOBJ implements java.io.Serializable{
	private String strUserName;
	private String strPassWord;
	
	public AdministratorOBJ(){
	}
	
	public AdministratorOBJ(String user,String pass){
		this.strUserName=user;
		this.strPassWord=pass;
	}
	
	public  void setUserName(String user){
		this.strUserName=user;
	}
	
	public  String getUserName(){
		return this.strUserName;
	}
	
	public  void setPassWord(String pass){
		this.strPassWord=pass;
	}
	
	public  String getPassWord(){
		return this.strPassWord;
	}
	
	public static AdministratorOBJ  findAdministrator(String user,String pass){
		AdministratorOBJ admin=null;
		try{
			String sql="select Admin_name from Tbl_Admin where Admin_name='"+user
						+"' and Admin_pwd='"+pass+"'";
			DBAccess dba=new DBAccess();
			dba.open();
			ResultSet rs=dba.sqlQuery(sql);
			if(rs.next() && rs.getString("Admin_name").equals(user)){
				admin=new AdministratorOBJ(user,pass);
			}
			dba.close();
		}catch(SQLException ex){
			System.out.println(ex.getMessage());
		}finally{
			return admin;
		}
	}
}