Hi friend,

Code to help in Solving the problem :

<%@ page language="java" import="java.sql.*;"%>



<%

System.out.println("MySQL Connect Example.");
Connection conn = null;
String url = "jdbc:mysql://localhost:3306/";;
String dbName = "userdetails";
String driver = "com.mysql.jdbc.Driver";
String username = "root";
String userPassword = "root";


try {
Class.forName(driver).newInstance();

while(true)
{
conn = DriverManager.getConnection(url+dbName,username,userPassword);

Statement st = conn.createStatement();
String strQuery = "select * from transaction ";
// out.println(strQuery);

ResultSet rs = st.executeQuery(strQuery);

while(rs.next())
{
%>

<tr><td><a href="nextpage.jsp?code=<%=rs.getInt("code")%>>/td></tr>
<%
}

rs.close();
st.close();
conn.close();

}

}
catch(Exception e)
{
System.out.println(e);
}

%>

For more information on JSP visit to :

http://www.roseindia.net/jsp/

Thanks