pom.xml

<?xml version="1.0" encoding="UTF-8"?> <project xmlns="http://maven.apache.org/POM/4.0.0"xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd"><modelVersion>4.0.0</modelVersion><groupId>mybatis-generator</groupId><artifactId>mybatis-generator</artifactId><version>1.0-SNAPSHOT</version><dependencies><dependency><groupId>org.mybatis</groupId><artifactId>mybatis</artifactId><version>3.4.0</version></dependency></dependencies><build><plugins><plugin><groupId>org.mybatis.generator</groupId><artifactId>mybatis-generator-maven-plugin</artifactId><version>1.3.5</version><configuration><verbose>true</verbose><overwrite>true</overwrite></configuration></plugin></plugins></build></project>

　　generatorConfig.xml

<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE generatorConfigurationPUBLIC "-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN""http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd"> <generatorConfiguration><classPathEntry location="F:\mvn-repository\com\oracle\jdbc\ojdbc7\12.1.0.2\ojdbc7-12.1.0.2.jar" /><context id="demo" targetRuntime="MyBatis3"><commentGenerator><property name="suppressAllComments" value="true"/><property name="prefix" value="com.demo"/></commentGenerator><jdbcConnection driverClass="oracle.jdbc.driver.OracleDriver"connectionURL="jdbc:oracle:thin:@127.0.0.1:1521/sinafq" userId="scott"password="tiger"/><javaModelGenerator targetPackage="com.demo.entity"targetProject="D:/workspace/mybatis-generator/src/main/java"/><sqlMapGenerator targetPackage="com.demo.mapper"targetProject="D:/workspace/mybatis-generator/src/main/java/"/><javaClientGenerator targetPackage="com.demo.mapper"targetProject="D:/workspace/mybatis-generator/src/main/java"type="XMLMAPPER"/><table schema="" tableName="T_MERCHANT_USER" domainObjectName="MerchantUser"></table></context> </generatorConfiguration>

　　我用的intellij idea的maven插件執(zhí)行

生成的代碼類似如下：

package com.demo.mapper;import com.demo.entity.Users; import com.demo.entity.UsersExample; import java.util.List; import org.apache.ibatis.annotations.Param;public interface UsersMapper {long countByExample(UsersExample example);int deleteByExample(UsersExample example);int deleteByPrimaryKey(Long id);int insert(Users record);int insertSelective(Users record);List<Users> selectByExample(UsersExample example);Users selectByPrimaryKey(Long id);int updateByExampleSelective(@Param("record") Users record, @Param("example") UsersExample example);int updateByExample(@Param("record") Users record, @Param("example") UsersExample example);int updateByPrimaryKeySelective(Users record);int updateByPrimaryKey(Users record); }

　　

<?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="com.demo.mapper.UsersMapper"><resultMap id="BaseResultMap" type="com.demo.entity.Users"><id column="id" jdbcType="BIGINT" property="id" /><result column="username" jdbcType="VARCHAR" property="username" /><result column="password" jdbcType="VARCHAR" property="password" /><result column="password_salt" jdbcType="VARCHAR" property="passwordSalt" /></resultMap><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><sql id="Update_By_Example_Where_Clause"><where><foreach collection="example.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><sql id="Base_Column_List">id, username, password, password_salt</sql><select id="selectByExample" parameterType="com.demo.entity.UsersExample" resultMap="BaseResultMap">select<if test="distinct">distinct</if><include refid="Base_Column_List" />from users<if test="_parameter != null"><include refid="Example_Where_Clause" /></if><if test="orderByClause != null">order by ${orderByClause}</if></select><select id="selectByPrimaryKey" parameterType="java.lang.Long" resultMap="BaseResultMap">select <include refid="Base_Column_List" />from userswhere id = #{id,jdbcType=BIGINT}</select><delete id="deleteByPrimaryKey" parameterType="java.lang.Long">delete from userswhere id = #{id,jdbcType=BIGINT}</delete><delete id="deleteByExample" parameterType="com.demo.entity.UsersExample">delete from users<if test="_parameter != null"><include refid="Example_Where_Clause" /></if></delete><insert id="insert" parameterType="com.demo.entity.Users">insert into users (id, username, password, password_salt)values (#{id,jdbcType=BIGINT}, #{username,jdbcType=VARCHAR}, #{password,jdbcType=VARCHAR}, #{passwordSalt,jdbcType=VARCHAR})</insert><insert id="insertSelective" parameterType="com.demo.entity.Users">insert into users<trim prefix="(" suffix=")" suffixOverrides=","><if test="id != null">id,</if><if test="username != null">username,</if><if test="password != null">password,</if><if test="passwordSalt != null">password_salt,</if></trim><trim prefix="values (" suffix=")" suffixOverrides=","><if test="id != null">#{id,jdbcType=BIGINT},</if><if test="username != null">#{username,jdbcType=VARCHAR},</if><if test="password != null">#{password,jdbcType=VARCHAR},</if><if test="passwordSalt != null">#{passwordSalt,jdbcType=VARCHAR},</if></trim></insert><select id="countByExample" parameterType="com.demo.entity.UsersExample" resultType="java.lang.Long">select count(*) from users<if test="_parameter != null"><include refid="Example_Where_Clause" /></if></select><update id="updateByExampleSelective" parameterType="map">update users<set><if test="record.id != null">id = #{record.id,jdbcType=BIGINT},</if><if test="record.username != null">username = #{record.username,jdbcType=VARCHAR},</if><if test="record.password != null">password = #{record.password,jdbcType=VARCHAR},</if><if test="record.passwordSalt != null">password_salt = #{record.passwordSalt,jdbcType=VARCHAR},</if></set><if test="_parameter != null"><include refid="Update_By_Example_Where_Clause" /></if></update><update id="updateByExample" parameterType="map">update usersset id = #{record.id,jdbcType=BIGINT},username = #{record.username,jdbcType=VARCHAR},password = #{record.password,jdbcType=VARCHAR},password_salt = #{record.passwordSalt,jdbcType=VARCHAR}<if test="_parameter != null"><include refid="Update_By_Example_Where_Clause" /></if></update><update id="updateByPrimaryKeySelective" parameterType="com.demo.entity.Users">update users<set><if test="username != null">username = #{username,jdbcType=VARCHAR},</if><if test="password != null">password = #{password,jdbcType=VARCHAR},</if><if test="passwordSalt != null">password_salt = #{passwordSalt,jdbcType=VARCHAR},</if></set>where id = #{id,jdbcType=BIGINT}</update><update id="updateByPrimaryKey" parameterType="com.demo.entity.Users">update usersset username = #{username,jdbcType=VARCHAR},password = #{password,jdbcType=VARCHAR},password_salt = #{passwordSalt,jdbcType=VARCHAR}where id = #{id,jdbcType=BIGINT}</update> </mapper>

　　

package com.demo.entity;public class Users {private Long id;private String username;private String password;private String passwordSalt;public Long getId() {return id;}public void setId(Long id) {this.id = id;}public String getUsername() {return username;}public void setUsername(String username) {this.username = username;}public String getPassword() {return password;}public void setPassword(String password) {this.password = password;}public String getPasswordSalt() {return passwordSalt;}public void setPasswordSalt(String passwordSalt) {this.passwordSalt = passwordSalt;} }

　　

package com.demo.entity;import java.util.ArrayList; import java.util.List;public class UsersExample {protected String orderByClause;protected boolean distinct;protected List<Criteria> oredCriteria;public UsersExample() {oredCriteria = new ArrayList<Criteria>();}public void setOrderByClause(String orderByClause) {this.orderByClause = orderByClause;}public String getOrderByClause() {return orderByClause;}public void setDistinct(boolean distinct) {this.distinct = distinct;}public boolean isDistinct() {return distinct;}public List<Criteria> getOredCriteria() {return oredCriteria;}public void or(Criteria criteria) {oredCriteria.add(criteria);}public Criteria or() {Criteria criteria = createCriteriaInternal();oredCriteria.add(criteria);return criteria;}public Criteria createCriteria() {Criteria criteria = createCriteriaInternal();if (oredCriteria.size() == 0) {oredCriteria.add(criteria);}return criteria;}protected Criteria createCriteriaInternal() {Criteria criteria = new Criteria();return criteria;}public void clear() {oredCriteria.clear();orderByClause = null;distinct = false;}protected abstract static class GeneratedCriteria {protected List<Criterion> criteria;protected GeneratedCriteria() {super();criteria = new ArrayList<Criterion>();}public boolean isValid() {return criteria.size() > 0;}public List<Criterion> getAllCriteria() {return criteria;}public List<Criterion> getCriteria() {return criteria;}protected void addCriterion(String condition) {if (condition == null) {throw new RuntimeException("Value for condition cannot be null");}criteria.add(new Criterion(condition));}protected void addCriterion(String condition, Object value, String property) {if (value == null) {throw new RuntimeException("Value for " + property + " cannot be null");}criteria.add(new Criterion(condition, value));}protected void addCriterion(String condition, Object value1, Object value2, String property) {if (value1 == null || value2 == null) {throw new RuntimeException("Between values for " + property + " cannot be null");}criteria.add(new Criterion(condition, value1, value2));}public Criteria andIdIsNull() {addCriterion("id is null");return (Criteria) this;}public Criteria andIdIsNotNull() {addCriterion("id is not null");return (Criteria) this;}public Criteria andIdEqualTo(Long value) {addCriterion("id =", value, "id");return (Criteria) this;}public Criteria andIdNotEqualTo(Long value) {addCriterion("id <>", value, "id");return (Criteria) this;}public Criteria andIdGreaterThan(Long value) {addCriterion("id >", value, "id");return (Criteria) this;}public Criteria andIdGreaterThanOrEqualTo(Long value) {addCriterion("id >=", value, "id");return (Criteria) this;}public Criteria andIdLessThan(Long value) {addCriterion("id <", value, "id");return (Criteria) this;}public Criteria andIdLessThanOrEqualTo(Long value) {addCriterion("id <=", value, "id");return (Criteria) this;}public Criteria andIdIn(List<Long> values) {addCriterion("id in", values, "id");return (Criteria) this;}public Criteria andIdNotIn(List<Long> values) {addCriterion("id not in", values, "id");return (Criteria) this;}public Criteria andIdBetween(Long value1, Long value2) {addCriterion("id between", value1, value2, "id");return (Criteria) this;}public Criteria andIdNotBetween(Long value1, Long value2) {addCriterion("id not between", value1, value2, "id");return (Criteria) this;}public Criteria andUsernameIsNull() {addCriterion("username is null");return (Criteria) this;}public Criteria andUsernameIsNotNull() {addCriterion("username is not null");return (Criteria) this;}public Criteria andUsernameEqualTo(String value) {addCriterion("username =", value, "username");return (Criteria) this;}public Criteria andUsernameNotEqualTo(String value) {addCriterion("username <>", value, "username");return (Criteria) this;}public Criteria andUsernameGreaterThan(String value) {addCriterion("username >", value, "username");return (Criteria) this;}public Criteria andUsernameGreaterThanOrEqualTo(String value) {addCriterion("username >=", value, "username");return (Criteria) this;}public Criteria andUsernameLessThan(String value) {addCriterion("username <", value, "username");return (Criteria) this;}public Criteria andUsernameLessThanOrEqualTo(String value) {addCriterion("username <=", value, "username");return (Criteria) this;}public Criteria andUsernameLike(String value) {addCriterion("username like", value, "username");return (Criteria) this;}public Criteria andUsernameNotLike(String value) {addCriterion("username not like", value, "username");return (Criteria) this;}public Criteria andUsernameIn(List<String> values) {addCriterion("username in", values, "username");return (Criteria) this;}public Criteria andUsernameNotIn(List<String> values) {addCriterion("username not in", values, "username");return (Criteria) this;}public Criteria andUsernameBetween(String value1, String value2) {addCriterion("username between", value1, value2, "username");return (Criteria) this;}public Criteria andUsernameNotBetween(String value1, String value2) {addCriterion("username not between", value1, value2, "username");return (Criteria) this;}public Criteria andPasswordIsNull() {addCriterion("password is null");return (Criteria) this;}public Criteria andPasswordIsNotNull() {addCriterion("password is not null");return (Criteria) this;}public Criteria andPasswordEqualTo(String value) {addCriterion("password =", value, "password");return (Criteria) this;}public Criteria andPasswordNotEqualTo(String value) {addCriterion("password <>", value, "password");return (Criteria) this;}public Criteria andPasswordGreaterThan(String value) {addCriterion("password >", value, "password");return (Criteria) this;}public Criteria andPasswordGreaterThanOrEqualTo(String value) {addCriterion("password >=", value, "password");return (Criteria) this;}public Criteria andPasswordLessThan(String value) {addCriterion("password <", value, "password");return (Criteria) this;}public Criteria andPasswordLessThanOrEqualTo(String value) {addCriterion("password <=", value, "password");return (Criteria) this;}public Criteria andPasswordLike(String value) {addCriterion("password like", value, "password");return (Criteria) this;}public Criteria andPasswordNotLike(String value) {addCriterion("password not like", value, "password");return (Criteria) this;}public Criteria andPasswordIn(List<String> values) {addCriterion("password in", values, "password");return (Criteria) this;}public Criteria andPasswordNotIn(List<String> values) {addCriterion("password not in", values, "password");return (Criteria) this;}public Criteria andPasswordBetween(String value1, String value2) {addCriterion("password between", value1, value2, "password");return (Criteria) this;}public Criteria andPasswordNotBetween(String value1, String value2) {addCriterion("password not between", value1, value2, "password");return (Criteria) this;}public Criteria andPasswordSaltIsNull() {addCriterion("password_salt is null");return (Criteria) this;}public Criteria andPasswordSaltIsNotNull() {addCriterion("password_salt is not null");return (Criteria) this;}public Criteria andPasswordSaltEqualTo(String value) {addCriterion("password_salt =", value, "passwordSalt");return (Criteria) this;}public Criteria andPasswordSaltNotEqualTo(String value) {addCriterion("password_salt <>", value, "passwordSalt");return (Criteria) this;}public Criteria andPasswordSaltGreaterThan(String value) {addCriterion("password_salt >", value, "passwordSalt");return (Criteria) this;}public Criteria andPasswordSaltGreaterThanOrEqualTo(String value) {addCriterion("password_salt >=", value, "passwordSalt");return (Criteria) this;}public Criteria andPasswordSaltLessThan(String value) {addCriterion("password_salt <", value, "passwordSalt");return (Criteria) this;}public Criteria andPasswordSaltLessThanOrEqualTo(String value) {addCriterion("password_salt <=", value, "passwordSalt");return (Criteria) this;}public Criteria andPasswordSaltLike(String value) {addCriterion("password_salt like", value, "passwordSalt");return (Criteria) this;}public Criteria andPasswordSaltNotLike(String value) {addCriterion("password_salt not like", value, "passwordSalt");return (Criteria) this;}public Criteria andPasswordSaltIn(List<String> values) {addCriterion("password_salt in", values, "passwordSalt");return (Criteria) this;}public Criteria andPasswordSaltNotIn(List<String> values) {addCriterion("password_salt not in", values, "passwordSalt");return (Criteria) this;}public Criteria andPasswordSaltBetween(String value1, String value2) {addCriterion("password_salt between", value1, value2, "passwordSalt");return (Criteria) this;}public Criteria andPasswordSaltNotBetween(String value1, String value2) {addCriterion("password_salt not between", value1, value2, "passwordSalt");return (Criteria) this;}}public static class Criteria extends GeneratedCriteria {protected Criteria() {super();}}public static class Criterion {private String condition;private Object value;private Object secondValue;private boolean noValue;private boolean singleValue;private boolean betweenValue;private boolean listValue;private String typeHandler;public String getCondition() {return condition;}public Object getValue() {return value;}public Object getSecondValue() {return secondValue;}public boolean isNoValue() {return noValue;}public boolean isSingleValue() {return singleValue;}public boolean isBetweenValue() {return betweenValue;}public boolean isListValue() {return listValue;}public String getTypeHandler() {return typeHandler;}protected Criterion(String condition) {super();this.condition = condition;this.typeHandler = null;this.noValue = true;}protected Criterion(String condition, Object value, String typeHandler) {super();this.condition = condition;this.value = value;this.typeHandler = typeHandler;if (value instanceof List<?>) {this.listValue = true;} else {this.singleValue = true;}}protected Criterion(String condition, Object value) {this(condition, value, null);}protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {super();this.condition = condition;this.value = value;this.secondValue = secondValue;this.typeHandler = typeHandler;this.betweenValue = true;}protected Criterion(String condition, Object value, Object secondValue) {this(condition, value, secondValue, null);}} }

　　

?

轉(zhuǎn)載于:https://www.cnblogs.com/fofawubian/p/6364842.html

總結(jié)

以上是生活随笔為你收集整理的mybatis maven 代码生成器（mysql）的全部?jī)?nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯(cuò)，歡迎將生活随笔推薦給好友。