jsp using include & with mysql

Sir,

I am creating a login application using jsp & Mysql. 

The Codes are---


Html File......


<html>
<head><title>LOGIN APPLICATION</title></head>
<body bgcolor="sky blue">
<font color="red"><b><blink>PLEASE ENTER THE USERID AND PASSWORD...........</blink></b></font>
<br>
<br>
<form method="get" action="login.jsp">
Enter UserId:<input type="text" name="userId"><br>
Enter Password:<input type="password" name="password"><br><br><br>

<input type="submit" value="LOGIN">
</form>
</body>
</html>


Jsp file.......

<%@ page import="java.sql.*" %>

<%

String mailid=request.getParameter("userId");
String password=request.getParameter("password");

Class.forName(application.getInitParameter("driverclass"));

Connection con=DriverManager.getConnection(application.getInitParameter("url"),application.getInitParameter("user"),application.getInitParameter("password"));

PreparedStatement stmt=con.prepareStatement("Select name from userinfo where mailid=? and password=?");

stmt.setString(1,mailid);
stmt.setString(2,password);

ResultSet rset=stmt.executeQuery();

if (rset.next())
{
    out.println("Welcome"+rset.getString(1));
}
else
{
    out.println("Invalid Userid Or Password.");

    %>

<%@ include file="login.html" %>

        <%
}
        out.close();
        %>



  WEB.xml...........

<web-app>

<context-param>
<param-name>driverclass</param-name>
<param-value>com.mysql.jdbc.Driver</param-value>
</context-param>

<context-param>
<param-name>url</param-name>
<param-value>jdbc:mysql://localhost:3306/userinfo</param-value>
</context-param>


<context-param>
<param-name>url</param-name>
<param-value>root</param-value>
</context-param>

<context-param>
<param-name>url</param-name>
<param-value>root</param-value>
</context-param>

</web-app>

It will producing error like...........

type Exception report

message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

org.apache.jasper.JasperException
    org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:372)
    org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
    org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

root cause

java.lang.NullPointerException
    java.lang.Class.forName0(Native Method)
    java.lang.Class.forName(Class.java:164)
    org.apache.jsp.login_jsp._jspService(login_jsp.java:55)
    org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
    org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
    org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
    org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

note The full stack trace of the root cause is available in the Apache Tomcat/5.0.28 logs.

Please tell me the complete solution.


  Thanks,,,,

View Answers

August 8, 2011 at 1:21 PM

It seems that application doesn't find mysql connector jar file. Download it and put it into lib of jdk and in tomcat lib.

Please go through the following link:

JSP Login Application

Ads

Advertisements

how to fetch image from mysql using jsp
how to fetch image from mysql using jsp how to fetch image from mysql using jsp

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

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

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

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

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

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

include a jsp file
include a jsp file Sir, I have 2 jsp pages. I want to include second jsp in the first jsp page when a button in the first jsp is clicked. how can I do this. I tried in sevaral ways . I am using jsp and javascript... anyone

Using MYSQL Database with JSP & Servlets.
Using MYSQL Database with JSP & Servlets. ... acceres the MYSQL database. Here I am using MYSQL & tomcat server... current command quit (\q) Quit 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

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

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

Dynamic include jsp
Dynamic include jsp I need dynamic include jsp page with an example

JSP Include jsp
JSP Include jsp ... include either a static or dynamic file in a JSP file. If the file is static, its...;Includes Jsp Page</h2> <jsp:include page="includedJsp.jsp" >

Passing Parameter with <jsp: include>
a file in a jsp page. While using <jsp:param> we are adding...--> <jsp:include page="AccessincludedParameter.jsp"> <jsp...Passing Parameter with <jsp: include>

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

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

jsp:include action tag
jsp:include action tag In this section we will discuss about JSP "include" action tag. The jsp "include" tag is used to include... into Servlet. The include tag is used to include another resource it may be jsp

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

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/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

Ads