首先动态sql可以减少代码量,有利于后期对代码的维护
实体类
package com.zking.pojo;
public class users {
//id
private String uid;
//名称
private String uname;
//构造方法
public users() {
}
//带参数的构造方法
public users(String uid, String uname) {
this.uid = uid;
this.uname = uname;
}
//对象get/set方法
public String getUid() {
return uid;
}
public void setUid(String uid) {
this.uid = uid;
}
public String getUname() {
return uname;
}
public void setUname(String uname) {
this.uname = uname;
}
//toString方法
@Override
public String toString() {
return "users{" +
"uid='" + uid + '\'' +
", uname='" + uname + '\'' +
'}';
}
}
mapper类:
Usersvice接口
package com.zking.mapper;
import com.zking.pojo.users;
import java.util.List;
import java.util.Map;
public interface Usersservice {
//查询所有
public List<users> findAll();
//查询分页
public List<users> findAllfy(Map<String,Object> map);
//查询输出map形式
public Map<String,Object> fand();
//查询所有
public List<users> findall(users u);
//修改
public int update(users u);
}
XML:
<?xml version="1.0" encoding="utf-8" ?>
<!--引用mybatisDTD文件-->
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<!--1
方法名必须和接口的方法名一致
返回的参数类型也是和接口的参数类型一致
参数的数据类型也是和接口的参数数据类型一致
-->
<mapper namespace="com.zking.mapper.Usersservice">
<select id="findAll" resultType="users">
select * from users;
</select>
<!--查询分页-->
&