mybatis

package org.example;

import static org.junit.Assert.assertTrue;

import factory.server.myBatisServer;

import java.io.IOException;

/**

 * Unit test for simple App.

 */

public class mybatisTest

{

    public static void main(String[] args) throws IOException {

        myBatisServer server=new myBatisServer();

        System.out.println(server.getList(2));

    }

}

<?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE configuration PUBLIC "-////DTD Config 3.0//EN" "http:///dtd/mybatis-3-config.dtd">

<configuration>

    <typeAliases>

<!--        <typeAlias type="com.example.User" alias="User" />-->

    </typeAliases>

    <environments default="development">

        <environment id="development">

            <transactionManager type="JDBC" />

            <dataSource type="POOLED">

                <property name="driver" value="com.mysql.cj.jdbc.Driver" />

                <property name="url" value="jdbc:mysql://127.0.0.1:3306/mysql?serverTimezone=GMT%2B8" />

                <property name="username" value="root" />

                <property name="password" value="root" />

            </dataSource>

        </environment>

    </environments>

    <mappers>

        <mapper resource="mapper/mysqltest.xml" />

    </mappers>

</configuration>

package factory.server;

import entity.mysqlTest;

import mapper.mySqlTestMapper;

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 java.io.IOException;

import java.io.InputStream;

import java.util.List;

public class myBatisServer {

    private  mySqlTestMapper mapper;

    public myBatisServer() throws IOException {

        String resource="mybatis-config.xml";

        InputStream resourceAsStream = Resources.getResourceAsStream(resource);

        SqlSessionFactory sqlSessionFactory=new SqlSessionFactoryBuilder().build(resourceAsStream);

        SqlSession  sqlSession=sqlSessionFactory.openSession();

         mapper = sqlSession.getMapper(mySqlTestMapper.class);

    }

    public List<mysqlTest> getList(int id){

        List<mysqlTest> list=mapper.selectMysqlTest(id);

        return  list;

    }

}