txunbean.java

“JSP数据库项目案例导航”一书从第一章到第十一章各章实例的源程序文件以及数据库文件。 注意： 1. 本书中的案例提供的数据库环境不同

	package oa.bean;

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

	public class TxunBean extends  ParentBean
	{
	  String strPersonNo = "-1";
	   int  intDelType = -1;
	  String strOrderNo = "-1";
	//构造函数
	public TxunBean() 
	{
	}

	//设置职工编号
	public  void  setPersonNo(String d)
	{
		strPersonNo = d;
	}

	//设置联系人序号
	public  void  setOrderNo(String str)
	{
		 strOrderNo = str;
	}

	//取得个人通讯录表
	public  Vector getData()
	{
		Vector vect = new Vector();
		String sql = "";
		sql = "select * from ZZ_TXLB where zgbh='"+strPersonNo+"' order by ZGBH,LXRXH ";
		ResultSet rs = selectRecord(sql);
		Statement stmt = null;
		try{
			//取得列数和列名
			ResultSetMetaData  rsmd = rs.getMetaData();
			int cols = rsmd.getColumnCount();
			int rowno=0;
			while(rs.next())
			{
				rowno++;
				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);
			}
			vect.add(new Integer(rowno));
		}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();
		String sql = "";
		sql = "select * from ZZ_TXLB where lxrxh="+strOrderNo+" and ZGBH='"+strPersonNo+"'";
		ResultSet rs = selectRecord(sql);
		Statement stmt = null;
		try{
			ResultSetMetaData  rsmd = rs.getMetaData();
			int cols = rsmd.getColumnCount();
			while(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;
	}
	//取得某职工的通讯录的联系人最大序号+1
	public String getLXRNo()
	{
		String lxrNo="",maxNo = "0";
		int llxrNo = -1, lmaxNo = 0;

		String sql = "select LXRXH from ZZ_TXLB where ZGBH='"+strPersonNo+"'";
		ResultSet rs = selectRecord(sql);
		Statement stmt = null;
		try{
			while (rs.next()) //取得某职工的通讯录的联系人最大序号
			{ 
				lxrNo = ds.toString(rs.getString("LXRXH"));
				llxrNo = Integer.parseInt(lxrNo);
				if (llxrNo > lmaxNo) 
				{
					lmaxNo = llxrNo;
					maxNo = lxrNo;
				}
			}
		}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);}		
		}
		lxrNo = String.valueOf(lmaxNo+1);
		return lxrNo;	
	}

	//取得人员记录列表displayTxun.jsp排序用
	public Vector getData(String pxzd,boolean isdesc,String srchzd,String srchzdval,boolean isexact)
	{
		//pxzd按哪个字段排序；isdesc是否降序排列；srchzd按哪个字段搜索；isexact是否精确查询
		Vector vect = new Vector();
		String sql = "";
		sql = "select * from ZZ_TXLB where ZGBH='"+strPersonNo+"'";			
		if(!srchzd.equals(""))
		{
			if(isexact)
				sql = sql+" and "+srchzd+"='"+srchzdval+"'";
			if(!isexact)
				sql = sql+" and "+srchzd+" like '%"+srchzdval+"%'";
		}
		if(!pxzd.equals(""))
		{	
			sql = sql+" order by "+pxzd;
		}
		if(isdesc)
		{
			sql = sql+" DESC";
		}
		Hashtable ht = new Hashtable();
		ht.put("sql",sql);
		vect.add(ht);

		ResultSet rs = selectRecord(sql);
		int rowno=0;
		Statement stmt = null;
		try{
			//取得列数和列名
			ResultSetMetaData rsmd = rs.getMetaData();
			int cols = rsmd.getColumnCount();
			while(rs.next())
			{
				rowno++;
				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);}		
		}
		vect.add(new Integer(rowno));
		return vect;
	}
	//添加人员记录
	public int addPerson(Hashtable hash)
	{
		String strXH = ds.toString((String)hash.get("LXRXH"));
		String strXM = ds.toString((String)hash.get("LXRXM"));
		String strYD = ds.toString((String)hash.get("YDDH"));
		String strMAIL = ds.toString((String)hash.get("EMAIL"));
		String strBG = ds.toString((String)hash.get("BGDH"));
		String strDW = ds.toString((String)hash.get("GZDW"));
		String strDZ = ds.toString((String)hash.get("JTDZ"));
		Vector vect = new Vector();
		vect.add("ZZ_TXLB");
		vect.add(addVector("ZGBH",strPersonNo,"CHAR"));
		vect.add(addVector("LXRXH",strXH,"NUM"));
		vect.add(addVector("LXRXM",strXM,"CHAR"));
		vect.add(addVector("YDDH",strYD,"CHAR"));
		vect.add(addVector("EMAIL",strMAIL,"CHAR"));
		vect.add(addVector("BGDH",strBG,"CHAR"));
		vect.add(addVector("GZDW",strDW,"CHAR"));
		vect.add(addVector("JTDZ",strDZ,"CHAR"));
		
		return insertRecord(vect);
	}
	//修改人员记录
	public  int modPerson(Hashtable hash)
	{
		String strXM = ds.toString((String)hash.get("LXRXM"));
		String strYD = ds.toString((String)hash.get("YDDH"));
		String strMAIL = ds.toString((String)hash.get("EMAIL"));
		String strBG = ds.toString((String)hash.get("BGDH"));
		String strDW = ds.toString((String)hash.get("GZDW"));
		String strDZ = ds.toString((String)hash.get("JTDZ"));
		
		Vector vect = new Vector();
		vect.add("ZZ_TXLB");
		vect.add(addVector("LXRXM",strXM,"CHAR"));
		vect.add(addVector("YDDH",strYD,"CHAR"));
		vect.add(addVector("EMAIL",strMAIL,"CHAR"));
		vect.add(addVector("BGDH",strBG,"CHAR"));
		vect.add(addVector("GZDW",strDW,"CHAR"));
		vect.add(addVector("JTDZ",strDZ,"CHAR"));
		vect.add("ZGBH = '"+strPersonNo+"' and LXRXH ="+strOrderNo);
		return updateRecord(vect);
	}
	//删除人员记录
	public int delPerson()
   {
		String sql=""; 
		sql = "delete from ZZ_TXLB where ZGBH='"+strPersonNo+"' and LXRXH ="+strOrderNo;
		return deleteRecord(sql);
	}
	//删除多条记录
	public int delPerson(String ps){
		if(ps.equals(""))
			return 0;
		return deleteRecord("delete from ZZ_TXLB where ZGBH='"+strPersonNo+"' and LXRXH in("+ps+")");
	}
//清空通讯录记录
	public int clearRecord(){
		return deleteRecord("delete from ZZ_TXLB where ZGBH='"+strPersonNo+"'");
	}
//取得当前页面
	public Vector getOnePage(String sql,int page,int records)
	{
		return db.getOnePage(sql,page,records);
	}

/*	public static void main(String args[]) 
	{
		TxunBean mb = new TxunBean();
		mb.setPersonNo("1");
		mb.setOrderNo("10");

		String strXM = "xiaoliu";
		String strYD = "1234567";
		String strMAIL = "[e-mail]";
		String strBG = "8745631";
		String strDW = "河北";
		String strDZ = "留下";

		Hashtable hash= new Hashtable();
		hash.put("LXRXM",strXM);
		hash.put("YDDH",strYD);
		hash.put("EMAIL",strMAIL);
		hash.put("BGDH",strBG);
		hash.put("GZDW",strDW);
		hash.put("JTDZ",strDZ);
		
		
	}*/

}