trying to delete records from database using jQuery-ajax. But could not delete multiple records at a time.
Using jQuery-ajax, i am trying to develop an application. I want to delete districts from database. I am showing districts in tabular format and provided a checkbox against each and every district. On click of Delete button i want to delete selected districts from database. 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