3 import java
.util
.Calendar
;
4 import java
.text
.SimpleDateFormat
;
6 public class jdbcDelete
8 public static final String DATE_FORMAT_NOW
= "yyyy-MM-dd HH:mm:ss";
9 public static final int TS
= 1;
11 public static String
now() {
12 Calendar cal
= Calendar
.getInstance();
13 SimpleDateFormat sdf
= new SimpleDateFormat(DATE_FORMAT_NOW
);
14 return sdf
.format(cal
.getTime());
17 public static void main(String
[] args
)
20 if (args
.length
!= 1) {
21 System
.out
.println("Usage: java jdbcDelete <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, delStmt
= null, adSelStmt
=null, adDelStmt
=null;
28 selStmt
= con
.prepareStatement("select f2 from soakTable limit 1;");
29 delStmt
= con
.prepareStatement("delete from soakTable where f2 = ?;");
30 // adSelStmt = adCon.prepareStatement("select f2 from soakTable limit 1;");
31 adDelStmt
= adCon
.prepareStatement("delete from soakTable where f2 = ?;");
32 ResultSet rs
= null, adrs
= null; int f2var
= 0;
33 FileWriter fstream
= new FileWriter(args
[0], true);
34 BufferedWriter out
= new BufferedWriter(fstream
);
37 Thread
.sleep(jdbcDelete
.TS
);
38 rs
= selStmt
.executeQuery();
39 if(rs
.next()) { f2var
= rs
.getInt(1); }
41 // adrs = adSelStmt.executeQuery();
42 // if(adrs.next()) { f2var = adrs.getInt(1); }
44 delStmt
.setInt(1,f2var
);
47 adDelStmt
.setInt(1,f2var
);
50 //System.out.println("f2var = "+f2var+" "+jdbcDelete.now());
51 out
.write("deleted PK: " +f2var
+ " "+jdbcDelete
.now()+"\n");
53 } catch(Exception ex
) {
54 System
.out
.println("Exception: "+ ex
);
55 System
.out
.println("jdbcDelete fail f2 = "+f2var
+" "+jdbcDelete
.now());
58 } catch (Exception e
) {
59 System
.out
.println("Exception: "+ e
);