hov ikke den kode ;)
det er denne her:
/*
* showDB.java
*
* Created on 15. maj 2007, 01:51
*/
import java.awt.event.ActionEvent;
import java.io.*;
import java.net.*;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import javax.servlet.*;
import javax.servlet.http.*;
/**
*
* @author Martin CBS
* @version
*/
public class showGoods extends HttpServlet {
private String varenummer;
private String pris;
private String antal;
private String varenavn;
private String ende = ",-";
ArrayList Orders = new ArrayList();
/** Processes requests for both HTTP <code>GET</code> and <code>POST</code> methods.
* @param request servlet request
* @param response servlet response
*/
protected void processRequest(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType("text/html;charset=UTF-8");
PrintWriter out = response.getWriter();
showGoods(out, request);
out.close();
}
public void showGoods (PrintWriter out, HttpServletRequest request)
{
out.println("<FORM method=\"POST\" ACTION=\"sureorder\">");
//Start tabel
out.println("<table border=\"1\">");
out.println("<thead>");
out.println("<tr>");
out.println("<th>Varenummer:</th>");
out.println("<th>Pris: </th>");
out.println("<th>Antal på lager:</th>");
out.println("<th>Varenavn: </th>");
out.println("</tr>");
out.println("</thead>");
out.println("<tbody>");
//hent maks antal prod
ArrayList Orders = hentVarer();
try {
Connection con = connectTilDB();
Statement stmt = con.createStatement();
for(int i = 1; i<= Orders.size(); i++)
{
String query = "select varenummer, pris, antal, varenavn from varer where varenummer = " + '"' + i + '"';
ResultSet rs = stmt.executeQuery(query);
if (rs.next()) {
//id = rs.getString("id");
varenummer = rs.getString("varenummer");
pris = rs.getString("pris");
antal = rs.getString("antal");
varenavn = rs.getString("varenavn");
}
//Print alle produkterne
out.println("<tr>");
out.println("<td>" + varenummer + "</td>");
out.println("<td>" + pris + " " + ende + "</td>");
out.println("<td>" + antal + "</td>");
out.println("<td>" + varenavn + "</td>");
out.println("<td><input type=\"checkbox\" name=\"order" + i + "\" /></td>");
out.println("</tr>");
}
con.close();
}//try
catch(SQLException e) {
System.err.println("SQLException: " + e.getMessage());
}
//slut tabel
out.println("</table>");
out.println("<INPUT TYPE=\"SUBMIT\" VALUE=\"Tilføj markerede\">");
//slut form
out.println("</FORM>");
}
public ArrayList hentVarer() {
ArrayList orders = new ArrayList();
try {
Connection con = connectTilDB();
Statement stmt = con.createStatement();
//henter alle varer
String query = "select varenummer from varer";
ResultSet rs = stmt.executeQuery(query);
while (rs.next()) {
String ord = rs.getString("varenummer");
orders.add(ord);
}
}
catch(SQLException e) {
System.err.println("SQLException: " + e.getMessage());
}
return orders;
}
private Connection connectTilDB()
{
Connection con = null;
try{
Class.forName("com.mysql.jdbc.Driver");
con = DriverManager.getConnection("jdbc:
mysql://localhost:3306/adminlogin","root","");
} catch(java.lang.ClassNotFoundException e) {
System.err.println("ClassNotFoundException: " + e.getMessage());
} catch(SQLException e) {
System.err.println("SQLException: " + e.getMessage());
}
return con;
}
// <editor-fold defaultstate="collapsed" desc="HttpServlet methods. Click on the + sign on the left to edit the code.">
/** Handles the HTTP <code>GET</code> method.
* @param request servlet request
* @param response servlet response
*/
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
processRequest(request, response);
}
/** Handles the HTTP <code>POST</code> method.
* @param request servlet request
* @param response servlet response
*/
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
processRequest(request, response);
}
/** Returns a short description of the servlet.
*/
public String getServletInfo() {
return "Short description";
}
// </editor-fold>
}
