class ModifyBeetlesTable
1: import java.util.Calendar;
2: import java.sql.*;
3: import java.io.*;
4:
5: class ModifyBeetlesTable {
6: public static void main( String args[] )
7: throws SQLException, IOException {
8: try {
9: Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
10: } catch(ClassNotFoundException e) {
11: System.exit(1);
12: }
13: System.out.print("\nConnecting to Beetles table...\n\n");
14: String url = "jdbc:odbc:OrdersDriver";
15: Connection conn =
16: DriverManager.getConnection(url,"rPasenko","mpf98eub");
17: Statement stmt = conn.createStatement();
18: System.out.print("Modifying Beetles table...\n\n");
19: String updateString =
20: "ALTER TABLE Beetles ADD ORDERNO VARCHAR(12)";
21: stmt.executeUpdate(updateString);
22: Calendar cal = Calendar.getInstance();
23: String orderNo = String.valueOf(cal.get(cal.MONTH)+1) +
24: String.valueOf(cal.get(cal.DAY_OF_MONTH)) +
25: String.valueOf(cal.get(cal.YEAR)) +
26: String.valueOf(cal.get(cal.HOUR)) +
27: String.valueOf(cal.get(cal.MINUTE)) +
28: String.valueOf(cal.get(cal.SECOND));
29: updateString = "UPDATE Beetles SET ORDERNO = " +
30: orderNo + " WHERE NAME='Michael Owen'";
31: stmt.executeUpdate(updateString);
32: ResultSet rset = stmt.executeQuery("SELECT * FROM Beetles");
33: System.out.print("Displaying table contents...\n\n");
34: while (rset.next()) {
35: System.out.println(" " +
36: rset.getString("name") + ", " +
37: rset.getString("address") + ", " +
38: rset.getString("city") + ", " +
39: rset.getString("state") + "\n " +
40: rset.getString("zip") + ", " +
41: rset.getString("email") + ", " +
42: rset.getString("creditCard") + ", " +
43: rset.getString("orderno") );
44: }
45: System.out.print("\nDeleting test record...\n\n");
46: updateString = "DELETE FROM Beetles WHERE NAME='Michael Owen'";
47: stmt.executeUpdate(updateString);
48: System.out.print("Closing connection...\n\n");
49: conn.commit();
50: stmt.close();
51: rset.close();
52: conn.close();
53: }
54: }