# codegenbyMap

**Repository Path**: sishui198/codegenby-map

## Basic Information

- **Project Name**: codegenbyMap
- **Description**: 写了一个通用的代码生成器，默认是通过map的方式。模板也提供了根据实体类来生成。
可以生成entity，dao，mapper，controller。代码是在https://gitee.com/flying-cattle/mybatis-dsc-generator
 的基础上修改而来，感谢原作者。每张表必须要有主键,项目考虑了多个主键的情况。
- **Primary Language**: Unknown
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 1
- **Forks**: 0
- **Created**: 2021-07-05
- **Last Updated**: 2022-07-29

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# codegenbyMap

#### 介绍
写了一个通用的代码生成器，默认是通过map的方式。模板也提供了根据实体类来生成。
可以生成entity，dao，mapper，controller。代码是在https://gitee.com/flying-cattle/mybatis-dsc-generator的基础上修改而来，感谢原作者。

#### 软件架构
软件架构说明


#### 安装教程

对应的xml文件

<mapper namespace="com.dao.BaseDao">
	<insert id="insertSelective" parameterType="java.util.Map">
		insert into ${db.tableName}
		<foreach collection="params.keys" item="key" open="(" close=")"
			separator=",">
			<if test="params.get(key) !=null and params.get(key).toString() !=''">
				${key}
			</if>
		</foreach>
		values
		<foreach collection="params.values" item="val" open="(" close=")"
			separator=",">
			<if test="val !=null and  val.toString() !=''">
				#{val}
			</if>
		</foreach>
	</insert>

	<insert id="insert" parameterType="java.util.Map">



		insert into ${db.tableName}
		<foreach collection="params.keys" item="key" open="(" close=")"
			separator=",">
			${key}
		</foreach>
		VALUES
		<foreach collection="params.values" item="val" open="(" close=")"
			separator=",">

			#{val}
		</foreach>

	</insert>

<!-- 	<insert id="batchInsert2" parameterType="java.util.Map">
		<if test="list != null and list.size() > 0">
			insert into ${db.tableName}
			<foreach collection="list.get(0).keys" item="key" open="("
				close=")" separator=",">
				${key}
			</foreach>
			values
			<foreach collection="list" index="index" item="item"
				separator=",">
				<foreach collection="item.values" item="val" open="(" close=")"
					separator=",">
			
							#{val}
					
				
				</foreach>
			</foreach>
		</if>
	</insert> -->
	
		<insert id="batchInsert" parameterType="java.util.Map">
		<if test="list != null and list.size() > 0">
			insert into ${db.tableName}
			<foreach collection="list.get(0).keys" item="key" open="("
				close=")" separator=",">
				${key}
			</foreach>
			values
			<foreach collection="list" index="index" item="item"
				separator=",">
				<foreach collection="item.values" item="val" open="(" close=")"
					separator=",">
					<choose>
						<when test="val.toString()==''">
							null
						</when>
						<otherwise>
							#{val}
						</otherwise>
					</choose>
				</foreach>
			</foreach>
		</if>
	</insert>
	
	
	


	<update id="batchUpdate" parameterType="java.util.Map">
		<foreach collection="list" item="item" index="index" open=""
			close="" separator=";">
			UPDATE ${db.tableName}
			set
			<foreach collection="item.keys" item="key" separator=",">
				<choose>
					<when test="db.primaryKeyNames.contains(key)">
						<!-- ${key}= #{params.${key}} -->
					</when>
					<otherwise>
						${key}= #{item.${key}}
					</otherwise>
				</choose>
			</foreach>
			<where>
				<foreach collection="db.primaryKeyNames" item="key"
					separator="and">
					<if
						test="item.containsKey(key) and item.get(key) !=null and item.get(key).toString() !=''">
						${key}= #{item.${key}}
					</if>
				</foreach>
			</where>
		</foreach>
	</update>



	<!-- <insert id="insertBatch" parameterType="java.util.List"> <if test="list 
		!= null and list > 0"> insert into ${db.tableName} <foreach collection="params.keys" 
		item="key" open="(" close=")" separator=","> <if test="params.get(key) !=null 
		and params.get(key).toString() !=''"> ${key} </if> </foreach> values <foreach 
		collection="params.values" item="val" open="(" close=")" separator=","> <if 
		test="val !=null and val.toString() !=''"> #{val} </if> </foreach> </if> 
		</insert> -->


	<delete id="deleteByPrimaryKeys" parameterType="java.util.Map">
		delete from ${db.tableName}

		<where>

			<foreach collection="db.primaryKeyNames" item="key"
				separator="and">
				<if test="params.get(key) !=null and params.get(key).toString() !=''">
					${key}= #{params.${key}}
				</if>
			</foreach>
			and 1=1
		</where>
	</delete>


	<update id="updateByPrimaryKeys" parameterType="java.util.Map">
		update ${db.tableName} set
		<foreach collection="params.keys" item="key" separator=",">
			<choose>
				<when test="db.primaryKeyNames.contains(key)">
					<!-- ${key}= #{params.${key}} -->
				</when>
				<otherwise>
					${key}= #{params.${key}}
				</otherwise>
			</choose>
		</foreach>
		<where>
			<foreach collection="db.primaryKeyNames" item="key"
				separator="and">
				<if
					test="params.containsKey(key) and params.get(key) !=null and params.get(key).toString() !=''">
					${key}= #{params.${key}}
				</if>
			</foreach>
		</where>
	</update>

	<update id="updateByPrimaryKeysSelective" parameterType="java.util.Map">
		update ${db.tableName} set
		<foreach collection="params.keys" item="key" separator=",">
			<choose>
				<when test="db.primaryKeyNames.contains(key)">
					<!-- ${key}= #{params.${key}} -->
				</when>
				<otherwise>
					<if test="params.get(key) !=null and params.get(key).toString() !=''">
						${key}= #{params.${key}}
					</if>
				</otherwise>
			</choose>
		</foreach>
		<where>
			<foreach collection="db.primaryKeyNames" item="key"
				separator="and">
				<if
					test="params.containsKey(key) and params.get(key) !=null and params.get(key).toString() !=''">
					${key}= #{params.${key}}
				</if>
			</foreach>
		</where>
	</update>

	<select id="selectByPrimaryKeysToList" parameterType="java.util.Map"
		resultType="java.util.Map">
		select * from ${db.tableName}
		<if test="db.primaryKeyNames!=null and db.primaryKeyNames.size() != 0">
			<where>

				<foreach collection="db.primaryKeyNames" item="key"
					separator="AND">
					<if test="params.get(key) !=null and params.get(key).toString() !=''">
						${key}= #{params.${key}}
					</if>
				</foreach>
				and 1=1
			</where>
		</if>
		<if test="db.orderBy!=null and db.orderBy.length>0">
			ORDER BY ${db.orderBy}
		</if>
	</select>

	<!-- <select id="getXXXBeanList" resultType="XXBean"> select 字段... from 
		XXX where id in <foreach item="item" index="index" collection="list" open="(" 
		separator="," close=")"> #{item} </foreach> </select> -->
	<select id="selectByPrimaryKeysToOne" parameterType="java.util.Map"
		resultType="java.util.Map">
		select * from ${db.tableName}
		<if test="db.primaryKeyNames!=null and db.primaryKeyNames.size() != 0">
			<where>

				<foreach collection="db.primaryKeyNames" item="key"
					separator="AND">
					<if test="params.get(key) !=null and params.get(key).toString() !=''">
						${key}= #{params.${key}}
					</if>
				</foreach>
				and 1=1
			</where>
		</if>
		<if test="db.orderBy!=null and db.orderBy.length>0">
			ORDER BY ${db.orderBy}
		</if>
	</select>

	<delete id="deleteAll" parameterType="java.util.Map">
		delete from
		${db.tableName}
	</delete>


	<select id="selectAll" parameterType="java.util.Map" resultType="java.util.Map">
		select * from ${db.tableName}

		<if test="db.orderBy!=null and db.orderBy.length>0">
			ORDER BY ${db.orderBy}
		</if>
	</select>

	<select id="getCount" parameterType="java.util.Map" resultType="java.lang.Integer">
		select count(*) from ${db.tableName}
	</select>

	<!-- 组合条件查询 -->
	<select id="queryList" parameterType="java.util.Map" resultType="java.util.Map">
		select
		* from ${db.tableName}
		<if test="#{params}!=null">

			<where>
				<foreach collection="params.keys" item="key" separator="and ">
					<if test="params.get(key) !=null and params.get(key).toString() !=''">

						${key}= #{params.${key}}
					</if>
				</foreach>
			</where>

		</if>

		<if test="db.orderBy!=null and db.orderBy.length>0">
			ORDER BY ${db.orderBy}
		</if>
	</select>

	<!-- 使用where 标签 MyBatis会智能的把首个and 或 or 给忽略，等价于trim的用法 -->



	<!-- 组合条件查询 -->
	<delete id="deleteList" parameterType="java.util.Map">
		delete from ${db.tableName}
		<if test="#{params}!=null">

			<where>
				<foreach collection="params.keys" item="key" separator="and ">
					<if test="params.get(key) !=null and params.get(key).toString() !=''">

						${key}= #{params.${key}}
					</if>
				</foreach>
			</where>

		</if>
	</delete>


	<!-- <trim prefix="(" suffix=")" prefixOverrides="OR"> -->
	<sql id="Example_Where_Clause">
		<if test="criteriaList != null">
			<if test="criteriaList.criteriaList!= null">
				<foreach collection="criteriaList.criteriaList" item="criteria"
					separator="AND">
					<trim prefix="(" suffix=")">
						<foreach collection="criteria.criteria" item="criterion"
							separator="OR">
							<choose>
								<when test="criterion.noValue">
									${criterion.condition}
								</when>
								<when test="criterion.singleValue">
									${criterion.condition} #{criterion.value}
								</when>
								<when test="criterion.betweenValue">
									${criterion.condition} #{criterion.value} AND
									#{criterion.secondValue}
								</when>
								<when test="criterion.listValue">
									${criterion.condition}
									<foreach collection="criterion.value" item="listItem"
										open="(" close=")" separator=",">
										#{listItem}
									</foreach>
								</when>
							</choose>
						</foreach>
					</trim>
				</foreach>
			</if>
		</if>
	</sql>


	<sql id="orderBy_case">
		<if
			test="criteriaList.orderByList !=null and criteriaList.orderByList.size() >0">
			ORDER BY
			<foreach collection="criteriaList.orderByList" item="orderBy"
				separator=",">
				${orderBy.condition} ${orderBy.direction}
			</foreach>
		</if>
	</sql>


	<sql id="Update_By_Example_Where_Clause">
		<if test="criteriaList != null">
			<if test="criteriaList.criteriaList!= null">
				<where>
					<!-- 传入集合类型是example.oredCriteria 循环变量是criteria -->
					<foreach collection="criteriaList.criteriaList" item="criteria"
						separator="or">
						<if test="criteria.valid">
							<trim prefix="(" suffix=")" prefixOverrides="and">
								<foreach collection="criteria.criteria" item="criterion">
									<!-- 结构是条件判断如果满足就追加 -->
									<choose>
										<when test="criterion.noValue">
											and ${criterion.condition}
										</when>
										<when test="criterion.singleValue">
											and ${criterion.condition} #{criterion.value}
										</when>
										<when test="criterion.betweenValue">
											and ${criterion.condition} #{criterion.value}
											and
											#{criterion.secondValue}
										</when>
										<when test="criterion.listValue">
											and ${criterion.condition}
											<foreach collection="criterion.value" item="listItem"
												open="(" close=")" separator=",">
												#{listItem}
											</foreach>
										</when>
									</choose>
								</foreach>
							</trim>
						</if>
					</foreach>
				</where>
			</if>
		</if>
	</sql>

	<!-- <sql id="Example_Where_Clause"> <where> <foreach collection="oredCriteria" 
		item="criteria" separator="or"> <if test="criteria.valid"> <trim prefix="(" 
		prefixOverrides="and" suffix=")"> <foreach collection="criteria.criteria" 
		item="criterion"> <choose> <when test="criterion.noValue">//没有值 and ${criterion.condition} 
		</when> <when test="criterion.singleValue">//单个值 and ${criterion.condition} 
		#{criterion.value} </when> <when test="criterion.betweenValue">//区间值，范围查询 
		and ${criterion.condition} #{criterion.value} and #{criterion.secondValue} 
		</when> <when test="criterion.listValue"> //一组值 and ${criterion.condition} 
		<foreach close=")" collection="criterion.value" item="listItem" open="(" 
		separator=","> #{listItem} </foreach> </when> </choose> </foreach> </trim> 
		</if> </foreach> </where> </sql> -->


	<select id="selectByCriteria" parameterType="java.util.Map"
		resultType="java.util.Map">
		select * from ${db.tableName}
		<where>
			<include refid="Example_Where_Clause" />
		</where>
		<include refid="orderBy_case" />
	</select>

	<update id="updateByExample" parameterType="java.util.Map">
		update ${db.tableName}
		set
		<foreach collection="params.keys" item="key" separator=",">
			<choose>
				<when test="db.primaryKeyNames.contains(key)">
					<!-- ${key}= #{params.${key}} -->
				</when>
				<otherwise>
					<if test="params.get(key) !=null and params.get(key).toString() !=''">
						${key}= #{params.${key}}
					</if>
				</otherwise>
			</choose>
		</foreach>

		<include refid="Update_By_Example_Where_Clause" />
	</update>

	<delete id="deleteByCriteria" parameterType="java.util.Map">
		delete from ${db.tableName}
		<where>
			<include refid="Example_Where_Clause" />
		</where>
	</delete>



	<select id="getCountByCriteria" parameterType="java.util.Map">
		select count(*) from ${db.tableName)
		<where>
			<include refid="Example_Where_Clause" />
		</where>
	</select>




</mapper>

#### 使用说明

nt deleteByPrimaryKeys(@Param("params") Map<String, Object> map, @Param("db") DbProperties dbProperties);

	int deleteAll(@Param("db") DbProperties dbProperties);

	int deleteList(@Param("params") Map<String, Object> map, @Param("db") DbProperties dbProperties);

	int getCount(@Param("db") DbProperties dbProperties);

	int insert(@Param("params") Map<String, Object> map, @Param("db") DbProperties dbProperties);

	int insertSelective(@Param("params") Map<String, Object> map, @Param("db") DbProperties dbProperties);

	int updateByPrimaryKeys(@Param("params") Map<String, Object> map, @Param("db") DbProperties dbProperties);

	int updateByPrimaryKeysSelective(@Param("params") Map<String, Object> map, @Param("db") DbProperties dbProperties);

	/*
	 * int updateBySelectivePrimaryKey(@Param("params") Map<String, Object> map,
	 * 
	 * @Param("db") DbProperties dbProperties);
	 */

	List<Map<String, Object>> selectAll(@Param("db") DbProperties dbProperties);

	/*
	 * 
	 * 有些主键是符合的，如果输入主键不全，返回的就是多个
	 */
	List<Map<String, Object>> selectByPrimaryKeysToList(@Param("params") Map<String, Object> map,
			@Param("db") DbProperties dbProperties);

	List<Map<String, Object>> queryList(@Param("params") Map<String, Object> map,
			@Param("db") DbProperties dbProperties);

	/*
	 * 
	 * 有些主键是符合的，只返回一个
	 */
	Map<String, Object> selectByPrimaryKeysToOne(@Param("params") Map<String, Object> map,
			@Param("db") DbProperties dbProperties);

	List<Map<String, Object>> selectByCriteria(@Param("criteriaList") CriteriaExample criteriaList,
			@Param("db") DbProperties dbProperties);

	int updateByCriteria(@Param("criteriaList") CriteriaExample criteriaList, @Param("db") DbProperties dbProperties,
			@Param("params") Map<String, Object> map);

	int deleteByCriteria(@Param("criteriaList") CriteriaExample criteriaList, @Param("db") DbProperties dbProperties);

	int getCountByCriteria(@Param("criteriaList") CriteriaExample criteriaList, @Param("db") DbProperties dbProperties);

	int batchInsert(@Param("list") List<Map<String, Object>> map, @Param("db") DbProperties dbProperties);

	int batchUpdate(@Param("list") List<Map<String, Object>> map, @Param("db") DbProperties dbProperties);

#### 参与贡献

1.  Fork 本仓库
2.  新建 Feat_xxx 分支
3.  提交代码
4.  新建 Pull Request


#### 特技

1.  使用 Readme\_XXX.md 来支持不同的语言，例如 Readme\_en.md, Readme\_zh.md
2.  Gitee 官方博客 [blog.gitee.com](https://blog.gitee.com)
3.  你可以 [https://gitee.com/explore](https://gitee.com/explore) 这个地址来了解 Gitee 上的优秀开源项目
4.  [GVP](https://gitee.com/gvp) 全称是 Gitee 最有价值开源项目，是综合评定出的优秀开源项目
5.  Gitee 官方提供的使用手册 [https://gitee.com/help](https://gitee.com/help)
6.  Gitee 封面人物是一档用来展示 Gitee 会员风采的栏目 [https://gitee.com/gitee-stars/](https://gitee.com/gitee-stars/)