Mybatis 多表关联查询(1) one-to-one关系
推荐有mysql基础和java基础的伙伴阅读。
需要的jar包为
mysql-jdbc.jar(mysql数据包)
mybatis-3.2.1.jar(mybatis核心包)
基本文件
- MybatisUtil.java (工具类)
package com.adoken.util;
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 java.io.IOException;
import java.io.InputStream;
public class MybatisUtil {
private static SqlSessionFactory sqlSessionFactory = null;
private static ThreadLocal<SqlSession> threadLocal = new ThreadLocal<SqlSession>();
/*读取mybatis-config.xml文件*/
static {
try {
InputStream resources = Resources.getResourceAsStream("mybatis-config.xml");
sqlSessionFactory = new SqlSessionFactoryBuilder().build(resources);
} catch (IOException e) {
e.printStackTrace();
}
}
/**
* 禁止外部创建
*/
private MybatisUtil() {
}
public static SqlSession getSession() {
SqlSession session = threadLocal.get();
if (session == null) {
session = sqlSessionFactory.openSession();
}
return session;
}
public static void closeSession(SqlSession session) {
if (session != null) {
session.close();
}
}
/*测试连接*/
public static void main(String[] args) {
SqlSession session = MybatisUtil.getSession();
MybatisUtil.closeSession(session);
}
}
- db.properties (数据库配置信息文件)
username=root
password=root
url=jdbc:mysql://127.0.0.1:3306/un?useUnicode=true&characterEncoding=UTF-8&autoReconnect=true
driver=com.mysql.jdbc.Driver
- mybatis- config.xml (mybatis配置信息文件)
<?xml version="1.0"