IDEA版ssm增删改查

上篇做好登录之后开始进行角色的管理

entity类

可使用mybatis的逆向工程自动生成

import java.sql.Timestamp;
//时间类型为Timestamp
public class Role {

	private int r_id;
	private String r_name;
	private String r_desc;
	private Timestamp r_utime;
	public int getR_id() {
		return r_id;
	}
	public void setR_id(int r_id) {
		this.r_id = r_id;
	}
	public String getR_name() {
		return r_name;
	}
	public void setR_name(String r_name) {
		this.r_name = r_name;
	}
	public String getR_desc() {
		return r_desc;
	}
	public void setR_desc(String r_desc) {
		this.r_desc = r_desc;
	}
	public Timestamp getR_utime() {
		return r_utime;
	}
	public void setR_utime(Timestamp r_utime) {
		this.r_utime = r_utime;
	}
	@Override
	public String toString() {
		return "Role [r_id=" + r_id + ", r_name=" + r_name + ", r_desc=" + r_desc + ", r_utime=" + r_utime + "]";
	}
	

}

RoleController层

@Controller
@RequestMapping("/admin/role")
public class RoleController {

	@Autowired
	private RoleService rs;

	@RequestMapping("/list.action")
	public String list(Model model) {
		List<Role> list = rs.list();
		model.addAttribute("list", list);

		return "/role/roleList";
	}

}

service层

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

添加角色

---------------------------------------------------------------------------------------------------------------------------------------------------------------------

编辑角色

删除

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
<mapper namespace="crm.mapper.RoleMapper">
	<resultMap  type="crm.pojo.Role" id="BaseResultMap">
		<id column="r_id"    property="r_id" jdbcType="INTEGER" />
		<result column="r_name" property="r_name" jdbcType="VARCHAR" />
		<result column="r_desc" property="r_desc" jdbcType="VARCHAR" />
		<result column="r_utime" property="r_utime" jdbcType="TIMESTAMP"/>
	</resultMap>

	<select id="list"  resultMap="BaseResultMap">
		   select * from t_role
	</select> 
	
	<insert id="insert" parameterType="crm.pojo.Role">
		insert into t_role values(null, #{r_name,jdbcType=VARCHAR},
		 #{r_desc,jdbcType=VARCHAR},#{r_utime,jdbcType=TIMESTAMP})	
	</insert>
	
	<delete id="delete" parameterType="Integer">
		 delete from t_role where r_id = #{r_id}
	</delete>
	
	<select id="queryById" parameterType="Integer" resultType="crm.pojo.Role">
		select * from t_role where r_id = #{r_id}
	
	</select>
	
	<update id="update" parameterType="crm.pojo.Role">
	   update t_role set r_name = #{r_name},r_desc = #{r_desc}
	        ,r_utime = #{r_utime} where r_id = #{r_id}
	</update>
	
	
	
</mapper>

简单的角色crud完成

代码自取 杭歌的代码