usermgr.java

java阿里巴巴代码

/*
 * Created on 2005-5-9
 *
 * To change the template for this generated file go to
 * Window>Preferences>Java>Code Generation>Code and Comments
 */
package com.ahbay.UserMgr;
import java.sql.*;
import java.util.*;
import org.apache.struts.action.Action;
import com.ahbay.commenMgr.*;
/**
 * @author 王仁超
 *
 * To change the template for this generated type comment go to
 * Window>Preferences>Java>Code Generation>Code and Comments
 */
public class UserMgr  extends Action
{
	public UserMgr () {}
		
	private String staffId;
	private String staffName;
	private String staffLevel;
	private String staffPwd;
	private String caseid;
	private String contractId;
	public String GetContractId() 
	{		
		return contractId;
	}	
	public String GetCaseid() 
	{		
		return caseid;
	}
	public String GetStaffId() 
	{		
		return staffId;
	}
	public String GetStaffName()
	{	
		return staffName;
	}
	public String GetStaffLevel() 
	{		
		return staffLevel;
	}
	public String GetStaffPwd() 
	{		
		return staffPwd;
	}
	public void setContractId (String contractId ){this.contractId =contractId ;}
	public void setCaseid (String caseid ){this.caseid =caseid ;}
	
	public void setStaffId (String staffId ){this.staffId =staffId ;}
	public void setStaffName (String staffName ){this.staffName =staffName ;}
	public void setStaffLevel(String staffLevel ){this.staffLevel=staffLevel;}
	public void setStaffPwd (String staffPwd ){this.staffPwd =staffPwd ;}
	DataBaseCommMgr DBQuery = new DataBaseCommMgr();
	commMethodMgr comm = new commMethodMgr();
	

	public UserMgr GetUserInfo() 
	{	
		String sql = "";
		String result = "0";
		int i = 0;
		sql="select * from czyxxb where czygh='"+this.staffId+"' and mm='"+this.staffPwd+"'"; 
		ResultSet rst = null;	
		UserMgr userinfo = new UserMgr();
		DBQuery.setStrQuery(sql);
		rst = DBQuery.SelBizQuery();
		try
		{			
			while(rst.next())
			{					
				userinfo.setStaffId(comm.convetStrToWeb(rst.getString("czygh")));
				userinfo.setStaffName(comm.convetStrToWeb(rst.getString("czymc")));
				userinfo.setStaffLevel(comm.convetStrToWeb(rst.getString("czyjb")));
				userinfo.setStaffPwd(comm.convetStrToWeb(rst.getString("mm")));				
			}
		}
		catch (Exception e)
		{		
			System.out.println("ERROR:"+e.getMessage());		
		}	 
		
		DBQuery.CloseConn();	
		return userinfo;	 			  	   
	}

	/**
	 * 
	 * @author: Wangrc
	 * @Date: 2006-6-28 20:43:48
	 * @Method Name: GetUserList
	 */
	public ArrayList GetUserList(String X_tag)
	{
		String sql = "";
		if (X_tag.equalsIgnoreCase("SEL_BY_DEPART"))
		{
			sql="";
		}
		else if (X_tag.equalsIgnoreCase("SEL_BY_CASE"))
		{
			sql="select * from czyxxb a where a.czygh!='"+this.staffId+"' and a.czygh not in " +
				"(select b.staff_id from workstaffinfo b where b.case_id='"+this.caseid+"' and b.remove_tag='0')";
		}
		else if (X_tag.equalsIgnoreCase("SEL_BY_ALL"))
		{
			sql="select * from czyxxb";
		}
		else
		{
			sql="select * from czyxxb where czygh='"+this.staffId+"'";
		}
		
		ResultSet rst = null;
		ArrayList UserList = new ArrayList();	
		
		DBQuery.setStrQuery(sql);
		rst = DBQuery.SelBizQuery();
		try
		{
			while (rst.next())
			{
				UserMgr userinfo = new UserMgr();	
				userinfo.setStaffId(comm.convetStrToWeb(rst.getString("czygh")));
				userinfo.setStaffName(comm.convetStrToWeb(rst.getString("czymc")));
				userinfo.setStaffLevel(comm.convetStrToWeb(rst.getString("czyjb")));
				userinfo.setStaffPwd(comm.convetStrToWeb(rst.getString("mm")));
				UserList.add(userinfo);	
			}
		}
		catch (Exception e)
		{	 	
		}
		DBQuery.CloseConn();
		return UserList;				
	}
	
	/**
	 * 
	 * @author: Wangrc
	 * @Date: 2006-6-9 14:33:58
	 * @Method Name:GetList
	 */
	public UserMgr[] GetList (ArrayList ParaItem) 
	{
		UserMgr[] ItemList=new UserMgr[ParaItem.size()];
		for(int i=0;i<ParaItem.size();i++)
		{ 
			UserMgr Item=(UserMgr)ParaItem.get(i); 
			ItemList[i]=Item; 
		}
		return ItemList;
	}
}