0

i am using tomcat 5.5,but i am unable to connect to database

<HTML>
<HEAD>
<TITLE>  </TITLE>
</HEAD>
<BODY bgcolor="#8D9BCA" text="#333300" marginheight="0" marginwidth="0">
<center>
<!-- row 2 -->
<table height="1" width="381">
   <td height="1" width="373">
<P align="center">&nbsp;
<P align="center">&nbsp;
<p align="center"><span style="letter-spacing: 1pt"><b><font size="3" face="Bookman Old Style">Login
Form for Clients</font></b></span></p>
<p align="center">&nbsp;</p>
<form  action="clientcheck.jsp" method="POST">
  <div align="center">
   <table border="0" width="50%" cellspacing="5" cellpadding="5" height="80">
    <tr>
     <td width="33%" align="center" height="25">
      <p align="center"><font size="3" face="Bookman Old Style">Client ID&nbsp;</font></p>
     </td>
     <td width="33%" height="25">
      <p align="center"><font size="3" face="Bookman Old Style"><input type="text" name="client_id" size="20"></font></p>
     </td    </tr>


 <tr>
     <td width="33%" align="center" height="23">
      <p align="center"><font size="3" face="Bookman Old Style">Password&nbsp;</font></p>
     </td>
     <td width="33%" height="23">
      <p align="center"><font size="3" face="Bookman Old Style"><input type="password" name="client_password" size="20"></font></p>
     </td>
    </tr>
   </table>
  </div>

  <p align="center"><font size="3" face="Bookman Old Style">&nbsp;&nbsp;&nbsp;&nbsp;
  If new user&nbsp;&nbsp;&nbsp; <a href="registration_form.htm">Sign
  up</a></font></p>

  <p align="center"><b><font color="#008000" size="3" face="Bookman Old Style">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
   <input type="submit" value="    Go   " name="submit"></span>&nbsp;
  <input type="reset" value="Reset" name="reset">
  </span>
  </font></b></p>
  <p align="center">&nbsp;</p>

  <p align="center">&nbsp;</p>
</form>
</td>
</table>
</center>
</BODY>
</html>


clientcheck.jsp

<%@ page import="java.sql.*" %>
<html>
<BODY bgcolor="#8D9BCA" text="#333300" marginheight="0" marginwidth="0">
<%
 //Context ctx=null;
 ResultSet rs;
 Connection con;
 Statement st;
 String clientid;
 String password;
 int arraylen;



      clientid=request.getParameter("client_id");
      password=request.getParameter("client_password");

try
{
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
      con=DriverManager.getConnection("jdbc:odbc:Nikki","","");
 st = con.createStatement();
 rs=st.executeQuery("select * from clientlogin ");
 //rs = st.getResultSet();

 while(rs.next()){
                   String clientid1= rs.getString("client_id");
                   String  pwd1=rs.getString("password");

  if((clientid.equals(clientid1))&&(password.equals(pwd1))) 
                 {

   session.setAttribute("CLIENT_ID",clientid);

                    out.println(clientid);  

}  
}

}
catch(Exception e)
{
out.println(e.toString());
}
%>
</body>
</html>

i created dsn name correctly.After i open browser http://localhost:8080/login/clientlogin.html
it is excuted & sent to next page but i am getting error

SQL EXCEPTION:GeneralError

for tomcat do i need to install jsdk and do i need to create war file plz tell me how to create war file.

Edited by pyTony: fixed formatting

3
Contributors
3
Replies
4
Views
10 Years
Discussion Span
Last Post by aruna_k_2006
0

Please don't abuse power and beauty of JAVA, scriplets are no place for setting connection to database. Use servlet...

This article has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.