Mabitis简易实践理论1

MyBatis结构分布

sqlMapConfig.xml

1.配置数据源
2.配置别名标签
3.缓存的配置

xxxMapper.xml

映射文件，主要写sql，映射关系

SqlSeesionFactory

生成数据库连接

SqlSession

执行数据库的CRUD

项目准备

项目结构

约束文件

：所需文件自己下载(或者在下方留下评论)

代码书写

sqlMapConfig.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">
		<environment id="mysql">
			<transactionManager type="JDBC" />
			<dataSource type="POOLED">
				<property name="driver" value="com.mysql.jdbc.Driver" />
				<property name="url" value="jdbc:mysql://localhost:3306/mybatis" />
				<property name="username" value="root" />
				<property name="password" value="root" />
			</dataSource>
		</environment>
		
		<environment id="oracle">
			<transactionManager type="JDBC" />
			<dataSource type="POOLED">
				<property name="driver" value="oracle.jdbc.driver.OracleDriver" />
				<property name="url" value="jdbc:oracle:thin:@127.0.0.1:1521:XE" />
				<property name="username" value="ht1602" />
				<property name="password" value="htdb" />
			</dataSource>
		</environment>
	</environments>
	
</configuration>

在数据库创建表

：创建表的时候一定要注意细节问题，例如标点符号是否缺失。

创建bean（对应的是User.java文件）

package com.biem.mybatis.bean;

public class User {

	private int id;
	private String username;
	private int age;

	public int getId() {
		return id;
	}

	public void setId(int id) {
		this.id = id;
	}

	public String getUsername() {
		return username;
	}

	public void setUsername(String username) {
		this.username = username;
	}

	public int getAge() {
		return age;
	}

	public void setAge(int age) {
		this.age = age;
	}

	@Override
	public String toString() {
		return "User [id=" + id + ", username=" + username + ", age=" + age + "]";
	}

}

编写映射文件（对应的是UserMapper.xml文件）

该文件的主要功能是描述bean和表sql的映射关系

<?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="com.biem.mybatis.bean.UserMapper">
 
   <select id="queryAll" resultType="com.biem.mybatis.bean.User">
           select * from user
   </select>
 
</mapper>

将映射文件配置到sqlMaoConfig.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">
		<environment id="mysql">
			<transactionManager type="JDBC" />
			<dataSource type="POOLED">
				<property name="driver" value="com.mysql.jdbc.Driver" />
				<property name="url" value="jdbc:mysql://localhost:3306/mybatis" />
				<property name="username" value="root" />
				<property name="password" value="root" />
			</dataSource>
		</environment>
		
		<environment id="oracle">
			<transactionManager type="JDBC" />
			<dataSource type="POOLED">
				<property name="driver" value="oracle.jdbc.driver.OracleDriver" />
				<property name="url" value="jdbc:oracle:thin:@127.0.0.1:1521:XE" />
				<property name="username" value="ht1602" />
				<property name="password" value="htdb" />
			</dataSource>
		</environment>
	</environments>
	
	<!-- 配置映射文件 -->
	<mappers>
	    <mapper resource="com/biem/mybatis/bean/userMapper.xml"/>
	</mappers>
	
</configuration>

测试类（对应的是MybatisTest.java文件）

package com.biem.mybatis.test;

import java.io.IOException;
import java.io.InputStream;
import java.util.Arrays;
import java.util.List;

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.biem.mybatis.bean.User;

public class MybatisTest01 {

	@Test
	public void test01() throws IOException {
		//1.读取mybatis的核心配置文件
		InputStream in = Resources.getResourceAsStream("sqlMapConfig.xml");
		//2.根据核心配置文件创建sqlsessionFactory
		SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(in);
		//3.创建session会话
		SqlSession session = factory.openSession();
		//4.执行操作
		List<User> list = session.selectList("com.biem.mybatis.bean.UserMapper.queryAll");
		//5.遍历结果
		System.out.println(Arrays.toString(list.toArray()));
	}

}

运行结果

[User [id=1, username=null, age=0], User [id=2, username=null, age=0], User [id=3, username=null, age=0], User [id=4, username=null, age=0], User [id=5, username=null, age=0]]