Win a copy of Murach's Python Programming this week in the Jython/Python forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Deleting multiple records using jQuery-ajax at a time.  RSS feed

kaustubh kurambhatti
Posts: 13
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Using jQuery-ajax, i am trying to develop an application. I want to delete districts from database table named district_details. I am showing districts in tabular format as an user interface and provided a checkbox against each and every district. On click of Delete button i want to delete selected districts from table. But at a time, i can delete only 1 district from database. Multiple districts can not be deleted. I am providing with the code snippet. so please help.


<script type="text/javascript">
$('#myDiv1').load('http://localhost:8080/statsdept/admin/showDistrict.jsp');// showing the //districts
$('#myDiv2').load('http://localhost:8080/statsdept/addDistrict', //for adding district
{ name: $("#district").val()});

$("#Delete").click(function(){ // delete districts
var selectedItems = new Array();
$("input[@name='courseCb[]']:checked").each(function() {selectedItems.push($(this).val());});
if (selectedItems .length == 0)
alert("Please select item(s) to delete.");
type: "POST",
url: "http://localhost:8080/statsdept/delDistrict",
data: "items=" + selectedItems,
dataType: "text",
success: function (request) {

error: function(request,error){
alert('Error deleting item(s), try again later.');
});//end of trial button clicked function.

});//end of document.ready function.


<p class="msg_head">District Info</p>

<div class="msg_body">

<div id="myDiv1"></div>
<button id="Delete" type="button">Delete District</button><br>
District Name : <input type="text" id="district"><br>
<button id="b01" type="button">Add District</button>
<div id="myDiv2"></div>


try {
String[] sr_nos = request.getParameterValues("items"); //value from checkbox
//String[] sr_nos = {"32","35"}; //value from checkbox
out.println("<title>Servlet delDistrict</title>");

dbCon dc = new dbCon();
Connection con = dc.getConnection1();

Statement stmt = con.createStatement();
int arrayElement = 0;
for(int i = 0; i<sr_nos.length; i++){
//out.println("<script>alert(" + sr_nos[i] + ")</script>");
arrayElement = Integer.parseInt(sr_nos[i]);
stmt.executeUpdate("delete from district_details where dst_id = " + arrayElement);
catch(Exception e){


I am new to jQuery..... please help ... thanks
Hardik N Shah
Posts: 7
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
use $.post() for jquery ajax and pass your selected value as parameter of ajax call

are you getting array at server side?

David Newton
Posts: 12617
IntelliJ IDE Ruby
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Please UseCodeTags when posting code or configuration. Unformatted code and configuration is unnecessarily difficult to read. You can edit your post by using the button.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!