Comment on Tutorial - JSP Example to connect to MS SQL database and retrieve records By Abinaya

Comment Added by : Harshal

Comment Added at : 2013-02-19 14:56:35

Comment on Tutorial : JSP Example to connect to MS SQL database and retrieve records By Abinaya

I am getting a blank page. Closed the table tag and added the headers. Below is the modified code. Please let me know what is the issue with this?



<html>

<head><title>Enter to database</title></head>

<body>

<table border="5">

<%@ page import="java.util.*" %>

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

<% 



java.sql.Connection con;

java.sql.Statement s;

java.sql.ResultSet rs;

java.sql.PreparedStatement pst;



con=null;

s=null;

pst=null;

rs=null;



// Remember to change the next line with your own environment 

String url= 

"jdbc:jtds:sqlserver://harshal:1433/jasptest";

String id= "sa";

String pass= "password";

try{



Class.forName("net.sourceforge.jtds.jdbc.Driver");

con = java.sql.DriverManager.getConnection(url, id, pass);



}catch(ClassNotFoundException cnfex){

cnfex.printStackTrace();



}

//String sql = "select * from tbl_sys_user";

String sql = "select top 10 * from tbl_sys_user";

try{

s = con.createStatement();

rs = s.executeQuery(sql);

%>



<%

while( rs.next() ){

%>





<tr>

<th>Header 1

<td><%= rs.getString("cust_id") %></td>

</th>

</tr>



<tr>

<th> Header 2

<td><%= rs.getString("rdate") %></td>

<th>

</tr>



<tr>

<th>

<td><%= rs.getString("email") %></td>

</th>

</tr>

<%

}

%>



<%



}

catch(Exception e){e.printStackTrace();}

finally{

if(rs!=null) rs.close();

if(s!=null) s.close();

if(con!=null) con.close();

}



%>

</table>

</body>

</html>

View Tutorial

Programming Tutorials

Comment on Tutorial - JSP Example to connect to MS SQL database and retrieve records By Abinaya

categories

Related Tutorials