Mybatis入门

jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3307/exercisedb?characterEncoding=utf-8
jdbc.username=root
jdbc.password=admin57

public interface UserMapper {
    List selectAll();
}

    
        
        
        
        
    
    
    
        select * from exercisedb.user
    

package com.bjsxt.entity;

import java.io.Serializable;


public class User implements Serializable {
    private static final long serialVersionUID = -50885993925997685L;
    private Integer id;
    private String username;
    private String userpassword;
    
    public Integer getId() {
        return id;
    }
    public void setId(Integer id) {
        this.id = id;
    }
    public String getUsername() {
        return username;
    }
    public void setUsername(String username) {
        this.username = username;
    }
    public String getUserpassword() {
        return userpassword;
    }
    public void setUserpassword(String userpassword) {
        this.userpassword = userpassword;
    }
    @Override
    public String toString() {
        return "User{" +
                "id=" + id +
                ", username='" + username + ''' +
                ", userpassword='" + userpassword + ''' +
                '}';
    }
}

package com.bjsxt;

import java.io.BufferedInputStream;
import java.io.InputStream;
import java.util.List;

import com.bjsxt.Mapper.UserMapper;
import com.bjsxt.entity.User;
import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.*;

public class Test {
    public static void main(String[] args) throws Exception {
        String resource = "SqlMapperClient.xml";
        InputStream inputStream = Resources.getResourceAsStream(resource);
        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
        SqlSession sqlSession = sqlSessionFactory.openSession(ExecutorType.REUSE);
        try {
            UserMapper userMapper = sqlSession.getMapper(UserMapper.class);
            List users = userMapper.selectAll();
            users.stream().forEach(System.out::println);
        } finally {
            sqlSession.close();
        }
    }
}