Login Query

Login Query

how to login with usertype in jsp page and redirect then whith user tyep

here is my code

<% Connection con=null; Statement stmt=null; ResultSet rst=null;

String email=request.getParameter("username"); String password=request.getParameter("password"); String user=request.getParameter("usertype"); try { Class.forName("com.mysql.jdbc.Driver"); } catch(Exception e) { out.print("driver error"); } try { Class.forName("com.mysql.jdbc.Driver"); con=DriverManager.getConnection("jdbc:mysql://localhost:3306/internship","root",""); stmt=con.createStatement(); String str="Select * from login where email='"+email+"' and password='"+password+"' and user='"+user+"'"; rst=stmt.executeQuery(str);

if(rst.next()) { if(email.equals(rst.getString(2)) && password.equals(rst.getString(3)) && user.equals(rst.getString(4))) { response.sendRedirect("/student");
} else if(user.equals(rst.getString(4))) { response.sendRedirect("/employer"); } }
else { session.setAttribute("error","login"); response.sendRedirect("index.jsp"); } }

      catch(SQLException se)
       {
            out.print("driver error"+se);
       }         


            %>

please help me i want to redirect page with its login

View Answers









Related Tutorials/Questions & Answers:
Login Query
Login Query  how to login with usertype in jsp page and redirect...="Select * from login where email='"+email+"' and password='"+password+"' and user..."); } } else { session.setAttribute("error","login
login
login  How to create login page in jsp
Advertisements
login
login  How to create login page in jsp
login
login  login page display an error showing failure to login even when the correct information is entered
login
login  how to login admin and user with the same fields(name & password) in single login page while the table for admin and user is seprate in database(mysql) please provide me solution
login
login  i want to now how i can write code for form login incolude user and password in Jcreator 4.50   Hello Friend, Visit HereADS_TO_REPLACE_1 Thanks
login
java.awt.event.*; class Login { JButton SUBMIT; JLabel label1,label2; final JTextField text1,text2; Login() { final JFrame f=new JFrame("Login Form...(); ResultSet rs=st.executeQuery("select * from login where username='"+value1
login
login  how to create login page in jsp   Here is a jsp code that creates the login page and check whether the user is valid or not. 1...;tr><td></td><td><input type="submit" value="Login">
login
login  i am doing the project by using netbeens.. it is easy to use the java swing for design i can drag and drop the buttons and labels etc.. now i want the code for login.. i created design it contains the field of user name
login
login  i am doing the project by using netbeens.. it is easy to use the java swing for design i can drag and drop the buttons and labels etc.. now i want the code for login.. i created design it contains the field of user name
login
login  i am doing the project by using netbeens.. it is easy to use the java swing for design i can drag and drop the buttons and labels etc.. now i want the code for login.. i created design it contains the field of user name
login
login  i am doing the project by using netbeens.. it is easy to use the java swing for design i can drag and drop the buttons and labels etc.. now i want the code for login.. i created design it contains the field of user name
login page
login page  code for login page
Login page
Login page  how to create Login page in java
login page
login page  How to login as different user in php
login-logout
login-logout  how to do login and logout using session in php
LOGIN ERROR
LOGIN ERROR  ERROR SCRIPT: LOGIN FAILED", $_SESSION['login fail']='0',}?> Ty Team
login page
"); stmt=con.createStatement(); String query="select * from login...login page  hi i'm trying to create login page using jsp. i get... <h1>Login Example!</h1> USER NAME <input name="uname
Login authentication
Login authentication  i want d code for login authentication from mysql database on the same pc using swings
Login authentication
Login authentication  i want d code for login authentication from mysql database on the same pc using swings
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 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
login application
login application  how to create login application ?   Hi, Please check the following tutorials: Video tutorial - JSP Login Logout Example Login Authentication using Bean and Servlet In JSP simple code to login user
HQL query
HQL query  how to select only password based on username using HQL query from login table where uname and paswrd are two column names
Login modification
Login modification  How can I invalidate a user once he goes back to login page without signing out,I have already tried using session but it doesn't work please help
login box
login box  class file for password and conform password and how it connected to database
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 Program
Login Program  Login program in struts to set username & password in session. and this session is available in all screens for authentication...   Hi, Please read it at:ADS_TO_REPLACE_2 Login/Logout With Session
login data
login data   Hiiii Sir I am doing banking project on Asp.net i have... the data after login i want to show particular data for particular user means if i login i wanna see only myn data how shud i do thanxx in advance
login data
login data  Hiiii Sir I am doing banking project on Asp.net i have... the data after login i want to show particular data for particular user means if i login i wanna see only myn data how shud i do thanxx in advance
login example
login example  1.Loginpage.jsp <%@ page language="java...-Type" content="text/html; charset=windows-1256"> <title>Login...; public static UserBean login(UserBean bean) { //preparing
login example
login example  1.Loginpage.jsp <%@ page language="java...-Type" content="text/html; charset=windows-1256"> <title>Login...; public static UserBean login(UserBean bean) { //preparing
Login Form
Login Form  I have 8 jsp pages.Each of them has three columns:Left... of +,on clicking which a login form appears. Only the middle column is different for each of the page. How to write a code for login authentication so
Login Form
Login Form  I have 8 jsp pages.Each of them has three columns:Left... of +,on clicking which a login form appears. Only the middle column is different for each of the page. How to write a code for login authentication so
swing login code
swing login code  code for the login form
coding for login page
coding for login page  coding for login page
JSP LOGIN
JSP LOGIN  sir....i have two user types usercategory and user and both user have userid and password in two different table and now i am making login page for which i have to retrieve usertype,userid and password from two
login and logout
login and logout   > > > > hi, > > I have created two pages, one is home.jsp and another is welcome.jsp. In my home.jsp code i > created a login form and after submitting
DropDown Department Login
down box and then login to the page. I have a drop down list box with Customs and Accounts..A Username and a Password field.Now want to login to the page... is having the departments in the same table. Bcoz as per the SQL Query select * from
Login Project
Login Project  why should get the following compile error LoginForm log=(LoginForm)form. this will get when compile LoginAction class please give suggestion byee   make sure public class LoginAction extends Action
login in jsp
login in jsp  i need code for login which is verify the registeration... and otherwise show the failed message.   JSP Login Form 1)login.jsp: <html>...(); ResultSet rs=st.executeQuery("select * from login where username='"+user
login form
login form  sir my next form consists logout button when i click on it it showing login form but next form window is not closing but the components...() { setTitle("Login Form"); setLayout(null); label1 = new JLabel
login form
login form  sir my next form consists logout button when i click on it it showing login form but next form window is not closing but the components...; LoginDemo() { setTitle("Login Form"); setLayout(null); label1 = new
login
Login - Struts
Struts Login page  I want to page in which user must login to see that page. I can do that simple but he/she know that page URL,he/she can simplely type that url... Login Page after logging that page must return to my page.please
login page in php
login page in php  How to create a login page in php
integrate login in php
integrate login in php  how to integrate login in PHP
LOGIN FAILED", $_SESSION['login fail']='0',}?>
LOGIN FAILED", $_SESSION['login fail']='0',}?>  please correct my error guys
struts- login problem - Struts
struts- login problem  Hi all, I am a java developer, I am facing problems with the login application. The application's login page contains fields like username, password and a login button. With this functionality only
query - SQL
(10) primary key,username varchar(20),password varchar(10).This is login process... tell me how to write the query in database but not jsp code. thank u

Ads