Example #1
0
 @Override // 在执行关注之前先判断用户是否已被关注
 public void addFocusUser(long userId, long focusUserId) throws SQLException {
   QueryRunner queryRunner = new QueryRunner(DbTools.getDatasource());
   String sql = "insert into focus(user_id,Use_user_id) values(?,?)";
   Object[] param = {userId, focusUserId};
   queryRunner.update(sql, param);
 }
Example #2
0
 @Override
 public void cancerFocusUser(long userId, long focusUserId) throws SQLException {
   QueryRunner queryRunner = new QueryRunner(DbTools.getDatasource());
   String sql = "delete from focus where user_id=? and Use_user_id=? ";
   Object[] param = {userId, focusUserId};
   queryRunner.update(sql, param);
 }
Example #3
0
 /**
  * 没有关注user 返回值为0,否则返回被关注者的id
  *
  * @param userId
  * @return
  * @throws SQLException
  */
 @Override
 public List<Long> getFocusUserId(long userId) throws SQLException {
   QueryRunner queryRunner = new QueryRunner(DbTools.getDatasource());
   String sql = "select Use_user_id from focus where user_id=?";
   Object[] param = {userId};
   List ls = queryRunner.query(sql, new ArrayListHandler(), param);
   List<Long> focusUserId = new ArrayList<>();
   for (Object obj : ls) {
     Object[] objs = (Object[]) obj;
     String s = objs[0] + "";
     focusUserId.add(Long.parseLong(s));
   }
   return focusUserId;
 }