surya
I am having difficulty in retrieving data from table in oracle.i used resultset but while clicking button the last data in the resultset is getting retrieved.am pasting my code.please give me a solution.
page1.jsp
<%@ page import="java.sql.*" %>
<%@ page import="java.io.*" %>
<html>
<head>
<title>APPROVAL PAGE!!!</title>
</head>
<body>
<form action="http://localhost:8080/project/b.jsp"/>
<%
try {
Connection con = null;
Statement statement = null;
ResultSet rs = null;
Class.forName("oracle.jdbc.driver.OracleDriver");
con = DriverManager.getConnection("jdbc:oracle:thin:@10.238.66.27:1521:texcity","scott","tex123");
statement = con.createStatement();
rs = statement.executeQuery("SELECT * from s_257281");
%>
<TABLE cellpadding="15" border="1" style="background-color: #ffffcc;">
<TR>
<TH>ASSOCIATE ID</TH>
<TH>LINK</TH>
</TR>
<% while(rs.next())
{
%>
<TR>
<TD> <%= rs.getInt(1) %> </TD>
<% int val1 = rs.getInt(1);%>
<%
System.out.print("ID");
session.setAttribute("assid",val1);%>
<td><input type="submit" name="submit" value="click here">
</td></TR>
<%
}
//con.close();
} catch (Exception e) {
}
%>
</TABLE>
</form>
</body>
</html>
page2.jsp
<%@ page language="java" import="java.util.*"%>
<%
int id = (Integer)session.getAttribute("assid");
%>
<html>
<head>
<title>Cookie Create Example</title>
</head>
<body>
ASSOCIATE ID : <%= id %>
</body>
</html>
February 5, 2011 at 4:50 PM
Retrieve data from database
Using Mysql database
1)page1.jsp:
<%@page import="java.sql.*"%>
<%@page language="java" import="java.util.*" %>
<form method="post" action="page2.jsp">
<table border=1>
<tr><th>ID</th><th>Name</th><th>Address</th></tr>
<%
ArrayList list=new ArrayList();
try{
Class.forName("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/test", "root", "root");
Statement st=con.createStatement();
ResultSet rs=st.executeQuery("select * from data");
while(rs.next()){
%>
<tr><td><%=rs.getInt("id")%></td><td><%=rs.getString("name")%></td><td><%=rs.getString("address")%></td></tr>
<%
list.add(rs.getInt("id"));
}
session.setAttribute("assid",list);
rs.close();
st.close();
con.close();
}
catch(Exception e){}
%>
<tr><td></td><td></td><td><input type="submit" value="Submit"></td></tr>
</table>
</form>
2)page2.jsp:
<%@page language="java" import="java.util.*" %>
<%Iterator itr;%>
<% List data= (List)session.getAttribute("assid");
for (itr=data.iterator(); itr.hasNext(); )
{
out.println(itr.next()+"<br>");
}
%>
February 7, 2011 at 11:43 AM
thank u for ur reply...but we require the driver to be interfaced with oracle , we had made the necessary changes but the output is not obtained. we are getting a list of all the IDs and not the corresponding ID's information. Please assist us in this regard.
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.
