<?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.ibatis;
import org.ycl.base.dos.UserDO;
import org.ycl.base.daos.UserDAO;
import org.frame.base.dao.DefaultSqlMapBaseDAO;
import org.frame.base.exception.DAOException;
/**
* 用户
*
* @author ycl
*
*/
public class UserIbatisDAO extends DefaultSqlMapBaseDAO implements UserDAO {
@Override
public UserDO queryUser(Long userId) throws DAOException {
return (UserDO) super.queryForObject(userId);
}
@Override
public Long insertUser(UserDO userDO) throws DAOException {
return super.insert(userDO);
}
@Override
public Integer updateUser(UserDO userDO) throws DAOException {
return super.update(userDO);
}
@Override
public Integer deleteUser(Long userId) throws DAOException {
return super.delete(userId);
}
}