QuestionAsk Questions?
Manjunath.Surpur
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:
Related Pages:
If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.
Ask your questions, our development team will try to give answers to your questions.
Tutorial Topics
