Mybatis入门-环境搭建(一)

1.首先下配置下maven项目所依赖的jar包

<dependency>
    <groupId>org.mybatis</groupId>
    <artifactId>mybatis</artifactId>
    <version>3.5.3</version>
</dependency>

<!--mysql驱动包 -->
<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>5.1.8</version>
</dependency>

<!--junit测试包 -->
<dependency>
    <groupId>junit</groupId>
    <artifactId>junit</artifactId>
    <version>4.12</version>
</dependency>

<!--日志包，方便查看动态sql语句 -->
<dependency>
    <groupId>org.slf4j</groupId>
    <artifactId>slf4j-log4j12</artifactId>
    <version>1.6.1</version>
</dependency>

<build>
<resources>
    <resource>
        <directory>src/main/java</directory>
        <includes>
            <include>**/*.xml</include>
        </includes>
        <filtering>true</filtering>
    </resource>
    <resource>
        <directory>src/main/resources</directory>
        <includes>
            <include>**/*.xml</include>
            <include>**/*.properites</include>
        </includes>
    </resource>
</resources>
</build>

2.创建SqlMapConfig.xml全局配置文件模板
我们这里首先要再idea中配置模板文件 点击file->settings—>editor—>file and code templates->file tab页的+号

<?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="${driver}"/>
      <property name="url" value="${url}"/>
      <property name="username" value="${username}"/>
      <property name="password" value="${password}"/>
    </dataSource>
  </environment>
</environments>
<mappers>
  <mapper resource="org/mybatis/example/BlogMapper.xml"/>
</mappers>
</configuration>

3.创建SqlMapper.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="org.mybatis.example.BlogMapper">
<select id="selectBlog" resultType="Blog">
  select * from Blog where id = #{id}
</select>
</mapper>

然后设置网址 点击file->settings—>language & frameworks->schemas and dtds（网址内容可以在模板文件中找到）
添加：http://mybatis.org/dtd/mybatis-3-config.dtd
添加：http://mybatis.org/dtd/mybatis-3-mapper.dtd

4.rescources文件夹下创建SqlMapConfig.xml全局配置文件
配置文件中填写的四要素就是jdbc连接数据库的四要素，创建完成后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://192.168.220.130:3306/test_project?useUnicode=true&amp;characterEncoding=UTF-8"/>
              <property name="username" value="root"/>
              <property name="password" value="qwert123"/>
          </dataSource>
      </environment>
 </environments>
  <mappers>
      <!-这里是加载mapper映射文件的-->
      <mapper resource="com/msb/pojo/DeptMapper.xml"/>
  </mappers>
</configuration>

5.java文件夹下创建实体类

public class Dept {

private int deptno;

private String dname;

private String loc;

public int getDeptno() {
	 return deptno;
}

public void setDeptno(int deptno) {
this.deptno = deptno;
}

public String getDname() {
 return dname;
}

public void setDname(String dname) {
 this.dname = dname;
}

public String getLoc() {
return loc;
}

public void setLoc(String loc) {
this.loc = loc;
}

public Dept() {
}

public Dept(int deptno, String dname, String loc) {
this.deptno = deptno;
this.dname = dname;
this.loc = loc;
}
}

实体类的信息要和数据库表字段信息一致

6.rescources文件夹下创建SqlMapper.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="org.mybatis.example.BlogMapper">
  <!--id是唯一表示SQL语句的，resultType为返回集合中元素类型-->
  <select id="selectAllDept" resultType="com.msb.pojo.Dept">
      select * from dept
  </select>
</mapper>

7.加载log4j类

public class initLogRecord {
public static void initLog() {
FileInputStream fileInputStream = null;
try {
    Properties properties = new Properties();
    fileInputStream = new FileInputStream("src/main/resources/log4j.properites");
    properties.load(fileInputStream);
    PropertyConfigurator.configure(properties);
} catch (Exception e) {
    e.printStackTrace();
} finally {
    if (fileInputStream != null) {
        try {
            fileInputStream.close();
        } catch (IOException e) {
            e.printStackTrace();
        }
    }
}
}
}

8.log4j.properties

log4j.rootLogger=debug, stdout, R

log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout

log4j.appender.stdout.layout.ConversionPattern=%5p [%t] 	(%F:%L) - %m%n

log4j.appender.R=org.apache.log4j.RollingFileAppender
log4j.appender.R.File=example.log

log4j.appender.R.MaxFileSize=100KB

log4j.appender.R.MaxBackupIndex=5

log4j.appender.R.layout=org.apache.log4j.PatternLayout
log4j.appender.R.layout.ConversionPattern=%p %t %c - 	%m%n

9.测试类

public class MyBatisTest {
private SqlSessionFactory factory;

@Test
public void testSelectAllDept() throws IOException {
//获取session对象，返回结果
SqlSession session = factory.openSession();
List<Dept> list = session.selectList("selectAllDept");
for (Dept dept : list) {
    System.out.println(dept.getDeptno() + "," + dept.getDname() + "," + dept.getLoc());
}
session.close();
}

@Before
public void factoryInit() throws IOException{
   initLogRecord.initLog();
//加载配置文件
InputStream resource = Resources.getResourceAsStream("SqlMapConfig.xml");
SqlSessionFactoryBuilder builder = new SqlSessionFactoryBuilder();
factory = builder.build(resource);
}
}

运行结果