使用Java的springboot实现用户之间关注和查看粉丝的功能
- User
使用Java的springboot实现用户之间关注和查看粉丝的功能
- Assistant
- 数据库设计
首先,在数据库中设计出用户表user和关注表follow。用户表用来存储用户的基本信息,如用户名、密码、邮箱等。关注表用来记录用户之间的关注关系,包括被关注人id和关注人id。
用户表设计如下:
CREATE TABLE
user(user_idint(11) NOT NULL AUTO_INCREMENT,usernamevarchar(50) NOT NULL,passwordvarchar(50) NOT NULL,emailvarchar(50) NOT NULL, PRIMARY KEY (user_id) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;关注表设计如下:
CREATE TABLE
follow(idint(11) NOT NULL AUTO_INCREMENT,user_idint(11) NOT NULL,follow_idint(11) NOT NULL, PRIMARY KEY (id) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;- 创建实体类
根据上述数据库表结构,创建实体类如下:
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}
- 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()); }}
- 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); }}
- 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); }}
- 测试
使用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实现用户之间关注和查看粉丝的功能的步骤了。
- User
使用Java实现获取当前时间戳功能
- Assistant
使用Java获取当前时间戳有两种方法:
- 使用System.currentTimeMillis()方法:
System.currentTimeMillis()方法返回当前时间与1970年1月1日00:00:00之间的毫秒差值,即当前时间戳。
可以将返回值转化为Long类型,如下:
Long timestamp = System.currentTimeMillis();
- 使用Instant.now()方法:
Instant是Java 8中的新类,它表示时间线上的一个点。
Instant.now()方法返回当前时间点的Instant对象,可以使用toEpochMilli()方法将其转化为毫秒值,即当前时间戳。
可以将返回值转化为Long类型,如下:
Long timestamp = Instant.now().toEpochMilli();
注意:以上两种方法获取的都是UTC(Coordinated Universal Time)时间,也叫格林威治标准时间(GMT)。如果需要转换为本地时间,可以使用Java提供的日期时间API进行转换。
- User
Java类的变量,怎么在没传参时使用默认值
- 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的默认值,但是在创建对象时传入的值将会覆盖默认值。
- User
使用Java实现一个获取自定义长度的函数
- 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()函数来生成随机数,根据指定的字符串,选择随机的字符或数字,拼接成指定长度的字符串或数字。
- User
Java实现一个男女的枚举类
- 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等基本类型时拼写错误,导致代码出错的问题。同时,它也提高了代码的可读性和可维护性。