SpringBoot填坑系列---XML方式配置数据库

2023-08-08 15:25:10

本次只是简单的运用SpringBoot搭建框架，对其原理并不做深入的探究

1.POM文件

 <?xml version="1.0" encoding="UTF-8"?>

 <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

     xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">

     <modelVersion>4.0.0</modelVersion>

     <groupId>com.hxyz</groupId>

     <artifactId>media</artifactId>

     <version>0.0.1-SNAPSHOT</version>

     <packaging>jar</packaging>

     <name>media</name>

     <description>Demo project for Spring Boot</description>

     <parent>

       <groupId>org.springframework.boot</groupId>

       <artifactId>spring-boot-starter-parent</artifactId>

       <version>1.4.0.RELEASE</version>

       <relativePath/> <!-- lookup parent from repository -->

    </parent>

    <properties>

       <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>

       <project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding>

       <java.version>1.8</java.version>

       <mybatis.version>3.2.2</mybatis.version>

    </properties>

    <dependencies>

     <dependency>

         <groupId>org.springframework.boot</groupId>

         <artifactId>spring-boot-starter-web</artifactId>

     </dependency>

     <dependency>

         <groupId>mysql</groupId>

         <artifactId>mysql-connector-java</artifactId>

     </dependency>

     <!-- mybatis -->

     <dependency>

         <groupId>org.mybatis</groupId>

         <artifactId>mybatis</artifactId>

         <version>${mybatis.version}</version>

     </dependency>

     <dependency>

         <groupId>org.mybatis</groupId>

         <artifactId>mybatis-spring</artifactId>

         <version>1.2.0</version>

     </dependency>

     <dependency>

             <groupId>org.springframework.boot</groupId>

             <artifactId>spring-boot-starter</artifactId>

         </dependency>

         <dependency>

             <groupId>org.springframework.data</groupId>

             <artifactId>spring-data-commons</artifactId>

         </dependency>

         <!-- connection pool -->

         <dependency>

             <groupId>org.springframework</groupId>

             <artifactId>spring-jdbc</artifactId>

         </dependency>

         <dependency>

             <groupId>org.apache.tomcat</groupId>

             <artifactId>tomcat-jdbc</artifactId>

         </dependency>

         <dependency>

             <groupId>mysql</groupId>

             <artifactId>mysql-connector-java</artifactId>

         </dependency>

        <dependency>

             <groupId>com.fasterxml.jackson.core</groupId>

             <artifactId>jackson-databind</artifactId>

             <version>2.7.0</version>

         </dependency>

         <dependency>

             <groupId>net.sf.json-lib</groupId>

             <artifactId>json-lib</artifactId>

             <version>2.4</version>

             <classifier>jdk15</classifier>

         </dependency>

         <dependency>

             <groupId>com.fasterxml.jackson.module</groupId>

             <artifactId>jackson-module-jaxb-annotations</artifactId>

             <version>2.7.0</version>

         </dependency>

          <dependency>

             <groupId>net.sf.json-lib</groupId>

             <artifactId>json-lib</artifactId>

             <version>2.4</version>

             <classifier>jdk15</classifier>

         </dependency>

         <dependency>

             <groupId>dom4j</groupId>

             <artifactId>dom4j</artifactId>

             <version>1.1</version>

         </dependency>

         <dependency>

             <groupId>org.apache.commons</groupId>

             <artifactId>commons-lang3</artifactId>

             <version>3.1</version>

         </dependency>

         <dependency>

             <groupId>org.codehaus.jackson</groupId>

             <artifactId>jackson-mapper-asl</artifactId>

             <version>1.9.13</version>

         </dependency>

         <dependency>

             <groupId>org.codehaus.jackson</groupId>

             <artifactId>jackson-core-asl</artifactId>

             <version>1.9.13</version>

         </dependency>

     </dependencies>

     <build>

         <plugins>

             <plugin>

                 <groupId>org.springframework.boot</groupId>

                 <artifactId>spring-boot-maven-plugin</artifactId>

             </plugin>

         </plugins>

     </build>

 </project>

2.通过MyBatis-generate自动生成实体类和mapper

SpringBoot填坑系列---XML方式配置数据库

3.配置XML文件

在resource下面新建applicationContext.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:p="http://www.springframework.org/schema/p"

    xmlns:aop="http://www.springframework.org/schema/aop"

    xmlns:context="http://www.springframework.org/schema/context"

    xmlns:jee="http://www.springframework.org/schema/jee"

    xmlns:tx="http://www.springframework.org/schema/tx"

    xsi:schemaLocation="

        http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-4.0.xsd

        http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-4.0.xsd

        http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.0.xsd

        http://www.springframework.org/schema/jee http://www.springframework.org/schema/jee/spring-jee-4.0.xsd

        http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.0.xsd">

 <bean id="dataSource" class="org.apache.tomcat.jdbc.pool.DataSource" destroy-method="close">

        <!-- Connection Info -->

        <property name="driverClassName" value="${jdbc.driver}" />

        <property name="url" value="${jdbc.url}" />

        <property name="username" value="${jdbc.username}" />

        <property name="password" value="${jdbc.password}" />

        <!-- Connection Pooling Info -->

        <property name="maxActive" value="10" />

        <property name="maxIdle" value="50" />

        <property name="minIdle" value="0" />

        <property name="defaultAutoCommit" value="false" />

    </bean>

     <!-- MyBatis配置 -->

    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">

        <property name="dataSource" ref="dataSource" />

        <!-- 自动扫描entity目录, 省掉Configuration.xml里的手工配置 -->

        <property name="typeAliasesPackage" value="com.hxyz.media.entity" />

        <!-- 显式指定Mapper文件位置 -->

        <property name="mapperLocations" value="classpath:/mapper/*Mapper.xml" />

    </bean>

    <!-- 扫描basePackage下所有以@MyBatisRepository标识的 接口-->

    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">

        <property name="basePackage" value="com.hxyz.media.mapper" />

    </bean>

</beans>

在resource路径下新建application.properties

 server.port=8089

 jdbc.driver=com.mysql.jdbc.Driver

 jdbc.url=jdbc:mysql://localhost:3306/

 jdbc.username=jack

 jdbc.password=123456

至此，我们的xml文件已经配置好了，我们可以写一个简单的控制器来测试下数据库是否已经连通

4.测试是否连通

 public interface FactoryService {

     public List<FactoryEntity> findFactory();

 }
@Service

public class FactoryServiceImpl implements FactoryService{

    @Resource

    private FactoryEntityMapper factoryMaaper;

    @Override

    public List<FactoryEntity> findFactory() {

        FactoryEntityExample example=new FactoryEntityExample();

        Criteria createCriteria = example.createCriteria();

        List<FactoryEntity> selectByExample = factoryMaaper.selectByExample(example);

        return selectByExample;

    }

}
 @RestController

 @RequestMapping(value="front/factory")

 public class FactoryController {

     @Resource

     private FactoryService factoryService;

     @RequestMapping(value="list")

     @ResponseBody

     public ResponseVo queryAll(){

         ResponseVo responseVo=new ResponseVo();

         List<FactoryEntity> factoryEntityList = factoryService.findFactory();

         responseVo.setData(factoryEntityList);

         return responseVo;

     }

 }

所以，我们猜一下，现在我请求下，数据会正常的返回么

我们现在请求下

http://localhost:8089/front/factory/list

返回的是

 Caused by: org.springframework.beans.factory.NoSuchBeanDefinitionException: No qualifying bean of type [com.hxyz.media.mapper.FactoryEntityMapper] found for dependency [com.hxyz.media.mapper.FactoryEntityMapper]: expected at least 1 bean which qualifies as autowire candidate for this dependency. Dependency annotations: {@javax.annotation.Resource(shareable=true, lookup=, name=, description=, authenticationType=CONTAINER, type=class java.lang.Object, mappedName=)}

     at org.springframework.beans.factory.support.DefaultListableBeanFactory.raiseNoMatchingBeanFound(DefaultListableBeanFactory.java:1406) ~[spring-beans-4.3.2.RELEASE.jar:4.3.2.RELEASE]

     at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1057) ~[spring-beans-4.3.2.RELEASE.jar:4.3.2.RELEASE]

     at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1019) ~[spring-beans-4.3.2.RELEASE.jar:4.3.2.RELEASE]

     at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.autowireResource(CommonAnnotationBeanPostProcessor.java:518) ~[spring-context-4.3.2.RELEASE.jar:4.3.2.RELEASE]

     at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.getResource(CommonAnnotationBeanPostProcessor.java:496) ~[spring-context-4.3.2.RELEASE.jar:4.3.2.RELEASE]

     at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor$ResourceElement.getResourceToInject(CommonAnnotationBeanPostProcessor.java:627) ~[spring-context-4.3.2.RELEASE.jar:4.3.2.RELEASE]

     at org.springframework.beans.factory.annotation.InjectionMetadata$InjectedElement.inject(InjectionMetadata.java:169) ~[spring-beans-4.3.2.RELEASE.jar:4.3.2.RELEASE]

     at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:88) ~[spring-beans-4.3.2.RELEASE.jar:4.3.2.RELEASE]

     at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.postProcessPropertyValues(CommonAnnotationBeanPostProcessor.java:318) ~[spring-context-4.3.2.RELEASE.jar:4.3.2.RELEASE]

     ... 34 common frames omitted

没有找到FactoryEntityMapper，但是我们明明是在xml中配置了mapperScannerConfigue

这是因为springboot在启动后并不会主动的去读取xml文件，只会根据类文件间的依赖去加载spring的bean类，所以springboot并没有发现xml中的配置

我们可以在启动类中添加

@ImportResource(locations = "classpath*:/applicationContext.xml")

完整的启动类如下

 @ImportResource(locations = "classpath*:/applicationContext.xml")

 @SpringBootApplication

 //@SpringBootApplication(exclude = { DataSourceAutoConfiguration.class})

 public class MediaApplication {

     public static void main(String[] args) {

         SpringApplication.run(MediaApplication.class, args);

     }

 }

这时我们再启动就可以返回数据了

　

上一篇：MySql索引简介


下一篇：geotrellis使用（二十四）将Geotrellis移植到CDH中必须要填的若干个坑