mainframe.java

  private void databaseInit() throws Exception{
    Class.forName("com.extendedsystems.jdbc.advantage.ADSDriver");
    conn = DriverManager.getConnection("jdbc:extendedsystems:" +
      "advantage://server:6262/share/adsbook/" +
      "demodictionary.add;user=adsuser;password=password");
    stmt = conn.createStatement();
    prepStmt = conn.prepareStatement( "SELECT * FROM INVOICE "+
      "WHERE [customer id] = ?" );
  }