DaniWeb Forum Index > Web Development > JSP

plz tell me how to solve problem

Please support our JSP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Feb 2007

Posts: 18

Reputation: aruna_k_2006 is an unknown quantity at this point

Solved Threads: 0

aruna_k_2006 aruna_k_2006 is offline

Offline

Newbie Poster

plz tell me how to solve problem

Feb 17th, 2007

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>

<table height="1" width="381">
<td height="1" width="373">
<P align="center"> 
<P align="center"> 
<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"> </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 </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 </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">    
If new user    <a href="registration_form.htm">Sign
up</a></font></p>

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

<p align="center"> </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 .