コード例 #1
0
ファイル: MySQLUserDao.java プロジェクト: CoderJaymark/NACv5
 @Override
 public User retrieveUser(User user) {
   final String SQL = "SELECT * FROM users WHERE username = ?";
   PreparedStatement preparedStatement = PreparedStatementCreator.createPreparedStatement(SQL);
   ResultSet resultSet = null;
   try {
     preparedStatement.setString(1, user.getUsername());
     resultSet = preparedStatement.executeQuery();
     rowAffected = resultSet.getFetchSize();
     System.out.println("Row: " + rowAffected);
   } catch (SQLException e) {
     e.printStackTrace();
   }
   User retrievedUser = null;
   try {
     while (resultSet.next()) {
       retrievedUser = new User();
       retrievedUser.setFirstName(resultSet.getString("first_name"));
       retrievedUser.setLastName(resultSet.getString("last_name"));
       retrievedUser.setUsername(resultSet.getString("username"));
       retrievedUser.setEmail(resultSet.getString("email"));
       retrievedUser.setPassword(resultSet.getString("password"));
       retrievedUser.setType(resultSet.getString("user_type"));
     }
   } catch (SQLException e) {
     e.printStackTrace();
   }
   return retrievedUser;
 }
コード例 #2
0
ファイル: MySQLUserDao.java プロジェクト: CoderJaymark/NACv5
 @Override
 public Integer updateUser(User oldUserInfo, User newUserInfo) {
   final String SQL = "UPDATE users SET email = ? WHERE email = ?";
   PreparedStatement preparedStatement = PreparedStatementCreator.createPreparedStatement(SQL);
   try {
     preparedStatement.setString(1, newUserInfo.getEmail());
     preparedStatement.setString(2, oldUserInfo.getEmail());
   } catch (SQLException e) {
     e.printStackTrace();
   }
   Integer numberOfUpdates = null;
   try {
     numberOfUpdates = preparedStatement.executeUpdate();
   } catch (SQLException e) {
     e.printStackTrace();
   }
   return numberOfUpdates;
 }
コード例 #3
0
ファイル: AdminRegister.java プロジェクト: CoderJaymark/NACv5
  /** @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response) */
  protected void doPost(HttpServletRequest request, HttpServletResponse response)
      throws ServletException, IOException {
    String firstname = request.getParameter("firstname");
    String lastname = request.getParameter("lastname");
    String email = request.getParameter("email");
    String username = request.getParameter("username");
    String password1 = request.getParameter("password");
    String password2 = request.getParameter("password1");
    String gender = request.getParameter("gender");
    String address = request.getParameter("address");
    String contact = request.getParameter("contact");
    String superPassword = request.getParameter("superPassword");

    User user = new User();
    UserService service = new UserService(user);
    MySQLUserDao userDao = new MySQLUserDao();

    //		if(!service.isUsernameAvailable()){
    //			response.sendRedirect("Error.jsp");
    //			return;
    //		}
    //
    //		else if(!service.isPasswordMatch(password1, password2)){
    //			response.sendRedirect("Error.jsp");
    //			return;
    //		}
    //

    user.setFirstName(firstname);
    user.setLastName(lastname);
    user.setUsername(username);
    user.setEmail(email);
    user.setPassword(password1);
    user.setAddress(address);
    user.setContactNumber(contact);
    user.setType("admin");

    int status = userDao.createUser(user);
    if (status > 0) {
      RequestDispatcher rd = request.getRequestDispatcher("AdminLogin");
      rd.forward(request, response);
    } else {
      RequestDispatcher rd = request.getRequestDispatcher("login.jsp");
      request.setAttribute("error", true);
      rd.forward(request, response);
    }
  }
コード例 #4
0
ファイル: MySQLUserDao.java プロジェクト: CoderJaymark/NACv5
  @Override
  public Integer createUser(User user) {
    final String query =
        "INSERT INTO users (first_name, last_name, username, email, password, contact, address, user_type) values (?, ?, ?, ?, ?, ?, ?, ?)";
    PreparedStatement preparedStatement = PreparedStatementCreator.createPreparedStatement(query);
    Integer numberOfRecordsAdded = 0;
    try {
      preparedStatement.setString(1, user.getFirstName());
      preparedStatement.setString(2, user.getLastName());
      preparedStatement.setString(3, user.getUsername());
      preparedStatement.setString(4, user.getEmail());
      preparedStatement.setString(5, user.getPassword());
      preparedStatement.setString(6, user.getContactNumber());
      preparedStatement.setString(7, user.getAddress());
      preparedStatement.setString(8, user.getType());

      numberOfRecordsAdded = preparedStatement.executeUpdate();
    } catch (SQLException e) {
      e.printStackTrace();
    }
    return numberOfRecordsAdded;
  }