【Java开源代码栏目提醒】:网学会员为广大网友收集整理了,TxunBean.java,希望对大家有所帮助!
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{ st