MyBatis环境搭建

导包

mybatis-3.2.7.jar(MyBatis核心Jar包)

oracle6.jar(Oracle数据库Jar包)

在类目录下创建mybatis-config.xml，该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>

	<properties resource="db.properties"></properties><!-- 类目录下的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>
    <!-- 映射器 -->
	<mappers>
		<mapper resource="TestMapper.xml" /><!-- 类目录下的xml文件，用来了存储SQL语句 -->
	</mappers>
</configuration>

在类目录下创建db.properties文件，该文件用来存放连接数据库属性

url=jdbc:oracle:thin:@localhost:1521:orcl
username=scott
password=123456
driver=oracle.jdbc.driver.OracleDriver

在类目录下创建TestMapper.xml文件，该xml用来存放SQL语句

<!DOCTYPE mapper
    PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
    "http://mybatis.org/dtd/mybatis-3-mapper.dtd">

<mapper namespace="province">
	<select id="selectProvinceByid" resultType="com.yf.domain.Province">
		select * from province where provinceid=#{id}
	</select>
	<select id="selectProvinces" resultType="com.yf.domain.Province">
		select * from province
	</select>
</mapper>

Test测试类

public class Test {

	public static void main(String[] args) throws IOException {
		//mybatis环境的初始化
		String resource = "mybatis-config.xml";
		//加载mybatis-config.xml
		InputStream inputStream = Resources.getResourceAsStream(resource);
		//创建SqlSessionFactory
		SqlSessionFactory sqlSessionFactory =
		  new SqlSessionFactoryBuilder().build(inputStream);
		
		//获取SqlSession
		SqlSession session=sqlSessionFactory.openSession();
		System.out.println(session);
		
		//查询单个数据
		Province province=session.selectOne("province.selectProvinceByid", 110000);
		System.out.println(province.toString());
		//关闭session
		session.close();
	}
}

测试结果

org.apache.ibatis.session.defaults.DefaultSqlSession@66d33a
Province [provinceid=110000, province=北京]

连接成功，查询数据库信息成功

https://mybatis.org/mybatis-3/zh/index.html，这是MyBatis简介，里面对MyBatis做了详细介绍。