mybatis集成spring,mybatis注解版
mybatis集成spring
步骤
1.导包(依赖)
mybatis
mysql
Druid连接池
<!--mybatis--> <dependency> <groupId>org.mybatis</groupId> <artifactId>mybatis</artifactId> <version>3.5.4</version> </dependency> <!--jdbc--> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <version>8.0.20</version> </dependency> <dependency> <groupId>com.alibaba</groupId> <artifactId>druid</artifactId> <version>1.1.22</version> </dependency>
spring-webmvc通过spring来管理对象
mybatis集成spring
mybatis-spring
mybatis依赖spring-jdbc来进行实务管理
<!--通过spring来管理对象--> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-webmvc</artifactId> <version>5.2.7.RELEASE</version> </dependency> <!--mybatis集成spring--> <dependency> <groupId>org.mybatis</groupId> <artifactId>mybatis-spring</artifactId> <version>2.0.4</version> </dependency> <!--mybatis依赖spring-jdbc来进行事务处理--> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-jdbc</artifactId> <version>5.2.7.RELEASE</version> </dependency>
创建文件夹
2.添加spring配置文件
配置app.xml文件
配置mybatis相关bean
配置数据源
配置mapper映射器
<!--配置mybatis相关bean --> <bean class="org.mybatis.spring.SqlSessionFactoryBean"> <!--配置数据源(告诉mybatis怎么连接数据库)--> <property name="dataSource" ref="dataSource"></property> </bean> <util:properties id="mysql" location="classpath:mysql.properties"></util:properties> <!--配置数据源--> <bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource"> <property name="driverClassName" value="#{mysql.driver}"></property> <property name="url" value="#{mysql.url}"></property> <property name="username" value="#{mysql.username}"></property> <property name="password" value="#{mysql.password}"></property> <property name="initialSize" value="#{mysql.init}"></property> <property name="maxActive" value="#{mysql.max}"></property> </bean> <!--配置mapper映射器--> <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer"> <property name="basePackage" value="com.demo.dao"></property> </bean>
配置mysql.properties文件
driver:com.mysql.cj.jdbc.Driver url:jdbc:mysql://localhost:3306/demo?serverTimezone=UTC username:root password:root init:3 max:4
根据自己的情况进行修改
3.编写Dao层接口
创建接口
public interface DeptDao { //#{}是占位符 {}中的名称可以自己定义 与方法的参数名可以不一致 @Select("select * from dept where deptno = #{id}") public Dept findById(int id); }
创建类
@Data public class Dept { private int deptno; private String dnam; private String loc; }
引入lombok依赖
<dependency> <groupId>org.projectlombok</groupId> <artifactId>lombok</artifactId> <version>1.18.12</version> </dependency>
dept.sql
SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for dept -- ---------------------------- DROP TABLE IF EXISTS `dept`; CREATE TABLE `dept` ( `DEPTNO` int(2) DEFAULT NULL, `DNAME` varchar(255) DEFAULT NULL, `LOC` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of dept -- ---------------------------- INSERT INTO `dept` VALUES ('10', 'ACCOUNTING', 'NEW YORK'); INSERT INTO `dept` VALUES ('20', 'RESEARCH', 'DALLAS'); INSERT INTO `dept` VALUES ('30', 'SALES', 'CHICAGO'); INSERT INTO `dept` VALUES ('40', 'OPERATIONS', 'BOSTON');
然后就完成了
加油哦