java

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

&lt;%@ page import="java.sql.*" %>
&lt;%@ 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

&lt;%@ page language="java" import="java.util.*"%>
&lt;%
int id = (Integer)session.getAttribute("assid");
%>
<html>
<head>
<title>Cookie Create Example</title>

</head>
<body>
ASSOCIATE ID : &lt;%= id %>
</body>
</html>

View Answers

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.

Advertisements

java
java why iterator in java if we for loop

Java
Java Whether Java is pure object oriented Language

JAVA
JAVA how the name came for java language as "JAVA

java
java explain technologies are used in java now days and structure java

java
java different between java & core java

java
java is java open source

java
java what is java reflection

java
java in java does not pointers concept but what is nullpointers in java? nullpointer is a runtime Exception

java
what is the size of array in java ? what is the size of array in java ? what is the mean of finalize in java

java
java why to set classpath in java

java
java RARP implementation using java socket

java
java sample code for RARP using java

Java
Java how to do java in command prompt

java
java how use java method

java
java is java purely object oriented language

java
java why multiple inheritance is not possible in java

java
java give a simple example for inheritance in java

java
java why to set classpath in java

java
java What is ?static? keyword

java
java Does java allows multiline comments

java
java Write a java code to print "ABABBABCABABBA

java
java write a program in java to acess the email

java
java send me java interview questions

java
java what are JAVA applications development tools

Java
Java Whether Java is Programming Language or it is SOftware

java
java explain object oriented concept in java

java
java difference between class and interface

Java
Java how to draw class diagrams in java

java
java write a java program using filenotfoundexception

java
java how to edit text document by using java then how to edit starting and ending of text document by using java

java
java different between java & core java print("code sample

java
java how can use sleep in java which book learn of java language

java
java hi im new to java plz suggest me how to master java[email protected]

java
java How to set java Policy for applet using jdk 6

java
java pattern code for a given words java pattern code for a given words pattern

java
java dear, i want a field for date picker using java/java script

java
java create java program for delete and update the details,without using database, just a normal java program

java
java why methods in java raise exceptions Have a look at the following link: Java Exceptions

java
java code to search the nodes how to write the java code to search the nodes using routers

java
java online telephone directory i need coding for online telephone directory..by using java....pls help me

java
java different between java & core java print("code sample

java
java how to invoke one chart java file from another java file

java
java how to prepare the java Hi Friend, If you want to learn how to install java, creating and running a java program then go through the following links: http://www.roseindia.net/java/beginners/index.shtml http

java
java java swing Swing is a principal GUI toolkit for the Java programming language. It is a part of the JFC (Java Foundation Classes), which is an API for providing a graphical user interface for Java programs

java
java what is the need of java if java is not there what will happen... work unless you have Java installed, and more are created every day. Java... to scientific supercomputers, cell phones to the Internet, Java is everywhere! http

java

Questions by Category