Posted by

danielniko

Posted on

April 17, 2012

Posted under

Java Web, Uncategorized

Comments

229 Comments

Simple CRUD Using Jsp, Servlet and MySQL

You can view and download the complete source code of this tutorial from my github account.

In this tutorial, we will create a simple CRUD (Create Read Update Delete) User Management Web Application using Jsp, Servlet and MySQL.

For this tutorial, we will need the following tools: (The older or newer version should also works). Moreover, basic Java knowledge is assumed.

1. Eclipse IDE for Java EE Developers (Indigo – ver. 3.7)

2. Apache Tomcat ver 7.0

3. MySQL Community Server and MySQL Workbench (GUI Tool)

4. MySQL Connector for Java

5. jstl.jar and standard.jar. You can get these jars from your Tomcat. Check in this directory : (your tomcat directory)—>apache-tomcat-7.0.26-windows-x86—>apache-tomcat-7.0.26—>webapps—>examples—>WEB-INF—>lib

I will tell you where you should put these jars later.

6. jQuery for javascript capability. In this case, we only use it for the datepicker component

First, lets create the database and table for User using the following SQL scripts:

create database UserDB;
use UserDB;
grant all on UserDB.* to 'admin'@'localhost' identified by 'test'; 

CREATE TABLE UserDB.`users` (
  `userid` int(11) NOT NULL AUTO_INCREMENT,
  `firstname` varchar(45) DEFAULT NULL,
  `lastname` varchar(45) DEFAULT NULL,
  `dob` date DEFAULT NULL,
  `email` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`userid`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8

Go to eclipse. Before we create a new project for our application, we need to setup the server. Select File—>New—>Other. From the tree, Select Server.

Choose Apache—>Tomcat v7.0 Server and set the runtime environment.

Next, create a new project. Select File—>New—>Dynamic Web Project.

Enter “SimpleJspServletDB” as the project name. Select target runtime to Apache Tomcat v7.0 which we already setup before. Click Finish.

Please refer to this project directory in case you miss something along the way

Copy the standard.jar, mysql-connector jar and jstl jar to WEB-INF—>lib folder.

Create four packages in the src folder.

com.daniel.controller: contains the servlets
com.daniel.dao: contains the logic for database operation
com.daniel.model: contains the POJO (Plain Old Java Object). Each class in this package represents the database table. For this tutorial, however, we only have one table.
com.daniel.util : contains the class for initiating database connection

Next, create a new Java class. in com.daniel.model folder. Name it “User.java” and insert these following codes. Each of the variables in this class represents the field in USERS table in our database.

package com.daniel.model;

import java.util.Date;

public class User {

    private int userid;
    private String firstName;
    private String lastName;
    private Date dob;
    private String email;
    public int getUserid() {
        return userid;
    }
    public void setUserid(int userid) {
        this.userid = userid;
    }
    public String getFirstName() {
        return firstName;
    }
    public void setFirstName(String firstName) {
        this.firstName = firstName;
    }
    public String getLastName() {
        return lastName;
    }
    public void setLastName(String lastName) {
        this.lastName = lastName;
    }
    public Date getDob() {
        return dob;
    }
    public void setDob(Date dob) {
        this.dob = dob;
    }
    public String getEmail() {
        return email;
    }
    public void setEmail(String email) {
        this.email = email;
    }
    @Override
    public String toString() {
        return "User [userid=" + userid + ", firstName=" + firstName
                + ", lastName=" + lastName + ", dob=" + dob + ", email="
                + email + "]";
    }    
}

Create a new class in com.daniel.util package and name it DbUtil.java. This class handles the database connection to our MySQL server. In this class, we read a .properties file which contains the information necessary for the connection.

package com.daniel.util;

import java.io.FileNotFoundException;
import java.io.IOException;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.Properties;

public class DbUtil {

    private static Connection connection = null;

    public static Connection getConnection() {
        if (connection != null)
            return connection;
        else {
            try {
                Properties prop = new Properties();
                InputStream inputStream = DbUtil.class.getClassLoader().getResourceAsStream("/db.properties");
                prop.load(inputStream);
                String driver = prop.getProperty("driver");
                String url = prop.getProperty("url");
                String user = prop.getProperty("user");
                String password = prop.getProperty("password");
                Class.forName(driver);
                connection = DriverManager.getConnection(url, user, password);
            } catch (ClassNotFoundException e) {
                e.printStackTrace();
            } catch (SQLException e) {
                e.printStackTrace();
            } catch (FileNotFoundException e) {
                e.printStackTrace();
            } catch (IOException e) {
                e.printStackTrace();
            }
            return connection;
        }

    }
}

Create the properties file directly under the src folder. Create a new file, name it db.properties. Put the following information inside.

driver=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost:3306/UserDB
user=admin
password=test

Next, create a new class in com.daniel.dao package, name it UserDao.java. Dao stands for Data Access Object. It contains the logic for database operation.

package com.daniel.dao;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;
import com.daniel.model.User;
import com.daniel.util.DbUtil;

public class UserDao {

    private Connection connection;

    public UserDao() {
        connection = DbUtil.getConnection();
    }

    public void addUser(User user) {
        try {
            PreparedStatement preparedStatement = connection
                    .prepareStatement("insert into users(firstname,lastname,dob,email) values (?, ?, ?, ? )");
            // Parameters start with 1
            preparedStatement.setString(1, user.getFirstName());
            preparedStatement.setString(2, user.getLastName());
            preparedStatement.setDate(3, new java.sql.Date(user.getDob().getTime()));
            preparedStatement.setString(4, user.getEmail());
            preparedStatement.executeUpdate();

        } catch (SQLException e) {
            e.printStackTrace();
        }
    }

    public void deleteUser(int userId) {
        try {
            PreparedStatement preparedStatement = connection
                    .prepareStatement("delete from users where userid=?");
            // Parameters start with 1
            preparedStatement.setInt(1, userId);
            preparedStatement.executeUpdate();

        } catch (SQLException e) {
            e.printStackTrace();
        }
    }

    public void updateUser(User user) {
        try {
            PreparedStatement preparedStatement = connection
                    .prepareStatement("update users set firstname=?, lastname=?, dob=?, email=?" +
                            "where userid=?");
            // Parameters start with 1
            preparedStatement.setString(1, user.getFirstName());
            preparedStatement.setString(2, user.getLastName());
            preparedStatement.setDate(3, new java.sql.Date(user.getDob().getTime()));
            preparedStatement.setString(4, user.getEmail());
            preparedStatement.setInt(5, user.getUserid());
            preparedStatement.executeUpdate();

        } catch (SQLException e) {
            e.printStackTrace();
        }
    }

    public List<User> getAllUsers() {
        List<User> users = new ArrayList<User>();
        try {
            Statement statement = connection.createStatement();
            ResultSet rs = statement.executeQuery("select * from users");
            while (rs.next()) {
                User user = new User();
                user.setUserid(rs.getInt("userid"));
                user.setFirstName(rs.getString("firstname"));
                user.setLastName(rs.getString("lastname"));
                user.setDob(rs.getDate("dob"));
                user.setEmail(rs.getString("email"));
                users.add(user);
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }

        return users;
    }

    public User getUserById(int userId) {
        User user = new User();
        try {
            PreparedStatement preparedStatement = connection.
                    prepareStatement("select * from users where userid=?");
            preparedStatement.setInt(1, userId);
            ResultSet rs = preparedStatement.executeQuery();

            if (rs.next()) {
                user.setUserid(rs.getInt("userid"));
                user.setFirstName(rs.getString("firstname"));
                user.setLastName(rs.getString("lastname"));
                user.setDob(rs.getDate("dob"));
                user.setEmail(rs.getString("email"));
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }

        return user;
    }
}

Finally, create a new Servlet inside the com.daniel.controller package and name it UserController.java

package com.daniel.controller;

import java.io.IOException;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.Date;

import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import com.daniel.dao.UserDao;
import com.daniel.model.User;

public class UserController extends HttpServlet {
    private static final long serialVersionUID = 1L;
    private static String INSERT_OR_EDIT = "/user.jsp";
    private static String LIST_USER = "/listUser.jsp";
    private UserDao dao;

    public UserController() {
        super();
        dao = new UserDao();
    }

    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        String forward="";
        String action = request.getParameter("action");

        if (action.equalsIgnoreCase("delete")){
            int userId = Integer.parseInt(request.getParameter("userId"));
            dao.deleteUser(userId);
            forward = LIST_USER;
            request.setAttribute("users", dao.getAllUsers());    
        } else if (action.equalsIgnoreCase("edit")){
            forward = INSERT_OR_EDIT;
            int userId = Integer.parseInt(request.getParameter("userId"));
            User user = dao.getUserById(userId);
            request.setAttribute("user", user);
        } else if (action.equalsIgnoreCase("listUser")){
            forward = LIST_USER;
            request.setAttribute("users", dao.getAllUsers());
        } else {
            forward = INSERT_OR_EDIT;
        }

        RequestDispatcher view = request.getRequestDispatcher(forward);
        view.forward(request, response);
    }

    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        User user = new User();
        user.setFirstName(request.getParameter("firstName"));
        user.setLastName(request.getParameter("lastName"));
        try {
            Date dob = new SimpleDateFormat("MM/dd/yyyy").parse(request.getParameter("dob"));
            user.setDob(dob);
        } catch (ParseException e) {
            e.printStackTrace();
        }
        user.setEmail(request.getParameter("email"));
        String userid = request.getParameter("userid");
        if(userid == null || userid.isEmpty())
        {
            dao.addUser(user);
        }
        else
        {
            user.setUserid(Integer.parseInt(userid));
            dao.updateUser(user);
        }
        RequestDispatcher view = request.getRequestDispatcher(LIST_USER);
        request.setAttribute("users", dao.getAllUsers());
        view.forward(request, response);
    }
}

Now, it’s time for us to create the jsp, the view for our application. Under the WebContent folder, create a jsp file, name it index.jsp

<%@ page language="java" contentType="text/html; charset=EUC-KR" pageEncoding="EUC-KR"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=EUC-KR">
<title>Insert title here</title>
</head>
<body>
<jsp:forward page="/UserController?action=listUser" />
</body>
</html>

This jsp serves as the entry point for our application. In this case, it will redirect the request to our servlet to list all the users in the database.

Next, create the jsp to list all the users in the WebContent folder. Name it listUser.jsp

<%@ page language="java" contentType="text/html; charset=EUC-KR" pageEncoding="EUC-KR"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/fmt" prefix="fmt"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=EUC-KR">
<title>Show All Users</title>
</head>
<body>
    <table border=1>
        <thead>
            <tr>
                <th>User Id</th>
                <th>First Name</th>
                <th>Last Name</th>
                <th>DOB</th>
                <th>Email</th>
                <th colspan=2>Action</th>
            </tr>
        </thead>
        <tbody>
            <c:forEach items="${users}" var="user">
                <tr>
                    <td><c:out value="${user.userid}" /></td>
                    <td><c:out value="${user.firstName}" /></td>
                    <td><c:out value="${user.lastName}" /></td>
                    <td><fmt:formatDate pattern="yyyy-MMM-dd" value="${user.dob}" /></td>
                    <td><c:out value="${user.email}" /></td>
                    <td><a href="UserController?action=edit&userId=<c:out value="${user.userid}"/>">Update</a></td>
                    <td><a href="UserController?action=delete&userId=<c:out value="${user.userid}"/>">Delete</a></td>
                </tr>
            </c:forEach>
        </tbody>
    </table>
    <p><a href="UserController?action=insert">Add User</a></p>
</body>
</html>

In this jsp, we use JSTL to connect between the jsp and the servlet. We should refrain from using scriplet inside the jsp because it will make the jsp more difficult to maintain. Not to mention it will make the jsp looks ugly.

Next, create a new jsp in WebContent folder and name it user.jsp

<%@ page language="java" contentType="text/html; charset=EUC-KR" pageEncoding="EUC-KR"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/fmt" prefix="fmt"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=EUC-KR">
<link type="text/css"
    href="css/ui-lightness/jquery-ui-1.8.18.custom.css" rel="stylesheet" />
<script type="text/javascript" src="js/jquery-1.7.1.min.js"></script>
<script type="text/javascript" src="js/jquery-ui-1.8.18.custom.min.js"></script>
<title>Add new user</title>
</head>
<body>
    <script>
        $(function() {
            $('input[name=dob]').datepicker();
        });
    </script>

    <form method="POST" action='UserController' name="frmAddUser">
        User ID : <input type="text" readonly="readonly" name="userid"
            value="<c:out value="${user.userid}" />" /> <br /> 
        First Name : <input
            type="text" name="firstName"
            value="<c:out value="${user.firstName}" />" /> <br /> 
        Last Name : <input
            type="text" name="lastName"
            value="<c:out value="${user.lastName}" />" /> <br /> 
        DOB : <input
            type="text" name="dob"
            value="<fmt:formatDate pattern="MM/dd/yyyy" value="${user.dob}" />" /> <br /> 
        Email : <input type="text" name="email"
            value="<c:out value="${user.email}" />" /> <br /> <input
            type="submit" value="Submit" />
    </form>
</body>
</html>

Lastly, check the web.xml file located in WebContent—>WEB-INF folder in your project structure. Make sure it looks like this

<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://java.sun.com/xml/ns/javaee" xmlns:web="http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd" id="WebApp_ID" version="2.5">
  <display-name>SimpleJspServletDB</display-name>
  <welcome-file-list>
    <welcome-file>index.jsp</welcome-file>
  </welcome-file-list>
  <servlet>
    <description></description>
    <display-name>UserController</display-name>
    <servlet-name>UserController</servlet-name>
    <servlet-class>com.daniel.controller.UserController</servlet-class>
  </servlet>
  <servlet-mapping>
    <servlet-name>UserController</servlet-name>
    <url-pattern>/UserController</url-pattern>
  </servlet-mapping>
</web-app>

That is it. Right click the project name and run it using Run As–>Run on server option.

229 thoughts on “Simple CRUD Using Jsp, Servlet and MySQL”

stvflyer says:

May 10, 2012 at 4:48 pm

Hi I am trying to run your example and I am getting The requested resource (/SimpleJspServletDB/listUser.jsp) is not available. I have the listUser.jsp in the WebContent folder so I am not sure why its not seeing it.

Reply
- stvflyer says:
  
  May 10, 2012 at 4:56 pm
  
  Its all good got it working! Thanks for the very clear example! Finally I found one on the web. Thank you!
  
  Reply
  - Dean says:
    
    March 8, 2013 at 3:25 pm
    
    What was the issue im having the same problem you had
  - reyan says:
    
    April 28, 2013 at 8:57 am
    
    What did you do men I also encounter an error ?
    
    HTTP Status 404 – /SimpleJspServletDB/
    
    ——————————————————————————–
    
    type Status report
    
    message /SimpleJspServletDB/
    
    description The requested resource is not available.
    
    ——————————————————————————–
    
    Apache Tomcat/7.0.35
  - Ghous Khan says:
    
    May 20, 2013 at 8:34 pm
    
    Check your user.jsp,listUser.jsp and index.jsp files they must be under the WebContent folder
  - gui_gofu says:
    
    June 27, 2013 at 2:07 pm
    
    thanks, that project was very useful.
    about the error message, in my case was the configuration of the libraries. In the project check:
    java resources>libraries>JRE System Library>right click>properties and choose the jre that you have installed in your system, it is jre7 in my case.
  - Vinay says:
    
    January 24, 2017 at 5:55 pm
    
    Hello.. I have updated this example but in my case I have some more int fields .my problem is when I insert a int value in the table it is showing me null
  - shiva says:
    
    June 15, 2017 at 8:59 pm
    
    how did u do that. am also getting same error.
- Kiran says:
  
  July 26, 2013 at 6:16 am
  
  I am also having the same problem.Only thing i done is I kept all jsp files in folder named ‘jsp’.My tomcat is not starting now. It is unable to start up.I attempted by putting all code as it is. pls suggest me what should i do??
  
  Reply
- Claire says:
  
  March 6, 2014 at 3:01 am
  
  What did you do with this error ?
  
  type Exception report
  
  message An exception occurred processing JSP page /index.jsp at line 9
  
  description The server encountered an internal error that prevented it from fulfilling this request.
  
  exception
  
  org.apache.jasper.JasperException: An exception occurred processing JSP page /index.jsp at line 9
  
  6: Insert title here
  7:
  8:
  9:
  10:
  11:
  
  Reply
- Ajeet Singh says:
  
  January 10, 2015 at 10:33 am
  
  hi i also tried to built a web application using this tutorial but i am also getting the same error plz tell me what mistake u did and how did u overcome i mean how u removed that error.??
  
  Reply
- shiva says:
  
  June 15, 2017 at 8:58 pm
  
  how did u solve that.
  
  Reply
  - meryem says:
    
    November 28, 2018 at 4:58 pm
    
    Did u solve it?
rian says:

May 29, 2012 at 3:52 pm

may I ask source code?

Reply
baapu says:

July 30, 2012 at 3:36 pm

Thank’s …
It was simple and the best crud for servlet +jsp+jquery+mysql I ever found

Reply
- manoj says:
  
  September 21, 2012 at 10:22 am
  
  wesome Example
  
  Reply
Pal Babu Giri says:

August 1, 2012 at 2:42 am

Thanks, Really a very helpful tutorial.

Reply
Travis says:

August 3, 2012 at 8:05 pm

How do you do this part?

First, lets create the database and table for User using the following SQL scripts:

create database UserDB;
use UserDB;
grant all on UserDB.* to ‘admin’@’localhost’ identified by ‘test’;

CREATE TABLE UserDB.`users` (
`userid` int(11) NOT NULL AUTO_INCREMENT,
`firstname` varchar(45) DEFAULT NULL,
`lastname` varchar(45) DEFAULT NULL,
`dob` date DEFAULT NULL,
`email` varchar(100) DEFAULT NULL,
PRIMARY KEY (`userid`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8

never used a script before, the rest the tutorial is super simple but I got lost right here

Reply
- abanggultom says:
  
  September 14, 2012 at 1:59 am
  
  just copy and paste the script to any sql editor and run it 😀
  as my post said, i use MySQL Workbench GUI.
  sorry for the late reply, i hope by now you already figure it out
  
  Reply
Oscar says:

August 30, 2012 at 5:03 pm

you rock! thx for saving me a lot of time 😀

Reply
benjamin says:

September 7, 2012 at 1:02 am

Excellent, your tutorial was clear and very good

Reply
TSL says:

September 20, 2012 at 2:23 am

Thank a lot for sharing

Reply
Pingback: JSPs and Servlets Tutorials | Saikat's space
Abhijeet says:

September 22, 2012 at 1:20 pm

nice and clear example thx

Reply
omya says:

October 5, 2012 at 3:00 pm

hey, I try to implement your code..
I try to save some datas,
after I debug it, I realize that the code through catch(SqlException e){}
my datas unable to save to database..
What does the SqlException means ?
How can I fix this?

Reply
Paulo Cassiano says:

October 29, 2012 at 5:13 pm

I`m following the entire post, but…

http://localhost:8080/SimpleJspServletDB/

HTTP Status 404 –

…

How can I fix this?

Reply
- Nishara says:
  
  November 5, 2012 at 7:40 am
  
  Same here
  
  Reply
- Deval Dholariya says:
  
  March 13, 2013 at 4:46 am
  
  i have same Error :
  
  HTTP Status 404 – /SimpleJspServletDB/UserController>action=listuser
  
  ——————————————————————————–
  
  type Status report
  
  message /SimpleJspServletDB/UserController>action=listuser
  
  description The requested resource (/SimpleJspServletDB/UserController>action=listuser) is not available.
  
  ——————————————————————————–
  
  so please give me a solution of that Error :
  
  Reply
- Ghous Khan says:
  
  May 20, 2013 at 8:35 pm
  
  Check your user.jsp,listUser.jsp and index.jsp files they must be under the WebContent folder
  
  Reply
  - andrew says:
    
    March 15, 2016 at 2:49 am
    
    you have listuser there. it should be listUser
sangram panda says:

October 30, 2012 at 7:54 am

Thanks dude………………………………
nice tutorial and u explain it very clearly.

all files are loosely coupled also.
thanks again

Reply
v.laksmi says:

November 1, 2012 at 10:18 am

very clear cut tutorial, thanks a lot
v.laksmi

Reply
- akshaha says:
  
  November 22, 2017 at 9:23 am
  
  k tell me about servlet page in jsp
  
  Reply
Fandi Akhmad says:

November 20, 2012 at 3:22 am

Hello, thanks for your tutorials.
But i want to ask, how do you manage an application in folders? I confused manage url in Servlet, because my application’s view i put in folders spearately.

Thank you

Reply
Niraj says:

November 21, 2012 at 11:59 am

Fantastic tutorial! Well explained! Thank you very much!

Reply
nanda says:

November 25, 2012 at 5:04 pm

nice..
tnks a lot

Reply
Jeffyt says:

November 28, 2012 at 4:18 pm

Thank you! This really helped me get my head around Java servlets and Tomcat implementation. Was able to get a sample up and running that provides a good basis going forward.

Reply
rahul says:

December 20, 2012 at 11:41 am

package com.daniel.controller;

import java.io.IOException;

import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.Date;

import javax.servlet.RequestDispatcher ;//errors m getting
import javax.servlet.ServletException; ;//errors m getting
import javax.servlet.http.HttpServlet; ;//errors m getting
import javax.servlet.http.HttpServletRequest; ;//errors m getting
import javax.servlet.http.HttpServletResponse; ;//errors m getting

import com.daniel.dao.UserDao;
import com.daniel.model.User;

public class UserController extends HttpServlet {
private static final long serialVersionUID = 1L;
private static String INSERT_OR_EDIT = “/user.jsp”;
private static String LIST_USER = “/listUser.jsp”;
private UserDao dao;

public UserController() {
super();
dao = new UserDao();
}

protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException,

Reply
rahul says:

December 20, 2012 at 1:09 pm

If i have to add search functionality by user id then how togo for it

I have used the same code that has been used for delete.
and i have forward that to search.jsp and in this the code is same ajust as list users.jsp

and also how to make the build file
plz suggest

Reply
rank says:

December 27, 2012 at 5:42 pm

Hi when i execute this code i am got an error as

HTTP Status 500 –

——————————————————————————–

type Exception report

message

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

exception

org.apache.jasper.JasperException: An exception occurred processing JSP page /index.jsp at line 10

7: Insert title here
8:
9:
10:
11:
12:

Stacktrace:
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:553)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:457)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:391)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334)
javax.servlet.http.HttpServlet.service(HttpServlet.java:722)

root cause

java.lang.NullPointerException
com.daniel.dao.UserDao.getAllUsers(UserDao.java:69)
com.daniel.controller.UserController.doGet(UserController.java:63)
javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
org.apache.jasper.runtime.PageContextImpl.doForward(PageContextImpl.java:745)
org.apache.jasper.runtime.PageContextImpl.forward(PageContextImpl.java:716)
org.apache.jsp.index_jsp._jspService(index_jsp.java:63)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:419)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:391)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334)
javax.servlet.http.HttpServlet.service(HttpServlet.java:722)

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

——————————————————————————–
Please tell me the solutions
Thanks in Advance

Reply
- KJohn says:
  
  February 13, 2013 at 4:20 pm
  
  See my comment below about the private members of User class. Not sure if thats the prob, you didnt provide the full stack trace.
  
  Reply
- suresh says:
  
  November 26, 2013 at 6:44 pm
  
  hi
  I am also getting same error please help me
  
  Reply
- Rodrigo Araújo says:
  
  July 22, 2014 at 1:35 pm
  
  if someone still get this error, i made a small crud example here: http://www.universocomputacao.com/computer-science-basics-1-crud-java-jsp-mysql/
  
  Reply
  - sembang says:
    
    May 10, 2015 at 9:04 am
    
    hye sir..why i cant insert my data using your code..??need help actually…
  - meryem says:
    
    November 28, 2018 at 5:17 pm
    
    it’s not working anymore
santosh says:

January 11, 2013 at 10:36 am

Thank you so much……U made my day 🙂 cheers

Reply
Ben Chapman says:

January 11, 2013 at 12:13 pm

Reblogged this on Ben Chapman and commented:
Here’s an excellent tutorial on how to create a basic database-powered JSP-driven application.

Reply
PRAMOD says:

January 13, 2013 at 8:21 pm

i have one form i should get insert data and update data on same form using two button on same page add new….update

Reply
Pochomaz says:

January 28, 2013 at 8:31 pm

Hi! if i have two or more “model” classes.. how many servlets are neccessary? one for each class? Like UserController, Class2Controller… ClassNController OR One BIIIG controller to handle all the classes.. Thank you for the tutorial, it is excellent!! sorry for my english!

Reply
- abanggultom says:
  
  January 29, 2013 at 12:20 am
  
  if the operations are complex, best to use one servlet for each model, but if it is simple and the model always interact together, you can use one big controller. whichever suits your taste. after all you are the one who will develop it.
  
  Reply
Poonam says:

January 31, 2013 at 5:06 pm

how to use the same logic in struts framework ??

Reply
russel says:

February 5, 2013 at 10:39 am

Hi,
I’ve been able to run your great example, but I’ve troubles setting the correct date format in the JSP user.jsp:

the pattern defined is ignored and the listUser show the DOB as yyyy-MM-dd. I really cannot understand what’s wrong.

Thanks

Reply
farid says:

February 12, 2013 at 6:54 pm

how to run using eclipse?

Reply
KJohn says:

February 13, 2013 at 4:18 pm

This is an excellent tutorial, however you must have made some changes to the User class, and did not update the other classes. The data members of User are all ‘private’, and in listUser and user.jsp, you try to reference these directly:
”

”

This fails and throws a null pointer exception. (HTTP Error 500 returned).

These need to say:
”

“

Reply
- KJohn says:
  
  February 13, 2013 at 4:25 pm
  
  Dang, the code got stripped. If you look in listUser.jsp, when you have value = user.userid, that will fail. It needs to use the get method of the User class: value = user.getUserid().
  
  Reply
- KJohn says:
  
  February 14, 2013 at 4:24 pm
  
  Nevermind! (I’m sure most can tell that I’m still learning this stuff!)
  The errors were due to my dynamic web project using Servlet 3.0, whereas your project (since it includes web.xml) is using 2.5.
  There are probably other minor configs that differ (how you use the JSTL) that can cause the HTTP 500 error.
  
  Fun stuff!
  
  Reply
- kw says:
  
  June 25, 2014 at 11:56 pm
  
  Hi,
  
  I still have the NullPointerException, can anyone help with that?
  
  Reply
Nikos says:

February 17, 2013 at 1:26 am

Great tutorial!!!! It is the first one that helped through clean and easy to read code. Thanx!!!
Some search would be perfect

Reply
ricky says:

February 19, 2013 at 10:00 am

Good tutorial..but i find one bug in listuser when i refresh the page list row is go on adding with the previous result.Please tell me how to fix it.

Thanks,

Reply
- Alan Morelli says:
  
  April 30, 2014 at 12:11 pm
  
  me too i’m looking for a solution to this problem
  
  Reply
KJohn says:

February 19, 2013 at 9:45 pm

This package will work on your local machine as you start/stop your server, but it will not work when deployed to a server which stays up, and database queries are not performed within 8 hours (or whatever your MySQL timeout is set to). The Connection object you instantiated will be closed, but will not be null, and the queries will fail.
Need to check:
connection.isClosed() and connection.isValid() before you attempt to perform queries; if those fail, you need to create a new connection.

Or, use a DataSource Object (with PooledConnections) instead of DriverManager to create your Connection.

Reply
fathson says:

February 23, 2013 at 1:16 pm

Hi, very nice tuto.Ii have a trouble someone can show how or where to download the jstl.jar and the standar.jar. Since i looked on web but i can’t find them. Thx

Reply
- ossevangelist says:
  
  March 12, 2013 at 2:20 pm
  
  All files are availabe at github, as also mentioned by the writer in this very first line of this tutorial. Writer has also provided the link.
  
  “You can view and download the complete source code of this tutorial from my github account.”
  
  Reply
- ossevangelist says:
  
  March 12, 2013 at 2:26 pm
  
  All the source files are available at github as mentioned by writer at the very first line of this tutorial. Writer has also provided the link in the second line.
  
  Pls let me know if you have any issue.
  
  Reply
Neha says:

March 4, 2013 at 9:31 am

Hi,
After adding all the files to respected directories i ma getting error in jsp pages listUser.jsp and user.jsp where the following to lines are not ecognsed.

i have added the jstljar and standard.jas files to WebContent->WEB-INF->lib directory

please help me.
Thanks
NehaLBK

Reply
- GNU says:
  
  March 12, 2013 at 2:44 pm
  
  Did you add all three jar files from writer’s github account to webcontent->WEB_INF->lib ?
  
  Reply
  - Neha says:
    
    March 13, 2013 at 3:43 am
    
    Hi,
    The example is working fine. Grate tutorial. But i need a example to upload any file(.doc,.pdf,.jpg etc) to oracle database Clob data type, and display it back in the same format when needed. I tried many examples but they upload only images or .txt files and display is in binay format. Please can you help me?
    Thanks in advance.
Neha says:

March 4, 2013 at 9:35 am

The uri’s are as follows which are not recognzed

taglib uri=”http://java.sun.com/jsp/jstl/core” prefix=”c”
taglib uri=”http://java.sun.com/jsp/jstl/fmt” prefix=”fmt”

Reply
fatma says:

March 13, 2013 at 8:32 pm

hi,
you need just to add the library : jstl 1.2.jar

Reply
Deval Dholariya says:

March 18, 2013 at 5:10 am

i have process as per given code furthere if give problem to me.
I cant show user List on jsp page.

Not give any Error and bugs. it also pass listarray and show in consol but i can show in table and i can not insert a new data. please give me a solution.

Reply
Deval Dholariya says:

March 18, 2013 at 9:25 am

i got this error :

org.apache.jasper.JasperException: An exception occurred processing JSP page /listUser.jsp at line 33

30:
31:
32:
33:
34:
35:
36:

Stacktrace:
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:553)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:457)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:391)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334)
javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
com.d.controller.UserController.doPost(UserController.java:121)
javax.servlet.http.HttpServlet.service(HttpServlet.java:641)
javax.servlet.http.HttpServlet.service(HttpServlet.java:722)

Reply
- tulus wahyuno says:
  
  December 16, 2016 at 4:25 am
  
  please cek you web.xml, you must set the package same with your package, so YOURNAMEPACKAGE.CLASS
  
  Reply
sanjeev says:

March 25, 2013 at 8:47 am

may I ask source code?

Reply
suresh says:

March 31, 2013 at 6:47 am

Hi,
I am using the same code. I got this exception in server startup time…

javax.servlet.ServletException: Wrapper cannot find servlet class com.daniel.controller.UserController or a class it depends on
org.apache.jasper.runtime.PageContextImpl.doForward(PageContextImpl.java:706)
org.apache.jasper.runtime.PageContextImpl.forward(PageContextImpl.java:677)
org.apache.jsp.index_jsp._jspService(index_jsp.java:68)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

Can any one help me..

Cheers,
Suresh

Reply
wew says:

April 6, 2013 at 7:19 pm

Mas bro, kodingan ente ga bisa di input, terus ada yang salah parameter tuh…
seharusnya “string”.equalsIgnoreCase(action)
yang di controller…

entah kenapa

Reply
Mostovenko Alexander says:

April 21, 2013 at 5:48 pm

thanks man)

Reply
payal says:

April 22, 2013 at 12:24 am

Hello KJohn,
Awesome tutotrial, Thanks for your efforts. I am getting this error… “javax.el.PropertyNotFoundException: The class ‘com.daniel.model.User’ does not have the property ‘getUserid’. I have tried everything . My program loads in my weblogic server but when I insert a new user and try to submit..thats where I am getting this error. I would appreciate if you can please help me .
I already added the get Userid in ListUser as you have mentioned earlier…that is not helping either.

I would appreciate hearing back from you.

thanks.

Reply
- Noel says:
  
  May 3, 2015 at 9:34 pm
  
  It’s easy! Just change the first letter of your variables to lowerCase.
  You should respect the Java naming conventions. Variables always start with a lowercase letter. Properties also start with a lowercase letter. And since the Members class represents one member, you should also call it Member, not Members.
  
  Reply
Waqqas Sheikh says:

May 13, 2013 at 10:56 am

Excellent Tutorial. Saved me a tonne of time. One question though: is the code thread-safe?

Reply
Flemes says:

May 15, 2013 at 5:34 pm

Hi, there

I have been trying your tutorial, but server is always returning the error below:

java.lang.NullPointerException
at com.entera.user.dao.UserDao.getAllUsers(UserDao.java:74)
…

As if connection was not being created. But I was unable figure it out. Can you help me?

Best regards,

Flemes

Reply
steve says:

May 18, 2013 at 12:00 pm

is there a way to do the project without using an IDE? [for 30+ years i’ve done it the text editor and love it.]

Reply
- steve says:
  
  May 18, 2013 at 12:02 pm
  
  meant: ‘the text editor way’
  
  Reply
  - James says:
    
    September 15, 2013 at 3:52 am
    
    I’m sure you can it is just a matter of file location and ensuring pointers are all correct.
Talib Hassan says:

May 25, 2013 at 2:47 pm

Thanks for this nice tutorials

Reply
Roman says:

June 12, 2013 at 3:04 pm

thanks for greate tutorial. it works perfectly. but I faced some problems when tried to add jquery libs via maven so I decided to remove ‘date of birth’ (dob) field and all references to it from data base table, jsp pages, UserDao.java and User.java.

Reply
steve says:

June 16, 2013 at 2:50 pm

Dude.
Best, best, best example of crud using jsp. Totally, the best. You da man! woo woo.

Reply
Kathy says:

July 3, 2013 at 6:03 am

Gracias

Reply
Dev says:

July 17, 2013 at 10:13 am

HTTP Status 503 – Servlet UserController is currently unavailable

type Status report

messageServlet UserController is currently unavailable

descriptionThe requested service (Servlet UserController is currently unavailable) is not currently available.
GlassFish Server Open Source Edition 3.1.1

Reply
Dev says:

July 17, 2013 at 10:17 am

Same Time 1st Error..(I m suing netbens)
HTTP Status 500 –

type Exception report

message

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

exception

javax.servlet.ServletException: PWC1392: Error instantiating servlet class com.daniel.controller.UserController

root cause

com.sun.enterprise.container.common.spi.util.InjectionException: Error creating managed object for class: class com.daniel.controller.UserController

root cause

java.lang.reflect.InvocationTargetException

root cause

java.lang.NullPointerException

note The full stack traces of the exception and its root causes are available in the GlassFish Server Open Source Edition 3.1.1 logs.
GlassFish Server Open Source Edition 3.1.1

2nd When I build —
Deleting directory D:\Java project\Example\SimpleJspServletDB\build
D:\Java project\Example\SimpleJspServletDB\nbproject\build-impl.xml:1054: Unable to delete file D:\Java project\Example\SimpleJspServletDB\build\web\WEB-INF\lib\jstl.jar
BUILD FAILED (total time: 3 seconds)

Reply
edwinangar says:

July 17, 2013 at 10:12 pm

thanks!!! you have really helped me 🙂

Reply
Kiran says:

July 26, 2013 at 6:19 am

I am also having the same problem.Only thing i done is I kept all jsp files in folder named ‘jsp’.My tomcat is not starting now. It is unable to start up.I attempted by putting all code as it is. pls suggest me what should i do??

Reply
Houda says:

August 5, 2013 at 5:49 pm

Hi ,I have problem in UserContorl and this is the exception:

18:44:41,446 INFO [org.jboss.as.server.deployment] (MSC service thread 1-7) JBAS015876: Starting deployment of “SimpleJspServletDB.war”
18:44:41,486 WARN [org.jboss.as.ee] (MSC service thread 1-2) JBAS011006: Not installing optional component com.controller.UserController due to exception: java.lang.ClassNotFoundException: com.controller.UserController from [Module “deployment.SimpleJspServletDB.war:main” from Service Module Loader]
at org.jboss.modules.ModuleClassLoader.findClass(ModuleClassLoader.java:190) [jboss-modules.jar:1.1.1.GA]
at org.jboss.modules.ConcurrentClassLoader.performLoadClassUnchecked(ConcurrentClassLoader.java:468) [jboss-modules.jar:1.1.1.GA]
at org.jboss.modules.ConcurrentClassLoader.performLoadClassChecked(ConcurrentClassLoader.java:456) [jboss-modules.jar:1.1.1.GA]
at org.jboss.modules.ConcurrentClassLoader.performLoadClassChecked(ConcurrentClassLoader.java:423) [jboss-modules.jar:1.1.1.GA]
at org.jboss.modules.ConcurrentClassLoader.performLoadClass(ConcurrentClassLoader.java:398) [jboss-modules.jar:1.1.1.GA]
at org.jboss.modules.ConcurrentClassLoader.loadClass(ConcurrentClassLoader.java:120) [jboss-modules.jar:1.1.1.GA]
at java.lang.Class.forName0(Native Method) [rt.jar:1.6.0_33]
at java.lang.Class.forName(Class.java:247) [rt.jar:1.6.0_33]
at org.jboss.as.server.deployment.reflect.DeploymentClassIndex.classIndex(DeploymentClassIndex.java:54) [jboss-as-server-7.1.1.Final.jar:7.1.1.Final]
at org.jboss.as.ee.component.deployers.EEModuleConfigurationProcessor.deploy(EEModuleConfigurationProcessor.java:79)
at org.jboss.as.server.deployment.DeploymentUnitPhaseService.start(DeploymentUnitPhaseService.java:113) [jboss-as-server-7.1.1.Final.jar:7.1.1.Final]
at org.jboss.msc.service.ServiceControllerImpl$StartTask.startService(ServiceControllerImpl.java:1811) [jboss-msc-1.0.2.GA.jar:1.0.2.GA]
at org.jboss.msc.service.ServiceControllerImpl$StartTask.run(ServiceControllerImpl.java:1746) [jboss-msc-1.0.2.GA.jar:1.0.2.GA]
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) [rt.jar:1.6.0_33]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) [rt.jar:1.6.0_33]
at java.lang.Thread.run(Thread.java:662) [rt.jar:1.6.0_33]

Reply
ajay says:

September 10, 2013 at 8:57 am

Thanks for the example.I am completely ok with the example and I have executed it properly..If any one have any question..mail me at ajay.c20@gmail.com..

Reply
- liya says:
  
  May 3, 2014 at 6:49 am
  
  how do i update again a form after retrieving data from existing database?
  
  Reply
James says:

September 15, 2013 at 3:45 am

Works beautifully, love the dbutil inputstream nice touch

Reply
prashansa kumari says:

September 18, 2013 at 6:31 pm

very good tutorial…….

Reply
Ankesh says:

September 22, 2013 at 8:57 pm

why did not you map the insert action to any of the jsp’s. i am not able to move to next page from home page.

Reply
jose says:

October 6, 2013 at 6:31 pm

this is absolutely great, i’ve tried this with ms sql server and it works with the correct adapter obviously.

Reply
Emiliano says:

October 6, 2013 at 9:48 pm

Hi Daniel,
I was looking example of CRUD JSP encontri a website and I have copied your content.

Is this site here:
http://rajkamalsingh.in/simple-crud-jspservlet-mysql/

Reply
rapi.Exponent says:

October 11, 2013 at 7:53 am

This Tutorial has a clear,clean instructions and so Helpful…. thank you so much!

Reply
andy says:

October 12, 2013 at 3:34 pm

thanks dude
it’s really helpful

Reply
andy says:

October 12, 2013 at 6:52 pm

but for now you will get “side effect” after submiting new user. thats why it is better use redirect instead of request dispatcher.

Reply
KAVI says:

October 23, 2013 at 6:42 am

how to copy jstl jar into web-inf???

Reply
- KAVI says:
  
  October 23, 2013 at 6:51 am
  
  how to copy jstl jar into web-inf???
  
  Reply
KAVI says:

October 23, 2013 at 6:53 am

Can any one pls say me….

Reply
- abanggultom says:
  
  October 23, 2013 at 6:58 am
  
  just find the jar file inside your apache folder as described in the post and copy it into the WEB-INF/lib folder
  
  Reply
  - KAVI says:
    
    October 23, 2013 at 7:40 am
    
    thank u….but when i open this jar it show the exception message….now what can i do?
  - KAVI says:
    
    October 23, 2013 at 10:03 am
    
    i got it…thank u
calvin says:

November 13, 2013 at 2:40 pm

hi..
how to change into POST. so that the url when you update or delete can be invisible
thanks.

Reply
suresh says:

November 26, 2013 at 6:23 pm

Hi All,
we got this exception please help me what i made mistake here.
//http://localhost:9989/SimpleJspServletDB/ when i tryed this url.

SEVERE: Servlet.service() for servlet UserController threw exception
java.lang.NullPointerException
at com.daniel.dao.UserDao.getAllUsers(UserDao.java:71)
at com.daniel.controller.UserController.doGet(UserController.java:44)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646)

Reply
- niraj says:
  
  December 11, 2013 at 5:32 am
  
  make database .
  
  Reply
suresh says:

December 2, 2013 at 9:19 am

worked like a charm…thanks

Reply
Aman says:

December 18, 2013 at 4:21 pm

Thank you for your clear instruction.

Reply
- vinay says:
  
  December 26, 2013 at 9:46 am
  
  When I run the program , I am getting this error,any suggestions?
  HTTP Status 404 – /CRUD/UserController
  
  Reply
Thilina Waasalage says:

January 14, 2014 at 4:36 am

Dude thank you man this is awesome

Reply
Alonso says:

January 23, 2014 at 6:44 pm

Gracias, me ha ayudado mucho en mis estudios. Y lo verdaderamente increíble es que ha funcionado a la primera.

Thanks, it helped me a lot in my studies. And the truly amazing thing is that it worked the first time.

Reply
Lech says:

January 28, 2014 at 9:29 am

You might also mention that one should put jQuery libraries into WebContent/js folder. At first I didn’t even recognize that something is wrong. I was putting the date manually and wondering what this jQuery snippet is used for? 😉
And the better way might be using absolute directories e.g.

Nevertheless it is truly awesome tutorial for beginners! Very big THANKS! 🙂

Reply
Stephen Mogg says:

February 27, 2014 at 11:47 pm

Hi, and thanks so much for this great tutorial. I am using these principles in a small project which has several related tables. When listing data for some object, I would like to include descriptor information from a related table, and example would be if your user tables had a company_id, I would want to display company_name from a related table (company, primary key on company_id).

I can see a few ways of doing this, but see problems with all of them.

1. change the sql of the getuser functions include company information via a join, and populate necessare elements in the object (duplicate and cross dependancies in code)

2. change the user object to include a company object, and then do a getCompanyById for each user in the resultset (processing intensive).

3. a bastardisation of the two, using a join query to return user and company information and using the same results set to create user and related company objects (company object would not neccessarily be complete).

Perhaps I am completed on the wrong track. Can someone tell me the best way to proceed,

Regards
Stephen

Reply
myfaizzz says:

March 5, 2014 at 6:24 am

Hi, i got this error, can you fix it please.

HTTP Status 503 – Servlet UserController is currently unavailable

type Status report

message Servlet UserController is currently unavailable

description The requested service is not currently available.

Reply
myfaizzz says:

March 5, 2014 at 6:29 am

and sometimes i also find this error.

HTTP Status 500 – javax.servlet.ServletException: Error instantiating servlet class com.daniel.controller.UserController

type Exception report

message javax.servlet.ServletException: Error instantiating servlet class com.daniel.controller.UserController

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

exception

org.apache.jasper.JasperException: javax.servlet.ServletException: Error instantiating servlet class com.daniel.controller.UserController
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:549)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:455)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:390)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334)
javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)

Reply
myfaizzz says:

March 5, 2014 at 7:21 am

Hi, when I try to run my project it seems ok, but when i clik button submit the page directly go to here :

HTTP Status 500 –

type Exception report

message

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

exception

java.lang.NullPointerException
net.roseindia.dao.UserDao.getAllUsers(UserDao.java:75)
net.roseindia.handler.UserHandler.doGet(UserHandler.java:76)
javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
org.netbeans.modules.web.monitor.server.MonitorFilter.doFilter(MonitorFilter.java:393)

please help me..
thanks

Reply
Claire says:

March 6, 2014 at 3:06 am

Please help, I got this error:

type Exception report

message An exception occurred processing JSP page /index.jsp at line 9

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

exception

org.apache.jasper.JasperException: An exception occurred processing JSP page /index.jsp at line 9

6: Insert title here
7:
8:
9:
10:
11:

Reply
- Claire says:
  
  March 6, 2014 at 3:07 am
  
  Here is the error at line 9:
  9:
  
  Reply
Claire says:

March 6, 2014 at 5:44 am

Hi, update and delete is working but for add it’s not. I got this error. Please Help. Thank you!

java.lang.NullPointerException
com.daniel.dao.UserDao.addUser(UserDao.java:28)
com.daniel.controller.UserController.doPost(UserController.java:67)
javax.servlet.http.HttpServlet.service(HttpServlet.java:647)
javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)

Reply
Krishna says:

March 7, 2014 at 8:53 pm

I got this problem. I am sure I get help with it because many people have successfully run it.

HTTP Status 500 – An exception occurred processing JSP page /index.jsp at line 9

——————————————————————————–

type Exception report

message An exception occurred processing JSP page /index.jsp at line 9

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

exception

org.apache.jasper.JasperException: An exception occurred processing JSP page /index.jsp at line 9

6: Insert title here
7:
8:
9:
10:
11:

Stacktrace:
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:568)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:470)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:390)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334)
javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)

root cause

java.lang.NullPointerException
com.daniel.dao.UserDao.getAllUsers(UserDao.java:71)
com.daniel.controller.UserController.doGet(UserController.java:44)
javax.servlet.http.HttpServlet.service(HttpServlet.java:620)
javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
org.apache.jasper.runtime.PageContextImpl.doForward(PageContextImpl.java:750)
org.apache.jasper.runtime.PageContextImpl.forward(PageContextImpl.java:720)
org.apache.jsp.index_jsp._jspService(index_jsp.java:71)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:432)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:390)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334)
javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)

Reply
- Anone says:
  
  December 2, 2015 at 7:14 am
  
  Is this article based from this? http://thejavatrail.blogspot.jp/2012/08/step-by-step-guide-developing-mvc.html
  
  Reply
Krishna says:

March 8, 2014 at 8:06 pm

I have found a root cause of the above problem myself. I will give the answer as well. It’s pretty simple but unless we knot it’s hard.

Problem: Driver could not be loaded (that I found by putting System.out.println logging statement in many places in DbUtil.java file)

Solution: Placed JDBC driver inside lib folder of the web app directory (download from internet and copy and paste)

When I put the JDBC driver in the java build path (right click the web app root directory > build path > configure build path), it did not work. It has to be put under the specific web directory.

Reply
Michele.T says:

March 31, 2014 at 9:40 am

Hi, thank you very much for your tutorial. I have a question: how can I handle mora tables? If I have 3 tables, how I handle Controllers and pages with forward???
Thak you

Reply
Dinesh Reddy says:

April 16, 2014 at 8:14 am

HTTP Status 404 – /facultymange/UserController

——————————————————————————–

type Status report

message /facultymange/UserController

description The requested resource is not available.

——————————————————————————–

Apache Tomcat/6.0.39

can u fix it

Reply
mkulisep says:

April 25, 2014 at 10:56 am

Great example. Finally got it to work after 3 days of debugging. Thanks 😀

Reply
Mario says:

April 28, 2014 at 2:34 pm

http://localhost:8080/SimpleJspServletDB/

Estado HTTP 503 – Servlet UserController is currently unavailable

How to fix this error? cause i import this project in Eclipse EE (Kepler) and inside the UserController.java i have error in the imports:

import java.io.IOException;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.Date;

And in this line:
public class UserController extends HttpServlet {
Show me this error:
The hierarchy of the type UserController is inconsistent

What can I Do?

Reply
Alan Morelli says:

April 29, 2014 at 2:05 pm

how can i catch exception in public void addUser(User user) (for example if query returns an error) ?

if there is an error, it simply return to Users List without printin the exception
i want see every error that comes…

for the rest, very usefull post for newbie like me

thanks

Reply
Carlos says:

June 11, 2014 at 1:19 am

Very good example
thanks 😀

Reply
Alex says:

June 17, 2014 at 12:59 pm

Hello,

The tutorial seems great and it’s exactly what I was looking for 😀

Howerver, I am trying to get it to work on JBoss 5 instead of Tomcat. I have followed the intructions, without any modifications.

When I run the servlet, I get the following error:

2014-06-17 14:33:15,106 INFO [org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/SimpleJspServletDB]] (http-127.0.0.1-8080-2) Marking servlet UserController as unavailable

2014-06-17 14:33:15,106 ERROR [org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/SimpleJspServletDB].[UserController]] (http-127.0.0.1-8080-2) Excepción de reserva de espacio para servlet UserController [NOTE: i THINK THIS IS THE SAME AS
“UnavailableException”]
java.lang.NullPointerException
at java.util.Properties$LineReader.readLine(Unknown Source)
at java.util.Properties.load0(Unknown Source)
at java.util.Properties.load(Unknown Source)
at com.daniel.util.DbUtil.getConnection(DbUtil.java:21)
at com.daniel.dao.UserDao.(UserDao.java:18)
at com.daniel.controller.UserController.(UserController.java:25)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at java.lang.Class.newInstance(Unknown Source)
at org.jboss.web.tomcat.service.TomcatInjectionContainer.newInstance(TomcatInjectionContainer.java:264)
at org.jboss.web.tomcat.service.TomcatInjectionContainer.newInstance(TomcatInjectionContainer.java:256)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1006)
at org.apache.catalina.core.StandardWrapper.allocate(StandardWrapper.java:777)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:607)
at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:444)
at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:382)
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:310)
at org.apache.jasper.runtime.PageContextImpl.doForward(PageContextImpl.java:696)
at org.apache.jasper.runtime.PageContextImpl.forward(PageContextImpl.java:667)
at org.apache.jsp.index_jsp._jspService(index_jsp.java:62)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:369)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:322)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:249)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:235)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:190)
at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:92)
at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.process(SecurityContextEstablishmentValve.java:126)
at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.invoke(SecurityContextEstablishmentValve.java:70)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:158)
at org.bonitasoft.console.security.SessionFixationValve.invoke(SessionFixationValve.java:77)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:330)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:829)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:598)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
at java.lang.Thread.run(Unknown Source)

Reply
Akash says:

July 7, 2014 at 9:34 pm

Using this same example, how can we submit information from radio buttons or checkboxes?

Reply
MARIO RAMOS MOSCOL says:

July 19, 2014 at 3:08 am

Excelente !!!!!!! Limpio, claro, didáctico !!!!!! Muchas gracias.

Reply
Johne127 says:

August 2, 2014 at 5:28 pm

Magnificent beat ! I wish to apprentice even as you amend your site, how could i subscribe for a blog web site? The account helped me a acceptable deal. I were a little bit acquainted of this your broadcast offered bright transparent concept adcceebkkkgc

Reply
Waseem says:

August 6, 2014 at 4:40 pm

Good tutorial, very helpful. Thank you.

Reply
Mubarak Pathan says:

August 27, 2014 at 3:18 pm

Im getting this error when I run this

HTTP Status 503 – Servlet UserController is currently unavailable

type Status report

message Servlet UserController is currently unavailable

description The requested service is not currently available.

Apache Tomcat/7.0.42
any solution on tthis ??

Reply
mx30 says:

September 18, 2014 at 2:28 pm

Bonjour suis debutant en JEE j’ai testé le code CRUD l’ajout modifier et supprimmé sa marche, maintenant je veux créer une petite application je me suis confronté a des problemes , j’ai deux tables fournisseur et materiel la clé de la table fournisseur migré (clé etrangér ) dans la table materiel ,comment recuperé la clé etrangér dans la page JSP (select) , et le deuxiem blem j’ai vu la methode de la recherche dans la classe dao mais je sais pas comment le faire dans une page jsp , s’il te plait si quelqu’un peut m’aider.c’est urgen

Reply
Pingback: Jsp Y Mysql Tutorial Pdf | free pdf download
Burt Kohl's guest blog backlink says:

October 4, 2014 at 10:12 pm

When someone writes an piece of writing he/she maintains the idea of a user in his/her mind
that how a user can understand it. Thus that’s why this paragraph is great.
Thanks!

Reply
Eduardo Garrett says:

November 20, 2014 at 7:47 pm

JUST AWESOME!!
thanks man!

Reply
Pingback: Fix Jsp Error Message From Servlet Windows XP, Vista, 7, 8 [Solved]
Catatan says:

November 26, 2014 at 9:55 am

Thanks for the tutorial. Awesome!… 🙂

Reply
Hamza Ghani says:

November 28, 2014 at 9:11 pm

how is the data from listuser from being sent to the edit jsp page?

Reply
Hamza Ghani says:

November 30, 2014 at 9:38 am

How would you use a drop down to sort the data on the page

Reply
Avisek says:

December 21, 2014 at 11:45 am

Easy to digest.. 🙂 . Thanks a lot.

Reply
salaps says:

January 21, 2015 at 6:07 am

I’ve found and read this tutorial. I’ve never try this code but it seems clear and perfect tutorial. Thanks!

Reply
Sue says:

January 22, 2015 at 8:53 am

Hi. I tried to implement your example in netbeans with postgresql, there are no errors and it shows build successful but this is all that appears on the browser: “http://localhost:8080/SimpleJspServletDB/” in the url
and “TODO write content” on the page.
Would be really grateful if you could help out…

Reply
- Morteza Darksun says:
  
  June 26, 2015 at 8:08 am
  
  set your welcome file in web.xml
  
  Reply
dhruvin says:

February 8, 2015 at 4:05 am

HTTP Status 404 – Servlet UserController is not available

——————————————————————————–

type Status report

message Servlet UserController is not available

description The requested resource (Servlet UserController is not available) is not available.

Reply
salapso says:

February 20, 2015 at 12:08 am

It works fine but on Create, Read, and Delete. It isn’t working once you have selected the “Update”action

Example:
I have record to update the record below:

UserId Firstname | Lastname | BoD | Email | Action
1 | John | Doe | 02/02/1987 |jd@gmail.com | Update | Delete |

I have changed the record Last name “Doe” to “Wade” and clicked “Submit” button.
and it displayed record like this.

UserId Firstname | Lastname | BoD | Email | Action
1 | John | Doe | 02/02/1987 |jd@gmail.com | Update | Delete |
2 | John | Wade | 02/02/1987 |jd@gmail.com | Update | Delete |

Anyone encounter the same problem?
Thanks in advance.

Reply
Palanikumar says:

February 21, 2015 at 5:40 am

sorry sir i followed your procedure but it is not working properly

Reply
Palanikumar says:

February 21, 2015 at 6:05 am

HTTP Status 503 – Servlet UserController is currently unavailable

——————————————————————————–

type Status report

message Servlet UserController is currently unavailable

description The requested service is not currently available.

——————————————————————————–

Apache Tomcat/7.0.55

Reply
Palanikumar says:

March 18, 2015 at 6:19 am

Dear Friends, really very good examples servlet +jsp crud application program run perfectly. once again thank you so much

Reply
- aidana says:
  
  October 1, 2016 at 1:10 pm
  
  how did you fixed your problem with 503 error?
  
  Reply
Prasad says:

March 25, 2015 at 6:13 am

It was very useful for me. Thanks a lot

Reply
Kishan says:

March 30, 2015 at 6:36 am

Guys plz help me out. i am getting this error.

HTTP Status 404 – /SimpleJspServletDB/user.jsp

——————————————————————————–

type Status report

message /SimpleJspServletDB/user.jsp

description The requested resource (/SimpleJspServletDB/user.jsp) is not available.

——————————————————————————–

Apache Tomcat/7.0.12

Reply
Sravz says:

April 11, 2015 at 4:53 pm

HTTP Status 500 – javax.servlet.ServletException: Error instantiating servlet class com.daniel.controller.UserController

type Exception report

message javax.servlet.ServletException: Error instantiating servlet class com.daniel.controller.UserController

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

exception
org.apache.jasper.JasperException: javax.servlet.ServletException: Error instantiating servlet class com.daniel.controller.UserController
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:548)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:454)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:396)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:340)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)

root cause
javax.servlet.ServletException: Error instantiating servlet class com.daniel.controller.UserController
org.apache.jasper.runtime.PageContextImpl.doForward(PageContextImpl.java:741)
org.apache.jasper.runtime.PageContextImpl.forward(PageContextImpl.java:711)
org.apache.jsp.index_jsp._jspService(index_jsp.java:98)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:431)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:396)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:340)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)

root cause
java.lang.ClassNotFoundException: com.daniel.controller.UserController
org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1305)
org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1157)
org.apache.jasper.runtime.PageContextImpl.doForward(PageContextImpl.java:741)
org.apache.jasper.runtime.PageContextImpl.forward(PageContextImpl.java:711)
org.apache.jsp.index_jsp._jspService(index_jsp.java:98)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:431)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:396)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:340)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)

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

Apache Tomcat/8.0.21

Reply
Sravz says:

April 11, 2015 at 4:53 pm

Am getting the above error…. please help me resolve it….

Reply
Noel says:

May 3, 2015 at 9:14 pm

HTTP Status 500 – Internal Server Error

I tried to make my own template, but I got:
javax.el.PropertyNotFoundException: The class ‘model.EmployeeEntity’ does not have the property ‘EmployeeNumber’.
of course I declared it and has the set and get methods, I just change name of fields.
How can I solve this?

Thanks in advance;

Noel Flores from Nicaragua.
noelfloresr@gmail.com

Reply
- Noel says:
  
  May 3, 2015 at 9:35 pm
  
  I respond to myself:
  You should respect the Java naming conventions. Variables always start with a lowercase letter. Properties also start with a lowercase letter. And since the Members class represents one member, you should also call it Member, not Members.
  
  Reply

Hey there!

My propject is called imwsaogotardo and the Class directory is:

imwsaogotardo.src.util.Conexao.java

In this directory, i have only 2 files that is Conexao.java and db.properties, like this post

The Conection Class is this:

package util;
 
import java.io.FileNotFoundException;
import java.io.IOException;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.Properties;
 
public class Conexao {
 
    private static Connection connection = null;
 
    public static Connection getConnection() {
        if (connection != null)
            return connection;
        else {
            try {
                Properties prop = new Properties();
                InputStream inputStream = Conexao.class.getClassLoader().getResourceAsStream("util/db.properties");
                prop.load(inputStream);
                String driver = prop.getProperty("driver");
                String url = prop.getProperty("url");
                String user = prop.getProperty("user");
                String password = prop.getProperty("password");
                
                Class.forName(driver);
                connection = DriverManager.getConnection(url, user, password);
            } catch (ClassNotFoundException e) {
                e.printStackTrace();
            } catch (SQLException e) {
                e.printStackTrace();
            } catch (FileNotFoundException e) {
                e.printStackTrace();
            } catch (IOException e) {
                e.printStackTrace();
            }
            return connection;
        }
 
    }
}

The properties file is:

driver=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost:3306/imwsaogotardo
user=imwsaogotardo
password=carcleo

And is error is this:

HTTP Status 500 - 
 
 
type Exception report
 
message 
 
description The server encountered an internal error that prevented it from fulfilling this request.
 
exception
java.lang.NullPointerException
dao.ProfessorDAO.addProfessor(ProfessorDAO.java:39)
controller.ProfessorServlet.processRequest(ProfessorServlet.java:54)
controller.ProfessorServlet.doPost(ProfessorServlet.java:68)
javax.servlet.http.HttpServlet.service(HttpServlet.java:648)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
 
 
note The full stack trace of the root cause is available in the Apache Tomcat/8.0.22 logs.
 
 
Apache Tomcat/8.0.22

I put in the moment of conexao Class called a validator:

…
private Connection connection;

public ProfessorDAO()
{
connection = Conexao.getConnection();
if (connection==null)
{ System.out.println(“Fora do Ar”);}
else { System.out.println(“No Ar”);}
}
…

But it returns “Fora do Ar”.

Anyone can helpe-me?

Carlos Rocha says:

June 23, 2015 at 9:24 pm

trouble finish

My problem was the connectoer

mysql-connector-java-5.1.35-bin.jar

It not works

when i changed for

com.mysql.jdbc_5.1.5.jar

it now works!

Thank’s

Reply
rakesh says:

August 2, 2015 at 3:26 pm

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table ‘sakila.users’ doesn’t exist
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:400)
at com.mysql.jdbc.Util.getInstance(Util.java:383)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:980)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3847)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3783)

Loading different DB even though i configures right

Properties files:

driver=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost:3306/infytestdb

Reply
ramireddy says:

September 1, 2015 at 11:43 am

really Excellent Example in this one .
Thanks & Regards
RamiReddy

Reply
Randalllync says:

September 6, 2015 at 1:27 am

They make one sale to my advice and they collect cash from me for months, maybe long periods of time. Include that associated with time time to get your fans. Does the organization have an online presence?
mxswk
http://sadas22323sdsddasdadaasdas.com
ohp qx hrph

Reply
bmk says:

September 14, 2015 at 8:34 pm

guys send the source code for this mail id moneyshanth@gmail.com which getting exact out put .

Reply
Malvika says:

September 17, 2015 at 6:31 am

hello…when i run this program i got error..requested resource is not available…please help me..

Reply
- sai says:
  
  September 17, 2015 at 1:09 pm
  
  guys please guide me which jar files we have to import
  
  Reply
fgfdf says:

September 17, 2015 at 1:03 pm

not working

Reply
fgfdf says:

September 17, 2015 at 1:04 pm

HTTP Status 503 – Servlet Controller is currently unavailable

type Status report

message Servlet Controller is currently unavailable

description The requested service is not currently available.

please help me

Reply
- Bindu says:
  
  November 6, 2015 at 9:21 am
  
  HTTP Status 503 – Servlet Controller is currently unavailable
  
  type Status report
  
  message Servlet Controller is currently unavailable
  
  description The requested service is not currently available.
  
  Reply
sai says:

September 17, 2015 at 1:10 pm

guys please guide me which jar files we have to import

Reply
Pingback: Hibernate チュートリアル | Linuxよろず情報処
Pingback: Hibernate（まず最初は、Mysql、Tomcat、JSP、Servlet、Sql） | Linuxよろず情報処
Vara says:

November 9, 2015 at 2:39 pm

Very good detailing and great place to start building webapps. 🙂

Reply
Hajar says:

December 20, 2015 at 1:26 am

Hello !
Thank you for the tutorial. Deleting action works amazingly but the update action doesn’t work. I wonder if someone could help me.

Reply
news iphone 6s says:

January 9, 2016 at 9:26 pm

In Deutschland gibt es dann jedoch auch noch weitere Aktienindizes, wie
zum Beispiel den MDAX ( 50 Unternehmen, die dem Umsatz
nach den 30 DAX-Werten folgen) , SDAX (ebenfalls 50 Unternehmen,
die den 50 MDAX-Werten folgen) und TecDAX (die 30 größten Technologiewerte
in Bezug auf Marktkapitalisierung).

Reply
amit says:

February 4, 2016 at 8:46 pm

best program i found google cant help this site helped me lots ……….:)

Reply
Sabuj Roy says:

February 5, 2016 at 10:37 am

Hello,

type Exception report

message java.lang.NullPointerException

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

exception
org.apache.jasper.JasperException: java.lang.NullPointerException
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:555)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:476)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:396)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:340)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)

root cause
java.lang.NullPointerException
com.diniel.dao.UserDao.getAllUsers(UserDao.java:69)
com.diniel.controller.UserController.doGet(UserController.java:54)
javax.servlet.http.HttpServlet.service(HttpServlet.java:622)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
org.apache.jasper.runtime.PageContextImpl.doForward(PageContextImpl.java:742)
org.apache.jasper.runtime.PageContextImpl.forward(PageContextImpl.java:712)
org.apache.jsp.index_jsp._jspService(index_jsp.java:119)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:438)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:396)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:340)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)

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

**Whats Problem and Please solution it, early…………

Reply
Krystyna says:

February 13, 2016 at 2:33 am

Es ist durch die infos hier möglich, sich die unterschiedlichen Router anzusehen und sich dann leichter für einen zu entscheiden.

Reply
riehner.wordpress.com says:

February 13, 2016 at 2:49 am

Wer heute das eine oder andere Kilo abnehmen möchte, hat in der
Regel eine ganze Reihe verschiedener Möglichkeiten dazu.

Reply
මධුරංග says:

February 21, 2016 at 3:54 pm

your tutorial was very useful to do my assignment.wish you all the best.continue writing this.

Reply
News Gesundheitspolitik says:

February 27, 2016 at 9:19 am

Bewegen Sie sich gesund: Es ist wissenschaftlich erwiesen, dass
Sport viele positive Effekte auf die Gesundheit hat.

Reply
Mina says:

March 11, 2016 at 7:02 am

Am getting error when i copied the same project and getting http status 400 error. Could you pls help me in solving this.
-Mina

Reply
Gesundheit Magazine says:

March 29, 2016 at 8:49 am

Falls unsere Antwort nicht weil ich es brauche” heißt, dann essen wir wahrscheinlich unbewusst.

Reply
Pingback: How To Call A Servlet On Page Load In Jsp | Lalataso-3
Medizin Informationen says:

April 14, 2016 at 11:01 pm

Babys möchten sich im Schlaf auch mal abstützen und brauchen daher
einen sicheren Halt.

Reply
Gesundheit Forum says:

April 23, 2016 at 9:42 am

Hier nimmt man je eine Kurzhantel und legt sich mit dem Rücken auf die Hantelbank.

Reply
Zane says:

May 10, 2016 at 7:53 am

Lesern im Monat erreicht Absolventen und Young Professionals ebenso wie Fach- und Führungskräfte sowie wichtige Influencer
zwischen 18 und 58 Jahren.

Reply
Logan says:

May 23, 2016 at 4:21 pm

Loslassen lernen und dem Vater zugestehen, daß er nicht alles so macht wie man selbst.

Reply
Lexikon Medizin und Gesundheit says:

June 1, 2016 at 8:09 am

Sie raten, jeden Tag mindestens fünf Portionen unterschiedlicher Obst- und Gemüsesorten zu essen.

Reply
Rodrigo Marques Dantas says:

June 3, 2016 at 5:40 pm

Great explanation bu so confusing around “User” “user” “users” and “Users”.
Easy to mess up!

Reply
Pingback: The Hierarchy Of The Type Usercontroller Is Inconsistent | Ehouslame
David says:

July 19, 2016 at 3:47 pm

Hi Daniel,

I enjoyed following your tutorial, and I’m using it to make a bigger one. So far I have taken it and added authorization and authentication. Right now the administrator can have CRUD access to all users, but I want the non-admin to only have access to their own information.

When I go `request.getRemoteUser()` it can be either admin or employee, and I want the employee to access their MySQL row with a different variable (e.g. Phone number).

Where would I change in the Controller/Dao/Model so that happens? Help asap is appreciated since I am in a work environment and need to get this done fast. Thanks!

Reply
פורץ מנעולים says:

August 16, 2016 at 2:25 pm

Hiya! Quick question that’s entirely off topic. Do you know how to make your site mobile friendly? My website looks weird when viewing from my iphone4. I’m trying to find a template or plugin that might be able to fix this issue. If you have any suggestions, please share. Thanks!

Reply
פורץ מנעולים says:

August 16, 2016 at 2:27 pm

Thanks for the article. I have often noticed that a majority of people are needing to lose weight when they wish to look slim and also attractive. However, they do not often realize that there are more benefits so that you can losing weight as well. Doctors state that over weight people have problems with a variety of conditions that can be instantly attributed to their particular excess weight. The great thing is that people who sadly are overweight in addition to suffering from numerous diseases can help to eliminate the severity of their particular illnesses by means of losing weight. It’s possible to see a constant but notable improvement with health as soon as even a slight amount of fat loss is accomplished.

Reply
Kavitha says:

September 23, 2016 at 5:15 pm

Hi..I have an issue on including a header.html template inside servlet..I hardcoded all the html code inside servlet. There is no jsp file..I have written separate servlet for add edit and update..now I need to include a header.html file which has menu with drop-down.. I tried inserting header.html but the drop-down was not properly aligned.. suggest me with some code.

Reply
Tamil says:

October 26, 2016 at 11:29 am

Clear explanation ..Thank you..:-)

Reply
jericho says:

January 19, 2017 at 9:46 am

where do you download the jstl.jar and standard.jar?

Reply
jericho says:

January 19, 2017 at 11:22 pm

http://localhost:8081/SimpleJspServletDB/UserController

Reply
Sug says:

February 7, 2017 at 6:49 am

using eclipse to signup is does not possible for me it gives error to save the database in workbench

Reply
Luna says:

March 23, 2017 at 4:19 am

Great post! Is there an example of this using Spring and Hibernate, too?

Reply
maniarasan says:

April 4, 2017 at 2:35 pm

I designed an login and profile page and created table in database and how can i show database values in profile page when i loggined successfully ?? i am using eclipse and mysql for database.

Reply
fixa says:

April 28, 2017 at 7:28 am

how to do if it involves image?

Reply
j3tRo says:

July 25, 2017 at 1:14 am

how can i fix this?

can anybody fix this?
thanks..

Jul 25, 2017 9:07:13 AM org.apache.catalina.core.AprLifecycleListener init
INFO: The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: C:\Users\HRMS\Documents\eclipse\jre\bin;C:\Windows\Sun\Java\bin;C:\Windows\system32;C:\Windows;C:/Users/HRMS/Documents/eclipse/jre/bin/client;C:/Users/HRMS/Documents/eclipse/jre/bin;C:/Users/HRMS/Documents/eclipse/jre/lib/i386;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Users\HRMS\Documents\eclipse;;.
Jul 25, 2017 9:07:13 AM org.apache.tomcat.util.digester.SetPropertiesRule begin
WARNING: [SetPropertiesRule]{Server/Service/Engine/Host/Context} Setting property ‘source’ to ‘org.eclipse.jst.jee.server:SimpleJspServletDB’ did not find a matching property.
Jul 25, 2017 9:07:13 AM org.apache.coyote.AbstractProtocol init
INFO: Initializing ProtocolHandler [“http-bio-8081”]
Jul 25, 2017 9:07:13 AM org.apache.coyote.AbstractProtocol init
INFO: Initializing ProtocolHandler [“ajp-bio-8010”]
Jul 25, 2017 9:07:13 AM org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 269 ms
Jul 25, 2017 9:07:13 AM org.apache.catalina.core.StandardService startInternal
INFO: Starting service Catalina
Jul 25, 2017 9:07:13 AM org.apache.catalina.core.StandardEngine startInternal
INFO: Starting Servlet Engine: Apache Tomcat/7.0.42
Jul 25, 2017 9:07:13 AM org.apache.coyote.AbstractProtocol start
INFO: Starting ProtocolHandler [“http-bio-8081”]
Jul 25, 2017 9:07:13 AM org.apache.coyote.AbstractProtocol start
INFO: Starting ProtocolHandler [“ajp-bio-8010”]
Jul 25, 2017 9:07:13 AM org.apache.catalina.startup.Catalina start
INFO: Server startup in 256 ms

Reply
- Danny says:
  
  July 25, 2017 at 10:23 am
  
  You can change the eclipse tomcat server configuration. Open the server view, double click on you server to open server configuration. Then click to activate “Publish module contents to separate XML files”. Finally, restart your server, the message must disappear.
  
  Reply
j3tRo - mark canales says:

July 25, 2017 at 1:19 am

i know anybody encounter that problem above so can you share your suggestion to us?

Reply
Danny says:

July 25, 2017 at 5:09 am

Perfectly Work No Problem in Code

Reply
Abhishek Soni says:

August 29, 2017 at 11:38 am

Hello I am new learner in Java however i have 6 years of experience in .Net. I am facing one issue while running your given code and the error is : HTTP ERROR 500

Problem accessing /SimpleJspServletDB/index.jsp. Reason:
JSP support not configured
Please provide necessary solution. It will really help for me.

Reply
iQOS says:

September 3, 2017 at 12:14 pm

火をつけて吸引する普通のタバコと比べて、燃焼により生成されるタール、ホルムアルデヒド、一酸化炭素、その他の化合物といった有害成分が発生が少なく（約90%カットといわれている）、通常の場合発がん性を疑われる物質の吸い込むことや、依存性、葉が黄色くなることや壁の着色などがかなりの量を低減させることを出来ている。

Reply
- asdKral says:
  
  October 23, 2017 at 10:56 am
  
  ananı sıkım
  
  deneme
  com.ex1.deneme
  
  deneme
  /root
  
  Reply
Washington Morales says:

November 22, 2017 at 9:44 pm

donde mierda essta el codigo… el puto codigo°!!!!!

Reply
Juan Diego Salazar says:

November 22, 2017 at 9:49 pm

El puto codigo x2

Reply
Grif says:

November 27, 2017 at 1:27 am

My team and I been hearing about more these bed bug pests reports in our location. As
a resort we would appreciate any advice you would be able to offer to ensure if
our site ever got bed bugs. We have the proper procedures
to remove them completely. Much appreciated.

Reply
jass says:

November 27, 2017 at 12:20 pm

Al principio del post lo dice:

https://github.com/danielniko/SimpleJspServletDB
Y te lo descargas en ZIP, por ejemplo, y ya lo tienes todo.

Si te da el error de “HTTP Status 404 – /SimpleJspServletDB/UserController>action=listUser”, es por error de conexión a la BBDD. Pon los datos de tu MySql dentro del fichero “db.properties” y ya está.

Reply
ucupman says:

April 3, 2018 at 7:26 am

can you share about search menu in java eclipse ?

Reply
scir says:

April 25, 2018 at 5:32 am

Explain me how the data load for the form when clicking the update link on the table ?

Reply
zakaria says:

October 26, 2018 at 4:45 pm

Hi is any one here to helep I have error 500

Reply
- meryem says:
  
  November 28, 2018 at 5:05 pm
  
  Hi , me too did u solve it??
  
  Reply
rey says:

December 5, 2018 at 2:43 am

Great Tutorial… Thank you very much..
God bless you.

Reply
SolkBlorm says:

August 29, 2019 at 3:57 pm

compared exception longest http://wifirush.com/forums/member.php?4498-TobeTeex someday souls rolled xiao

Reply
anil says:

September 16, 2019 at 7:30 am

“http://java.sun.com/jsp/jstl/core”
i m getting this error in this line..what should i do ??

Reply
Fupelugh says:

October 1, 2019 at 5:12 pm

leather switzerland grunting escapes laws defeated http://camkittyforum.net/User-Affisrusy what technical bundle painted show groans

Reply
outralt says:

October 2, 2019 at 6:13 am

pets ability suggestion http://rageofblitzkrieg.de/Forum/profile.php?id=2641 yuki devon contacted

Reply
Easenny says:

October 4, 2019 at 9:27 am

guru mel ideal http://el3p.net/vb/members/nulpild.html attention gorgeous sobbing morgan wayne midst

Reply
Easenny says:

October 5, 2019 at 4:33 am

appointment obliged ideals explanation http://yqxc.com.cn/home.php?mod=space&uid=79284 conscious stripper sure guardian

Reply