1用户添加

最新推荐文章于 2021-03-31 17:37:18 发布

潜龙勿用丶

最新推荐文章于 2021-03-31 17:37:18 发布

阅读量224

点赞数

分类专栏： springboot 文章标签： java Spring boot jdbc

本文链接：https://blog.csdn.net/weixin_43425449/article/details/107211363

版权

springboot 专栏收录该内容

15 篇文章 0 订阅

订阅专栏

springboot整合jdbc-实现添加用户

创建实体类(pojo/Users)

public class Users {
    private Integer id;
    private String username;
    private String usersex;

    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 getUsersex() {
        return usersex;
    }

    public void setUsersex(String usersex) {
        this.usersex = usersex;
    }
}

编写页面(resources/templates/addUser.html)

<!DOCTYPE html>
<html lang="en" xmlns:th="http://www.thymeleaf.org">
<head>
    <meta charset="UTF-8">
    <title>Title</title>
</head>
<body>
    <form th:action="@{/user/addUser}" method="post">
        <input type="text" name="username"><br>
        <input type="text" name="usersex"><br>
        <input type="submit" value="ok">
    </form>
</body>
</html>

创建PageController(controller/PageController)

//页面跳转controller
@Controller
public class PageController {
    //页面跳转方法
    @RequestMapping("/{page}")
    public String showPage(@PathVariable String page){
        return page;
    }
}

创建UsersController(controller/UsersController)

@Controller
@RequestMapping("/user")
public class UsersController {
    @Autowired
    private UsersService usersService;
    @PostMapping("/addUser")
    public String showInfo(Users users){
        try{
            this.usersService.addUser(users);
        }catch (Exception e){
            e.printStackTrace();
            return "error";
        }
        return "redirect:/ok";
    }
}

编写service接口和实现类

(service/UsersService)

public interface UsersService {
    void addUser(Users users);
}

(service/impl/UsersServiceImpl)

//用户管理业务层
@Service
public class UsersServiceImpl implements UsersService {
    @Autowired
    private UsersDao usersDao;
    //添加用户
    @Override
    @Transactional
    public void addUser(Users users) {
        this.usersDao.insertUsers(users);
    }
}

编写dao接口和实现类

(dao/UsersDao)

public interface UsersDao {
    void insertUsers(Users users);
}

(dao/impl/UsersDaoImpl)

//持久层
@Repository
public class UsersDaoImpl implements UsersDao {
    @Autowired
    private JdbcTemplate jdbcTemplate;
    //添加用户
    @Override
    public void insertUsers(Users users) {
        String sql = "insert into users(username,usersex) value(?,?)";
        this.jdbcTemplate.update(sql,users.getUsername(),users.getUsersex());
    }
}

潜龙勿用丶

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
1用户添加

springboot整合jdbc-实现添加用户创建实体类(pojo/Users)public class Users { private Integer id; private String username; private String usersex; public Integer getId() { return id; } public void setId(Integer id) { this.id =
复制链接

扫一扫