<?xml version="1.0" encoding="UTF-8"?>
<schema>
<tables>
<table name="user" desc="用户">
<columns>
<column name="id" type="Long" desc="用户id"/>
<column name="name" type="String" desc="用户名称"/>
<column name="gender" type="String" desc="用户性别"/>
<column name="email" type="String" desc="用户Email"/>
</columns>
</table>
<table name="role" desc="角色">
<columns>
<column name="id" type="Long" desc="角色id"/>
<column name="name" type="String" desc="角色名称"/>
<column name="level" type="String" desc="角色级别"/>
<!-- 简单的权限控制 -->
</columns>
</table>
</tables>
</schema>
package org.ycl.base.daos;
import org.ycl.base.dos.UserDO;
import org.frame.base.exception.DAOException;
/**
* 用户
*
* @author ycl
*
*/
public interface UserDAO {
/**
* 搜索用户
*
* @param id
* @return
*/
public UserDO queryUser(Long id) throws DAOException;
/**
* 添加用户
*
* @param userDO
* @return
*/
public Long insertUser(UserDO userDO) throws DAOException;
/**
* 删除用户
*
* @param id
* @return
*/
public Integer deleteUser(Long id) throws DAOException;
/**
* 更新用户
*
* @param userDO
* @return
*/
public Integer updateUser(UserDO userDO) throws DAOException;
}