SpringBoot（一）基本使用

最新推荐文章于 2023-07-31 14:37:49 发布

哦吼~

最新推荐文章于 2023-07-31 14:37:49 发布

阅读量132

点赞数 1

分类专栏： SpringBoot

本文链接：https://blog.csdn.net/qq_42727102/article/details/103868704

版权

SpringBoot 专栏收录该内容

5 篇文章 0 订阅

订阅专栏

1.User.java


public class User implements Serializable {
    private Integer userId;
    private String userName;
    private String userPwd;

    public User() {
    }


    @Override
    public String toString() {
        return "User{" +
                "userId=" + userId +
                ", userName='" + userName + '\'' +
                ", userPwd='" + userPwd + '\'' +
                '}';
    }

    public void setUserId(Integer userId) {
        this.userId = userId;
    }

    public void setUserName(String userName) {
        this.userName = userName;
    }

    public void setUserPwd(String userPwd) {
        this.userPwd = userPwd;
    }

    public Integer getUserId() {
        return userId;
    }

    public String getUserName() {
        return userName;
    }

    public String getUserPwd() {
        return userPwd;
    }
}

2.UserMapper.java

@Mapper
public interface UserMapper {
   User loadByUser(User user);
   int addUser(User user);
   int updateUser(User user);
   int deleteUser(int userId);
   List<User> findAllUser();
}

3.UserService.java

public interface UserService {
    boolean loadByUser(User user);
    boolean addUser(User user);
    boolean updateUser(User user);
    boolean deleteUser(int userId);
    List<User> findAllUser();
}

4.UserServiceImpl.java


@Service
public class UserServiceImpl implements UserService {
    @Resource
    private UserMapper um;

    @Override
    public boolean loadByUser(User user) {
        return um.loadByUser(user)!=null?true:false;
    }

    @Override
    public List<User> findAllUser() {
        return um.findAllUser();
    }

    @Override
    public boolean addUser(User user) {
        int count=um.addUser(user);
        return count>0?true:false;
    }

    @Override
    public boolean updateUser(User user) {
        int count=um.updateUser(user);
        return count>0?true:false;
    }

    @Override
    public boolean deleteUser(int userId) {
        int count=um.deleteUser(userId);
        return count>0?true:false;
    }
}

5.UserController.java

@RestController //相当于Controller+ResponseBody
public class UserController {
    @Autowired
    private UserService us;

    @GetMapping(value = {"/loaduser"}) //查询GetMapping
    public boolean loadUser(User user){
        boolean bool = us.loadByUser(user);
        return bool;
    }

    //带占位符的参数传递 更加安全
    @PostMapping(value = {"/adduser/{userName}/{userPwd}"}) //增加PostMapping
    public boolean addUser(User user){
        return us.addUser(user);
    }

    @PutMapping(value = {"/updateuser/{userId}/{userName}/{userPwd}"})//修改PutMapping
    public boolean updateUser(User user){
        System.out.println(user);
        return us.updateUser(user);
    }

    @DeleteMapping(value = {"/deleteuser/{id}"})//删除DeleteMapping
    public boolean deleteUser(@PathVariable("id")int id){
        return us.deleteUser(id);
    }

    @GetMapping(value = {"/findalluser"})
    public List<User> findAllUser(){
        return us.findAllUser();
    }
}

6.UserMapper.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.xzy.xiangmu.dao.UserMapper">
    <select id="loadByUser" parameterType="user" resultType="user">
      SELECT * FROM userInfo WHERE userName=#{userName} AND userPwd=MD5(#{userPwd})
    </select>

    <insert id="addUser" parameterType="user">
        insert into userinfo values(default,#{userName},md5(#{userPwd}))
    </insert>

    <update id="updateUser" parameterType="user">
        update userinfo set userName = #{userName},userPwd = md5(#{userPwd}) where userId = #{userId}
    </update>

    <delete id="deleteUser" parameterType="int">
        delete from userinfo where userId = #{userId}
    </delete>

    <select id="findAllUser" resultType="user">
        select * from userInfo
    </select>
</mapper>

7.login.html

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>登录</title>
    <script src="js/jquery-3.4.1.min.js" type="text/javascript"></script>
    <script type="text/javascript">
        $(function () {
            $("#but").click(function () {
                var uname = $("#userName").val();
                var upwd = $("#userPwd").val();
                $.get("loaduser",{"userName":uname,"userPwd":upwd},function (data){
                    if (data==true){
                        location.href = "http://www.baidu.com";
                    }else{
                        alert("错误！！！");
                    }
                });
            });
        });
    </script>
</head>
<body>
    <form action="/loaduser" method="get">
        <input type="text" name="userName" id="userName"/>
        <input type="password" name="userPwd" id="userPwd"/>
        <input type="button" value="提交" id="but"/>
    </form>
</body>
</html>

8.update.html

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>修改</title>
    <script type="text/javascript" src="js/jquery-3.4.1.min.js"></script>
    <script type="text/javascript">
        $(function () {
            $("#but").click(function () {
                var uid = $("#userId").val();
                var uname = $("#userName").val();
                var upwd = $("#userPwd").val();

                $.post("updateuser",{"_method":"put","userId":uid,"userName":uname,"userPwd":upwd},function (data) {
                    alert(data);
                });
            });
        });
    </script>
</head>
<body>
<form action="/updateuser" method="post">
    <!--name是固定的-->
    <input type="hidden" name="_method" value="PUT"/>
    <input type="text" name="userId" value="5" id="userId"/><br/>
    <input type="text" name="userName" value="" id="userName"/><br/>
    <input type="password" name="userPwd" value="" id="userPwd"><br/>
    <!--submit会跳转页面
    input的type属性还可以是button，这时它只是一个按钮，不会引发表单提交。-->
    <input type="button" value="确定" id="but"/>
</form>
</body>
</html>

哦吼~

关注

1
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
SpringBoot（一）基本使用

1.User.javapublic class User implements Serializable { private Integer userId; private String userName; private String userPwd; public User() { } @Override public Stri...
复制链接

扫一扫