Home
JAVA JDBC
Deleting Records
Here is a sample code to Delete records from the database
import java.sql.*; import javax.servlet.http.*; import javax.servlet.*; import java.io.*; public class update extends HttpServlet { Connection con; String name,email; int age; String dsn; String strsql; Statement stmt; public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { PrintWriter pw = response.getWriter(); dsn = "Jdbc:Odbc:dsninfo"; name = request.getParameter("txtname"); age = Integer.parseInt(request.getParameter("txtage")); email=request.getParameter("txtemail"); try{ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); }catch (ClassNotFoundException cfe) {} try{ con=DriverManager.getConnection(dsn); stmt = con.createStatement(); strsql = "delete from userinfo where name = '" + name +"'"; stmt.executeUpdate(strsql); pw.println("Succesfully Deleted"); stmt.close(); pw.close(); con.close(); }catch (SQLException se) { System.out.println(se); } } }
Previous
Next