使用MyBatis的开发步骤
1.下载mybatis-3.5.1.jar
2.将所需jar文件导入工程
3.编写MyBatis核心配置文件
4.创建实体类(POJO)
5.定义DAO层Mapper接口
6.定义SQL映射文件
7.创建测试类
- 读取MyBatis核心配置文件
- 创建SqISessionFactory实例
- 创建SqlSession实例
- 创建Mapper实例执行SQL映射文件中的SQL语句
一.下载mybatis-3.5.1.jar
(1)导入Mybatis开发包
mybatis-3.1.1.jar
commons-logging-1.1.1.jar
log4j-1.2.16.jar
cglib-2.2.2.jar
asm-3.3.1.jar
(2)导入mysql/oracle开发包
mysql-connector-java-5.1.7-bin.jar
Oracle 11g 11.2.0.1.0 JDBC_ojdbc6.jar
2.mybatis的下载和安装
(1)将下载的mybatis-3.5.5.zip进行解压,
(2)将mybatis-3.5.5.jar,lib 路径下的所有jar包,还有jdbc所需要的 导入项目,其中 log4j-1.2.17.jar 是用来输出日志的包,并且需要把数据库对应jdbc驱动包导入到项目。
二.导入jar包
junit
<dependencies>
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>4.12</version>
</dependency>
mybatis
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.5.2</version>
</dependency>
mysql数据库
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.47</version>
</dependency>
spring相关
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-webmvc</artifactId>
<version>5.1.9.RELEASE</version>
</dependency>
<!--Spring操作数据库的话,还需要一个spring-jdbc-->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-jdbc</artifactId>
<version>5.1.9.RELEASE</version>
</dependency>
aop织入
<!-- Aop注入包-->
<dependency>
<groupId>org.aspectj</groupId>
<artifactId>aspectjweaver</artifactId>
<version>1.8.13</version>
</dependency>
mybatis-spring【new】
<!-- mybatis和spring整合的包-->
<!-- https://mvnrepository.com/artifact/org.mybatis/mybatis-spring -->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis-spring</artifactId>
<version>2.0.2</version>
</dependency>
<dependency>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
<version>1.16.10</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-jdbc</artifactId>
<version>5.3.19</version>
<scope>compile</scope>
</dependency>
三.编写MyBatis核心配置文件
<?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 resource="jdbc.properties"></properties>
<!-- 设置类型别名,以包为单位,包下所有的类都有默认的别名(类名且不区分大小写) -->
<typeAliases>
<!-- 完善实体类所在的包路径(截止到包)如<package name="com.hrp.entity"/> -->
<package name=""/>
</typeAliases>
<!--
<environments default="development">中default的值可以是
1.测试环境(测试员使用):使用的环境是独立的 ->test
2.开发环境(开发使用):使用的环境是独立的 ->dev
3.生产环境(客户使用):使用的环境是独立的 ->prod
-->
<environments default="development">
<environment id="development">
<transactionManager type="JDBC"/>
<!-- 数据源-->
<dataSource type="POOLED">
<!-- 获取数据库连接配置文件中的key -->
<property name="driver" value="${jdbc.driver}"/>
<property name="url" value="${jdbc.url}"/>
<property name="username" value="${jdbc.username}"/>
<property name="password" value="${jdbc.password}"/>
</dataSource>
</environment>
</environments>
<!-- 映射文件-->
<mappers>
<!--
完善映射文件所在的路径
1.mapper接口所在的包和映射文件所在的路径/包一致
2.mapper接口的名字与映射文件的名字要一致
如:<package name="com.hrp.mapper"/>
-->
<package name=""/>
</mappers>
</configuration>
四.创建实体类(POJO)
private long id;
private String name;
private String pwd;
public Users(String name, String pwd) {
this.name = name;
this.pwd = pwd;
}
public Users(long id, String name, String pwd) {
this.id = id;
this.name = name;
this.pwd = pwd;
}
public Users() {
}
public long getId() {
return id;
}
public void setId(long id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getPwd() {
return pwd;
}
public void setPwd(String pwd) {
this.pwd = pwd;
}
@Override
public String toString() {
return "Users{" +
"id=" + id +
", name='" + name + '\'' +
", pwd='" + pwd + '\'' +
'}';
}
五.定义DAO层Mapper接口
public interface UserMapper {
List<Users>selectAllReList();
int deleteById(Integer id);
int insert(Users users);
int updateById(Users users);
}
六.定义SQL映射文件
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"https://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.mybatis.mapper.UserMapper">
<select id="selectAllReList" resultType="com.mybatis.Users">
select * from users
</select>
<delete id="deleteById">
delete from users where id > #{id}
</delete>
<insert id="insert">
INSERT INTO `users` ( `name`, `pwd`) VALUES (#{name},#{pwd});
</insert>
<update id="updateById">
UPDATE`users` SET `name` = #{name}, `pwd` = #{pwd} WHERE `id` = #{id};
</update>
</mapper>
七.创建测试类
import com.mybatis.Users;
import com.mybatis.mapper.UserMapper;
import com.mybatis.util.SqlSessionUtil;
import org.apache.ibatis.session.SqlSession;
import org.junit.Test;
import java.util.List;
public class TestMybatis {
/**
* 查询
*/
@Test
public void testSelectUserReList(){
SqlSession sqlSession = SqlSessionUtil.openSession();
UserMapper mapper = sqlSession.getMapper(UserMapper.class);
List<Users> users = mapper.selectAllReList();
for (Users user : users) {
System.out.println(user);
}
sqlSession.close();
}
/**
* 删除
*/
@Test
public void testDeleteById(){
SqlSession sqlSession = SqlSessionUtil.openSession();
UserMapper mapper = sqlSession.getMapper(UserMapper.class);
int count = mapper.deleteById(43);
System.out.println(count);
sqlSession.commit();
sqlSession.close();
}
/**
* 新增
*/
@Test
public void testInsert(){
SqlSession sqlSession = SqlSessionUtil.openSession();
UserMapper mapper = sqlSession.getMapper(UserMapper.class);
Users users=new Users("san","1234");
int count = mapper.insert(users);
System.out.println(count);
sqlSession.commit();
sqlSession.close();
}
/**
* 修改
*/
@Test
public void testUpdateBYId(){
SqlSession sqlSession = SqlSessionUtil.openSession();
UserMapper mapper = sqlSession.getMapper(UserMapper.class);
Users users=new Users(26,"乐扣","123456");
int count = mapper.updateById(users);
System.out.println(count);
sqlSession.commit();
sqlSession.close();
}
}