java学习碎碎念2：Mybatis学习

java学习碎碎念2：Mybatis学习

                      **mybatis框架图**

log4j.properties文件(用于mybatis)

log4j.rootLogger=DEBUG,A1
log4j.logger.org.apache=DEBUG
log4j.appender.A1=org.apache.log4j.ConsoleAppender
log4j.appender.A1.layout=org.apache.log4j.PatternLayout
#log4j.appender.A1.layout.ConversionPattern=%-d{yyyy-MM-dd HH:mm:ss,SSS} [%t] [%c]-[%p] %m%n
log4j.append、er.A1.layout.ConversionPattern=%5p [%t] %m%n

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>
    <properties>
        <property name="driver" value="com.mysql.jdbc.Driver"/>
        <property name="url" value="jdbc:mysql://localhost:3306/happy"/>
        <property name="username" value="root"/>
        <property name="password" value="admin"/>
    </properties>

    <environments default="development">
        <environment id="development">
            <transactionManager type="JDBC"/>
            <dataSource type="POOLED">
                <property name="driver" value="${driver}"/>
                <property name="url" value="${url}"/>
                <property name="username" value="${username}"/>
                <property name="password" value="${password}"/>
            </dataSource>
        </environment>
    </environments>
</configuration>

测试数据库连接

public class testConnection {
    String mybatisConfig = "mybatis.xml";
    @Test
    public void testConn() throws IOException {
        //mybatis提供得类完成文件得读写
        //import org.apache.ibatis.io.Resources;导的这个
        InputStream inputStream = Resources.getResourceAsStream(this.mybatisConfig);
        SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(inputStream);
        SqlSession session = factory.openSession();
        Connection connection = session.getConnection();
        System.out.println(connection);
    }
}