<?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="${packageName}.dao.${className}Dao" >
<!-- Result Map-->
<resultMap id="BaseResultMap" type="$!{className}" >
$!{SQL.resultMap}
</resultMap>
<!-- $!{tableName} table all fields -->
<sql id="Base_Column_List" >
$!{SQL.columnFields}
</sql>
<!-- 查询条件 -->
<sql id="Example_Where_Clause">
where 1=1
$!{SQL.exampleWhereSql}
</sql>
<!-- 插入记录 -->
<insert id="insert" parameterType="$!{className}" >
$!{SQL.insert}
</insert>
<!-- 根据id，修改记录-->
<update id="update" parameterType="$!{className}" >
$!{SQL.update}
</update>
<!-- -->
<update id="updateBySelective" parameterType="$!{className}" >
$!{SQL.updateSelective}
</update>
<!-- 逻辑删除，将deleted 改成 1 -->
<update id="delete" parameterType="$!{className}">
$!{SQL.delete}
</update>
<!-- ${codeName}列表 -->
<select id="selectById" resultMap="BaseResultMap" parameterType="java.lang.Long">
$!{SQL.selectById}
</select>
<!-- ${codeName} 列表总数-->
<select id="selectByModelCount" resultType="java.lang.Integer" parameterType="$!{className}">
select count(1) from ${tableName}
<include refid="Example_Where_Clause"/>
</select>
<!-- 根据id查询${codeName} -->
<select id="selectByModel" resultMap="BaseResultMap" parameterType="$!{className}">
select
<include refid="Base_Column_List"/>
from ${tableName}
<include refid="Example_Where_Clause"/>
</select>
<!-- ${codeName} 列表总数-->
<select id="selectByMapCount" resultType="java.lang.Integer" parameterType="java.util.Map">
select count(1) from ${tableName}
<include refid="Example_Where_Clause"/>
</select>
<!-- 根据id查询${codeName} -->
<select id="selectByMap" resultMap="BaseResultMap" parameterType="java.util.Map">
select
<include refid="Base_Column_List"/>
from ${tableName}
<include refid="Example_Where_Clause"/>
</select>
</mapper>
mybatis 代码生成工具 GenCode
5星 · 超过95%的资源 需积分: 10 15 浏览量
2013-03-12
16:41:41
上传
评论
收藏 13.97MB ZIP 举报 
CodeGen.zip （64个子文件） 
CodeGen 
DataSourceConfig.properties 242B
CodeGenerator.jar 55KB lib velocity-1.6.2.jar 411KB commons-collections-3.1.jar 546KB org.springframework.instrument.tomcat-3.1.1.RELEASE.jar 11KB org.springframework.instrument-3.1.1.RELEASE.jar 7KB dom.jar 27KB mybatis-3.1.1-SNAPSHOT.jar 635KB asm-3.3.1.jar 43KB org.springframework.web.struts-3.1.1.RELEASE.jar 31KB org.springframework.beans-3.1.1.RELEASE.jar 576KB org.springframework.orm-3.1.1.RELEASE.jar 370KB log4j-1.2.16.jar 470KB aopalliance-1.0.jar 4KB slf4j-api-1.6.2.jar 25KB junit.jar 118KB standard.jar 385KB org.springframework.context-3.1.1.RELEASE.jar 812KB mail.jar 292KB org.springframework.asm-3.1.1.RELEASE.jar 52KB xercesImpl.jar 1.13MB saxpath.jar 23KB org.springframework.aspects-3.1.1.RELEASE.jar 49KB commons-logging-1.1.1.jar 59KB org.json.jar 117KB servlet-api.jar 173KB org.springframework.core-3.1.1.RELEASE.jar 439KB mysql-connector-java-5.1.6-bin.jar 687KB org.springframework.jdbc-3.1.1.RELEASE.jar 395KB jstl.jar 21KB xalan.jar 1.2MB slf4j-log4j12-1.6.2.jar 10KB aspectjweaver.jar 1.61MB org.springframework.oxm-3.1.1.RELEASE.jar 71KB mybatis-generator-core-1.3.1.jar 470KB org.springframework.context.support-3.1.1.RELEASE.jar 105KB jaxen-full.jar 186KB urlrewrite-3.2.0.jar 194KB org.springframework.test-3.1.1.RELEASE.jar 224KB org.springframework.expression-3.1.1.RELEASE.jar 172KB commons-fileupload-1.2.1.jar 56KB cglib-2.2.2.jar 280KB commons-lang-2.4.jar 256KB jdbc2_0-stdext.jar 7KB sax.jar 26KB org.springframework.transaction-3.1.1.RELEASE.jar 241KB mybatis-spring-1.1.1-SNAPSHOT.jar 40KB org.springframework.aop-3.1.1.RELEASE.jar 324KB commons-httpclient-3.0.jar 238KB org.springframework.web.portlet-3.1.1.RELEASE.jar 186KB velocity-tools-generic-2.0.jar 188KB org.springframework.web-3.1.1.RELEASE.jar 532KB dom4j-1.6.jar 306KB commons-io-1.4.jar 106KB org.springframework.jms-3.1.1.RELEASE.jar 195KB org.springframework.web.servlet-3.1.1.RELEASE.jar 560KB jaxp-api.jar 27KB template TempModel.vm 108B TempBean.vm 98B TempServiceImpl.vm 2KB TempDao.vm 173B TempController.vm 4KB TempMapper.xml 2KB TempService.vm 280B
评论1
最新资源