QuestionAsk Questions?
View Answers
September 13, 2008 at 10:59 AM
Hi friend,
<html>
<title>login application in jsp</title>
<head>
<script type="text/javascript">
function validateForm(theForm){
if(theForm.userid.value==""){
//Please enter username
alert("Please enter User Name.");
theForm.userid.focus();
return false;
}
if(theForm.password.value==""){
//please enter passward
alert("Please enter Password.");
theForm.password.focus();
return false;
}
return true;
}
</script>
</head>
<body>
<br>
<br/>
<center>
<table border="1" width="400px" bgcolor="pink" cellspacing="0" cellpadding="0">
<tr>
<td width="100%">
<form method="POST" action="loginAction.jsp" onsubmit="return validateForm(this);">
<h2 align="center"><font color="red">Login Application in JSP</font></h2>
<table border="0" width="350px" cellspacing="2" cellpadding="4">
<tr>
<td width="50%"><b>User Name:</b></td>
<td width="50%"><input type="text" name="userid" size="20"/> </td>
</tr>
<tr>
<td width="50%"><b>Password:</b></td>
<td width="50%"><input type="password" name="password" size="20"/> </td>
</tr>
</table>
<center>
<p><input type="submit" value="Submit" name="submit">
<input type="reset" value="Reset" name="reset"></p>
</center>
</form>
</td>
</tr>
</table>
</center>
</body>
</html>
<html>
<title>login application in jsp</title>
<head>
<script type="text/javascript">
function validateForm(theForm){
if(theForm.userid.value==""){
//Please enter username
alert("Please enter User Name.");
theForm.userid.focus();
return false;
}
if(theForm.password.value==""){
//please enter passward
alert("Please enter Password.");
theForm.password.focus();
return false;
}
return true;
}
</script>
</head>
<body>
<br>
<br/>
<center>
<table border="1" width="400px" bgcolor="pink" cellspacing="0" cellpadding="0">
<tr>
<td width="100%">
<form method="POST" action="loginAction.jsp" onsubmit="return validateForm(this);">
<h2 align="center"><font color="red">Login Application in JSP</font></h2>
<table border="0" width="350px" cellspacing="2" cellpadding="4">
<tr>
<td width="50%"><b>User Name:</b></td>
<td width="50%"><input type="text" name="userid" size="20"/> </td>
</tr>
<tr>
<td width="50%"><b>Password:</b></td>
<td width="50%"><input type="password" name="password" size="20"/> </td>
</tr>
</table>
<center>
<p><input type="submit" value="Submit" name="submit">
<input type="reset" value="Reset" name="reset"></p>
</center>
</form>
</td>
</tr>
</table>
</center>
</body>
</html>
September 13, 2008 at 11:02 AM
<%@ page language="java" import="java.sql.*" import="java.util.*" %>
<%
String userid = request.getParameter("userid");
String password = request.getParameter("password");
Connection con = null;
String url = "jdbc:mysql://192.168.10.211:3306/";;
String db = "amar";
String driver = "com.mysql.jdbc.Driver";
String userName ="amar";
String pass="amar123";
try {
Class.forName(driver);
con = DriverManager.getConnection(url+db,userName,pass);
Statement st = con.createStatement();
String strQuery = "select * from login where userid='"+userid+"' and password='"+password+"'";
out.println(strQuery);
ResultSet rs = st.executeQuery(strQuery);
while(rs.next()){
if((rs.getString(1).equals("admin")) && (rs.getString(2).equals("admin")))
{
session.setAttribute("userid",userid);
response.sendRedirect("userForm.jsp");
}
if((rs.getString(1).equals("user")) && (rs.getString(2).equals("user")))
{
session.setAttribute("userid",userid);
response.sendRedirect("registrationForm.jsp");
}
else{
response.sendRedirect("loginForm.jsp");
}
}
System.out.println("Connected to the database");
con.close();
} catch (Exception e) {
e.printStackTrace();
}
%>
------------------------------------------------
Visit for more information.
http://www.roseindia.net/jsp/bank.shtml
Thanks & Regards
Amardeep
<%
String userid = request.getParameter("userid");
String password = request.getParameter("password");
Connection con = null;
String url = "jdbc:mysql://192.168.10.211:3306/";;
String db = "amar";
String driver = "com.mysql.jdbc.Driver";
String userName ="amar";
String pass="amar123";
try {
Class.forName(driver);
con = DriverManager.getConnection(url+db,userName,pass);
Statement st = con.createStatement();
String strQuery = "select * from login where userid='"+userid+"' and password='"+password+"'";
out.println(strQuery);
ResultSet rs = st.executeQuery(strQuery);
while(rs.next()){
if((rs.getString(1).equals("admin")) && (rs.getString(2).equals("admin")))
{
session.setAttribute("userid",userid);
response.sendRedirect("userForm.jsp");
}
if((rs.getString(1).equals("user")) && (rs.getString(2).equals("user")))
{
session.setAttribute("userid",userid);
response.sendRedirect("registrationForm.jsp");
}
else{
response.sendRedirect("loginForm.jsp");
}
}
System.out.println("Connected to the database");
con.close();
} catch (Exception e) {
e.printStackTrace();
}
%>
------------------------------------------------
Visit for more information.
http://www.roseindia.net/jsp/bank.shtml
Thanks & Regards
Amardeep
Related Pages:
If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.
Ask your questions, our development team will try to give answers to your questions.
Tutorial Topics
