SSM框架(九)Spring整合mybatis

目录

1. pom.xml文件介绍

2. Spring整合Mybatis

2.1 在pom.xml中添加依赖

2.2 在web.xml中配置前端控制器等

2.3 添加Spring整合mybatis的配置文件spring-mybatis.xml

2.4 编写jdbc.properties

2.5 编写实体类

2.6 编写dao层

2.7 编写StudentMapper.xml

2.8 编写service层

2.9 编写controller层

2.10 编写一个index.jsp显示数据

---

1. pom.xml文件介绍

在上一节中，我们已经创建好了一个maven工程，还没有添加任何东西，这一节我们就直接使用上一节创建的那个maven项目就好了。创建好一个maven项目后，你会发现多了一个pox.xml文件，这个文件描述了maven项目的基本信息，一个最简单的pom.xml文件至少需要包含四个元素：modelVersion, groupId, artiffactId 和 version。在maven工程中，jar包就不需要我们手动导入了，只需要在pom.xml这个文件中添加相关依赖就可以了。

    project：所有元素的根元素，该元素声明的信息主要为了方便第三方插件使用。

    modelVersion：用于指定当前POM模型的版本，对于maven2,maven3只能是4.0.0。

    groupId：用于指定当前项目所属的团体，公司，小组，组织 或 其它团体，比如cn.goktech.xxx。

    artiffactId：当前项目所属组的唯一的ID号，

    version：用于指定当前项目的版本编号。比如：0.0.1-SNAPSHOT。后面的SNAPSHOT常指正在开发中的项目

2. Spring整合Mybatis

先创建一个数据库javaweb_day9，创建一张表student

create database javaweb_day9;
DROP TABLE IF EXISTS `student`;
CREATE TABLE `student` (
  `sid` int(11) NOT NULL AUTO_INCREMENT,
  `sname` varchar(255) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  `score` double DEFAULT NULL,
  PRIMARY KEY (`sid`)
) ENGINE=InnoDB AUTO_INCREMENT=1007 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of student
-- ----------------------------
INSERT INTO `student` VALUES ('1001', 'Alice', '123258', '98');
INSERT INTO `student` VALUES ('1002', 'Bob', '852132', '89');
INSERT INTO `student` VALUES ('1003', 'Clover', '5565656', '87');
INSERT INTO `student` VALUES ('1004', 'Glover', '56854656', '60');
INSERT INTO `student` VALUES ('1005', 'God', '1235', '70');
INSERT INTO `student` VALUES ('1006', 'UFO', '123456', '99');

2.1 在pom.xml中添加依赖

Spring整合mybatis的时候既要使用Spring又要使用mybatis，所以需要Spring和mybatis的jar。在pom.xml中添加这些jar的依赖

<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.chtw</groupId>
  <artifactId>MavenTest</artifactId>
  <version>0.0.1-SNAPSHOT</version>
  <packaging>war</packaging>
  <!-- 引用jar包 -->
	<dependencies>
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-core</artifactId>
			<version>5.1.3.RELEASE</version>
		</dependency>
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-beans</artifactId>
			<version>5.1.3.RELEASE</version>
		</dependency>
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-context</artifactId>
			<version>5.1.3.RELEASE</version>
		</dependency>
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-context-support</artifactId>
			<version>5.1.3.RELEASE</version>
		</dependency>
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-tx</artifactId>
			<version>5.1.3.RELEASE</version>
		</dependency>
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-orm</artifactId>
			<version>5.1.3.RELEASE</version>
		</dependency>
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-aop</artifactId>
			<version>5.1.3.RELEASE</version>
		</dependency>
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-web</artifactId>
			<version>5.1.3.RELEASE</version>
		</dependency>
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-webmvc</artifactId>
			<version>5.1.3.RELEASE</version>
		</dependency>
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-jdbc</artifactId>
			<version>5.1.3.RELEASE</version>
		</dependency>

		<dependency>
			<groupId>mysql</groupId>
			<artifactId>mysql-connector-java</artifactId>
			<version>5.1.47</version>
		</dependency>

		<dependency>
			<groupId>org.mybatis</groupId>
			<artifactId>mybatis</artifactId>
			<version>3.4.0</version>
		</dependency>
		<dependency>
			<groupId>org.mybatis</groupId>
			<artifactId>mybatis-spring</artifactId>
			<version>1.3.1</version>
		</dependency>
		<dependency>
			<groupId>commons-io</groupId>
			<artifactId>commons-io</artifactId>
			<version>2.2</version>
		</dependency>
		<dependency>
			<groupId>commons-fileupload</groupId>
			<artifactId>commons-fileupload</artifactId>
			<version>1.3.2</version>
		</dependency>
		<dependency>
			<groupId>org.apache.commons</groupId>
			<artifactId>commons-dbcp2</artifactId>
			<version>2.6.0</version>
		</dependency>
		<dependency>
			<groupId>com.mchange</groupId>
			<artifactId>c3p0</artifactId>
			<version>0.9.5.2</version>
		</dependency>
		<dependency>
			<groupId>javax.servlet</groupId>
			<artifactId>jstl</artifactId>
			<version>1.1.2</version>
		</dependency>
		<dependency>
			<groupId>taglibs</groupId>
			<artifactId>standard</artifactId>
			<version>1.1.0</version>
		</dependency>
	</dependencies>
</project>

2.2 在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_2_5.xsd" version="2.5">
  <display-name>MavenTest</display-name>
  <welcome-file-list>
    <welcome-file>index.do</welcome-file>
  </welcome-file-list>
 
  <!-- 配置前端控制器 -->
	<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:spring-mybatis.xml</param-value>
		</init-param>
		<load-on-startup>1</load-on-startup><!-- 当启动的时候加载 -->
	</servlet>

	<servlet-mapping>
		<servlet-name>springmvc</servlet-name>
		<url-pattern>*.do</url-pattern>
	</servlet-mapping>

	<!-- 在web.xml配置编码处理的过滤器 ,解决中文乱码问题 -->
	<filter>
		<filter-name>encodingFilter</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>encodingFilter</filter-name>
		<url-pattern>/*</url-pattern>
	</filter-mapping>

	<session-config>
		<session-timeout>30</session-timeout>
	</session-config>
</web-app>

2.3 添加Spring整合mybatis的配置文件spring-mybatis.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:util="http://www.springframework.org/schema/util"
	xmlns:mvc="http://www.springframework.org/schema/mvc"
	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
		http://www.springframework.org/schema/util
		http://www.springframework.org/schema/util/spring-util-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="com.chtw.*"/>
	<!-- 用于扫描RequestMapping -->
	<mvc:annotation-driven />

	<!-- 视图解析器 -->
	<bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
		<property name="prefix" value="/" />
		<property name="suffix" value=".jsp" />
	</bean>

	
	<!-- SSM:Spring+SpringMVC+Mybatis -->
	<!-- dao接口，mapper.xml映射
		 sqlSessionFactoryBean
	-->
	<!-- 加载数据库连接配置文件 -->
	<util:properties id="ds" location="classpath:jdbc.properties"></util:properties>
	
	<!-- 配置数据源 -->
	<bean id="dataSource" class="org.apache.commons.dbcp2.BasicDataSource">
		<property name="driverClassName" value="#{ds.driver}"/>
		<property name="url" value="#{ds.url}"/>
		<property name="username" value="#{ds.username}"/>
		<property name="password" value="#{ds.password}"/>
	</bean>
	
	<!-- 配置sqlSessionFactory -->
	<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
		<property name="dataSource" ref="dataSource"/>
		<!-- 自动扫描所以mapper.xml -->
		<property name="mapperLocations" value="classpath:mapper/*Mapper.xml"/>
		
		<!-- 给包起别名 -->
		<property name="typeAliasesPackage" value="com.chtw.entity"/>
	</bean>
	
	<!-- 扫描DAO接口 -->
	<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
		<property name="basePackage" value="com.chtw.dao"/>
		<property name="sqlSessionFactory" ref="sqlSessionFactory"/>
	</bean>
</beans>

2.4 编写jdbc.properties

driver=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost:3306/javaweb_day9
username=root
password=1728aceAB7

2.5 编写实体类

package com.chtw.entity;

public class Student {

	private int sid;
	private String sname;
	private String password;
	private int score;
	private int cid;

	public int getSid() {
		return sid;
	}

	public void setSid(int sid) {
		this.sid = sid;
	}

	public String getSname() {
		return sname;
	}

	public void setSname(String sname) {
		this.sname = sname;
	}

	public String getPassword() {
		return password;
	}

	public void setPassword(String password) {
		this.password = password;
	}

	public int getScore() {
		return score;
	}

	public void setScore(int score) {
		this.score = score;
	}

	public int getCid() {
		return cid;
	}

	public void setCid(int cid) {
		this.cid = cid;
	}

	
}

2.6 编写dao层

package com.chtw.dao;

import java.util.List;

import com.chtw.entity.Student;

public interface StudentDAO {

	/**
	 * 获取所有信息
	 * 
	 * @return
	 */
	// @Select("select * from student")
	public List<Student> getAll();

	public List<Student> getStudent(Student student);

	public List<Student> search(Student student);

	public List<Student> testWhere(Student student);

	public int updateStudent(Student student);

	/**
	 * 查询获奖同学
	 * @param ids
	 * @return
	 */
	public List<Student> award(List<Integer> ids);
}

2.7 编写StudentMapper.xml

（在resource文件夹下面新建一个mapper文件夹，在mapper文件夹下面新建StudentMapper.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.chtw.dao.StudentDAO"><!-- 对应一个dao -->
	<!-- 增删查改,insert,delete,update,select
		id:指定方法名,
		resultType:返回类型，集合写直属子元素类型,
		parameterType:指定参数类型,多参数可写类类型
	-->
	<select id="getAll" resultType="Student">
		select * from student
	</select>
	
	<select id="getStudent" resultType="Student" parameterType="Student">
		select * from student where sname like '%${sname}%'
			<!-- 当满足if里面的条件，则拼接到sql语句 -->
			<if test="score==0">
				and score>60
			</if>
			<if test="score!=0">
				and score>#{score}
			</if>
	</select>
	
	<select id="search" resultType="Student" parameterType="Student">
		select * from student where sname like '%${sname}%'
			<choose>
				<when test="password!=null">
					and password like '%${password}%'
				</when>
				<when test="score!=0">
					and score>#{score}
				</when>
				<otherwise>
					order by sid desc
				</otherwise>
			</choose>
	</select>
	
	
	
	
	<!-- trim元素，动态拼接元素，消除不需要的前缀以及后缀 -->
	<select id="testWhere" resultType="Student" parameterType="Student">
		select * from student
			<!-- prefix要拼接的前缀， prefixOverrides：trim中拼接的语句块开头若出现指定单词将要去除 -->
			<trim prefix="where" prefixOverrides="and|or">
				<if test="sname!=null">
					sname like CONCAT('%',#{sname},'%')
				</if>
				<if test="password!=null">
					and password like '%${password}%'
				</if>
				<if test="score!=0">
					and score>#{score}
				</if>
			</trim>
	</select>
	
	
	
	<update id="updateStudent" parameterType="Student">
		update student
			<trim suffix="WHERE sid=#{sid}" prefix="set" suffixOverrides=",">
				<if test="sname!=null">
					sname=#{sname},
				</if>
				<if test="score!=0">
					score=#{score},
				</if>
				<if test="password!=null">
					password=#{password}
				</if>
			</trim>
	</update>
	
	
	<!-- forEach元素 -->
	<select id="award" resultType="Student">
		select * from student where sid in
		<!-- collection：list写list，数组写array，map写param.values -->
		<foreach collection="list" item="id" open="(" close=")" separator=",">
			#{id}
		</foreach>
	</select>
</mapper>

2.8 编写service层

package com.chtw.service;

import java.util.List;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import com.chtw.dao.StudentDAO;
import com.chtw.entity.Student;

@Service
public class StuService {

	//自动注入StudentDAO
	@Autowired
	private StudentDAO studentDAO;
	
	/**
	 * 获取所有学生信息
	 * @return
	 */
	public List<Student> getAll(){
		return studentDAO.getAll();
	}
}

2.9 编写controller层

package com.chtw.controller;

import java.util.List;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;

import com.chtw.entity.Student;
import com.chtw.service.StuService;

@Controller
@RequestMapping("/stu")
public class StuController {

	//自动注入StuService
	@Autowired
	private StuService stuService;
	
	@RequestMapping("/index")
	public String getAll(Model model) {
		List<Student> sList = stuService.getAll();
		model.addAttribute("sList",sList);
		return "index";
	}
}

2.10 编写一个index.jsp显示数据

<%@ 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 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>
	<table>
		<caption>学生信息</caption>
		<tr>
			<th>学号</th>
			<th>姓名</th>
			<th>成绩</th>
		</tr>
		<c:forEach items="${sList}" var="list">
			<tr>
				<td>${list.sid}</td>
				<td>${list.sname}</td>
				<td>${list.score}</td>
			</tr>
		</c:forEach>
	</table>
</body>
</html>

启动服务器

本人联系方式2329095893,欢迎各位进行学习讨论

欢迎关注熊熊出没ING公众号，不定时跟新Java、python、信息安全等相关知识哦。