wrote this code.. for executing the search..
<%!
Connection con=null;
java.sql.Statement stmt=null;
ResultSet rs=null;
%>
<%
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con = DriverManager.getConnection("jdbc
dbc:mech_iit");
stmt = con.createStatement();
String fname=request.getParameter("fname").toUpperCase();
String lname=request.getParameter("lname").toUpperCase();
String mainquery="";
String subquery="";
if(!fname.trim().equals(""))
subquery="select upper(fname) from login where fname like '%"+fname+"%'";
System.out.println("select upper(fname) from login where fname like '%"+fname+"%'");
if(!lname.trim().equals(""))
{
if(subquery.length()>10)
{
subquery=subquery+"and";
}
subquery=subquery+"select uppper(lname) from login where lname like '%"+lname+"%'";
System.out.println(subquery+"select uppper(lname) from login where lname like '%"+lname+"%'");
}
mainquery="select fname,lname from login where "+subquery+"";
while(rs.next())
{
fname = rs.getString("fname");
lname = rs.getString("lname");
%>
<table border="1" width="400">
<tr><td><%=fname %></td>
<td><%=lname %></td>
</tr>
<%
}
}
catch(Exception e)
{
System.out.println(e);
}
%>
</table>
getting a null pointer exception
why so?? can anyone explain..
thanks