how to connect databas using odbc in servlet

[bhavishya goyal]

i m creating simple page and codding of my class is bellow . tell me how i can connect database at running time .i m using ms access as when

   import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
import java.util.*;
 
public class LoginServlet extends HttpServlet{ 
  public void doPost(HttpServletRequest request, HttpServletResponse response)
                                   throws ServletException,IOException{
try
{
 
    String user=request.getParameter("user");
    String pass=request.getParameter("pass");
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc :o dbc:user");
Statement st=con.createStatement();
String sql="select * from user where name='"+user+"' and pass='"+pass+"'";
System.out.println(sql);
ResultSet rs=st.executeQuery(sql);
 
 
if(rs.next())
{
 
sql="select * from user";
System.out.println(sql);
rs=st.executeQuery(sql);
 
List al=new ArrayList();
while(rs.next())
{
String a[]=new String[2];
a[0]=rs.getString(1);
a[1]=rs.getString(2);
al.add(a);
}
request.setAttribute("list",al);
RequestDispatcher dispatcher = 
request.getRequestDispatcher("/welcome.jsp");
    if (dispatcher != null) dispatcher.forward(request, response);
 
}
else
{
RequestDispatcher dispatcher = 
request.getRequestDispatcher("/error.htm");
    if (dispatcher != null) dispatcher.forward(request, response);
 
}
 
}
catch(Exception e)
{
e.printStackTrace();
}
  }
} 

i start server and enter user name and password .there is processing but it does not make any respond . tell me what is the problem help me [email removed]
[ September 26, 2008: Message edited by: Bear Bibeault ]

[Campbell Ritchie]

Welcome to JavaRanch

Please go back and edit your post (pencil-and-paper icon) so as to disable smilies and get rid of the excess spaces round the : and o which appear as .
Please don't ask people to e-mail you.

What are you supposed to pass to the JDBC connection? Is it really "Jdbc: odbc:user" not the user's name? How are you passing a user name and password to the database?
You appear to be calling rs.next() frequently; you call if (rs.next()) which will go to the first row of the ResultSet, then while (rs.next()) which will start from the 2nd row. I think the if is unnecessary, and might cause you to miss the 1st row.


See whether my suggestions are any help; if not, please ask again.
[ September 26, 2008: Message edited by: Campbell Ritchie ]