SQL fejl: java.sql.SQLException: Before start of result set 0 S10
Hvad går der galt for mig her, Jeg får SQL fejl: java.sql.SQLException: Before start of result set 0 S10import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
import util.Databaseforbindelsemysql;
public class Ipaq extends HttpServlet
{
public void doPost(HttpServletRequest request,
HttpServletResponse response)
throws ServletException, IOException
{
PrintWriter out;
response.setContentType("text/html");
String result = request.getParameter ("result");
StringBuffer buffer = new StringBuffer();
out = response.getWriter();
buffer.append("<html><head><title>Ipaq</title><head>");
buffer.append("<body>");
Databaseforbindelsemysql d = new Databaseforbindelsemysql("jdbc:mysql://192.168.1.12/DB?user=USER&password=PASS","com.mysql.jdbc.Driver");
StringBuffer bu = new StringBuffer();
bu.append("select k.kunde, o.ordre_id, v.vare_navn, v.vare_pris ");
bu.append("from kunder k, ");
bu.append("ordre o, ");
bu.append("ordre_linie ol, ");
bu.append("varer v ");
bu.append("where k.kunde_id = '"+result+"'");
bu.append(" and k.kunde_id = o.kunde_id");
bu.append(" and o.ordre_id = ol.ordre_id");
bu.append(" and ol.vare_id = v.vare_id;");
ResultSet rs = d.select(bu.toString());
System.out.println(bu.toString());
System.out.println(result);
buffer.append(bu.toString());
try {
String kunde = rs.getString("kunde");
buffer.append("<h3>"+kunde+"</h3>");
buffer.append("<table border=\"1\">");
buffer.append("<tr>");
buffer.append("<th>Ordre nr.</th>");
buffer.append("<th>Vare</th>");
buffer.append("<th>Pris</th>");
buffer.append("</tr>");
while (rs.next()) {
String ordreID = rs.getString("ordre_id");
String vare = rs.getString("vare_navn");
String pris = rs.getString("vare_pris");
buffer.append("<tr>");
buffer.append("<td>"+ordreID+"</td>");
buffer.append("<td>"+vare+"</td>");
buffer.append("<td>"+pris+"</td>");
buffer.append("</tr>");
}
buffer.append("</table>");
buffer.append("</body>");
buffer.append("</html>");
} catch (SQLException s) {
buffer.append("<h3>SQL fejl: " + s.toString() + " "
+ s.getErrorCode() + " " + s.getSQLState() + "</h3>");
}
out.println(buffer.toString());
out.close();
d.close();
}
}
