userdao.java

网上购物系统

// ----------------------------------------------------------
// $Id: $
// Copyright (c) SHSAFE 2005-2006. All Rights Reserved.
// ----------------------------------------------------------
package example.user;

import java.sql.SQLException;
import java.util.List;
import java.util.Map;

import com.shsafe.common.basic.attribute.PageInformation;
import com.shsafe.common.basic.dto.DTOFactory;
import com.shsafe.common.database.DatabaseConnection;

import example.common.dao.ExampleDAO;
import example.common.dto.UserDTO;

/**
 * @author Michael J Chane
 * @version $Revision: $ $Date: $
 */
public class UserDAO extends ExampleDAO {

  /**
   * Creates a new <code>UserDAO</code> object.
   * 
   * @param connection
   * @throws SQLException
   */
  public UserDAO(DatabaseConnection connection) throws SQLException {
    super(connection);
  }

  /**
   * @param condition
   * @return count of users
   * @throws SQLException
   */
  public int countUsers(UserDTO condition) throws SQLException {
    return count("countUsers", condition);
  }

  /**
   * @param condition
   * @param pageInfo
   * @return users
   * @throws SQLException
   */
  @SuppressWarnings("unchecked")
  public List<UserDTO> searchUsers(UserDTO condition, PageInformation pageInfo)
      throws SQLException {
    List<Map<String, Object>> list = findOnPage("searchUsers", condition,
        pageInfo);
    List<UserDTO> dtoList = DTOFactory.convert(list, UserDTO.class);
    return dtoList;
  }

  /**
   * @param users
   * @return rows affected
   * @throws SQLException
   */
  @SuppressWarnings("unchecked")
  public int updateUsers(List users) throws SQLException {
    return changeAll("updateUsers", users);
  }
}