SSM 整合+Maven+ Bootstrap搭建简单项目（基础+主要代码）

水深无声 2022-03-08 15:52 847阅读 0赞

最近公司要求搭建展示数据的Web平台，虽然只是进行简单的查询展示操作，但正好可以用来练练手。此项目应用Spring+SpringMVC+Mybatis+Maven+Bootstrap。本人技术小白，如有写的不对的地方，欢迎大家批评指正，谢谢。

一.创建Maven工程（过程不累述）

1.目录结构如下图所示：相关文件层次应该一目了然，后面会做详细解读

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwNjA4NDI1_size_16_color_FFFFFF_t_70][]

2.maven依赖导入

maven的依赖位于pom.xml中，要导入ssm等相关jar包的依赖，具体如下

<dependency>
    			<groupId>org.springframework</groupId>
    			<artifactId>spring-webmvc</artifactId>
    			<version>4.3.7.RELEASE</version>
    		</dependency>
    
     		
    		<dependency>
    			<groupId>com.github.pagehelper</groupId>
    			<artifactId>pagehelper</artifactId>
    			<version>5.0.0</version>
    		</dependency>
    
    		
    		<dependency>
    			<groupId>com.fasterxml.jackson.core</groupId>
    			<artifactId>jackson-databind</artifactId>
    			<version>2.8.8</version>
    		</dependency>
    
    		
    		<dependency>
    			<groupId>org.hibernate</groupId>
    			<artifactId>hibernate-validator</artifactId>
    			<version>5.4.1.Final</version>
    		</dependency>
    
    
    		
    		<dependency>
    			<groupId>org.springframework</groupId>
    			<artifactId>spring-jdbc</artifactId>
    			<version>4.3.7.RELEASE</version>
    		</dependency>
    
    		
    		<dependency>
    			<groupId>org.springframework</groupId>
    			<artifactId>spring-test</artifactId>
    			<version>4.3.7.RELEASE</version>
    		</dependency>
    
    
    		
    		<dependency>
    			<groupId>org.springframework</groupId>
    			<artifactId>spring-aspects</artifactId>
    			<version>4.3.7.RELEASE</version>
    		</dependency>
    
    		
                    <dependency>
    			<groupId>org.mybatis</groupId>
    			<artifactId>mybatis</artifactId>
    			<version>3.4.2</version>
    		</dependency>
    
    		
    		<dependency>
    			<groupId>org.mybatis</groupId>
    			<artifactId>mybatis-spring</artifactId>
    			<version>1.3.1</version>
    		</dependency>
    
    		
    		<dependency>
    			<groupId>c3p0</groupId>
    			<artifactId>c3p0</artifactId>
    			<version>0.9.1</version>
    		</dependency>
    
    		
    		<dependency>
    			<groupId>mysql</groupId>
    			<artifactId>mysql-connector-java</artifactId>
    			<version>5.1.41</version>
    		</dependency>
    
    		
    		
    		<dependency>
    			<groupId>jstl</groupId>
    			<artifactId>jstl</artifactId>
    			<version>1.2</version>
    		</dependency>
    	
    		<dependency>
    			<groupId>javax.servlet</groupId>
    			<artifactId>javax.servlet-api</artifactId>
    			<version>3.0.1</version>
    			<scope>provided</scope>
    		</dependency>
    
    
    		
    		
    		<dependency>
    			<groupId>junit</groupId>
    			<artifactId>junit</artifactId>
    			<version>4.12</version>
    		</dependency>

二.Bootstrap

bootatrap是简单的前端框架，相关文件依赖可以去这个上面下载：[http://www.bootcss.com/][http_www.bootcss.com]

bootstrap相关教程可在此网站上学习：[http://www.runoob.com/bootstrap/bootstrap-tutorial.html][http_www.runoob.com_bootstrap_bootstrap-tutorial.html]

此项目中包括bootstrap、js、图片等相关静态资源都放在webapp目录下的static文件夹中。

三.Spring的相关配置

1.web.xml

启动Spring容器，制定spring配置文件applicationContext.xml的位置，并拦截来自前端的所有请求

<context-param>
    		<param-name>contextConfigLocation</param-name>
    		<param-value>classpath:applicationContext.xml</param-value>
    	</context-param>
    
    	
    	<listener>
    		<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
    	</listener>
    	
    	
    	
    	<servlet>
    		<servlet-name>dispatcherServlet</servlet-name>
    		<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
    		<load-on-startup>1</load-on-startup>
    	</servlet>
    
    	
    	<servlet-mapping>
    		<servlet-name>dispatcherServlet</servlet-name>
    		<url-pattern>/</url-pattern>
    	</servlet-mapping>

2.applicationContext.xml

在此配置文件中指定spring容器扫描的包（扫描除了controller之外的所有包），以及配置数据源、mybatis、事物控制等。

<context:component-scan base-package="com.bstc">
    		<context:exclude-filter type="annotation"
    			expression="org.springframework.stereotype.Controller" />
    	</context:component-scan>
    
    	
    	
    	<context:property-placeholder location="classpath:dbconfig.properties" />
    	<bean id="pooledDataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
    		<property name="jdbcUrl" value="${jdbc.jdbcUrl}"></property>
    		<property name="driverClass" value="${jdbc.driverClass}"></property>
    		<property name="user" value="${jdbc.user}"></property>
    		<property name="password" value="${jdbc.password}"></property>
    	</bean>
    
    	
    	<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
    		
    		<property name="configLocation" value="classpath:mybatis-config.xml"></property>
    		<property name="dataSource" ref="pooledDataSource"></property>
    		
    		<property name="mapperLocations" value="classpath:mapper/*.xml"></property>
    	</bean>
    
    	
    	<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
    		
    		<property name="basePackage" value="com.bstc.dao"></property>
    	</bean>
    	
    	
    	<bean id="sqlSession" class="org.mybatis.spring.SqlSessionTemplate">
    		<constructor-arg name="sqlSessionFactory" ref="sqlSessionFactory"></constructor-arg>
    		<constructor-arg name="executorType" value="BATCH"></constructor-arg>
    	</bean>
    	
    
    	
    	<bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
    		
    		<property name="dataSource" ref="pooledDataSource"></property>
    	</bean>
    	
    	<tx:annotation-driven transaction-manager="transactionManager"/>

三、SpringMVC配置文件

倘若没有在web.xml文件中指定springMVC配置文件的位置，则mvc配置文件默认位置在WEB-INF目录下，默认名为web.xml文件中前端控制器名-servlet.xml，此处为dispatcher-servlet.xml

此处使用IOC注解，并配置视图解析器

<context:component-scan base-package="com.bstc"/>
    
    
    	
    	<bean
    		class="org.springframework.web.servlet.view.InternalResourceViewResolver">
    		<property name="prefix" value="/WEB-INF/views/" />
    		<property name="suffix" value=".jsp" />
    	</bean>
    	
    	<mvc:annotation-driven></mvc:annotation-driven>
    	
    	
    	<mvc:default-servlet-handler/>

四、Mybatis配置文件

在Spring配置文件applicationContext.xml中已经指定了全局配置文件和mapper映射文件的位置

1.全局配置文件

此处启用驼峰命名法，使用别名，以及使用了分页插件

2.mapper映射文件

由于我的初始页面有四个查询条件栏（后续会有展示），最少输入一项就能查询出结果，所以此处使用了动态sql

<mapper namespace="com.bstc.dao.TestDao">
    	
    	<resultMap type="java.util.HashMap" id="FirstMap">
    		<id column="id" property="id" jdbcType="VARCHAR"/>
    		<result column="companyName" property="companyName" jdbcType="VARCHAR"/>
    	</resultMap>
    
            
    	<select id="getCompanyByFour" resultMap="FirstMap">
    		 select distinct cominfo.id,cominfo.companyName from cominfo,capabilityinfo
    		 <where>
    		   
    		    	cominfo.id=capabilityinfo.companyId
    		   
    		    <if test="id != null and id.length()>0">
    		        and cominfo.id=#{id}
    		    </if>
    		    <if test="companyName != null and companyName.length()>0">
    		    	and cominfo.companyName like "%"#{companyName}"%"
    		    </if>
    		    <if test="checkRange != null and checkRange.length()>0">
    		    	and capabilityinfo.checkRange=#{checkRange}
    		    </if>
    		    <if test="abilityName != null and abilityName.length()>0">
    		    	and capabilityinfo.name=#{abilityName}
    		    </if>
    		 </where>
    		 order by cominfo.id ASC
    	
    	</select>
    </mapper>

五.相关类的编写

1.dao层：根据查询参数得到公司列表

public interface TestDao {
    	
    	/**
    	 * 根据四个参数查询公司list
    	 * */
         List<Map<String, Object>> getCompanyByFour(@Param("id") String id,@Param("companyName")String companyName,
    			@Param("checkRange")String checkRange,@Param("abilityName")String abilityName);

2.service层

@Service
    public class TestService {
    	
    	@Autowired
    	private TestDao testDao;
    
            //测试map接收数据
    	public List<Map<String, Object>> getCompanyByFour(String id,String companyName,String checkRange,String abilityName){
    		
    		return testDao.getCompanyByFour(id,companyName,checkRange,abilityName);
    	}
    }

3.controller层，将从数据库查询到的信息返还给前端控制器

@Controller
    public class TestController {
    	
    	@Autowired
    	private TestService testService;
    
            @RequestMapping("/test")
    	public String test(@RequestParam(value="pn",defaultValue="1") Integer pn,HttpServletRequest request) {
    		String id = request.getParameter("id");
    		String companyName = request.getParameter("companyName");
    		String checkRange = request.getParameter("checkRange");
    		String abilityName = request.getParameter("abilityName");
    	  
    		List<Map<String, Object>> lists = testService.getCompanyByFour(id, companyName, checkRange, abilityName);
    		for(Map<String, Object> map:lists){
    			for(Entry<String, Object> e:map.entrySet()){
    				e.getKey();
    				e.getValue();
    				System.out.println(e.getKey() + ":" + e.getValue());
    			}
    		}
    		request.setAttribute("companyList", lists);
    		return "success";
    	}
    }

六.前端代码

由于前端中路径信息经常出错，所以我在head中得到根路径信息

<%  
    pageContext.setAttribute("APP\_PATH", request.getContextPath());  
%>

1.查询页面：此表单向controller层发送请求test.action

2.展示页面 success.jsp

<div class="container">
       	  <div class="row">
       	  	<div class="col-sm-12">
       	  		<h3 class="text-center">机构列表</h3>
       	  		<h4 class="text-right"><a href="${APP_PATH }/first.jsp">返回查询页</a></h4>
       	  	</div>
       	  </div>
       	 </div>
       	 
       <div class="container">
       	  <div class="row">
       	  	<div class="col-sm-12,row pre-scrollable">	 
    		   	<c:if test="${requestScope.companyList != null}">
    		   		<table class="table table-striped">
    		   			<tr>	  
    		   			  <th>机构名称</th>
    		   			  <th>机构ID(链接)</th>
    		   			</tr>
    		   			
    		   		<c:forEach items="${requestScope.companyList }" var="list">
    		   			
    		   			<tr>
    		   			<c:forEach items="${list }" var="map">
    			   			  <c:choose>
    			   			    <c:when test="${map.key == 'id' }">
    			   			       <th><a href="${APP_PATH}/getAll?id=${map.value}">${map.value}</a></th>
    			   			    </c:when>
    			   			    <c:otherwise>
    			   			       <th>${map.value}</th>
    			   			    </c:otherwise>
    			   			  </c:choose>	
    		   				       				
    		   			</c:forEach>
    		   			</tr>
    		   			</c:forEach>
    		   		</table>
    		   	</c:if>	   
    		 </div>	 
    	  </div>
       </div>

七.测试

1.查询：输入一个查询条件进行模糊查询

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwNjA4NDI1_size_16_color_FFFFFF_t_70 1][]

2.查询结果

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwNjA4NDI1_size_16_color_FFFFFF_t_70 2][]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwNjA4NDI1_size_16_color_FFFFFF_t_70]: /images/20220308/6e0066af243043c6a9724e19f968d199.png
[http_www.bootcss.com]: http://www.bootcss.com/
[http_www.runoob.com_bootstrap_bootstrap-tutorial.html]: http://www.runoob.com/bootstrap/bootstrap-tutorial.html
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwNjA4NDI1_size_16_color_FFFFFF_t_70 1]: /images/20220308/34e19934379b470088b02b4bbf119a82.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwNjA4NDI1_size_16_color_FFFFFF_t_70 2]: /images/20220308/2382328f7a344d3689b9f2a8b2462865.png