jsp fie execution in tomcat and using mysql

Ads
 

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

Ads









Related Tutorials/Questions & Answers:
jsp using include & with mysql
jsp using include & with mysql  Sir, I am creating a login application using jsp & Mysql. The Codes are--- Html File...... <... and in tomcat lib. Please go through the following link: JSP Login Application
how to fetch image from mysql using jsp
how to fetch image from mysql using jsp  how to fetch image from mysql using jsp
Advertisements
login page with mysql using jsp
login page with mysql using jsp  pls i need a sample of login page to check username and password in mysql database. thanks
Image upload in mysql database using jsp servlet
Image upload in mysql database using jsp servlet  Hello, I need code to insert image in mysql database, I have seen the code which is already in your... located inside the application, but i need to upload in mysql and also for inserting
upload csv to mysql db using jsp upload
upload csv to mysql db using jsp upload  Hello all, Please give me the code to uplad .csv from jsp page and insert values into MySQl db. I have a table with 8 cloumns.(MDN--varchar(30),Otafdate date,crt varchar(30),dmdn
login page using jsp servlrt with mysql database?
login page using jsp servlrt with mysql database?  Description: example:total users are 3.each use have username and password save in mysql database table login. After successfully login user1 see only index page,if user2 login
How to connect mysql with jsp
How to connect mysql with jsp  how to connect jsp with mysql while using apache tomcat
Exporting data from mysql into csv using jsp
Exporting data from mysql into csv using jsp  Hi friends.... I want to export the data from mysql to csv file using... i am having 30 columns in my... want csv file with 10 rows.. i want to do in jsp... pls help me soon..its very
Read Excel data using JSP and update MySQL databse
Read Excel data using JSP and update MySQL databse  HOw to read excel data using JSP and update MySQl database
insert name city and upload image in database using mysql and jsp
insert name city and upload image in database using mysql and jsp   insert name city and upload image in database using mysql and jsp
access image from ajax store in mysql using jsp
access image from ajax store in mysql using jsp  access image from ajax store in mysql using jsp (code to access image captured by camera and store in mysql
get info from mysql using jsp and servlet
get info from mysql using jsp and servlet  HELLO! I wanna create a jsp page which able to let me get its name, phone and other info by asking the user to key in their email address from mysql database by using servlet and jsp too
retrive the employee details with image from mysql database using jsp servlet
retrive the employee details with image from mysql database using jsp servlet  im doing the web project to retrive the employee profile which i stored in the database using jsp servlet then want to show the result in the next jsp
JSP &MYSQL
JSP &MYSQL  Develop a web page for the telephone directory using jsp and mysql
how to upload an image from a jsp page to a mysql database table using jsp
how to upload an image from a jsp page to a mysql database table using jsp  how to upload an image from a jsp page to a mysql database table using jspstrong text
retrieve related data from database using jsp and mysql
retrieve related data from database using jsp and mysql  Hi sir, please give some example of jsp code for retrieving mysql database values in multiple dropdown list. if we change a value in a dropdown its related value must
JSP tomcat hosting
JSP tomcat hosting  Hi, What is JSP tomcat hosting? Thanks  ... application on internet. But if you are using Tomcat to host the applications then the hosting environment is called as jsp tomcat hosting. There are many
Data needs to be gathered in XML file from the database (MySql) using JSP
in XML file from the database (MySql) using appropriate JSP/Java Bean functions...Data needs to be gathered in XML file from the database (MySql) using JSP ... files. using following database create database music; use music; CREATE
netbeans with mysql and tomcat
netbeans with mysql and tomcat  Hi. I have to run a JSP or JAVA file in netbeans with mysql database and tomcat server 7.0. But while the page loading itself it say error. ClassNotFoundException: com.mysql.jdbc.Driver. How
insert name city image in database using mysql and jsp
insert name city image in database using mysql and jsp  how to insert name ,city and image in database in mysql and jsp   Here is an example in jsp that insert name, city and image to database. <%@ page import
fetch and insert multiple rows into mysql database using jsp servlet
fetch and insert multiple rows into mysql database using jsp servlet  ... jsp form and want inserting it into my mysql database table. but i am having a problem to insert multiple rows into database using a single insert query
Storing and retrieving data alongwith image in mysql db using jsp
Storing and retrieving data alongwith image in mysql db using jsp  I want to store and retrieve the whole data as shown below in mysql db. I've put in my all efforts for building this jsp but I'm not able to understand where's
How to change image size before adding to mysql using jsp
How to change image size before adding to mysql using jsp  I want to upload an image to MySQL DB, before inserting the image I want to change the image size as per defined by me and then I want to store that image into my DB
how to store image in folder and stored image path in mysql database using JSP
how to store image in folder and stored image path in mysql database using JSP  how to store image in folder and stored image path in mysql database using JSP
JSP with Mysql
JSP with Mysql  Hi sir, I trying to several time but i am not get an answer. My questions are 1. How to inserting same field data to different mysql table using jsp. That is creating a form with 5 fields,data's are same
how to display data from mysql table in text box using jsp??
how to display data from mysql table in text box using jsp??  <p>hi, i have a written a code to display data from a mysql table into txtboxes... at line: 113 in the jsp file: /Cat1.jsp The local variable v_RGPC may not have
jsp/mysql connection
jsp/mysql connection  I am puttng the following files in the lib folder of jdk to connect jsp and mysql and in the lib folder of tomacat and in the lib folder of project of netbeans but I am unable to to connect jsp and mysql
jsp/mysql connection
jsp/mysql connection  I am puttng the following files in the lib folder of jdk to connect jsp and mysql and in the lib folder of tomacat and in the lib folder of project of netbeans but I am unable to to connect jsp and mysql
MySQL Generate AlphaNumberic Id In JSP
numeric id using MySQL as database, tomcat 7 as a server for deploying the JSP...MySQL Generate AlphaNumberic Id In JSP In this section we will discus about how to generate id in specific format in MySQL and JSP. This example explains
jsp and mysql
jsp and mysql  i have a form which contains dropdown list. i have to take the values to another jsp page and perform the calculation on the database which i have earlier using the values of the selected dropdown list
jsp mysql
........... like that all requests nd comments should be display through jsp and mysql...jsp mysql  actually i want a page that has two frames nd in 1 frame i'l add a textarea to post some help nd nw when he clicks on post button it has

Ads