Jdbc Login Page Validation using Combobox

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









Related Tutorials/Questions & Answers:
Jdbc Login Page Validation using Combobox
Jdbc Login Page Validation using Combobox  I got Login By this code i want to login by validating with combobox....The link which you send its...(e.getMessage()); } } } I want login username,password and combobox By sessions
Jdbc Login Page Validation using Combobox
Jdbc Login Page Validation using Combobox  I am beginer to java i am... help me to validate username and password by using combo box..... Please Help Me.... Thanks alot Index.jsp <%@ page language="java" contentType="text
Advertisements
Jdbc Login Page Validation using Combobox
Jdbc Login Page Validation using Combobox  I am beginer to java i am... help me to validate username and password by using combo box..... Please Help Me.... Thanks alot Index.jsp <%@ page language="java" contentType="text
Login page validation on ipad
Login page validation on ipad  I am using userId & password labels and their corresponding textfield. Now I want to validate the details by single sign in button and want to switch on to next page. Used two labels again
login page validation
login page validation  hi could you please send me code for login validations Email validation and password email should be in correct format and valid password in java   import java.awt.*; import javax.swing.
comboBox validation
comboBox validation  dear sir. i want to know . how to validate radio button in struts using xml validation. thanks
login page with mysql using jsp
login page with mysql using jsp  pls i need a sample of login page to check username and password in mysql database. thanks
program code for login page in struts by using eclipse
program code for login page in struts by using eclipse  I want program code for login page in struts by using eclipse
login page using jsp servlrt with mysql database?
login page using jsp servlrt with mysql database?  Description... table login. After successfully login user1 see only index page,if user2 login then he see only visiter page and so on. please gine me any suggession. Thanks
code for user registration page and login page of emails using jsp
code for user registration page and login page of emails using jsp  hiiiiiii please send me the code for user registration page and login page of email using jsp and servlets and also code for database connectivity to oracle
create login page using data from text file
create login page using data from text file  I want to create login page using data store in textfile(data submit from regiter page to textfile) using jsp and servlet. Thanks
struts2.2.1 Login validation example.
struts2.2.1 Login validation example. In this example, We will discuss about the Login validation using struts2.2.1. Directory structure of example...;title>Login Validation Example</title> <s:head
login page
login page  code for login page
Struts Login Validation. In This code setter of login page is called only one time again it doesnt call it. Why..?
Struts Login Validation. In This code setter of login page is called only one... page..."); log.info("Login page loaded successfully."); return...="com.credentek.recon.sms.action.IndexAction" method="login"> <
Login page
Login page  how to create Login page in java
login form validation - JSP-Servlet
login form validation  hi, how to validate the login form that contains user name and password using post method . the validation should not allow user to login in the address bar thanks regards, anand
using ajax and jsp (struts) to login and remain on same page.
using ajax and jsp (struts) to login and remain on same page.  I am a fresher... I can forward my login page to success page using struts, but I want to remain on same login page and just want to display loggers name ... I don't
login page
login page  hi i'm trying to create login page using jsp. i get no error while compiling but i get 404 while running the index.jsp. And i'm using... the program. Following are my programs... 1.index.jsp <%@page contentType="text
login page
login page  pls say how to create a login page in jsp and mysql using netbaens   Hi Friend, Please visit the following links:ADS_TO_REPLACE_1 http://roseindia.net/jsf/netbeans/index.shtml http://roseindia.net/jsp
Login Page
Login Page  Can anyone tell me the steps to create a login page in myeclipse 7.0 and validating it with login database in db2 9.7 ??? Please tell me
Login validation doubt
Login validation doubt  Hi, 1)login.jsp: <%@page import..._TO_REPLACE_4 <%@page import="java.sql.*"%> <% String user=request.getParameter...("sun.jdbc.odbc.JdbcOdbcDriver"); Connection con = DriverManager.getConnection("jdbc
LOGIN PROBLEM - JDBC
values and special charecters etc, on the data entered. - Using JDBC create... - After submitting the User ID and Password in the login page, forward the control... and special charecters etc, on the data entered. - Using JDBC create a connection
Creating Login Page In JSF using NetBeans
Creating Login Page In JSF using NetBeans  ... illustrates you how to create a login form in JSF using NetBeans. To create the jsp page... and click. 3. Enter JSP File Name (login, for this example) when New JSP File
login page
login page  How to login as different user in php
Login Password Validation iPhone / iPAD
Login Password Validation iPhone / iPAD  HOW TO WRITE A TEST CASE TO SET THE VALIDATION FOR LOGIN AND PASSWORD FIELD IN OBJECTIVE C, IOS.   ...]; //unless you're using ARC } @end   WHAT IS "STAssertTrue
HTML Login Page Code
JavaScript validation in Login page. We have set username and password value...HTML Login Page Code Here is an example of html login page code.... Login page is used in most of the dynamic website to validate user based
basic login and registration web page using jsp and servlet without using bean .....
basic login and registration web page using jsp and servlet without using bean .....  Hello Folks please i m totally beginner so guys please help me with very simple solution..... thnx
LOGIN PAGE
LOGIN PAGE  A java program with "login" as title,menus added, and a text field asking for firstname, lastname, and displaying current date and time
How to prevent from navigating to ck buttonnext page when user reaches login page using back button
goback to user login page using back button and agin click browser forward button...How to prevent from navigating to ck buttonnext page when user reaches login page using back button  Hi sir, I have created 2 pages, 1) Lo gin Page
How to prevent from navigating to a page after reaching Login page using back button?
How to prevent from navigating to a page after reaching Login page using back... login page using back button and agin click browser forward button,the 2nd page.....But i dont want it to happen.Instead,it should again ask for login. I am using
How to set the border in header and footer from login page using swings/awt
How to set the border in header and footer from login page using swings/awt  Hi, How to set the border in header and footer from login page using swings/awt
coding for login page
coding for login page  coding for login page
login page in php
login page in php  How to create a login page in php
login page code in asp.net
login page code in asp.net  i need front end and backend code for login page in vb asp.net using sql server....having code for submit button
jsp login page
jsp login page  hi tell me how to create a login page using jsp and servlet and not using bean... please tell how to create a database in sql server... please tell with code
html login page with ajax
html login page with ajax  hi all... i want to create a login page using html and ajax for validation is must. please help me doing that with code... and password from the user and check whether the user is valid or not by using ajax
Controling login - JDBC
to controlling the userid and password matches or not iam using oracle database... = "XE"; String url = "jdbc:oracle:thin:@" + serverName...){ System.err.println("Could not load JDBC driver"); System.out.println("Exception
JDbc Login Authentication
JDbc Login Authentication  Pease Please.. Send Me one Login Authentication Using ComboBox.From Servlet and jsp with sessions I am new to sessions..." value="Login"><input type="reset" Value="Cancel" ></input><
java code using combobox,radiobutton,checkbox
java code using combobox,radiobutton,checkbox  hi, send me java code for entering student details into ms access database, the code should includes combo box,radiobutton and checkboxes pl send as early as possible
login page with image
login page with image  I am writing program for login page.It consists of a image and the login details... how to write a java program using frames that have the default positions in any of the systems.. thanks   i had
Login issue using Servlet
Login issue using Servlet  Hi all, I need a code for login using servlet where in I want to check and validate user name and password from database also I want to check candidate's class (for ex. FY, SY, TY) if candidate's class
login page - Java Beginners
login page  I have one login page in jsp that is login.jsp. Now i have validate user from database by another page validate.jsp. but if the user feeded wrong information then i want to print error massege on the first page
jsp-oracle validation - JDBC
; } login page User Name...jsp-oracle validation  Dear friends, my validation not takes place... ----------------------------------- loginsuccess.jsp Logout Success login
SSL for login page
SSL for login page  I am trying to apply ssl cert to login page only. Does anyone know how to do this on a tomcat web server
jsp login page
jsp login page  Hi All, can any one tell me how to create Login page using JSP and Beans. A simple log in page. Please reply ASAP.ADS...:ADS_TO_REPLACE_2 JSP Login Using Bean Thanks   Hi,ADS_TO_REPLACE_3
.Net and SQl 2000 Login page
.Net and SQl 2000 Login page  Please help me creating a login page using dot net using data base sql 2000
login page error
login page error  How to configure in to config.xml .iam takin to one login form in that form action="/login" .when iam deployee the project... this request." please suggest me.   if your login page is prepared
java login form using netbeans
java login form using netbeans  how to connect an access database to a login form using netbeans
Displaying data from combobox on the web page
Displaying data from combobox on the web page  Sir, I have to make a project in which a data from the database is to be displayed in combo box... the database is to be extracted and shown on the same page. Kindly provide me
Displaying data from combobox on the web page
Displaying data from combobox on the web page  Sir, I have to make a project in which a data from the database is to be displayed in combo box... the database is to be extracted and shown on the same page. Kindly provide me

Ads