springboot集成miniDao ### 1、创建一个单独的springboot项目 **1.1、首先新建一个maven工程,下面是pom.xml的配置,引入springboot相关的依赖** ``` <properties> <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding> <maven.compiler.source>1.7</maven.compiler.source> <maven.compiler.target>1.7</maven.compiler.target> </properties> <parent> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-parent</artifactId> <version>1.5.6.RELEASE</version> <relativePath/> <!-- lookup parent from repository --> </parent> <dependencies> <dependency> <groupId>junit</groupId> <artifactId>junit</artifactId> <version>4.11</version> <scope>test</scope> </dependency> <!-- Spring Boot --> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-web</artifactId> </dependency> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-test</artifactId> <scope>test</scope> </dependency> <!--启动时启动内置tomcat --> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-tomcat</artifactId> </dependency> <!--对Jsp支持 --> <dependency> <groupId>org.apache.tomcat.embed</groupId> <artifactId>tomcat-embed-jasper</artifactId> </dependency> <!-- 支持jstl --> <dependency> <groupId>javax.servlet</groupId> <artifactId>jstl</artifactId> <version>1.2</version> </dependency> <!-- MySql驱动 --> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <version>5.1.21</version> </dependency> </dependencies> ``` **1.2、新建一个application类,通过application.java启动项目** ``` @SpringBootApplication public class Application { private static Logger logger = Logger.getLogger(Application.class); public static void main(String[] args) { logger.info("=================开始成功================="); SpringApplication.run(Application.class, args); logger.info("=================启动成功================="); } } ``` **1.3、写一个controller类** ``` @Controller public class IndexController { private static Logger logger = Logger.getLogger(IndexController.class); @RequestMapping("/index") public String index() { logger.info("进入index方法"); return "Hello Spring Boot !"; } } ``` **1.4、运行application.java文件,启动项目** ![输入图片说明](https://static.oschina.net/uploads/img/201807/03113323_FScC.png "在这里输入图片标题") **1.5、在浏览器中访问** ![输入图片说明](https://static.oschina.net/uploads/img/201807/03113521_Votm.png "在这里输入图片标题") ### 2、springboot整合miniDao **2.1、首先需要在pom.xml中加入miniDao所需依赖** ``` <properties> <!-- minidao --> <minidao.version>1.6.5</minidao.version> <!-- 数据库连接池 --> <commons-dbcp.version>1.4</commons-dbcp.version> <commons-pool.version>1.6</commons-pool.version> </properties> <!-- minidao --> <dependency> <groupId>org.jeecgframework</groupId> <artifactId>minidao-pe</artifactId> <version>${minidao.version}</version> </dependency> <!-- DBCP连接池 --> <dependency> <groupId>commons-pool</groupId> <artifactId>commons-pool</artifactId> <version>${commons-pool.version}</version> <scope>runtime</scope> </dependency> <dependency> <groupId>commons-dbcp</groupId> <artifactId>commons-dbcp</artifactId> <version>${commons-dbcp.version}</version> <scope>compile</scope> </dependency> ``` **2.2、在resource目录下新建config文件夹,创建application.properties文件对项目信息进行配置** ``` #设置Tomcat端口,默认8080 server.port=8080 #设置项目ContextPath server.context-path=/ #设置Tomcat编码 server.tomcat.uri-encoding=UTF-8 #设置视图解析器路径 spring.mvc.view.prefix=/WEB-INF/views/ #设置视图解析器后缀 spring.mvc.view.suffix=.jsp #数据库配置 spring.datasource.url=jdbc:mysql://localhost:3306/demo?useUnicode=true&characterEncoding=utf-8&zeroDateTimeBehavior=convertToNull&allowMultiQueries=true spring.datasource.username=root spring.datasource.password=123456 spring.datasource.driver-class-name=com.mysql.jdbc.Driver ``` **2.3、在config文件夹下,创建spring-minidao.xml文件并进行配置** ``` <?xml version="1.0" encoding="UTF-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" xmlns:aop="http://www.springframework.org/schema/aop" xmlns:util="http://www.springframework.org/schema/util" xmlns:tx="http://www.springframework.org/schema/tx" xmlns:task="http://www.springframework.org/schema/task" xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.0.xsd http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-3.0.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-3.0.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-3.0.xsd http://www.springframework.org/schema/task http://www.springframework.org/schema/task/spring-task-3.0.xsd http://www.springframework.org/schema/util http://www.springframework.org/schema/util/spring-util-3.0.xsd" default-autowire="byName" default-lazy-init="false"> <!-- MiniDao动态代理类 --> <bean id="miniDaoHandler" class="org.jeecgframework.minidao.factory.MiniDaoBeanScannerConfigurer"> <!-- 是使用什么字母做关键字Map的关键字 默认值origin 即和sql保持一致,lower小写(推荐),upper 大写 --> <property name="keyType" value="lower"></property> <!-- 格式化sql --> <property name="formatSql" value="false"></property> <!-- 输出sql --> <property name="showSql" value="false"></property> <!-- 数据库类型 mysql/postgresql/oracle/sqlserver --> <property name="dbType" value="mysql"></property> <!-- dao地址,配置符合spring方式 --> <property name="basePackage" value="com.jeecg.demo.dao,com.jeecg.demo"></property> <!-- 使用的注解,默认是Minidao,推荐 Repository--> <property name="annotation" value="org.springframework.stereotype.Repository"></property> </bean> </beans> ``` **2.4、在application.java中加入@ImportResource注解引入spring-minidao.xml的配置** ![输入图片说明](https://static.oschina.net/uploads/img/201807/03113753_fU83.png "在这里输入图片标题") ### 3、测试用例 **3.1、编写minidao接口** userDao ``` @MiniDao public interface UserDao { /** * 查询用户列表 * @return */ @Sql("select id,username,realname,password from user") List<User> getList(); /** * 删除用户 * @param id 用户ID */ void delUser(@Param("id")String id); } ``` **3.2编写minidao接口对应sql文件userDao_delUser.sql** ``` DELETE FROM USER WHERE id = :id ``` **3.3、编写controller** ``` @RestController public class IndexController { private static Logger logger = Logger.getLogger(IndexController.class); @Autowired private UserDao userDao; @RequestMapping("/userList") public ModelAndView index() { logger.info("用户列表查询开始"); ModelAndView model = new ModelAndView(); List<User> users = userDao.getList(); model.addObject("users", users); model.setViewName("userList"); logger.info("用户列表查询结束"); return model; } @RequestMapping("/userDel") public ModelAndView userDel(String id) { logger.info("删除用户开始"); ModelAndView model = new ModelAndView(); userDao.delUser(id); model.setViewName("redirect:/userList"); logger.info("删除用户结束"); return model; } } ``` **3.4、启动项目浏览器访问** ![输入图片说明](https://static.oschina.net/uploads/img/201807/03114044_m63f.png "在这里输入图片标题") ### 4、完整项目结构 ![输入图片说明](https://static.oschina.net/uploads/img/201807/03114116_4ChO.png "在这里输入图片标题") ``` Demo下载地址: 链接: https://pan.baidu.com/s/1xZRjrdNHQtKqkSRx93PBqQ 密码: nr4h ```