JSP code for "Display" Info from Database
<%@page language="java" import="java.sql.*"%>
<html>
<body>
<h3>Mohsin Sayad
<%!ResultSet rs=null;;Statement st=null;;Connection cn=null; %>
<% try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); cn=DriverManager.getConnection("jdbc:odbc:test"); st=cn.createStatement(); rs=st.executeQuery("select * from BCASTUDENT_TEMP"); while(rs.next()) { out.print(rs.getString(1)); out.print(rs.getString(2)); } } catch(Exception ee) { out.println(ee); } %>
</h3>>
</body>
</html>
<html>
<body>
<h3>Mohsin Sayad
<%!ResultSet rs=null;;Statement st=null;;Connection cn=null; %>
<% try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); cn=DriverManager.getConnection("jdbc:odbc:test"); st=cn.createStatement(); rs=st.executeQuery("select * from BCASTUDENT_TEMP"); while(rs.next()) { out.print(rs.getString(1)); out.print(rs.getString(2)); } } catch(Exception ee) { out.println(ee); } %>
</h3>>
</body>
</html>
Comments
Post a Comment