hej eksperter jeg har et problem med at fjærne en vare fra min indkøbskurv varen er lagt i en forespørgsel i access database her er min kode:
try { stat.executeUpdate("DELETE * FROM indholdAfKurv WHERE antal = '" +request.getParameter("antal")+"' AND vareNavn = '"+request.getParameter("vareNavn")+"' AND pris = '"+request.getParameter("pris")+"' "); } catch (Exception ex) { System.out.println("Det er fejl med DELETE FROM: " + ex.getMessage());
} her er fejl meddelelsen fra JB
Det er fejl med DELETE FROM: [Microsoft][ODBC Microsoft Access-driver] Der kan ikke slettes fra de angivne tabeller.
I dette særtema ser vi på, hvordan cloud og AI bliver fundamentet for virksomhedernes digitale forretning, og hvordan de nye muligheder for automatisering og forretningsværdi kan udnyttes uden at miste overblik, sikkerhed og menneskelig kontrol.
stat.executeUpdate("DELETE FROM indholdAfKurv WHERE antal = " +request.getParameter("antal")+" AND vareNavn = '"+request.getParameter("vareNavn")+"' AND pris = "+request.getParameter("pris"));
public class kurvTilfojSlet extends HttpServlet { static final private String CONTENT_TYPE = "text/html"; //Initialize global variables final String dbDriver = "sun.jdbc.odbc.JdbcOdbcDriver"; final String dbUrl = "jdbc:odbc:projekt"; Connection dbConn = null; private Statement stat = null; private String ud= null; ResultSet rs =null; public void init() throws ServletException { try { // Get driver for the database Class.forName( dbDriver ).newInstance(); // Open connection to the database dbConn = DriverManager.getConnection(dbUrl); } // Catch sentences print out information about the error that has occoured catch (ClassNotFoundException e) { System.err.println("Class not found: " + e); } catch (InstantiationException e) { System.err.println("InstantiationException: " + e); } catch (IllegalAccessException e) { System.err.println("IllegalAccessException: " + e); } catch (SQLException E) { System.err.println("SQLException: " + E.getMessage()); System.err.println("SQLState: " + E.getSQLState()); System.err.println("VendorError: " + E.getErrorCode()); } } //Process the HTTP Get request public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { response.setContentType(CONTENT_TYPE); PrintWriter out = response.getWriter();
try {
stat.executeUpdate("DELETE * FROM indholdAfKurv WHERE antal = '" +request.getParameter("antal")+"' AND vareNavn = '"+request.getParameter("vareNavn")+"' AND pris = '"+request.getParameter("pris")+"' "); } catch (Exception ex) { System.out.println("Det er fejl med DELETE FROM: " + ex.getMessage());
} try { stat = dbConn.createStatement();
out.println( "<head><title>Indhold af din kurv</title>"); out.println("<body background='images/frame4back.jpg' style='background-attachment: fixed'>"); out.println("</head><body><br/><p><b>Indhold af din kurv</b></p>"); out.println("<table border=2 width=90%>"); out.println("<tr>"); out.println("<th>Vare navn</th><th>Antal</th><th>Pris</th><th>Sum</th></tr>");
rs = stat.executeQuery("SELECT * from indholdAfKurv");
while(rs.next()) { String ud = " <td class = 'right bold'>Vare navn:</td>"+ "<td><input type = 'text' value = "+rs.getString("vareNavn")+" name = 'vareNavn' size = '20' />"+ "</td>"+ "<td class = 'right bold'>Antal af vare:</td>"+ "<td><input type = 'text' value = "+rs.getString("antal")+" name = 'antal' size = '20' />"+ "</td>"+ "<td class = 'right bold'>pris:</td>"+ "<td><input type = 'text' value = "+rs.getString("pris")+" name = 'pris' size = '20' />"+ "</td>"+ "<td class = 'right bold'>Sum:</td>"+ "<td><input type = 'text' value = "+rs.getString("Sum")+" name = 'Sum' size = '20' />"+ "</td>"+ "<form action='/kurvtilfojslet' method='get'>"+ "<td><p align='left'><input type='submit' id=Submit' value='Slet'></p>" + "</form>"+
rs = stat.executeQuery("SELECT Sum(antal*pris) from indholdAfKurv "); if(rs.next()) { int sum = rs.getInt(1);
String ud = " <td class = 'right bold'>Vare navn:</td>"+ "<td><input type = 'text' value = "+ sum +" name = 'vareNavn' size = '20' />"+ "</td>"; out.println(ud); } } catch (Exception ex) { System.out.println("Udskrivning af duregnede sum: " + ex.getMessage());
}
} //Process the HTTP Post request public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { response.setContentType(CONTENT_TYPE); PrintWriter out = response.getWriter(); out.println("<html>"); out.println("<head><title>kurvTilfojSlet</title></head>"); out.println("<body>"); out.println("<p>The servlet has received a POST. This is the reply.</p>"); out.println("</body></html>"); } //Clean up resources public void destroy() { } }
Synes godt om
Ny brugerNybegynder
Din løsning...
Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.