QuestionAsk Questions?
View Answers
February 5, 2009 at 3:53 AM
Hi vasu,
I am sending login application connected with database. Please implement following code:
<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>
I am sending login application connected with database. Please implement following code:
<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>
February 5, 2009 at 3:54 AM
Action file :
<%@ 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/
Thanks.
Amardeep
<%@ 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/
Thanks.
Amardeep
February 6, 2009 at 2:48 AM
Hi! vasu
use singleton design pattern. This should help u , if am not wrong.
If performs some thing like a static object & in that implement a logic which if d connection is present it should return else d existing obj will be returned.
Regards,
Krishna.Kantimahantu
use singleton design pattern. This should help u , if am not wrong.
If performs some thing like a static object & in that implement a logic which if d connection is present it should return else d existing obj will be returned.
Regards,
Krishna.Kantimahantu
Related Pages:
