【jeecg-mybatis版本】 mybatis+spring mvc 完美整合方案 查询，保存，更新，删除自动生成

Jeecg-mybatis-framework 版本

简要说明

• JEECG[J2EE Code Generation]是一款基于代码生成器的J2EE智能开发框架,借助该框架可以节省50%的工作量,实现代码生成+手工merge的半智能开发
• 代码生成：根据表生成对应的Bean,Service,Dao,Action,XML,JSP等,增删改查功能直接使用,实现了快速开发
• jeecg-mybatis-framework,采用SpringMVC+Mybatis等主流框架
• 支持数据库: Mysql,Oracle10g
• 前端:使用Jquery和Easyui技术.JS封装简洁,操作简单.
• 权限:对菜单,按钮控制.根据登陆用户权限展示拥有的菜单和按钮.
• 拦截:对所有无权限URL进行拦截,防止手动发送HTTP请求,确保系统全性.

源码下载：

链接:http://pan.baidu.com/s/1pJMkprt密码: k3u8

入门视频：

链接:http://pan.baidu.com/s/1ntD0O1z密码: 66gi

环境搭建：

1.创建一个utf-8的数据库，数据库名jeecgmybatis
2.执行脚本jeecgmybatis.sql，初始化数据库
3.项目导入myeclipse工程
4.启动项目
访问：http://localhost:8080/jeecg-mybatis-framework
5.代码生成器路径
/jeecg-mybatis-framework/src/com/code/CodeUtil.java

技术交流

本系统由JEECG社区提供,如需个性化定制,可与官方（www.jeecg.org）联系.

• 交流:106259349, 106838471, 289782002
• 开发者：JEECG社区
• 官网：http://www.jeecg.org

Java代码

1. <?xmlversion="1.0"encoding="UTF-8"?>
2. <!DOCTYPEmapper
3. PUBLIC"-//mybatis.org//DTDMapper3.0//EN"
4. "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
5. <mappernamespace="scott.dao.demo.JeecgNoteDao">
6. <!--ResultMap-->
7. <resultMapid="BaseResultMap"type="scott.entity.demo.JeecgNote">
8. <resultcolumn="id"property="id"/>
9. <resultcolumn="title"property="title"/>
10. <resultcolumn="content"property="content"/>
11. <resultcolumn="crtuser"property="crtuser"/>
12. <resultcolumn="crtuser_name"property="crtuser_name"/>
13. <resultcolumn="create_dt"property="create_dt"/>
14. <resultcolumn="deleted"property="deleted"/>
15. </resultMap>
17. <!--jeecg_notetableallfields-->
18. <sqlid="Base_Column_List">
19. id,title,content,crtuser,crtuser_name,create_dt,deleted
20. </sql>
23. <!--查询条件-->
24. <sqlid="Example_Where_Clause">
25. where1=1
26. <trimsuffixOverrides=",">
27. <iftest="id!=nullandid!=''">
28. andid=#{id}
29. </if>
30. <iftest="title!=nullandtitle!=''">
31. andtitle=#{title}
32. </if>
33. <iftest="content!=nullandcontent!=''">
34. andcontent=#{content}
35. </if>
36. <iftest="crtuser!=nullandcrtuser!=''">
37. andcrtuser=#{crtuser}
38. </if>
39. <iftest="crtuser_name!=nullandcrtuser_name!=''">
40. andcrtuser_name=#{crtuser_name}
41. </if>
42. <iftest="create_dt!=nullandcreate_dt!=''">
43. andcreate_dt=#{create_dt}
44. </if>
45. <iftest="deleted!=nullanddeleted!=''">
46. anddeleted=#{deleted}
47. </if>
48. </trim>
49. </sql>
52. <!--插入记录-->
53. <insertid="add"parameterType="Object">
54. <selectKeyresultType="java.lang.Integer"order="AFTER"keyProperty="id">
55. SELECTLAST_INSERT_ID()
56. </selectKey>
57. insertintojeecg_note(id,title,content,crtuser,crtuser_name,create_dt,deleted)
58. values(#{id},#{title},#{content},#{crtuser},#{crtuser_name},#{create_dt},#{deleted})
59. </insert>
61. <!--根据id，修改记录-->
62. <updateid="update"parameterType="Object">
63. updatejeecg_notesettitle=#{title},content=#{content},crtuser=#{crtuser},crtuser_name=#{crtuser_name},create_dt=#{create_dt},deleted=#{deleted}whereid=#{id}
64. </update>
66. <!--修改记录，只修改只不为空的字段-->
67. <updateid="updateBySelective"parameterType="Object">
68. updatejeecg_noteset
69. <trimsuffixOverrides=",">
70. <iftest="title!=null">
71. title=#{title},
72. </if>
73. <iftest="content!=null">
74. content=#{content},
75. </if>
76. <iftest="crtuser!=null">
77. crtuser=#{crtuser},
78. </if>
79. <iftest="crtuser_name!=null">
80. crtuser_name=#{crtuser_name},
81. </if>
82. <iftest="create_dt!=null">
83. create_dt=#{create_dt},
84. </if>
85. <iftest="deleted!=null">
86. deleted=#{deleted},
87. </if>
88. </trim>whereid=#{id}
89. </update>
91. <!--删除记录-->
92. <deleteid="delete"parameterType="Object">
93. deletefromjeecg_notewhereid=#{id}
94. </delete>
96. <!--根据id查询公告-->
97. <selectid="queryById"resultMap="BaseResultMap"parameterType="Object">
98. select<includerefid="Base_Column_List"/>
99. fromjeecg_notewhereid=#{id}
100. </select>
102. <!--公告列表总数-->
103. <selectid="queryByCount"resultType="java.lang.Integer"parameterType="Object">
104. selectcount(1)fromjeecg_note
105. <includerefid="Example_Where_Clause"/>
106. </select>
108. <!--查询公告列表-->
109. <selectid="queryByList"resultMap="BaseResultMap"parameterType="Object">
110. select
111. <includerefid="Base_Column_List"/>
112. fromjeecg_note
113. <includerefid="Example_Where_Clause"/>
114. <iftest="pager.orderCondition!=nullandpager.orderCondition!=''">
115. ${pager.orderCondition}
116. </if>
117. <iftest="pager.mysqlQueryCondition!=nullandpager.mysqlQueryCondition!=''">
118. ${pager.mysqlQueryCondition}
119. </if>
120. </select>
122. </mapper>