userdao.java

一个bbs论坛系统

package com.lovo.dao;

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

import com.lovo.po.UserPO;
import com.lovo.util.Page;

public interface UserDAO {
	/** 添加一条用户记录 */
	public void insert(UserPO po) throws SQLException;

	/** 删除一条用户记录 */
	public void delete(String name) throws SQLException;
	public void delete(int id) throws SQLException;

	/** 修改一条用户记录 */
	public void update(UserPO po) throws SQLException;

	/** 根据name查找某个用户 */
	public UserPO queryUserByName(String name) throws SQLException;
	
	/** 根据id查找某个用户 */
	public UserPO queryUserById(int id) throws SQLException;

	/** 查询全部用户 */
	public List<UserPO> queryUser(Page page) throws SQLException;

	/** 根据名字模糊查询 */
	public List<UserPO> queryUserByLike(String name) throws SQLException;
	
	/** 财富排名 */
	public List<UserPO> queryUserByWealth(Page page) throws SQLException;
	public List<UserPO> queryUserByWealth() throws SQLException;
	
	/** 新人排名 */
	public List<UserPO> queryUserByRegisterTime() throws SQLException;

	/** 根据区域ID查询区主 */
	public List<UserPO> queryByAreaId(int areaId) throws SQLException;

	/** 根据区域name查询区主 */
	public List<UserPO> queryByAreaName(String AreaName) throws SQLException;

	/** 根据版块ID查询版主 */
	public List<UserPO> queryByBlockId(int blockId) throws SQLException;

	/** 根据版块name查询版主 */
	public List<UserPO> queryByBlockName(String blockName) throws SQLException;
	
	public int queryRegUserNum() throws SQLException ;
}