SqlSessionFactory是mybatis的基礎中的基礎,必須實例!
邏輯思路:
- 減少代碼冗余,需要封裝mybatisAPI。
- 可以注冊SqlSessionFactoryBean,來完成SqlSessionFactory的實例化。
它的實例化需要(依賴)"mybatis-config.xml"文件,
其中有三大抽象:1、數據源;2、別名;3、注冊mapper
可以把依賴(作為屬性)注入(DI)到SqlSessionFactoryBean中,
來完成SqlSessionFactory的實例化。
pom:junit、webmvc、mysql-connector、spring-jdbc、mybatis、mybatis-spring、lombok
1、spring-dao.xml:bean約束
1
2
3
4
5
6
7
8
|
< beans xmlns = "http://www.springframework.org/schema/beans" xmlns:xsi = "http://www.w3.org/2001/XMLSchema-instance" xmlns:context = "http://www.springframework.org/schema/context" xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd"> </ beans > |
2、db.properties
jdbc.driver=com.mysql.cj.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/數據庫?serverTimezone=GMT%2B8
jdbc.username=root
jdbc.password=123
3、引入數據庫配置文件
<context:property-placeholder location="classpath:db.properties"/>
4、從spring自帶jdbc配置數據源
1
2
3
4
5
6
|
< bean id = "dataSource" class = "org.springframework.jdbc.datasource.DriverManagerDataSource" > < property name = "driverClassName" value = "${jdbc.driver}" /> < property name = "url" value = "${jdbc.url}" /> < property name = "username" value = "${jdbc.username}" /> < property name = "password" value = "${jdbc.password}" /> </ bean > |
5、利用SqlSessionFactoryBean獲取配置SqlSessionFactory實例
1
2
3
4
5
|
< bean id = "sqlSessionFactory" class = "org.mybatis.spring.SqlSessionFactoryBean" > < property name = "dataSource" ref = "dataSource" /> < property name = "mapperLocations" value = "classpath*:mapper/*.xml" /> < property name = "typeAliasesPackage" value = "pojo" /> </ bean > |
6、掃描dao包,同時生成sqlsessionTemplate和注入mapper接口的實現類
1
2
3
4
|
< bean class = "org.mybatis.spring.mapper.MapperScannerConfigurer" > < property name = "basePackage" value = "dao" /> < property name = "sqlSessionFactoryBeanName" value = "sqlSessionFactory" /> </ bean > |
7、加載spring-dao.xml獲取上下文,從而為dao接口自動裝配
ClassPathXmlApplicationContext context = new ClassPathXmlApplicationContext("spring/spring-dao.xml");
StudentDao studentDao = (StudentDao) context.getBean("studentDao");
List<Student> students = studentDao.selectAll();
以上就是本文的全部內容,希望對大家的學習有所幫助,也希望大家多多支持服務器之家。
原文鏈接:https://www.cnblogs.com/mo-jian-ming/p/13285996.html