从Maven基础到整合ssm

刺骨的言语ヽ痛彻心扉 2021-09-19 10:18 237阅读 0赞

**目录**

pom.xml:

web.xml:（注意：此xml文件放在WEB-INF文件夹下面,即【src】-【main】-【webapp】-【WEB-INF】-【web.xml】）

applicationContext\_mapper.xml:

applicationContext\_service.xml:

applicationContext\_transaction.xml:

db.properties:

springmvc.xml:

例1：输出lijiang Servlet

例2：在例1的基础上拓展

项目网盘地址：https://pan.baidu.com/s/10zAo3D0qM1m9uzMf8FvmMQ    提取码：ksr8

例3：Maven整合SSM 。（在例2的基础上继续拓展）

项目网盘地址：https://pan.baidu.com/s/1cVxoyymlNXj25ZxBmSwjog     提取码：irrl

--------------------

## pom.xml: ##

<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.lijiang</groupId>
      <artifactId>ssm_spring_mvc_maven</artifactId>
      <version>0.0.1-SNAPSHOT</version>
      <packaging>war</packaging>
      <name>ssm_spring_mvc_maven</name>
      <description>用maven做的ssm_spring_mvc项目</description>
      
      <properties>
      	
      	<spring.version>5.0.8.RELEASE</spring.version>
      	<mybais.version>3.4.6</mybais.version>
      	<mybatis-spring.version>1.3.2</mybatis-spring.version>
      	<mysql-connector.version>5.1.46</mysql-connector.version>
      	<ojdbc7.version>12.1.0.2.0</ojdbc7.version>
      	<druid.version>1.0.16</druid.version>
      	<aopalliance.version>1.0</aopalliance.version>
      	<aspectj.weaver.version>1.6.4.RELEASE</aspectj.weaver.version>
      	<commons.logging.version>1.1.1</commons.logging.version>
      	<jstl.version>1.2</jstl.version>
      	<log4j.version>1.2.16</log4j.version>
      	<slf4j-api.version>1.6.1</slf4j-api.version>
      	<slf4j-nop.version>1.6.4</slf4j-nop.version>
      	<fileupload.version>1.3.1</fileupload.version>
      	<jackson.version>2.9.6</jackson.version>
      	<junit.version>4.9</junit.version>
      	<servlet-api.version>8.0.53</servlet-api.version>
      	<jsp-api.version>8.0.53</jsp-api.version>
      	
      	<c3p0.version>0.9.5.2</c3p0.version>
      	
      	
      	<maven-compiler-plugin.version>3.8.0</maven-compiler-plugin.version>
      	<tomcat7-maven-plugin.version>2.2</tomcat7-maven-plugin.version>
      </properties>
      
      
      <dependencyManagement>
      	<dependencies>
      		 
    		<dependency>
    		    <groupId>org.springframework</groupId>
    		    <artifactId>spring-core</artifactId>
    		    <version>${spring.version}</version>
    		</dependency>
    	 	<dependency>
    		   <groupId>org.springframework</groupId>
    		   <artifactId>spring-web</artifactId>
    		   <version>${spring.version}</version>
    	    </dependency>
    	    <dependency>
    		   <groupId>org.springframework</groupId>
    		   <artifactId>spring-tx</artifactId>
    		   <version>${spring.version}</version>
    	    </dependency>
    	    <dependency>
    		   <groupId>org.springframework</groupId>
    		   <artifactId>spring-jdbc</artifactId>
    		   <version>${spring.version}</version>
    	    </dependency>
    	    <dependency>
    		   <groupId>org.springframework</groupId>
    		   <artifactId>spring-webmvc</artifactId>
    		   <version>${spring.version}</version>
    	    </dependency>
    	    <dependency>
    		   <groupId>org.springframework</groupId>
    		   <artifactId>spring-aop</artifactId>
    		   <version>${spring.version}</version>
    	    </dependency>
    	    <dependency>
    		   <groupId>org.springframework</groupId>
    		   <artifactId>spring-context-support</artifactId>
    		   <version>${spring.version}</version>
    	    </dependency>
    	    <dependency>
    		   <groupId>org.springframework</groupId>
    		   <artifactId>spring-test</artifactId>
    		   <version>${spring.version}</version>
    	    </dependency>
    	    
    	    
    	     
    		<dependency>
    		    <groupId>org.mybatis</groupId>
    		    <artifactId>mybatis</artifactId>
    		    <version>${mybais.version}</version>
    		</dependency>
    		
    		<dependency>
    		    <groupId>org.mybatis</groupId>
    		    <artifactId>mybatis-spring</artifactId>
    		    <version>${mybatis-spring.version}</version>
    		</dependency>
    		
    		
    		<dependency>
    		    <groupId>com.fasterxml.jackson.core</groupId>
    		    <artifactId>jackson-core</artifactId>
    		    <version>${jackson.version}</version>
    		</dependency>
    		<dependency>
    		    <groupId>com.fasterxml.jackson.core</groupId>
    		    <artifactId>jackson-annotations</artifactId>
    		    <version>${jackson.version}</version>
    		</dependency>
    		<dependency>
    		    <groupId>com.fasterxml.jackson.core</groupId>
    		    <artifactId>jackson-databind</artifactId>
    		    <version>${jackson.version}</version>
    		</dependency>
    		
    		
    
    		<dependency>
    		    <groupId>com.mchange</groupId>
    		    <artifactId>c3p0</artifactId>
    		    <version>${c3p0.version}</version>
    		</dependency>
      	</dependencies>
      
      </dependencyManagement>
      
      <dependencies>
        
    	<dependency>
    	    <groupId>org.springframework</groupId>
    	    <artifactId>spring-core</artifactId>
    	</dependency>
     	<dependency>
    	   <groupId>org.springframework</groupId>
    	   <artifactId>spring-web</artifactId>
        </dependency>
        <dependency>
    	   <groupId>org.springframework</groupId>
    	   <artifactId>spring-tx</artifactId>
        </dependency>
        <dependency>
    	   <groupId>org.springframework</groupId>
    	   <artifactId>spring-jdbc</artifactId>
        </dependency>
        <dependency>
    	   <groupId>org.springframework</groupId>
    	   <artifactId>spring-webmvc</artifactId>
        </dependency>
        <dependency>
    	   <groupId>org.springframework</groupId>
    	   <artifactId>spring-aop</artifactId>
        </dependency>
        <dependency>
    	   <groupId>org.springframework</groupId>
    	   <artifactId>spring-context-support</artifactId>
        </dependency>
        <dependency>
    	   <groupId>org.springframework</groupId>
    	   <artifactId>spring-test</artifactId>
        </dependency>
        
            
        
    	<dependency>
    	    <groupId>org.mybatis</groupId>
    	    <artifactId>mybatis</artifactId>
    	</dependency>
    	
    	
    	<dependency>
    	    <groupId>org.mybatis</groupId>
    	    <artifactId>mybatis-spring</artifactId>
    	</dependency>
     
    	
    	<dependency>
    	    <groupId>mysql</groupId>
    	    <artifactId>mysql-connector-java</artifactId>
    	    <version>${mysql-connector.version}</version>
    	</dependency>
     
    	<dependency>
    	    <groupId>cn.easyproject</groupId>
    	    <artifactId>ojdbc7</artifactId>
    	    <version>${ojdbc7.version}</version>
    	</dependency>
    	
    	
    	 
    	<dependency>
    	    <groupId>com.alibaba</groupId>
    	    <artifactId>druid</artifactId>
    	    <version>${druid.version}</version>
    	</dependency>
    	
    	
    	<dependency>
    	    <groupId>aopalliance</groupId>
    	    <artifactId>aopalliance</artifactId>
    	    <version>${aopalliance.version}</version>
    	</dependency>
    	
    	<dependency>
    	    <groupId>org.aspectj</groupId>
    	    <artifactId>com.springsource.org.aspectj.weaver</artifactId>
    	    <version>${aspectj.weaver.version}</version>
    	</dependency>
    	
    	
    	
    	<dependency>
    	    <groupId>org.apache.commons</groupId>
    	    <artifactId>com.springsource.org.apache.commons.logging</artifactId>
    	    <version>${commons.logging.version}</version>
    	</dependency>
     
    	
    	<dependency>
    		<groupId>javax.servlet</groupId>
    		<artifactId>jstl</artifactId>
    		<version>${jstl.version}</version>
    	</dependency>
    	
    	
    	<dependency>
    		<groupId>log4j</groupId>
    		<artifactId>log4j</artifactId>
    		<version>${log4j.version}</version>
    	</dependency>
    	<dependency>
    		<groupId>org.slf4j</groupId>
    		<artifactId>slf4j-api</artifactId>
    		<version>${slf4j-api.version}</version>
    	</dependency>
    	<dependency>
    		<groupId>org.slf4j</groupId>
    		<artifactId>slf4j-nop</artifactId>
    		<version>${slf4j-nop.version}</version>
    	</dependency>
    	
     
    	
    	<dependency>  
    		<groupId>commons-fileupload</groupId>  
    		<artifactId>commons-fileupload</artifactId>  
    		<version>${fileupload.version}</version>  
    	</dependency>
    	
    	
    	<dependency>
    	    <groupId>com.fasterxml.jackson.core</groupId>
    	    <artifactId>jackson-core</artifactId>
    	</dependency>
    	<dependency>
    	    <groupId>com.fasterxml.jackson.core</groupId>
    	    <artifactId>jackson-annotations</artifactId>
    	</dependency>
    	<dependency>
    	    <groupId>com.fasterxml.jackson.core</groupId>
    	    <artifactId>jackson-databind</artifactId>
    	</dependency>
    	
    	
    	
    	<dependency>
    	    <groupId>junit</groupId>
    	    <artifactId>junit</artifactId>
    	    <version>${junit.version}</version>
    	    <scope>test</scope>
    	</dependency>
    	
    	
    	<dependency>
      		<groupId>org.apache.tomcat</groupId>
      		<artifactId>tomcat-servlet-api</artifactId>
      		<version>${servlet-api.version}</version>
      		<scope>provided</scope>
      	</dependency>
    	
    	<dependency>
    	    <groupId>org.apache.tomcat</groupId>
    	    <artifactId>tomcat-jsp-api</artifactId>
    	    <version>${jsp-api.version}</version>
    	    <scope>provided</scope>
    	</dependency>
    	
    	
    		<dependency>
    		    <groupId>com.mchange</groupId>
    		    <artifactId>c3p0</artifactId>
    		    <version>${c3p0.version}</version>
    		</dependency>
    	
      </dependencies>
      
      <build>
      	<plugins>
      		<plugin>
      			<groupId>org.apache.maven.plugins</groupId>
      			<artifactId>maven-compiler-plugin</artifactId>
      			<version>${maven-compiler-plugin.version}</version>
      			<configuration>
      				<source>1.8</source>
    				<target>1.8</target>  			
      			</configuration>
      		</plugin>
      		
      		<plugin>
      			<groupId>org.apache.tomcat.maven</groupId>
      			<artifactId>tomcat7-maven-plugin</artifactId>
      			<version>${tomcat7-maven-plugin.version}</version>
      			<configuration>
      				<uriEncoding>UTF-8</uriEncoding>
      				<url>http://localhost:8080/manager/text</url>
      				<username>lijiang</username>
      				<password>111</password>
      			</configuration>
      		</plugin>
      		
      	</plugins>
      	
      	
        <resources>
    		<resource>
    			<directory>src/main/java</directory>
    			<includes>
    				<include>**/*.properties</include>
    				<include>**/*.xml</include>
    			</includes>
    			<filtering>false</filtering>
    		</resource>
    		
    		<resource>
    			<directory>src/main/resources</directory>
    			<includes>
    				<include>**/*.properties</include>
    				<include>**/*.xml</include>
    			</includes>
    			<filtering>false</filtering>
    		</resource>
    	</resources>
      </build>
      
    </project>

## web.xml:（注意：此xml文件放在WEB-INF文件夹下面,即【src】-【main】-【webapp】-【WEB-INF】-【web.xml】） ##

<?xml version="1.0" encoding="UTF-8"?>
    <web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://xmlns.jcp.org/xml/ns/javaee" xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_3_1.xsd" id="WebApp_ID" version="3.1">
      <display-name>Maven-ssm</display-name>
      <welcome-file-list>
        <welcome-file>index.html</welcome-file>
        <welcome-file>index.htm</welcome-file>
        <welcome-file>index.jsp</welcome-file>
        <welcome-file>default.html</welcome-file>
        <welcome-file>default.htm</welcome-file>
        <welcome-file>default.jsp</welcome-file>
      </welcome-file-list>
      
       
      <servlet-mapping>
      	<servlet-name>default</servlet-name>
      	<url-pattern>*.css</url-pattern>
      	<url-pattern>*.ttf</url-pattern>
      	<url-pattern>*.woff</url-pattern>
      	<url-pattern>*.js</url-pattern>
      	<url-pattern>*.png</url-pattern>
      	<url-pattern>*.jpg</url-pattern>
      	<url-pattern>*.gif</url-pattern>
      </servlet-mapping>
      
      
      <filter>
      	<filter-name>encoding</filter-name>
      	<filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
      	<init-param>
      		<param-name>encoding</param-name>
      		<param-value>utf-8</param-value>
      	</init-param>
      </filter>
      <filter-mapping>
      	<filter-name>encoding</filter-name>
      	
      	<url-pattern>/*</url-pattern>
      </filter-mapping>
      
      <listener>
      	<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
      </listener>
      <context-param>
      	<param-name>contextConfigLocation</param-name>
      	<param-value>classpath:applicationContext_*.xml</param-value>
      </context-param>
      
      
      <servlet>
      	<servlet-name>springmvc</servlet-name>
      	<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
      	<init-param>
      		
      		<param-name>contextConfigLocation</param-name>
      		<param-value>classpath:springmvc.xml</param-value>
      	</init-param>
      </servlet>
      <servlet-mapping>
      	<servlet-name>springmvc</servlet-name>
      	
      	<url-pattern>/</url-pattern>
      </servlet-mapping>
      
    </web-app>

## applicationContext\_mapper.xml: ##

注意：如果这里连接数据库出错，就把name="username"改为 name="user"试试！这里用username极有可能报错 ！

<?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"
    	xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-4.3.xsd
    		http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.3.xsd">
    		
    		
    		<context:property-placeholder location="classpath:db.properties"/>
    		
    		
    		<bean name="dataSource" class="com.alibaba.druid.pool.DruidDataSource">
    			<property name="driverClassName" value="${jdbc.driverClass}"/>
    			<property name="url" value="${jdbc.jdbcUrl}"/>
    			<property name="username" value="${jdbc.user}"/>
    			<property name="password" value="${jdbc.password}"/>
    		</bean>
    		
    		
    		<bean name="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
    			<property name="dataSource" ref="dataSource"/>
    			<property name="typeAliasesPackage" value="com.sikiedu.bean"/>
    		</bean>
    		
    		
    		<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
    			<property name="basePackage" value="com.sikiedu.mapper"/>
    		</bean>
    		
    		
    </beans>

## applicationContext\_service.xml: ##

## applicationContext\_transaction.xml: ##

## db.properties: ##

jdbc.driverClass=com.mysql.jdbc.Driver
    jdbc.jdbcUrl=jdbc:mysql://localhost:3306/ssm_steam
    jdbc.user=root
    jdbc.password=123

## springmvc.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:mvc="http://www.springframework.org/schema/mvc"
    	xsi:schemaLocation="http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc-4.3.xsd
    		http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-4.3.xsd
    		http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.3.xsd">
    		
    		
    		
    		
    		
    		<context:component-scan base-package="com.sikiedu.controller"/>
    		
    		
    		<mvc:annotation-driven/>
    		
    		
    		<bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
    			<property name="prefix" value="/WEB-INF/jsp/"/>
    			<property name="suffix" value=".jsp"/>
    		</bean>
    		
    		
    		<bean name="multipartResolver" class="org.springframework.web.multipart.commons.CommonsMultipartResolver"/>
    		
    </beans>

热部署：

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwMzIzMjU2_size_16_color_FFFFFF_t_70][]

# 例1：输出lijiang Servlet #

新建Maven项目，配置：pom.xml，web.xml。（直接复制上面的代码）

再新建servlet，注解值为“/test”

![20190513142847323.png][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwMzIzMjU2_size_16_color_FFFFFF_t_70 1][]

测试：

先打开D:\\apache-tomcat-v8.0.53\\apache-tomcat-8.0.53\\bin\\**startup.bat**

再点击Maven build...，输入：**clean tomcat7:redeploy **

运行结果：

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwMzIzMjU2_size_16_color_FFFFFF_t_70 2][]

![20190513143315544.png][]

# 例2：在例1的基础上拓展 #

### 项目网盘地址：[https://pan.baidu.com/s/10zAo3D0qM1m9uzMf8FvmMQ][https_pan.baidu.com_s_10zAo3D0qM1m9uzMf8FvmMQ]    提取码：ksr8 ###

下面红框是在例1的基础上新添加的内容

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwMzIzMjU2_size_16_color_FFFFFF_t_70 3][]

User.java:

package com.sikiedu.bean;
    
    public class User {
    	  private String username;
    	  private String password;
    	  
    	public String getUsername() {
    		return username;
    	}
    	public void setUsername(String username) {
    		this.username = username;
    	}
    	public String getPassword() {
    		return password;
    	}
    	public void setPassword(String password) {
    		this.password = password;
    	}
    	@Override
    	public String toString() {
    		return "User [username=" + username + ", password=" + password + "]";
    	}
    	  
    	
    }

UserController.java:

package com.sikiedu.controller;
    
    import org.springframework.stereotype.Controller;
    import org.springframework.ui.Model;
    import org.springframework.web.bind.annotation.RequestMapping;
    
    import com.sikiedu.bean.User;
    
    @Controller
    public class UserController {
    
    	@RequestMapping("/login")
    	public String login(User u,Model model){
    		
    		System.out.println("user="+u);
    		model.addAttribute("User", u);
    		return "list";
    	}
    }

list.jsp:

<%@ page language="java" contentType="text/html; charset=UTF-8"
        pageEncoding="UTF-8"%>
       <%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
    <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
    <html>
    <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
    <title>Insert title here</title>
    </head>
    <body>
    	用户名：<label>${User.username }</label>
    	密码：<label>${User.password }</label>
    </body>
    </html>

<%@ page language="java" contentType="text/html; charset=UTF-8"
        pageEncoding="UTF-8"%>
           <%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
    <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
    <html>
    <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
    <title>Insert title here</title>
    </head>
    <body>
    	<form action="${pageContext.request.contextPath }/login" method="get">
    		<input type="text" name="username">
    		<input type="text" name="password">
    		<input type="submit" name="提交">
    	</form>
    </body>
    </html>

运行结果：

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwMzIzMjU2_size_16_color_FFFFFF_t_70 4][]

![20190513150249388.gif][]

# 例3：Maven整合SSM 。（在例2的基础上继续拓展） #

### 项目网盘地址：[https://pan.baidu.com/s/1cVxoyymlNXj25ZxBmSwjog][https_pan.baidu.com_s_1cVxoyymlNXj25ZxBmSwjog]     提取码：irrl ###

下面红框里面是添加或者有修改的代码

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwMzIzMjU2_size_16_color_FFFFFF_t_70 5][]

ItemInfo.java:

package com.sikiedu.bean;
    
    public class ItemInfo {
    
    	private Integer item_id;
    	private String item_name;
    	private String item_type;
    	private Double item_price;
    	public Integer getItem_id() {
    		return item_id;
    	}
    	public void setItem_id(Integer item_id) {
    		this.item_id = item_id;
    	}
    	public String getItem_name() {
    		return item_name;
    	}
    	public void setItem_name(String item_name) {
    		this.item_name = item_name;
    	}
    	public String getItem_type() {
    		return item_type;
    	}
    	public void setItem_type(String item_type) {
    		this.item_type = item_type;
    	}
    	public Double getItem_price() {
    		return item_price;
    	}
    	public void setItem_price(Double item_price) {
    		this.item_price = item_price;
    	}
    	@Override
    	public String toString() {
    		return "ItemInfo [item_id=" + item_id + ", item_name=" + item_name + ", item_type=" + item_type
    				+ ", item_price=" + item_price + "]";
    	}
    	
    	
    }

ItemMapper.java:

package com.sikiedu.mapper;
    
    import java.util.List;
    
    import com.sikiedu.bean.ItemInfo;
    
    public interface ItemMapper {
    
    	List<ItemInfo> getAllList();
    
    }

ItemMapper.xml:

<?xml version="1.0" encoding="UTF-8" ?>
    <!DOCTYPE mapper    
    PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"    
    "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
     
    <mapper namespace="com.sikiedu.mapper.ItemMapper">
     
    
    	<select id="getAllList" resultType="ItemInfo">
    		select * from item_info
    	</select>
     
    </mapper>

ItemService.java:

package com.sikiedu.service;
    
    import java.util.List;
    
    import com.sikiedu.bean.ItemInfo;
    
    public interface ItemService {
    
    	List<ItemInfo> getAllList();
    
    }

ItemServicelmpl.java:

package com.sikiedu.service;
    
    import java.util.List;
    
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.stereotype.Service;
    
    import com.sikiedu.bean.ItemInfo;
    import com.sikiedu.mapper.ItemMapper;
    
    @Service
    public class ItemServicelmpl implements ItemService {
    
    	@Autowired
    	private ItemMapper itemMapper;
    	
    	@Override
    	public List<ItemInfo> getAllList() {
    		return itemMapper.getAllList();
    	}
    
    }

db.properties:（这里的数据库名改为了web01）

jdbc.driverClass=com.mysql.jdbc.Driver
    jdbc.jdbcUrl=jdbc:mysql://localhost:3306/web01
    jdbc.user=root
    jdbc.password=root

item\_List.jsp:

<%@ page language="java" contentType="text/html; charset=UTF-8"
        pageEncoding="UTF-8"%>
       <%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
    <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
    <html>
    <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
    <title>Insert title here</title>
    </head>
    <body>
    	<c:forEach items="${itemList }" var="item">
    		<label>${item.item_name }</label><label>${item.item_type }</label>
    	</c:forEach>
    	
    </body>
    </html>

<%@ page language="java" contentType="text/html; charset=UTF-8"
        pageEncoding="UTF-8"%>
           <%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
    <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
    <html>
    <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
    <title>Insert title here</title>
    </head>
    <body>
    	<form action="${pageContext.request.contextPath }/login" method="get">
    		<input type="text" name="username">
    		<input type="text" name="password">
    		<input type="submit" name="提交">
    	</form>
    	
    	<button onclick="window.location='${pageContext.request.contextPath}/list'">游戏列表</button>
    </body>
    </html>

数据库：

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwMzIzMjU2_size_16_color_FFFFFF_t_70 6][]![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwMzIzMjU2_size_16_color_FFFFFF_t_70 7][]

运行结果：

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwMzIzMjU2_size_16_color_FFFFFF_t_70 8][]

![20190514101139215.gif][]![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwMzIzMjU2_size_16_color_FFFFFF_t_70 9][]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwMzIzMjU2_size_16_color_FFFFFF_t_70]: /images/20210725/2867a4e6c4254412821dfd274fb94d27.png
[20190513142847323.png]: /images/20210725/b17e665710cc49199624be2cfce34825.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwMzIzMjU2_size_16_color_FFFFFF_t_70 1]: /images/20210725/2d1a08ab063148d6b52f946ed37e5e98.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwMzIzMjU2_size_16_color_FFFFFF_t_70 2]: /images/20210725/e555fa9bd2ca4e87b84565c3726e4cab.png
[20190513143315544.png]: /images/20210725/0b3ca7b436a84bb7b91662e8d039a40c.png
[https_pan.baidu.com_s_10zAo3D0qM1m9uzMf8FvmMQ]: https://pan.baidu.com/s/10zAo3D0qM1m9uzMf8FvmMQ
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwMzIzMjU2_size_16_color_FFFFFF_t_70 3]: /images/20210725/4d1b5973cb0e48c6b2cb3efa9880f4c2.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwMzIzMjU2_size_16_color_FFFFFF_t_70 4]: /images/20210725/f991d996be9f4eb488042bb740d1a04e.png
[20190513150249388.gif]: /images/20210725/e478118603cc4fe5bdc163eeeb05de61.png
[https_pan.baidu.com_s_1cVxoyymlNXj25ZxBmSwjog]: https://pan.baidu.com/s/1cVxoyymlNXj25ZxBmSwjog
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwMzIzMjU2_size_16_color_FFFFFF_t_70 5]: /images/20210725/34116d38e30c415b859cc35dbeffa0bb.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwMzIzMjU2_size_16_color_FFFFFF_t_70 6]: https://img-blog.csdnimg.cn/20190514100902700.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwMzIzMjU2,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwMzIzMjU2_size_16_color_FFFFFF_t_70 7]: /images/20210725/473c64aa98434fd4b9ef47f3bcd7d610.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwMzIzMjU2_size_16_color_FFFFFF_t_70 8]: /images/20210725/a5f40a78ad784a5e9f05642e2c8f5020.png
[20190514101139215.gif]: https://img-blog.csdnimg.cn/20190514101139215.gif
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwMzIzMjU2_size_16_color_FFFFFF_t_70 9]: /images/20210725/0c74e00a8f114cb2826e659799224271.png