SSM项目小测试

最新推荐文章于 2023-10-06 18:10:05 发布

Diligent little pig

最新推荐文章于 2023-10-06 18:10:05 发布

阅读量484

点赞数

分类专栏：入门案例文章标签： java spring mvc mysql eclipse

原文链接：https://pan.baidu.com/s/1xf4EhQSiY3Ks2yN6iZjaiA%20

版权

入门案例专栏收录该内容

5 篇文章 0 订阅

订阅专栏

ssm项目的小测试

1、相关工具
2、相关数据库语句
3、配置相关文件
4、相关类
5、前端的静态资源---webapp
6、小结

初步整合ssm项目

1、相关工具

1.eclipse----需要安装好maven
2.mysql----SQLyog.exe

2、相关数据库语句

创建一个名为test1的数据库，在库中创建一个people表：pid为主键，表中有五个属性----编号，姓名，性别，年龄，出生日期。插入几条数据。

CREATE DATABASE test1 CHARSET utf8;
DROP DATABASE test1;
CREATE TABLE people(
pid INT PRIMARY KEY AUTO_INCREMENT COMMENT&apos;编号&apos;,
pname VARCHAR(20) NOT NULL COMMENT &apos;姓名&apos;,
psex CHAR(1) COMMENT &apos;性别&apos;,
page INT COMMENT &apos;年龄&apos;,
pbir DATE COMMENT &apos;出生日期&apos; 
);

INSERT INTO people(pname,psex,page,pbir)
VALUES
(&apos;张飞&apos;,&apos;1&apos;,30,&apos;1990-1-1&apos;),
(&apos;关羽&apos;,&apos;1&apos;,33,&apos;1987-1-1&apos;),
(&apos;刘备&apos;,&apos;1&apos;,35,&apos;1985-1-1&apos;),
(&apos;诸葛亮&apos;,&apos;1&apos;,20,&apos;2000-1-1&apos;),
(&apos;黄忠&apos;,&apos;1&apos;,50,&apos;1970-1-1&apos;)

INSERT INTO people(pname,psex,page,pbir)
VALUES
(&apos;貂蝉&apos;,&apos;0&apos;,15,&apos;2005-1-1&apos;),
(&apos;小乔&apos;,&apos;0&apos;,14,&apos;2006-1-1&apos;),
(&apos;大乔&apos;,&apos;0&apos;,13,&apos;2007-1-1&apos;),
(&apos;甄氏&apos;,&apos;0&apos;,12,&apos;2008-1-1&apos;),
(&apos;卞氏&apos;,&apos;0&apos;,16,&apos;2004-1-1&apos;)

3、配置相关文件

3.1、导入jar包—pom.xml

 <dependencies>
  	<!-- springmvc包 -->
  	<dependency>
  		<groupId>org.springframework</groupId>
  		<artifactId>spring-webmvc</artifactId>
  		<version>4.3.27.RELEASE</version>
  	</dependency>
  	<!-- spring包 -->
  	<dependency>
  		<groupId>org.springframework</groupId>
  		<artifactId>spring-jdbc</artifactId>
  		<version>4.3.27.RELEASE</version>
  	</dependency>
  	<dependency>
  		<groupId>org.springframework</groupId>
  		<artifactId>spring-aspects</artifactId>
  		<version>4.3.27.RELEASE</version>
  	</dependency>
  	<!-- mybatis包 -->
  	<dependency>
  		<groupId>org.mybatis</groupId>
  		<artifactId>mybatis</artifactId>
  		<version>3.4.6</version>
  	</dependency>
  	<!-- 整合包 -->
  	<dependency>
  		<groupId>org.mybatis</groupId>
  		<artifactId>mybatis-spring</artifactId>
  		<version>1.3.2</version>
  	</dependency>
  	<!-- 驱动包 -->
  	<dependency>
  		<groupId>mysql</groupId>
  		<artifactId>mysql-connector-java</artifactId>
  		<version>5.1.47</version>
  	</dependency>
  	<!-- 连接池包 -->
  	<dependency>
	    <groupId>com.alibaba</groupId>
	    <artifactId>druid</artifactId>
	    <version>1.1.10</version>
	</dependency>
  	<!-- jstl包 -->
  	<dependency>
  		<groupId>javax.servlet</groupId>
  		<artifactId>jstl</artifactId>
  		<version>1.2</version>
  	</dependency>
  	<!-- json转换包 -->
  	<dependency>
	    <groupId>com.fasterxml.jackson.core</groupId>
	    <artifactId>jackson-databind</artifactId>
	    <version>2.9.8</version>
	</dependency>
  	<!-- 日志包 -->
  	<dependency>
	    <groupId>log4j</groupId>
	    <artifactId>log4j</artifactId>
	    <version>1.2.17</version>
	</dependency>
  	<!-- 上传包 -->
  	<dependency>
	    <groupId>commons-fileupload</groupId>
	    <artifactId>commons-fileupload</artifactId>
	    <version>1.3.3</version>
	</dependency>
  	
  </dependencies>

3.2、springmvc----springmvc.xml

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
		xmlns:context="http://www.springframework.org/schema/context"
		xmlns:aop="http://www.springframework.org/schema/aop"
		xmlns:tx="http://www.springframework.org/schema/tx"
		xmlns:mvc="http://www.springframework.org/schema/mvc"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xsi:schemaLocation="http://www.springframework.org/schema/beans
        https://www.springframework.org/schema/beans/spring-beans.xsd
        http://www.springframework.org/schema/context
        https://www.springframework.org/schema/context/spring-context.xsd
        http://www.springframework.org/schema/aop
        https://www.springframework.org/schema/aop/spring-aop.xsd
        http://www.springframework.org/schema/tx
        https://www.springframework.org/schema/tx/spring-tx.xsd
        http://www.springframework.org/schema/mvc
        https://www.springframework.org/schema/mvc/spring-mvc.xsd">
	<!-- 扫描包 -->
	<!-- springmvc层只扫描controller层，不扫描service、dao层 -->
	<context:component-scan base-package="com.offcn">
	</context:component-scan>
	
	<!-- 注解驱动 -->
	<!-- 注册工厂 -->
	<mvc:annotation-driven conversion-service="conversionService"></mvc:annotation-driven>
	<!-- 取消静态资源的拦截 -->
	<mvc:default-servlet-handler/>
	
	<!-- 日期转换器的配置 -->
	<bean id="conversionService"
        class="org.springframework.context.support.ConversionServiceFactoryBean">
	    <property name="converters">
	        <set>
	            <bean class="com.offcn.converter.DateConverter"/>
	        </set>
	    </property>
	</bean>
	
	<!-- 上传解析器 -->
	<!-- id名称固定 -->
	<bean id="multipartResolver" class="org.springframework.web.multipart.commons.CommonsMultipartResolver">
	</bean>
    
</beans>

3.3、配置spring文件—application.xml

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
		xmlns:context="http://www.springframework.org/schema/context"
		xmlns:aop="http://www.springframework.org/schema/aop"
		xmlns:tx="http://www.springframework.org/schema/tx"
		xmlns:mvc="http://www.springframework.org/schema/mvc"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xsi:schemaLocation="http://www.springframework.org/schema/beans
        https://www.springframework.org/schema/beans/spring-beans.xsd
        http://www.springframework.org/schema/context
        https://www.springframework.org/schema/context/spring-context.xsd
        http://www.springframework.org/schema/aop
        https://www.springframework.org/schema/aop/spring-aop.xsd
        http://www.springframework.org/schema/tx
        https://www.springframework.org/schema/tx/spring-tx.xsd
        http://www.springframework.org/schema/mvc
        https://www.springframework.org/schema/mvc/spring-mvc.xsd">
        
        
    <!-- 扫描 -->
    <context:component-scan base-package="com.offcn">
    	<!-- 不包含xxx扫描 -->
    	<context:exclude-filter type="annotation" expression="org.springframework.stereotype.Controller"/>
    </context:component-scan>
    
    <!-- 连接池 -->
    <!-- 管理连接对象 -->
    <bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource" init-method="init" destroy-method="close">
        <!-- 基本属性 url、user、password -->
        <property name="driverClassName" value="com.mysql.jdbc.Driver" />
        <property name="url" value="jdbc:mysql://localhost:3306/test1?characterEncoding=utf8" />
        <property name="username" value="username" />
        <property name="password" value="password" />

        <!-- 配置初始化大小、最小、最大 -->
        <property name="initialSize" value="1" />
        <property name="minIdle" value="1" />
        <property name="maxActive" value="20" />

        <!-- 配置获取连接等待超时的时间 -->
        <property name="maxWait" value="60000" />

        <!-- 配置间隔多久才进行一次检测，检测需要关闭的空闲连接，单位是毫秒 -->
        <property name="timeBetweenEvictionRunsMillis" value="60000" />

        <!-- 配置一个连接在池中最小生存的时间，单位是毫秒 -->
        <property name="minEvictableIdleTimeMillis" value="300000" />

        <property name="validationQuery" value="SELECT 'x'" />
        <property name="testWhileIdle" value="true" />
        <property name="testOnBorrow" value="false" />
        <property name="testOnReturn" value="false" />

        <!-- 打开PSCache，并且指定每个连接上PSCache的大小 -->
        <property name="poolPreparedStatements" value="true" />
        <property name="maxPoolPreparedStatementPerConnectionSize" value="20" />

        <!-- 配置监控统计拦截的filters，去掉后监控界面sql无法统计 -->
        <property name="filters" value="stat" />
    </bean>
    
    
    <!-- 事务管理 -->
    <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
    	<!-- 数据源注入 -->
    	<property name="dataSource" ref="dataSource"></property>
    </bean>
    <tx:annotation-driven transaction-manager="transactionManager"/>
    
    <!-- 会话工厂 -->
    <!-- mybatis中程序中创建工厂，加载核心文件 -->
    <bean id="factoryBean" class="org.mybatis.spring.SqlSessionFactoryBean">
    	<!-- 注入数据源 -->
    	<property name="dataSource" ref="dataSource"></property>
    	<!-- 注入映射文件 -->
    	<!-- classpath表示类路径；字节码文件所在目录 -->
    	<property name="mapperLocations" value="classpath:mappers/*.xml"></property>
    </bean>
    
    <!-- 持久层对象 -->
    <bean id="mapperScanner" class="org.mybatis.spring.mapper.MapperScannerConfigurer">
    	<!-- 指定持久层接口的位置 -->
    	<property name="basePackage" value="com.offcn.dao"></property>
    </bean>
</beans>

4、相关类

4.1 实体类—bean

//与数据库中的people表一一对应
public class People {
	private Integer pid;//编号
	private String pname;//姓名
	private String psex;//性别
	private Integer page;//年龄
	private Date pbir;//出生日期
	public Integer getPid() {
		return pid;
	}
	public void setPid(Integer pid) {
		this.pid = pid;
	}
	public String getPname() {
		return pname;
	}
	public void setPname(String pname) {
		this.pname = pname;
	}
	public String getPsex() {
		return psex;
	}
	public void setPsex(String psex) {
		this.psex = psex;
	}
	public Integer getPage() {
		return page;
	}
	public void setPage(Integer page) {
		this.page = page;
	}
	public Date getPbir() {
		return pbir;
	}
	public void setPbir(Date pbir) {
		this.pbir = pbir;
	}
}

4.2、日期转换—converter

在实体类中日期是String类型，在people表中日期是date类型，所以需要转换

public class DateConverter implements Converter<String, Date>{

	@Override
	public Date convert(String str) {
		try {
			//一个字符串转日期
			SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
			Date parse = sdf.parse(str);
			return parse;
		} catch (ParseException e) {
			e.printStackTrace();
		}
		return null;
	}

}

4.3、持久层----dao

4.3.1、映射接口

public interface PeopleDao {

	public List<People> selectPeopleAll();
	
	public void insertPeople(People people);
}

4.3.2、映射文件

在resources下建立一个mappers文件夹，在文件夹下建立model.xml和people.xml

4.3.2.1、模型—封装数据–model.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.offcn.dao">
	
</mapper>

4.3.2.2、people映射文件—people.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.offcn.dao.PeopleDao">
	
	<!-- 查询所有 -->
	<select id="selectPeopleAll" resultType="com.offcn.bean.People">
		select * from people
	</select>
	<!-- 增加操作 -->
	<insert id="insertPeople" parameterType="com.offcn.bean.People">
		insert into people(pname,psex,page,pbir) value(#{pname},#{psex},#{page},#{pbir})
	</insert>
	</mapper>

4.4、业务逻辑接口—service

public interface PeopleService {

	public List<People> queryPeopleAll();
	
	public void savePeople(People people);
}

4.5、业务逻辑实现—serviceImpl

@Service
public class PeopleServiceImpl implements PeopleService{

	@Autowired
	private PeopleDao peopleDao;
	
	//查询
	@Override
	public List<People> queryPeopleAll() {
		List<People> ps = peopleDao.selectPeopleAll();
		return ps;
	}

	//保存
	@Override
	@Transactional //实现事务管理
	public void savePeople(People people) {
		peopleDao.insertPeople(people);
	}

}

4.6、控制层—controller

@Controller
@RequestMapping("people")
public class PeopleController {
	
	@Autowired
	private PeopleService peopleService;
	
	//查看
	@RequestMapping("people-show")
	public String peopleShow(Model model){
		
		List<People> ps = peopleService.queryPeopleAll();
		//送数据去页面
		model.addAttribute("ps", ps);
		return "/WEB-INF/views/people/peopleshow.jsp";
	}
	
	//显示添加页面
	@RequestMapping("people-add-show")
	public String peopleAddShow(){
		return "/WEB-INF/views/people/peopleadd.jsp";
	}
	
	//添加功能实现
	@RequestMapping("people-add")
	public String peopleAdd(People people){
		peopleService.savePeople(people);
		return "redirect:/people/people-show";
	}
}

5、前端的静态资源—webapp

5.1、登录界面—index.jsp

<%@ page language="java" contentType="text/html; charset=utf-8"
    pageEncoding="utf-8"%>
<!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>首页</title>
</head>
<body>
<!-- 给请求分组 -->
<a href="${pageContext.request.contextPath }/people/people-show">查看人员列表</a><br>
<a href="${pageContext.request.contextPath }/people/people-add-show">进入人员添加界面</a>
</body>
</html>

5.2、内部浏览器访问—WEB-INF

5.2.1、web.xml

<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://java.sun.com/xml/ns/javaee" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd" id="WebApp_ID" version="3.0">
	<!-- 加载spring配置文件 -->
	<!-- 上下文初始化 -->
	<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>
	
	<!-- post请求中文乱码过滤器 -->
	<filter>
		<filter-name>characterEncodingFilter</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>characterEncodingFilter</filter-name>
		<url-pattern>/*</url-pattern>
	</filter-mapping>
	<!-- 前端控制器 -->
	<servlet>
		<servlet-name>dispatcherServlet</servlet-name>
		<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
		<!-- 加载springmvc配置文件 -->
		<init-param>
			<param-name>contextConfigLocation</param-name>
			<param-value>classpath:springmvc.xml</param-value>
		</init-param>
	</servlet>
	<servlet-mapping>
		<servlet-name>dispatcherServlet</servlet-name>
		<!-- 初步拦截 -->
		<url-pattern>/</url-pattern>
	</servlet-mapping>
</web-app>

5.2.2、配置jsp 显示ViewResolver

例如在controller中某个方法返回一个string类型的"login"，实际上会返回"/WEB-INF/login.jsp"

5.2.2.1、人员列表显示界面

在WEB-INF下建议一个views文件夹，在文件夹下建立一个people文件，在people文件下建立peopleshow.jsp
加一层people的目的：分组

<%@ page language="java" contentType="text/html; charset=utf-8"
    pageEncoding="utf-8"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
<%@ taglib uri="http://java.sun.com/jsp/jstl/fmt" prefix="fmt" %>    
<!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>人员列表</title>
</head>
<body>
列表。。。。。。。。
<hr>
<table border=1 width=100% cellspacing=0>
	<tr>
		<td>编号</td>
		<td>姓名</td>
		<td>性别</td>
		<td>年龄</td>
		<td>日期</td>
	</tr>
	<c:forEach items="${ps }" var="peo">
		<tr>
			<td>${peo.pid }</td>
			<td>${peo.pname }</td>
			<td>
				<c:if test="${peo.psex == 1 }">男</c:if>
				<c:if test="${peo.psex == 0 }">女</c:if>
			</td>
			<td>${peo.page }</td>
			<td>
				<fmt:formatDate value="${peo.pbir }" pattern="yyyy-MM-dd"/>
			</td>
		</tr>
	</c:forEach>
</table>
</body>
</html>

5.2.2.2、人员添加界面—peopleadd.jsp

<%@ page language="java" contentType="text/html; charset=utf-8"
    pageEncoding="utf-8"%>
<!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>人员添加界面</title>
</head>
<body>
<p>人员添加</p>
<form action="${pageContext.request.contextPath }/people/people-add" method="post">
	<p>姓名<input name="pname"></p>
	<p>性别<input name="psex"></p>
	<p>年龄<input name="page"></p>
	<p>日期<input name="pbir"></p>
	<p><input type="submit" value="提交"></p>
</form>
</body>
</html>

6、小结

6.1、spring中事务管理

通常service业务层一个方法相当于一个事务单元，在这个事务单元中多个增删改查操作，保证要成功都成功、要失败都失败，要保证就需要在方法的前、后、异常、最终切入增强，实现事务管理
在spring中提供了有增强方法的类，通过相关的配置把增强切入到相应的位置

6.2、springmvc

（1）和界面、视图交互，负责接收请求、做出响应
（2）表现层/web层应用框架
（3）属于spring的子框架，和spring整合—天然的整合

6.3、后端控制器

（1）后端控制器类实现接口Controller – 入门案例
（2）另一种实现：类上添加注解—@Controller @RequestMapping、配置文件中添加配置—扫描包注解驱动

6.4、数据传递

（1）从界面传到后端控制器
A、超链接、表单传输数据—到后端控制器
B、可以设置默认值、post请求时中文乱码
（2）从后端控制器传回界面

Diligent little pig

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
SSM项目小测试

ssm项目的小测试1、相关工具2、相关数据库语句3、配置相关文件3.1、导入jar包---pom.xml3.2、springmvc----springmvc.xml3.3、配置spring文件---application.xml4、相关类4.1 实体类---bean4.2、日期转换---converter4.3、持久层----dao4.3.1、映射接口4.3.2、映射文件4.3.2.1、模型---封装数据--model.xml4.3.2.2、people映射文件---people.xml4.4、业务逻辑
复制链接

扫一扫