How to Extract row from table view using JSP Code

Home Answers Viewqa Java-Beginners How to Extract row from table view using JSP Code

Vinay

How to Extract row from table view using JSP Code
2 Answer(s) 3 years ago
Posted in : Java Beginners

Hi Friends,

This is vinay here. Hope this mail finds u all in condition.
I am totally new to java world and trying to design a web page using NetBeans IDE 6.8.

My problem exist with retrival of row from a table on click of link.
Table Structure is given bellow:

User_ID First_Name Middle_Name Last_name Role Region Status Email
1 A B C D E F G Update Delete

On click of Update, entire row should get placed into the corresponding textboxes & dropdown.

I am unable to achieve the functionality. So please send me the code if anyone of you have. This is really urgent for me.

Thank in advance....

Regards
Vinay Kumar Rai

View Answers

May 22, 2010 at 12:03 PM

Hi Friend,

Try the following code:

1)user.jsp:

<%@ page import="java.sql.*" %>
<html>
<head>
<script language="javascript">
function editRecord(id){
window.open('http://localhost:8080/examples/jsp/edituser.jsp?id='+id,'mywindow','width=500, height=350,toolbar=no,resizable=yes,menubar=yes');
}
function deleteRecord(id){
window.open('http://localhost:8080/examples/jsp/deleteuser.jsp?id='+id,'mywindow','width=500, height=350,toolbar=no,resizable=yes,menubar=yes');
}
</script>
</head>
<body>

<br><br>
<table border="1">
<tr><th>FirstName</th><th>LastName</th><th>Address</th><th>Email</th></tr>
<%
Connection con = null;
String url = "jdbc:mysql://localhost:3306/";;;
String db = "test";
String driver = "com.mysql.jdbc.Driver";
String userName ="root";
String password="root";

int sumcount=0;
Statement st;
try{
Class.forName(driver).newInstance();
con = DriverManager.getConnection(url+db,userName,password);
String query = "select * from register";
st = con.createStatement();
ResultSet rs = st.executeQuery(query);
%>

<%
while(rs.next()){
%>
<tr><td><%=rs.getString(2)%></td>
<td><%=rs.getString(3)%></td>
<td><%=rs.getString(4)%></td>
<td><%=rs.getString(5)%></td>
<td><input type="button" name="edit" value="Edit" style="background-color:#49743D;font-weight:bold;color:#ffffff;" onclick="editRecord(<%=rs.getString(1)%>);" ></td>
<td><input type="button" name="delete" value="Delete" style="background-color:#ff0000;font-weight:bold;color:#ffffff;" onclick="deleteRecord(<%=rs.getString(1)%>);" ></td>
</tr>
<%
}
%>
<%
}
catch (Exception e) {
e.printStackTrace();
}
%>
</table>
</form>
</body>
</html>

2)edituser.jsp:

<%@page language="java"%>
<%@page import="java.sql.*"%>
<form method="post" action="update.jsp">
<table border="1">
<tr><th>FirstName</th><th>LastName</th><th>Address</th><th>Email</th></tr>
<%
String id=request.getParameter("id");
int no=Integer.parseInt(id);
int sumcount=0;
try {
Class.forName("com.mysql.jdbc.Driver").newInstance();
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/test";, "root", "root");
String query = "select * from register where id='"+no+"'";
Statement st = conn.createStatement();
ResultSet rs = st.executeQuery(query);
while(rs.next()){
%>
<tr>
<td><input type="text" name="firstname" value="<%=rs.getString(2)%>"></td>
<td><input type="text" name="lastname" value="<%=rs.getString(3)%>"></td>
<td><input type="text" name="address" value="<%=rs.getString(4)%>"></td>
<td><input type="text" name="email" value="<%=rs.getString(5)%>"></td>
<td><input type="hidden" name="id" value="<%=rs.getString(1)%>"></td>
</tr>
<tr>
<td><input type="submit" name="Submit" value="Update" style="background-color:#49743D;font-weight:bold;color:#ffffff;"></td>
</tr>
<%
}
}
catch(Exception e){}
%>
</table>
</form>
</form>

May 22, 2010 at 12:05 PM

continue..

3)update.jsp:

<%@page import="java.sql.*"%>
<%
String id=request.getParameter("id");
int no=Integer.parseInt(id);
String firstname=request.getParameter("firstname");
String lastname=request.getParameter("lastname");
String address=request.getParameter("address");
String email=request.getParameter("email");
try{
Connection conn = null;
Class.forName("com.mysql.jdbc.Driver").newInstance();
conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root";, "root");

Statement st=null;
st=conn.createStatement();
st.executeUpdate("update register set firstname='"+firstname+"',lastname='"+lastname+"',address='"+address+"',email='"+email+"' where id='"+no+"'");
out.println("Data is updated successfully");
}
catch(Exception e){
out.println(e);
}
%>

4)deleteuser.jsp:

<%@page language="java"%>
<%@page import="java.sql.*"%>
<%
String id=request.getParameter("id");
int no=Integer.parseInt(id);
int sumcount=0;
try {
Class.forName("com.mysql.jdbc.Driver").newInstance();
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/test";, "root", "root");
String query = "select * from register where id='"+no+"'";
Statement st = conn.createStatement();
st.executeUpdate("DELETE FROM register WHERE id = '"+no+"'");
out.println("Record is deleted successfully");
}
catch(Exception e){}
%>

For the above code, we have used following database table:

CREATE TABLE `register` (
`id` bigint(20) NOT NULL auto_increment,
`firstname` varchar(40) default NULL,
`lastname` varchar(40) default NULL,
`address` varchar(100) default NULL,
`email` varchar(100) default NULL,
PRIMARY KEY (`id`)
)

Thanks

How to Extract row from table view using JSP Code - Java Beginners
How to Extract row from table view using JSP Code Hi Friends... problem exist with retrival of row from a table on click of link. Table Structure...)deleteuser.jsp: For the above code, we have used following database table

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... from Table by removeLastObject and is then reloaded the data into the Table view

iphone Table View
iphone Table View In this tutorial will learn how to use Table View and also how to add object to table view, will add or insert the object into the Table... view cell by using cel for row at index path method. Here am displaying only

Deleting a Row from SQL Table Using EJB
to delete a row from the SQL Table. Find out the steps given below that describes how to delete a particular row from the database table using EJB. The steps... Deleting a Row from SQL Table Using EJB

Insert a row in 'Mysql' table using JSP Code
Insert a row in 'Mysql' table using JSP Code In this section, we will discuss about how to insert data in Mysql database using JSP code. Query...; Mysql database Table. Code to insert row in Mysql table : databaseinsertion.jsp

delete row
delete row how to delete row using checkbox and button in php? localhost=wampserver database name=sourabh table name=sonu and my code...; We are providing you the jsp code that displays the database table data

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(hql); //error when executing above code CONTACT is not mapped

How to extract details from XML? - JSP-Servlet
How to extract details from XML? I want to extract details from http://service.openkapow.com/palanikumar/airportantigua.rest How can i extract details from this link?Here is my program... Airport

How to delete the row from the Database by using servlet
How to delete the row from the Database by using servlet Dear Sir...: Delete row from database using servlet In that link solution... then the user data to be delete from the database table. Assume in Database table have

Shorting Table View By Column Name
Shorting Table View By Column Name This tutorial explains how to shorting table view by column name from the database in JSP and Servlet. This example... shorting table view by column name. The code of "userdetails.jsp

display the hidden text from that row, when onclick on a row of 1- 10
display the hidden text from that row, when onclick on a row of 1- 10 Using JSP: I'm displaying a set of values from the databse in a table rows (1 to 10)in jsp page, when onclick on one of the view row, it has to submit

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... Delete row and column from table through java code... present in table : "+count); /* Here sql query find the element from

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

Deleting a Row from SQL Table Using EJB
are going to delete a row from the SQL Table. Find out the steps given below that describes how to delete a particular row from the database table using EJB... Deleting a Row from SQL Table Using EJB

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 place one table data as hyperlink. now the problem here is how can i know

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... code retrieve data from database and display in the html table. At each row... page.But the problem is how do i get the selected radio button table row

how to display data from mysql table in text box using jsp??
how to display data from mysql table in text box using jsp?? <p>hi, i have a written a code to display data from a mysql table into txtboxes...);%>/></td> </tr> <tr> <th scope="row">Code

Delete a Specific Row from a Database Table
Delete a Specific Row from a Database Table ... from a specific database table. Here is an example with code which provides... the connection we are going to delete a specific row from the table. If the row

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

view
view hi iam writing some struts application by using dyanafalidator form in place of actionform bean classes i can enter data by using some jsp file and it will insert to database by using business logic. now my requirement

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

iPhone Simple Table View
Simple Table View In this tutorial will learn how to use Table View and also how to add object to table view, to insert the object into the table view we have... that Table view Knows how many rows to be set into Table, will display the actual

Table View Application
table-view programming and shows how to create and manage table views in your... are going to create Table View by using Navigation based application... = @"Countries"; } Using array , adding object into the Table View

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 ... server database by using Servlet program (Tomcat server). In Database table.... It is Urgent... When you retrieve the data from the Database by using

JavaScript add row to table
'. On clicking the button, a new row will be added to the table. Here is the code... row is added to the table: Download Source Code... JavaScript add row to table

Highlight a corresponding table row - Struts
Highlight a corresponding table row I have 2 jsps... the table being displayed with rows having links in them(paged display of the table due to huge data) 2.wen klik on the link it leads to Return.jsp 3.now wen

search in Two Tables to Find data and view by jsp
print the row else go to second table. rs = st.executeQuery("select * from... in Two Tables to Find data and view by jsp <%@page import...; Have a look at the following link: JSP search using two tables

Table view with multiple view and sections
to enter the data on table view we have to take an array and using that will add... Table view with multiple view and sections Project will look like... to the cell(Rows of Table View) and will have two section in Table View

JavaScript add row dynamically to table
to add row to a table dynamically then we can also do this with the JavaScript code. In this example we will describe you how to add row dynamically to the table... JavaScript add row dynamically to table

extract data fom table when a button is clicked in front end page using mysql5.0 and tomcat6.0
extract data fom table when a button is clicked in front end page using mysql5.0 and tomcat6.0 sir, i want to extract data from table which is stored in mysql5.0 databse, when a button is clicked in front end page using

use struts 1.0 to view sql table value on JSP page
use struts 1.0 to view sql table value on JSP page Here i am using struts 1.0 to view my sql table values on jsp page. But the problem is when i append the value in bean then i find the last row of table is shown repetedly. Any

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

Removing a Row from a JTable
of row that have to removed from a table. Here the data of first and last rows... Removing a Row from a JTable ... to remove any one row's data that is wrong entry then you must have to remove from

Count Row - JSP-Servlet
Count Row Hello all, Please I need your help on how to desplay the number of row(s) affected along with the affected row(s) in mssql database 2000 using java servlet and html form. Thanks for your good job! Hi friend

Shifting Row Using JSP
Shifting row using JSP In this program we are going to shift the row using java program. Code description : The packages we need to import are java.io.

mysql table extract
mysql table extract Hello friends!! I am a trainee. I am learning connectivity of java with MYSQL. I want to extract table from mysql so that I can access it on another computer. I want to attach mysql table to my java NETBEANS

Simple Table View With Next View
Simple Table View With Next View In this iphone tutorial will learn how to use Table View and also how to add object to table view, to insert the object into the table view we have to take an array and through that will add or insert

how to display a table from database using servlet
how to display a table from database using servlet how to display a table with values from servletpage Hi Friend, Please go through the following link: http://roseindia.net/jsp/servlet-jsp-data-list.shtml Thanks

Hoe to refresh a table row dynamically
Hoe to refresh a table row dynamically Want to refresh a table data when a particular link is clicked. How can i do using ajax ? Hello Friend, Is there a link attribute with every row of a table through which we

Deleting row and column from a table
Deleting row and column from a table In this program ,we delete row and column of a table. First we create connection to a database using connection interface and java driver. After it we can delete row using "delete

include a delete option in every row of table in a JSP page
include a delete option in every row of table in a JSP page I have the following code of a JSP page........... <blockquote> <p><%@taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%> &lt

how to display values from database into table using jsp
how to display values from database into table using jsp I want to display values from database into table based on condition in query, how... to display books based on either bookname or authorname, for this i created one jsp page

How to extract name,surname, doamin name from mailid
How to extract name,surname, doamin name from mailid Hi sir How to extract name,surname, doamin name from mailid using java coding? for example, i want to extract first name as swamy, surname as nandha and domain

extract data from HTML
extract data from HTML how to write the coding for to extract data from html tags like(h3,p) and then extracted data should be stored in data base? can anybody tell me how to write the coding

JSP Delete Record From Table Using MySQL
JSP Delete Record From Table Using MySQL This tutorial explains you that how to write a JSP for deleting a record from database table. In this section you.... In this tutorial you will learn that how to delete a record of a database table in JSP

Display Blob(Image) from Mysql table using JSP
Display Blob(Image) from Mysql table using JSP In this section, we will display blob data(image) from Mysql database table using JSP code. A Blob stores... : Insert Blob(Image) in Mysql table using JSP Download Source Code

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

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...; <table border="1"> <tr><td></td> <td><b>

how to load a table of data from oracle, to a jsp page using hashmap.
how to load a table of data from oracle, to a jsp page using hashmap. I have a jsp page which ask for project ID,team name,member name according to this data i have to retrieve their details from the database(oracle). I have

Ask Questions?

If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.

Ask your questions, our development team will try to give answers to your questions.

Tutorial Topics