mybatis动态SQL

首先动态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>
    <!--查询分页-->
    &