CIS297, Database

From MCIS Wiki

Java mySql

Make sure you have the mySql jdbc library in your compile-time libraries.

The original code is over here: User:Hickman/CIS297/Java_DB_Project.

Below is an example of retrieving recordsets for tables that you don't know much about.

Class.forName("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection(jdbc:mysql://mcis.western.edu:3306, username, password);
Statement stmnt = con.createStatement();
stmnt.execute("use cis297");
stmnt.executeQuery("show columns from InvoiceItemXX;");
ResultSet rs1 = stmnt.getResultSet();
ArrayList<String> fields = new ArrayList<String>();
ArrayList<String> types = new ArrayList<String>();
while(rs1.next()) {
     fields.add(rs1.getString("Field"));
     types.add(rs1.getString("Type"));
}
stmnt.executeQuery("select * from InvoiceItemKE;");
ResultSet rs = stmnt.getResultSet();
for (int i = 0; i < fields.size(); i++) {
     System.out.print(fields.get(i)+", ");
}
System.out.println("");
while(rs.next()) {
     for (int i = 0; i < fields.size(); i++) {
         System.out.print(rs.getString(fields.get(i))+", ");
     }
     System.out.println("");
}