3 import java
.util
.Calendar
;
4 import java
.text
.SimpleDateFormat
;
6 public class jdbcSelect1
8 public static final String DATE_FORMAT_NOW
= "yyyy-MM-dd HH:mm:ss";
10 public static String
now() {
11 Calendar cal
= Calendar
.getInstance();
12 SimpleDateFormat sdf
= new SimpleDateFormat(DATE_FORMAT_NOW
);
13 return sdf
.format(cal
.getTime());
16 public static void main(String
[] args
)
19 if (args
.length
!= 1) {
20 System
.out
.println("Usage: java jdbcSelect1 <opfile>\n");
24 Class
.forName("csql.jdbc.JdbcSqlDriver");
25 Connection con
= DriverManager
.getConnection("jdbc:csql", "root", "manager");
26 Connection adCon
= DriverManager
.getConnection("jdbc:Adapter", "root", "manager");
27 PreparedStatement stmt
= null, selStmt
= null;
28 PreparedStatement adStmt
= null, adSelStmt
= null;
29 selStmt
=con
.prepareStatement("select count(f1) from soakTable;");
30 adSelStmt
=adCon
.prepareStatement("select count(f1) from soakTable;");
31 ResultSet rs
= null, adrs
=null; int f1var
=0, f2var
=0, f3var
=0;
32 FileWriter fstream
= new FileWriter(args
[0], true);
33 BufferedWriter out
= new BufferedWriter(fstream
);
37 rs
= selStmt
.executeQuery();
42 adrs
=adSelStmt
.executeQuery();
49 out
.write("Total Records in CSQL: " +f1var
+" "+jdbcDelete
.now()+"\n");
50 out
.write("Total Records in DRDB: " +f2var
+" "+jdbcDelete
.now()+"\n");
53 } catch(Exception ex
) {
54 System
.out
.println("Exception: "+ ex
);
55 System
.out
.println("jdbcSelect1 failed at "+jdbcDelete
.now());
58 } catch (Exception e
) {
59 System
.out
.println("Exception: "+ e
);