<?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"><mappernamespace="com.sws.code.mycode.dao.DeptDao"><resultMapid="BaseResultMap"type="com.sws.code.mycode.entity.Dept"><!--
WARNING - @mbg.generated
This element is automatically generated by MyBatis Generator, do not modify.
--><idcolumn="id"jdbcType="INTEGER"property="id"/><resultcolumn="name"jdbcType="VARCHAR"property="name"/><resultcolumn="remark"jdbcType="VARCHAR"property="remark"/></resultMap><deleteid="deleteByPrimaryKey"parameterType="java.lang.Integer"><!--
WARNING - @mbg.generated
This element is automatically generated by MyBatis Generator, do not modify.
-->
delete from dept_inf
where id = #{id,jdbcType=INTEGER}
</delete><insertid="insert"parameterType="com.sws.code.mycode.entity.Dept"><!--
WARNING - @mbg.generated
This element is automatically generated by MyBatis Generator, do not modify.
--><selectKeykeyProperty="id"order="AFTER"resultType="java.lang.Integer">
SELECT LAST_INSERT_ID()
</selectKey>
insert into dept_inf (`name`, remark)
values (#{name,jdbcType=VARCHAR}, #{remark,jdbcType=VARCHAR})
</insert><updateid="updateByPrimaryKey"parameterType="com.sws.code.mycode.entity.Dept"><!--
WARNING - @mbg.generated
This element is automatically generated by MyBatis Generator, do not modify.
-->
update dept_inf
set `name` = #{name,jdbcType=VARCHAR},
remark = #{remark,jdbcType=VARCHAR}
where id = #{id,jdbcType=INTEGER}
</update><selectid="selectByPrimaryKey"parameterType="java.lang.Integer"resultMap="BaseResultMap"><!--
WARNING - @mbg.generated
This element is automatically generated by MyBatis Generator, do not modify.
-->
select id, `name`, remark
from dept_inf
where id = #{id,jdbcType=INTEGER}
</select><selectid="selectAll"resultMap="BaseResultMap"><!--
WARNING - @mbg.generated
This element is automatically generated by MyBatis Generator, do not modify.
-->
select id, `name`, remark
from dept_inf
</select><selectid="getAllNum"resultType="java.lang.Integer">
select count(*) from dept_inf
</select></mapper>
dao
由mybatis-generator生成,与mapper.xml对应
@RepositorypublicinterfaceDeptDao{/**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table dept_inf
*
* @mbg.generated
*/intdeleteByPrimaryKey(Integer id);/**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table dept_inf
*
* @mbg.generated
*/intinsert(Dept record);/**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table dept_inf
*
* @mbg.generated
*/
Dept selectByPrimaryKey(Integer id);/**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table dept_inf
*
* @mbg.generated
*/
List<Dept>selectAll();/**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table dept_inf
*
* @mbg.generated
*/intupdateByPrimaryKey(Dept record);intgetAllNum();}
entity
由mybatis-generator生成,对应mysql表
publicclassDeptimplementsSerializable{/**
*
* This field was generated by MyBatis Generator.
* This field corresponds to the database column dept_inf.id
*
* @mbg.generated
*/private Integer id;/**
*
* This field was generated by MyBatis Generator.
* This field corresponds to the database column dept_inf.name
*
* @mbg.generated
*/private String name;/**
*
* This field was generated by MyBatis Generator.
* This field corresponds to the database column dept_inf.remark
*
* @mbg.generated
*/private String remark;/**
* This field was generated by MyBatis Generator.
* This field corresponds to the database table dept_inf
*
* @mbg.generated
*/privatestaticfinallong serialVersionUID =1L;/**
* This method was generated by MyBatis Generator.
* This method returns the value of the database column dept_inf.id
*
* @return the value of dept_inf.id
*
* @mbg.generated
*/public Integer getId(){return id;}/**
* This method was generated by MyBatis Generator.
* This method sets the value of the database column dept_inf.id
*
* @param id the value for dept_inf.id
*
* @mbg.generated
*/publicvoidsetId(Integer id){this.id = id;}/**
* This method was generated by MyBatis Generator.
* This method returns the value of the database column dept_inf.name
*
* @return the value of dept_inf.name
*
* @mbg.generated
*/public String getName(){return name;}/**
* This method was generated by MyBatis Generator.
* This method sets the value of the database column dept_inf.name
*
* @param name the value for dept_inf.name
*
* @mbg.generated
*/publicvoidsetName(String name){this.name = name == null ? null : name.trim();}/**
* This method was generated by MyBatis Generator.
* This method returns the value of the database column dept_inf.remark
*
* @return the value of dept_inf.remark
*
* @mbg.generated
*/public String getRemark(){return remark;}/**
* This method was generated by MyBatis Generator.
* This method sets the value of the database column dept_inf.remark
*
* @param remark the value for dept_inf.remark
*
* @mbg.generated
*/publicvoidsetRemark(String remark){this.remark = remark == null ? null : remark.trim();}/**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table dept_inf
*
* @mbg.generated
*/@Overridepublic String toString(){
StringBuilder sb =newStringBuilder();
sb.append(getClass().getSimpleName());
sb.append(" [");
sb.append("Hash = ").append(hashCode());
sb.append(", id=").append(id);
sb.append(", name=").append(name);
sb.append(", remark=").append(remark);
sb.append(", serialVersionUID=").append(serialVersionUID);
sb.append("]");return sb.toString();}}