今天完成的事情：通过设置xml使用mybatis连接数据库

1.1mybatis-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/mytest" />
                <property name="username" value="root" />
                <property name="password" value="1234" />
            </dataSource>
        </environment>
    </environments>    
    <mappers>
        <mapper resource="JnsListMapper.xml" />
    </mappers>
</configuration>

1.2JnsListMapper.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.jns.test.dao.ListMapper">
<select id="getListId" resultType="com.jns.list.Jnslist">
select * from bjlist where id = #{id}
</select>
</mapper>

1.3使用junit测试mybatis连接数据库代码

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 org.junit.jupiter.api.Test;

@Test
 public void test() throws IOException {
  String resource = "mybatis-config.xml";
  InputStream inputStream = Resources.getResourceAsStream(resource);
  SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);  
  SqlSession openSession = sqlSessionFactory.openSession();  
  try {
   Jnslist jnslist = openSession.selectOne("com.jns.test.dao.ListMapper.getListId", 1);
          System.out.println(jnslist);
  }finally {
    openSession.close();
  }            
 }

明日计划的事情：继续练习通过接口和实现类操作数据库

遇到的问题：接口和实现类代表的含义感觉还很模糊，mybatis后会返回再深入了解jdbctemplate的CRUD相关使用