Role

package com.song.dao;

import com.song.popj.Role;
import org.apache.ibatis.annotations.Param;

import java.util.List;

public interface RoleMapper {
//练习1：获取角色列表
public List<Role> getRoleList();
//练习2：添加角色信息
public int add(Role role);
//练习3：通过Id删除Role RoleMapper主要看@Param里的参数名
public int deleteRoleById(@Param("id")Integer delId);
//练习4：修改角色信息
public int modify(Role role);
//练习5：通过Id获取role
public Role getRoleById(@Param("id")Integer id);
//练习6：根据roleCode，进行角色编码的唯一性验证,使用计数count
public int roleCodeIsExist(@Param("roleCode") String roleCode);
}

 

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.song.dao.RoleMapper">
<select id="getRoleList" resultType="Role">
select * from smbms.smbms_role;
</select>
<insert id="add" parameterType="Role">
insert into smbms.smbms_role values(#{id},#{roleCode},#{roleName},#{createdBy},#{creationDate},#{modifyBy},#{modifyDate})
</insert>
<delete id="deleteRoleById" parameterType="int">
delete from smbms.smbms_role where id=#{id}
</delete>
<update id="modify" parameterType="Role">
update smbms.smbms_role
<set>
<if test="roleCode != null">
roleCode=#{roleCode},
</if>
<if test="roleName != null">
roleName=#{roleName},
</if>
<if test="createdBy != null">
createdBy=#{createdBy},
</if>
<if test="creationDate != null">
creationDate=#{creationDate},
</if>
<if test="modifyBy != null">
modifyBy=#{modifyBy},
</if>
<if test="modifyDate!=null">
modifyDate=#{modifyDate}
</if>
</set>
where id = #{id}
</update>
<select id="getRoleById" parameterType="int" resultType="Role">
select * from smbms.smbms_role where id=#{id}
</select>
<select id="roleCodeIsExist" parameterType="java.lang.String" resultType="java.lang.Integer">
select count(*) from smbms.smbms_role where roleCode=#{roleCode}
</select>
</mapper>

 

package com.song.popj;

import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;

import java.util.Date;
@AllArgsConstructor
@NoArgsConstructor
@Data
public class Role {
private Integer id; //id
private String roleCode; //角色编码
private String roleName; //角色名称
private Integer createdBy; //创建者
private Date creationDate; //创建时间
private Integer modifyBy; //更新者
private Date modifyDate;//更新时间
}

搜索

复制