mybatis+spring mvc 完美整合方案 查询，保存，更新，删除自动生成

Jeecg-Mybatis版本代码生成器演示视频

  http://pan.baidu.com/share/link?shareid=243717&uk=2668473880
简要说明
JEECG[J2EE Code Generation]
代码生成：根据表生成对应的Bean,Service,Dao,Action,XML,JSP等,增删改查功能直接使用,实现了快速开发
jeecg-mybatis-framework,采用SpringMVC+Mybatis等主流框架
支持数据库: Mysql,Oracle10g
前端:使用Jquery和Easyui技术.JS封装简洁,操作简单.
权限:对菜单,按钮控制.根据登陆用户权限展示拥有的菜单和按钮.
拦截:对所有无权限URL进行拦截,防止手动发送HTTP请求,确保系统全性.

<?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="scott.dao.demo.JeecgNoteDao" > 
<!-- Result Map-->
<resultMap id="BaseResultMap" type="scott.entity.demo.JeecgNote" >
	<result column="id" property="id"/>
	<result column="title" property="title"/>
	<result column="content" property="content"/>
	<result column="crtuser" property="crtuser"/>
	<result column="crtuser_name" property="crtuser_name"/>
	<result column="create_dt" property="create_dt"/>
	<result column="deleted" property="deleted"/>
</resultMap>
       
<!-- jeecg_note table all fields -->
<sql id="Base_Column_List" >
	 id,title,content,crtuser,crtuser_name,create_dt,deleted
</sql>
   
   
<!-- 查询条件 -->
<sql id="Example_Where_Clause">
where 1=1
<trim  suffixOverrides="," >
	<if test="id != null and id != ''" >
	    and id =  #{id}
	</if>
	<if test="title != null and title != ''" >
	    and title =  #{title}
	</if>
	<if test="content != null and content != ''" >
	    and content =  #{content}
	</if>
	<if test="crtuser != null and crtuser != ''" >
	    and crtuser =  #{crtuser}
	</if>
	<if test="crtuser_name != null and crtuser_name != ''" >
	    and crtuser_name =  #{crtuser_name}
	</if>
	<if test="create_dt != null and create_dt != ''" >
	    and create_dt =  #{create_dt}
	</if>
	<if test="deleted != null and deleted != ''" >
	    and deleted =  #{deleted}
	</if>
</trim>
</sql>
   

<!-- 插入记录 -->
<insert id="add" parameterType="Object" >
<selectKey resultType="java.lang.Integer" order="AFTER" keyProperty="id">
	SELECT LAST_INSERT_ID()
  </selectKey>
  insert into jeecg_note(id,title,content,crtuser,crtuser_name,create_dt,deleted)
 values(#{id},#{title},#{content},#{crtuser},#{crtuser_name},#{create_dt},#{deleted})
</insert>

<!-- 根据id，修改记录-->  
 <update id="update" parameterType="Object" >
  update jeecg_note set title=#{title},content=#{content},crtuser=#{crtuser},crtuser_name=#{crtuser_name},create_dt=#{create_dt},deleted=#{deleted} where id=#{id}
 </update>
 
 <!-- 修改记录，只修改只不为空的字段 -->
<update id="updateBySelective" parameterType="Object" >
	update jeecg_note set 
	<trim  suffixOverrides="," >
	<if test="title != null  ">
		title=#{title},
	</if>
	<if test="content != null  ">
		content=#{content},
	</if>
	<if test="crtuser != null  ">
		crtuser=#{crtuser},
	</if>
	<if test="crtuser_name != null  ">
		crtuser_name=#{crtuser_name},
	</if>
	<if test="create_dt != null  ">
		create_dt=#{create_dt},
	</if>
	<if test="deleted != null  ">
		deleted=#{deleted},
	</if>
	</trim> where id=#{id}
</update>

<!-- 删除记录 -->
<delete id="delete" parameterType="Object">
	delete 	 from jeecg_note where id = #{id}
</delete>
 
<!-- 根据id查询 公告 -->
<select id="queryById"  resultMap="BaseResultMap" parameterType="Object">
	select <include refid="Base_Column_List" /> 
	 from jeecg_note where id = #{id}
</select>

<!-- 公告 列表总数-->
<select id="queryByCount" resultType="java.lang.Integer"  parameterType="Object">
	select count(1) from jeecg_note 
	<include refid="Example_Where_Clause"/>
</select>
  	
<!-- 查询公告列表 -->
<select id="queryByList" resultMap="BaseResultMap"  parameterType="Object">
	select 
	<include refid="Base_Column_List"/>
	from jeecg_note 
	<include refid="Example_Where_Clause"/>
	<if test="pager.orderCondition != null and pager.orderCondition != ''" >
      ${pager.orderCondition}
    </if>
    <if test="pager.mysqlQueryCondition != null and pager.mysqlQueryCondition != ''" >
       ${pager.mysqlQueryCondition}
    </if>
</select>
  	
</mapper>   

是一个代码生成工具么？？

封装好的一个成熟的框架，代码可以一键生成

我知道有个mybatis-generator.jar，一个开源的自动化工具，可以直接读db反向生成java代码和xml啥的。

不过楼主这个做的不错，权限是用什么做的？看了一下项目的源码有41MB，不知道楼主有没有用maven构建项目，建议使用maven。

很多朋友建议过，我之所以不换，是担心有些人用不明白！还有就是jar包有时候下载不下来

楼主要开源啊，这样才有活力~~~

在哪下载呢

怎么只有视频，没有工具下载？