• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Paul Clapham
  • Ron McLeod
  • Liutauras Vilda
  • Bear Bibeault
Sheriffs:
  • Jeanne Boyarsky
  • Tim Cooke
  • Devaka Cooray
Saloon Keepers:
  • Tim Moores
  • Tim Holloway
  • Piet Souris
  • salvin francis
  • Stephan van Hulst
Bartenders:
  • Frits Walraven
  • Carey Brown
  • Jj Roberts

Deleting multiple records using jQuery-ajax at a time.

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

 
Author
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.
 
Hold that thought. Tiny ad:
Thread Boost feature
https://coderanch.com/t/674455/Thread-Boost-feature
reply
    Bookmark Topic Watch Topic
  • New Topic