");
out.println(insertString);
try{
stmt.executeUpdate(insertString);
} catch (SQLException e){
System.out.println(e.getMessage());
e.printStackTrace();
} // end try
} //end insertPerson
public void viewPeople(PrintWriter out){
//runs a query on people table, spits out result
out.println(exQ("Select * from people"));
} // end view people
public void viewCity(PrintWriter out){
//runs a query on city table, spits out result
out.println(exQ("Select * from city"));
} // end view people
public void viewData(PrintWriter out){
//runs a joined query on people, city table, spits out result
out.println(exQ("Select FName, LName, City.name from people INNER JOIN city on people.city = city.id"));
} // end view people
public String exQ(String query){
//handles all queries which use executeQuery
String result = "";
System.out.println(query);
try {
ResultSet rs = stmt.executeQuery(query);
result = createHTMLTable(rs);
} catch (SQLException e){
System.out.println(e.getMessage());
e.printStackTrace();
} // end try
return result;
} // end exQ
public String createHTMLTable(ResultSet rs) throws SQLException{
//takes in a resultset and prints out an HTML table
ResultSetMetaData rsmd = rs.getMetaData();
String HTMLOut = "";
HTMLOut += "