提供了编程的基础技术教程

zl程序教程

您现在的位置是：首页 >  后端

当前栏目

Spring+SpringMVC+Mybatis（开发必备技能）04、mybatis自动生成mapper_dao_model(包含工具与视频讲解) 纯绿色版本、配套使用视频，100%运行成功

SpringMVCSpringmybatis工具自动开发 版本 运行
2023-09-14 09:04:59 时间

Spring+SpringMVC+Mybatis（开发必备技能）

04、mybatis自动生成mapper_dao_model(包含工具与视频讲解) 纯绿色版本、配套使用视频，100%运行成功

百度网盘链接：链接：https://pan.baidu.com/s/11cO4roAQ108D9E06IHrmGw 提取码：h63e

视频教程链接：

common_utils配套使用视频_哔哩哔哩_bilibili

目录

1、配置文件：

2、脚本文件：

3、执行效果：

生成mapper.xml文件示例：

生成model文件示例：

生成dao层文件示例：

1、配置文件：

其中修改数据库账号密码和链接就行

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE generatorConfiguration PUBLIC
	"-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN"
	"http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd">
<generatorConfiguration>
	<!-- 数据库驱动包位置 -->
	<classPathEntry location="mysql-connector-java-5.1.24-bin.jar"/>
	<context id="DB2Tables" targetRuntime="MyBatis3">
		<!-- 生成的代码注释，加入下面的配置控制 false:生成、true:不生成 -->
		<commentGenerator>
			<property name="suppressAllComments" value="false"/>
			<property name="suppressDate" value="false"/>
		</commentGenerator>
		
		<!-- 数据库连接URL、用户名、密码 -->
		<!-- Oracle连接 
		<jdbcConnection driverClass="oracle.jdbc.driver.OracleDriver"
			connectionURL="jdbc:oracle:thin:@localhost:1521:orcl"
			userId="tiger" password="123456">
		</jdbcConnection>
		-->
		<!-- MySQL连接 -->
		<jdbcConnection driverClass="com.mysql.jdbc.Driver"
			connectionURL="jdbc:mysql://localhost:3306/test?characterEncoding=utf8" 
			userId="root" password="root">
		</jdbcConnection>
		
		<!-- java类型处理器 -->
		<javaTypeResolver>
			<property name="forceBigDecimals" value="false"/>
		</javaTypeResolver>
		
		<!-- Model位置 -->
		<javaModelGenerator targetPackage="main.java.com.item.model" targetProject="D:\laoshifu_hongmuxiangxun\">
			<property name="enableSubPackages" value="true"/>
			<property name="trimStrings" value="true"/>
		</javaModelGenerator>
		
		<!-- mapper位置 -->
		<sqlMapGenerator targetPackage="main.resources.mapper" targetProject="D:\laoshifu_hongmuxiangxun\">
			<property name="enableSubPackages" value="true"/>
		</sqlMapGenerator>
		
		<!-- dao位置 -->
		<javaClientGenerator type="XMLMAPPER" targetPackage="main.java.com.item.dao" targetProject="D:\laoshifu_hongmuxiangxun\">
			<property name="enableSubPackages" value="true"/>
		</javaClientGenerator>
		
		<!-- %代表生成所有的表，如果只想生成某表，自己改成表名字就行 -->
		<table tableName="%" schema="SCOTT" enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false" enableSelectByExample="false" selectByExampleQueryId="false" ></table>
	</context>
</generatorConfiguration>

2、脚本文件：

chcp 65001
echo off
title AutoMybatis_laoshifu
mkdir D:\laoshifu_hongmuxiangxun
cls
java -jar mybatis-generator-core-1.3.2.jar -configfile generator.xml -overwrite
start D:\laoshifu_hongmuxiangxun
echo 如果生成正确，代码会生成在D盘的根目录下，结构为，java/com与java/resources可以直接复制，看到successfully代表生成完毕，按任意键结束。
pause

执行文件：

3、执行效果：

生成并打开对应生成文件夹位置：

生成mapper.xml文件示例：

<?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="main.java.com.item.dao.UsersMapper" >
  <resultMap id="BaseResultMap" type="main.java.com.item.model.Users" >
    <!--
      WARNING - @mbggenerated
      This element is automatically generated by MyBatis Generator, do not modify.
      This element was generated on Sat May 28 16:28:01 CST 2022.
    -->
    <id column="id" property="id" jdbcType="INTEGER" />
    <result column="createDate" property="createdate" jdbcType="TIMESTAMP" />
    <result column="userName" property="username" jdbcType="VARCHAR" />
    <result column="introduce" property="introduce" jdbcType="VARCHAR" />
  </resultMap>
  <sql id="Base_Column_List" >
    <!--
      WARNING - @mbggenerated
      This element is automatically generated by MyBatis Generator, do not modify.
      This element was generated on Sat May 28 16:28:01 CST 2022.
    -->
    id, createDate, userName, introduce
  </sql>
  <select id="selectByPrimaryKey" resultMap="BaseResultMap" parameterType="java.lang.Integer" >
    <!--
      WARNING - @mbggenerated
      This element is automatically generated by MyBatis Generator, do not modify.
      This element was generated on Sat May 28 16:28:01 CST 2022.
    -->
    select 
    <include refid="Base_Column_List" />
    from users
    where id = #{id,jdbcType=INTEGER}
  </select>
  <delete id="deleteByPrimaryKey" parameterType="java.lang.Integer" >
    <!--
      WARNING - @mbggenerated
      This element is automatically generated by MyBatis Generator, do not modify.
      This element was generated on Sat May 28 16:28:01 CST 2022.
    -->
    delete from users
    where id = #{id,jdbcType=INTEGER}
  </delete>
  <insert id="insert" parameterType="main.java.com.item.model.Users" >
    <!--
      WARNING - @mbggenerated
      This element is automatically generated by MyBatis Generator, do not modify.
      This element was generated on Sat May 28 16:28:01 CST 2022.
    -->
    insert into users (id, createDate, userName, 
      introduce)
    values (#{id,jdbcType=INTEGER}, #{createdate,jdbcType=TIMESTAMP}, #{username,jdbcType=VARCHAR}, 
      #{introduce,jdbcType=VARCHAR})
  </insert>
  <insert id="insertSelective" parameterType="main.java.com.item.model.Users" >
    <!--
      WARNING - @mbggenerated
      This element is automatically generated by MyBatis Generator, do not modify.
      This element was generated on Sat May 28 16:28:01 CST 2022.
    -->
    insert into users
    <trim prefix="(" suffix=")" suffixOverrides="," >
      <if test="id != null" >
        id,
      </if>
      <if test="createdate != null" >
        createDate,
      </if>
      <if test="username != null" >
        userName,
      </if>
      <if test="introduce != null" >
        introduce,
      </if>
    </trim>
    <trim prefix="values (" suffix=")" suffixOverrides="," >
      <if test="id != null" >
        #{id,jdbcType=INTEGER},
      </if>
      <if test="createdate != null" >
        #{createdate,jdbcType=TIMESTAMP},
      </if>
      <if test="username != null" >
        #{username,jdbcType=VARCHAR},
      </if>
      <if test="introduce != null" >
        #{introduce,jdbcType=VARCHAR},
      </if>
    </trim>
  </insert>
  <update id="updateByPrimaryKeySelective" parameterType="main.java.com.item.model.Users" >
    <!--
      WARNING - @mbggenerated
      This element is automatically generated by MyBatis Generator, do not modify.
      This element was generated on Sat May 28 16:28:01 CST 2022.
    -->
    update users
    <set >
      <if test="createdate != null" >
        createDate = #{createdate,jdbcType=TIMESTAMP},
      </if>
      <if test="username != null" >
        userName = #{username,jdbcType=VARCHAR},
      </if>
      <if test="introduce != null" >
        introduce = #{introduce,jdbcType=VARCHAR},
      </if>
    </set>
    where id = #{id,jdbcType=INTEGER}
  </update>
  <update id="updateByPrimaryKey" parameterType="main.java.com.item.model.Users" >
    <!--
      WARNING - @mbggenerated
      This element is automatically generated by MyBatis Generator, do not modify.
      This element was generated on Sat May 28 16:28:01 CST 2022.
    -->
    update users
    set createDate = #{createdate,jdbcType=TIMESTAMP},
      userName = #{username,jdbcType=VARCHAR},
      introduce = #{introduce,jdbcType=VARCHAR}
    where id = #{id,jdbcType=INTEGER}
  </update>
</mapper>

生成model文件示例：

package main.java.com.item.model;

import java.util.Date;

public class Users {
    /**
     * This field was generated by MyBatis Generator.
     * This field corresponds to the database column users.id
     *
     * @mbggenerated Sat May 28 16:28:01 CST 2022
     */
    private Integer id;

    /**
     * This field was generated by MyBatis Generator.
     * This field corresponds to the database column users.createDate
     *
     * @mbggenerated Sat May 28 16:28:01 CST 2022
     */
    private Date createdate;

    /**
     * This field was generated by MyBatis Generator.
     * This field corresponds to the database column users.userName
     *
     * @mbggenerated Sat May 28 16:28:01 CST 2022
     */
    private String username;

    /**
     * This field was generated by MyBatis Generator.
     * This field corresponds to the database column users.introduce
     *
     * @mbggenerated Sat May 28 16:28:01 CST 2022
     */
    private String introduce;

    /**
     * This method was generated by MyBatis Generator.
     * This method returns the value of the database column users.id
     *
     * @return the value of users.id
     *
     * @mbggenerated Sat May 28 16:28:01 CST 2022
     */
    public Integer getId() {
        return id;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method sets the value of the database column users.id
     *
     * @param id the value for users.id
     *
     * @mbggenerated Sat May 28 16:28:01 CST 2022
     */
    public void setId(Integer id) {
        this.id = id;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method returns the value of the database column users.createDate
     *
     * @return the value of users.createDate
     *
     * @mbggenerated Sat May 28 16:28:01 CST 2022
     */
    public Date getCreatedate() {
        return createdate;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method sets the value of the database column users.createDate
     *
     * @param createdate the value for users.createDate
     *
     * @mbggenerated Sat May 28 16:28:01 CST 2022
     */
    public void setCreatedate(Date createdate) {
        this.createdate = createdate;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method returns the value of the database column users.userName
     *
     * @return the value of users.userName
     *
     * @mbggenerated Sat May 28 16:28:01 CST 2022
     */
    public String getUsername() {
        return username;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method sets the value of the database column users.userName
     *
     * @param username the value for users.userName
     *
     * @mbggenerated Sat May 28 16:28:01 CST 2022
     */
    public void setUsername(String username) {
        this.username = username == null ? null : username.trim();
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method returns the value of the database column users.introduce
     *
     * @return the value of users.introduce
     *
     * @mbggenerated Sat May 28 16:28:01 CST 2022
     */
    public String getIntroduce() {
        return introduce;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method sets the value of the database column users.introduce
     *
     * @param introduce the value for users.introduce
     *
     * @mbggenerated Sat May 28 16:28:01 CST 2022
     */
    public void setIntroduce(String introduce) {
        this.introduce = introduce == null ? null : introduce.trim();
    }
}

生成dao层文件示例：

package main.java.com.item.dao;

import main.java.com.item.model.Users;

public interface UsersMapper {
    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table users
     *
     * @mbggenerated Sat May 28 16:28:01 CST 2022
     */
    int deleteByPrimaryKey(Integer id);

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table users
     *
     * @mbggenerated Sat May 28 16:28:01 CST 2022
     */
    int insert(Users record);

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table users
     *
     * @mbggenerated Sat May 28 16:28:01 CST 2022
     */
    int insertSelective(Users record);

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table users
     *
     * @mbggenerated Sat May 28 16:28:01 CST 2022
     */
    Users selectByPrimaryKey(Integer id);

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table users
     *
     * @mbggenerated Sat May 28 16:28:01 CST 2022
     */
    int updateByPrimaryKeySelective(Users record);

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table users
     *
     * @mbggenerated Sat May 28 16:28:01 CST 2022
     */
    int updateByPrimaryKey(Users record);
}

相关文章