zdchang.java
来源:互联网 发布:如果没有安史之乱知乎 编辑:程序博客网 时间:2024/05/17 03:03
- 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);
- }
-
-
- }
-
- 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;
- }
- }