SSM=Spring+SpringMVC+Mybatis
SpringMVC容器:管理web相关的对象,主要是Controller,视图对象等,数据来自Servlce
Spring容器:管理Service,Dao,工具类等对象
Mybatis:访问数据库
用户处理过程:
用户发起请求—->SpringMVC的Controller——>Service——>Dao——->DB数据库
SpringMVC和Spring的关系:SpringMVC看做Spring的子容器,从继承角度来看,SpringMVC子容器可以访问Spring父容器的对象
- 项目目录:
- 在pom.xml文件中导入依赖:
<dependencies>
<!-- https://mvnrepository.com/artifact/org.junit.jupiter/junit-jupiter-api -->
<dependency>
<groupId>org.junit.jupiter</groupId>
<artifactId>junit-jupiter-api</artifactId>
<version>5.6.2</version>
<scope>test</scope>
</dependency>
<!-- https://mvnrepository.com/artifact/javax.servlet/javax.servlet-api -->
<dependency>
<groupId>javax.servlet</groupId>
<artifactId>javax.servlet-api</artifactId>
<version>4.0.1</version>
<scope>provided</scope>
</dependency>
<!-- https://mvnrepository.com/artifact/org.springframework/spring-webmvc -->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-webmvc</artifactId>
<version>5.2.8.RELEASE</version>
</dependency>
<!-- https://mvnrepository.com/artifact/com.alibaba/druid -->
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid</artifactId>
<version>1.1.10</version>
</dependency>
<!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java -->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.19</version>
</dependency>
<!-- https://mvnrepository.com/artifact/org.mybatis/mybatis -->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.4.6</version>
</dependency>
<!-- https://mvnrepository.com/artifact/org.mybatis/mybatis-spring -->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis-spring</artifactId>
<version>1.3.2</version>
</dependency>
<!-- https://mvnrepository.com/artifact/org.springframework/spring-tx -->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-tx</artifactId>
<version>5.2.9.RELEASE</version>
</dependency>
<!-- https://mvnrepository.com/artifact/org.springframework/spring-jdbc -->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-jdbc</artifactId>
<version>5.2.9.RELEASE</version>
</dependency>
<!--SpringMVC依赖-->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-webmvc</artifactId>
<version>5.2.8.RELEASE</version>
</dependency>
<!--jackson依赖-->
<dependency>
<groupId>com.fasterxml.jackson.core</groupId>
<artifactId>jackson-databind</artifactId>
<version>2.11.0</version>
</dependency>
<dependency>
<groupId>com.fasterxml.jackson.core</groupId>
<artifactId>jackson-core</artifactId>
<version>2.9.8</version>
</dependency>
</dependencies>
配置文件:
- springmvc.xml文件(SpringMVC核心配置文件):
<!--SpringMVC配置文件-->
<!--声明组件扫描器-->
<context:component-scan base-package="com.bjpowernode.controller"/>
<!--声明视图解析器-->
<bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
<property name="prefix" value="/WEB-INF/views/"/>
<property name="suffix" value=".jsp"/>
</bean>
<!--声明注解驱动-->
<mvc:annotation-driven/>
- applicationContext.xml(Spring核心配置文件):
<!--Spring配置文件-->
<!--指定属性配置文件的位置-->
<context:property-placeholder location="classpath:jdbc.properties"/>
<!--声明数据源-->
<bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource">
<property name="url" value="${mysql.url}"/>
<property name="username" value="${mysql.username}"/>
<property name="password" value="${mysql.password}"/>
</bean>
<!--声明SqlSessionFactoryBean-->
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<property name="dataSource" ref="dataSource"/>
<property name="configLocation" value="classpath:mybatis-config.xml"/>
</bean>
<!--声明Mybatis的扫描器,创建Dao对象-->
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/>
<property name="basePackage" value="com.bjpowernode.dao"/>
</bean>
<!--声明组件扫描器,指定Service注解包名-->
<context:component-scan base-package="com.bjpowernode.service"/>
- mybatis-config.xml(MyBatis核心配置文件):
<configuration>
<typeAliases>
<package name="com.bjpowernode.entity"/>
</typeAliases>
<mappers>
<mapper resource="Mappers/StudentDaoMappers.xml"/>
</mappers>
</configuration>
- StudentDaoMappers.xml:
<mapper namespace="com.bjpowernode.dao.StudentDao">
<select id="selectStudents" resultType="Student">
select * from student
</select>
<insert id="insertStudent" parameterType="Student">
insert into student(id,name,age) values (#{id},#{name},#{age})
</insert>
</mapper>
- web.xml:
<!--注册SpringMVC的DispatcherServlet-->
<servlet>
<servlet-name>dispatcherServlet</servlet-name>
<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
<init-param>
<param-name>contextConfigLocation</param-name>
<!--指定Spring的配置文件-->
<param-value>classpath:springmvc.xml</param-value>
</init-param>
<load-on-startup>1</load-on-startup>
</servlet>
<servlet-mapping>
<servlet-name>dispatcherServlet</servlet-name>
<url-pattern>*.do</url-pattern>
</servlet-mapping>
<!--注册Spring的ContextLoaderListener-->
<context-param>
<param-name>contextConfigLocation</param-name>
<!--指定Spring的配置文件-->
<param-value>classpath:applicationContext.xml</param-value>
</context-param>
<listener>
<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
</listener>
<!--注册CharacterEncodingFilter-->
<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>
<init-param>
<param-name>forceRequestEncoding</param-name>
<param-value>true</param-value>
</init-param>
<init-param>
<param-name>forceResponseEncoding</param-name>
<param-value>true</param-value>
</init-param>
</filter>
<filter-mapping>
<filter-name>characterEncodingFilter</filter-name>
<url-pattern>/*</url-pattern>
</filter-mapping>
前端:
- addStudent.jsp文件:
<div align="center">
<form action="student/addStudent.do" method="post">
<table>
<tr>
<td>id:</td>
<td><input type="text" name="id"/> </td>
</tr>
<tr>
<td>姓名:</td>
<td><input type="text" name="name"/> </td>
</tr>
<tr>
<td>年龄:</td>
<td><input type="text" name="age"/> </td>
</tr>
<tr>
<td></td>
<td><input type="submit" value="save"/> </td>
</tr>
</table>
</form>
</div>
- selectStudent.jsp文件:
<html>
<head>
<title>Title</title>
<script type="text/javascript" src="js/jquery-1.6.4.min.js"></script>
<script type="text/javascript">
$(function () {
$.ajax({
url:"student/queryAll.do",
type:"post",
success:function(response){
alert(response.id+" "+response.name+" "+response.age)
console.log(response)
$("#stubody").html("");
$("#stubody").append("<tr>")
.append("<td>"+response.id+"</td>")
.append("<td>"+response.name+"</td>")
.append("<td>"+response.age+"</td>")
.append("</tr>")
}
})
})
</script>
</head>
<body>
<div align="center">
<table>
<thead>
<tr>
<td>id</td>
<td>name</td>
<td>age</td>
</tr>
</thead>
<tbody id="stubody">
</tbody>
</table>
</div>
</body>
</html>
后端Controller层:
@Controller
@RequestMapping("/student")
public class StudentController {
/**引用类型自动注入@Autowired ,@Resource
* */
@Autowired
private StudentService studentService;
@RequestMapping("/addStudent.do")
public ModelAndView AddStudent(Student student){
int nums= studentService.addStudent(student);
String msg="学生["+student.getName()+"]注册成功!";
if(nums>0){
msg="学生["+student.getName()+"]注册成功!";
}
ModelAndView mv=new ModelAndView();
mv.addObject("msg",msg);
mv.setViewName("result");
return mv;
}
@RequestMapping("/queryAll.do")
@ResponseBody
public Student queryStudent(){
return studentService.findAll().get(0);
}
}