📄 personbean.java
字号:
vt.add(ds.toString(rs.getString("XMMC")));
} 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 vt;
}
public Vector getXL()//从字典表取得学历
{
String sql = "";
sql = "select XMMC from news.CODE_ZDB where ZDMC='学历' and SYZT=0 order by jbxh";
ResultSet rs = selectRecord(sql);
Vector vt = new Vector();
Statement stmt = null;
try {
while (rs.next())
vt.add(ds.toString(rs.getString("XMMC")));
} 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 vt;
}
public Vector getZC()//从字典表取得职称
{
String sql = "";
sql = "select XMMC from news.CODE_ZDB where ZDMC='职称' and SYZT=0 order by jbxh";
ResultSet rs = selectRecord(sql);
Statement stmt = null;
Vector vt = new Vector();
try {
while (rs.next())
vt.add(ds.toString(rs.getString("XMMC")));
} 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 vt;
}
//增加人员数据记录
public int addPerson(Hashtable hash) {
String sql = "";
long intPerson = 0;
String strBMBH = ds.toString((String) hash.get("BMBH"));
String strZGBH = ds.toString((String) hash.get("ZGBH"));
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"));
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 news.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 news.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 news.ZZ_ZGB where YHM='" + strYHM
+ "' and ZZZT=0";
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 news.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 news.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 news.ZZ_ZGB set JBXH=JBXH-1 where BMBH='"
+ strOrgNO + "' and ZZZT=0 and JBXH <=" + jbxh
+ " and JBXH>" + yjbxh;
deleteRecord(sql2);
}
} else//部门发生改变,更新级别序号
{///修改原部门内人员级别序号
String sql3 = "update news.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 news.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 news.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 news.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 news.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();
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -