Maven中Mybatis配置

1.在pom文件中添加mybatis核心依赖，

• 配置 pom 文件 ，导包

 

代码如下：

<dependencies>

<!-- 配置 mybatis 核心依赖 -->

<dependency>

<groupId>org.mybatis</groupId>

<artifactId>mybatis</artifactId>

<version>3.4.5</version>

</dependency>

<dependency>

<groupId>mysql</groupId>

<artifactId>mysql-connector-java</artifactId>

<version>5.1.44</version>

</dependency>

<!-- 导入log4j 日志包 -->

<dependency>

<groupId>org.slf4j</groupId>

<artifactId>slf4j-log4j12</artifactId>

<version>1.7.21</version>

</dependency>

</dependencies>

• 配置全局配置文件 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="dev">

<environment id="dev">

<transactionManager type="JDBC"></transactionManager>

<dataSource type="POOLED">

<property name="driver" value="com.mysql.jdbc.Driver"/>

<property name="url" value="jdbc:mysql:///table"/>

<property name="username" value="root"/> <property name="password" value="root"/>

</dataSource> </environment> </environments>

<mappers>

<mapper resource="com/xingxue/mybatis/mapper/UserMapper.xml"/>

</mappers>

</configuration>

• 配置 mapper 映射文件
• 

• 代码如下：

• <?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="test">
• <!-- insert 标签会被mybatis封装成一个 statement对象 -->
• <insert id="add"> INSERT INTO TBL_USER (NAME,BIRTH,PASSWORD)VALUES(#{name},#{birth},#{password}) </insert>
• </mapper>
  
  测试：
• 

  代码如下：

• private static void insert() throws IOException { InputStream is = Resources.getResourceAsStream("SqlMapConfig.xml");
• SqlSessionFactoryBuilder sb = new SqlSessionFactoryBuilder(); SqlSessionFactory factory = sb.build(is);
• //得到了 SqlSession
• SqlSession session = factory.openSession();
• UserModel u = new UserModel();
• u.setBirth(new Date()); u.setPassword("111");
• u.setName("test2");
• //插入操作
• session.insert("test.add",u);
• //提交事务
• session.commit(); }
  
  

  Mybtais 的核心对象API

  Resources 对象 ：通过 类加载器获取文件数据

  SqlSessionFactoryBuilder 对象: 创建 SqlSessionFactory 对象实例

  SqlSessionFactory 对象: 创建一个 Connection 或者说 SqlSession 对象

  SqlSession 对象：执行 sql 命令 以及管理事务 (掌握)，该对象线程不安全

以下代码告诉mybatis读取配置文件的规则：

<build>
<resources>
<resource>
<directory>src/main/java</directory>
<includes>
<include>**/*.xml</include>
</includes>
<filtering>false</filtering>
</resource>
<resource>
<directory>src/main/resources</directory>
<includes>
<include>**/*.xml</include>
<include>**/*.properties</include>
</includes>
<filtering>false</filtering>
</resource>
</resources>
</build>

 

 

转载于:https://www.cnblogs.com/www-yusheng-com/p/8885998.html