<?xml version="1.0" encoding="UTF8" ?><!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd"><!--namespace绑定一个对应的Dao/Mapper接口--><mappernamespace="com.zhbit.dao.UserMapper"><!--select查询语句 id为方法的名字--><selectid="getUserList"resultType="com.zhbit.pojo.User">
select * from mybatis.user
</select><selectid="getUserById"parameterType="int"resultType="com.zhbit.pojo.User">
select * from mybatis.user where id = #{id}
</select><insertid="addUser"parameterType="com.zhbit.pojo.User">
insert into mybatis.user (id,name,pwd) values (#{id},#{name},#{pwd})
</insert><!--通过map来传递参数,values后面的参数名字可以自定义了--><insertid="addUser2"parameterType="map">
insert into mybatis.user (id,name,pwd) values (#{userId},#{userName},#{passWord})
</insert><updateid="updateUser"parameterType="com.zhbit.pojo.User">
update mybatis.user set name = #{name},pwd=#{pwd} where id=#{id} ;
</update><deleteid="deleteUser"parameterType="int">
delete from mybatis.user where id = #{id}
</delete></mapper>
mybatis-config.xml
<?xml version="1.0" encoding="UTF-8" ?><!DOCTYPE configuration
PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-config.dtd"><configuration><environmentsdefault="development"><environmentid="development"><transactionManagertype="JDBC"/><dataSourcetype="POOLED"><propertyname="driver"value="com.mysql.cj.jdbc.Driver"/><propertyname="url"value="jdbc:mysql://localhost:3306/mybatis?userSSL=true&userUnicode=true&chartacterEncoding=UTF-8"/><propertyname="username"value="root"/><propertyname="password"value="123456"/></dataSource></environment></environments><mappers><mapperresource="com/zhbit/dao/userMapper.xml"/></mappers></configuration>