DropDown Department Login

DropDown Department Login

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.

View Answers









Related Tutorials/Questions & Answers:
DropDown Department Login
DropDown Department Login  Hi all, I am doing a project using JSP... login where username='"+user+"' and password='"+pass+"'and department='"+dep... LIKE ACCOUNTS. Now I want to login when I select department from the drop down
jsp login code when username , password and dropdown box value is correct...
jsp login code when username , password and dropdown box value is correct...  my project has login in whic i should select the company name in dropdown box.... so when i login i all the three username,password and dropdown box
Advertisements
jsp login code when username , password and dropdown box value is correct...
jsp login code when username , password and dropdown box value is correct...  my project has login in which i should select the company name in dropdown box.... so when i login i all the three username,password and dropdown box
dropdown
dropdown  how to hide textbox field when i deselect from select dropdown
dropdown
dropdown  I have a dropdown having 2 options-"Open"& "closed".When i select "open" option the related rows of data are retrieved from database and same with the other option.My database is Mysql and coding in PHP
login
login  How to create login page in jsp
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
dropdown box
dropdown box  i need to have country,state and city in drop down box using ajax and use db2 database   Have a look at the following link: JSP dependent dropdown
Ajax Dropdown
Ajax Dropdown  hi I have One Dropdown that contains 2 options assume A and B,if i select A option then samepage one more Dropdown is their it should display values in german language using DWRUtil Parameter values in ajax. Only
dropdown cacheing
dropdown cacheing   I need code to create cache for load drop down list from db in struts1 example
department of data science
department of data science  Hi, I am beginner in Data Science and machine learning field. I am searching for the tutorials to learn: department... learn the topic "department of data science". Also tell me which
DropDown Menu
DropDown Menu  Hello, i have a program that can view,add,delete... me draw to your my mind my program.. in my homepage which i have a dropdown... is the problem.. for example; if i select page 1 in my dropdown menu, and click
ModuleNotFoundError: No module named 'odoo10-addon-l10n-fr-department'
ModuleNotFoundError: No module named 'odoo10-addon-l10n-fr-department' ...: ModuleNotFoundError: No module named 'odoo10-addon-l10n-fr-department' How to remove the ModuleNotFoundError: No module named 'odoo10-addon-l10n-fr-department' error
ModuleNotFoundError: No module named 'odoo10-addon-l10n-fr-department'
ModuleNotFoundError: No module named 'odoo10-addon-l10n-fr-department' ...: ModuleNotFoundError: No module named 'odoo10-addon-l10n-fr-department' How to remove the ModuleNotFoundError: No module named 'odoo10-addon-l10n-fr-department' error
ModuleNotFoundError: No module named 'odoo11-addon-l10n-fr-department'
ModuleNotFoundError: No module named 'odoo11-addon-l10n-fr-department' ...: ModuleNotFoundError: No module named 'odoo11-addon-l10n-fr-department' How to remove the ModuleNotFoundError: No module named 'odoo11-addon-l10n-fr-department' error
ModuleNotFoundError: No module named 'odoo12-addon-l10n-fr-department'
ModuleNotFoundError: No module named 'odoo12-addon-l10n-fr-department' ...: ModuleNotFoundError: No module named 'odoo12-addon-l10n-fr-department' How to remove the ModuleNotFoundError: No module named 'odoo12-addon-l10n-fr-department' error
ModuleNotFoundError: No module named 'odoo12-addon-l10n-fr-department'
ModuleNotFoundError: No module named 'odoo12-addon-l10n-fr-department' ...: ModuleNotFoundError: No module named 'odoo12-addon-l10n-fr-department' How to remove the ModuleNotFoundError: No module named 'odoo12-addon-l10n-fr-department' error
ModuleNotFoundError: No module named 'odoo12-addon-l10n-fr-department'
ModuleNotFoundError: No module named 'odoo12-addon-l10n-fr-department' ...: ModuleNotFoundError: No module named 'odoo12-addon-l10n-fr-department' How to remove the ModuleNotFoundError: No module named 'odoo12-addon-l10n-fr-department' error
ModuleNotFoundError: No module named 'odoo8-addon-l10n-fr-department'
ModuleNotFoundError: No module named 'odoo8-addon-l10n-fr-department' ...: No module named 'odoo8-addon-l10n-fr-department' How to remove the ModuleNotFoundError: No module named 'odoo8-addon-l10n-fr-department' error
ModuleNotFoundError: No module named 'odoo8-addon-l10n-fr-department'
ModuleNotFoundError: No module named 'odoo8-addon-l10n-fr-department' ...: No module named 'odoo8-addon-l10n-fr-department' How to remove the ModuleNotFoundError: No module named 'odoo8-addon-l10n-fr-department' error
ModuleNotFoundError: No module named 'odoo9-addon-l10n-fr-department'
ModuleNotFoundError: No module named 'odoo9-addon-l10n-fr-department' ...: No module named 'odoo9-addon-l10n-fr-department' How to remove the ModuleNotFoundError: No module named 'odoo9-addon-l10n-fr-department' error
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
dropdown
DropDown list
DropDown list  how to get mysql database values into dropdown usign java servlet and ajax?   Here is a jsp code that displays the database values into dropdown list. 1)country.jsp: <%@page import="java.sql.*"%>
login page
login page  code for login page
Dependant Dropdown Lists
Dependant Dropdown Lists  Hello, I'm trying to create 2 dropdown lists. When the visitor chooses one option from the 1st list it will automatically update the 2nd dropdown. Ive already found some code which i edited but still
dropdown list in jsp
dropdown list in jsp  hai, i have static dropdown list.. i want to get the selected value in string variable without jsp regards asha
html dropdown not working firefox
html dropdown not working firefox  I am writing a Dropdown code in HTML which is not working in firefox. What could be the reason as it's perfectly working in IE and Crome. Thanks
creating dropdown lists in jsp
creating dropdown lists in jsp  i want to create two dropdown list which are dependent that is the first box choice have to evaluate the second boxs options
populate dropdown box
populate dropdown box  hi, Is there any ways in which i can populate my dropdown menu with values from 1 to n (n = the value stored in database... item in dropdown menu is 10 then the second dropdown box should contain values
ajax+dropdown+table format
ajax+dropdown+table format  HI, i am looking for an ajax application which must contain two dropdown list.In first dropdown if i select a manager name from the first dropdown all the reporties under the selected manager should
ModuleNotFoundError: No module named 'odoo10-addon-analytic-base-department'
ModuleNotFoundError: No module named 'odoo10-addon-analytic-base-department...: ModuleNotFoundError: No module named 'odoo10-addon-analytic-base-department' How...-department' error? Thanks   Hi, In your python environment you
ModuleNotFoundError: No module named 'odoo10-addon-l10n-fr-department-delivery'
ModuleNotFoundError: No module named 'odoo10-addon-l10n-fr-department-delivery...: ModuleNotFoundError: No module named 'odoo10-addon-l10n-fr-department-delivery' How...-department-delivery' error? Thanks   Hi, In your python
ModuleNotFoundError: No module named 'odoo10-addon-l10n-fr-department-oversea'
ModuleNotFoundError: No module named 'odoo10-addon-l10n-fr-department-oversea...: ModuleNotFoundError: No module named 'odoo10-addon-l10n-fr-department-oversea' How...-department-oversea' error? Thanks   Hi, In your python
ModuleNotFoundError: No module named 'odoo10-addon-l10n-fr-department-delivery'
ModuleNotFoundError: No module named 'odoo10-addon-l10n-fr-department-delivery...: ModuleNotFoundError: No module named 'odoo10-addon-l10n-fr-department-delivery' How...-department-delivery' error? Thanks   Hi, In your python
ModuleNotFoundError: No module named 'odoo10-addon-l10n-fr-department-oversea'
ModuleNotFoundError: No module named 'odoo10-addon-l10n-fr-department-oversea...: ModuleNotFoundError: No module named 'odoo10-addon-l10n-fr-department-oversea' How...-department-oversea' error? Thanks   Hi, In your python
ModuleNotFoundError: No module named 'odoo10-addon-partner-contact-department'
ModuleNotFoundError: No module named 'odoo10-addon-partner-contact-department...: ModuleNotFoundError: No module named 'odoo10-addon-partner-contact-department' How...-contact-department' error? Thanks   Hi, In your python
ModuleNotFoundError: No module named 'odoo10-addon-project-department'
ModuleNotFoundError: No module named 'odoo10-addon-project-department' ...: ModuleNotFoundError: No module named 'odoo10-addon-project-department' How to remove the ModuleNotFoundError: No module named 'odoo10-addon-project-department' error
ModuleNotFoundError: No module named 'odoo10-addon-purchase-request-department'
ModuleNotFoundError: No module named 'odoo10-addon-purchase-request-department...: ModuleNotFoundError: No module named 'odoo10-addon-purchase-request-department' How...-request-department' error? Thanks   Hi, In your python
ModuleNotFoundError: No module named 'odoo10-addons-oca-department'
ModuleNotFoundError: No module named 'odoo10-addons-oca-department'  ...: No module named 'odoo10-addons-oca-department' How to remove the ModuleNotFoundError: No module named 'odoo10-addons-oca-department' error
ModuleNotFoundError: No module named 'odoo10-addons-oca-department'
ModuleNotFoundError: No module named 'odoo10-addons-oca-department'  ...: No module named 'odoo10-addons-oca-department' How to remove the ModuleNotFoundError: No module named 'odoo10-addons-oca-department' error

Ads