Rogelio Trist�n

Greenhorn

+ Follow

news 4 Posts 4 Threads

since May 12, 2005

Merit badge: grant badges

For More

Cows and Likes

Cows

Total received

In last 30 days

Forums and Threads

Recent posts by Rogelio Trist�n

how do I pass data from one JSP to another?

hey, I'm having a problem passing this data to a new JSP.. maybe you guys can help me out. here is thesection of code that seeems to be troubling me...

<%@page contentType="text/html"%>
<%@page pageEncoding="UTF-8"%>
<%--
The taglib directive below imports the JSTL library. If you uncomment it,
you must also add the JSTL library to the project. The Add Library... action
on Libraries node in Projects view can be used to add the JSTL 1.1 library.
--%>
<%--
<%@taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
--%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>JDBC & Javabean</title>
</head>
<body>

<%@page language ="Java" import="java.sql.*" %>
<jsp:useBean id="jdbcbean" scope="request" class="student.StudentJdbcBean" />
<jsp:setProperty name ="jdbcbean" property="*" />
<%! ResultSet rs1=null;
ResultSetMetaData rsmd1=null;
int i;
int noCol;
%>
<h2>STUDENT MANAGED SYSTEM</h2>
<%
jdbcbean.connect();
%>
<table Border=0>
<%
try
{
rs1=jdbcbean.executeSQL("select Stud_Name from Student");
}
catch(SQLException error)
{
throw new ServletException("Invalid query",error);
}
rsmd1 = rs1.getMetaData();
noCol=rsmd1.getColumnCount();
for(i = 1; i <= noCol; i++)
{
%>
<th>
<%
out.println(rsmd1.getColumnName(i));
%>
</th>
<%
}
%>
<br>
<%
%>
<br>
<%
while(rs1.next())
{
%>
<tr>
<td>
[B]
<form action="detailemployee.jsp">
<input type=text name="t2" value="<%=rs1.getString("Stud_Name")%>"><br>
<input type=submit value="Edit"></form>
[/B]
</td>
</tr>
<%
}
jdbcbean.closeConn();
%>
</table><br><br>
</body>
</html>

this will display a table with a list of names from top to bottom.... then it has an "edit" button in the cell next to it.. great.. but what I want to happen is when you click the "edit" button it should go to a new .jsp page that will display the name, and display the details of the name, I think that requires a statement like select * from Student where Stud_Name = t2...

but how do I send the data off to a new .jsp file? ? Im having trouble getting that to happen... thanks

20 years ago

JSP

sending/retrieving data via SQL statements...

hey, I have 3 pages here
index:

vali.jsp

<%@page contentType="text/html"%>
<%@page pageEncoding="UTF-8"%>
<html>
<head>
<title>JDBC & JavaBean</title>
</head>
<body>
<%
String up=request.getParameter("t1");
if(up.equals("1"))
{
%>
<form action="add.jsp">
<pre>
<h2>Add Student Data<h2>
<h4>Enter the student details to be added</h4>
Student Name: <input type=text name="a1"><br>
Student Id: <input type=text name="a2"><br>
<input type=submit>
</pre>
</form>
<%
}
else
if(up.equals("2"))
{
%>
<form action="delete.jsp">
<h2>Student Data Deletion<h2>
<br><pre><h4>
Enter the student name to be deleted</h4><h4><br>
Student Name: <input type=text name="d1">
<input type=submit>
</pre>
</form>
<%
} else
if(up.equals("3"))
{
%>
<form action="update.jsp">
<h2>Student Data Update<h2>
<br><h4>
Enter the Student name to be updated: <input type=text name="t2"><br>
<br></h4><pre>
Updated Student Name:<input type=text name="t3"><br>
Updated student ID: <input type= text name= "t4"><br>
<input type=submit>
</pre>
</form>
<%
}
else
if(up.equals("4"))
{
%>
<jsp:forward page="jdbcbean.jsp"/>
<%
} else
if(up.equals("5"))
{
%>
<form action="fullinfo.jsp">

<%@page language ="Java" import="java.sql.*" %>
<jsp:useBean id="jdbcbean" scope="request" class="student.StudentJdbcBean" />
<jsp:setProperty name ="jdbcbean" property="*" />
<%! ResultSet rs1=null;
ResultSetMetaData rsmd1=null;
int i;
int noCol;
%>
<h2>STUDENT MANAGED SYSTEM</h2>
<%
jdbcbean.connect();
%>
<table Border=0>
<%
try
{
rs1=jdbcbean.executeSQL("select Stud_Name from Student");
}
catch(SQLException error)
{
throw new ServletException("Invalid query",error);
}
rsmd1 = rs1.getMetaData();
noCol=rsmd1.getColumnCount();
for(i = 1; i <= noCol; i++)
{
%>
<th>
<%
out.println(rsmd1.getColumnName(i));
%>
</th>
<%
}
%>
<br>
<%
%>
<br>
<%
while(rs1.next())
{
%>
<tr>
<td><%=rs1.getString("Stud_Name")%></td>
</tr>
<%
}
jdbcbean.closeConn();
%>
</table><br><br>

<h2>Student Data Update<h2>
<br><h4>
Enter the Student name to be updated: <input type=text name="t2"><br>
<br></h4><pre>
Updated Student Name:<input type=text name="t3"><br>
Updated student ID: <input type= text name= "t4"><br>
<input type=submit>
</pre>
</form>
<%
}%>
</body>
</html>

and fullinfo.jsp

<%@page contentType="text/html"%>
<%@page pageEncoding="UTF-8"%>
<%--
The taglib directive below imports the JSTL library. If you uncomment it,
you must also add the JSTL library to the project. The Add Library... action
on Libraries node in Projects view can be used to add the JSTL 1.1 library.
--%>
<%--
<%@taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
--%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>JDBC & Javabean</title>
</head>
<body>
<form action ="index.jsp">
<%@page language ="Java" import="java.sql.*" %>
<jsp:useBean id="jdbcbean" scope="request" class="student.StudentJdbcBean" />
<jsp:setProperty name ="jdbcbean" property="*" />
<%! ResultSet rs1=null;
ResultSetMetaData rsmd1=null;
int i;
int noCol;
%>
<h2>STUDENT MANAGED SYSTEM</h2>
<%
jdbcbean.connect();
%>
<table Border=0>
<%
try
{
rs1=jdbcbean.executeSQL("select * from Student WHERE Stud_Name = ?");
}
catch(SQLException error)
{
throw new ServletException("Invalid query",error);
}
rsmd1 = rs1.getMetaData();
noCol=rsmd1.getColumnCount();
for(i = 1; i <= noCol; i++)
{
%>
<th>
<%
out.println(rsmd1.getColumnName(i));
%>
</th>
<%
}
%>
<br>
<%
%>
<br>
<%
while(rs1.next())
{
%>
<tr>
<td><%=rs1.getString("Stud_Name")%></td>
<td><%=rs1.getString("Stud_Id")%></td>
</tr>
<%
}
jdbcbean.closeConn();
%>
</table><br><br>
<input type = "submit" value="HOME">
</body>
</html>

my problem is that what I want it to do, is when the user select option "5", it will take you to a page that will display a table with all student names only. which it does. then prompt for the student name to update, which it does. then I want it to take the person to fullinfo.jsp, which will show all the information for that one student entered... but I'm having a bit of trouble understanding where I would put the sytax and what syntax to use.... it lists the student names only, and asks for student name, but thats as far as I go..any help is appreciated....
[ May 14, 2005: Message edited by: Rogelio Trist�n ]

20 years ago

JSP

jsp problems, only one part of code executes

<%@page contentType="text/html"%>
<%@page pageEncoding="UTF-8"%>
<%--
The taglib directive below imports the JSTL library. If you uncomment it,
you must also add the JSTL library to the project. The Add Library... action
on Libraries node in Projects view can be used to add the JSTL 1.1 library.
--%>
<%--
<%@taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
--%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>JDBC & Javabean</title>
</head>
<body>
<form action ="index.jsp">
<%@page language ="Java" import="java.sql.*" %>
<jsp:useBean id="jdbcbean" scope="request" class="student.StudentJdbcBean" />
<jsp:setProperty name ="jdbcbean" property="*" />
<%! ResultSet rs1=null;
ResultSetMetaData rsmd1=null;
int i;
int noCol;
%>
<h2>STUDENT MANAGED SYSTEM</h2>
<%
jdbcbean.connect();
%>
<table Border=1>
<%
try
{
rs1=jdbcbean.executeSQL("select Stud_Name from Student");
}
catch(SQLException error)
{
throw new ServletException("Invalid query",error);
}
rsmd1 = rs1.getMetaData();
noCol=rsmd1.getColumnCount();
for(i = 1; i <= noCol; i++)
{
%>
<th>
<%
out.println(rsmd1.getColumnName(i));
%>
</th>
<%
}
%>
<br>
<%
%>
<br>
<%
while(rs1.next())
{
%>
<tr>
<td><%=rs1.getString("Stud_Name")%></td>
</tr>
<%
}
//jdbcbean.closeConn();
%>
</table><br><br>
<form action="index.jsp">
<%@ page language="Java" import="java.sql.*" %>
<jsp:setProperty name="jdbcbean" property="*" />
<%!
int d;
String[] d2;
%>
<table>
<jsp:setProperty name="jdbcbean" property="uname" value="<%=request.getParameter("t2")%>" />
<jsp:setProperty name="jdbcbean" property="name" value="<%=request.getParameter("t3")%>" />
<jsp:setProperty name="jdbcbean" property="id" value="<%=request.getParameter("t4")%>" />
<%
//jdbcbean.connect();
jdbcbean.update();
out.println("Table update");
%>
</table>
<%
jdbcbean.closeConn();
%>
<br>
<br>
<input type=submit value="Display Record">
</form>
<input type = "submit" value="HOME">
</body>
</html>

okay the code is supposed to make a table and display student names from the student table, and then afterwards have some text boxes to enter the student name you want to edit, then the new student info (new name and new id number)... well when I execute it, it will show a form for asking wwhat data to update, but it completely skips the first part of the code that sets a table to display the list of students...... funny thing is, when I delete the part about asking for student update info, it will show the list of students... why will it only do the second part of the code when I have them both? how do I make it both show all students in the database, AND ask for student info to update at the bottom ?
thanks guys I appreciat it

20 years ago

JSP

hey.. I know how to make a login.jsp and request the session in the nextjsp file.. but I would like to know how to make a login.html and have a servlet that creates a session, then request the session in the success.jsp.. is this even possible?
[ May 12, 2005: Message edited by: Bear Bibeault ]

20 years ago

JSP