?? userbean.java

?? 在系統開發過程中用到了javabean和jsp技術
?? JAVA
字號:
/**********************************************************
Version 1.0
Date:2003-10-22
Description:主頁－－主頁管理中的用戶列表查詢、單條信息查詢、增加記錄、修改記錄、刪除記錄
Other:
Variable List:
1.String id = "-1"//記錄唯一編號
2.String username = ""//用戶名，唯一識別號

Function List:
1.public void setUserName(String i)//設置記錄唯一編號

2.public Vector getData()//取得數據表內容

3.public Hashtable getOneData()//取得當前某一用戶信息

4.public int addUser(Hashtable hash)//增加管理員用戶
5.public int modUser(Hashtable hash)//修改用戶信息
6.public int modRight(Hashtable hash)//修改權限
7.public void delData()//刪除數據記錄
8.public Vector getYHM()//取得注冊但不是管理員的用戶名
9.public boolean verifyPwd(String pwd)
10.public int changePwd(Hashtable hash);
11.public String getOrg(String id);//根據人員的編號取得所在部門

History:
***********************************************************/

package oa.bean;

import java.text.*;
import java.util.*;
import java.lang.*;
import java.io.*;
import java.sql.*;
import oa.main.*;


public class UserBean extends ParentBean 
{	
	String username = "";
	String userid = "";

	//設置記錄唯一編號
	public void setUserName(String u)
	{
		username = u;
	}

	public void setUserId(String id)
	{
		userid = id;
	}


	//取得數據表內容
	public Vector getData()
	{
		Vector vect = new Vector();
		String sql = "";
		int intGLYH = 0;
		sql = " select * from news.ZZ_ZGB";

		ResultSet rs = selectRecord(sql);
		Statement stmt = null;
		try{
		//取得列數和列名
		ResultSetMetaData rsmd = rs.getMetaData();
		int cols = rsmd.getColumnCount();
		while(rs.next())
		{	
			Hashtable hash = new Hashtable();
			for(int i=1;i<=cols;i++)
			{
				String field = ds.toString(rsmd.getColumnName(i));
				String value = ds.toString(rs.getString(i));
				hash.put(field,value);
			}
			vect.add(hash);
		}
		}catch(Exception e){System.out.println("運行時出錯："+e);}
		finally{
			if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("關閉記錄集rs時出錯"+e);}
			if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("關閉聲明時statement出錯"+e);}		
		}
		return vect;
	}


	//取得當前某一用戶信息
	public Hashtable getOneData()
	{
		Hashtable hash = new Hashtable();
		int intGLYH = 0;
		String sql = "";

		sql = " select * from news.ZZ_ZGB where ZGBH = '"+userid+"'";

		ResultSet rs = selectRecord(sql);
		Statement stmt = null;
		try{
			ResultSetMetaData rsmd = rs.getMetaData();
			int cols = rsmd.getColumnCount();
			if (rs.next())
			{
				for(int i=1;i<=cols;i++)
				{
					String field = ds.toString(rsmd.getColumnName(i));
					String value = ds.toString(rs.getString(i));
					hash.put(field,value);
				}
			}
		}catch(Exception e){System.out.println("運行時出錯："+e);}
		finally{
			if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("關閉記錄集rs時出錯"+e);}
			if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("關閉聲明時statement出錯"+e);}		
		}
		return hash;
	}


	//增加管理員用戶
	public int addUser(Hashtable hash)
	{
		int intGLYH = 0;
		String strpersonNo= getMaxzgNo();
		String strOrgNo = ds.toString((String)hash.get("BMBH"));
		String strYHM = ds.toString((String)hash.get("YHM"));
		
		String strMM = ds.toString((String)hash.get("MM"));
		String strXM = ds.toString((String)hash.get("XM"));
		String strXB = ds.toString((String)hash.get("XB"));
		String strQX = ds.toString((String)hash.get("QX"));
		String strCSNY = ds.toString((String)hash.get("CSNY"));
		String stremail = ds.toString((String)hash.get("EMAIL"));
		String strYDDH = ds.toString((String)hash.get("YDDH"));
		String strQQ = ds.toString((String)hash.get("QQ"));

		String strJTDZ = ds.toString((String)hash.get("JTDZ"));
		String stYZBM = ds.toString((String)hash.get("YZBM"));

		String strGRJJ = ds.toString((String)hash.get("GRJJ"));
		//String strFBWZ = ds.toString((String)hash.get("FBWZ"));

		Vector vect =new Vector();
		vect.add("ZZ_ZGB");
		vect.add(addVector("BMBH",strOrgNo,"CHAR"));
		vect.add(addVector("ZGBH",strpersonNo,"CHAR"));
		vect.add(addVector("YHM",strYHM,"CHAR"));
		vect.add(addVector("MM",strMM,"CHAR"));

		vect.add(addVector("XM",strXM,"CHAR"));
		vect.add(addVector("XB",strXB,"CHAR"));
		vect.add(addVector("CSNY",strCSNY,"CHAR"));
		vect.add(addVector("YZBM",stYZBM,"CHAR"));

		vect.add(addVector("QQ",strQQ,"CHAR"));
		vect.add(addVector("JTDZ",strJTDZ,"CHAR"));
		vect.add(addVector("YDDH",strYDDH,"CHAR"));
		vect.add(addVector("EMAIl",stremail,"CHAR"));
		//vect.add(addVector("DJGL",strDJGL,"CHAR"));
		vect.add(addVector("QX",strQX,"CHAR"));
 		vect.add(addVector("GRJJ",strGRJJ,"CHAR"));
		String time=ds.getDateTime();
		time=time.substring(0,10);
    	vect.add(addVector("ZCRQ",time,"CHAR"));
   
		vect.add(addVector("GLYH",String.valueOf(intGLYH),"NUM"));
		vect.add(addVector("ZZZT",String.valueOf(intGLYH),"NUM"));

	  
	    //vect.add("YHM='"+username+"'");
		ResultSet rs = selectRecord("select YHM from news.ZZ_ZGB where YHM='"+strYHM+"'");
		Statement stmt = null;
		try{
			if(rs.next())
				return 1;
		}catch(Exception e){System.out.println("運行時出錯："+e);}
		finally{
			if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("關閉記錄集rs時出錯"+e);}
			if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("關閉聲明時statement出錯"+e);}		
		}
		return insertRecord(vect);
	}




	//修改用戶信息
	public int modUser(Hashtable hash) 
	{

		String strYHM = ds.toString((String)hash.get("YHM"));
		//String strMM= ds.toString((String)hash.get("MM"));

		String strXM = ds.toString((String)hash.get("XM"));
		String strXB = ds.toString((String)hash.get("XB"));
		String strCSNY = ds.toString((String)hash.get("CSNY"));
		String stremail = ds.toString((String)hash.get("EMAIL"));
		String strYDDH = ds.toString((String)hash.get("YDDH"));

		String strQQ = ds.toString((String)hash.get("QQ"));
		String stYZBM = ds.toString((String)hash.get("YZBM"));
		String strJTDZ = ds.toString((String)hash.get("JTDZ"));
		String strGRJJ = ds.toString((String)hash.get("GRJJ"));

		Vector vect =new Vector();
		vect.add("ZZ_ZGB");
		vect.add(addVector("YHM",strYHM,"CHAR"));
		//vect.add(addVector("MM",strMM,"CHAR"));

		vect.add(addVector("XM",strXM,"CHAR"));
		vect.add(addVector("XB",strXB,"CHAR"));
		vect.add(addVector("CSNY",strCSNY,"CHAR"));
		vect.add(addVector("QQ",strQQ,"CHAR"));
		vect.add(addVector("YZBM",stYZBM,"CHAR"));
		vect.add(addVector("JTDZ",strJTDZ,"CHAR"));
		vect.add(addVector("YDDH",strYDDH,"CHAR"));
		vect.add(addVector("EMAIL",stremail,"CHAR"));
 		vect.add(addVector("GRJJ",strGRJJ,"CHAR"));

	    vect.add("ZGBH='"+userid+"'");
		//ResultSet rs = selectRecord("select YHM from news.ZZ_ZGB where YHM='"+username+"'");
		return updateRecord(vect);
	}

	//修改權限
	public int modRight(Hashtable hash)
	{
		String sql = "";
		String strQX = ds.toString((String)hash.get("QX"));	

		Vector vect =new Vector();
		vect.add("ZZ_ZGB");
		vect.add(addVector("QX",strQX,"CHAR"));
	    vect.add("ZGBH = '"+userid+"'");

		return updateRecord(vect);
	}

	//取得注冊但不是管理員的用戶名
	public Vector getYHM()
	{
		Vector vect = new Vector();
		String sql = "";
		int i = 0;
		int intGLYH = 0;

		sql = "select YHM from news.ZZ_ZGB where YHM is not null and GLYH!=0";
		ResultSet rs = selectRecord(sql);
		Statement stmt = null;
		try{
			while(rs.next())
			{	
				Hashtable hash = new Hashtable();
				String field = ds.toString(String.valueOf(i));
				String value = ds.toString(rs.getString("YHM"));
				hash.put(field,value);
				vect.add(hash);
				i++;
			}
		}catch(Exception e){System.out.println("運行時出錯："+e);}
		finally{
			if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("關閉記錄集rs時出錯"+e);}
			if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("關閉聲明時statement出錯"+e);}		
		}
		return vect;
	}

	//刪除數據記錄
	public int delData()
	{
		int intGLYH = 1;
		String sql="";
		sql = "delete from news.ZZ_ZGB  where ZGBH = '"+userid+"'";
		return deleteRecord(sql);
	}

   //分頁時取得一頁的數據量
	public Vector getOnePage(int page,int records)
	{
		int intGLYH = 0;
		String sql = " select * from news.ZZ_ZGB";
		return db.getOnePage(sql,page,records);
	}

	//驗證人員秘密
	public boolean verifyPwd(String pwd)
	{
		String sql = "";
		sql = "select MM from news.ZZ_ZGB where YHM = '"+username.trim()+"'";
		ResultSet rs =selectRecord(sql);
		Statement stmt = null;
		try{
			if(rs.next())
			{
				String strPassword = ds.toString(rs.getString("MM"));
				if(strPassword.equals(pwd))
				{
					return true;
				}
			}
		}catch(Exception e){System.out.println("運行時出錯："+e);}
		finally{
			if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("關閉記錄集rs時出錯"+e);}
			if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("關閉聲明時statement出錯"+e);}		
		}
		return false;
	}

	//修改密碼
	public int changePwd(Hashtable hash)
	{
		String sql = "";
		String strQX = ds.toString((String)hash.get("MM"));	

		Vector vect =new Vector();
		vect.add("ZZ_ZGB");
		vect.add(addVector("MM",strQX,"CHAR"));
	    vect.add("YHM = '"+username+"'");

		return updateRecord(vect);
	}

	public String getMaxzgNo()//取得最大職工編號+1
	{
		String sql = "",zgNo="";
		long lzgNo=0,lmaxNo = 0;
		sql = " select ZGBH from news.ZZ_ZGB ";//where BMBH = '"+strOrgNO+"'"
		ResultSet rs = selectRecord(sql);
		Statement stmt = null;
		try{
		while(rs.next())
		{
			zgNo = ds.toString(rs.getString("ZGBH"));
			lzgNo = Long.parseLong(zgNo);
			if (lzgNo > lmaxNo) {
				lmaxNo = lzgNo;
				//maxNo = zgNo;
			}
		}
		}catch(Exception e){System.out.println("運行時出錯："+e);}
		finally{
			if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("關閉記錄集rs時出錯"+e);}
			if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("關閉聲明時statement出錯"+e);}		
		}
		lmaxNo = lmaxNo + 1;
		return String.valueOf(lmaxNo);
	}

	//根據人員的編號取得所在部門
	public String getOrg(String id)
	{
		String sql = "";
		String orgid = "";
		sql = "select BMBH from news.zz_zgb where ZGBH='"+id+"'";
		ResultSet rs = selectRecord(sql);
		Statement stmt = null;
		try{
			if(rs.next())
			{
				orgid = ds.toString(rs.getString("BMBH"));
			}
		}catch(Exception e){System.out.println("運行時出錯："+e);}
		finally{
			if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("關閉記錄集rs時出錯"+e);}
			if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("關閉聲明時statement出錯"+e);}		
		}
		return orgid;
	}

	public static void main(String args[]) 
	{
		UserBean mb = new UserBean();
		//mb.setUserName("xiaoyan");
		System.out.println("begin\r\n\r\n");
		Hashtable hash = new Hashtable();
		hash.put("XM","王八蛋");
		hash.put("XB","男");
		hash.put("MZ","蒙");
		hash.put("QQ","98765432");
		hash.put("MZ","蒙");
		hash.put("QQ","98765432");
		hash.put("YDDH","1310000000");
		hash.put("EMAIL","98765432@etang.com");
		hash.put("YDDH","1310000000");
		hash.put("email","98765432@etang.com");
		hash.put("QX","錄入員");
		hash.put("FBWZ","20");
		hash.put("GRJJ","我是個王八蛋");
		//mb.getYHM();
		//mb.delData();
		System.out.println(mb.getOnePage(1,10));

		System.out.println("\r\n\r\nend");
	}
}
?? 文件大小 11884 K
?? 上傳用戶 zhhw254774338
?? 所屬分類 Java編程
??? 相關標簽

#javabean #jsp #系統開發 #過程
?? 快捷鍵說明

復制代碼 Ctrl + C
搜索代碼 Ctrl + F
全屏模式 F11
切換主題 Ctrl + Shift + D
顯示快捷鍵 ?
增大字號 Ctrl + =
減小字號 Ctrl + -
亚洲欧美第一页_禁久久精品乱码_粉嫩av一区二区三区免费野_久草精品视频

?? userbean.java

?? 快捷鍵說明
