Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- /*
- * To change this template, choose Tools | Templates
- * and open the template in the editor.
- */
- import eskuel.CMI_SQL;
- //import java.awt.Image;
- import java.io.*;
- import java.sql.ResultSet;
- import javax.servlet.*;
- import javax.servlet.http.*;
- /**
- *
- * @author Administrator
- */
- public class Laptops extends HttpServlet {
- //locatie database + inloggegevens
- /**
- * Processes requests for both HTTP <code>GET</code> and <code>POST</code> methods.
- * @param request servlet request
- * @param response servlet response
- */
- String databaselocatie = "jdbc:mysql://mysql.cmi-hro.nl:3306/cmi";
- String gebruikernaam = "cmi";
- String toegangscode = "";
- byte[] pic = null;
- protected void processRequest(HttpServletRequest request, HttpServletResponse response)
- throws ServletException, IOException {
- ResultSet rset=null;
- String Merk= "";
- CMI_SQL sql = new CMI_SQL(databaselocatie, gebruikernaam, toegangscode);
- // CMI_Backup b= new CMI_Backup(databaselocatie,gebruikernaam,toegangscode);
- //schrijven van laptoplijst en printen tabel na klikken link
- PrintWriter out = response.getWriter();
- try {
- try {
- rset = sql.selectieQuery("select * from Laptops");
- out.println("Kies de laptop waarvan u de gegevens wilt:<br>");
- out.println("<table>");
- while (rset.next()){
- out.println("<tr>");
- Merk = rset.getString("Merk");
- out.println("<td>"+Merk+"</td><td><a href=/Laptops/Laptops?Merk="+Merk+"><img src=/Laptops/Image?nummer="+Merk+"</a></td>");
- out.println("</tr>");
- }
- out.println("</table>");
- } catch (Exception e) {
- }
- } finally {
- out.close();
- }
- }
- // <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>
- }
Add Comment
Please, Sign In to add comment