How to get the data from the database using Servlet or JSP program

hello My Netizen friend has given the answer to retrieve data from the database by using servlet or jsp program by typing the output as like this below ReusltSet rs=statement.executeQuery("select * from Table1) while(rs.next()) { out.println(rs.getInt(1)); out.println(rs.getString(2)); out.println(rs.getString(3)); out.println(rs.getInt(4)); } But still i am not gettin the output from the Browser.

Actual problem is that i have a simple program in jsp in the sense to get data from the database like oracle . I have created one jsp program like this

<@ page session="false"%> <@ page import="java.io.*" import="java.sql."%> <%try { PreparedStatement ps; Connectin con; Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); con=DrivergetConnection("jdbc:odbc:DNSName","scott","tiger"; ps=con.prepareStatement(); ResultSet rs=ps.executeQuery("select from Table1"); if(rs.next()) { out.println(rs.getInt(1)); out.println(rs.getString(2)); out.println(rs.getString(3)); out.println(rs.getInt(4)); } } catch(Exception e) {} rs.close(); ps.close(); con.close(); %>

But now when i iam saving this program in JSP it is alright , when i opened the Tomcat and getting the necessary path then i clicked on the JSP file i,but i am not getting any thing in the internet Browser.i have given the data (Table1) in the database.so that data should come on the Browser. but not getting.So kindly the RoseIndia netizens help to solve the problem

October 20, 2011 at 3:24 PM

Get data from database using servlet

Retrieve data from database using JSP

Get data from database using JSP