Mybatis入门

核心配置文件的 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="mysql"><!--将来采用那种配置  通过ID进行选择-->
        <environment id="mysql">
            <transactionManager type="JDBC"></transactionManager>
            <dataSource type="POOLED">
                <property name="driver" value="com.mysql.jdbc.Driver"/>
                <property name="url" value="jdbc:mysql://localhost:3306/db14"/>
                <property name="username" value="root"/>
                <property name="password" value="141012"/>
            </dataSource>
        </environment>
    </environments>

    <mappers>
        <mapper resource="StudentMapper.xml"></mapper>
    </mappers>

</configuration>

映射文件的 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="StudentMapper">
    <select id="selectALL" resultType="com.zxp.bean.Student">
        select * from student
    </select>
</mapper>

测试代码

public class test {
    public static void main(String[] args) {
        try {
            InputStream in = Resources.getResourceAsStream("MaBatisConfig.xml");
            SqlSessionFactoryBuilder sqlSessionFactoryBuilder = new SqlSessionFactoryBuilder();//工厂对象
            SqlSessionFactory factory = sqlSessionFactoryBuilder.build(in);
            SqlSession sqlSession= factory.openSession();//最终想要的
          List<Student> students = sqlSession.selectList("StudentMapper.selectALL");//名称空间 配合 id 器
            for (Student student :students){
                System.out.println(student);
            }
        } catch (IOException e) {
            e.printStackTrace();
        }
    }
}