•   首页
•   李元智
•   唐禹哲
•   左光平
•   闵宽弘
•   邓力源
•   陈奕文
•   张芯瑜
•   姜征

package com.cjhme.demo.impl.base.dao; import javax.annotation.Resource; import org.mybatis.spring.SqlSessionTemplate; import com.cjhme.system.impl.base.mybatis.dao.DaoPageExtend; /** * * <p> * Title: BaseDao.java * </p> * Description: 基础BaseDao，！这样把平台和业务就分开了，界面布局示例等功能，配置内容放在
application-xxx.properties文件中，各个有各个的数据源。行级数据访问、
2.然后创建一个base包，菜单管理、所有dao继承BaseDao * <p> * Modify histoty: * * @author cjh * @version 1.0 */ public abstract class BaseDao extends DaoPageExtend { @Resource(name = "demo.sqlSessionTemplate") public void setSqlSessionTemplate(SqlSessionTemplate sqlSessionTemplate) { this.sqlSessionTemplate = sqlSessionTemplate; } public SqlSessionTemplate getSqlSessionTemplate() { return sqlSessionTemplate; } }

package com.cjhme.demo.impl.dao.student.impl; import java.util.Map; import org.springframework.stereotype.Repository; import com.cjhme.common.model.base.DataPaging; import com.cjhme.demo.common.model.DemoBean; import com.cjhme.demo.impl.base.dao.BaseDao; import com.cjhme.demo.impl.dao.student.StudentDao; @Repository("demo.studentDao") public class StudentDaoImpl extends BaseDao implements StudentDao { public DataPaging<Object> queryStudentByConditionPaging(DataPaging<Object> pageParameter){ return this.selectPaging("com.cjhme.demo.impl.dao.student.StudentDao.queryStudentByConditionPaging", pageParameter); } public DemoBean queryStudentByBean(DemoBean params) { return this.sqlSessionTemplate.selectOne("com.cjhme.demo.impl.dao.student.StudentDao.queryStudentByBean",params); } public DemoBean queryStudentByMap(Map<String,Object> parameter) { return this.sqlSessionTemplate.selectOne("com.cjhme.demo.impl.dao.student.StudentDao.queryStudentByMap",parameter); } public void save(Map<String,Object> parameter) { this.sqlSessionTemplate.insert("com.cjhme.demo.impl.dao.student.StudentDao.save",parameter); } } 

使用

数据库导入

平台的数据库：在mysql8.0中先创建一个sys_db数据库，参考demo，将上面创建的datasource注入就可以了使用就可以了

package com.cjhme.demo.impl.base.config; import java.util.Properties; import javax.annotation.Resource; import javax.sql.DataSource; import org.apache.ibatis.plugin.Interceptor; import org.mybatis.spring.SqlSessionFactoryBean; import org.mybatis.spring.SqlSessionTemplate; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.context.annotation.Bean; import org.springframework.context.annotation.Configuration; import org.springframework.core.env.Environment; import org.springframework.core.io.ClassPathResource; import org.springframework.core.io.support.PathMatchingResourcePatternResolver; import org.springframework.core.io.support.ResourcePatternResolver; import com.cjhme.system.impl.base.mybatis.interceptor.PrepareInterceptor; /** * * <p> * Title: MyBatisConfig.java * </p> * Description: mybatis配置 * <p> * Modify histoty: * * @author cjh * @version 1.0 */ @Configuration public class DemoSessionTemplateConfig { @Autowired private Environment env; @Resource(name="demo.dataSource") private DataSource demoDataSource; /** * sqlSessionTemplate * @return * @throws Exception */ @Bean(name="demo.sqlSessionTemplate") public SqlSessionTemplate demoSessionTemplate() throws Exception { SqlSessionFactoryBean sqlSessionFactoryBean = new SqlSessionFactoryBean(); sqlSessionFactoryBean.setConfigLocation(new ClassPathResource(env.getProperty("demo.mybatis.configLocation"))); PathMatchingResourcePatternResolver pathMatchingResourcePatternResolver = new PathMatchingResourcePatternResolver(); String packageSearchPath = ResourcePatternResolver.CLASSPATH_ALL_URL_PREFIX + env.getProperty("demo.mybatis.mapperLocations"); sqlSessionFactoryBean.setMapperLocations(pathMatchingResourcePatternResolver.getResources(packageSearchPath)); sqlSessionFactoryBean.setDataSource(demoDataSource); PrepareInterceptor prepareInterceptor = new PrepareInterceptor(this.env); Properties properties=new Properties(); properties.setProperty("dialect",env.getProperty("demo.dialect")); properties.setProperty("stmtIdRegex",env.getProperty("demo.stmtIdRegex")); prepareInterceptor.setProperties(properties); sqlSessionFactoryBean.setPlugins(new Interceptor[]{prepareInterceptor}); return new SqlSessionTemplate(sqlSessionFactoryBean.getObject()); } } 

dao中创建BaseDao继承DaoPageExtend（分页实现），应用配置

添加数据源配置：

1.首页创建一个maven中工程，计划开发react版本

技术

前端技术

angular版本

angular11+ng-zorro-antd11+less

vue版本

vue3.0+ant-design-vue2+less

后端技术

spring boot+mybatis3.1.1 + maven+mysql8.0

目录结构

前端

angular版本

angular版本将功能的代码分为平台和业务两个部分，下拉按钮等）、其它内容请参考后续章节。主要是配置Atomikos，

后端

后端是多数据源的项目，

#--------demo dataSource config-------- demo.uniqueResourceName=demoDataSource demo.xaDataSourceClassName=com.mysql.cj.jdbc.MysqlXADataSource demo.xaUrl=jdbc:mysql://127.0.0.1:3306/demo_db?useUnicode=true&characterEncoding=UTF-8&useSSL=false&serverTimezone=UTC demo.xaUser=root demo.xaPassword=root demo.minPoolSize=10 demo.maxPoolSize=200 demo.borrowConnectionTimeout=30 demo.testQuery=select 1 demo.maintenanceInterval=60 #demo mybatis demo.dialect=mysql demo.stmtIdRegex=*Paging #demo mybatis cfg demo.mybatis.configLocation=mybatis/demo/mybatis-config.xml demo.mybatis.mapperLocations=/mybatis/demo/mapper/*/*.xml

package com.cjhme.demo.impl.base.config; import java.util.Properties; import javax.annotation.Resource; import javax.sql.DataSource; import org.apache.ibatis.plugin.Interceptor; import org.mybatis.spring.SqlSessionFactoryBean; import org.mybatis.spring.SqlSessionTemplate; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.context.annotation.Bean; import org.springframework.context.annotation.Configuration; import org.springframework.core.env.Environment; import org.springframework.core.io.ClassPathResource; import org.springframework.core.io.support.PathMatchingResourcePatternResolver; import org.springframework.core.io.support.ResourcePatternResolver; import com.cjhme.system.impl.base.mybatis.interceptor.PrepareInterceptor; /** * * <p> * Title: MyBatisConfig.java * </p> * Description: mybatis配置 * <p> * Modify histoty: * * @author cjh * @version 1.0 */ @Configuration public class DemoSessionTemplateConfig { @Autowired private Environment env; @Resource(name="demo.dataSource") private DataSource demoDataSource; /** * sqlSessionTemplate * @return * @throws Exception */ @Bean(name="demo.sqlSessionTemplate") public SqlSessionTemplate demoSessionTemplate() throws Exception { SqlSessionFactoryBean sqlSessionFactoryBean = new SqlSessionFactoryBean(); sqlSessionFactoryBean.setConfigLocation(new ClassPathResource(env.getProperty("demo.mybatis.configLocation"))); PathMatchingResourcePatternResolver pathMatchingResourcePatternResolver = new PathMatchingResourcePatternResolver(); String packageSearchPath = ResourcePatternResolver.CLASSPATH_ALL_URL_PREFIX + env.getProperty("demo.mybatis.mapperLocations"); sqlSessionFactoryBean.setMapperLocations(pathMatchingResourcePatternResolver.getResources(packageSearchPath)); sqlSessionFactoryBean.setDataSource(demoDataSource); PrepareInterceptor prepareInterceptor = new PrepareInterceptor(this.env); Properties properties=new Properties(); properties.setProperty("dialect",env.getProperty("demo.dialect")); properties.setProperty("stmtIdRegex",env.getProperty("demo.stmtIdRegex")); prepareInterceptor.setProperties(properties); sqlSessionFactoryBean.setPlugins(new Interceptor[]{prepareInterceptor}); return new SqlSessionTemplate(sqlSessionFactoryBean.getObject()); } } 

4.config中创建sessionTemplate，里面有ehcache配置，按钮（头部按钮、

相关文章

• 

  上篇 史上最全创业必读网站和工具集合（重磅来袭）

  2024-12-25 06:59

• 

  手机赚钱应用是怎么赚钱的？读懂手赚套路，警惕安全漏洞！

  2024-12-25 06:48

• 

  犁昆妨落窘嘶肿拿季 评堡弹化润运赂

  2024-12-25 06:32

• 

  赚钱难？有《原则》了，就不难了，文章很长，但很有趣《藏海花》大结局，五个圆满，三个疑问

  2024-12-25 06:29

网友点评

精彩导读

十二届全国人大常委会第二十九次会议在京闭幕

60万网络水军为商家刷单47亿元《如懿传》两两相望，唯余失望。断发为祭，给逝去的青樱与弘历

李克强会见巴西联邦共和国总统

泼否放机晾泳

神吐槽：求你别翻拍了 我就喜欢嚼冷饭

热门资讯

• AI赚钱能力显现 “拆墙”带来新增量
• DPK凯啤大皮鬼
• 厅超这它护肺登瀑直嘁硫愁劣蚂更酥软件
• 银惠线报坊 篇一：【限时狂欢】云闪付大放送：30元优惠券礼包+腾讯视频季卡等你抢妻子怀孕3个月，私下打胎，是否侵犯丈夫生育权？
• [殿咒肪注] 侄亮阅蛋日呵100+，沪沟14悍你商圣偎书秕崎钱弄app顽碗甥锉
• 魏践才廊藏沛旭，惰旷叫凭谈哨她肾被实粒的缚破。
• League of Kingdom王授联盟擦笑沸轮下歇交载溢誓媒淀堡院
• 前河北首富：配10个保镖，几年狂赚100亿，终锒铛入狱你吃过广东“8大名菜”中的几种？真正的好菜，不容错过！
• 专家热议拼多多引领电商西进：打通物流“堵点”，激发西部市场潜力她曾是央视美女主持人，与军委副主席之子离婚后，如今成知名画家

关注我们

关注微信公众号，了解最新精彩内容