Ok so for our Uni project we are making a website to store information about churches (I know super interesting right -.-).Basicly it just needs to have church information in a database and when a user clicks or searchs for a church it needs to pull the church information along with user comments from the database.So far I have a HTML form that delivers a comment to the servlet/database and outputs it using a resultset. I was just wondering what the best method would be for handling multiple information as now that I'm trying to deliver both comments and the church information I'm kinda lost as to how to store it.Thanks in advance!Ow and here is my code for reference:HTML\[code\] <form method="get" action="dbtest" id="form1"> <fieldset> <p>Please enter you're Name:</p> <input type="text" name="author" size="10" id="name"/><br /> <p>Please enter you're Email here:</p> <input type="text" name="author_email" size="10" id="email"/><br /> <p>Please enter you're comment here:</p> <input type="text" name="comment_text" size="10" id="comment"/><br /> <p> <input type="submit" value="http://stackoverflow.com/questions/13749592/Submit" name="submit_button" /> </p> </fieldset> </form>\[/code\]Servlet\[code\]import java.io.IOException;import java.io.PrintWriter;import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.Statement;import javax.servlet.ServletException;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;/** * * @author mxk12ycu */public class dbtest extends HttpServlet { /** * Processes requests for both HTTP * <code>GET</code> and * <code>POST</code> methods. * * @param request servlet request * @param response servlet response * @throws ServletException if a servlet-specific error occurs * @throws IOException if an I/O error occurs */ protected void processRequest(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { response.setContentType("text/html;charset=UTF-8"); PrintWriter out = response.getWriter(); String authorName = request.getParameter("author"); String authorEmail = request.getParameter("author_email"); String commentText = request.getParameter("comment_text"); try { //Holding SQL statement String SQL; String insertSQL; //insertSQL = "INSERT INTO comments VALUES('0002')" + authorName + authorEmail + commentText + ("('29 Nov 2012','002')"); //insertSQL = "INSERT INTO comments VALUES (default,'Ryan H','[email protected]','TestComments','29 Nov 2012','1')"; //insertSQL = "INSERT INTO comments (author, author_email, comment_text, comment_date, church_id) VALUES ('" + authorName + "'," + "'" + authorEmail + "'," + "'" + commentText + "', '29 Nov 2012', '1')"; //insertSQL = "INSERT INTO comments VALUES ('Ryan Holder', '[email protected]', 'Comment here', '30 Nov 2012', 'default', '1')"; insertSQL = "INSERT INTO comments VALUES (default, " + "'" + authorName + "'," + "'" + authorEmail + "'," + "'" + commentText + "', '29 Nov 2012', '1')"; SQL = "SELECT * FROM churches, comments"; Class.forName("org.postgresql.Driver"); Connection connection = DriverManager.getConnection( "jdbc
ostgresql:ChurchSearch", "postgres", "*****"); Statement statement = connection.createStatement(); statement.executeUpdate(insertSQL); ResultSet resultSet = statement.executeQuery(SQL); /* TODO output your page here. You may use following sample code. */ out.println("<html>"); out.println("<head>"); out.println("<title>Test Comment Servlet</title>"); out.println("</head>"); out.println("<body>"); out.println("<h1>Servlet test at " + request.getContextPath() + "</h1>"); out.println("<h2>Comment Form</h2>"); while (resultSet.next()) { out.println("<p>"); out.println(resultSet.getString("author")); out.println("</p>"); out.println("<p>"); out.println(resultSet.getString("author_email")); out.println("</p>"); out.println("<p>"); out.println(resultSet.getString("comment_text")); out.println("</p>"); } out.println("</body>"); out.println("</html>"); connection.close(); } catch (Exception e) { System.err.println("Error: " + e); } finally { out.close(); } }\[/code\]
ostgresql:ChurchSearch", "postgres", "*****"); Statement statement = connection.createStatement(); statement.executeUpdate(insertSQL); ResultSet resultSet = statement.executeQuery(SQL); /* TODO output your page here. You may use following sample code. */ out.println("<html>"); out.println("<head>"); out.println("<title>Test Comment Servlet</title>"); out.println("</head>"); out.println("<body>"); out.println("<h1>Servlet test at " + request.getContextPath() + "</h1>"); out.println("<h2>Comment Form</h2>"); while (resultSet.next()) { out.println("<p>"); out.println(resultSet.getString("author")); out.println("</p>"); out.println("<p>"); out.println(resultSet.getString("author_email")); out.println("</p>"); out.println("<p>"); out.println(resultSet.getString("comment_text")); out.println("</p>"); } out.println("</body>"); out.println("</html>"); connection.close(); } catch (Exception e) { System.err.println("Error: " + e); } finally { out.close(); } }\[/code\]