@Override
public void endElement(String s, String s1, String element) throws SAXException {
// if end of book element add to list
if (element.equals("deptname")) {
DeptNameLst.add(depttmp);
}
if (element.equals("gradstudent")) {
GradStudentLst.add(gstmp);
}
if (element.equals("undergradstudent")) {
UndGdStudentLst.add(undtmp);
}
if (element.equals("staff")) {
StaffLst.add(stftmp);
}
if (element.equals("faculty")) {
FacultyLst.add(fcttmp);
}
if (element.equals("deptname")) {
depttmp.setDeptname(tempval);
}
if (element.equals("phone")) {
if (flaggs) {
gstmp.setPhone(Integer.parseInt(tempval));
}
if (flagstaff) {
stftmp.setPhone(Integer.parseInt(tempval));
}
if (flagfaculty) {
fcttmp.setPhone(Integer.parseInt(tempval));
}
if (flagund) {
undtmp.setPhone(Integer.parseInt(tempval));
}
}
if (element.equals("email")) {
if (flaggs) {
gstmp.setEmail(tempval);
}
if (flagstaff) {
stftmp.setEmail(tempval);
}
if (flagfaculty) {
fcttmp.setEmail(tempval);
}
if (flagund) {
undtmp.setEmail(tempval);
}
}
if (element.equals("office")) {
if (flaggs) {
gstmp.setOffice(Integer.parseInt(tempval));
}
if (flagstaff) {
stftmp.setOffice(Integer.parseInt(tempval));
}
if (flagfaculty) {
fcttmp.setOffice(Integer.parseInt(tempval));
}
if (flagund) {
undtmp.setOffice(Integer.parseInt(tempval));
}
}
if (element.equals("url")) {
if (flaggs) {
gstmp.setUrl(tempval);
}
if (flagund) {
undtmp.setUrl(tempval);
}
}
if (element.equals("gpa")) {
if (flaggs) {
gstmp.setGpa(tempval);
}
if (flagund) {
undtmp.setGpa(tempval);
}
}
if (element.equals("firstname")) {
if (flaggs) {
gstmp.setFirstname(tempval);
}
if (flagstaff) {
stftmp.setFirstname(tempval);
}
if (flagfaculty) {
fcttmp.setFirstname(tempval);
}
if (flagund) {
undtmp.setFirstname(tempval);
}
}
if (element.equals("lastname")) {
if (flaggs) {
gstmp.setLastname(tempval);
}
if (flagstaff) {
stftmp.setLastname(tempval);
}
if (flagfaculty) {
fcttmp.setLastname(tempval);
}
if (flagund) {
undtmp.setLastname(tempval);
}
}
if (element.equals("zip")) {
if (flaggs) {
gstmp.setZip(tempval);
}
if (flagund) {
undtmp.setZip(tempval);
}
}
if (element.equals("state")) {
if (flaggs) {
gstmp.setState(tempval);
}
if (flagund) {
undtmp.setState(tempval);
}
}
if (element.equals("city")) {
if (flaggs) {
gstmp.setCity(tempval);
}
if (flagund) {
undtmp.setCity(tempval);
}
}
}
// Uses SQL Injection to insert data into Graduate Table
private void insertDataGrad() {
Connection c = null;
try {
Class.forName("org.sqlite.JDBC");
c = DriverManager.getConnection("jdbc:sqlite:C:/Users/SRV/Desktop/project8");
String sql =
"insert into gradstudents (gid,lastname, firstname, phone, email, city, state, zip, office, url, gpa) "
+ "values (?, ?, ?,?,?,?,?,?,?,?,?)";
PreparedStatement prespstat = c.prepareStatement(sql);
for (GradStudent tmpdata : GradStudentLst) {
prespstat.setString(1, null);
prespstat.setString(2, tmpdata.getLastname());
prespstat.setString(3, tmpdata.getFirstname());
prespstat.setInt(4, tmpdata.getPhone());
prespstat.setString(5, tmpdata.getEmail());
prespstat.setString(6, tmpdata.getCity());
prespstat.setString(7, tmpdata.getState());
prespstat.setString(8, tmpdata.getZip());
prespstat.setInt(9, tmpdata.getOffice());
prespstat.setString(10, tmpdata.getUrl());
prespstat.setString(11, tmpdata.getGpa());
prespstat.addBatch();
}
prespstat.executeBatch();
prespstat.close();
c.close();
} catch (Exception e) {
System.err.println(e.getClass().getName() + ": " + e.getMessage());
System.exit(0);
}
System.out.println("Database Inserted Successfully");
}
