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();

}

巴特西

mybatis_01 初运行

最新文章

热门文章