文章目录
(一)Mybatis环境搭建
(1)mybatis下载
mybaits的代码由github.com管理
下载地址:https://github.com/mybatis/mybatis-3/releases
(2)导入jar包
测试相关的包: junit hamcrest
日志相关的包:log4j-1.2.16 slf4-api slf4j-log4j12
数据库相关jar包: mysql-connector
Mybatis先关jar包: mybaits-3.4.5
<dependencies>
<!-- junit-->
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>4.11</version>
<scope>test</scope>
</dependency>
<!-- MySql -->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.32</version>
</dependency>
<!-- Mybatis -->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.4.5</version>
</dependency>
<!--日志包-->
<dependency>
<groupId>org.slf4j</groupId>
<artifactId>slf4j-log4j12</artifactId>
<version>1.7.25</version>
</dependency>
<dependency>
<groupId>log4j</groupId>
<artifactId>log4j</artifactId>
<version>1.2.17</version>
</dependency>
</dependencies>
(3)导入jar包log4j.properties
Global logging configuration
log4j.rootLogger=DEBUG, stdout
Console output…
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern=%5p [%t] - %m%n
(二)Mybatis的操作步骤
(1)mybatis开发流程
》1 创建SqlSessionFactoryBuilder对象
》2 创建SqlSessionFactory对象
》3 加载SqlMapConfig.xml配置文件
》4 创建SqlSession对象
》5 执行SqlSession对象执行删除
》6 打印结果
》7 释放资源
Mybatis的入门案例-Java代码编写
(1)先获取Session
(2)再进行增删改查操作
src\test\java\com\wzx\pack01\Test01Myabatis.java
public class Test01Myabatis {
@Test
public void test01(){
// 》1 创建SqlSessionFactoryBuilder对象
SqlSessionFactoryBuilder sqlSessionFactoryBuilder = new SqlSessionFactoryBuilder();
// 》2 创建SqlSessionFactory对象
InputStream inputStream = Test01Myabatis.class.getClassLoader().getResourceAsStream("SqlMapConfig.xml");
SqlSessionFactory sessionFactory = sqlSessionFactoryBuilder.build(inputStream);//加载核心配置文件 参1 输入流
// 》3 加载SqlMapConfig.xml配置文件
// 》4 创建SqlSession对象
SqlSession sqlSession = sessionFactory.openSession();
// 》5 执行SqlSession对象执行删除
System.out.println(sqlSession);
//delete from user where id = ?
sqlSession.delete("com.wzx.bean.User.deleteById"</