思路:搭建環境–>導入Mybatis–>編寫代碼–>測試
在.xml文件中,轉譯用&
搭建環境
搭建數據庫
CREATE DATABASE ‘mybatis’;
USE ‘mybatis’;
CREATE TABLE ‘user’ (
‘id’ INT(20) NOT NULL PRIMARY KAY,
‘name’ VARCHAR(30) DEFAULT NULL,
‘pwd’ VARCHAR(30) DEFAULT NULL
)ENGING=INNODB DEFAULT CHARSET = utf8;
INSERT INTO ‘user’(‘id’,‘name’,‘pwd’) values(1,‘Candy’,‘123432’),
(2,‘lucy’,‘123142’),(3,‘lemon’,‘329019’)
新建項目
1.1搭建一個maven項目
1.2刪除src目錄
2.1導入maven依賴
<!-- 父工程 -->
<groupId>com.crystal</groupId>
<artifactId>Mybatis-01</artifactId>
<version>1.0-SNAPSHOT</version>
<!-- 導入依賴 -->
<dependencies>
<!-- mysql驅動 -->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.47</version>
</dependency>
<!-- mybatis -->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.5.2</version>
</dependency>
<!-- junit -->
<dependency>
<groupId>junit</groupId>
<artifictId>junit</artifictId>
<version>4.12</version>
</dependency>
</dependencies>
2.2創建一個模塊
編寫mybatis的核心配置文件
<!-- configuration核心配置文件 -->
<configuration>
<environments default="development">
<environment id="development">
<transactionManager type="JDBC"/>
<dataSource type="POOLED">
<property name="driver" value="com.mysql.jdbc.Driver"/>
<property name="url"
value="jdbc:sqlserver://10.192.21.21:1033/WWIS?useSSL=true&useUnicode=true&characterEncoding=UTF-8"/>
<property name="username" value="wewe"/>
<property name="password" value="123321"/>
</dataSource>
</environment>
</environments>
<mappers>
<mapper resource="org/mybatis/example/BlogMapper.xml"/>
</mappers>
</configuration>
編寫mybatis工具類
public class MybatisUtils{
private static SqlSessionFactory sqlSessionFactory;
static{
String resource = "mybatis-config.xml";
InputStream inputStream = Resources.getResourceAsStream(resource);
SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
}
// sqlSession 完全包含了面向數據庫執行sql命令所需的所有方法
public static SqlSession getSqlSession(){
SqlSession sqlSession = sqlSessionFactory.openSession();
return sqlSession;
}
}
2.3編寫代碼
實體類
Dao接口
package com.crystal.dao;
import com.crystal.pojo.User;
import java.util.List;
public interface UserDao{
List<User> getUserList();
}
接口實現類由原來的UserDaoImpl轉變為一個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">
<!-- namespace=綁定一個對應的Dao/Mapper接口-->
<mapper namespace="com.crystal.dao.UserDao">
<!-- select查詢語句 -->
<select id="getUserList" resultType="com.crystsl.pojo.User">
select * from dl_members where empno = #{empno}
</select>
</mapper>
增刪改必須提交事務
//提交事務
sqlSession.commit();