MyBatis基本配置

来源：互联网发布：java开源库存管理系统编辑：程序博客网时间：2024/06/02 04:02

<pre name="code" class="html"><?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><property name="dialect" value="cn.org.framework.jdbc.dialect.MySQLDialect" /></properties><settings><setting name="cacheEnabled" value="true" /></settings><environments default="development"><environment id="development"><transactionManager type="JDBC"></transactionManager><dataSource type="POOLED"><property name="driver" value="com.mysql.jdbc.Driver" /><property name="url"value="jdbc:mysql://101.201.152.172:3306/ams?useUnicode=true&characterEncoding=UTF-8" /><property name="username" value="root" /><property name="password" value="123456" /></dataSource></environment></environments><mappers><mapper resource="com/platform/core/module/Module.mapper.xml" /><mapper resource="com/platform/core/metadata/Entity.mapper.xml" /><mapper resource="com/platform/core/widget/Widget.mapper.xml" /><mapper resource="com/platform/app/model/SysUsers.mapper.xml" /></mappers></configuration>

<span style="font-family: Arial, Helvetica, sans-serif;">import java.io.IOException;</span>

import java.io.Reader;import org.apache.ibatis.io.Resources;import org.apache.ibatis.session.SqlSessionFactory;import org.apache.ibatis.session.SqlSessionFactoryBuilder;public class MyBatisUtil {// 每一个MyBatis的应用程序都以一个SqlSessionFactory对象的实例为核心// 使用SqlSessionFactory的最佳实践是在应用运行期间不要重复创建多次,最佳范围是应用范围private final static SqlSessionFactory sqlSessionFactory;static {String resource = "mybatis.xml";Reader reader = null;try {reader = Resources.getResourceAsReader(resource);} catch (IOException e) {System.out.println(e.getMessage());}// SqlSessionFactory对象的实例可以通过SqlSessionFactoryBuilder对象来获得// SqlSessionFactoryBuilder实例的最佳范围是方法范围（也就是本地方法变量）。sqlSessionFactory = new SqlSessionFactoryBuilder().build(reader);}public static SqlSessionFactory getSqlSessionFactory() {return sqlSessionFactory;}}

import org.apache.ibatis.session.SqlSession;import org.apache.ibatis.session.SqlSessionFactory;public class SQLBuildTest {static SqlSessionFactory sqlSessionFactory;static{sqlSessionFactory = MyBatisUtil.getSqlSessionFactory();}public static void main(String[] args) throws Exception {SqlSession sqlSession = sqlSessionFactory.openSession(); }}

0 0