delete multiple row using checkbox

Ads

Share on Google+

divyadaga

delete multiple row using checkbox
3 Answer(s) 5 years and 7 months ago
Posted in : JSP-Servlet

delete multiple row using checkbox

Ads

View Answers

April 7, 2017 at 11:49 AM

thank you for help

April 7, 2017 at 1:54 PM

how to delete any checkbox selected value? but this program are not satisfied the condition....i will increase string size then delete file...actually don't know how many data are store data in database...plz help me

March 27, 2012 at 10:17 AM

We are providing you the code where we have specified only three fields bookid,author and title in the database.

1) Create book.jsp

<%@page import="java.sql.*"%>

<form name=myname method=post action="delete.jsp">
<table border="1">
<tr><td></td>
<td><b><u>bookid</u></b></td>
<td><b><u>Author</u></b></td>
<td><b><u>title</u></b></td>
</tr>
<%try{

Connection conn = null;
Class.forName("com.mysql.jdbc.Driver").newInstance();
conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/mysql","root", "root");
ResultSet rs = null;
Statement st=null;
st=conn.createStatement();
rs = st.executeQuery("select * from book");
int i=0; while(rs.next()){ %>
<tr><td><input type="checkbox" name="check<%=i%>" value=<%= rs.getString("bookid") %>></td>
<td><%= rs.getString("bookid") %></td>
<td><%= rs.getString("author") %></td>
<td><%= rs.getString("title") %></td>
</tr><%
i++;
}
}catch(SQLException e){ System.out.println(e.getMessage()); } %>
</table>
<input type="submit">
</form>

2) Create delete.jsp

<%@page import="java.sql.*"%>

<%String id[]= new String[10];
for(int i=0;i<10;i++){
id[i]=request.getParameter("check"+i);
out.println(id[i]);
}
%>
<%try{
Connection conn = null;
Class.forName("com.mysql.jdbc.Driver").newInstance();
conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/mysql","root", "root");
ResultSet rs = null;
Statement st=null;
st=conn.createStatement();
for(int a=0;a<10;a++){
st.executeUpdate("delete from book where bookid='"+id[a]+"'");

}
}catch(SQLException e){ 
    System.out.println(e.getMessage()); 
    }
    %>

Ads

Advertisements

delete multiple row using checkbox
delete multiple row using checkbox delete multiple row using checkbox We are providing you the code where we have specified only three... i=0; while(rs.next()){ %> <tr><td><input type="checkbox" name

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(hql); int row = query.executeUpdate(); if (row == 0

Adding checkbox in table using that delete table rows
Adding checkbox in table using that delete table rows I need coding for how to add checkbox in table,the table data from database.Using that checkbox select more than than one rows,and using delete button i want to delete

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 row from a table using hibernate
delete row from a table using hibernate //code in java file String hql="delete from CONTACT c where ID=6"; Query query=session.createQuery... [delete from CONTACT] int i=query.executeUpdate

How to delete the row from the Database by using servlet
How to delete the row from the Database by using servlet Dear Sir/Madam I am trying to delete the one user data in the Oracle SQL server database...: Delete row from database using servlet In that link solution

delete row
delete row how to delete row using checkbox and button in php... if(isset($_POST['delete'])) { for($i=0;$i<$row;$i++) { $delete = $checkbox[$i]; mysql_query("delete from sonu where id='$delete

delete row from a table in hibernate
delete row from a table in hibernate is there method to delete row in a table using hibernate like save(-) to insert row

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

How to delete the row from the Database by using while loop in servlet
How to delete the row from the Database by using while loop in servlet Dear Sir/Madam, I am trying to delete the one user data in the Oracle SQL server database by using Servlet program (Tomcat server). In Database table

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

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

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

JDBC: Delete Record using Prepared Statement
JDBC: Delete Record using Prepared Statement In this section, we will discuss how to delete row of a table using Prepared Statements. Delete Record ... Clause. So you can delete one row or multiple row of table as specified

Delete a row from database by id
Delete a row from database by id I m creating a small application using servlet. There is a form (index.jsp)having 10 fields on submitting the form...) for "DELETE" AND "UPDATE". On clicking delete which is hyper link that particular row

how to insert multiple columns of a single row into my sql database using jsp
how to insert multiple columns of a single row into my sql database using jsp hi sir, how to insert multiple columns of a single row into my sql database using jsp. when i click ADD ROW,rows are added.when i click submit

JDBC ResultSet Delete Row Example
JDBC ResultSet Delete Row Example: Learn how to delete row using ResultSet. We are also used ResultSet object with update capability for delete rows from.... 6. Finally call deleteRow() ResultSet method for delete the current row form

checkbox
checkbox how to insert multiple values in database by using checkbox in jsp

Hibernate delete a row error - Hibernate
Hibernate delete a row error Hello, I been try with the hibernate delete example (http://www.roseindia.net/hibernate/hibernate-delete.shtml...(); //======================================= sess = fact.openSession(); String hql = "delete from Contact contact

data grid with edit and delete options at each row.
data grid with edit and delete options at each row. i want to display the table data in the format of data grid with edit and delete options at each row. i need it very urgently. advance thanks

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

jQuery Multiple Checkbox Select / Deselect
"); } }); }); jQuery Multiple Checkbox Select / Deselect In this section, you will learn how to create multiple checkbox group which select/deselect the group...="jquery-1.4.2.js"></script> <TITLE>Multiple Checkbox

Delete multiple records with pagination by selecting checkboxes
Delete multiple records with pagination by selecting checkboxes Hi there,I'm working with PHP.I want to delete my database records which is displayed using pagination by selecting check boxes.But I'm able to delete only records

Insertion of multiple row data for billing purpose.
Insertion of multiple row data for billing purpose. Hi , I have...)========(inutfield2) I want to insert all these row value .problem is that the no of text field in row/column can be dynamic. so how can i insert all

add row in grid using dojo
add row in grid using dojo add row in grid using dojo

deleting messages using checkbox in JSP
deleting messages using checkbox in JSP Am working on a Mail Server... is deleting correctly in my project. But Problem occurs when i use to delete... on button it shows an error. A when there is no message in it and i click on delete its

JDBC Delete Row In Table Example
JDBC Delete Row In Table Example : In this tutorial we will learn how delete... or more specific row delete from table that follow any given condition...; delete row then count deleted row and display output "Deleted specific

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

Ads

Advertisement null

Ads