Win a copy of Cross-Platform Desktop Applications: Using Node, Electron, and NW.js this week in the JavaScript forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

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

 
kaustubh kurambhatti
Greenhorn
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.

modifydb.jsp

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

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

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


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


</script>

<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>

</div>


delDistrict.java

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

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

try{
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){
out.println(e);
}

out.println("</body>");
out.println("</html>");

I am new to jQuery..... please help ... thanks
 
Hardik N Shah
Greenhorn
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

http://api.jquery.com/jQuery.post/
http://net.tutsplus.com/tutorials/javascript-ajax/5-ways-to-make-ajax-calls-with-jquery/

are you getting array at server side?

 
David Newton
Author
Rancher
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.
 
Consider Paul's rocket mass heater.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!