usermanagedao.java

网上购物系统

package example.usermanage;

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;

public class UserManageDAO extends ExampleDAO {

	public UserManageDAO(DatabaseConnection connection) throws SQLException {
		super(connection);
	}

	@SuppressWarnings("unchecked")
	public List<UserDTO> find(UserDTO user, PageInformation pageInfo)
			throws SQLException {
		List<Map<String, Object>> data = findOnPage("find", user, pageInfo);
		List<UserDTO> list = DTOFactory.convert(data, UserDTO.class);
		return list;
	}

	public int count(UserDTO user) throws SQLException {
		return count("count", user);
	}

	public int update(UserDTO user) throws SQLException {
		return change("modify", user);
	}

	public int add(UserDTO user) throws SQLException {
		return change("add", user);
	}

	public int delete(UserDTO user) throws SQLException {
		return change("delete", user);
	}
}