SSM框架入门搭建

最新推荐文章于 2024-06-11 07:55:51 发布

isAya

最新推荐文章于 2024-06-11 07:55:51 发布

阅读量197

点赞数

文章标签： SSM JAVA

本文链接：https://blog.csdn.net/weixin_43687167/article/details/87019166

版权

简介

使用Spring+SpringMVC+Mybatis搭建一个基本的学生和班级的基本项目
实现学生表的全查和增加

步骤分析

数据库建表
导入jar包
mybats配置
– mapper.xml和mapper代理接口
Spring配置
SpringMVC配置
业务逻辑实现
测试

开始搭建

创建数据库和表并插入测试数据


CREATE DATABASE test;

USE test;

CREATE TABLE student(
	sid INT PRIMARY KEY AUTO_INCREMENT,
	sname VARCHAR(50) NOT NULL,
	sex INT NOT NULL,
	sage INT NOT NULL,
	cid INT NOT NULL REFERENCES clazz(cid)
);

CREATE TABLE clazz(
	cid INT PRIMARY KEY AUTO_INCREMENT,
	cname VARCHAR(50)
);

INSERT INTO clazz VALUES(NULL,'一班');
INSERT INTO clazz VALUES(NULL,'二班');

INSERT INTO student VALUES(NULL,'AA',0,20,1);
INSERT INTO student VALUES(NULL,'BB',1,21,2);
INSERT INTO student VALUES(NULL,'CC',0,20,2);

然后创建一个web工程，首先导入jar包

jar包分析

首先是Spring的jar包
Spring-core.jar —— spring核心包必不可少
Spring-beans.jar —— Ioc相关包同样基本必不可少
Spring-context.jar —— 扩展包，JDNI和校验等拓展，依赖Spring-beans，必须
Spring-context-support.jar —— 依赖Spring-context，可能会用到，这里也引入
Spring-tx.jar —— 事务相关
Spring-jdbc.jar —— jdbc相关
Spring-expression.jar —— 表达式语言
Spring-web.jar —— 支持web开发相关的包含比如文件上传，过滤器等
Mybatis
我们这里只是一个测试的基本项目所以只要引入mybatis.jar和整合包mybatis-spring.jar就已经够用了
如果需要更多mybatis依赖的jar包，从官方下载的压缩包中就已经包含了可以根据需要添加
SpringMVC
因为SpringMVC和Spring属于一家所以只要引入Spring-webmvc.jar就行不需要额外的整合包
其它
mysql的连接驱动jar包mysql-connector-java.jar
数据库连接池，这里使用dbcp2连接池
所以需要用引入dbcp2所依赖的三个jar包
commons-dbcp2.jar
commons-logging.jar
commons-pool2.jar
如果需要使用其他的数据库连接池按情况更换即可
再引入java标准标签库jstl.jar和standrd.jar
日志相关log4j等有需要可自行引入

首先创建数据库表的映射实体实体类

package org.hua.entity;

public class Student {

	private Integer sid;
	private String sname;
	private Integer sex;
	private Integer sage;
	//配置映射多对一关系，多方持有一方对象
	private Clazz cl;

	//getter,setter,toString 
}
package org.hua.entity;

public class Clazz {

	private Integer cid;
	private String cname;
	
	//getter,setter,toString 
}

然后创建mapper.xml和mapper代理接口
因为两者互相依赖关系紧密所以一般把他们两个放到同一个包下

<?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="org.hua.mapper.StudentMapper">
	
	<select id="stuQueryAll" resultMap="stuResultMap">
		select * from student s,clazz c where s.cid=c.cid
	</select>
	
	
	<insert id="stuAdd" parameterType="student">
		insert into
			student
		values(
			null,
			#{sname},
			#{sex},
			#{sage},
			#{cl.cid}
		)
	</insert>

	<resultMap type="student" id="stuResultMap">
		<id column="sid" property="sid"/>
		<result column="sname" property="sname"/>
		<result column="sex" property="sex"/>
		<result column="sage" property="sage"/>
		<association property="cl" javaType="clazz">
			<id column="cid" property="cid"/>
			<result column="cname" property="cname"/>
		</association>
	</resultMap>
	
</mapper>

package org.hua.mapper;

import java.util.List;

import org.hua.entity.Student;

public interface StudentMapper {

	List<Student> stuQueryAll();
	
	void stuAdd(Student s);
	
}

创建spring配置文件

通常我们会取名为applicaionContext.xml,然后在里边配置各个bean，包括Mybatis和SpringMVC的配置，但是我们一般不把SpringMVC的配置也配置到一块，这里我们分开

<?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/beans http://www.springframework.org/schema/beans/spring-beans.xsd
		http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.3.xsd
		http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc-4.3.xsd">

	<!-- 开启包扫描 -->
	<context:component-scan base-package="org.hua"></context:component-scan>
	
	<!-- 数据源 -->
	<bean id="dataSource" class="org.apache.commons.dbcp2.BasicDataSource">
		<property name="driverClassName" value="com.mysql.cj.jdbc.Driver" />
		<property name="url" value="jdbc:mysql:///test?useUnicode=true&amp;characterEncoding=utf-8&amp;useSSL=false&amp;serverTimezone=GMT%2B8" />
		<property name="username" value="root" />
		<property name="password" value="123456" />
	</bean>
	
	<!-- SqlSessionFactory -->
	<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
		<property name="dataSource" ref="dataSource"></property>
		<!-- 把给出包路径下的所有数据库表的实体映射类批量设置别名，别名默认为类名不区分大小写 -->
		<property name="typeAliasesPackage" value="org.hua.entity"></property>
		<!-- 映射mapper文件路径 -->
		<property name="mapperLocations" value="classpath:org/hua/mapper/*.xml"></property>
		
	</bean>
	
	<!-- 批量产生mapper动态代理对象 -->
	<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
		<property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"></property>
		<property name="basePackage" value="org.hua.mapper"></property>
	</bean>
	
</beans>

搭建三层架构

由于我们使用的是mapper动态代理方式来实现的dao层，所以并不需要再进行进行传统方式的dao层实现，mapper直接可以替代dao层。
直接开始service层

package org.hua.service;

import java.util.List;

import org.hua.entity.Student;

public interface StudentService {
	
	List<Student> stuQueryAll();
	
	void stuAdd(Student s);
	
}

service层实现


package org.hua.service.impl;

import java.util.List;

import org.hua.entity.Student;
import org.hua.mapper.StudentMapper;
import org.hua.service.StudentService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

@Service
public class StudentServiceImpl implements StudentService {

	@Autowired
	private StudentMapper sm;
	
	public void setSm(StudentMapper sm) {
		this.sm = sm;
	}

	@Override
	public List<Student> stuQueryAll() {
		// TODO Auto-generated method stub
		return sm.stuQueryAll();
	}

	@Override
	public void stuAdd(Student s) {
		// TODO Auto-generated method stub
		sm.stuAdd(s);
	}
	
	
}

controller层

package org.hua.controller;

import org.hua.entity.Student;
import org.hua.service.StudentService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.servlet.ModelAndView;

@Controller
public class StudentController {

	@Autowired
	private StudentService ss;

	public void setSs(StudentService ss) {
		this.ss = ss;
	}
	
	@RequestMapping("stuQueryAll")
	public ModelAndView stuQueryAll() {
		ModelAndView mav=new ModelAndView();
		mav.setViewName("stuShow");
		mav.addObject("stuli", ss.stuQueryAll());
		
		return mav;
	}
	
	@RequestMapping("stuAdd")
	public String stuAdd(Student s) {
		ss.stuAdd(s);
		
		return "redirect:stuQueryAll";
	}
	
}

然后配置SpringMVC
创建spring-mvc.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/beans http://www.springframework.org/schema/beans/spring-beans.xsd
		http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.3.xsd
		http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc-4.3.xsd">
	<!-- 包扫描 -->
	<context:component-scan base-package="org.hua.controller"></context:component-scan>
	
	<!-- SpringMVC 配置 -->
	<mvc:annotation-driven></mvc:annotation-driven>
	
	<!-- 视图解析器 -->
	<bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
		<property name="prefix" value="/"></property>
		<property name="suffix" value=".jsp"></property>
	</bean>
		
</beans>

然后在web.xml文件中配置Spring监听器和SpringMVC过滤器

<?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>SSMDemo</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>
  
  <!-- needed for ContextLoaderListener -->
	<context-param>
		<param-name>contextConfigLocation</param-name>
		<param-value>classpath:applicationContext.xml</param-value>
	</context-param>

	<!-- Bootstraps the root web application context before servlet initialization -->
	<listener>
		<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
	</listener>
	
	<!-- The front controller of this Spring Web application, responsible for handling all application requests -->
	<servlet>
		<servlet-name>springDispatcherServlet</servlet-name>
		<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
		<init-param>
			<param-name>contextConfigLocation</param-name>
			<param-value>classpath:spring-mvc.xml</param-value>
		</init-param>
		<load-on-startup>1</load-on-startup>
	</servlet>
	 
	<!-- Map all requests to the DispatcherServlet for handling -->
	<servlet-mapping>
		<servlet-name>springDispatcherServlet</servlet-name>
		<!-- 拦截所有请求 -->
		<url-pattern>/</url-pattern>
	</servlet-mapping>
	
</web-app>

然后写前台页面，创建index.jsp放一个超链跳转到全查页面

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
	<h1 align="center">你好，请<a href="stuQueryAll">点一下</a> </h1>
</body>
</html>

全查页面

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
	<table style="margin: auto">
		<tr align="center">
			<td>编号</td>
			<td>姓名</td>
			<td>性别</td>
			<td>年龄</td>
			<td>班级</td>
		</tr>
		<c:forEach items="${stuli}" var="stu">
			<tr>
				<td> ${stu.sid} </td>
				<td> ${stu.sname} </td>
				<td>
					<c:if test="${stu.sex==0}">女</c:if>
					<c:if test="${stu.sex==1}">男</c:if>
				</td>
				<td> ${stu.sage} </td>
				<td> ${stu.cl.cname} </td>
			</tr>
		</c:forEach>
		<tr>
			<td colspan="5" align="center">
				<a href="add.jsp">增加</a>
			</td>
		</tr>
	</table>
</body>
</html>

增加页面

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
	<form action="stuAdd" method="post" style="margin-left:40%;">
		姓名: <input type="text" name="sname"><br>
		性别: 男<input type="radio" name="sex" value="1">
			女<input type="radio" name="sex" value="0"><br>
		年龄: <input type="number" name="sage"><br>
		班级: <select name="cl.cid">
			<option value="1">一班</option>
			<option value="2">二班</option>
		</select><br>
		<input type="submit" value="提交">
	</form>
</body>
</html>

然后把项目放到tomcat中并启动，直接访问项目根路径
index.jsp
点击
在这里插入图片描述
添加一名学生

isAya

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
SSM框架入门搭建

简介使用Spring+SpringMVC+Mybatis搭建一个基本的学生和班级的基本项目实现学生表的CRUD步骤分析数据库建表xml文件配置– spring配置文件– mybatis配置– SpringMVC配置业务逻辑实现测试开始搭建创建数据库和表并插入测试数据CREATE DATABASE test;USE test;CREATE TABLE stud...
复制链接

扫一扫