public class JdbcOrderDialog extends OrderDialog
class JdbcButtonHandler implements ActionListener
1: import java.util.Calendar;
2: import java.awt.event.*;
3: import javax.swing.*;
4: import java.sql.*;
5: import java.io.*;
6:
7: public class JdbcOrderDialog extends OrderDialog {
8:
9: public JdbcOrderDialog(JFrame owner) {
10: super(owner);
11: }
12:
13: protected ActionListener makeButtonHandler() {
14: return new JdbcButtonHandler();
15: }
16:
17: class JdbcButtonHandler implements ActionListener {
18: public void actionPerformed(ActionEvent evt) {
19: JButton button = (JButton) evt.getSource();
20: String label = button.getText();
21: if ("Ok".equals(label)) {
22: try {
23: insertNewOrder();
24: } catch( SQLException IOex ) {}
25: catch( IOException IOex ) {}
26: dialogPanel.reset();
27: setVisible(false);
28: }
29: }
30:
31: public void insertNewOrder() throws SQLException, IOException {
32: System.out.print( "Loading JDBC OCI driver...\n\n\n" );
33: try {
34: Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver" );
35: } catch (ClassNotFoundException e) {
36: System.exit( 1 );
37: }
38: String url = "jdbc:odbc:OrdersDriver";
39: Connection conn = DriverManager.getConnection(url,"rpasenko","mpf8eub");
40: Statement stmt = conn.createStatement();
41: String creditCard = null;
42: if (dialogPanel.visaBox.isSelected()) {
43: creditCard = "Visa";
44: } else if (dialogPanel.mcBox.isSelected()) {
45: creditCard = "MasterCard";
46: } else if ( dialogPanel.discoverBox.isSelected() ) {
47: creditCard = "Discover";
48: }
49: Calendar cal = Calendar.getInstance();
50: String orderNo = String.valueOf(cal.get(cal.MONTH)+1) +
51: String.valueOf(cal.get(cal.DAY_OF_MONTH)) +
52: String.valueOf(cal.get(cal.YEAR)) +
53: String.valueOf(cal.get(cal.HOUR)) +
54: String.valueOf(cal.get(cal.MINUTE)) +
55: String.valueOf(cal.get(cal.SECOND));
56: String insertString;
57: insertString = "INSERT INTO Beetles VALUES( " +
58: "'" + dialogPanel.nameField.getText() + "'," +
59: "'" + dialogPanel.addressField.getText() + "'," +
60: "'" + dialogPanel.cityField.getText() + "'," +
61: "'" + dialogPanel.stateField.getText() + "'," +
62: "'" + dialogPanel.zipField.getText() + "'," +
63: "'" + dialogPanel.emailField.getText() + "'," +
64: "'" + creditCard + "'," +
65: "'" + orderNo + "')";
66: stmt.executeUpdate(insertString);
67: stmt.close();
68: conn.commit();
69: conn.close();
70: }
71: }
72: }