Spring Boot Login and Logout with MySQL Database

Posted on June 7, 2021

10 min read

12,138

This Tutorial will teach you how to make the Spring Boot Login and Logout with MySQL Database.

Domain

First you must Create the package com.example.LindaSchool.Logindomain. inside the package you have to create the class.

i have created the table name which is records in the database. this annotation @Table(name=”login”) indicate the table name of the database.

Entity annotation @Entity indicate as Entity of class.
Column annotation @Column indicate each column of the table.

Login.java

package com.example.LindaSchool.Logindomain;

import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;

@Entity
@Table(name="login")
public class Login {
	
	@Id
    @GeneratedValue(strategy= GenerationType.IDENTITY)
    private Long id;
    private String username;
    private String password;

    
public Login()
 {
		
}

public Login(Long id, String username, String password) {
		
		this.id = id;
		this.username = username;
		this.password = password;
	}
	
	public Long getId() {
		return id;
	}
	public void setId(Long id) {
		this.id = id;
	}
	public String getUsername() {
		return username;
	}
	public void setUsername(String username) {
		this.username = username;
	}
	public String getPassword() {
		return password;
	}
	public void setPassword(String password) {
		this.password = password;
	}
}

package com.example.LindaSchool.Logindomain;

import javax.persistence.Entity;

import javax.persistence.GeneratedValue;

import javax.persistence.GenerationType;

import javax.persistence.Id;

import javax.persistence.Table;

@Entity

@Table(name="login")

public class Login {

@Id

@GeneratedValue(strategy= GenerationType.IDENTITY)

private Long id;

private String username;

private String password;

public Login()

{

}

public Login(Long id, String username, String password) {

this.id = id;

this.username = username;

this.password = password;

}

public Long getId() {

return id;

}

public void setId(Long id) {

this.id = id;

}

public String getUsername() {

return username;

}

public void setUsername(String username) {

this.username = username;

}

public String getPassword() {

return password;

}

public void setPassword(String password) {

this.password = password;

}

after that you have to Create the package com.example.LindaSchool.Logincontroller . inside the package you have to create the class

Logincontroller .java

package com.example.LindaSchool.LoginController;

import java.util.Objects;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.ModelAttribute;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.servlet.ModelAndView;

import com.example.LindaSchool.Logindomain.Login;
import com.example.LindaSchool.Loginservice.LoginService;



@Controller
public class LoginController {
	
	@Autowired
    private LoginService userService;

                                   
    @GetMapping("/login")
           
    public ModelAndView login() {
    	ModelAndView mav = new ModelAndView("login");
        mav.addObject("user", new Login());
        return mav;
    }

    @PostMapping("/login")
    public String login(@ModelAttribute("user") Login user ) {
    	
    	Login oauthUser = userService.login(user.getUsername(), user.getPassword());
    	

    	System.out.print(oauthUser);
    	if(Objects.nonNull(oauthUser)) 
    	{	
  
    		return "redirect:/";
    	
    		
    	} else {
    		return "redirect:/login";
    		
    	
    	}

}
    
    @RequestMapping(value = {"/logout"}, method = RequestMethod.POST)
    public String logoutDo(HttpServletRequest request,HttpServletResponse response)
    {
    	
	  
        return "redirect:/login";
    }

}

package com.example.LindaSchool.LoginController;

import java.util.Objects;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

import org.springframework.beans.factory.annotation.Autowired;

import org.springframework.stereotype.Controller;

import org.springframework.web.bind.annotation.GetMapping;

import org.springframework.web.bind.annotation.ModelAttribute;

import org.springframework.web.bind.annotation.PostMapping;

import org.springframework.web.bind.annotation.RequestMapping;

import org.springframework.web.bind.annotation.RequestMethod;

import org.springframework.web.servlet.ModelAndView;

import com.example.LindaSchool.Logindomain.Login;

import com.example.LindaSchool.Loginservice.LoginService;

@Controller

public class LoginController {

@Autowired

private LoginService userService;

@GetMapping("/login")

public ModelAndView login() {

ModelAndView mav = new ModelAndView("login");

mav.addObject("user", new Login());

return mav;

}

@PostMapping("/login")

public String login(@ModelAttribute("user") Login user ) {

System.out.print(oauthUser);

if(Objects.nonNull(oauthUser))

{

return "redirect:/";

} else {

return "redirect:/login";

}

@RequestMapping(value = {"/logout"}, method = RequestMethod.POST)

public String logoutDo(HttpServletRequest request,HttpServletResponse response)

{

return "redirect:/login";

}

First you must Create the package com.example.LindaSchool.Loginservice . inside the package you have to create the class

Loginservice.java

package com.example.LindaSchool.Loginservice;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import com.example.LindaSchool.Logindomain.Login;
import com.example.LindaSchool.Loginreposotory.LoginRepository;



@Service
public class LoginService {
	
	@Autowired
	private LoginRepository repo;
  
  public Login login(String username, String password) {
	  Login user = repo.findByUsernameAndPassword(username, password);
  	return user;
  }
	

}

package com.example.LindaSchool.Loginservice;

import org.springframework.beans.factory.annotation.Autowired;

import org.springframework.stereotype.Service;

import com.example.LindaSchool.Logindomain.Login;

import com.example.LindaSchool.Loginreposotory.LoginRepository;

@Service

public class LoginService {

@Autowired

private LoginRepository repo;

public Login login(String username, String password) {

return user;

}

LoginRepository.java

First you must Create the package com.example.LindaSchool.Loginreposotory inside the package you have to create the Interface here.

LoginRepository.java

@Repository
public interface LoginRepository extends JpaRepository<Login, Long>{
	Login findByUsernameAndPassword(String username, String password);

}

@Repository

public interface LoginRepository extends JpaRepository<Login, Long>{

}

After that you must set database path and project configuration in application.properties file.

spring.datasource.url=jdbc:mysql://localhost:3306/lindaschool?useUnicode=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC
server.error.whitelabel.enabled=false
server.port=9040
spring.datasource.username=root
spring.datasource.password=
#logging.level.root=WARN
spring.jpa.open-in-view=false
spring.thymeleaf.cache=false

spring.jpa.show-sql=true
api.base.path = http://localhost:9080/login

spring.datasource.url=jdbc:mysql://localhost:3306/lindaschool?useUnicode=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC

server.error.whitelabel.enabled=false

server.port=9040

spring.datasource.username=root

spring.datasource.password=

#logging.level.root=WARN

spring.jpa.open-in-view=false

spring.thymeleaf.cache=false

spring.jpa.show-sql=true

api.base.path = http://localhost:9080/login

Inside the Templete Folder Create two pages login and index.

Login.html

<!DOCTYPE html>
<html>
<head>
<meta charset="ISO-8859-1">
<title>Insert title here</title>
	<link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootswatch/4.5.2/cosmo/bootstrap.min.css" />
</head>
<body>
 
    
    
    <style type="text/css">
    body,td,th{
        color: #000000;
    }
    
    body{
        background-color: #F0F0F0;
    }
    
    .style1
    {
        font-family: arial;
        font-size: 14px;
        padding: 12px;
        line-height: 25px;
        border-radius: 4px;
        text-decoration: none;
        
    }
    
    .style2
    {
        font-family: arial;
        font-size: 17px;
        padding: 12px;
        line-height: 25px;
        border-radius: 4px;
        text-decoration: none;
        
    }
    
    
</style>

    </head>
    <body>
        <div class="container">
            <table width="100%" height="100%" border="0" cellpadding="0" align="center">
            <tr>
                <td align="center" valign="middle">
                <table class="table-bordered" width="350" border="0" cellpadding="3"cellspacing="3" bgcolor="#ffffff">
        
			        <form action="#" th:action="@{/login}" th:object="${user}" method="post">
			  
			           
			                  <tr>
                                    <td height="25" colspan="2" align="left" valign="middle" bgcolor="#ffffff" class="style2">
                                        <div align="center">
                                            <strong>User Login</strong>
                                        </div>
                                        
                                    </td>
                                </tr>

			            <tr>
			                <td>Username</td>
			                <td>
				             
				                <input type="text" th:field="*{username}" class="form-control" />
			                </td>
			            </tr>
			            <tr>
			                <td>Password</td>
			                <td><input type="password" th:field="*{password}" class="form-control" /></td>
			            </tr>
			            <tr>
			            <td colspan="2"><button type="submit" class="btn btn-info" align="right">Login</button> </td>
			            </tr>
			        
			    </form>
       </table>  
         </td>   
         </tr>  
      </table> 
     </div>  

</body>
</html>

<!DOCTYPE html>

<html>

<head>

<title>Insert title here</title>

</head>

<body>

body,td,th{

color: #000000;

}

body{

background-color: #F0F0F0;

}

.style1

{

font-family: arial;

font-size: 14px;

padding: 12px;

line-height: 25px;

border-radius: 4px;

text-decoration: none;

}

.style2

{

font-family: arial;

font-size: 17px;

padding: 12px;

line-height: 25px;

border-radius: 4px;

text-decoration: none;

}

</style>

</head>

<body>

<tr>

<tr>

<strong>User Login</strong>

</div>

</td>

</tr>

<tr>

<td>Username</td>

<td>

</td>

</tr>

<tr>

<td>Password</td>

</tr>

<tr>

<td colspan="2"><button type="submit" class="btn btn-info" align="right">Login</button> </td>

</tr>

</form>

</table>

</td>

</tr>

</table>

</div>

</body>

</html>

Index.html

<!DOCTYPE html>
<html>
<head>
<meta charset="ISO-8859-1">
<title>Insert title here</title>
</head>
<body>
	<link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootswatch/4.5.2/cosmo/bootstrap.min.css" />

   <h1>Welcome to Home Page</h1>
   <form th:action="@{/logout}" method="post">
        <input type="submit" class="btn btn-info" value="Logout" />
    </form>
</body>
</html>

<!DOCTYPE html>

<html>

<head>

<title>Insert title here</title>

</head>

<body>

<h1>Welcome to Home Page</h1>

</form>

</body>

</html>

Create Maven project in Intellij

Django Vue.js Full Stack App

Django React Full Stack Project

Create Maven project in Intellij

Hibernate crud tutorial create delete update search

Hibernate Tutorial Introduction IntelliJ IDEA

Leave a Reply Cancel reply

Check Also

Create Maven project in Intellij

Recent Posts

Domain

i have attached the video link below. which will do this tutorials step by step.

Leave a Reply Cancel reply

Check Also

Recent Posts