Jdbc Login Page Validation using Combobox

Ads

 
 

Share on Google+Share on Google+

Manjunath.Surpur
Jdbc Login Page Validation using Combobox
1 Answer(s)      6 years and a month ago
Posted in : JDBC

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

Ads
View Answers

July 25, 2011 at 3:49 PM


Please go through the following link:

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


Ads









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
comboBox validation
comboBox validation  dear sir. i want to know . how to validate radio button in struts using xml validation. thanks
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.
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
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...; charset=UTF-8"> <title>Login Validation Example<
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
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
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 validation doubt
Login validation doubt  Hi, 1)login.jsp: <%@page import...;% } %> 2)check.jsp: <%@page import="java.sql.*"%> <% String user... = DriverManager.getConnection("jdbc:odbc:student"); Statement st=con.createStatement
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
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
login page
login page  code for login page
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
Login page
Login page  how to create Login page in java
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: http://roseindia.net/jsf/netbeans/index.shtml http://roseindia.net/jsp/loginbean.shtml
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
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  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
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
jsp-oracle validation - JDBC
; } login page User Name...jsp-oracle validation  Dear friends, my validation not takes place... ----------------------------------- loginsuccess.jsp Logout Success login
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
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
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
JSP-jdbc validation - JSP-Servlet
JSP-jdbc validation  How to validate login email id using JSP, where...; } login page..., login application in jsp function validateForm(theForm
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><