| | |
| | | </select> |
| | | |
| | | <select id="selectByPage" resultType="com.lf.server.entity.data.MetaEntity"> |
| | | select * from lf.sys_meta |
| | | select a.*,fn_uname(a.create_user) uname,fn_rec_query(a.depid, 'dep') depName,fn_ver(a.verid) verName from lf.sys_meta a |
| | | <where> |
| | | <if test="name != null"> |
| | | name like #{name} |
| | |
| | | </select> |
| | | |
| | | <select id="selectById" resultType="com.lf.server.entity.data.MetaEntity"> |
| | | select * from lf.sys_meta where id = #{id} |
| | | select a.*,fn_uname(a.create_user) uname,fn_rec_query(a.depid, 'dep') depName,fn_ver(a.verid) verName from lf.sys_meta a where id = #{id} |
| | | </select> |
| | | |
| | | <insert id="insert" parameterType="com.lf.server.entity.data.MetaEntity"> |