Login With Drop Down, Having Departments in different table

Login With Drop Down, Having Departments in different table

Hi all,

I am doing a project using JSP. My Issue is..... I have two departments name Customs and Accounts in the database with different tables. I have designed the HTML page in such a way the I have a drop down list consisting of Customs and Accounts. I have user accounts of both the departments.

Now, my intention is to select the department from the drop 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 by selecting the drop down box. Suppose the Customs username is 1001 and Accounts Username is 1002. and password is abcd.

In my project I have different departments say, Customs in one table and Accounts in other table. The code provided is having the departments in the same table. Bcoz as per the SQL Query select * from login where username='"+user+"' and password='"+pass+"'and department='"+dep+"' the departments is in the same table. And my issue is I want to login using different departments Customs and Accounts which are in different tables and as soon as I login I have to get individual page of Customs and Accounts.

Suppose In Customs, I have a DEPTID DEPTNAME DEPTHEAD PASSWORD ---- THIS IS ONE TABLE THE SAME LIKE ACCOUNTS. Now I want to login when I select department from the drop down list. Since I cannot populate the departments name from each table into drop down I use Select tag and declare as CustomsDept and AccountsDept

Please provide me the code on how to login using the drop down box and the Username and passwords must match with the Database during Login. One of my friend suggest me to use if(option.equals) condition for LOGIN...Please provide me the code for the above senario.....I'll be grateful to you forever.

Thank You Very Much

Prem Sagar.

Code provided:

1)login.jsp:

<html>
<script>
function validate(){
var username=document.form.user.value;
var password=document.form.pass.value;
if(username==""){
 alert("Enter Username!");
  return false;
}
if(password==""){
 alert("Enter Password!");
  return false;
}
return true;
}
</script>
<form name="form" method="post" action="check.jsp" onsubmit="javascript:return validate();">
<table>
<tr><td>Select Department: </td>
<td>
<select name="dep">
<option value="-1">Select</option>
<option value="Customs">Customs</option>
<option value="Accounts">Accounts</option>
</select>
</td></tr>
<tr><td>Username:</td><td><input type="text" name="user"></td></tr>
<tr><td>Password:</td><td><input type="password" name="pass"></td></tr>
<tr><td></td><td><input type="submit" value="Login"></td></tr>
</table>
</form>
</html>

2)check.jsp:

<%@page import="java.sql.*"%>
<%
try{
String user=request.getParameter("user");
String pass=request.getParameter("pass");
String com=request.getParameter("dep");
 Class.forName("com.mysql.jdbc.Driver").newInstance();
    Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","root");  
       Statement st=con.createStatement();
       ResultSet rs=st.executeQuery("select * from login where username='"+user+"' and password='"+pass+"'and department='"+dep+"'");
       int count=0;
       while(rs.next()){
       count++;
      }
      if(count>0){
       out.println("welcome "+user);
       }
      else{
       response.sendRedirect("login.jsp");
      }
    }
    catch(Exception e){
    System.out.println(e);
}
%>
View Answers









Related Tutorials/Questions & Answers:
Login With Drop Down, Having Departments in different table
Login With Drop Down, Having Departments in different table  Hi all... the departments name from each table into drop down I use Select tag and declare... is to select the department from the drop down box and then login to the page. I
Login With Drop Down
Login With Drop Down   Hi all, I am doing a project using JSP. My... the departments. Now, my intention is to select the department from the drop down box and then login to the page. I have a drop down list box with Customs
Advertisements
display table details when selecting table name in drop down liat
display table details when selecting table name in drop down liat  Hello, Am having problem in my project... i want to retrive the data from mysql... of tables from the database to the dropdown list... if i select the particular table
jsp login code ... when username , drop down box and password is correct
jsp login code ... when username , drop down box and password is correct  i need a jsp code for login.... when username password and dropdown box value is correct.... the drop down box values should be retrieved from database
drop down
drop down  how can i add data from choice/dropdown component of java awt to myaql table
Add values of drop down menu( select option) to mysql table
Add values of drop down menu( select option) to mysql table   Here is my code <?php echo $row['valveName'].'<td>'.$row['valveId'].'<td>'; echo '<select name="onoff">'; echo '<
DropDown Department Login
down box and then login to the page. I have a drop down list box with Customs... is having the departments in the same table. Bcoz as per the SQL Query select * from...+"' the departments is in the same table. And my issue is I want to login using
Drop Down
Drop Down  How to insert date into database using dropdown like facebook
Drop Table
Drop Table       Drop Table in SQL get rid of an object or table from the database. Using a drop Query... from database. The Drop table cannot get it back, once you run the drop Query
DROP a table and TRUNCATE
DROP a table and TRUNCATE   What are the differences between DROP a table and TRUNCATE a table
Drop down menu
Drop down menu  I have drop down list of some 14 links which links to the table,If i click each link the table should display below the link and again if i click the link the table should not appear. please help me
Drop down menu
Drop down menu  I have created a drop down list of links which links to a table but if i click the link the table display in the other page i want to display it in the same page.Please tell me the solution
drop down menu
drop down menu  drop down menu using html
Pls provide me jsp code to get values in drop down list from another table's field....
Pls provide me jsp code to get values in drop down list from another table's field....  my project has customer registration and company registration... in customer registration page and should be shown in drop down box in front end
drop down list in Struts
drop down list in Struts  How to create a drop down list in Struts
Add/Remove Rows Dynamically with drop down list in html table using php
Add/Remove Rows Dynamically with drop down list in html table using php  Here Is My Code. I want to give and get the id of drop down list. Can Anyone...;table border="1" id="tblSample"> <tr> <
Drop Down reload in IE
Drop Down reload in IE  Hi i was using two drop down box..One for Displaying date followed by another for Dispalying Month..If i Select/Change Month from the 2nd drop down then the 1st drop down ( which is date) automatically
Drop Down Box
Drop Down Box  In a Drop Down box I want to show the user All the Country In the World. And when he type A-z,then each of the type Show those country which start with those word. Like I For-India
validation for drop down list
validation for drop down list  Hi all I have a form, it contain 12 drop down list. Each drop down has 1 to 5 values,i need to validate this form. the following condition should be true. 1.you can choose only 3 times 5 value. 2
dynamic drop down
dynamic drop down   I have created 2 drop downs in jsp.1... into the designation drop down (use jsp+javascript+servlet) reply soon   1..., create tables dept and designation: CREATE TABLE `dept
dynamic drop down list
dynamic drop down list  I want to create 2 drop down list, where it takes value from database and the two list are dependent..means if I select a particular value from one the other list is developed accordingly..depending
Ajax drop down and textbox
Ajax drop down and textbox  hie frnds I have a dropdown menu in the 3 options(1,2,3) are there if i choose 1 then I should get 1 text box if i select... in advance............   Here is an ajax example which is having a drodown
Dependent drop down list
Dependent drop down list  hi,i am trying to design a form on which 2 dependent drop down list is used my code is successful but when i select class from first drop down list all the data get lossed means the value entered
Get values in drop down list
Get values in drop down list  Pls provide me jsp code to get values in drop down list from another table's field. my project has customer... in drop down box in front end..... pls provide me code.. thanx
Drop Table
Drop Table       Drop Table in SQL get rid of an object or table from the database. Using a drop Query get rid of all the rows deleted from the table and the structure
Drop down combos
Drop down combos  Hi.. How to write a javascript for linked combo dropdown boxes.   <html> <h2>ComboBox</h2> <script language="javascript"> var arr = new Array(); arr[0] = new Array("-select
login for different user in the same page
login for different user in the same page  how can i do the login for different user in the same page throug jsp
drop down php mysql - PHP
drop down php mysql  PHP Script required to show the similar drop down item in each menu without refreshing the page. Is it possible if yes how
drop down box - JSP-Servlet
drop down box  when i enter some letter in the input box,the corresponding words of that particular letter must be displayed below as a list from the data base in the same input box as drop down. Thanks&Regards, VijayaBabu.M
Dependant & dynamic drop down list
Dependant & dynamic drop down list  I don't know this should be in this or AJAX forum. I have one dynamic drop down list from data base (working... on the values selected by user in first drop down list. How to achieve this ?   
Drop down list from database
Drop down list from database  Hi, Can I know how do we get the drop down list from database? Eg: select country--select state--select district--so..., we have created two database tables: CREATE TABLE `country
jsp drop down-- select Option
jsp drop down-- select Option  how to get drop down populated dynamically   Hi Friend, Create table country(country_id,country... following database tables:ADS_TO_REPLACE_3 1)country CREATE TABLE country
JSP Dependent Drop Down Menu
JSP Dependent Drop Down Menu  Hey Guy/Gals! I need someone help to guide me in creating a drop down menu, where the first menu affects the second menu and it's selection. So in my database I have a category table that has a ID
Select functionality of drop down list - Struts
have Drop down list having element Test1,Test2,Test3,HIDE and one Text msg box...Select functionality of drop down list  Hi, I have to write a code(in struts application) in which if user select HIDE from the drop down list
JDBC: Drop Table Example
JDBC: Drop Table Example In this section, we will discuss how to drop table using JDBC. Drop Table : Dropping table means deleting all the rows... for dropping table. When you call drop table query, it throws an exception
html menu button drop down
html menu button drop down  How to create a menu button in HTML?   <select id="category"> <option value="1">One</option> <option value="2">Two</option> </select> <select id
jQuery Drop Down Menu
jQuery Drop Down Menu       In this JQuery tutorial we will develop a program  to make Drop Down menuADS_TO_REPLACE_1 Steps to develop the Drop Down menu . Step 1:  ADS
Drop down for search textbox like google search
Drop down for search textbox like google search  I want drop down like google search (ie, when we type one letter then the word start with that are displayed). when the drop down list appear, then we can select one of word as our
store values of drop down list box in database
store values of drop down list box in database  how to store values of drop down list box in oracle database in jsp?I have information inserting form where i have date of birth as drop down list box
JDBC Drop Table Example
JDBC Drop Table Example:   In this tutorial we will learn  how drop...  we create "DropTable.java " class that used for drop table. We...; class that defined how connect to database and drop table. Drop table
dynamic creation of multiple drop-down menus
dynamic creation of multiple drop-down menus  can anybody plz help me in coding for dynamic creation of multiple drop-down menus in a webpage using ajax/js/html/css
dependent drop down box - JSP-Servlet
dependent drop down box  haloo sir Please give me the solution how to extract data from dependent drop down box with page refresh..., we have used following database tables: 1)book CREATE TABLE `book
Drop Down Reloads again in IE..How to prevent this?
Drop Down Reloads again in IE..How to prevent this?  Hi i was using two drop down box..One for Displaying date followed by another for Dispalying Month..If i Select/Change Month from the 2nd drop down then the 1st drop down
jsp drop down without refresh - JSP-Servlet
jsp drop down without refresh  Sir I have tried two depenedent jsp dropdown in jsp page,But the probleam is when i select first drop down its... jsp same probleam also arise. Please tell me how to use the drop down without
Using java script do login form having fields with condition.
Using java script do login form having fields with condition.  Need a login form with username, password, phone no, email id, date fields. We should specify the conditions for each field and if we press the submit button
Dependant & dynamic drop down list - Follow up
Dependant & dynamic drop down list - Follow up  Thanks for your answer. As per your answer This will select only ONE row (country) from first drop down. In my case user can choose more than one row , which is then sent to next
Drop-down text selection in jsp/html
Drop-down text selection in jsp/html  Hi, I am trying to create JSP page where I have two drop-downs. There are two-sets of data - First set.... Now the first dropdown will have all the values. The second drop-down depends upon
Display related data in other drop down list on selecting one data in one drop down list
Display related data in other drop down list on selecting one data in one drop down list  How to display related datas in dropdown list from database on selecting one data in previous dropdownlist in Java Server Page
how to retreive data dynamically from mysql to drop down list
the data of a particular column in a table into drop down list dynamically...how to retreive data dynamically from mysql to drop down list   sir, i created a table in mysql and i inserted some values into the table through
dynamic drop down list box - Java Beginners
dynamic drop down list box  hi all , I want to dynamically populate a drop down box from an sql query in a servlet program, using only html & javascript. Is this possible without some kind of server side code? If so, please

Ads