ResultSet result = statement.executeQuery() PreparedStatement statement = connection.prepareStatement(sql) String sql = 'SELECT * FROM users WHERE email = ? and password = ?' String jdbcURL = 'jdbc:mysql://localhost:3306/bookshop' Ĭonnection connection = DriverManager.getConnection(jdbcURL, dbUser, dbPassword) Public User checkLogin(String email, String password) throws SQLException, So create UserDAO class with the following code: package net.codejava Code Check Login methodNext, we need to implement a method that checks the login information entered by the user against the data in the database. They are not shown in the above code or brevity.ģ. }You should generate getter and setter methods for all fields of this class. getters and setters are not shown for brevity The User model classNext, create a plain old Java object (POJO) class that represents a user: package net.codejava Of course you can add additional fields to this table if you want.Ģ. Create database table used for authenticationIn the login page, the user enters email and password – so we need to verify that login information against data in a database table, typically the users table.Make sure that the table you use for authentication has at least 3 fields: fullname, email and password.Here’s the structure of the table users I use for this tutorial: If you haven’t created any table for authentication, execute the following MySQL script to create one: CREATE TABLE `users` ( Create database table used for authenticationħ. No frameworks are used.Suppose that you have an existing Java web project and now you wish to add the login and logout features for your website.Table of content:ġ. Just plain old, core Java EE technologies. In this tutorial, I will guide you how to implement login and logout functions for a small Java web application using Servlet, JSP, JDBC and MySQL.

How to implement remember password feature.

How to implement forgot password feature.

How to read password-protected Excel file in Java.

Java File Encryption and Decryption Example.Compile and run a Java program with Sublime Text.Compile and Run a Java Program with TextPad.File Upload to Database with Spring and Hibernate.File Upload to Database with Servlet, JSP, MySQL.Java Servlet and JSP Hello World Tutorial.

Servlet program for a login page