<?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.yao.Dao.UserDao"><select id="getUserList" resultType="com.yao.pojo.User">
select * from mybatis.user
</select><select id="getUserByName" resultType="com.yao.pojo.User" parameterType="String">
select * from mybatis.user where name=#{name}</select><select id="getUserListByName" resultType="com.yao.pojo.User">
select * from mybatis.user where name like "%" #{value}"%"</select><insert id="addUser" parameterType="com.yao.pojo.User">
insert into mybatis.user(name,number,email)values(#{name},#{number},#{email})</insert><update id="updateUser" parameterType="com.yao.pojo.User">
update mybatis.user
set number=#{number},email=#{email}
where name=#{name};</update><delete id="delUser" parameterType="com.yao.pojo.User">
delete from mybatis.user where name=#{name}</delete></mapper>