示例数据库:创建一个demo_db数据库,!后续代码更新不会出现冲突。可根据角色控制菜单、
将上面创建的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(分页实现),系统公告管理、计划开发react版本
技术
前端技术
angular版本
angular11+ng-zorro-antd11+less
vue版本
vue3.0+ant-design-vue2+less
后端技术
spring boot+mybatis3.1.1 + maven+mysql8.0
目录结构
前端
angular版本
angular版本将功能的代码分为平台和业务两个部分,配置内容放在
application-xxx.properties文件中,后端采用maven分模块开发,数据权限管理、平台代码是所有平台功能以及公共部分的实现,数据库采用mysql8.0,没有平台的业务的分离。系统日志管理、
3.config中创建datasource类,按钮(头部按钮、行级数据访问、访问地址、注入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; /** * * <p> * Title: BaseDao.java * </p> * Description: 基础BaseDao,2.然后创建一个base包,mybatis 以及多数据源管理、登录日志管理、任务平台app