📄 personbean.java
字号:
String strMMWT = ds.toString((String)hash.get("MMWT"));
String strMMDA = ds.toString((String)hash.get("MMDA"));
String strMM = ds.toString((String)hash.get("MM"));
strMM =(new MD5()).toMD5(strMM);
String strXB = ds.toString((String)hash.get("XB"));
String strCSNY = ds.toString((String)hash.get("CSNY"));
String strMZ = ds.toString((String)hash.get("MZ"));
String strZZMM = ds.toString((String)hash.get("ZZMM"));
String strXL = ds.toString((String)hash.get("XL"));
String strZC = ds.toString((String)hash.get("ZC"));
String strQQ = ds.toString((String)hash.get("QQ"));
String strBGDH = ds.toString((String)hash.get("BGDH"));
String strFJDH = ds.toString((String)hash.get("FJDH"));
String strYZBM = ds.toString((String)hash.get("YZBM"));
String strJTDZ = ds.toString((String)hash.get("JTDZ"));
String strJTDH = ds.toString((String)hash.get("JTDH"));
String strYDDH = ds.toString((String)hash.get("YDDH"));
String stremail = ds.toString((String)hash.get("EMAIL"));
String strZZZT = ds.toString((String)hash.get("ZZZT"));
//
String strYHM = ds.toString((String)hash.get("YHM"));
String strZCRQ = ds.toString((String)hash.get("ZCRQ"));
// String strDJGL = ds.toString((String)hash.get("DJGL"));
// String strFBWZ = ds.toString((String)hash.get("FBWZ"));
// String strGLYH = ds.toString((String)hash.get("GLYH"));
String strGRJJ = ds.toString((String)hash.get("GRJJ"));
String strZNYH = ds.toString((String)hash.get("ZNYH"));
/*sql = "select * from ZZ_ZGB";
ResultSet rs = selectRecord(sql);
while (rs.next())
{
intPerson++;
}
intPerson++;
strZGBH = String.valueOf(intPerson);*/
Vector vect = new Vector();
vect.add("ZZ_ZGB");
vect.add(addVector("BMBH",strBMBH,"CHAR"));
vect.add(addVector("ZGBH",strZGBH,"CHAR"));
vect.add(addVector("XM",strXM,"CHAR"));
vect.add(addVector("GH",strGH,"CHAR"));
// vect.add(addVector("CZQX",strCZQX,"CHAR"));
// vect.add(addVector("LCQX",strLCQX,"CHAR"));
vect.add(addVector("PZCS",strPZCS,"CHAR"));
vect.add(addVector("MMWT",strMMWT,"CHAR"));
vect.add(addVector("MMDA",strMMDA,"CHAR"));
vect.add(addVector("MM",strMM,"CHAR"));
vect.add(addVector("XB",strXB,"CHAR"));
vect.add(addVector("CSNY",strCSNY,"CHAR"));
vect.add(addVector("MZ",strMZ,"CHAR"));
vect.add(addVector("ZZMM",strZZMM,"CHAR"));
vect.add(addVector("XL",strXL,"CHAR"));
vect.add(addVector("ZC",strZC,"CHAR"));
vect.add(addVector("QQ",strQQ,"CHAR"));
vect.add(addVector("BGDH",strBGDH,"CHAR"));
vect.add(addVector("FJDH",strFJDH,"CHAR"));
vect.add(addVector("YZBM",strYZBM,"CHAR"));
vect.add(addVector("JTDZ",strJTDZ,"CHAR"));
vect.add(addVector("JTDH",strJTDH,"CHAR"));
vect.add(addVector("YDDH",strYDDH,"CHAR"));
vect.add(addVector("EMAIL",stremail,"CHAR"));
vect.add(addVector("ZZZT",strZZZT,"NUM"));
vect.add(addVector("YHM",strYHM,"CHAR"));
vect.add(addVector("ZCRQ",strZCRQ,"CHAR"));
// vect.add(addVector("DJGL",strDJGL,"CHAR"));
// vect.add(addVector("FBWZ",strFBWZ,"NUM"));
// vect.add(addVector("GLYH",strGLYH,"NUM"));
vect.add(addVector("GRJJ",strGRJJ,"CHAR"));
vect.add(addVector("ZNYH",strZNYH,"NUM"));
////////////////
int jbxh=makeID("ZZ_ZGB","BMBH","ZZZT","JBXH",strBMBH,"0",false,true);
String jbNo=""+jbxh;
vect.add(addVector("JBXH",jbNo,"NUM"));
//检验工号是否已经存在
sql = "select GH from ZZ_ZGB where GH='"+strGH+"' and ZZZT=0";
ResultSet rs = selectRecord(sql);
Statement stmt = null;
try{
if(rs.next())
return 5;
else //检验用户名是否已经存在
{
sql = "select YHM from ZZ_ZGB where YHM='"+ strYHM + "'";// and ZZZT=0"; modified by 2004.12.24
stmt = rs.getStatement(); rs.close(); stmt.close();
rs = selectRecord(sql);
if(rs.next())
return 6;
}
}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 modPerson(Hashtable hash)
{
//String strBMBH = ds.toString((String)hash.get("BMBH"));
String strXM = ds.toString((String)hash.get("XM"));
String strGH = ds.toString((String)hash.get("GH"));
// String strCZQX = ds.toString((String)hash.get("CZQX"));
// String strLCQX = ds.toString((String)hash.get("LCQX"));
String strPZCS = ds.toString((String)hash.get("PZCS"));
String strMMWT = ds.toString((String)hash.get("MMWT"));
String strMMDA = ds.toString((String)hash.get("MMDA"));
String strMM = ds.toString((String)hash.get("MM"));
String strXB = ds.toString((String)hash.get("XB"));
String strCSNY = ds.toString((String)hash.get("CSNY"));
String strMZ = ds.toString((String)hash.get("MZ"));
String strZZMM = ds.toString((String)hash.get("ZZMM"));
String strXL = ds.toString((String)hash.get("XL"));
String strZC = ds.toString((String)hash.get("ZC"));
String strQQ = ds.toString((String)hash.get("QQ"));
String strBGDH = ds.toString((String)hash.get("BGDH"));
String strFJDH = ds.toString((String)hash.get("FJDH"));
String strYZBM = ds.toString((String)hash.get("YZBM"));
String strJTDZ = ds.toString((String)hash.get("JTDZ"));
String strJTDH = ds.toString((String)hash.get("JTDH"));
String strYDDH = ds.toString((String)hash.get("YDDH"));
String stremail = ds.toString((String)hash.get("EMAIL"));
String strZZZT = ds.toString((String)hash.get("ZZZT"));
//
String strYHM = ds.toString((String)hash.get("YHM"));
String strZCRQ = ds.toString((String)hash.get("ZCRQ"));
// String strDJGL = ds.toString((String)hash.get("DJGL"));
// String strFBWZ = ds.toString((String)hash.get("FBWZ"));
// String strGLYH = ds.toString((String)hash.get("GLYH"));
String strGRJJ = ds.toString((String)hash.get("GRJJ"));
String strJBXH = ds.toString((String)hash.get("JBXH"));
String strZNYH = ds.toString((String)hash.get("ZNYH"));
/////////////////////////////////////////////
String strBMNO=getBMBH();
ResultSet rs1 = selectRecord(
"select JBXH from ZZ_ZGB where BMBH='" + strBMNO +"' and ZGBH='"
+ strPersonNO + "' and ZZZT=0 and ZGBH <> '1'");
int yjbxh=999;
Statement stmt = null;
try{
if(rs1.next())
yjbxh=Integer.parseInt(rs1.getString("JBXH"));
}catch(Exception e){System.out.println("运行时出错："+e);}
finally{
if(rs1!=null)try{ stmt = rs1.getStatement(); rs1.close();}catch(Exception e){System.out.println("关闭记录集rs时出错"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("关闭声明时statement出错"+e);}
}
int jbxh=0;
int maxjbNo=makeID("ZZ_ZGB","BMBH","ZZZT","JBXH",strBMNO,"0",false,true);
if(!strJBXH.equals(""))
jbxh=Integer.parseInt(strJBXH);
if(strPersonNO.equals("1")) {//系统管理员,令其级别序号总为0
jbxh=0;strJBXH=""+jbxh;
}
else if(strBMNO.equals(ds.toString(strOrgNO)))//部门未改变,更新级别序号
{
if(jbxh==0||jbxh>=maxjbNo)
{ jbxh=maxjbNo-1;strJBXH=""+jbxh;}
if(jbxh < yjbxh){
String sql1="update ZZ_ZGB set JBXH=JBXH+1 where BMBH='"
+ strOrgNO
+ "' and ZZZT=0 and JBXH >="
+ jbxh
+ " and JBXH<"
+ yjbxh;
deleteRecord(sql1);
}
else if(jbxh > yjbxh && yjbxh!=0){
String sql2="update ZZ_ZGB set JBXH=JBXH-1 where BMBH='"
+ strOrgNO
+ "' and ZZZT=0 and JBXH <="
+ jbxh
+ " and JBXH>"
+ yjbxh;
deleteRecord(sql2);
}
}
else//部门发生改变,更新级别序号
{///修改原部门内人员级别序号
String sql3="update ZZ_ZGB set JBXH=JBXH-1 where BMBH='"
+ strBMNO
+ "' and ZZZT=0 and JBXH >"
+ yjbxh;
deleteRecord(sql3);
////修改新部门内人员级别序号
maxjbNo=makeID("ZZ_ZGB","BMBH","ZZZT","JBXH",strOrgNO,"0",false,true);
if(!strJBXH.equals(""))
jbxh=Integer.parseInt(strJBXH);
if(jbxh==0||jbxh>maxjbNo)
{ jbxh=maxjbNo;strJBXH=""+jbxh;}
String sql4="update ZZ_ZGB set JBXH=JBXH+1 where BMBH='"+ strOrgNO + "' and ZZZT=0 and JBXH >=" + jbxh ;
deleteRecord(sql4);
}
/////////////////////////////////////////////
Vector vect = new Vector();
vect.add("ZZ_ZGB");
vect.add(addVector("BMBH",strOrgNO,"CHAR"));
vect.add(addVector("XM",strXM,"CHAR"));
vect.add(addVector("GH",strGH,"CHAR"));
// vect.add(addVector("CZQX",strCZQX,"CHAR"));
// vect.add(addVector("LCQX",strLCQX,"CHAR"));
vect.add(addVector("PZCS",strPZCS,"CHAR"));
vect.add(addVector("MMWT",strMMWT,"CHAR"));
vect.add(addVector("MMDA",strMMDA,"CHAR"));
if(strMM!=null && !strMM.equals(""))
{
strMM = (new MD5()).toMD5(strMM);
vect.add(addVector("MM",strMM,"CHAR"));
}
vect.add(addVector("XB",strXB,"CHAR"));
vect.add(addVector("CSNY",strCSNY,"CHAR"));
vect.add(addVector("MZ",strMZ,"CHAR"));
vect.add(addVector("ZZMM",strZZMM,"CHAR"));
vect.add(addVector("XL",strXL,"CHAR"));
vect.add(addVector("ZC",strZC,"CHAR"));
vect.add(addVector("QQ",strQQ,"CHAR"));
vect.add(addVector("BGDH",strBGDH,"CHAR"));
vect.add(addVector("FJDH",strFJDH,"CHAR"));
vect.add(addVector("YZBM",strYZBM,"CHAR"));
vect.add(addVector("JTDZ",strJTDZ,"CHAR"));
vect.add(addVector("JTDH",strJTDH,"CHAR"));
vect.add(addVector("YDDH",strYDDH,"CHAR"));
vect.add(addVector("EMAIL",stremail,"CHAR"));
vect.add(addVector("ZZZT",strZZZT,"NUM"));
//
vect.add(addVector("YHM",strYHM,"CHAR"));
vect.add(addVector("ZCRQ",strZCRQ,"CHAR"));
// vect.add(addVector("DJGL",strDJGL,"CHAR"));
// vect.add(addVector("FBWZ",strFBWZ,"NUM"));
// vect.add(addVector("GLYH",strGLYH,"NUM"));
vect.add(addVector("GRJJ",strGRJJ,"CHAR"));
vect.add(addVector("JBXH",strJBXH,"NUM"));
vect.add(addVector("ZNYH",strZNYH,"NUM"));
vect.add("ZGBH = "+strPersonNO+"");
//检验工号是否已经存在
String sql = "select GH from ZZ_ZGB where GH='"+ strGH + "' and ZZZT=0 and ZGBH<>'"+ strPersonNO +"'";
ResultSet rs =selectRecord(sql);
try{
if (rs.next())
return 5;
else //检验用户名是否已经存在
{
stmt = rs.getStatement();rs.close();stmt.close();
sql = "select YHM from ZZ_ZGB where YHM='"+ strYHM + "' and ZZZT=0 and ZGBH<>'"+ strPersonNO +"'";
rs = selectRecord(sql);
if(rs.next())
return 6;
}
}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);}
}
updateRecord(vect);
return 0;
}
//删除当前人员数据记录
public int delPerson()
{
String sql="";
ResultSet rst = selectRecord("select JBXH from ZZ_ZGB where ZGBH='"
+ strPersonNO + "' and ZZZT=0");
Statement stmt = null;
int yjbxh=999;
try{
if(rst.next())
yjbxh=Integer.parseInt(rst.getString("JBXH"));
}catch(Exception e){System.out.println("运行时出错："+e);}
finally{
if(rst!=null)try{ stmt = rst.getStatement(); rst.close();}catch(Exception e){System.out.println("关闭记录集rs时出错"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("关闭声明时statement出错"+e);}
}
sql="update ZZ_ZGB set JBXH=JBXH-1 where BMBH='"
+ getBMBH()
+ "' and ZZZT=0 and JBXH >"
+ yjbxh;
//System.out.println(sql);
deleteRecord(sql);
sql = "update ZZ_ZGB set ZZZT = 3 where ZGBH = '"+strPersonNO+"'";
deleteRecord(sql);
sql = "delete from ZZ_ZGZWB where ZGBH = '"+strPersonNO+"'";
deleteRecord(sql);
sql = "delete from ZZ_FBXWB where ZGBH = '"+strPersonNO+"'";
return deleteRecord(sql);
}
public void delDBPs()//从数据库中永久删除离退休等人员信息
{
String sql="";
sql = "delete from ZZ_ZGB where ZGBH = '"+strPersonNO+"'";
deleteRecord(sql);
}
public void resumePs() //恢复挂起人员
{
String sql="";
sql = "update ZZ_ZGB set ZZZT=0,JBXH=1+(select JBXH) where ZGBH = '"+strPersonNO+"'";
//改变级别序号+1
sql = "update ZZ_ZGB set ZZZT=0,JBXH=(select max(JBXH)+1 from ZZ_ZGB where ZZZT=0 and BMBH=(select BMBH from ZZ_ZGB where ZGBH='"+strPersonNO+"')) where ZGBH='"+strPersonNO+"'";
deleteRecord(sql);
}
//取得当前职工在当前部门的操作权限
public String getOper()
{
String strOper = "";
String sql = "";
String strMRCZ = "1";
String strSYZT = "0";
String str1 = ",";
String str2 = "@";
String strBMBH = "";
String strZWBH = "";
String strMax = "";
int i,j;
sql = " select CZQX from ZZ_ZGZWB where ZGBH = '"+strPersonNO+"' ";
ResultSet rs = selectRecord(sql);
Statement stmt = null;
try{
while(rs.next())//在ZZ_ZGZWB表找此职工所有职务的权限
{
String strX = ds.toString(rs.getString(1));//取得某一职务的权限
if (!strX.equals(""))
{
strMax+=strX+str2;
}
}
}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);}
}
if(strMax.equals(""))//如果ZZ_ZGZWB中的操作权限为空,在ZZ_ZWB表找此职工所有职务的权限
{
sql = "select a.CZQX from ZZ_ZWB a,ZZ_ZGZWB b where ZGBH = '"+strPersonNO+"' and a.zwzt<>1 and a.BMBH = b.BMBH and a.ZWBH = b.ZWBH ";
rs = selectRecord(sql);
try{
while(rs.next())//把此职工的所有职务的权限用（@）分割存储
{
String strX = ds.toString(rs.getString(1));//取得某一职务的权限
if (!strX.equals(""))
{
strMax+=strX+str2;
}
}
}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);}
}
if(strMax.equals(""))//判断是否启用默认权限，空则用默认权限
{
sql = "select ID from CODE_ANCZQXB where MRCZ = "+strMRCZ+" and SYZT = "+strSYZT+"";
ResultSet r = selectRecord(sql);
try{
while(r.next())
{
strOper+=ds.toString(r.getString("ID"))+str1;
}
}catch(Exception e){System.out.println("运行时出错："+e);}
finally{
if(r!=null)try{ stmt = r.getStatement(); r.close();}catch(Exception e){System.out.println("关闭记录集rs时出错"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("关闭声明时statement出错"+e);}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -