mybatis的开发流程
1.mybatis框架
ORM就是通过实例对象的语法,完成关系型数据库的操作的技术,是“对象-关系型映射”(Object/Relational/Mapping)的缩写。
数据库:SQL
java:面向对象
jdbc五部曲不适合商业开发。
java(面向对象)——>mybatis(java/xml)——>数据库(表)sql
2.mybatis开发流程
2.1 数据库
2.1.1 创建库
2.1.2 创建表book_tab
2.2 后台
2.2.1 创建表的实体映射类(entity)
/**
* 映射数据库的表book_tab
* @author Administrator
*
*/
@Alias("Book")
@Data
@NoArgsConstructor
@AllArgsConstructor
public class Book {
private Integer id;
private String isbn;
private String title;
private String author;
private String cover;
private Double price;
private Date date;
}
2.2.2定义接口,表操作(mapper/dao)
/**
* 表的操作接口
* @author Administrator
*
*/
public interface IBookMapper {
void save(Book book);
void delete(int id);
void update(Book book);
List<Book> findAll();
}
2.2.3 重定义数据源(util)
使用druid数据源替换mybatis内置的druid
/**
* 重定义数据源对象
*
* @author Administrator
*
*/
public class MybatisDataSource extends UnpooledDataSourceFactory {
public MybatisDataSource() {
this.dataSource = new DruidDataSource();
}
}
2.3 相关配置文件
2.3.1 druid.properties
druid.driver = com.mysql.cj.jdbc.Driver
druid.url = jdbc:mysql://localhost:3306/mybatis_db?useUnicode=true&characterEncoding=utf8&useSSL=false&serverTimezone=UTC&allowPublicKeyRetrieval=true
druid.username=root
druid.password=123456
2.3.2 mybatis-comfig.xml
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="resources/druid/druid.properties"/>
<environments default="development">
<environment id="development">
<transactionManager type="JDBC"/><!-- 配置数据库事务管理 -->
<dataSource type="com.dyit.util.MybatisDataSource">
<property name="driverClassName" value="${druid.driver}"/>
<property name="url" value="${druid.url}"/>
<property name="username" value="${druid.username}"/>
<property name="password" value="${druid.password}"/>
</dataSource>
</environment>
</environments>
<!-- 表和类之间的映射 -->
<mappers>
</mappers>
</configuration>
2.3.2 xxx.mapper.xml
类名.mapper.xml
nameSpace->接口的位置
sql语句
更新config
xxxxxxxxxx <?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="com.dyit.mapper.IBookMapper"><!-- 接口的位置 --> <insert id="save"> INSERT INTO book_tab(book_isbn,book_title,book_author,book_date,book_price,book_cover) VALUES(#{isbn},#{title},#{author},#{date},#{price},#{cover}) </insert></mapper>
<?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="resources/druid/druid.properties"/>
<environments default="development">
<environment id="development">
<transactionManager type="JDBC"/><!-- 配置数据库事务管理 -->
<dataSource type="com.dyit.util.MybatisDataSource">
<property name="driverClassName" value="${druid.driver}"/>
<property name="url" value="${druid.url}"/>
<property name="username" value="${druid.username}"/>
<property name="password" value="${druid.password}"/>
</dataSource>
</environment>
</environments>
<!-- 表和类之间的映射,mapper文件创建之后再配置 -->
<mappers>
<mapper resource="resources/mapper/Book.mapper.xml"/>
</mappers>
</configuration>