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

Ads

Share on Google+

Shubham Tiwari

include a delete option in every row of table in a JSP page
0 Answer(s) 5 years and 3 months ago
Posted in : JSP-Servlet

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

Ads

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

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

jsp:include page=.. and include file = ...
jsp:include page=.. and include file = ... What is the difference between <jsp:include page = ... > and <%@ include file = ... >?. <jsp:include page = ... >: This is like a function call from

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

Jsp include page problem
Jsp include page problem I have included footer.jsp in all my pages... content is displayed ) How can I rectify this? Hi, You have to delete... will find it in apache-tomcat-5.5.30\work\Catalina Delete the content

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

Delete and add row from Table View iPhone
Delete and add row from Table View iPhone In this tutorial will learn how to delete and also how to add row into the table view iPhone, with the help of edit... and Delete buttons on Table view. Table views are commonly found in iPhone applications

Deleting row and column from a table
Deleting row and column from a table In this program ,we delete row... connection interface and java driver. After it we can delete row using "delete " keyword and also can delete column using "Alter" table commands

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

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

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

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

Include static files within a JSP page
Include static files within a JSP page How do I include static files within a JSP page? Static resources should always be included using the JSP include directive. This way, the inclusion is performed just once

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

How to know the selected row from table - JSP-Interview Questions
How to know the selected row from table hi Every one....i am retriving data from database and i place that data into html table.in that table i... the selected row in that table. Hi Friend, Please clarify your

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

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

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

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

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

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

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

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

Ads

Advertisement null

Ads