@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"); }