my coding is
<%
//Connection conn=null;
//Statement st=null;
//ResultSet rs=null;
int msgCount;
try
{
String userid=request. getParameter("a pplication_no") ;
String Query="SELECT * FROM master WHERE To='"+userid+"' ";
Class.forName(" sun.jdbc.odbc.J dbcOdbcDriver") ;
Connection conn=DriverMana ger.getConnecti on("jdbc:odbc:c deDB","admin"," ");
Statement st = conn.createStat ement(ResultSet .TYPE_SCROLL_SE NSITIVE,ResultS et.CONCUR_READ_ ONLY);
//ResultSet rs=st.executeQu ery(Query);
//rs.last();
//msgCount=rs.get Row();
//out.println("Yo u Have "+msgCount +" Messages");
//Class.forName(" oracle.jdbc.dri ver.OracleDrive r");
//Connection con = DriverManager.g etConnection("j dbc:oracle:thin :@rccadv7:1521: ORACL","coll"," coll");
//Statement st=con.createSt atement();
ResultSet che=st.executeQ uery("select count(*) from master where application_no= '"+userid+"' ");
while(che.next( ))
{
int cnt=che.getInt( 1);
if(cnt>0)
{
ResultSet rs=st.executeQu ery("select * from master where application_no= '"+userid+"' ");
while(rs.next() )
{
String cpdf=rs.getStri ng("image");
cpdf=cpdf.trim( );
%>
<%
//Connection conn=null;
//Statement st=null;
//ResultSet rs=null;
int msgCount;
try
{
String userid=request. getParameter("a pplication_no") ;
String Query="SELECT * FROM master WHERE To='"+userid+"' ";
Class.forName(" sun.jdbc.odbc.J dbcOdbcDriver") ;
Connection conn=DriverMana ger.getConnecti on("jdbc:odbc:c deDB","admin"," ");
Statement st = conn.createStat ement(ResultSet .TYPE_SCROLL_SE NSITIVE,ResultS et.CONCUR_READ_ ONLY);
//ResultSet rs=st.executeQu ery(Query);
//rs.last();
//msgCount=rs.get Row();
//out.println("Yo u Have "+msgCount +" Messages");
//Class.forName(" oracle.jdbc.dri ver.OracleDrive r");
//Connection con = DriverManager.g etConnection("j dbc:oracle:thin :@rccadv7:1521: ORACL","coll"," coll");
//Statement st=con.createSt atement();
ResultSet che=st.executeQ uery("select count(*) from master where application_no= '"+userid+"' ");
while(che.next( ))
{
int cnt=che.getInt( 1);
if(cnt>0)
{
ResultSet rs=st.executeQu ery("select * from master where application_no= '"+userid+"' ");
while(rs.next() )
{
String cpdf=rs.getStri ng("image");
cpdf=cpdf.trim( );
%>