mybatis_01 初运行

maven坐标

<dependency>
  <groupId>org.mybatis</groupId>
  <artifactId>mybatis</artifactId>
  <version>3.5.2</version>
</dependency>
<dependency>
   <groupId>mysql</groupId>
   <artifactId>mysql-connector-java</artifactId>
   <version>5.1.47</version>
</dependency>

mybatis配置文件：

mybatis-config.xml

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration
       PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
       "http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
   <environments default="development">
       <environment id="development">
           <transactionManager type="JDBC"/>
           <dataSource type="POOLED">
               <property name="driver" value="com.mysql.jdbc.Driver"/>
               <property name="url" value="jdbc:mysql://localhost:3306/test?useSSL=true&amp;useUnicode=true&amp;characterEncoding=utf8"/>
               <property name="username" value="root"/>
               <property name="password" value="root"/>
           </dataSource>
       </environment>
   </environments>
   <mappers>
       <mapper resource="com/huang/mapper/UserInfoMapper.xml"/>
   </mappers>
</configuration>

映射文件：

mapper.xml

<?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="com.huang.mapper.UserInfoMapper">
 <select id="selectUser" resultType="com.huang.entity.UserInfo">
  select * from user_info
 </select>
</mapper>

测试：

  String resource = "mybatis-config.xml";
  InputStream inputStream = Resources.getResourceAsStream(resource);
  SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);

  SqlSession session = sqlSessionFactory.openSession();
  
  UserInfoMapper userInfoMapper = session.getMapper(UserInfoMapper.class);
  
  userInfoMapper.selectUser().forEach(System.out::print);

 

其他代码：

实体：

package com.huang.entity;

public class UserInfo {
    
    private String id;
    
    private String username;
    
    private String password;

    public String getId() {
        return id;
    }

    public void setId(String id) {
        this.id = id;
    }

    public String getUsername() {
        return username;
    }

    public void setUsername(String username) {
        this.username = username;
    }

    public String getPassword() {
        return password;
    }

    public void setPassword(String password) {
        this.password = password;
    }

    public UserInfo() {
        super();
        // TODO Auto-generated constructor stub
    }

    public UserInfo(String id, String username, String password) {
        super();
        this.id = id;
        this.username = username;
        this.password = password;
    }

    @Override
    public String toString() {
        return "UserInfo [id=" + id + ", username=" + username + ", password=" + password + "]";
    }
    
    

}

dao层：

package com.huang.mapper;

import java.util.List;

import com.huang.entity.UserInfo;

public interface UserInfoMapper {
    
    List<UserInfo> selectUser();

}