mybatis+maven项目配置

1.建立maven项目，这里jar包，注意不是war。war的需要web.xml，我们只是java项目。

2.

<dependencies>
		<dependency>
			<groupId>org.mybatis</groupId>
			<artifactId>mybatis</artifactId>
			<version>3.4.6</version>
		</dependency>
		<dependency>
			<groupId>mysql</groupId>
			<artifactId>mysql-connector-java</artifactId>
			<version>5.1.46</version>
		</dependency>
		<dependency>
			<groupId>log4j</groupId>
			<artifactId>log4j</artifactId>
			<version>1.2.12</version>
		</dependency>
		<dependency>
			<groupId>commons-logging</groupId>
			<artifactId>commons-logging</artifactId>
			<version>1.2</version>
		</dependency>
		<dependency>
			<groupId>org.slf4j</groupId>
			<artifactId>slf4j-log4j12</artifactId>
			<version>1.7.25</version>
		</dependency>
		<dependency>
			<groupId>junit</groupId>
			<artifactId>junit</artifactId>
			<version>4.12</version>
			<scope>test</scope>
		</dependency>
	</dependencies>

引入依赖，mybaits   mysql   mysql-connection-java  log4j  commons-logging

3.配置mybatisConfig.xml这是mybatis的总配置文件，这个文件有两个作用，第一是连接数据库，第二是管理实体类和数据库的映射文件

<?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>

	<!-- 和spring整合后 environments配置将废除 -->
	<environments default="development">
		<environment id="development">
			<!-- 使用jdbc事务管理 -->
			<transactionManager type="JDBC" />
			<!-- 数据库连接池 -->
			<dataSource type="POOLED">
				<property name="driver" value="com.mysql.jdbc.Driver" />
				<property name="url"
					value="jdbc:mysql://localhost:3306/mybatisdemo" />
				<property name="username" value="root" />
				<property name="password" value="root" />
			</dataSource>
		</environment>
	</environments>

	<mappers>
		<mapper resource="com/dhcc/UserMapper.xml" />
	</mappers>

</configuration>

4.建立pojo类，这个类要求和数据库每个字段对应，建立对应的xml   UserMapper.xml

5.写测试

package cn.ybzy.MybatisTestPK;

import java.io.IOException;
import java.io.InputStream;
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.Test;
import com.dhcc.User;

public class MybatisTest {

	@Test
	public void test() throws IOException {
		/**
		 * 创建会话工厂，获取数据库的连接会话，通过session操作数据库
		 */
		InputStream in = Resources.getResourceAsStream("com/mybatisConfig.xml");

		SqlSessionFactory sqlSession = new SqlSessionFactoryBuilder().build(in);

		SqlSession session = sqlSession.openSession();

		User user = session.selectOne("com.dhcc.selectOneUser", 1);

		System.out.println(user);

	}

}