java - 我如何在我的数据库中计算这些变量？

Question

你能帮我解决这个问题吗？

我有 4 个变量

1. XTSM在0~200之间
2. XTS在0~2之间
3. XRX为0~3
4. XHAN为0~7
5. ZHTYPE 是其中之一:(1)TCHF_HLF (2)TCHSD (3)TCHFULL

他们与这个形状有关。

XTSM->XTS->XRX->XHAN->ZHTYPE(纯逻辑)

这意味着:

• 每个 XTSM 有 3 个 XTS (0-2)
• 每个XTS有4个XRX(0-3)
• 每个XRX有8个XCHAN (0-7)
• 并且每一行都有一个ZHTYPE类型

我有一个包含 14000 行的数据库文件；在这个文件中指定了这些变量，例如 XTSM 在 0~200 之间，但通常小于 200，例如可能指定 0~60，但绝不会大于 200；当然对于 XTS、XRX 和 XCHAN 也是如此……所以我们必须使所有变量成为动态变量；

这是文件的一部分(例如已更新): http://www.4shared.com/file/210566155/c080d93a/db_online.html

我想要得到这个输出？ (我想显示 XTSM 和 XTS 输出并且在后台必须计算所有这些)请帮助我

----Type------------------Total---------------------Total of ZHTYPE-----------------
XTSM:0/XTS:0               in this case is : 29     TCHF_HLF:28 TCHSD:1 TCHFULL:0
XTSM:0/XTS:1               No. of found   
XTSM:0/XTS:2               No. of found   
XTSM:1/XTS:0               No. of found   
XTSM:1/XTS:1               No. of found   
XTSM:1/XTS:2               No. of found 

我不知道，但我想可能是这样；不 ？这只是伪代码:

for(i ; i< (Total of XTSM) ; i++){
        for(j ; j< (Total of XTS) ; j++){
            for(k ; k< (Total of XRX) ; k++){
                for(l ; l< (Total of XCHAN) ; l++)
                    Print( Total of XTSM:x/XTS:y);
            }
        }

}

感谢您的帮助...

Answer 1

请在下面查看我的解决方案。您提供的测试文件 test1.txt 似乎在文件开头有一些特殊字符。

.

解决方案

public class Test {

    public static void main(String[] args) throws IOException {
        Test test = new Test();
        test.execute();
    }

    private static String TYPE_XTSM = "XTSM";
    private static String TYPE_XTS = "XTS";
    private static String TYPE_XRX = "XRX";
    private static String TYPE_XHAN = "XHAN";

    private void execute() throws IOException {
        InputStream in = null;
        BufferedReader br = null;
        TreeMap<Integer, TreeMap<Integer, Integer>> xtsmMap = new TreeMap<Integer, TreeMap<Integer, Integer>>();
        try {
            in = Test.class.getResourceAsStream("test1.txt");
            br = new BufferedReader(new InputStreamReader(in));
            String line;
            while ((line = br.readLine()) != null) {
                Record rec = new Record(line);
                processRecord(xtsmMap, rec);
            }
        } finally {
            if (br != null) {
                br.close();
            }
        }
        printResults(xtsmMap);
    }

    private void processRecord(
            TreeMap<Integer, TreeMap<Integer, Integer>> xtsmMap, Record rec) {
        TreeMap<Integer, Integer> xtsMap;
        if (xtsmMap.containsKey(rec.getXtsm())) {
            xtsMap = xtsmMap.get(rec.getXtsm());
        } else {
            xtsMap = new TreeMap<Integer, Integer>();
            xtsmMap.put(Integer.valueOf(rec.getXtsm()), xtsMap);
        }
        if (xtsMap.containsKey(rec.getXts())) {
            Integer count = xtsMap.get(rec.getXts());
            xtsMap.put(Integer.valueOf(rec.getXts()), Integer.valueOf(count
                    .intValue() + 1));
        } else {
            xtsMap.put(Integer.valueOf(rec.getXts()), Integer.valueOf(1));
        }
    }

    private void printResults(
            TreeMap<Integer, TreeMap<Integer, Integer>> xtsmMap) {
        System.out.println("Type\t\tTotal");
        Set<Integer> xtsmSet = xtsmMap.navigableKeySet();
        for (Integer xtsm : xtsmSet) {
            TreeMap<Integer, Integer> xtsMap = xtsmMap.get(xtsm);
            Set<Integer> xtsSet = xtsMap.navigableKeySet();
            for (Integer xts : xtsSet) {
                Integer count = xtsMap.get(xts);
                String outputLine = TYPE_XTSM + ":" + xtsm + "/" + TYPE_XTS
                        + ":" + xts + "\t" + count;
                System.out.println(outputLine);
            }
        }
    }

    private static class Record {

        private Integer xtsm, xts, xrk, xhan;

        Record(String line) {
            StringTokenizer st = new StringTokenizer(line, "/");
            while (st.hasMoreTokens()) {
                String token = st.nextToken();
                String type = token.substring(0, token.indexOf(":"));
                String valueStr = token.substring(token.indexOf(":") + 1, token
                        .length());
                Integer value = Integer.valueOf(valueStr);
                if (TYPE_XTSM.equals(type)) {
                    xtsm = value;
                } else if (TYPE_XTS.equals(type)) {
                    xts = value;
                } else if (TYPE_XRX.equals(type)) {
                    xrk = value;
                } else if (TYPE_XHAN.equals(type)) {
                    xhan = value;
                }
            }
        }

        public Integer getXtsm() {
            return xtsm;
        }

        public Integer getXts() {
            return xts;
        }

        public Integer getXrk() {
            return xrk;
        }

        public Integer getXhan() {
            return xhan;
        }
    }
}

.

输出

Type        TotalXTSM:0/XTS:0    29XTSM:0/XTS:1    29XTSM:0/XTS:2    29XTSM:1/XTS:0    29XTSM:1/XTS:1    29XTSM:1/XTS:2    29XTSM:2/XTS:0    29XTSM:2/XTS:1    29XTSM:2/XTS:2    29XTSM:3/XTS:0    14XTSM:3/XTS:1    14XTSM:3/XTS:2    14XTSM:4/XTS:0    13XTSM:4/XTS:1    13XTSM:4/XTS:2    13XTSM:5/XTS:0    14XTSM:5/XTS:1    14XTSM:5/XTS:2    14XTSM:6/XTS:0    21XTSM:6/XTS:1    21XTSM:6/XTS:2    21XTSM:7/XTS:0    29XTSM:7/XTS:1    29XTSM:7/XTS:2    29XTSM:8/XTS:0    14XTSM:8/XTS:1    21XTSM:9/XTS:0    21XTSM:9/XTS:1    21XTSM:9/XTS:2    21XTSM:10/XTS:0   14XTSM:10/XTS:1   14XTSM:10/XTS:2   14XTSM:11/XTS:0   14XTSM:11/XTS:1   14XTSM:11/XTS:2   14XTSM:12/XTS:0   14XTSM:12/XTS:1   14XTSM:12/XTS:2   14XTSM:13/XTS:0   29XTSM:13/XTS:1   29XTSM:13/XTS:2   29XTSM:14/XTS:0   29XTSM:14/XTS:1   29XTSM:15/XTS:0   29XTSM:15/XTS:1   29XTSM:15/XTS:2   29XTSM:16/XTS:0   29XTSM:16/XTS:1   29XTSM:16/XTS:2   29XTSM:17/XTS:0   29XTSM:17/XTS:1   29XTSM:17/XTS:2   29XTSM:18/XTS:0   29XTSM:18/XTS:1   29XTSM:18/XTS:2   29XTSM:19/XTS:0   29XTSM:19/XTS:1   29XTSM:19/XTS:2   29XTSM:21/XTS:0   29XTSM:21/XTS:1   29XTSM:21/XTS:2   29XTSM:22/XTS:0   29XTSM:22/XTS:1   29XTSM:22/XTS:2   29XTSM:23/XTS:0   29XTSM:23/XTS:1   29XTSM:23/XTS:2   29XTSM:24/XTS:0   29XTSM:24/XTS:1   29XTSM:24/XTS:2   29XTSM:25/XTS:0   29XTSM:25/XTS:1   29XTSM:25/XTS:2   29XTSM:26/XTS:0   14XTSM:26/XTS:1   14XTSM:26/XTS:2   14XTSM:28/XTS:0   15XTSM:28/XTS:1   15XTSM:28/XTS:2   15XTSM:29/XTS:0   13XTSM:29/XTS:1   13XTSM:29/XTS:2   13XTSM:30/XTS:0   14XTSM:30/XTS:1   14XTSM:31/XTS:0   14XTSM:31/XTS:1   13XTSM:31/XTS:2   13XTSM:32/XTS:0   13XTSM:32/XTS:1   14XTSM:32/XTS:2   13XTSM:33/XTS:0   14XTSM:33/XTS:1   14XTSM:33/XTS:2   14XTSM:34/XTS:0   14XTSM:34/XTS:1   14XTSM:34/XTS:2   14XTSM:35/XTS:0   29XTSM:35/XTS:1   29XTSM:35/XTS:2   29XTSM:36/XTS:0   29XTSM:36/XTS:1   21XTSM:36/XTS:2   21XTSM:37/XTS:0   14XTSM:37/XTS:1   14XTSM:37/XTS:2   14XTSM:38/XTS:0   14XTSM:38/XTS:1   14XTSM:38/XTS:2   14XTSM:39/XTS:0   21XTSM:39/XTS:1   21XTSM:39/XTS:2   21XTSM:40/XTS:0   29XTSM:40/XTS:1   29XTSM:40/XTS:2   7XTSM:41/XTS:0   29XTSM:41/XTS:1   29XTSM:41/XTS:2   29