Example #1
0
  @Override
  public boolean isUserExisted(String email) throws Exception {
    // TODO Auto-generated method stub
    // 连接数据库
    DatabaseConnection dbc = new DatabaseConnection();
    Connection conn = dbc.getConnection();
    PreparedStatement pStatement = null;
    // 声明变量用于存取结果
    boolean isExisted = false;
    // 搜索语句
    String query = "select * from user where email=\'" + email + "\'";
    try {
      // 执行搜索
      pStatement = conn.prepareStatement(query);
      ResultSet rs = pStatement.executeQuery();

      // 判断是否为空
      if (!rs.next()) {
        System.out.println("Not Existed!");
        isExisted = false;
      } else {
        System.out.println("Existed!");
        isExisted = true;
      }
      // 关闭连接,返回结果
      // rs.close();
      dbc.close();
      return isExisted;
    } catch (SQLException e) {
      e.printStackTrace();
    }
    return isExisted;
  }
Example #2
0
  @Override
  public boolean insertRole(int uid, int pid, int participateWay, boolean isManager)
      throws Exception {
    // TODO Auto-generated method stub
    // 连接数据库
    DatabaseConnection dbc = new DatabaseConnection();
    Connection conn = dbc.getConnection();
    PreparedStatement pStatement = null;
    // 判断结果
    boolean isSuccess = false;
    // 插入语句
    String query =
        "INSERT INTO role (RoleID, UID, PID, IsManager, ParticipateWay, Date) "
            + "VALUES (NULL, ?, ?, ?, ?, CURRENT_TIMESTAMP);";
    String updataFavCount = "UPDATE  project SET  FavCount = FavCount + 1 WHERE PID =" + pid;
    String memberCount = "UPDATE  project SET  MemberCount = MemberCount + 1 WHERE PID =" + pid;
    try {
      // 执行搜索
      pStatement = conn.prepareStatement(query);
      pStatement.setInt(1, uid);
      pStatement.setInt(2, pid);
      pStatement.setBoolean(3, isManager);
      pStatement.setInt(4, participateWay);

      int row = pStatement.executeUpdate();

      // 判断是否为空
      if (row > 0) {
        System.out.println("insertRole Successful!");
        if (participateWay == 3) {
          pStatement = conn.prepareStatement(updataFavCount);
          pStatement.executeUpdate();
        } else {
          pStatement = conn.prepareStatement(memberCount);
          pStatement.executeUpdate();
        }
        isSuccess = true;
      } else {
        System.out.println("insertRole Insert faild!");
        isSuccess = false;
      }
      // 关闭连接,返回结果
      // rs.close();
      dbc.close();
      return isSuccess;
    } catch (SQLException e) {
      e.printStackTrace();
    }
    return false;
  }
Example #3
0
  @Override
  public List<User> findByUIDs(int[] uidArray) throws Exception {
    // TODO Auto-generated method stub
    // 连接数据库
    DatabaseConnection dbc = new DatabaseConnection();
    Connection conn = dbc.getConnection();
    PreparedStatement pStatement = null;
    // 声明变量用于存取结果
    List<User> userList = new LinkedList<User>();
    // 搜索语句
    String query = "select * from user where uid = ?";

    try {
      // 执行搜索
      pStatement = conn.prepareStatement(query);

      for (int i = 0; i < uidArray.length; i++) {
        pStatement.setInt(1, uidArray[i]);
        ResultSet rs = pStatement.executeQuery();

        while (rs.next()) {
          User user = new User();
          user.setMBID(rs.getInt("MBID"));
          user.setFullName(rs.getString("FullName"));
          user.setAvatarUrl(rs.getString("AvatarUrl"));
          user.setEmail(rs.getString("Email"));
          user.setPassWord(rs.getString("PassWord"));
          user.setUID(rs.getInt("UID"));

          userList.add(user);
        }
      }
      // 判断是否为空
      if (userList.size() != 0) {
        System.out.println("Successful!");
      } else {
        System.out.println("No record satisfied!");
        userList = null;
      }
      // 关闭连接,返回结果
      // rs.close();
      dbc.close();
      return userList;
    } catch (SQLException e) {
      e.printStackTrace();
    }
    return null;
  }
Example #4
0
  @Override
  public int[] findMyProjectIDs(int uid, int participateWay) throws Exception {
    // TODO Auto-generated method stub
    // 连接数据库
    DatabaseConnection dbc = new DatabaseConnection();
    Connection conn = dbc.getConnection();
    PreparedStatement pStatement = null;
    // 声明变量用于存取结果
    int[] pidArray;
    // 搜索语句
    String query = "select pid from role where uid=? and participateWay=? order by pid desc";

    try {
      // 执行搜索
      pStatement = conn.prepareStatement(query);
      pStatement.setInt(1, uid);
      pStatement.setInt(2, participateWay);
      ResultSet rs = pStatement.executeQuery();

      // 获取结果集大小
      rs.last();
      pidArray = new int[rs.getRow()];
      // 逐个获取结果
      rs.beforeFirst();
      /*while(rs.next()) {
      	int i = 0;
      	pidArray[i] = rs.getInt("pid");
      	i++;
      }*/
      for (int i = 0; rs.next(); i++) {
        pidArray[i] = rs.getInt("pid");
      }
      // 判断是否为空
      if (pidArray.length != 0) {
        System.out.println("findMyProjectIDs Successful!");
      } else {
        System.out.println("findMyProjectIDs No record satisfied!");
        pidArray = null;
      }
      // 关闭连接,返回结果
      // rs.close();
      dbc.close();
      return pidArray;
    } catch (SQLException e) {
      e.printStackTrace();
    }
    return null;
  }
Example #5
0
  @Override
  public List<User> findByUserName(String userName) throws Exception {
    // TODO Auto-generated method stub
    // 连接数据库
    DatabaseConnection dbc = new DatabaseConnection();
    Connection conn = dbc.getConnection();
    PreparedStatement pStatement = null;
    // 声明变量用于存取结果
    List<User> userList = new LinkedList<User>();
    // 搜索语句
    String query = "SELECT * FROM user WHERE Fullname LIKE '%" + userName + "%'";
    try {
      // 执行搜索
      pStatement = conn.prepareStatement(query);
      // pStatement.setString(1, userName);
      ResultSet rs = pStatement.executeQuery();

      while (rs.next()) {
        User user = new User();
        user.setMBID(rs.getInt("MBID"));
        user.setFullName(rs.getString("FullName"));
        user.setAvatarUrl(rs.getString("AvatarUrl"));
        user.setEmail(rs.getString("Email"));
        user.setPassWord(rs.getString("PassWord"));
        user.setUID(rs.getInt("UID"));

        userList.add(user);
      }
      // 判断是否为空
      if (userList.size() != 0) {
        System.out.println("findByUserName Successful!");
      } else {
        System.out.println("findByUserName No record satisfied!");
        userList = null;
      }
      // 关闭连接,返回结果
      // rs.close();
      dbc.close();
      return userList;
    } catch (SQLException e) {
      e.printStackTrace();
    }
    return null;
  }
Example #6
0
  @Override
  public User signin(String email, String password) throws Exception {
    // TODO Auto-generated method stub
    // 连接数据库
    DatabaseConnection dbc = new DatabaseConnection();
    Connection conn = dbc.getConnection();
    PreparedStatement pStatement = null;
    // 声明变量用于存取结果
    User user = new User();
    // 搜索语句
    String query = "select * from user where email= ? and password= ?";

    try {
      // 执行搜索
      pStatement = conn.prepareStatement(query);
      pStatement.setString(1, email);
      pStatement.setString(2, password);
      ResultSet rs = pStatement.executeQuery();

      while (rs.next()) {
        user.setMBID(rs.getInt("MBID"));
        user.setFullName(rs.getString("FullName"));
        user.setAvatarUrl(rs.getString("AvatarUrl"));
        user.setEmail(rs.getString("Email"));
        user.setPassWord(rs.getString("PassWord"));
        user.setUID(rs.getInt("UID"));
      }
      // 判断是否为空
      if (user.getUID() != 0) {
        System.out.println("Signin Successfully!");
      } else {
        System.out.println("Signin Faild!");
        user = null;
      }
      // 关闭连接,返回结果
      // rs.close();
      dbc.close();
      return user;
    } catch (SQLException e) {
      e.printStackTrace();
    }
    return null;
  }
Example #7
0
  @Override
  public User findByUID(int uid) throws Exception {
    // TODO Auto-generated method stub
    // 连接数据库
    DatabaseConnection dbc = new DatabaseConnection();
    Connection conn = dbc.getConnection();
    PreparedStatement pStatement = null;
    // 声明变量用于存取结果
    User user = new User();
    // 搜索语句
    String query = "select * from user where uid=" + uid;
    try {
      // 执行搜索
      pStatement = conn.prepareStatement(query);
      ResultSet rs = pStatement.executeQuery();

      while (rs.next()) {
        user.setMBID(rs.getInt("MBID"));
        user.setFullName(rs.getString("FullName"));
        user.setAvatarUrl(rs.getString("AvatarUrl"));
        user.setEmail(rs.getString("Email"));
        user.setPassWord(rs.getString("PassWord"));
        user.setUID(rs.getInt("UID"));
      }
      // 判断是否为空
      if (user.getFullName() != null) {
        System.out.println("findByUID Successful!");
      } else {
        System.out.println("findByUID No record satisfied!");
        user = null;
      }
      // 关闭连接,返回结果
      // rs.close();
      dbc.close();
      return user;
    } catch (SQLException e) {
      e.printStackTrace();
    }
    return null;
  }
Example #8
0
  @Override
  public User updateProfile(User user) throws Exception {
    // TODO Auto-generated method stub
    // 连接数据库
    DatabaseConnection dbc = new DatabaseConnection();
    Connection conn = dbc.getConnection();
    PreparedStatement pStatement = null;
    // 声明变量用于存取结果
    User updatedUser = new User();
    // 搜索语句
    String query =
        "UPDATE user SET Email = ?, FullName = ?, AvatarUrl = ?, Password = ? " + "WHERE  uid = ?";
    try {
      // 执行搜索
      pStatement = conn.prepareStatement(query);
      pStatement.setString(1, user.getEmail());
      pStatement.setString(2, user.getFullName());
      pStatement.setString(3, user.getAvatarUrl());
      pStatement.setString(4, user.getPassWord());
      pStatement.setInt(5, user.getUID());
      int row = pStatement.executeUpdate();

      // 判断是否为空
      if (row > 0) {
        updatedUser = user;
        System.out.println("updateProfile Successful!");
      } else {
        System.out.println("updateProfile No record satisfied!");
        user = null;
      }
      // 关闭连接,返回结果
      // rs.close();
      dbc.close();
      return updatedUser;
    } catch (SQLException e) {
      e.printStackTrace();
    }
    return null;
  }
Example #9
0
  @Override
  public User signup(String email, String password, String fullName, String avatarUrl)
      throws Exception {
    // TODO Auto-generated method stub
    // 连接数据库
    DatabaseConnection dbc = new DatabaseConnection();
    Connection conn = dbc.getConnection();
    PreparedStatement pStatement = null;
    // 结果
    User user = new User();
    // 搜索语句
    String query =
        "INSERT INTO user (UID, Email, Password, Fullname, AvatarURL, MBID) "
            + "VALUES (NULL, ?, ?, ?, ?, ?)";
    String result = "select * from user where email=?";
    if (isUserExisted(email)) {
      return null;
    } else {
      try {
        // 新建MsgBoard给新用户
        MsgBoardDAOImpl mdi = new MsgBoardDAOImpl();
        MsgBoard msgBoard = mdi.createMsgBoard();
        // 执行插入
        pStatement = conn.prepareStatement(query);
        pStatement.setString(1, email);
        pStatement.setString(2, password);
        pStatement.setString(3, fullName);
        pStatement.setString(4, avatarUrl);
        pStatement.setInt(5, msgBoard.getMBID());

        int row = pStatement.executeUpdate();
        // 判断是否为空
        if (row > 0) {
          // 若不为空,返回刚插入的对象
          System.out.println("Signup Successful!");
          pStatement = conn.prepareStatement(result);
          pStatement.setString(1, email);
          ResultSet rs = pStatement.executeQuery();
          if (rs.next()) {
            user.setMBID(rs.getInt("MBID"));
            user.setFullName(rs.getString("FullName"));
            user.setAvatarUrl(rs.getString("AvatarUrl"));
            user.setEmail(rs.getString("Email"));
            user.setPassWord(rs.getString("PassWord"));
            user.setUID(rs.getInt("UID"));
          }
        } else {
          System.out.println("Signup faild!");
          user = null;
        }
        // 关闭连接,返回结果
        // rs.close();
        dbc.close();
        return user;

      } catch (SQLException e) {
        e.printStackTrace();
      }
    }
    return null;
  }