import java.sql.*;
public class InsertTransaction {
public static void main(String args[]) {
String url = "jdbc:odbc:dbtest";
Connection con;
Statement stmt;
String query = "select * from TRANSACTION";
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
} catch(java.lang.ClassNotFoundException e) {
System.err.print("ClassNotFoundException: ");
System.err.println(e.getMessage());
}
try {
con = DriverManager.getConnection(url, "admin", "admin");
stmt = con.createStatement();
stmt.executeUpdate("insert into TRANSACTION " +
"values(500, 100, 'T0010', 1, 1200.00, #1/8/2000#)");
stmt.executeUpdate("insert into TRANSACTION " +
"values(501, 101, 'V100', 2, 1000.00, #2/20/2000#)");
ResultSet rs = stmt.executeQuery(query);
System.out.println("T_ID C_ID P_CODE T_NUM T_TOTAL_PRICE T_DATE");
while (rs.next()) {
int i = rs.getInt("T_ID");
int i1 = rs.getInt("C_ID");
String s = rs.getString("P_CODE");
int i2 = rs.getInt("T_NUM");
float f = rs.getFloat("T_TOTAL_PRICE");
Date d = rs.getDate("T_DATE");
System.out.println(i + " " + i1 + " " + s +
" " + i2 + " " + f + " " + d);
}
stmt.close();
con.close();
} catch(SQLException ex) {
System.err.println("SQLException: " + ex.getMessage());
}
}
}