how to convert string into string array

[Baktha Elumalai]

input

row1: "2010-04-21 11:01:35",
row2: "2010-04-22 11:01:58",
row3: "2010-04-23 11:02:21",
row4: "2010-04-24 11:02:42",
row4: "2010-04-24 11:03:28",
row5: "2010-04-25 11:03:51"

i get the data like this
i need to get the hh, mm and ss seperate and compare each row by row the hh mm ss is same or not

 preparedStatement = conn1.prepareStatement(
    "select gpstime from xydataa a inner join fm4features f on a.ID=f.ID
    where a.objectId= '18'  AND a.clientId = '1' AND a.gpstime > '2010-04-24 00:00:00'
    AND a.gpstime < '2010-04-26 23:59:59' AND f.DataId='1' AND f.value = '1'
    GROUP  BY a.gpstime");
        rs = preparedStatement.executeQuery();
         while (rs.next())
            {
                String output[];
                String temp[];
                String gpstime = rs.getString("gpstime");
                System.out.println("GPSTIME"    +gpstime);
                String sub = gpstime.substring(11,21);
                String sub1 = gpstime.substring(11,13);
                System.out.println("GPSDATE"    +sub+ "GPSTIME" +sub1);

               //String[] values = gpstime.split(" ");
                System.out.println("***HH**MM**SS***");
                String[] date = new String[gpstime.length()];
                int[] hh = new int[gpstime.length()];
                int[] mm = new int[gpstime.length()];
                String[] ss = new String[gpstime.length()];
               List row1 = new ArrayList();
               List row2 = new ArrayList();
//                for (char c : cArray)
//                  System.out.println(c);
               for(int k = 0 ; k < gpstime.length(); k++)
           {
              [color=red]
               temp = gpstime.split(" ");[/color]
               output = temp[1].split(":");
               date[k] = String.valueOf(temp[0]);
               hh[k] = Integer.parseInt(output[0]);
               mm[k] = Integer.parseInt(output[1]);
               ss[k] = String.valueOf(output[2]);
              System.out.println(k+1+"."+date[k]+" "+hh[k]+" "+mm[k]+" "+ss[k]+" ");
              row1.add(k);
              row2.add(k);
              
             temp=null;
             output=null;
        }

i need temp = gpstime[k].split(" ");

please help me

[Campbell Ritchie]

Why don't you put the Strings into a SimpleDateFormat or similar class, get an instance from that, and separate the time from that? What is wrong with the split() call you are using?

[David Newton]

(Consider posting only the code necessary to deal w/ the question--the loop and JDBC isn't really relevant :)

[Gokul Nanthakumar]

As the String length and format is known you can simply use String.substring() for find the HH MM values

[Campbell Ritchie]

David Newton wrote: . . . the JDBC isn't really relevant . . .

And it's even harder to read as one line; I had to put new lines in for you. Please avoid such long lines inside code tags.

[sai prashanth]

row1: "2010-04-21 11:01:35",
row2: "2010-04-22 11:01:58",
row3: "2010-04-23 11:02:21",

If the input you have provided is right, then I think you also need to take in to account the date part too. How about converting the date/time in to milliseconds and then comparing it?

[Baktha Elumalai]

Hi i used same way

 while (rs.next())
            {
                String output[];
                String temp[];
                String gpstime = rs.getString("gpstime");
                //System.out.println("GPSTIME"    +gpstime);
                String time = gpstime.substring(11,21);
                String hh2 = gpstime.substring(11,13);
                String mm2 = gpstime.substring(14,16);
                String ss2 = gpstime.substring(17,19);
                System.out.println(" HH:" +hh2+ " MM:" +mm2+ " SS:" +ss2);

ouput

 HH:20 MM:06 SS:13
 HH:20 MM:07 SS:13
 HH:20 MM:08 SS:13
 HH:20 MM:09 SS:14
 HH:20 MM:10 SS:14
 HH:20 MM:11 SS:14
 HH:20 MM:12 SS:14
 HH:20 MM:13 SS:14
 HH:20 MM:14 SS:14
 HH:20 MM:15 SS:14
 HH:20 MM:16 SS:14
 HH:20 MM:17 SS:15
 HH:20 MM:18 SS:15
 HH:20 MM:19 SS:15
 HH:20 MM:20 SS:15
 HH:20 MM:21 SS:15
 HH:20 MM:22 SS:15
 HH:20 MM:23 SS:15
 HH:20 MM:24 SS:15
 HH:20 MM:25 SS:16
 HH:20 MM:26 SS:16
 HH:20 MM:27 SS:16
 HH:20 MM:28 SS:16
 HH:20 MM:29 SS:16
 HH:20 MM:30 SS:16
 HH:20 MM:31 SS:03
 HH:20 MM:32 SS:03
 HH:20 MM:33 SS:03
 HH:20 MM:34 SS:04
 HH:20 MM:35 SS:04
 HH:20 MM:36 SS:04
 HH:21 MM:41 SS:42
 HH:21 MM:42 SS:42
 HH:21 MM:47 SS:47
 HH:21 MM:48 SS:47
 HH:21 MM:49 SS:47
 HH:22 MM:43 SS:45
 HH:22 MM:44 SS:45
 HH:22 MM:46 SS:56
 HH:22 MM:47 SS:56
 HH:23 MM:08 SS:53
 HH:23 MM:09 SS:54
 HH:23 MM:10 SS:54
 HH:23 MM:11 SS:54
 HH:23 MM:12 SS:54
 HH:23 MM:13 SS:54
 HH:23 MM:14 SS:54
 HH:23 MM:15 SS:54
 HH:23 MM:24 SS:15
 HH:23 MM:25 SS:16
 HH:23 MM:26 SS:16
 HH:00 MM:35 SS:25
 HH:00 MM:36 SS:26
 HH:00 MM:37 SS:26
 HH:00 MM:38 SS:26
 HH:00 MM:39 SS:26
 HH:00 MM:40 SS:21
 HH:00 MM:45 SS:19
 HH:00 MM:46 SS:19
 HH:00 MM:47 SS:19
 HH:00 MM:48 SS:19
 HH:00 MM:49 SS:19
 HH:09 MM:55 SS:01
 HH:09 MM:56 SS:02
 HH:09 MM:57 SS:02
 HH:09 MM:58 SS:03
 HH:09 MM:59 SS:03
 HH:10 MM:00 SS:03
 HH:10 MM:52 SS:53
 HH:10 MM:53 SS:54
 HH:10 MM:54 SS:54
 HH:11 MM:04 SS:27
 HH:11 MM:04 SS:55
 HH:11 MM:32 SS:55
 HH:11 MM:33 SS:56
 HH:11 MM:41 SS:05
 HH:16 MM:29 SS:03
 HH:16 MM:30 SS:03
 HH:16 MM:31 SS:04
 HH:16 MM:32 SS:04
 HH:16 MM:33 SS:04
 HH:16 MM:34 SS:04
 HH:16 MM:35 SS:04
 HH:16 MM:36 SS:04
 HH:16 MM:37 SS:04
 HH:16 MM:38 SS:04
 HH:16 MM:39 SS:05
 HH:16 MM:40 SS:05
 HH:16 MM:41 SS:05
 HH:16 MM:42 SS:05
 HH:16 MM:43 SS:05
 HH:16 MM:44 SS:05
 HH:16 MM:45 SS:05
 HH:16 MM:46 SS:05
 HH:18 MM:53 SS:37
 HH:18 MM:54 SS:37
 HH:18 MM:55 SS:37
 HH:18 MM:56 SS:37
 HH:18 MM:57 SS:38
 HH:18 MM:58 SS:38
 HH:18 MM:59 SS:38
 HH:19 MM:00 SS:38
 HH:19 MM:59 SS:24
 HH:20 MM:00 SS:25
 HH:20 MM:01 SS:25
 HH:20 MM:02 SS:25
 HH:20 MM:03 SS:25
 HH:20 MM:04 SS:25
 HH:20 MM:11 SS:05
 HH:20 MM:12 SS:05
 HH:20 MM:18 SS:47
 HH:20 MM:19 SS:47
 HH:20 MM:53 SS:58
 HH:20 MM:54 SS:59
 HH:20 MM:55 SS:59
 HH:21 MM:24 SS:17
 HH:21 MM:25 SS:18
 HH:21 MM:26 SS:18
 HH:21 MM:54 SS:31
 HH:00 MM:00 SS:00

the above output how to compare the hh, mm and ss row by row
if any idea please help me

[Gokul Nanthakumar]

if you want to unique data put the result into Set and get the unique result or just want to compare and find the given time is already there are not, put them into hashset or hashmap(according to your requirement) and compare it is already available or not.

[James Sabre]

Campbell Ritchie wrote:Why don't you put the Strings into a SimpleDateFormat or similar class, get an instance from that, and separate the time from that? What is wrong with the split() call you are using?

To those interested - this topic has been running for over 5 days and it is still not clear what the OP is trying to do.

[David Newton]

Wow, that's borderline epic.

[Baktha Elumalai]

Gokul Nanthakumar wrote:if you want to unique data put the result into Set and get the unique result or just want to compare and find the given time is already there are not, put them into hashset or hashmap(according to your requirement) and compare it is already available or not.

please send any eaxmple

[David Newton]

Example of what, how to put data into a set?

[Baktha Elumalai]

yes

[Campbell Ritchie]

Is the Java™ Tutorials section about collections any use to you?