Getting Textbox data from database

When i m trying to get data in textbox as readonly from database i m getting following error.and my code is shown below.

<%
String empid=(String) session.getAttribute("empid");
ResultSet rs=null;
Statement stmt=null;

try{
    Class.forName("oracle.jdbc.driver.OracleDriver");
    Connection con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","adm","adm");
    stmt=con.createStatement();
    rs=stmt.executeQuery("select fname,empid from cremp where empid='"+empid+"'");
    rs.next();
}

catch(Exception e){}
finally {
    rs.close();
    stmt.close();
}
%>

     <table width="309" border="1" align="center">
      <tr>
    <td width="108">Name:</td>
    <td width="185"><label>
      <input type="text" name="fname" value="<%=rs.getString(1)%>" readonly/>
    </label></td>
      </tr>
      <tr>
    <td>Id:</td>
    <td><label>
      <input type="text" name="empid" value="<%=rs.getString(6)%>" readonly/>
    </label></td>
      </tr>

org.apache.jasper.JasperException: Exception in JSP: /raisereq.jsp:72
<tr>
<td width="108">Name:</td>
<td width="185"><label>
<input type="text" name="fname" value="<%=rs.getString(1)%>" readonly/>
</label></td>
</tr>
<tr>

September 22, 2012 at 5:22 PM

Here is a jsp code that retrieves data from database and display it on the textboxes.

<%@page language="java"%>
<%@page import="java.sql.*"%>
<table border="1">
<%
try {
Class.forName("com.mysql.jdbc.Driver").newInstance();
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/test", "root", "root");
String query = "select * from employee where id='1'";
Statement st = conn.createStatement();
ResultSet rs = st.executeQuery(query);
if(rs.next()){
%>
<tr>
<tr><td>Name</td><td><input type="text" name="name" value="<%=rs.getString("name")%>"></td></tr>
<tr><td>Address</td><td><input type="text" name="address" value="<%=rs.getString("address")%>"></td></tr>
<tr><td>Contact No</td><td><input type="text" name="contact" value="<%=rs.getInt("contactNo")%>"></td></tr>
<tr><td>Email</td><td><input type="text" name="email" value="<%=rs.getString("email")%>"></td></tr>
<%
}
}
catch(Exception e){}
%>
</table>