您好,登錄后才能下訂單哦!
1、創(chuàng)建項(xiàng)目maven,方便依賴下載。使用的jar如下:
<dependencies> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-context</artifactId> <version>5.0.8.RELEASE</version> </dependency> <dependency> <groupId>org.mybatis</groupId> <artifactId>mybatis-spring</artifactId> <version>2.0.0</version> </dependency> <dependency> <groupId>org.mybatis</groupId> <artifactId>mybatis</artifactId> <version>3.4.6</version> </dependency> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <version>5.1.34</version> </dependency> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-jdbc</artifactId> <version>5.0.8.RELEASE</version> </dependency> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-core</artifactId> <version>5.0.8.RELEASE</version> </dependency> </dependencies>
2、創(chuàng)建包c(diǎn)om >config、dao、service、test
3、使用spring創(chuàng)建AppConfig文件,創(chuàng)建Bean>SqlSessionFactoryBean、DataSourceBean
1、spring注解@Configuration,說(shuō)明是配置層
2、注冊(cè)掃描映射
3、注冊(cè)包掃描器
4、創(chuàng)建SqlSessionFactoryBean
5、創(chuàng)建數(shù)據(jù)源Bean
package com.config; import org.mybatis.spring.SqlSessionFactoryBean; import org.mybatis.spring.annotation.MapperScan; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.context.annotation.Bean; import org.springframework.context.annotation.ComponentScan; import org.springframework.context.annotation.Configuration; import org.springframework.jdbc.datasource.DriverManagerDataSource; import javax.sql.DataSource; @Configuration @MapperScan("com.dao")//注解 與XML<mybatis:scan base-package="org.mybatis.spring.sample.mapper" /> //注冊(cè)包中遞歸搜索映射器 @ComponentScan("com")//注冊(cè)Bean public class AppConfig { @Bean @Autowired public SqlSessionFactoryBean sqlSessionFactoryBean(DataSource dataSource ){ SqlSessionFactoryBean sqlSessionFactoryBean = new SqlSessionFactoryBean(); sqlSessionFactoryBean.setDataSource(dataSource); return sqlSessionFactoryBean; } @Bean public DataSource getDataSource(){ DriverManagerDataSource dataSource = new DriverManagerDataSource(); dataSource.setDriverClassName("com.mysql.jdbc.Driver"); dataSource.setUsername("root"); dataSource.setPassword("110226wjwj"); dataSource.setUrl("jdbc:mysql://localhost:3306/mybatis_wjw?useUnicode=true&characterEncoding=UTF-8&useSSL=false"); return dataSource; } }
4、創(chuàng)建Dao接口
1、創(chuàng)建query方法并使用注解@Select(Mybatis提供,mybatis-spring官網(wǎng)有相關(guān)解釋)
package com.dao; import org.apache.ibatis.annotations.Select; import java.util.List; import java.util.Map; public interface UserDao { @Select ("select * from t_user where tid =3") public List<Map> query(); }
5、創(chuàng)建服務(wù)層
1、注解服務(wù)層
2、引入DaoBean
package com.service; import com.dao.UserDao; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; //spring注解中service與component意思差不多,區(qū)別在于component是中立注解,而service是業(yè)務(wù)邏輯層的注解 //@Component @Service public class UserService { @Autowired UserDao userDao; public void query(){ System.out.println(userDao.query()); } }
6、測(cè)試
1、創(chuàng)建application
2、創(chuàng)建service
package com.test; import com.config.AppConfig; import com.service.UserService; import org.springframework.context.annotation.AnnotationConfigApplicationContext; public class MainTest { public static void main(String args[]){ AnnotationConfigApplicationContext acc = new AnnotationConfigApplicationContext(AppConfig.class); UserService us = acc.getBean(UserService.class); us.query(); } }
jar包之家:https://mvnrepository.com/artifact
使用spring依賴注入mapper 根據(jù)官網(wǎng)提示需要
<mybatis:scan base-package="org.mybatis.spring.sample.mapper" />==@MapperScan(“需要注入的包”)
mybatis缺點(diǎn):使用XML方式與dao開(kāi)發(fā)結(jié)合出現(xiàn)嚴(yán)重的臃腫現(xiàn)象,需要維護(hù)很多sql語(yǔ)句。
測(cè)試的時(shí)候出現(xiàn)這個(gè)問(wèn)題。(版本導(dǎo)致,我直接將最新[mybatis-spring]的導(dǎo)入進(jìn)來(lái)就沒(méi)問(wèn)題了)
上面的問(wèn)題解決后有出現(xiàn)這個(gè)問(wèn)題,此問(wèn)題出現(xiàn)的原因是java compiler改成8就OK了
測(cè)試結(jié)果:
重點(diǎn):
mybatis運(yùn)行原理
我們可以看到,再測(cè)試類中用的是UserService對(duì)象調(diào)用Dao接口中的query,但是mybatis是如何實(shí)現(xiàn)將接口轉(zhuǎn)換成對(duì)象的呢? 答案:動(dòng)態(tài)代理 ,我們常用的代理(proxy)一共有兩種:cglib和jdk兩用代理模式
無(wú)論哪一種最終都是使用反射機(jī)制進(jìn)行代理。詳情自己查看度娘(哈哈@0@)
mybatis源碼解析
DefaultSqlSession下如何實(shí)現(xiàn)返回一條數(shù)據(jù)的:底層調(diào)用的是selectList方法,對(duì)返回的結(jié)果集進(jìn)行數(shù)量判斷如果==1則直接放回,>1直接拋出TooManyResultsException(感覺(jué)很傻,有些妄自菲?。。?/p>
public <T> T selectOne(String statement, Object parameter) { List<T> list = this.selectList(statement, parameter); if (list.size() == 1) { return list.get(0); } else if (list.size() > 1) { throw new TooManyResultsException("Expected one result (or null) to be returned by selectOne(), but found: " + list.size()); } else { return null; } }
下面我們繼續(xù)看selectList是如何實(shí)現(xiàn)的
public <E> List<E> selectList(String statement, Object parameter, RowBounds rowBounds) { List var5; try { MappedStatement ms = this.configuration.getMappedStatement(statement); var5 = this.executor.query(ms, this.wrapCollection(parameter), rowBounds, Executor.NO_RESULT_HANDLER); } catch (Exception var9) { throw ExceptionFactory.wrapException("Error querying database. Cause: " + var9, var9); } finally { ErrorContext.instance().reset(); } return var5; }
我們來(lái)看看這個(gè)defaultSqlSession.configuration.getMappedStatement方法具體是什么
結(jié)論:再啟動(dòng)項(xiàng)目的時(shí)候,mybatis會(huì)進(jìn)行初始化,這個(gè)初始化就是將我們的"包+類+方法名"作為key 和 sql語(yǔ)句作為value 的鍵值對(duì)形式賦給下面Map類型的mappedStatements
protected final Map<String, MappedStatement> mappedStatements;
這也是為什么我們使用XML方式一定要將方法名字與id對(duì)應(yīng)上才能使用,如果對(duì)應(yīng)不上再進(jìn)行Id傳值的時(shí)候找不到對(duì)應(yīng)的key。
繼續(xù)往下分析:
已發(fā)帖子詢問(wèn)大神具體是什么原因?qū)е虏贿M(jìn)入124行,等大佬們回答后我將公布結(jié)果。直接看看executor是什么鬼
是一個(gè)接口,https://blog.csdn.net/ykzhen2015/article/details/50315027
protected Set<BeanDefinitionHolder> doScan(String... basePackages) { Assert.notEmpty(basePackages, "At least one base package must be specified"); Set<BeanDefinitionHolder> beanDefinitions = new LinkedHashSet(); String[] var3 = basePackages; int var4 = basePackages.length; for(int var5 = 0; var5 < var4; ++var5) { String basePackage = var3[var5]; Set<BeanDefinition> candidates = this.findCandidateComponents(basePackage); Iterator var8 = candidates.iterator(); while(var8.hasNext()) { BeanDefinition candidate = (BeanDefinition)var8.next(); ScopeMetadata scopeMetadata = this.scopeMetadataResolver.resolveScopeMetadata(candidate); candidate.setScope(scopeMetadata.getScopeName()); String beanName = this.beanNameGenerator.generateBeanName(candidate, this.registry); if (candidate instanceof AbstractBeanDefinition) { this.postProcessBeanDefinition((AbstractBeanDefinition)candidate, beanName); } if (candidate instanceof AnnotatedBeanDefinition) { AnnotationConfigUtils.processCommonDefinitionAnnotations((AnnotatedBeanDefinition)candidate); } if (this.checkCandidate(beanName, candidate)) { BeanDefinitionHolder definitionHolder = new BeanDefinitionHolder(candidate, beanName); definitionHolder = AnnotationConfigUtils.applyScopedProxyMode(scopeMetadata, definitionHolder, this.registry); beanDefinitions.add(definitionHolder); this.registerBeanDefinition(definitionHolder, this.registry); } } } return beanDefinitions; }
關(guān)于mybatis中的executor與一級(jí)緩存的關(guān)系:https://www.jb51.net/article/159394.htm
這里引出一個(gè)經(jīng)典問(wèn)題,關(guān)于mybatis一級(jí)緩存問(wèn)題,這個(gè)緩存存儲(chǔ)在session中,當(dāng)sql關(guān)閉的時(shí)候就會(huì)自動(dòng)銷毀,涉及到mybatis中的session生命周期問(wèn)題
為什么mybatis與spring結(jié)合后一級(jí)緩存會(huì)失效?以為SqlSession是由SqlSessionFactoryBean生成,二這個(gè)SqlSessionFactoryBean是由spring管理,也就是此時(shí)的session是由spring進(jìn)行管理的并不是mybatis管理,所以此時(shí)session緩存會(huì)失效。
public interface Executor { ResultHandler NO_RESULT_HANDLER = null; int update(MappedStatement var1, Object var2) throws SQLException; <E> List<E> query(MappedStatement var1, Object var2, RowBounds var3, ResultHandler var4, CacheKey var5, BoundSql var6) throws SQLException; <E> List<E> query(MappedStatement var1, Object var2, RowBounds var3, ResultHandler var4) throws SQLException; <E> Cursor<E> queryCursor(MappedStatement var1, Object var2, RowBounds var3) throws SQLException; List<BatchResult> flushStatements() throws SQLException; void commit(boolean var1) throws SQLException; void rollback(boolean var1) throws SQLException; CacheKey createCacheKey(MappedStatement var1, Object var2, RowBounds var3, BoundSql var4); boolean isCached(MappedStatement var1, CacheKey var2); void clearLocalCache(); void deferLoad(MappedStatement var1, MetaObject var2, String var3, CacheKey var4, Class<?> var5); Transaction getTransaction(); void close(boolean var1); boolean isClosed(); void setExecutorWrapper(Executor var1); }
mybatis-spring依賴中MapperScannerRegistrar的作用:registerBeanDefinitions方法中的doScan()此方法是將Mapper掃描到初始化中。原理就是獲取到項(xiàng)目路徑找到對(duì)應(yīng)的classes路徑,獲取了com.dao包名,將獲取的路徑+包名轉(zhuǎn)成文件夾,循環(huán)獲取文件夾下面的文件(UserDao.class),然后使用將UserDao拿到。此時(shí)包名+類名都拿到后使用Class.forName(包名+類名)反射出對(duì)象,進(jìn)行bean注冊(cè)
總結(jié)運(yùn)行原理:
初始化信息(數(shù)據(jù)庫(kù)連接信息,掃描mapper包中的class用于創(chuàng)建bean對(duì)象,spring中的類applicationFactory用于創(chuàng)建變對(duì)象、mapper中的xml的id與sql放到MapperStatement對(duì)象中)
其中對(duì)于掃描mapper包中的class路徑+參數(shù)basePackages轉(zhuǎn)成文件夾,然后循環(huán)找到所有的類名,使用.......(請(qǐng)看MapperScannerRegistrar引出的doScan方法)
執(zhí)行過(guò)程:根據(jù)SqlSessionFactoryBean創(chuàng)建出sqlSession,調(diào)用selectList方法,之后根據(jù)參數(shù)(nameSpaceName+id)作為key找到MapperStatement對(duì)象中存儲(chǔ)的value獲取到sql語(yǔ)句,再有Executor(mybatis默認(rèn)使用 CacheExecutor)執(zhí)行sql語(yǔ)句查詢出結(jié)果集
免責(zé)聲明:本站發(fā)布的內(nèi)容(圖片、視頻和文字)以原創(chuàng)、轉(zhuǎn)載和分享為主,文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng),如果涉及侵權(quán)請(qǐng)聯(lián)系站長(zhǎng)郵箱:is@yisu.com進(jìn)行舉報(bào),并提供相關(guān)證據(jù),一經(jīng)查實(shí),將立刻刪除涉嫌侵權(quán)內(nèi)容。