SpringBoot:SpringBoot结合Jsp和Mybatis实现一个简单的登录

一、准备工作

  1. 先导入一些css和js文件
    在这里插入图片描述
  2. 新建三个页面,登录页,失败页,成功页
    login.jsp
<html>
<head>
    <title>login</title>
    <link rel="stylesheet" type="text/css" href="/css/bootstrap.css" />
    <script src="/js/jquery-3.3.1.min.js"></script>
    <script src="/js/bootstrap.js"></script>
</head>
<body>
    <div class="container col-xs-2 col-xs-push-4">
        <h1>Login</h1>
        <form action="/login">
            <div class="form-group">
                <label for="username">Username</label>
                <input type="text" class="form-control" id="username" name="username" placeholder="Username">
            </div>
            <div class="form-group">
                <label for="password">Password</label>
                <input type="password" class="form-control" id="password" name="password" placeholder="Password">
            </div>
            <button type="submit" class="btn btn-default">Submit</button>
        </form>
    </div>
</body>
</html>

success.jsp

<html>
<head>
    <title>success</title>
</head>
<body>
    <h1>success</h1>
</body>
</html>

fail.jsp

<html>
<head>
    <title>fail</title>
</head>
<body>
    <h1>fail</h1>
</body>
</html>

二、开始写后台代码了

  1. User实体类
public class User {
    private Integer id;
    private String username;
    private String password;

    public Integer getId(){
        return id;
    }

    public void SetId(Integer 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;
    }
}
  1. UserMapper接口
@Mapper
public interface UserMapper {
    //根据username查找用户
    User findUser(String username);
}
  1. UserMapper.xml
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://www.mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.example.demo.mapper.UserMapper">
    <select id="findUser" resultType="com.example.demo.domain.User">
        select * from tb_user where username = #{0}
    </select>
</mapper>
  1. UserService接口
public interface UserService {
    //根据用户名查找用户
    User getUserByName(String username);
}
  1. UserService实现类
@Service
public class UserServiceImpl implements UserService {
    @Autowired
    private UserMapper userMapper;

    @Override
    public User getUserByName(String username) {
        return userMapper.findUser(username);
    }
}
  1. UserController
@Controller
public class LoginController {
    @Autowired
    private UserService userService;

    @RequestMapping("/loginPage")
    public String loginPage(){
        return "login";
    }

    @RequestMapping("/login")
    public String login(String username, String password){
        User user = userService.getUserByName(username);
        if (user == null)
            return "fail";
        if(user.getPassword().equals(password))
            return "success";
        else
            return "fail";
    }
}

三、访问流程

用户提交表单后根据action找到对应RequestMapping中的路径,根据input标签中的name传递参数到Controller。
Controller通过Service传递username参数找到user对象。
Service通过Mapper找到对应的Mapper,Mapper通过映射找到xml执行Sql查出数据。

  • 1
    点赞
  • 6
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
好的,下面是简单的步骤: 1. 创建一个Spring Boot项目 2. 添加依赖:spring-boot-starter-web、spring-boot-starter-jdbc、mybatis-spring-boot-starter、mysql-connector-java 3. 在application.properties文件中配置数据源和MyBatis配置 4. 创建一个User实体类,用于存储用户信息 5. 创建一个UserMapper接口和一个UserMapper.xml文件,用于定义对User实体类的CRUD操作 6. 创建一个UserService类,实现注册和登录功能,通过UserMapper来操作数据库 7. 创建一个UserController类,处理用户请求,返回JSP页面 8. 创建login.jsp和register.jsp页面,用于用户登录和注册 具体实现细节可以参考以下代码: User.java ```java public class User { private Integer id; private String username; private String password; // getter and setter } ``` UserMapper.java ```java @Mapper public interface UserMapper { @Insert("INSERT INTO user(username, password) VALUES(#{username}, #{password})") int insert(User user); @Select("SELECT * FROM user WHERE username = #{username}") User findByUsername(String username); } ``` application.properties ```properties spring.datasource.url=jdbc:mysql://localhost:3306/test?useSSL=false&serverTimezone=UTC spring.datasource.username=root spring.datasource.password=root spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver mybatis.mapper-locations=classpath:mapper/*.xml mybatis.type-aliases-package=com.example.demo.model ``` UserService.java ```java @Service public class UserService { @Autowired private UserMapper userMapper; public boolean register(User user) { User existUser = userMapper.findByUsername(user.getUsername()); if (existUser != null) { return false; } userMapper.insert(user); return true; } public boolean login(User user) { User existUser = userMapper.findByUsername(user.getUsername()); if (existUser == null || !existUser.getPassword().equals(user.getPassword())) { return false; } return true; } } ``` UserController.java ```java @Controller public class UserController { @Autowired private UserService userService; @RequestMapping("/login") public String login() { return "login"; } @RequestMapping("/register") public String register() { return "register"; } @RequestMapping("/doLogin") public String doLogin(User user, Model model) { boolean result = userService.login(user); if (result) { return "success"; } else { model.addAttribute("error", "用户名或密码错误"); return "login"; } } @RequestMapping("/doRegister") public String doRegister(User user, Model model) { boolean result = userService.register(user); if (result) { return "success"; } else { model.addAttribute("error", "用户名已存在"); return "register"; } } } ``` login.jsp ```html <%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <!DOCTYPE html> <html> <head> <meta charset="UTF-8"> <title>登录</title> </head> <body> <h1>登录</h1> <form action="doLogin" method="post"> <label>用户名:</label> <input type="text" name="username"><br> <label>密码:</label> <input type="password" name="password"><br> <input type="submit" value="登录"> </form> <p>${error}</p> </body> </html> ``` register.jsp ```html <%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <!DOCTYPE html> <html> <head> <meta charset="UTF-8"> <title>注册</title> </head> <body> <h1>注册</h1> <form action="doRegister" method="post"> <label>用户名:</label> <input type="text" name="username"><br> <label>密码:</label> <input type="password" name="password"><br> <input type="submit" value="注册"> </form> <p>${error}</p> </body> </html> ``` 注意:以上代码仅为示例,仅供参考,需要根据具体需求进行调整。

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值