Jdbc Login Page Validation using Combobox

I am beginer to java i am able to validate username and password but unable to get validate the username and password with combo box....please help me I want to validate username and password for diffrent cities diffrent types of username and password.....please help me to validate username and password by using combo box..... Please Help Me....

Thanks alot

Index.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Celcabs Login Page</title>
<link href="css/DBLogin.css" type="text/css" rel="stylesheet"></link>
<script language="javascript">
<!--//
/*This Script allows people to enter by using a form that asks for a
UserID and Password*/
function pasuser(form) {
if (form.id.value=="agni") {
if (form.pass.value=="ihafuf") {
location="Menu.jsp"
} else {
alert("Invalid Password")
}
} else { alert("Invalid UserID")
}
}
//-->
</script>
</head>
<body bgcolor="#DCDCDC">
<h2 align="center">Celcabs UserLogin </h2> <hr>
<form action="authenticateUserServlet" method="POST">
<table>
<tr><td align="left">Username</td><td><input type="text" name="username" size="20"></td></tr>
<tr><td align="left">Password:</td><td><input type="password" name="password" size="20"></td></tr>
<tr><td align="left">Terminal:</td><td><select style=width:180px>
*****<option value="Mumbai">Mumbai</option><option value="hma">Hma</option>
<option value="Bangalore">Bangalore</option>
<option value="Pune">Pune</option>
<option value="Chennai">Chennai</option><option value="Hydrabad">Hydrabad</option>*****
</select></td></tr>
<tr><td colspan="2"><input type="submit" value="Login"><input type="reset" Value="Cancel" ></input></td></tr>
</table>
</form>
</body></html>

servlets:-
package myservlets;
import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;

public class authenticateUserServlet extends HttpServlet {
@Override
public void init(ServletConfig config) throws ServletException {
super.init(config);
        }

protected void doPost(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException {

response.setContentType("text/html");
PrintWriter pw = response.getWriter();
String name = request.getParameter("username");
String password = request.getParameter("password");

try{
String driver = "org.postgresql.Driver";
Class.forName(driver).newInstance();

Connection con=null;
Statement stmt=null;

String url="jdbc:postgresql://192.168.10.32/blrtaxi";
con=DriverManager.getConnection("jdbc:postgresql://localhost:5432/manju","postgres", "password");
stmt=con.createStatement();
String query = "select uname,password from dblogin where uname='"+name+"' and password='"+password+"'";
System.out.println(query);
ResultSet rs = stmt.executeQuery(query);

if(rs.next()){

response.sendRedirect("Menu.jsp");
}
else{
    response.sendRedirect("index.jsp");
}
}

catch(Exception e){
System.out.println(e.getMessage());
}
}
}

Thanks and Regards Manjunath Surpur

View Answers

July 25, 2011 at 3:49 PM

Please go through the following link:

http://www.roseindia.net/jsp/loginbean.shtml