<?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="Dao.UserDao"> <!-- id 为接口中查询方法的方法名 也可自定义 resultType:表示结果类型,遍历resultSet得到的java类型 ==全限定名称== ! --> <selectid="userList"resultType="entity.User"> select id,username,password from test01 order by id </select> <insertid="insertUser"> insert into test01 values (#{id},#{username},#{password}) </insert> <deleteid="deleteUser" > delete from test01 where id=#{id} </delete> <selectid="selectUserById"resultType="entity.User"parameterType="int"> select id,username,password from test01 where id=#{id} </select> <selectid="selectUserByIdOrUsername"resultType="entity.User" > select id,username,password from test01 where id=#{uid} or username=#{username} </select> </mapper>