- 首先先新建一个SpringBoot工程,设置好项目名,选择对应的JDK以及打包方式。点击下一步
- 选择对应的依赖项,暂时选了三个,后面增加功能可以在pom文件添加。点击创建。完成后的目录结构
- 修改配置文件以及创建三层架构目录。
- 接下来完成代码编写。首先登录页面
<!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <title>Title</title> </head> <body> <div style="text-align: center"> <h1>登录</h1> <form action="/login" method="post"> <div style="padding: 10px"> <label for="username">用户名:</label><input id="username" name="username" type="text"><br/> </div> <div style="padding: 10px;margin-left: 12px"> <label for="password">密码: </label><input id="password" name="password" type="password"><br/> </div> <input type="submit" value="登录"> </form> </div> </body> </html>
Controller层
@Controller public class UserController { @Autowired private UserMapper userMap; @RequestMapping(value = "/login",method = RequestMethod.POST) public String Login(String username, String password){ if (userMap.loginUser(username, password)!=null){ return "login"; } else { return "index"; } } }
entity层
@Data public class User { private Integer id; private String username; private String password; }
mapper层
@Mapper public interface UserMapper { User loginUser(String username , String password); }
以及
<?xml version="1.0" encoding="UTF-8" ?> <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> <mapper namespace="com.cc.demo2.mappers.UserMapper"> <select id="loginUser" parameterType="User" resultType="User"> select * from user where username = #{param1} and password = #{param2}; </select> </mapper>
SQL
SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for user -- ---------------------------- DROP TABLE IF EXISTS `user`; CREATE TABLE `user` ( `id` int NOT NULL, `username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of user -- ---------------------------- INSERT INTO `user` VALUES (1, 'admin', '123456'); SET FOREIGN_KEY_CHECKS = 1;
5.大功告成,运行一下,浏览器输入localhost:8080,输入对应admin,123456可登录
如下
至此完成简单的登录功能