include a delete option in every row of table in a JSP page

I have the following code of a JSP page...........

<blockquote>
  <p>&lt;%@taglib prefix="c"
  uri="http://java.sun.com/jsp/jstl/core"%> &lt;%@taglib prefix="sql"
  uri="http://java.sun.com/jsp/jstl/sql"
  %> <sql:setDataSource
  driver="com.mysql.jdbc.Driver"
  url="jdbc:mysql://localhost:3306/employee"
  user="root" password="shubham"/>
  <sql:query var="rs" sql="select* from
  login"> </sql:query> <html>
      <head>
          <title>JSP Page</title>
      </head>
      <body>
          <table border="1">
              <tr><td>Username� </td><td>Password</td><td>Role</td><td>Edit</td><td>Delete</td></tr>
              <c:forEach var="data" items="${rs.rows}">
                  <tr><td>${data.username}</td><td>${data.pass}</td><td>${data.role}</td><td><a
  href="edit.jsp">Edit</a></td><td><a
  href="delete.jsp">Delete</a></td></tr>
              </c:forEach>
          </table>
      </body> </html></p>
</blockquote>

Now, I want that on clicking on Delete it should delete the particular record from the database and reflect the change on the page..............also if the user clicks on edit then he can change the password and role but not the username.........

please provide the code for this purpose........i.e edit.jsp and delete.jsp in JSTL only........

View Answers

Ads

Advertisements

Table's row elimination based on option choosen
Table's row elimination based on option choosen I have a drop down with yes and no option.if i select yes in a table 2 new rows are shown and if i select no another question in row appears but the space occupied by the question

How to get table row contents into next jsp page
How to get table row contents into next jsp page Hi, I have a 30... page.But the problem is how do i get the selected radio button table row contents in the next jsp page and display them Thanks Vikas The given

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

JDBC Delete Row In Table Example
JDBC Delete Row In Table Example : In this tutorial we will learn how delete specific row from the table use mysql JDBC driver.This tutorial defined how one or more specific row delete from table that follow any given condition

delete row
delete row how to delete row using checkbox and button in php...="delete" > <table width="100%" border="1"> <tr><td>... if(isset($_POST['delete'])) { for($i=0;$i<$row;$i++) { $delete

Java to create table in jsp file that include other jsp file
Java to create table in jsp file that include other jsp file String jspContent = "table" += "tr" += "td" += "jsp:include page='fileSource'" //this line is not working properly... += "/td" += "/tr>" += "/table" Please refer

How to search the selected item in row table using radia button in JSP?
How to search the selected item in row table using radia button in JSP? How to search the selected item in row table using radia button in JSP

show folder on server by clicking a row in table using jsp and ajax
show folder on server by clicking a row in table using jsp and ajax Hi, i want a jsp page which has one dropdown and one textfield. when i click... display the table. Now if i click on a row it should open a folder in server

The Include Directive in JSP Page
The Include Directive in JSP Page ...; <%@include file="relativeURL" %> <jsp:include page="relativeURL" /> or <jsp:include page="

delete multiple row using checkbox
delete multiple row using checkbox how to delete multiple row in a table which is connected to database using checkbox

Delete row and column from table through java code
Delete row and column from table through java code... will see how to delete row and column from given table through java code. Java code... will delete the row having minimum value of ID then delete the column named

How To Include Two Jsp page in another jsp page?
How To Include Two Jsp page in another jsp page? I use following code to Include Two Jsp Page Header and footer <%@include file="header.jsp... the following links: http://www.roseindia.net/jsp/jsp-include-file.shtml http

How to change table row color when click on Hyper Link in jsp?
How to change table row color when click on Hyper Link in jsp? I use 5 links: Link 1 Link 2 Link 3.. table: row1 row2 row3.. when click on the link1 automatically change

Include Static HTML Page in JSP
Include Static HTML Page in JSP ... html page in jsp. In JSP, there are two ways to include another web resource. 1. include directive and 2. jsp:include element. Using include directive

insert , edit , and delete button in one jsp page
insert , edit , and delete button in one jsp page hello I want to ask about the way of creating a jsp page contains insert , edit , and delete buttons and manipulate data in database directly. any help please or hints

How to identify the radio button id and row id in a table in jsp?
How to identify the radio button id and row id in a table in jsp? function generateid(no) {var table..."+no; } function addRow(tableID) { var table

Delete a Specific Row from a Database Table
Delete a Specific Row from a Database Table ... the connection we are going to delete a specific row from the table. If the row... in a row, now we need to delete that wrong data. This can be done very easily

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

using insert and delete in a single page in jsp
using insert and delete in a single page in jsp I am using the following code in jsp to declare two javascript functions to insert and delete in a single jsp page but insert function doesn't works only delete function works even

Dragging and dropping HTML table row to another position(In Jsp) and save the new position (values) also in database
Dragging and dropping HTML table row to another position(In Jsp) and save... table in jsp page and i am iterating values (in columns of html table)from Database, Now i am Dragging and dropping one HTML table row to another position.I

How to Dragging and dropping HTML table row to another position(In Jsp) and save the new position (values) also in database(MySql)?
How to Dragging and dropping HTML table row to another position(In Jsp... have one Html table in jsp page and i am iterating values (in columns of html table)from Database, Now i am Dragging and dropping one HTML table row to another

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

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

Delete a row from database by id
Delete a row from database by id I m creating a small application...) for "DELETE" AND "UPDATE". On clicking delete which is hyper link that particular row... all the values are added in to database and page is redirected to a new page

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

JavaScript add row dynamically to table
and into this page we have created a table with one row. We have one button "Add... JavaScript add row dynamically to table ... to add row to a table dynamically then we can also do this with the JavaScript code

How we delete a data of database from front end jsp page
How we delete a data of database from front end jsp page I make a website and featch a data from data base and now i want that a delete button put... deleted from jsp page as well as from database.I used mysql and jsp. Please help me

Ads