2023.2.23

 @Select("select * from user where username=#{username} and  password=#{password}")
    User Login(@Param("username") String username, @Param("password") String password);

    @Insert("insert into user value (#{id},#{username},#{password},null,'0','0','0')")
    boolean addUser(User user);



 public User Login(String username, String password) {
        SqlSession sqlSession = factory.openSession();
        UserMapper mapper = sqlSession.getMapper(UserMapper.class);
        User user = mapper.Login(username, password);
        sqlSession.close();
        return user;
    }



public boolean addUser(User user) {
        SqlSession sqlSession = factory.openSession();
        UserMapper mapper = sqlSession.getMapper(UserMapper.class);
        User u = mapper.selectUsernameUser(user.getUsername());
        if(u == null)
        {
            mapper.addUser(user);
            sqlSession.commit();
        }
        sqlSession.close();
        return u == null;

    }

学习到了登陆注册所用的sql语句