sql語句
CREATE TABLE people
(
id INT AUTO_INCREMENT
PRIMARY KEY,
user_name VARCHAR(255) NULL,
age INT NULL,
password VARCHAR(255) NULL
)
ENGINE = InnoDB;
使用mybatis插件自動生成代碼
dao層·
@Component
public interface PeopleMapper {
//用戶登錄
People userlogin(@Param("user_name") String username,@Param("password") String password);
//注冊新用戶(方式1)
int adduser(@Param("user_name") String username, @Param("password") String password, @Param("age") int age);
}
peopleMapper.xml
<?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.demo.dao.PeopleMapper">
<select id="userlogin" resultType="com.demo.enity.People">
SELECT id,user_name,password,age FROM people WHERE user_name = #{user_name} AND password = #{password}
</select>
<insert id="adduser">
INSERT INTO people (user_name,password,age) VALUES (#{user_name},#{password},#{age})
</insert>
</mapper>
service層
public interface UserLoginService {
public People userLogin(String username, String password);
public int adduser(String username,String password,int age);
}
public class UserLoginServiceImpl implements UserLoginService {
@Qualifier("peopleMapper")
@Autowired
PeopleMapper mapper;
public People userLogin(String username, String password) {
People people =mapper.userlogin(username,password);
return people;
}
public int adduser(String username, String password, int age) {
return mapper.adduser(username,password,age);
}
}
controller層
@Controller
@RequestMapping(value = {"/user"})
public class UserLoginController {
@Autowired
private UserLoginService userLoginService;
@RequestMapping(value = {"/loginHtml"})
public String loginHtml() {
return "userLogin";
}
@RequestMapping(value = {"/userLogin"})
public ModelAndView userLogin(@RequestParam("username") String username,
@RequestParam("password") String password,
HttpServletRequest request, Model model) {
ModelAndView mv = new ModelAndView("index2");
ModelAndView mv2 = new ModelAndView("loginError");
People people = userLoginService.userLogin(username, password);
String name = people.getUserName();
mv.addObject("people", name);
if (people!=null)
return mv;
return mv2;
}
@RequestMapping(value = {"/registerpage"})
public String registerpage() {
return "register";
}
@ResponseBody
@RequestMapping(value = {"/uregister"})
public String addUser(@RequestParam("username") String username,
@RequestParam("password") String password,
@RequestParam("password2") String password2,
@RequestParam("age") int age) {
if (!password.equals(password2)) {
return "兩次密碼不相同，注冊失?。?！";
} else {
int res = userLoginService.adduser(username, password, age);
if (res == 0) {
return "注冊失?。?;
} else {
return "注冊成功！";
}
}
}
userLoging.html
<html xmlns:th="http://www.thymeleaf.org">
<head>
<meta charset="UTF-8">
<title>Title</title>
</head>
<body>
請輸入用戶名與密碼登錄
<form action="/user/userLogin" method="post">
用戶名：<input type="text" name="username" /><br>
密 碼：<input type="password" name="password" /><br>
<input type="submit" value="登錄" />
<a href="/user/registerpage" target="_blank">注冊</a>
</form>
</body>
</html>
register.html
<html lang="en">
<head>
<meta charset="UTF-8">
<title>注冊</title>
</head>
<body>
<form action="/user/uregister" method="post">
用戶名:<input type="text" name="username" /></br>
密碼:<input type="password" name="password" /></br>
確認(rèn)密碼:<input type="password" name="password2" /></br>
年齡:<input type="text" name="age" /></br>
<input type="submit" value="注冊">
</form>
</body>
</html>
對于寫代碼的順序，我是從xml（sql語句）開始寫，然后Dao，Service，最后寫Controller。下面為我的部分代碼。（開始生成的代碼沒有用到的部分被我刪除掉了）
圖片.png
圖片.png
圖片.png
https://blog.csdn.net/m15801049086/article/details/78521275
https://blog.csdn.net/weixin_42685022/article/details/82215893#commentBox
