Forum:

I/O and Streams

How can i count this variables in my DB?

Mike Redford

Greenhorn

Posts: 3

posted 14 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Hi everyone please help me this is very important to me ...

this is my source code :

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;
        }
    }
}

this source code is correct but it's not complete

please help me
right now output is :

how can i add count of ZHTYPE to this? ZTYPE is one of this : TCH_HLF or TCHFULL or TCHSD example file :
4 shared --> /file/210566155/c080d93a/db_online.html

such as this output :

* Each XTSM has 3 XTS (0-2)
* Each XTS has 4 XRX (0-3)
* Each XRX has 8 XCHAN (0-7)
* and Each line has a type of ZHTYPE

thank you very much indeed ...

Wouter Oet

Bartender

Posts: 2700

I like...

posted 14 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Why don't you create a class for each type? That will improve cohesion and then you can get rid of the TreeMap<Integer, TreeMap<Integer, Integer>> xtsmMap = new TreeMap<Integer, TreeMap<Integer, Integer>>();

"Any fool can write code that a computer can understand. Good programmers write code that humans can understand." --- Martin Fowler
Please correct my English.

Mike Redford

Greenhorn

Posts: 3

posted 14 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Wouter Oet wrote:Why don't you create a class for each type? That will improve cohesion and then you can get rid of the TreeMap<Integer, TreeMap<Integer, Integer>> xtsmMap = new TreeMap<Integer, TreeMap<Integer, Integer>>();

hi thanks

could you please show me with code?

Wouter Oet

Bartender

Posts: 2700

I like...

posted 14 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Yes I can but why don't you try it first.

"Any fool can write code that a computer can understand. Good programmers write code that humans can understand." --- Martin Fowler
Please correct my English.

Mike Redford

Greenhorn

Posts: 3

posted 14 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Wouter Oet wrote:Yes I can but why don't you try it first.

OK thanks but i have this error :

Are You online right now?

This is my example file (Updated !!!) :

XTSM:0/XTS:0/XRX:1/XHAN:4/ZHTYPE:TCHF_HLF
XTSM:0/XTS:0/XRX:1/XHAN:5/ZHTYPE:TCHF_HLF
XTSM:0/XTS:0/XRX:1/XHAN:6/ZHTYPE:TCHF_HLF
XTSM:0/XTS:0/XRX:1/XHAN:7/ZHTYPE:TCHF_HLF
XTSM:0/XTS:0/XRX:2/XHAN:0/ZHTYPE:TCHF_HLF
XTSM:0/XTS:0/XRX:2/XHAN:1/ZHTYPE:TCHF_HLF
XTSM:0/XTS:0/XRX:2/XHAN:2/ZHTYPE:TCHF_HLF
XTSM:0/XTS:0/XRX:2/XHAN:3/ZHTYPE:TCHF_HLF
XTSM:0/XTS:0/XRX:2/XHAN:4/ZHTYPE:TCHF_HLF
XTSM:0/XTS:0/XRX:2/XHAN:5/ZHTYPE:TCHF_HLF
XTSM:0/XTS:0/XRX:2/XHAN:6/ZHTYPE:TCHF_HLF
XTSM:0/XTS:0/XRX:2/XHAN:7/ZHTYPE:TCHF_HLF
XTSM:0/XTS:0/XRX:3/XHAN:0/ZHTYPE:TCHF_HLF
XTSM:0/XTS:0/XRX:3/XHAN:1/ZHTYPE:TCHF_HLF
XTSM:0/XTS:0/XRX:3/XHAN:2/ZHTYPE:TCHF_HLF
XTSM:0/XTS:0/XRX:3/XHAN:3/ZHTYPE:TCHF_HLF
XTSM:0/XTS:0/XRX:3/XHAN:4/ZHTYPE:TCHF_HLF
XTSM:0/XTS:0/XRX:3/XHAN:5/ZHTYPE:TCHF_HLF
XTSM:0/XTS:0/XRX:3/XHAN:6/ZHTYPE:TCHF_HLF
XTSM:0/XTS:0/XRX:3/XHAN:7/ZHTYPE:TCHF_HLF
XTSM:0/XTS:1/XRX:0/XHAN:2/ZHTYPE:TCHF_HLF
XTSM:0/XTS:1/XRX:0/XHAN:3/ZHTYPE:TCHF_HLF
XTSM:0/XTS:1/XRX:0/XHAN:4/ZHTYPE:TCHF_HLF
XTSM:0/XTS:1/XRX:0/XHAN:5/ZHTYPE:TCHF_HLF
XTSM:0/XTS:1/XRX:0/XHAN:6/ZHTYPE:TCHF_HLF
XTSM:0/XTS:1/XRX:0/XHAN:7/ZHTYPE:TCHF_HLF
XTSM:0/XTS:1/XRX:1/XHAN:1/ZHTYPE:TCHSD
XTSM:0/XTS:1/XRX:1/XHAN:2/ZHTYPE:TCHF_HLF
XTSM:0/XTS:1/XRX:1/XHAN:3/ZHTYPE:TCHF_HLF

Wouter Oet

Bartender

Posts: 2700

I like...

posted 14 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Something like this:

"Any fool can write code that a computer can understand. Good programmers write code that humans can understand." --- Martin Fowler
Please correct my English.

Morning came much too soon and it brought along a friend named Margarita Hangover, and a tiny ad.

a bit of art, as a gift, that will fit in a stocking

https://gardener-gift.com