[QUOTE=Dragon_EPT;14362]what i want is that everytime i add something to my sell table the stocks table deletes<html><body><%@ page import="java.sql.*"%><%@ page import="java.util.*"%><%@ page import="java.util.*"%><%try { Connection con; Statement stmt; ResultSet rs; String brokers = request.getParameter("brokers"); String stock = request.getParameter("stock"); String qty = request.getParameter("qty"); String price = request.getParameter("price"); Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); con = DriverManager.getConnection("jdbc:odbc:sherwin","",""); stmt = con.createStatement(); rs = stmt.executeQuery("INSERT INTO sell (brokers,stock,qty,price) VALUES ('"+brokers+"','"+stock+"','"+qty+"','"+price+"')"); rs = stmt.executeQuery("DELETE FROM stocks WHERE brokers = 'one'"); response.sendRedirect("main.jsp"); con.close();} catch (Exception e){ System.out.println("SQL Exception : " + e.getMessage());}response.sendRedirect("main.jsp");%></body></html>[/QUOTE]
add at the same time delete
Posted - 2008-01-18 : 19:35:34
