Skip to content
The Chat Archive
gpt-3.5-turbo-0301· OpenAI WildChat-4.8M (AI2)

使用Java的springboot实现用户之间关注和查看粉丝的功能

  1. User

    使用Java的springboot实现用户之间关注和查看粉丝的功能

  2. Assistant
    1. 数据库设计

    首先,在数据库中设计出用户表user和关注表follow。用户表用来存储用户的基本信息,如用户名、密码、邮箱等。关注表用来记录用户之间的关注关系,包括被关注人id和关注人id。

    用户表设计如下:

    CREATE TABLE user ( user_id int(11) NOT NULL AUTO_INCREMENT, username varchar(50) NOT NULL, password varchar(50) NOT NULL, email varchar(50) NOT NULL, PRIMARY KEY (user_id) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

    关注表设计如下:

    CREATE TABLE follow ( id int(11) NOT NULL AUTO_INCREMENT, user_id int(11) NOT NULL, follow_id int(11) NOT NULL, PRIMARY KEY (id) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

    1. 创建实体类

    根据上述数据库表结构,创建实体类如下:

    User.java

    public class User { private Integer userId; private String username; private String password; private String email;

    // getters and setters
    

    }

    Follow.java

    public class Follow { private Integer id; private Integer userId; private Integer followId;

    // getters and setters
    

    }

    1. DAO层实现

    创建UserDao和FollowDao接口及其实现类UserDaoImpl和FollowDaoImpl,分别对应连接数据库的用户和关注表。

    UserDao.java

    public interface UserDao { User getUserById(Integer userId); User getUserByUsername(String username); void addUser(User user); void deleteUserById(Integer userId); }

    FollowDao.java

    public interface FollowDao { List getFollowByUserId(Integer userId); List getFansByUserId(Integer userId); void addFollow(Follow follow); void deleteFollow(Follow follow); }

    UserDaoImpl.java

    @Repository public class UserDaoImpl implements UserDao { @Autowired private JdbcTemplate jdbcTemplate;

    @Override
    public User getUserById(Integer userId) {
        String sql = "SELECT * FROM user WHERE user_id = ?";
        return jdbcTemplate.queryForObject(sql, new BeanPropertyRowMapper<>(User.class), userId);
    }
    
    @Override
    public User getUserByUsername(String username) {
        String sql = "SELECT * FROM user WHERE username = ?";
        return jdbcTemplate.queryForObject(sql, new BeanPropertyRowMapper<>(User.class), username);
    }
    
    @Override
    public void addUser(User user) {
        String sql = "INSERT INTO user(username, password, email) VALUES (?, ?, ?)";
        jdbcTemplate.update(sql, user.getUsername(), user.getPassword(), user.getEmail());
    }
    
    @Override
    public void deleteUserById(Integer userId) {
        String sql = "DELETE FROM user WHERE user_id = ?";
        jdbcTemplate.update(sql, userId);
    }
    

    }

    FollowDaoImpl.java

    @Repository public class FollowDaoImpl implements FollowDao { @Autowired private JdbcTemplate jdbcTemplate;

    @Override
    public List<Follow> getFollowByUserId(Integer userId) {
        String sql = "SELECT * FROM follow WHERE user_id = ?";
        return jdbcTemplate.query(sql, new BeanPropertyRowMapper<>(Follow.class), userId);
    }
    
    @Override
    public List<Follow> getFansByUserId(Integer userId) {
        String sql = "SELECT * FROM follow WHERE follow_id = ?";
        return jdbcTemplate.query(sql, new BeanPropertyRowMapper<>(Follow.class), userId);
    }
    
    @Override
    public void addFollow(Follow follow) {
        String sql = "INSERT INTO follow(user_id, follow_id) VALUES (?, ?)";
        jdbcTemplate.update(sql, follow.getUserId(), follow.getFollowId());
    }
    
    @Override
    public void deleteFollow(Follow follow) {
        String sql = "DELETE FROM follow WHERE user_id = ? AND follow_id = ?";
        jdbcTemplate.update(sql, follow.getUserId(), follow.getFollowId());
    }
    

    }

    1. Service层实现

    创建UserService和FollowService接口及其实现类UserServiceImpl和FollowServiceImpl。

    UserService.java

    public interface UserService { User getUserById(Integer userId); User getUserByUsername(String username); void addUser(User user); void deleteUserById(Integer userId); }

    FollowService.java

    public interface FollowService { List getFollowByUserId(Integer userId); List getFansByUserId(Integer userId); void addFollow(Integer userId, Integer followId); void deleteFollow(Integer userId, Integer followId); }

    UserServiceImpl.java

    @Service public class UserServiceImpl implements UserService { @Autowired private UserDao userDao;

    @Override
    public User getUserById(Integer userId) {
        return userDao.getUserById(userId);
    }
    
    @Override
    public User getUserByUsername(String username) {
        return userDao.getUserByUsername(username);
    }
    
    @Override
    public void addUser(User user) {
        userDao.addUser(user);
    }
    
    @Override
    public void deleteUserById(Integer userId) {
        userDao.deleteUserById(userId);
    }
    

    }

    FollowServiceImpl.java

    @Service public class FollowServiceImpl implements FollowService { @Autowired private FollowDao followDao;

    @Autowired
    private UserDao userDao;
    
    @Override
    public List<User> getFollowByUserId(Integer userId) {
        List<Follow> followList = followDao.getFollowByUserId(userId);
        List<User> userList = new ArrayList<>();
        for (Follow follow : followList) {
            userList.add(userDao.getUserById(follow.getFollowId()));
        }
        return userList;
    }
    
    @Override
    public List<User> getFansByUserId(Integer userId) {
        List<Follow> followList = followDao.getFansByUserId(userId);
        List<User> userList = new ArrayList<>();
        for (Follow follow : followList) {
            userList.add(userDao.getUserById(follow.getUserId()));
        }
        return userList;
    }
    
    @Override
    public void addFollow(Integer userId, Integer followId) {
        Follow follow = new Follow();
        follow.setUserId(userId);
        follow.setFollowId(followId);
        followDao.addFollow(follow);
    }
    
    @Override
    public void deleteFollow(Integer userId, Integer followId) {
        Follow follow = new Follow();
        follow.setUserId(userId);
        follow.setFollowId(followId);
        followDao.deleteFollow(follow);
    }
    

    }

    1. Controller层实现

    创建UserController和FollowController,分别处理用户和关注的请求。

    UserController.java

    @RestController @RequestMapping("/user") public class UserController { @Autowired private UserService userService;

    @GetMapping("/{userId}")
    public User getUserById(@PathVariable Integer userId) {
        return userService.getUserById(userId);
    }
    
    @GetMapping("/username/{username}")
    public User getUserById(@PathVariable String username) {
        return userService.getUserByUsername(username);
    }
    
    @PostMapping("")
    public void addUser(@RequestBody User user) {
        userService.addUser(user);
    }
    
    @DeleteMapping("/{userId}")
    public void deleteUserById(@PathVariable Integer userId) {
        userService.deleteUserById(userId);
    }
    

    }

    FollowController.java

    @RestController @RequestMapping("/follow") public class FollowController { @Autowired private FollowService followService;

    @GetMapping("/follow/{userId}")
    public List<User> getFollowByUserId(@PathVariable Integer userId) {
        return followService.getFollowByUserId(userId);
    }
    
    @GetMapping("/fans/{userId}")
    public List<User> getFansByUserId(@PathVariable Integer userId) {
        return followService.getFansByUserId(userId);
    }
    
    @PostMapping("/{userId}/{followId}")
    public void addFollow(@PathVariable Integer userId, @PathVariable Integer followId) {
        followService.addFollow(userId, followId);
    }
    
    @DeleteMapping("/{userId}/{followId}")
    public void deleteFollow(@PathVariable Integer userId, @PathVariable Integer followId) {
        followService.deleteFollow(userId, followId);
    }
    

    }

    1. 测试

    使用Postman测试一下用户和关注的功能:

    • 添加用户:POST /user

    { "username": "user1", "password": "123456", "email": "user1@example.com" }

    • 查询用户:GET /user/{userId} 或 GET /user/username/{username}

    • 添加关注:POST /follow/{userId}/{followId}

    • 删除关注:DELETE /follow/{userId}/{followId}

    • 查询用户的关注:GET /follow/follow/{userId}

    • 查询用户的粉丝:GET /follow/fans/{userId}

    以上就是使用Java的springboot实现用户之间关注和查看粉丝的功能的步骤了。

  3. User

    使用Java实现获取当前时间戳功能

  4. Assistant

    使用Java获取当前时间戳有两种方法:

    1. 使用System.currentTimeMillis()方法:

    System.currentTimeMillis()方法返回当前时间与1970年1月1日00:00:00之间的毫秒差值,即当前时间戳。

    可以将返回值转化为Long类型,如下:

    Long timestamp = System.currentTimeMillis();

    1. 使用Instant.now()方法:

    Instant是Java 8中的新类,它表示时间线上的一个点。

    Instant.now()方法返回当前时间点的Instant对象,可以使用toEpochMilli()方法将其转化为毫秒值,即当前时间戳。

    可以将返回值转化为Long类型,如下:

    Long timestamp = Instant.now().toEpochMilli();

    注意:以上两种方法获取的都是UTC(Coordinated Universal Time)时间,也叫格林威治标准时间(GMT)。如果需要转换为本地时间,可以使用Java提供的日期时间API进行转换。

  5. User

    Java类的变量,怎么在没传参时使用默认值

  6. Assistant

    在Java类中,可以为变量设置默认值。在创建对象时,如果没有为变量显式地赋值,则会使用默认值。

    Java中的变量类型有以下默认值:

    • 数值类型(byte, short, int, long, float, double)默认值为0
    • char类型默认值为'\u0000'
    • boolean类型默认值为false
    • 引用类型(如String、Object等)默认值为null

    示例如下:

    public class Test {
        int a; // 默认值为0
        char b; // 默认值为'\u0000'
        boolean c; // 默认值为false
        String d; // 默认值为null
    
        public static void main(String[] args) {
            Test t = new Test();
            System.out.println(t.a); // 输出0
            System.out.println(t.b); // 输出空白字符(即无输出)
            System.out.println(t.c); // 输出false
            System.out.println(t.d); // 输出null
        }
    }
    

    如果想要在对象创建时传入一些值,可以在构造函数中实现。示例如下:

    public class Employee {
        private String name;
        private int age;
        private String department;
    
        public Employee(String name, int age, String department) {
            this.name = name;
            this.age = age;
            this.department = department;
        }
    
        public String getName() {
            return name;
        }
    
        public void setName(String name) {
            this.name = name;
        }
    
        public int getAge() {
            return age;
        }
    
        public void setAge(int age) {
            this.age = age;
        }
    
        public String getDepartment() {
            return department;
        }
    
        public void setDepartment(String department) {
            this.department = department;
        }
    }
    
    public class Test {
        public static void main(String[] args) {
            Employee e1 = new Employee("张三", 25, "技术部");
            Employee e2 = new Employee("李四", 30, "市场部");
            Employee e3 = new Employee("王五", 35, "人事部");
    
            // ...
    
        }
    }
    

    以上示例中,Employee类的构造函数中已经设置了name、age、department的默认值,但是在创建对象时传入的值将会覆盖默认值。

  7. User

    使用Java实现一个获取自定义长度的函数

  8. Assistant

    以下是一个Java函数,可以用于获取指定长度的字符串或数字:

    public class StringUtils {
    
        /**
         * 获取自定义长度的随机字符串
         * @param length 长度
         * @return 随机字符串
         */
        public static String getRandomString(int length) {
            String str = "abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789";
            StringBuilder sb = new StringBuilder();
    
            for (int i = 0; i < length; i++) {
                sb.append(str.charAt((int)(Math.random() * str.length())));
            }
    
            return sb.toString();
        }
    
        /**
         * 获取自定义长度的随机数字
         * @param length 长度
         * @return 随机数字
         */
        public static String getRandomNumber(int length) {
            String str = "0123456789";
            StringBuilder sb = new StringBuilder();
    
            for (int i = 0; i < length; i++) {
                sb.append(str.charAt((int)(Math.random() * str.length())));
            }
    
            return sb.toString();
        }
    }
    

    以上代码中,getRandomString()函数用于获取指定长度的随机字符串,getRandomNumber()函数用于获取指定长度的随机数字。

    其中,使用了Java中的Math.random()函数来生成随机数,根据指定的字符串,选择随机的字符或数字,拼接成指定长度的字符串或数字。

  9. User

    Java实现一个男女的枚举类

  10. Assistant

    可以使用Java枚举类型来定义男女的类型,示例如下:

    public enum Gender {
        MALE("男"),
        FEMALE("女");
    
        private String name;
    
        public String getName() {
            return name;
        }
    
        private Gender(String name) {
            this.name = name;
        }
    }
    

    以上代码中,定义了一个名为Gender的枚举类型,包含MALE和FEMALE两个枚举项。每个枚举项都有一个name属性,表示性别的文字描述。使用getName()方法来获取该属性的值。使用private构造函数来初始化属性。

    使用该枚举类型的示例如下:

    public class Person {
        private String name;
        private Gender gender;
    
        public Person(String name, Gender gender) {
            this.name = name;
            this.gender = gender;
        }
    
        public String getName() {
            return name;
        }
    
        public void setName(String name) {
            this.name = name;
        }
    
        public Gender getGender() {
            return gender;
        }
    
        public void setGender(Gender gender) {
            this.gender = gender;
        }
    }
    
    public class Test {
        public static void main(String[] args) {
            Person p1 = new Person("张三", Gender.MALE);
            Person p2 = new Person("李四", Gender.FEMALE);
    
            // 输出性别
            System.out.println(p1.getName() + "的性别是:" + p1.getGender().getName());
            System.out.println(p2.getName() + "的性别是:" + p2.getGender().getName());
        }
    }
    

    输出结果如下:

    张三的性别是:男
    李四的性别是:女
    

    可以看到,通过使用枚举类型Gender,可以避免在使用String等基本类型时拼写错误,导致代码出错的问题。同时,它也提高了代码的可读性和可维护性。