SqlException accured at processing Jsp

Hai...
this is my jsp...

<%@ page import="java.sql.*" import="org.bar.DbConnection" import="java.util.*" import="javax.imageio.ImageIO" import="java.io.*" import="java.awt.Image" import="java.net.URL"
    import="java.awt.image.BufferedImage" %>

<HTML>
    <HEAD>
      <style type="text/css">
     @media print {
     input#btnPrint {
     display: none;
        }
            }
            p.normal 
  { 
   border-style: ; 
  
  margin-left:5%; 
  line-height:150%;
  font-size:100%
   } 
           </style>
      
    </HEAD>

<BODY>
    <p class="normal" >
    <center>
   
    <font color="#0000FF"><br><br>
        <H1>RECEIPT</H1>

<% 
        //int bar=Integer.parseInt(request.getParameter("bar"));
       int bar = ((Integer)session.getAttribute("bar")).intValue();
         // int bar=Integer.parseInt((String)request.getAttribute("bar"));
              System.out.println(bar);
           //int b=Integer.parseInt(bar);
             Statement st=null;
	         ResultSet rs=null;	
             DbConnection dbc=new DbConnection();
             Connection con=dbc.getDbConnection();
             Properties props = new Properties();
          
		//PreparedStatement ps=null;
		 //ResultSet rs=null;	
	// DbConnection dbc=new DbConnection();
      //Connection con=dbc.getDbConnection();
     // Properties props = new Properties();
      try{
    	   props.load(getClass().getResourceAsStream("/org/bar/prop.properties")); 
			//props.load(fin);
	        String viewstatement =props.getProperty("view.query");
	        
		     
         //System.out.println(viewstatement);

st=con.createStatement();
	       rs=st.executeQuery(viewstatement+bar);
	       
            if(!rs.next()) {
                out.println("Sorry, could not find that publisher. ");
            } else {
             
        %>

<TABLE >
        
            <TR>
               <Td><font color="#0000FF">IREFNUM :</font></Td>
               <TD> <%= rs.getInt(1) %> </TD>
               </tr>
               <tr>
               <Td><font color="#0000FF">REFNUM :</font></Td>
                <TD><%= rs.getInt(2) %> </TD>
               </tr>
               <Td><font color="#0000FF">FROM DEPT :</font></Td>
               <TD> <%= rs.getString(3) %> </TD>
               <tr>
               <Td><font color="#0000FF">FROM SEC :</font>
                <TD> <%= rs.getString(4) %> </TD>
               </tr>
               <tr>
               <Td><font color="#0000FF">TO DEPT:</font></Td>
                <TD> <%= rs.getString(5) %> </TD>
               </tr>
               <tr>
               <Td><font color="#0000FF">TOSEC:</font></Td>
               <TD> <%= rs.getString(6) %> </TD>
               </tr>
               <tr>
               <Td><font color="#0000FF">SUBJECT:</font></Td>
               <TD> <%= rs.getString(7) %> </TD>
               </tr>
               <tr>
               <Td><font color="#0000FF">NOTES:</font></Td>
                <TD> <%= rs.getString(8) %> </TD>
               </tr>
               <tr>
               <Td><font color="#0000FF">BARCODE:</font></Td>
               <TD> <%= rs.getString(9) %> </TD>
               </tr>
           </TABLE>
       <BR>
      
       
      
        
         
       <% 
           
         } 
          
           }
           catch(Exception e){
           throw new SQLException();
           }
           finally {
		       	 try {
		             if (rs != null)
		             rs.close();
		             if (st != null)
		             st.close();
		             if(con !=null)
		             con.close();

} catch (Exception e) { 
		     
		      }
		      
	 }
	  
 %>
 <%= new java.util.Date() %>
        <br><br><br><br>
        <input type="Button" id="btnPrint" onClick="window.print()" value="Print This Page"/>
        </font>
       
       </center>
    </BODY>

when i am processing above jsp i am getting exception at

then how can i solve that exception and print values

Ramesh, first of all JSP isn't place to write your application logic. It is considered as bad practice.

Regarding your exception problem -

You can't be absolutely sure of which exception your JSP is throwing. You'll always get java.lang.SQLException in every case as you are explicitly throwing it from your code. Try to print the stack trace to get the exact exception.

As Smitesh Shinde pointed out, the first step os to move the Java code out of the JSP and into a Java class where it can be properly tested.