JAVA og MySQL
Hej jeg prøver at få min JAVA til at printe en liste ud i enkelt tabeller (som gæstebog) på min hjemmeside. JEg kan ikke helt forstå hvad der går galt... håber virkelig nogen kan se problemmet./*
* VisGeasteServlet.java
*
* Created on February 6, 2007, 1:33 PM
*/
package my.company;
import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.sql.*;
import java.util.*;
public class VisGeasteServlet extends HttpServlet {
public void doPost( HttpServletRequest request, HttpServletResponse response )
throws ServletException, IOException {
//String startKnap = request.getParameter( "StartKnap" );
//String valgKnap = request.getParameter( "ValgKnap" );
response.setContentType("text/html");
PrintWriter out = response.getWriter();
//if (startKnap != null)
//visGeasteListe(out);
//else {
//String valgtGeaste = request.getParameter( "geasteSort" );
findOgVisGeaste(out);
//}
out.close();
}
/**
public void visGeasteListe(PrintWriter out) {
skrivStartPaaSide(out, "Vis side for geastedemo");
ArrayList geasteSorter = hentGeasteSorter();
out.println("<h2>VÊlg hvilken geastesort du vil se nÊrmere pÂ</h2>");
out.println("<form method=\"post\" action=\"VisGeasteServlet\">");
out.println("<select name=\"geasteSort\" size=\"4\" multiple>");
// IndsÊt kaffesorterne i listboxen p html-siden
Iterator ite = geasteSorter.iterator();
while (ite.hasNext()) {
String geasteSort = (String) ite.next();
out.println("<option selected value=\"" + geasteSort + "\">" + geasteSort + "</option>");
}
out.println("</select><br><br>");
out.println("<input type=\"submit\" name=\"ValgKnap\" value=\"Vis kaffesort\">");
out.println("</form>");
skrivSlutPaaSide(out);
}
*/
public void findOgVisGeaste(PrintWriter out) {
skrivStartPaaSide(out, "List of all");
try {
Connection con = connectTilDB();
Statement stmt = con.createStatement();
//hent leverand¯r og pris for den valgte kaffesort
//String query = "select name, mail, Message from geastelist where idnumber = " + '"' + i + '"';
//ResultSet rs = stmt.executeQuery(query);
ResultSet rs = stmt.executeQuery("SELECT * FROM geastelist;");
while ( rs.next() ) {
// String idnumber1 = null;
//String mail1 = null;
//String message1 = null;
//if (rs.next()) {
int idnumber1 = rs.getInt("idnumber");
String mail1 = rs.getString("mail");
String message1 = rs.getString("Message");
String navn1 =rs.getString("navn");
out.println("<table width=\"300\">");
out.println("<tr>");
out.println("<td>Person</td>");
out.println("<td> list of messages nr: </td>");
out.println("</tr>");
out.println("<tr>");
out.println("<td>ID number</td>");
out.println("<td>" + idnumber1 + "</td>");
out.println("</tr>");
out.println("<tr>");
out.println("<td>Mail</td>");
out.println("<td>" + mail1 + "</td>");
out.println("</tr>");
out.println("<tr>");
out.println("<td>Message</td>");
out.println("<td>" + message1 + "</td>");
out.println("</tr>");
out.println("</table>");
// }
}
int idnumber = rs.getInt("idnumber");
String mail = rs.getString("mail");
String message = rs.getString("Message");
String navn =rs.getString("navn");
out.println("<table width=\"300\">");
out.println("<tr>");
out.println("<td>Person</td>");
out.println("<td> list of messages nr: </td>");
out.println("</tr>");
out.println("<tr>");
out.println("<td>ID number</td>");
out.println("<td>" + idnumber + "</td>");
out.println("</tr>");
out.println("<tr>");
out.println("<td>Mail</td>");
out.println("<td>" + mail + "</td>");
out.println("</tr>");
out.println("<tr>");
out.println("<td>Message</td>");
out.println("<td>" + message + "</td>");
out.println("</tr>");
out.println("</table>");
con.close();
} catch(SQLException e) {
System.err.println("SQLException: " + e.getMessage());
out.println("fejl");
}
out.println("hej med dig din spade!");
skrivSlutPaaSide(out);
}
Start på side omitted
public void skrivSlutPaaSide(PrintWriter out) {
out.println("</div>");
out.println("</body>");
out.println("</html>");
}
public ArrayList hentGeasteSorter() {
ArrayList geasteSorter = new ArrayList();
try {
Connection con = connectTilDB();
Statement stmt = con.createStatement();
//hent kaffenavn for alle kaffesorter
String query = "select idnumber from geastelist";
ResultSet rs = stmt.executeQuery(query);
while (rs.next()) {
String geasteName = rs.getString("idnumber");
geasteSorter.add(geasteName);
}
con.close();
} catch(SQLException e) {
System.err.println("SQLException: " + e.getMessage());
}
return geasteSorter;
}
public Connection connectTilDB() {
Connection con = null;
try {
Class.forName("com.mysql.jdbc.Driver");
con = DriverManager.getConnection(
"jdbc:mysql://localhost:3306/geastebog","root","");
} catch(java.lang.ClassNotFoundException e) {
System.err.println("ClassNotFoundException: " + e.getMessage());
} catch(SQLException e) {
System.err.println("SQLException: " + e.getMessage());
}
return con;
}
}
