|
import java.sql.*;import
java.io.*;import javax.servlet.*;import javax.servlet.http.*;
public class UsefulAddresses extends HttpServlet { // Class Definition starts here private String url="jdbc:mysql://localhost/DundeeInfoService"; private Connection con = null; public void init(ServletConfig config) throws ServletException { super.init(config); try { // Loads the driver Class.forName("org.gjt.mm.mysql.Driver"); // Get a Connection to the database con = DriverManager.getConnection (url); } catch (Exception E) { System.err.println("Unable to load driver."); E.printStackTrace(); } // end catch } public void doGet(HttpServletRequest req, HttpServletResponse res) throws ServletException, IOException { // doget method starts Statement stmt = null;String query; res.setContentType("text/html"); PrintWriter out = res.getWriter(); try { stmt = con.createStatement(); query =
"SELECT TeleNumber, OpeningHours, UsefulAddname, StreetNum,
Address1, Address2, Postcode, AccessComments FROM UsefulAddresses"; ResultSet result = stmt.executeQuery(query); String usefulAddNameResult[]; String teleNumberResult[]; // Initialise arrays to contain database info String openingHoursResult[]; etc................... usefulAddNameResult = new String[6]; teleNumberResult = new String[6]; // Dynamically allocate array space required openingHoursResult = new String[6]; etc...................
int loop=0;
while(result.next()) { // Loops until last row in table is found usefulAddNameResult[loop] = result.getString("UsefulAddname"); // assignsvalues in the named column to this variable array streetNumResult[loop] = result.getString("StreetNum"); if (streetNumResult[loop] == null) { streetNumResult[loop] = ""; // If the address has no street number thenstops null being displayed } address1Result[loop] = result.getString("Address1"); address2Result[loop] = result.getString("Address2"); etc................ loop++; } //Display the result set in a HTML table out.println("<html><?xml version=\"1.0\"?>"); out.println("<wml>"); out.println("<card id=\"ShopMob\" title=\"useful info\"> "); out.println("<p mode=\"nowrap\">Tele No <strong>" + teleNumberResult[0] +"</strong><br/> "); out.println("Address <strong>" + streetNumResult[0] + " " +address1Result[0] + " " + address2Result[0] + " " + postcodeResult[0] +"</strong><br/> "); out.println("Opening Hours <strong>" + openingHoursResult[0] +"</strong></p> "); out.println("<p mode=\"wrap\">Comments <strong>" +accessCommentsResult[0] + "</strong> "); out.println("</p>"); out.println("</card>"); etc................... } // end try catch(SQLException e) { out.println("SQLException caught: " + e.getMessage()); } |
