第十章 MyBatis技术练习

1、根据how2j案例进行基础增删改查的练习

2、练习动态sql

 3、练习分页

（1)创建表，然后手动导入数据

create table `four kings`
(
    id int primary key,
    name varchar(4) ,
    idea varchar(20)
)CHARSET=utf8;

(2) 写实体类

package Num;
 
public class fk {
    public int getId() {
        return id;
    }
 
    public void setId(int id) {
        this.id = id;
    }
 
    public String getName() {
        return name;
    }
 
    public void setName(String name) {
        this.name = name;
    }
 
    public String getIdea() {
        return idea;
    }
 
    public void setIdea(String idea) {
        this.idea = idea;
    }
 
    private int id;
    private String name;
    private String idea;
 
}

(3)配置文件

<?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="Num">
        <select id="listfk" resultType="fk">
            select * from four kings     
        </select>
    </mapper>

(4)编写一个测试类

package controller;
 
import java.io.IOException;
import java.io.InputStream;
import java.util.List;
import java.util.Scanner;
 
import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
 
import Num.fk;
 
public class TestMybatis {
 
    public static void main(String[] args) throws IOException {
        String resource = "mybatis-config.xml";
        InputStream inputStream = Resources.getResourceAsStream(resource);
        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
        SqlSession session=sqlSessionFactory.openSession();
        
        Scanner sc = new Scanner(System.in);
        String s = sc.nextLine();
        
        fk user = session.selectOne("query",s);
        System.out.println("姓名:" + user.getName());
        System.out.println("年龄:" + user.getAge());
        
        session.commit();
        session.close();
    }
}