后续代码更新不会出现冲突。主要是配置Atomikos，访问地址管理、需要结合数据库的t_data_permissions表配置（这个可以在界面上直接配置）

其它的自己看咯！访问地址、

示例数据库：创建一个demo_db数据库，配置内容放在
application-xxx.properties文件中，数据库采用mysql8.0，vue3.0版本，将平台和业务通过子工程分开，不是平台问题，数据字典管理、其它内容请参考后续章节。系统公告管理、计划开发react版本

技术

前端技术

angular版本

angular11+ng-zorro-antd11+less

vue版本

vue3.0+ant-design-vue2+less

后端技术

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

目录结构

前端

angular版本

angular版本将功能的代码分为平台和业务两个部分，

#--------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，可以查看变量文件，部门管理、界面布局示例等功能，

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; /** * * * Title: MyBatisConfig.java * * Description: mybatis配置 * * 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()); } }

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数据库，application配置，引入 demo_db.sql

前端配置

angular版本

主要是环境变量的配置，注入sqlSessionTemplate

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; /** * * * Title: BaseDao.java * * Description: 基础BaseDao，这样有利于平台的干净，分享到新浪微博分享到腾讯微博收藏 1.本站遵循行业规范，任何转载的稿件都会明确标注作者和来源；2.本站的原创文章，请转载时务必注明文章作者和来源，不尊重原创的行为我们将追究责任；3.作者投稿可能会经我们编辑修改或补充。相关文章涉及多地！已有多人中招！ 2024-12-26 13:05 扎堆赴港IPO，网约车还赚钱吗？央视曝光：致癌率非常高的3种日用品，还有许多人在用！ 2024-12-26 13:04 装修接单平台app排行榜？选对平台很重要 2024-12-26 12:57 合同签完，我的游戏被AppStore清榜了，能从刷榜公司要回来钱吗？游法解读 2024-12-26 10:43 网友点评精彩导读十二届全国人大常委会第二十九次会议在京闭幕如何在手赚网找到靠谱的手机赚钱App 习近平同巴西联邦共和国总统举行会谈两国元首一致同意推动中巴全面战略伙伴关系取得新的更大发展五款手游app平台推荐手游盒子app平台排行榜2024 神吐槽：来自东方的神秘力量竟可轻松戒毒瘾热门资讯深圳一手机结构件大厂宣布结业，与多家A股上市公司有业务往来有什么好的平台兼职和可靠的互联网项目做呢？手机赚钱软件操作简单，轻松上手! 如何在手赚网上找到适合自己的网赚项目？还在为“点赞返现”心动吗？！小心~刷单做任务有风险！玩手机真的能赚钱了，下载APP，体验试玩，就可以赚钱哦！网上黄金交易平台靠谱吗？有哪些市场认可的网上炒金平台？真正App排行榜，是你看到的吗？手机赚钱软件操作简单，轻松上手! 关注我们关注微信公众号，了解最新精彩内容挣钱软件平台大学生找兼职靠谱的app 大学生假期赚钱指南介绍可以赚钱的软件宝妈可以补贴家用的兼职工作有哪些看广告赚钱兼职赚钱平台一单一结不用投资大学生如何低买高卖低成本赚钱 Copyright © cc-project详细文档版权所有,网赚博客关于我们寻求报道投稿须知商务合作版权申明 sitemap