当前位置：Gxlcms > 数据库问题 > ssm简单的示例整合（eclipse+maven+ssm+oracle/mysql+jquery.js）

ssm简单的示例整合（eclipse+maven+ssm+oracle/mysql+jquery.js）

时间：2021-07-01 10:21:17 帮助过：5人阅读

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 2 xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd"> 3 <modelVersion>4.0.0</modelVersion> 4 <groupId>Maven</groupId> 5 <artifactId>zxm02</artifactId> 6 <packaging>war</packaging> 7 <version>0.0.1-SNAPSHOT</version> 8 <name>zxm Maven Webapp</name> 9 <url>http://maven.apache.org</url> 10 <dependencies> 11 <dependency> 12 <groupId>junit</groupId> 13 <artifactId>junit</artifactId> 14 <version>3.8.1</version> 15 <scope>test</scope> 16 </dependency> 17 18  19 <dependency> 20 <groupId>org.apache.commons</groupId> 21 <artifactId>commons-dbcp2</artifactId> 22 <version>2.6.0</version> 23 </dependency> 24  25 <dependency> 26 <groupId>commons-logging</groupId> 27 <artifactId>commons-logging</artifactId> 28 <version>1.2</version> 29 </dependency> 30 31 <dependency> 32 <groupId>org.apache.commons</groupId> 33 <artifactId>commons-pool2</artifactId> 34 <version>2.6.2</version> 35 </dependency> 36 37  38 <dependency> 39 <groupId>com.fasterxml.jackson.core</groupId> 40 <artifactId>jackson-core</artifactId> 41 <version>2.9.9</version> 42 </dependency> 43  44 <dependency> 45 <groupId>com.fasterxml.jackson.core</groupId> 46 <artifactId>jackson-annotations</artifactId> 47 <version>2.9.9</version> 48 </dependency> 49 50  51 <dependency> 52 <groupId>com.fasterxml.jackson.core</groupId> 53 <artifactId>jackson-databind</artifactId> 54 <version>2.9.9</version> 55 </dependency> 56 57 58  59 <dependency> 60 <groupId>org.mybatis</groupId> 61 <artifactId>mybatis</artifactId> 62 <version>3.4.6</version> 63 </dependency> 64  65 <dependency> 66 <groupId>org.mybatis</groupId> 67 <artifactId>mybatis-spring</artifactId> 68 <version>2.0.1</version> 69 </dependency> 70 71  72 <dependency> 73 <groupId>org.springframework</groupId> 74 <artifactId>spring-aop</artifactId> 75 <version>4.1.6.RELEASE</version> 76 </dependency> 77 <dependency> 78 <groupId>org.springframework</groupId> 79 <artifactId>spring-aspects</artifactId> 80 <version>4.1.6.RELEASE</version> 81 </dependency> 82 <dependency> 83 <groupId>org.springframework</groupId> 84 <artifactId>spring-beans</artifactId> 85 <version>4.1.6.RELEASE</version> 86 </dependency> 87 <dependency> 88 <groupId>org.springframework</groupId> 89 <artifactId>spring-context</artifactId> 90 <version>4.1.6.RELEASE</version> 91 </dependency> 92 <dependency> 93 <groupId>org.springframework</groupId> 94 <artifactId>spring-context-support</artifactId> 95 <version>4.1.6.RELEASE</version> 96 </dependency> 97 <dependency> 98 <groupId>org.springframework</groupId> 99 <artifactId>spring-core</artifactId> 100 <version>4.1.6.RELEASE</version> 101 </dependency> 102 <dependency> 103 <groupId>org.springframework</groupId> 104 <artifactId>spring-expression</artifactId> 105 <version>4.1.6.RELEASE</version> 106 </dependency> 107 <dependency> 108 <groupId>org.springframework</groupId> 109 <artifactId>spring-jdbc</artifactId> 110 <version>4.1.6.RELEASE</version> 111 </dependency> 112 <dependency> 113 <groupId>org.springframework</groupId> 114 <artifactId>spring-test</artifactId> 115 <version>4.1.6.RELEASE</version> 116 </dependency> 117 <dependency> 118 <groupId>org.springframework</groupId> 119 <artifactId>spring-tx</artifactId> 120 <version>4.1.6.RELEASE</version> 121 </dependency> 122 <dependency> 123 <groupId>org.springframework</groupId> 124 <artifactId>spring-web</artifactId> 125 <version>4.1.6.RELEASE</version> 126 </dependency> 127 <dependency> 128 <groupId>org.springframework</groupId> 129 <artifactId>spring-webmvc</artifactId> 130 <version>4.1.6.RELEASE</version> 131 </dependency> 132 133 <dependency> 134 <groupId>com.oracle</groupId> 135 <artifactId>ojdbc6</artifactId> 136 <version>12.1.0.1-atlassian-hosted</version> 137 </dependency> 138 139 <dependency> 140 <groupId>mysql</groupId> 141 <artifactId>mysql-connector-java</artifactId> 142 <version>5.1.30</version> 143 </dependency> 144 145 146 147 148 </dependencies> 149 150 151 152 153 <build> 154 <finalName>zxm02</finalName> 155 </build> 156 </project>

pox.xml的东西不要全部复制粘贴，比如工程的名字就不一样，复制dependencies里的就行，

这里说一下，ojdbc6的jar包，因为版权原因，maven不能下载，需要先下载到本地再在引用（非maven的小伙伴可跳过）友情链接：https://blog.csdn.net/qq_38263715/article/details/80698499

导包成功后，我们进行第二步

二。我的web.xml

<span style="color: #008080;"> 1</span> <span style="color: #0000ff;"><?</span><span style="color: #ff00ff;">xml version="1.0" encoding="UTF-8"</span><span style="color: #0000ff;">?></span>
<span style="color: #008080;"> 2</span> 
<span style="color: #008080;"> 3</span> <span style="color: #0000ff;"><</span><span style="color: #800000;">web-app </span><span style="color: #ff0000;">xmlns:xsi</span><span style="color: #0000ff;">="http://www.w3.org/2001/XMLSchema-instance"</span> 
<span style="color: #008080;"> 4</span> <span style="color: #ff0000;">         xmlns</span><span style="color: #0000ff;">="http://xmlns.jcp.org/xml/ns/javaee"</span> 
<span style="color: #008080;"> 5</span> <span style="color: #ff0000;">         xsi:schemaLocation</span><span style="color: #0000ff;">="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_3_1.xsd"</span> 
<span style="color: #008080;"> 6</span> <span style="color: #ff0000;">         id</span><span style="color: #0000ff;">="WebApp_ID"</span><span style="color: #ff0000;"> version</span><span style="color: #0000ff;">="3.1"</span><span style="color: #0000ff;">></span>
<span style="color: #008080;"> 7</span> 
<span style="color: #008080;"> 8</span> 
<span style="color: #008080;"> 9</span>          
<span style="color: #008080;">10</span>       <span style="color: #0000ff;"><</span><span style="color: #800000;">context-param</span><span style="color: #0000ff;">></span>
<span style="color: #008080;">11</span>           <span style="color: #0000ff;"><</span><span style="color: #800000;">param-name</span><span style="color: #0000ff;">></span>contextConfigLocation<span style="color: #0000ff;"></</span><span style="color: #800000;">param-name</span><span style="color: #0000ff;">></span>
<span style="color: #008080;">12</span>           <span style="color: #0000ff;"><</span><span style="color: #800000;">param-value</span><span style="color: #0000ff;">></span>classpath:app.xml<span style="color: #0000ff;"></</span><span style="color: #800000;">param-value</span><span style="color: #0000ff;">></span>
<span style="color: #008080;">13</span>       <span style="color: #0000ff;"></</span><span style="color: #800000;">context-param</span><span style="color: #0000ff;">></span>
<span style="color: #008080;">14</span>       <span style="color: #0000ff;"><</span><span style="color: #800000;">listener</span><span style="color: #0000ff;">></span>
<span style="color: #008080;">15</span>           <span style="color: #0000ff;"><</span><span style="color: #800000;">listener-class</span><span style="color: #0000ff;">></span>org.springframework.web.context.ContextLoaderListener<span style="color: #0000ff;"></</span><span style="color: #800000;">listener-class</span><span style="color: #0000ff;">></span>
<span style="color: #008080;">16</span>       <span style="color: #0000ff;"></</span><span style="color: #800000;">listener</span><span style="color: #0000ff;">></span>
<span style="color: #008080;">17</span>       
<span style="color: #008080;">18</span>       <span style="color: #0000ff;"><</span><span style="color: #800000;">servlet</span><span style="color: #0000ff;">></span>
<span style="color: #008080;">19</span>         <span style="color: #0000ff;"><</span><span style="color: #800000;">servlet-name</span><span style="color: #0000ff;">></span>springmvc<span style="color: #0000ff;"></</span><span style="color: #800000;">servlet-name</span><span style="color: #0000ff;">></span>
<span style="color: #008080;">20</span>         <span style="color: #0000ff;"><</span><span style="color: #800000;">servlet-class</span><span style="color: #0000ff;">></span>org.springframework.web.servlet.DispatcherServlet<span style="color: #0000ff;"></</span><span style="color: #800000;">servlet-class</span><span style="color: #0000ff;">></span>
<span style="color: #008080;">21</span>         <span style="color: #0000ff;"><</span><span style="color: #800000;">init-param</span><span style="color: #0000ff;">></span>
<span style="color: #008080;">22</span>             <span style="color: #0000ff;"><</span><span style="color: #800000;">param-name</span><span style="color: #0000ff;">></span>contextConfigLocation<span style="color: #0000ff;"></</span><span style="color: #800000;">param-name</span><span style="color: #0000ff;">></span>
<span style="color: #008080;">23</span>             <span style="color: #0000ff;"><</span><span style="color: #800000;">param-value</span><span style="color: #0000ff;">></span>classpath:springmvc.xml<span style="color: #0000ff;"></</span><span style="color: #800000;">param-value</span><span style="color: #0000ff;">></span>
<span style="color: #008080;">24</span>         <span style="color: #0000ff;"></</span><span style="color: #800000;">init-param</span><span style="color: #0000ff;">></span>
<span style="color: #008080;">25</span>         <span style="color: #0000ff;"><</span><span style="color: #800000;">load-on-startup</span><span style="color: #0000ff;">></span>1<span style="color: #0000ff;"></</span><span style="color: #800000;">load-on-startup</span><span style="color: #0000ff;">></span>
<span style="color: #008080;">26</span>     <span style="color: #0000ff;"></</span><span style="color: #800000;">servlet</span><span style="color: #0000ff;">></span>
<span style="color: #008080;">27</span>     
<span style="color: #008080;">28</span>     
<span style="color: #008080;">29</span>     <span style="color: #0000ff;"><</span><span style="color: #800000;">servlet-mapping</span><span style="color: #0000ff;">></span>
<span style="color: #008080;">30</span>         <span style="color: #0000ff;"><</span><span style="color: #800000;">servlet-name</span><span style="color: #0000ff;">></span>springmvc<span style="color: #0000ff;"></</span><span style="color: #800000;">servlet-name</span><span style="color: #0000ff;">></span>
<span style="color: #008080;">31</span>         <span style="color: #0000ff;"><</span><span style="color: #800000;">url-pattern</span><span style="color: #0000ff;">></span>*.do<span style="color: #0000ff;"></</span><span style="color: #800000;">url-pattern</span><span style="color: #0000ff;">></span>
<span style="color: #008080;">32</span>     <span style="color: #0000ff;"></</span><span style="color: #800000;">servlet-mapping</span><span style="color: #0000ff;">></span>
<span style="color: #008080;">33</span>     
<span style="color: #008080;">34</span>       
<span style="color: #008080;">35</span>          
<span style="color: #008080;">36</span> <span style="color: #0000ff;"></</span><span style="color: #800000;">web-app</span><span style="color: #0000ff;">></span>

其实我这里只有两个东西：1是加载app.xml(大多数人写的是applicationContext.xml,我简写了)

　　　　　　　　　　　　2是加载springmvc.xml

　　　　　　下面那个<servlet-mapping>是拦截请求用的，他会拦截所有以.do结尾的url，这个可以自己选，*.什么都可以

既然要加载这两个文件，我们就要写出来，要不然会报错的

三。app.xml

<span style="color: #008080;"> 1</span> <span style="color: #0000ff;"><</span><span style="color: #800000;">beans </span><span style="color: #ff0000;">xmlns</span><span style="color: #0000ff;">="http://www.springframework.org/schema/beans"</span>
<span style="color: #008080;"> 2</span> <span style="color: #ff0000;">    xmlns:xsi</span><span style="color: #0000ff;">="http://www.w3.org/2001/XMLSchema-instance"</span> 
<span style="color: #008080;"> 3</span> <span style="color: #ff0000;">    xmlns:mvc</span><span style="color: #0000ff;">="http://www.springframework.org/schema/mvc"</span>
<span style="color: #008080;"> 4</span> <span style="color: #ff0000;">    xmlns:context</span><span style="color: #0000ff;">="http://www.springframework.org/schema/context"</span>
<span style="color: #008080;"> 5</span> <span style="color: #ff0000;">    xmlns:aop</span><span style="color: #0000ff;">="http://www.springframework.org/schema/aop"</span> 
<span style="color: #008080;"> 6</span> <span style="color: #ff0000;">    xmlns:tx</span><span style="color: #0000ff;">="http://www.springframework.org/schema/tx"</span>
<span style="color: #008080;"> 7</span> <span style="color: #ff0000;">    xsi:schemaLocation</span><span style="color: #0000ff;">="http://www.springframework.org/schema/beans 
</span><span style="color: #008080;"> 8</span> <span style="color: #0000ff;">        http://www.springframework.org/schema/beans/spring-beans-3.2.xsd 
</span><span style="color: #008080;"> 9</span> <span style="color: #0000ff;">        http://www.springframework.org/schema/mvc 
</span><span style="color: #008080;">10</span> <span style="color: #0000ff;">        http://www.springframework.org/schema/mvc/spring-mvc-3.2.xsd 
</span><span style="color: #008080;">11</span> <span style="color: #0000ff;">        http://www.springframework.org/schema/context 
</span><span style="color: #008080;">12</span> <span style="color: #0000ff;">        http://www.springframework.org/schema/context/spring-context-3.2.xsd 
</span><span style="color: #008080;">13</span> <span style="color: #0000ff;">        http://www.springframework.org/schema/aop 
</span><span style="color: #008080;">14</span> <span style="color: #0000ff;">        http://www.springframework.org/schema/aop/spring-aop-3.2.xsd 
</span><span style="color: #008080;">15</span> <span style="color: #0000ff;">        http://www.springframework.org/schema/tx 
</span><span style="color: #008080;">16</span> <span style="color: #0000ff;">        http://www.springframework.org/schema/tx/spring-tx-3.2.xsd "</span><span style="color: #0000ff;">></span>
<span style="color: #008080;">17</span>         
<span style="color: #008080;">18</span> 
<span style="color: #008080;">19</span>     <span style="color: #0000ff;"><</span><span style="color: #800000;">context:component-scan </span><span style="color: #ff0000;">base-package</span><span style="color: #0000ff;">="com.impl"</span><span style="color: #0000ff;">></</span><span style="color: #800000;">context:component-scan</span><span style="color: #0000ff;">></span>
<span style="color: #008080;">20</span>         
<span style="color: #008080;">21</span> 
<span style="color: #008080;">22</span>     <span style="color: #0000ff;"><</span><span style="color: #800000;">context:property-placeholder </span><span style="color: #ff0000;">location</span><span style="color: #0000ff;">="classpath:mysql.properties"</span><span style="color: #0000ff;">/></span>
<span style="color: #008080;">23</span>     <span style="color: #0000ff;"><</span><span style="color: #800000;">bean </span><span style="color: #ff0000;">id</span><span style="color: #0000ff;">="dataSource"</span><span style="color: #ff0000;"> class</span><span style="color: #0000ff;">="org.apache.commons.dbcp2.BasicDataSource"</span>
<span style="color: #008080;">24</span> <span style="color: #ff0000;">        destroy-method</span><span style="color: #0000ff;">="close"</span><span style="color: #0000ff;">></span>
<span style="color: #008080;">25</span>         <span style="color: #0000ff;"><</span><span style="color: #800000;">property </span><span style="color: #ff0000;">name</span><span style="color: #0000ff;">="driverClassName"</span><span style="color: #ff0000;"> value</span><span style="color: #0000ff;">="${jdbc.driverClassName}"</span> <span style="color: #0000ff;">/></span>
<span style="color: #008080;">26</span>         <span style="color: #0000ff;"><</span><span style="color: #800000;">property </span><span style="color: #ff0000;">name</span><span style="color: #0000ff;">="url"</span><span style="color: #ff0000;"> value</span><span style="color: #0000ff;">="${jdbc.url}"</span> <span style="color: #0000ff;">/></span>
<span style="color: #008080;">27</span>         <span style="color: #0000ff;"><</span><span style="color: #800000;">property </span><span style="color: #ff0000;">name</span><span style="color: #0000ff;">="username"</span><span style="color: #ff0000;"> value</span><span style="color: #0000ff;">="${jdbc.username}"</span> <span style="color: #0000ff;">/></span>
<span style="color: #008080;">28</span>         <span style="color: #0000ff;"><</span><span style="color: #800000;">property </span><span style="color: #ff0000;">name</span><span style="color: #0000ff;">="password"</span><span style="color: #ff0000;"> value</span><span style="color: #0000ff;">="${jdbc.password}"</span> <span style="color: #0000ff;">/></span>
<span style="color: #008080;">29</span>     <span style="color: #0000ff;"></</span><span style="color: #800000;">bean</span><span style="color: #0000ff;">></span>
<span style="color: #008080;">30</span>     
<span style="color: #008080;">31</span>     
<span style="color: #008080;">32</span>     
<span style="color: #008080;">33</span>     
<span style="color: #008080;">34</span>     <span style="color: #0000ff;"><</span><span style="color: #800000;">bean </span><span style="color: #ff0000;">id</span><span style="color: #0000ff;">="sqlSessionFactory"</span><span style="color: #ff0000;"> class</span><span style="color: #0000ff;">="org.mybatis.spring.SqlSessionFactoryBean"</span><span style="color: #0000ff;">></span>
<span style="color: #008080;">35</span>         <span style="color: #0000ff;"><</span><span style="color: #800000;">property </span><span style="color: #ff0000;">name</span><span style="color: #0000ff;">="dataSource"</span><span style="color: #ff0000;"> ref</span><span style="color: #0000ff;">="dataSource"</span> <span style="color: #0000ff;">/></span>
<span style="color: #008080;">36</span>         <span style="color: #0000ff;"><</span><span style="color: #800000;">property </span><span style="color: #ff0000;">name</span><span style="color: #0000ff;">="mapperLocations"</span><span style="color: #ff0000;"> value</span><span style="color: #0000ff;">="classpath:resource/userMapper.xml"</span> <span style="color: #0000ff;">/></span>
<span style="color: #008080;">37</span>     <span style="color: #0000ff;"></</span><span style="color: #800000;">bean</span><span style="color: #0000ff;">></span>   
<span style="color: #008080;">38</span>     
<span style="color: #008080;">39</span>     
<span style="color: #008080;">40</span> 
<span style="color: #008080;">41</span>     <span style="color: #0000ff;"><</span><span style="color: #800000;">bean </span><span style="color: #ff0000;">class</span><span style="color: #0000ff;">="org.mybatis.spring.mapper.MapperScannerConfigurer"</span><span style="color: #0000ff;">></span>
<span style="color: #008080;">42</span>         <span style="color: #0000ff;"><</span><span style="color: #800000;">property </span><span style="color: #ff0000;">name</span><span style="color: #0000ff;">="basePackage"</span><span style="color: #ff0000;"> value</span><span style="color: #0000ff;">="com.dao"</span><span style="color: #0000ff;">/></span>
<span style="color: #008080;">43</span>         <span style="color: #0000ff;"><</span><span style="color: #800000;">property </span><span style="color: #ff0000;">name</span><span style="color: #0000ff;">="sqlSessionFactoryBeanName"</span><span style="color: #ff0000;"> value</span><span style="color: #0000ff;">="sqlSessionFactory"</span><span style="color: #0000ff;">/></span>
<span style="color: #008080;">44</span>     <span style="color: #0000ff;"></</span><span style="color: #800000;">bean</span><span style="color: #0000ff;">></span>
<span style="color: #008080;">45</span> 
<span style="color: #008080;">46</span>     <span style="color: #0000ff;"><</span><span style="color: #800000;">bean </span><span style="color: #ff0000;">id</span><span style="color: #0000ff;">="transactionManager"</span><span style="color: #ff0000;"> class</span><span style="color: #0000ff;">="org.springframework.jdbc.datasource.DataSourceTransactionManager"</span><span style="color: #0000ff;">></span>
<span style="color: #008080;">47</span>         <span style="color: #0000ff;"><</span><span style="color: #800000;">property </span><span style="color: #ff0000;">name</span><span style="color: #0000ff;">="dataSource"</span><span style="color: #ff0000;"> ref</span><span style="color: #0000ff;">="dataSource"</span><span style="color: #0000ff;">/></span>    
<span style="color: #008080;">48</span>     <span style="color: #0000ff;"></</span><span style="color: #800000;">bean</span><span style="color: #0000ff;">></span>
<span style="color: #008080;">49</span> 
<span style="color: #008080;">50</span> <span style="color: #0000ff;"></</span><span style="color: #800000;">beans</span><span style="color: #0000ff;">></span>

这里配置了包扫描，连接数据库的，有几处用到了包路径的名字！！仔细改成你的路径（4处）

四。springmvc.xml

<span style="color: #0000ff;"><?</span><span style="color: #ff00ff;">xml version="1.0" encoding="UTF-8"</span><span style="color: #0000ff;">?></span>
<span style="color: #0000ff;"><</span><span style="color: #800000;">beans </span><span style="color: #ff0000;">xmlns</span><span style="color: #0000ff;">="http://www.springframework.org/schema/beans"</span><span style="color: #ff0000;">
    xmlns:xsi</span><span style="color: #0000ff;">="http://www.w3.org/2001/XMLSchema-instance"</span><span style="color: #ff0000;"> xmlns:mvc</span><span style="color: #0000ff;">="http://www.springframework.org/schema/mvc"</span><span style="color: #ff0000;">
    xmlns:context</span><span style="color: #0000ff;">="http://www.springframework.org/schema/context"</span><span style="color: #ff0000;">
    xmlns:aop</span><span style="color: #0000ff;">="http://www.springframework.org/schema/aop"</span><span style="color: #ff0000;"> xmlns:tx</span><span style="color: #0000ff;">="http://www.springframework.org/schema/tx"</span><span style="color: #ff0000;">
    xsi:schemaLocation</span><span style="color: #0000ff;">="http://www.springframework.org/schema/beans 
        http://www.springframework.org/schema/beans/spring-beans-3.2.xsd 
        http://www.springframework.org/schema/mvc 
        http://www.springframework.org/schema/mvc/spring-mvc-3.2.xsd 
        http://www.springframework.org/schema/context 
        http://www.springframework.org/schema/context/spring-context-3.2.xsd 
        http://www.springframework.org/schema/aop 
        http://www.springframework.org/schema/aop/spring-aop-3.2.xsd 
        http://www.springframework.org/schema/tx 
        http://www.springframework.org/schema/tx/spring-tx-3.2.xsd "</span><span style="color: #0000ff;">></span>
        
<span style="color: #008000;"><!--</span><span style="color: #008000;"> 开启controller注解支持 </span><span style="color: #008000;">--></span>
    <span style="color: #008000;"><!--</span><span style="color: #008000;"> 注意事项请参考：http://jinnianshilongnian.iteye.com/blog/1762632 </span><span style="color: #008000;">--></span>
    <span style="color: #008000;"><!--</span><span style="color: #008000;"> 扫描注解的，context是负责扫描的 </span><span style="color: #008000;">--></span>
    <span style="color: #0000ff;"><</span><span style="color: #800000;">context:component-scan </span><span style="color: #ff0000;">base-package</span><span style="color: #0000ff;">="com.controller"</span><span style="color: #ff0000;"> use-default-filters</span><span style="color: #0000ff;">="false"</span><span style="color: #0000ff;">></span>
        <span style="color: #0000ff;"><</span><span style="color: #800000;">context:include-filter </span><span style="color: #ff0000;">type</span><span style="color: #0000ff;">="annotation"</span><span style="color: #ff0000;"> expression</span><span style="color: #0000ff;">="org.springframework.stereotype.Controller"</span> <span style="color: #0000ff;">/></span>
        <span style="color: #0000ff;"><</span><span style="color: #800000;">context:include-filter </span><span style="color: #ff0000;">type</span><span style="color: #0000ff;">="annotation"</span><span style="color: #ff0000;"> expression</span><span style="color: #0000ff;">="org.springframework.web.bind.annotation.ControllerAdvice"</span> <span style="color: #0000ff;">/></span>
    <span style="color: #0000ff;"></</span><span style="color: #800000;">context:component-scan</span><span style="color: #0000ff;">></span>
    <span style="color: #008000;"><!--</span><span style="color: #008000;">使用mvc:annotation-driven代替上边注解映射器和注解适配器 配置 如果使用mvc:annotation-driven就不用配置上面的
        RequestMappingHandlerMapping和RequestMappingHandlerAdapter</span><span style="color: #008000;">--></span>
    <span style="color: #0000ff;"><</span><span style="color: #800000;">mvc:annotation-driven</span><span style="color: #0000ff;">></</span><span style="color: #800000;">mvc:annotation-driven</span><span style="color: #0000ff;">></span>
    
    <span style="color: #008000;"><!--</span><span style="color: #008000;"> 配置视图解析器    </span><span style="color: #008000;">--></span>
    <span style="color: #0000ff;"><</span><span style="color: #800000;">bean </span><span style="color: #ff0000;">class</span><span style="color: #0000ff;">="org.springframework.web.servlet.view.InternalResourceViewResolver"</span><span style="color: #0000ff;">></span>
        <span style="color: #008000;"><!--</span><span style="color: #008000;">配置jsp路径的前缀  </span><span style="color: #008000;">--></span>
        <span style="color: #0000ff;"><</span><span style="color: #800000;">property </span><span style="color: #ff0000;">name</span><span style="color: #0000ff;">="prefix"</span><span style="color: #ff0000;"> value</span><span style="color: #0000ff;">="/WEB-INF/view/"</span><span style="color: #0000ff;">/></span>
        <span style="color: #008000;"><!--</span><span style="color: #008000;">配置jsp路径的后缀  </span><span style="color: #008000;">--></span>
        <span style="color: #0000ff;"><</span><span style="color: #800000;">property </span><span style="color: #ff0000;">name</span><span style="color: #0000ff;">="suffix"</span><span style="color: #ff0000;"> value</span><span style="color: #0000ff;">=".jsp"</span><span style="color: #0000ff;">/></span>
    <span style="color: #0000ff;"></</span><span style="color: #800000;">bean</span><span style="color: #0000ff;">></span>
    
    
    
     <span style="color: #0000ff;"><</span><span style="color: #800000;">bean </span><span style="color: #ff0000;">id</span><span style="color: #0000ff;">="mappingJacksonHttpMessageConverter"</span><span style="color: #ff0000;">
       class</span><span style="color: #0000ff;">="org.springframework.http.converter.json.MappingJackson2HttpMessageConverter"</span><span style="color: #0000ff;">></span>
       <span style="color: #0000ff;"><</span><span style="color: #800000;">property </span><span style="color: #ff0000;">name</span><span style="color: #0000ff;">="supportedMediaTypes"</span><span style="color: #0000ff;">></span>
          <span style="color: #0000ff;"><</span><span style="color: #800000;">list</span><span style="color: #0000ff;">></span>
             <span style="color: #0000ff;"><</span><span style="color: #800000;">value</span><span style="color: #0000ff;">></span>app/json;charset=UTF-8<span style="color: #0000ff;"></</span><span style="color: #800000;">value</span><span style="color: #0000ff;">></span>
          <span style="color: #0000ff;"></</span><span style="color: #800000;">list</span><span style="color: #0000ff;">></span>
       <span style="color: #0000ff;"></</span><span style="color: #800000;">property</span><span style="color: #0000ff;">></span>
    <span style="color: #0000ff;"></</span><span style="color: #800000;">bean</span><span style="color: #0000ff;">></span>
    
    <span style="color: #0000ff;"><</span><span style="color: #800000;">bean </span><span style="color: #ff0000;">class</span><span style="color: #0000ff;">="org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter"</span><span style="color: #0000ff;">></span>
       <span style="color: #0000ff;"><</span><span style="color: #800000;">property </span><span style="color: #ff0000;">name</span><span style="color: #0000ff;">="messageConverters"</span><span style="color: #0000ff;">></span>
          <span style="color: #0000ff;"><</span><span style="color: #800000;">list</span><span style="color: #0000ff;">></span>
             <span style="color: #008000;"><!--</span><span style="color: #008000;">json视图拦截器，读取到@ResponseBody的时候去配置它 </span><span style="color: #008000;">--></span>
             <span style="color: #0000ff;"><</span><span style="color: #800000;">ref </span><span style="color: #ff0000;">bean</span><span style="color: #0000ff;">="mappingJacksonHttpMessageConverter"</span> <span style="color: #0000ff;">/></span>
          <span style="color: #0000ff;"></</span><span style="color: #800000;">list</span><span style="color: #0000ff;">></span>
       <span style="color: #0000ff;"></</span><span style="color: #800000;">property</span><span style="color: #0000ff;">></span>
    <span style="color: #0000ff;"></</span><span style="color: #800000;">bean</span><span style="color: #0000ff;">></span>
    
 
<span style="color: #0000ff;"></</span><span style="color: #800000;">beans</span><span style="color: #0000ff;">></span>

这里配置了controller的扫描和一个试图解析器，就是controller不用@ResponseBody时，返回页面的时候，会用到他，加一个前缀，加一个后缀

下面那俩配完了就允许返回java类的数据

五。这两个xml我们写完了，我们再连接一个数据库

db.properties（oracle）

<span style="color: #000000;">jdbc.driverClassName=oracle.jdbc.driver.OracleDriver
jdbc.url=jdbc:oracle:thin:@localhost:1521:orcl
jdbc.username=zxm
jdbc.password=zxm</span>

mysql.properties(mysql)

<span style="color: #008080;">1</span> <span style="color: #000000;">jdbc.driverClassName=com.mysql.jdbc.Driver
</span><span style="color: #008080;">2</span> jdbc.url=jdbc:mysql://localhost:3306/database01useUnicode=true<span style="color: #ff0000;">&characterEncoding</span><span style="color: #000000;">=UTF8
</span><span style="color: #008080;">3</span> <span style="color: #000000;">jdbc.username=root
</span><span style="color: #008080;">4</span> jdbc.password=root

我也不打码了，这个数据库，用户名，密码要改成你们的

mysql的我加了一个转码的

六。下一步是controller dao entity service service_impl usermapper.xml

这几个分别是控制层 dao层实体类服务层实现服务层和写语句的表

0.首先建一个实体类（要与数据库里的属性相对应）

技术图片

1.controller 被。do拦截的页面先来这里（a是我测试用的）

技术图片

2.然后走service的方法

技术图片

3.然后impl实现这个接口

技术图片

4.再去找dao

技术图片

5.dao里的名字与usermapper.xml的id相对应，去找usermapper.xml

技术图片

6.至此，后台的东西就写完了，框架也搭

< 上一篇
使用sqoop将mysql数据导入到hive中

下一篇 >
Mysql创建索引

人气教程排行

229次 1 oracle 用户解锁和修改用户密码

229次 2 解决：安装SQL Server 2008 Native Client遇到错误（在Navicat premium新建sqlserver连接时需要）：An error occurred during ...HRESULT: 0x80070422（注意尾部的错误号）

229次 3 rocksdb 编译步骤

229次 4 adb命令开关蓝牙及NFC

229次 5 解决数据库连接错误您在wp-config.php文件中提供的数据库用户名和密码可能不正确，或者无法连接到localhost上的数据库服务器，这意味着您的主机数据库服务器已停止工作。

229次 6 使用java自动填充，实现mysql的创建修改时间的自动填充

229次 7 Linux mount挂载磁盘报错 mount: wrong fs type, bad option, bad superblock on /dev/vdb

228次 8 关于mysql创建数据库中字符集和排序规则的选择

228次 9 Linux设置Mysql开机自启动服务

227次 10 SQL2008：WITH MOVE 子句可用于重新定位一个或多个文件

227次 11 图数据库Neo4j在GIS系统的应用

227次 12 SpringBoot配置 druid 数据源配置慢SQL记录

227次 13 SQL state [72000]; error code [1013]; ORA-03111: 通信通道收到中断; java.sql.SQLException: ORA-01745: 无效的主机/绑定变量名;java.sql.SQLException: ORA-01013: 用户请求取消当前的操作

227次 14 docker-compose启动MySQL并配置远程登录

225次 15 Mysql安装（for mac）

225次 16 kettle将图片转换至二进制存储至数据库

225次 17 adb的安装及配置

224次 18 使用PHP控制MODBUS-RTU设备

224次 19 MySQL 查询时间差值大于某一个值的记录

224次 20 MongoDB内存配置 --wiredTigerCacheSizeGB