jsp fie execution in tomcat and using mysql

View Answers

July 7, 2009 at 12:23 PM

Hi Friend,

There is a problem in both JSP pages.
If you want to login,try the following code:

1)form.jsp:
<html>
<head>
<title>User Login</title>
<style type = "text/css">
body
{ font-family: tahoma, helvetica, arial, sans-serif; }
table, tr, td
{ font-size: .9em;
border: 3px groove;
padding: 5px;
background-color: #dddddd;
}
</style>
</head>
<body>
<form method = "post" action = "userLogin.jsp">
<p>Enter The User Name and Password to Log into our Student Database</p>
<table>
<tr>
<td>User name</td>
<td>
<input type = "text" name = "username" />
</td>
</tr>

<tr>
<td>Password</td>
<td>
<input type = "password" name = "password" />
</td>
</tr>
<tr>
<td colspan = "2">
<input type = "submit" value = "Log In" />
</td>
</tr>
</table>
</form>
</body>
</html>
2)userLogin.jsp:
<%@ page import = "java.sql.*" %>
<%@ page errorPage = "userDataviewErrorpage.jsp" %>
<%
String name1 = request.getParameter( "username" );
String name2 = request.getParameter( "password" );

Connection connection = null;
Statement statement = null;
Class.forName( "com.mysql.jdbc.Driver");

connection = DriverManager.getConnection( "jdbc:mysql://localhost:3306/test";, "root", "root" );
statement = connection.createStatement();

ResultSet resultSet = statement.executeQuery("SELECT * from login where username='"+name1+"' and password='"+name2+"'" );
if(resultSet.next()){
out.println("Welcome"+name1);
}else{
out.println("Invalid Username or Password");
}
%>

3)userDataviewErrorpage.jsp:
<%@ page isErrorPage = "true" %>
<html>
<head>
<title>Error!</title>

<style type = "text/css">
.bigRed
{font-size: 2em;
color: red;
font-weight: bold;
}
</style>
</head>
<p class = "bigRed">

The error message was: <br />
<%= exception.getMessage() %>
</p>
<p class = "bigRed">Please try again later</p>
</body>
</html>

The username and password that we used in the JDBC Connection are the MySql username and password.The code we have provided you checks whether the entered username and password is valid or not.

Thanks

July 7, 2009 at 12:29 PM

continue..........

And If you want to insert the new username and password,then try the following code:

<%@ page import = "java.sql.*" %>
<%@ page errorPage = "an.jsp" %>
<%
String name1 = request.getParameter( "username" );
String name2 = request.getParameter( "password" );

Connection connection = null;
Statement statement = null;
Class.forName( "com.mysql.jdbc.Driver");

connection = DriverManager.getConnection( "jdbc:mysql://localhost:3306/test";, "root", "root" );
statement = connection.createStatement();
int i=statement.executeUpdate("Insert into login(username,password) values('"+name1+"','"+name2+"')");

%>

For more information,please visit the following link:

http://www.roseindia.net/jsp/javascriptpagerefresh.shtml
http://www.roseindia.net/jsp/loginstatus.shtml

Hope that it will be helpful for you.
Thanks