Course.java (Online at www.xp123.com/rwb )import java.sql.*; public class Course { private String name; private int credits; static String url = "jdbc:odbc:Reggie"; static { try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); } catch (Exception ignored) {} } public static Course create(String name, int credits) throws Exception { Connection conn = null; try { conn = DriverManager.getConnection(url, "", ""); Statement statement = conn.createStatement(); statement.executeUpdate( "DELETE FROM course WHERE name = '" + name + "';"); statement.executeUpdate( "INSERT INTO course VALUES ('" + name + "', '" + credits + "');"); return new Course(name, credits); } finally { try { conn.close(); } catch (Exception ignored) {} } } public static Course find(String name) { Connection conn = null; try { conn = DriverManager.getConnection(url, "", ""); Statement statement = conn.createStatement(); ResultSet result = statement.executeQuery( "SELECT * FROM course WHERE Name = '" + name + "';"); if (!result.next()) return null; int credits = result.getInt("Credits"); return new Course(name, credits); } catch (Exception ex) { return null; } finally { try { conn.close(); } catch (Exception ignored) {} } } public void update() throws Exception { Connection conn = null; try { conn = DriverManager.getConnection(url, "", ""); Statement statement = conn.createStatement(); statement.executeUpdate( "DELETE FROM COURSE WHERE name = '" + name + "';"); statement.executeUpdate( "INSERT INTO course VALUES('" + name + "','" + credits + "');"); } finally { try { conn.close(); } catch (Exception ignored) {} } } Course(String name, int credits) { this.name = name; this.credits = credits; } public int getCredits() { return credits; } public String getName() { return name; } } |