JSP- common dbase connection

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>

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

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