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

简要说明

JEECG[J2EE Code Generation]

代码生成：根据表生成对应的Bean,Service,Dao,Action,XML,JSP等,增删改查功能直接使用,实现了快速开发

jeecg-mybatis-framework,采用SpringMVC+Mybatis等主流框架

支持数据库: Mysql,Oracle10g

前端:使用Jquery和Easyui技术.JS封装简洁,操作简单.

权限:对菜单,按钮控制.根据登陆用户权限展示拥有的菜单和按钮.

拦截:对所有无权限URL进行拦截,防止手动发送HTTP请求,确保系统全性.

Java代码收藏代码

< xml version="1.0" encoding="UTF-8" >

PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"

"http://mybatis.org/dtd/mybatis-3-mapper.dtd">

id,title,content,crtuser,crtuser_name,create_dt,deleted

where 1=1

and id = #{id}

and title = #{title}

and content = #{content}

and crtuser = #{crtuser}

and crtuser_name = #{crtuser_name}

and create_dt = #{create_dt}

and deleted = #{deleted}

SELECT LAST_INSERT_ID()

insert into jeecg_note(id,title,content,crtuser,crtuser_name,create_dt,deleted)

values(#{id},#{title},#{content},#{crtuser},#{crtuser_name},#{create_dt},#{deleted})

update jeecg_note set title=#{title},content=#{content},crtuser=#{crtuser},crtuser_name=#{crtuser_name},create_dt=#{create_dt},deleted=#{deleted} where id=#{id}

update jeecg_note set

title=#{title},

content=#{content},

crtuser=#{crtuser},

crtuser_name=#{crtuser_name},

create_dt=#{create_dt},

deleted=#{deleted},

where id=#{id}

delete from jeecg_note where id = #{id}

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