confirm delete

Home Answers Viewqa JSP-Servlet confirm delete

gautamshetkar

confirm delete
2 Answer(s) 2 years and a month ago
Posted in : JSP-Servlet

Sir, I want to ask confirmation before deletion, i m using submit button then the form is passed to servlet for deletion,Please help Thanks in advance

View Answers

April 20, 2011 at 10:46 AM

1)application.jsp:

<%@ page import="java.sql.*" %>
<html>
<head>
<script language="javascript">
function deleteRecord(id){
    var doIt=confirm('Do you want to delete the record?');
  if(doIt){
   var f=document.form;
    f.method="post";
    f.action='../DeleteServlet?id='+id;
    f.submit();
    }
  else{

    }
}
</script>
</head>
<body>

<br><br>
<form method="post" name="form">
<table border="1">
<tr><th>Name</th><th>Address</th><th>Contact No</th><th>Email</th></tr>
<%
Connection con = null;
String url = "jdbc:mysql://localhost:3306/";
String db = "test";
String driver = "com.mysql.jdbc.Driver";
String userName ="root";
String password="root";

int sumcount=0;
Statement st;
try{
Class.forName(driver).newInstance();
con = DriverManager.getConnection(url+db,userName,password);
String query = "select * from employee";
st = con.createStatement();
ResultSet rs = st.executeQuery(query);
%>
<%
while(rs.next()){
%>
<tr><td><%=rs.getString(2)%></td>
<td><%=rs.getString(3)%></td>
<td><%=rs.getString(4)%></td>
<td><%=rs.getString(5)%></td>
<td><input type="button" name="delete" value="Delete" style="background-color:red;font-weight:bold;color:#ffffff;" onclick="deleteRecord(<%=rs.getString(1)%>);" ></td>
</tr>
<%
}
%>
<%
}
catch(Exception e){
e.printStackTrace();
}
%>
</table>
</form>
</body>
</html>

2)DeleteServlet.java:

import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;

public class DeleteServlet extends HttpServlet { 
    public void doPost(HttpServletRequest request,HttpServletResponse response) throws ServletException,IOException {
        response.setContentType("text/html");
        PrintWriter out = response.getWriter();
String id=request.getParameter("id");
int no=Integer.parseInt(id);
int sumcount=0;
try {
Class.forName("com.mysql.jdbc.Driver").newInstance();
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/test", "root", "root");
Statement st = conn.createStatement();
st.executeUpdate("DELETE FROM employee WHERE id = '"+no+"'");
response.sendRedirect("/examples/jsp/application.jsp");
}
catch(Exception e){}
    }
}

April 20, 2011 at 11:13 AM

Sir, If i choose cancel it still submits form. Please help

confirm delete
confirm delete Sir, I want to ask confirmation before deletion, i m using submit button then the form is passed to servlet for deletion,Please help Thanks in advance

Confirm problem
Confirm problem Sir i have used following code in button delete onclick="if (confirm('sure?')) submit();" and if i choose cancel it still submits the form however if choose cancel i want to remain on same jsp page please help

Servlets and confirm box
Servlets and confirm box Sir...! I want to insert or delete records form oracle based on the value of confirm box can you please give me the idea.... thanks

javascript confirm box
javascript confirm box javascript confirm box

javascript confirm yes no
javascript confirm yes no javascript confirm yes no - how to create confirm dialog box yes or no in JavaScript? if (confirm('Are You... are not redirected") } How to confirm yes or no in JavaScript

confirm message box - Java Beginners
confirm message box How can I create a confirm message with Yes... function showConfirm() { myBooleanVariable = newConfirm( 'My Confirm Title', 'My Confirm Message', 2,0,0) if (retVal==true) return true; else

Yes/No confirm box with vbscript - Framework
Yes/No confirm box with vbscript I'm using a Yes/No confirmation with vbscript. But the in the confirm box, the titiel is coming along with 'VBScript' in it. I just want to remove this 'VBScript' title, Can anyone help me

DELETE
DELETE I AM DOING IT IN MYSQL. DELETE FROM EMP WHERE SAL>(SELECT SAL FROM EMP WHERE ENAME='MILLAR') AND ENAME='ALLEN'; THIS IS GIVING THE FOLLOWING ERROR Error Code : 1093 You can't specify target table 'EMP

delete
delete how delete only one row in the database using jsp.database... type="button" name="edit" value="Delete" style="background-color:red;font-weight... = conn.createStatement(); st.executeUpdate("DELETE FROM employee WHERE empid

Delete Account
Delete Account How to delete account

how to use confirmation alert box before delete in jsp?
how to use confirmation alert box before delete in jsp? I use submit... language="javascript"> function deleteRecord(id){ var doIt=confirm('Do you want to delete the record?'); if(doIt){ var f=document.form; f.method="post

To delete post
To delete post How can I delete my old post answer. I've posted 2 same answers by mistake

delete jsp
delete jsp <%@ page language="java" contentType="text/html...; charset=ISO-8859-1"> <title>Delete Student</title> </head>...;/Controller"> <input type="hidden" name="page" value="delete"/> <

delete row
delete row how to delete row using checkbox and button in php...="delete" > <table width="100%" border="1"> <tr><td>...;/table> <input type="submit" name="delete" value="delete" /> <?php

delete record
delete record how to delete record using checkbox and button in php We are providing you the jsp code that displays the database table...=conn.createStatement(); for(int a=0;a<10;a++){ st.executeUpdate("delete from book where

delete an entry using JavaScript
delete an entry using JavaScript How to delete an entry using JavaScript

delete() method of hibernate
delete() method of hibernate Define the use of delete() method of hibernate? Example

delete javascript object
delete javascript object How to create and delete an object in JavaScript

What is the Delete Statements in SQL?
What is the Delete Statements in SQL? What is the Delete Statements in SQL? Hi, Here is the answer, Delete statement in SQL is used to delete partial/all data. Especially delete statement is useful in case

delete retailer jsp file (sir..is this a good logic.. jsp file is useful for what purpose)
delete retailer jsp file (sir..is this a good logic.. jsp file is useful...; } /*var r=confirm("Untag the products?") if(r==true) { confirm("Are you sure you want to delete retailer?") }*/ } </script> </head> <body>

how to delete a letter in a word?
how to delete a letter in a word? how to delete a letter in a word? for example if i enter= roseindia, i want to delete 's', then output= roeindia

php delete checkbox
php delete checkbox How can i delete the data with multiple check boxes in PHP

insert and delete a row programmatically
insert and delete a row programmatically How to insert and delete a row programmatically ? (new feature in JDBC 2.0

delete an item from database
delete an item from database how to delete an item from the database using jsp

delete app from iphone
delete app from iphone How to delete an existing app from itunes

uitableviewcell delete button position
uitableviewcell delete button position uitableviewcell delete button position - how can i set? Thanks in Advance

insert and delete data in database
insert and delete data in database insert and delete data in database from servlets through JDBC Hi Friend, Please visit the following links: Insert Data Delete Data Thanks

sqlite database delete row
sqlite database delete row How to delete row from SQLite Database? NSString *updateSQL = [NSString stringWithFormat: @"DELETE FROM aListDB WHERE id='%@'",details.ids

Delete Query using HQL
Delete Query using HQL Can we write 'AND' with 'WHERE' clause in delete query using HQL? For example: delete from table name where field1... is "delete from table where field1 = 'value1' and field2 = 'value2'. Have

The DELETE Statement
The DELETE Statement The DELETE statement is used to delete rows from a table. database will update...; DELETE FROM table_name WHERE

Hibernate delete HQL - Hibernate
Hibernate delete HQL Hi I am trying hibernate tutorial. But delete HQL tutorial not working properly. It gives null pointer exception. Query class has method executeUpate() & not executeUpdate

delete a file - JSP-Servlet
delete a file Correct question::::How can we delete a file which is stored in a server when read write operations for this particular file is closed. http://www.communigate.com/CommuniGatePro/WebFiles.html

tree menu delete node
tree menu delete node I have crated a tree menu having various sub nodes now i want to delete parent node and also want to delete sub nodes when... using url ....i have a problem when i perform a delete operation on parent node

Java delete file if exists
Java delete file if exists Hi, Hi how to delete file if exists? I need example code of java delete file if exists. Thanks Hi, following code can be used: String tempFile = "C:/mydir/myfile.txt"; //Delete

Delete points from database
Delete points from database I have a polygon on a web page and a delete button. The polygon is saved in the database in one table and in another... the delete button, the polygon in the webpage gets deleted as well as the polygon

how to delete a row in sql without using delete command.
how to delete a row in sql without using delete command. how to delete a row in sql without using delete command. thanks in advance

delete a file - JSP-Servlet
delete a file How can we read a file which is stored in a server when read write operations for this particular file is closed

JPA delete query - EJB
JPA delete query Hi, I have an entity InvoiceItems.java. I want to delete all the records from the table. What will be the JPA query to delete... to achieve this: Query query = em.createQuery("delete from InvoiceItems o

Create Delete Trigger in SQL
Create Delete Trigger in SQL Create Delete Trigger in SQL fire this trigger before the DELETE operation is executed. Understand with Example

delete query problem - Hibernate
delete query problem SessionFactory fact = new Configuration... = sess. beginTransaction(); String hql = "delete from STUDENT where name = 'mitha... system properly. STUDENT is not mapped. [delete from STUDENT where name = 'mitha

Use of delete() method in hibernate.
Use of delete() method in hibernate. Define the use of delete() method of hibernate? Hibernate provide the facility to delete one row... department0_ where department0_.id=? Hibernate: delete from department where id

delete row using id
delete row using id package pkg2; import org.hibernate.Query; import... = "delete from Insurance insurance where id = 2"; Query query = sess.createQuery...: delete [delete from pkg2.Insurance insurance where id = 2

uitableview manually delete row
uitableview manually delete row uitableview manually delete row NSMutableIndexSet *indexes = [NSMutableIndexSet indexSet]; [array removeObjectAtIndex:indexPath.row]; if(![array count]) [indexes addIndex

Delete HQL query - Hibernate
Delete HQL query Hi I am trying hibernate tutorial. But delete HQL tutorial not working properly. It gives null pointer exception. Query class has method executeUpate() & not executeUpdate(); log4j:WARN No appenders

Grid rows delete issue
Grid rows delete issue I have a grid having rows with Remove button to remove rows,But we also havae an facility to remove those rows on onchange event of dropdown also,so if we delete middle row and then remove all rows

hibernate delete query :
hibernate delete query : Hi, I m using Hibernate 3 + javadb my... NOT NULL , ITEM_ID INTEGER NOT NULL ) I want to delete a row from table...(); org.hibernate.Transaction tx = session.beginTransaction(); String query1 = "delete from

Delete a Records in Database
Delete a Records in Database The Delete Statement is used to delete the records and rows from the table. The generalized Syntax used for delete query in database

Difference between TRUNCATE and DELETE commands
Difference between TRUNCATE and DELETE commands hii, What is the difference between TRUNCATE and DELETE commands? hello, TRUNCATE is a DDL command whereas DELETE is a DML command. TRUNCATE is much faster than

Ask Questions?

If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.

Ask your questions, our development team will try to give answers to your questions.

Tutorial Topics