? 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）聯系.
- 交流QQ群:106259349, 106838471, 289782002
- 開發者：JEECG社區
- 官網：http://www.jeecg.org
Java代碼??
<?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> ? ??
總結
以上是生活随笔為你收集整理的【jeecg-mybatis版本】 mybatis+spring mvc 完美整合方案 查询，保存，更新，删除自动生成的全部內容，希望文章能夠幫你解決所遇到的問題。
如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。
