Client-Side Presentation Logic
621
We will not examine sqlBean here, since it is the file we created earlier. The program again makes use
of the Ælfred SAX2 parser available within the aelfred.jar file.
Here is the databaseBean.java, it has two methods; the first takes sufficient parameters about a sell-
off to register it on the database. The second cleans out the whole database. Here is the code for it:
import java.sql.Statement;
public class databaseBean extends com.wrox.pjxml.sqlBean {
String myAppend1 = "insert into hotdeals (startdate, region," +
" duration, location, price, commission) values ('";
String myAppend2 = "','";
String myAppend3 = "')";
public queryBean() {super();}
public boolean addTrip(String startdate,
String region,
String duration,
String location,
String price,
String commission)
throws Exception {
String myQuery = myAppend1 + startdate + myAppend2 + region + myAppend2 +
duration + myAppend2 + location + myAppend2 + price +
myAppend2 + commission + myAppend3;
Statement stmt = myConn.createStatement();
return (stmt.executeUpdate(myQuery) == 1);
}
public void clean()throws Exception {
Statement stmt = myConn.createStatement();
stmt.execute("delete from hotdeals");
}
}
Here is ParseHandler.java. The ParseHandler class handles the parsing of the incoming XML
data file. Note the inheritance from the default HandlerBase class.
class ParseHandler extends com.microstar.xml.HandlerBase {
String lastParsedText = null;
String lastParsedStart = null;
String lastParsedLoc = null;
String lastParsedDur = null;
String lastParsedPri = null;
String lastParsedCom = null;
String lastParsedRegion = null;