- /**
- * Title: 字典代码转换类
- * Description: 将部门字典字段转化为国标字典代码。
- * @date : 2006-4-4
- * @author : zhanglei
- * @version : 1.0
- */
- package server;
- import java.sql.*;
- import java.util.*;
- import java.io.*;
- import oracle.sql.*;
- public class ZdExchange {
- public static DomXML zdXml = null;
- public ZdExchange() {
- try {
- zdXml = new DomXML("zd.xml");
- }
- catch (Exception ex) {
- SaveLog.SetInfo("载入字典对照码失败!", 1);
- }
- }
- //得到国标字典项
- public static String getZdItem() {
- String zdItem = "";
- String item = "";
- String bmcode = "";
- int flag = 0;
- try {
- for (int n = 0; n < zdXml.GetItemCount("zditem"); n++) {
- item = zdXml.GetItemNoName(n).trim();
- if (item.equals("")) {
- continue;
- }
- flag = 0;
- for (int m = 0; m < zdXml.GetItemCount(item); m++) {
- bmcode = zdXml.GetItemNoAttribute(m, "bmcode").trim();
- if (bmcode.equals("")) {
- continue;
- }
- else {
- flag = 1;
- break;
- }
- }
- if (flag == 1) {
- zdItem = item + "," + zdItem;
- }
- }
- return zdItem;
- }
- catch (Exception ex) {
- SaveLog.SetInfo("ZdExchange中getZdItem:" + ex, 2);
- return "";
- }
- }
- //得到国标字典代码
- public static String getGbZd(String zdMc, String bmCode) {
- String gbCode = "";
- String item = "";
- try {
- for (int n = 0; n < zdXml.GetItemCount(zdMc.toLowerCase()); n++) {
- item = zdXml.GetItemNoName(n).trim();
- if (item.equals("")) {
- continue;
- }
- if (zdXml.GetItemNoAttribute(n, "bmcode").trim().equals(bmCode)) {
- gbCode = zdXml.GetItemNoAttribute(n, "gbcode");
- break;
- }
- }
- if (!gbCode.equals("")) {
- return gbCode;
- }
- return bmCode;
- }
- catch (Exception ex) {
- SaveLog.SetInfo("ZdExchange中getGbZd:" + ex, 2);
- return "";
- }
- }
- //生成字典
- public static void getZdXml() {
- WriteXml myxml = new WriteXml();
- JdbcWork jw = new JdbcWork();
- try {
- myxml.WriteFile("zd.xml");
- myxml.AddRoot(0, "root");
- myxml.AddRoot(1, "zditem");
- String aa[] = new String[4];
- String bb[] = new String[4];
- Statement tStmt = null;
- ResultSet tRs = null;
- Statement jlStmt = null;
- ResultSet jlRs = null;
- String Sql = "";
- Sql = "SELECT * FROM zh_dictnamedefine where dicttofield is not null";
- tStmt = jw.GetStatment();
- tRs = tStmt.executeQuery(Sql);
- while (tRs.next()) {
- aa[0] = "cname";
- bb[0] = tRs.getString("dictdepict");
- aa[1] = "dictname";
- bb[1] = tRs.getString("dictname");
- aa[2] = "dictversion";
- bb[2] = tRs.getString("dictversion"); ;
- aa[3] = "dictsource";
- bb[3] = tRs.getString("dictsource"); ;
- myxml.AddItem(1, tRs.getString("dicttofield").toLowerCase(), "", aa, bb);
- Sql = "SELECT * FROM zh_dictvalue where dictname = '" + tRs.getString("dictname") + "' order by dictcode";
- jlStmt = jw.GetStatment();
- jlRs = jlStmt.executeQuery(Sql);
- while (jlRs.next()) {
- aa[0] = "cname";
- bb[0] = jlRs.getString("dictvalue");
- aa[1] = "gbcode";
- bb[1] = jlRs.getString("dictcode");
- aa[2] = "bmcode";
- bb[2] = "";
- aa[3] = "";
- bb[3] = "";
- myxml.AddItem("item", "", aa, bb);
- }
- jlRs.close();
- jlStmt.close();
- }
- myxml.toSave("0");
- tStmt.close();
- tRs.close();
- }
- catch (Exception ex) {
- SaveLog.SetInfo("ZdExchange中getZdXml:" + ex, 2);
- }
- //读取字典
- /* try {
- DomXML SysXml = new DomXML("zd.xml");
- for (int m = 0; m < SysXml.GetItemCount("CzrkMz"); m++) {
- System.out.println(m+SysXml.GetItemNoName(m));
- System.out.println(SysXml.GetItemNoAttribute(m, "cname"));
- }
- }
- catch (Exception ex) {
- }
- */
- }
- //得到字典代码值数组
- public static String[][] getZdValSz(String zdMc) {
- String gbCode[][] = new String[9999][3];
- String item = "";
- int m = 0;
- for (int n = 0; n < zdXml.GetItemCount("zdMc.toLowerCase()"); n++) {
- item = zdXml.GetItemNoName(n).trim();
- if (item.equals("")) {
- continue;
- }
- gbCode[m][0] = zdXml.GetItemNoAttribute(n, "gbcode");
- gbCode[m][1] = zdXml.GetItemNoAttribute(n, "cname");
- gbCode[m][2] = "";
- m = m + 1;
- }
- return gbCode;
- }
- //得到字典名称数组
- public static String[] getZditemSz() {
- String gbCode[] = new String[999];
- String item = "";
- int m = 0;
- for (int n = 0; n < zdXml.GetItemCount("zditem"); n++) {
- item = zdXml.GetItemNoName(n).trim();
- if (item.equals("")) {
- continue;
- }
- gbCode[m] = zdXml.GetItemNoAttribute(n, "cname") +
- " * " +
- zdXml.GetItemNoAttribute(n, "dictsource") +
- " # " +
- zdXml.GetItemNoAttribute(n, "dictversion") +
- " @ " +
- zdXml.GetItemNoName(n).trim()
- ;
- m = m + 1;
- }
- return gbCode;
- }
- //得到字典数组值
- //行政职务级别
- public static String[][] getZdValSz1() {
- String gbCode[][] = new String[9999][3];
- String item = "";
- int m = 0;
- for (int n = 0; n < zdXml.GetItemCount("czrkzwjb"); n++) {
- item = zdXml.GetItemNoName(n).trim();
- if (item.equals("")) {
- continue;
- }
- gbCode[m][0] = zdXml.GetItemNoAttribute(n, "gbcode");
- gbCode[m][1] = zdXml.GetItemNoAttribute(n, "cname");
- gbCode[m][2] = "";
- m = m + 1;
- }
- return gbCode;
- }
- //行政职务名称
- public static String[][] getZdValSz2() {
- String gbCode[][] = new String[9999][3];
- String item = "";
- int m = 0;
- for (int n = 0; n < zdXml.GetItemCount("czrkzwmc"); n++) {
- item = zdXml.GetItemNoName(n).trim();
- if (item.equals("")) {
- continue;
- }
- gbCode[m][0] = zdXml.GetItemNoAttribute(n, "gbcode");
- gbCode[m][1] = zdXml.GetItemNoAttribute(n, "cname");
- gbCode[m][2] = "";
- m = m + 1;
- }
- return gbCode;
- }
- //字典名称数组.....专业技术资格名称
- public static String[][] getZdValSz3() {
- String gbCode[][] = new String[9999][3];
- String item = "";
- int m = 0;
- for (int n = 0; n < zdXml.GetItemCount("czrkzyjszgmc"); n++) {
- item = zdXml.GetItemNoName(n).trim();
- if (item.equals("")) {
- continue;
- }
- gbCode[m][0] = zdXml.GetItemNoAttribute(n, "gbcode");
- gbCode[m][1] = zdXml.GetItemNoAttribute(n, "cname");
- gbCode[m][2] = "";
- m = m + 1;
- }
- return gbCode;
- }
- //字典名称数组.....聘任专业技术职务名称
- public static String[][] getZdValSz4() {
- String gbCode[][] = new String[9999][3];
- String item = "";
- int m = 0;
- for (int n = 0; n < zdXml.GetItemCount("czrkprzyjszwmc"); n++) {
- item = zdXml.GetItemNoName(n).trim();
- if (item.equals("")) {
- continue;
- }
- gbCode[m][0] = zdXml.GetItemNoAttribute(n, "gbcode");
- gbCode[m][1] = zdXml.GetItemNoAttribute(n, "cname");
- gbCode[m][2] = "";
- m = m + 1;
- }
- return gbCode;
- }
- //工人职业资格等级
- public static String[][] getZdValSz5() {
- String gbCode[][] = new String[9999][3];
- String item = "";
- int m = 0;
- for (int n = 0; n < zdXml.GetItemCount("czrkzyzgdj"); n++) {
- item = zdXml.GetItemNoName(n).trim();
- if (item.equals("")) {
- continue;
- }
- gbCode[m][0] = zdXml.GetItemNoAttribute(n, "gbcode");
- gbCode[m][1] = zdXml.GetItemNoAttribute(n, "cname");
- gbCode[m][2] = "";
- m = m + 1;
- }
- return gbCode;
- }
- //职业类别
- public static String[][] getZdValSz6() {
- String gbCode[][] = new String[9999][3];
- String item = "";
- int m = 0;
- for (int n = 0; n < zdXml.GetItemCount("czrkzylb"); n++) {
- item = zdXml.GetItemNoName(n).trim();
- if (item.equals("")) {
- continue;
- }
- gbCode[m][0] = zdXml.GetItemNoAttribute(n, "gbcode");
- gbCode[m][1] = zdXml.GetItemNoAttribute(n, "cname");
- gbCode[m][2] = "";
- m = m + 1;
- }
- return gbCode;
- }
- //死亡原因
- public static String[][] getZdValSz7() {
- String gbCode[][] = new String[9999][3];
- String item = "";
- int m = 0;
- for (int n = 0; n < zdXml.GetItemCount("czrkswzxlb"); n++) {
- item = zdXml.GetItemNoName(n).trim();
- if (item.equals("")) {
- continue;
- }
- gbCode[m][0] = zdXml.GetItemNoAttribute(n, "gbcode");
- gbCode[m][1] = zdXml.GetItemNoAttribute(n, "cname");
- gbCode[m][2] = "";
- m = m + 1;
- }
- return gbCode;
- }
- //个人身份
- public static String[][] getZdValSz8() {
- String gbCode[][] = new String[9999][3];
- String item = "";
- int m = 0;
- for (int n = 0; n < zdXml.GetItemCount("czrkgrsf"); n++) {
- item = zdXml.GetItemNoName(n).trim();
- if (item.equals("")) {
- continue;
- }
- gbCode[m][0] = zdXml.GetItemNoAttribute(n, "gbcode");
- gbCode[m][1] = zdXml.GetItemNoAttribute(n, "cname");
- gbCode[m][2] = "";
- m = m + 1;
- }
- return gbCode;
- }
- //户口变动类别
- public static String[][] getZdValSz9() {
- String gbCode[][] = new String[9999][3];
- String item = "";
- int m = 0;
- for (int n = 0; n < zdXml.GetItemCount("czrkzxlb"); n++) {
- item = zdXml.GetItemNoName(n).trim();
- if (item.equals("")) {
- continue;
- }
- gbCode[m][0] = zdXml.GetItemNoAttribute(n, "gbcode");
- gbCode[m][1] = zdXml.GetItemNoAttribute(n, "cname");
- gbCode[m][2] = "";
- m = m + 1;
- }
- return gbCode;
- }
- //行业类别
- public static String[][] getZdValSz10() {
- String gbCode[][] = new String[9999][3];
- String item = "";
- int m = 0;
- for (int n = 0; n < zdXml.GetItemCount("czrkhylb"); n++) {
- item = zdXml.GetItemNoName(n).trim();
- if (item.equals("")) {
- continue;
- }
- gbCode[m][0] = zdXml.GetItemNoAttribute(n, "gbcode");
- gbCode[m][1] = zdXml.GetItemNoAttribute(n, "cname");
- gbCode[m][2] = "";
- m = m + 1;
- }
- return gbCode;
- }
- //学历
- public static String[][] getZdValSz11() {
- String gbCode[][] = new String[9999][3];
- String item = "";
- int m = 0;
- for (int n = 0; n < zdXml.GetItemCount("czrkwhcd"); n++) {
- item = zdXml.GetItemNoName(n).trim();
- if (item.equals("")) {
- continue;
- }
- gbCode[m][0] = zdXml.GetItemNoAttribute(n, "gbcode");
- gbCode[m][1] = zdXml.GetItemNoAttribute(n, "cname");
- gbCode[m][2] = "";
- m = m + 1;
- }
- return gbCode;
- }
- //学位
- public static String[][] getZdValSz12() {
- String gbCode[][] = new String[9999][3];
- String item = "";
- int m = 0;
- for (int n = 0; n < zdXml.GetItemCount("czrkxw"); n++) {
- item = zdXml.GetItemNoName(n).trim();
- if (item.equals("")) {
- continue;
- }
- gbCode[m][0] = zdXml.GetItemNoAttribute(n, "gbcode");
- gbCode[m][1] = zdXml.GetItemNoAttribute(n, "cname");
- gbCode[m][2] = "";
- m = m + 1;
- }
- return gbCode;
- }
- //参保状态
- public static String[][] getZdValSz13() {
- String gbCode[][] = new String[9999][3];
- String item = "";
- int m = 0;
- for (int n = 0; n < zdXml.GetItemCount("czrkcbzt"); n++) {
- item = zdXml.GetItemNoName(n).trim();
- if (item.equals("")) {
- continue;
- }
- gbCode[m][0] = zdXml.GetItemNoAttribute(n, "gbcode");
- gbCode[m][1] = zdXml.GetItemNoAttribute(n, "cname");
- gbCode[m][2] = "";
- m = m + 1;
- }
- return gbCode;
- }
- //兵役状况
- public static String[][] getZdValSz14() {
- String gbCode[][] = new String[9999][3];
- String item = "";
- int m = 0;
- for (int n = 0; n < zdXml.GetItemCount("czrkbyzk"); n++) {
- item = zdXml.GetItemNoName(n).trim();
- if (item.equals("")) {
- continue;
- }
- gbCode[m][0] = zdXml.GetItemNoAttribute(n, "gbcode");
- gbCode[m][1] = zdXml.GetItemNoAttribute(n, "cname");
- gbCode[m][2] = "";
- m = m + 1;
- }
- return gbCode;
- }
- //户口类别
- public static String[][] getZdValSz15() {
- String gbCode[][] = new String[9999][3];
- String item = "";
- int m = 0;
- for (int n = 0; n < zdXml.GetItemCount("czrkhlx"); n++) {
- item = zdXml.GetItemNoName(n).trim();
- if (item.equals("")) {
- continue;
- }
- gbCode[m][0] = zdXml.GetItemNoAttribute(n, "gbcode");
- gbCode[m][1] = zdXml.GetItemNoAttribute(n, "cname");
- gbCode[m][2] = "";
- m = m + 1;
- }
- return gbCode;
- }
- //婚姻状况
- public static String[][] getZdValSz16() {
- String gbCode[][] = new String[9999][3];
- String item = "";
- int m = 0;
- for (int n = 0; n < zdXml.GetItemCount("czrkhyzk"); n++) {
- item = zdXml.GetItemNoName(n).trim();
- if (item.equals("")) {
- continue;
- }
- gbCode[m][0] = zdXml.GetItemNoAttribute(n, "gbcode");
- gbCode[m][1] = zdXml.GetItemNoAttribute(n, "cname");
- gbCode[m][2] = "";
- m = m + 1;
- }
- return gbCode;
- }
- //健康状况
- public static String[][] getZdValSz17() {
- String gbCode[][] = new String[9999][3];
- String item = "";
- int m = 0;
- for (int n = 0; n < zdXml.GetItemCount("czrkjkzk"); n++) {
- item = zdXml.GetItemNoName(n).trim();
- if (item.equals("")) {
- continue;
- }
- gbCode[m][0] = zdXml.GetItemNoAttribute(n, "gbcode");
- gbCode[m][1] = zdXml.GetItemNoAttribute(n, "cname");
- gbCode[m][2] = "";
- m = m + 1;
- }
- return gbCode;
- }
- //就业状态
- public static String[][] getZdValSz18() {
- String gbCode[][] = new String[9999][3];
- String item = "";
- int m = 0;
- for (int n = 0; n < zdXml.GetItemCount("czrkjyzt"); n++) {
- item = zdXml.GetItemNoName(n).trim();
- if (item.equals("")) {
- continue;
- }
- gbCode[m][0] = zdXml.GetItemNoAttribute(n, "gbcode");
- gbCode[m][1] = zdXml.GetItemNoAttribute(n, "cname");
- gbCode[m][2] = "";
- m = m + 1;
- }
- return gbCode;
- }
- //民族
- public static String[][] getZdValSz19() {
- String gbCode[][] = new String[9999][3];
- String item = "";
- int m = 0;
- for (int n = 0; n < zdXml.GetItemCount("czrkmz"); n++) {
- item = zdXml.GetItemNoName(n).trim();
- if (item.equals("")) {
- continue;
- }
- gbCode[m][0] = zdXml.GetItemNoAttribute(n, "gbcode");
- gbCode[m][1] = zdXml.GetItemNoAttribute(n, "cname");
- gbCode[m][2] = "";
- m = m + 1;
- }
- return gbCode;
- }
- //性别
- public static String[][] getZdValSz20() {
- String gbCode[][] = new String[9999][3];
- String item = "";
- int m = 0;
- for (int n = 0; n < zdXml.GetItemCount("czrkxb"); n++) {
- item = zdXml.GetItemNoName(n).trim();
- if (item.equals("")) {
- continue;
- }
- gbCode[m][0] = zdXml.GetItemNoAttribute(n, "gbcode");
- gbCode[m][1] = zdXml.GetItemNoAttribute(n, "cname");
- gbCode[m][2] = "";
- m = m + 1;
- }
- return gbCode;
- }
- //血型
- public static String[][] getZdValSz21() {
- String gbCode[][] = new String[9999][3];
- String item = "";
- int m = 0;
- for (int n = 0; n < zdXml.GetItemCount("czrkxx"); n++) {
- item = zdXml.GetItemNoName(n).trim();
- if (item.equals("")) {
- continue;
- }
- gbCode[m][0] = zdXml.GetItemNoAttribute(n, "gbcode");
- gbCode[m][1] = zdXml.GetItemNoAttribute(n, "cname");
- gbCode[m][2] = "";
- m = m + 1;
- }
- return gbCode;
- }
- //信息级别
- public static String[][] getZdValSz22() {
- String gbCode[][] = new String[9999][3];
- String item = "";
- int m = 0;
- for (int n = 0; n < zdXml.GetItemCount("czrkxxjb"); n++) {
- item = zdXml.GetItemNoName(n).trim();
- if (item.equals("")) {
- continue;
- }
- gbCode[m][0] = zdXml.GetItemNoAttribute(n, "gbcode");
- gbCode[m][1] = zdXml.GetItemNoAttribute(n, "cname");
- gbCode[m][2] = "";
- m = m + 1;
- }
- return gbCode;
- }
- //行政区划
- public static String[][] getZdValSz23() {
- String gbCode[][] = new String[9999][3];
- String item = "";
- int m = 0;
- for (int n = 0; n < zdXml.GetItemCount("czrkcsdssx"); n++) {
- item = zdXml.GetItemNoName(n).trim();
- if (item.equals("")) {
- continue;
- }
- gbCode[m][0] = zdXml.GetItemNoAttribute(n, "gbcode");
- gbCode[m][1] = zdXml.GetItemNoAttribute(n, "cname");
- gbCode[m][2] = "";
- m = m + 1;
- }
- return gbCode;
- }
- //家庭关系
- public static String[][] getZdValSz24() {
- String gbCode[][] = new String[9999][3];
- String item = "";
- int m = 0;
- for (int n = 0; n < zdXml.GetItemCount("czrkyhzgx"); n++) {
- item = zdXml.GetItemNoName(n).trim();
- if (item.equals("")) {
- continue;
- }
- gbCode[m][0] = zdXml.GetItemNoAttribute(n, "gbcode");
- gbCode[m][1] = zdXml.GetItemNoAttribute(n, "cname");
- gbCode[m][2] = "";
- m = m + 1;
- }
- return gbCode;
- }
- //有效期限
- public static String[][] getZdValSz25() {
- String gbCode[][] = new String[9999][3];
- String item = "";
- int m = 0;
- for (int n = 0; n < zdXml.GetItemCount("czrkyxqx"); n++) {
- item = zdXml.GetItemNoName(n).trim();
- if (item.equals("")) {
- continue;
- }
- gbCode[m][0] = zdXml.GetItemNoAttribute(n, "gbcode");
- gbCode[m][1] = zdXml.GetItemNoAttribute(n, "cname");
- gbCode[m][2] = "";
- m = m + 1;
- }
- return gbCode;
- }
- }
zdchang.java
最新推荐文章于 2024-08-15 11:29:03 发布