Spring+SpringMVC+Mybatis
Spring负责bean配置和事务,aop等
SpringMVC负责web层逻辑及JSP页面
Mybatis负责持久层逻辑，与数据库进行交互
Mybatis层：
高度集成，降低耦合，Mybatis配置文件存在的必要性越来越小，在Mybatis配置中配置些次重要的配置(别名等等)证明Mybatis确实存在
<typeAliases> <typeAlias type="com.bj.pojo.User" alias="user"/> typeAliases>pojo实体类,尽量与数据库中数据字段一致
@Data@AllArgsConstructor@NoArgsConstructorpublic class User { private String name; private String pass; private int age;}编写dao层接口
public interface UserMapper { //查询全部User ListqueryAll(); //查询某一User User queryOne(String name); //增加一个User int addOne(User user); //删除一个User int delOne(String name); //修改一个User int updateOne(User user);}编写dao层接口的配置文件CRUD
namespace= <select id="queryAll" resultType="user"> select * from ssmbuild; select> <select id="queryOne" resultType="user"> select * from ssmbuild where name=#{name} select> "addOne" parameterType= insert into ssmbuild(name,pass,age) values(#{name},#{pass},#{age}) ="delOne" parameterType="String"> delete from ssmbuild where name=#{name} "updateOne" parameterType= update ssmbuild set pass=#{pass},age=#{age} where name=#{name} 编写service层接口，和dao层接口一致，service接受请求后调用dao层
编写service层接口的实现类
package com.bj.service;import com.bj.dao.UserMapper;import com.bj.pojo.User;import org.mybatis.spring.SqlSessionTemplate;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.beans.factory.annotation.Qualifier;import org.springframework.stereotype.Component;import org.springframework.stereotype.Service;import org.springframework.transaction.annotation.Transactional;import java.util.List;//@Transactional@Servicepublic class UserServiceImpl implements UserService{ @Autowired private UserMapper userMapper; public ListqueryAll() { return userMapper.queryAll(); } public User queryOne(String name) { return userMapper.queryOne(name); } public int addOne(User user) { return userMapper.addOne(user); } public int delOne(String name) { return userMapper.delOne(name); } public int updateOne(User user) { return userMapper.updateOne(user); }}Spring配置文件
<context:component-scan base-package="com.bj"/> <context:property-placeholder location="jdbc.properties"/> <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource"> <property name="url" value="${url}" /> <property name="username" value="${username}" /> <property name="password" value="${password}" /> <property name="driverClassName" value="${driver}" /> bean> <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean"> <property name="dataSource" ref="dataSource" /> <property name="configLocation" value="classpath:mybatis-config.xml"/> <property name="mapperLocations" value="classpath:com/bj/dao/UserMapper.xml"/> bean> <bean id="sqlSession" class="org.mybatis.spring.SqlSessionTemplate"> <constructor-arg index="0" ref="sqlSessionFactory"/> bean>配置Spring配置中应用的jdbc.properties属性文件
driver=com.mysql.jdbc.Driverurl=jdbc:mysql://localhost:3306/happusername=rootpassword=1452配置applicationContext配置，用来集成Spring和Mybatis
<?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:tx="http://www.springframework.org/schema/tx" 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.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx.xsd"> <import resource="classpath:spring-Dao.xml"/>beans>此时可以编写测试类来测试程序是否能跑起来，在此之前先实现dao层接口实现类
package com.bj.service;import com.bj.dao.UserMapper;import com.bj.pojo.User;import org.mybatis.spring.SqlSessionTemplate;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.beans.factory.annotation.Qualifier;import org.springframework.stereotype.Component;import java.util.List;@Componentpublic class UserMapperImpl implements UserMapper{ @Autowired @Qualifier(value = "sqlSession") private SqlSessionTemplate sqlSession; public ListqueryAll() { UserMapper mapper = sqlSession.getMapper(UserMapper.class); List list = mapper.queryAll(); return list; }}篇幅原因就只写一个查询全部用户信息的方法
@Test public void queryAll(){ ApplicationContext context=new ClassPathXmlApplicationContext("spring-Dao.xml"); UserMapper userMapperImpl = context.getBean("userMapperImpl", UserMapper.class); Listlist = userMapperImpl.queryAll(); for (User user : list) { System.out.println(user); } }测试类加@Test注解
执行结果：
注意,jdbc.properties的编码格式若是gbk，要改为utf-8，否则乱码导致数据库连接失败
SpringMVC层：
在web.xml中配置dispatcherservlet中央处理器及过滤器filter，filter在servlet执行前执行，将字符转为utf-8格式，防止乱码
<servlet> <servlet-name>springmvcservlet-name> <servlet-class>org.springframework.web.servlet.DispatcherServletservlet-class> <init-param> <param-name>contextConfigLocationparam-name> <param-value>classpath:applicationContext.xmlparam-value> init-param> <load-on-startup>1load-on-startup> servlet> <servlet-mapping> <servlet-name>springmvcservlet-name> <url-pattern>/url-pattern> servlet-mapping> <filter> <filter-name>encodingfilter-name> <filter-class>org.springframework.web.filter.CharacterEncodingFilterfilter-class> <init-param> <param-name>encodingparam-name> <param-value>utf-8param-value> init-param> filter> <filter-mapping> <filter-name>encodingfilter-name> <url-pattern>/*url-pattern> filter-mapping>SpringMVC配置，开启包扫描，注解驱动和视图解析器,并配置前缀后缀
<context:component-scan base-package="com.bj.controller"/> <mvc:annotation-driven/> <mvc:default-servlet-handler/> <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver" id="InternalResourceViewResolver"> <property name="prefix" value="/WEB-INF/JSP/"/> <property name="suffix" value=".jsp"/> bean>此时WEB-INF下应有对应的文件夹
配置服务层配置，开启包扫描
<context:component-scan base-package="com.bj.service"/>保证spring-Dao.xml,service-config.xml,springmvc-servlet.xml在同一目录下
在applicationContext.xml中加入
<import resource="classpath:spring-Dao.xml"/> <import resource="classpath:service-config.xml"/> <import resource="classpath:springmvc-servlet.xml"/>接下来编写controller程序
package com.bj.controller;import com.bj.pojo.User;import com.bj.service.UserService;import com.sun.org.apache.xpath.internal.operations.Mod;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 java.util.List;@Controllerpublic class UserController { @Autowired private UserService userService; @RequestMapping("/queryAll") public String queryAll(Model model){ List list = userService.queryAll(); model.addAttribute("list", list); return "queryAll"; } @RequestMapping("/queryOne") public String queryOne(Model model,String name){ User user = userService.queryOne(name); model.addAttribute("user",user); return "queryOne"; } @RequestMapping("/addOne") public String addOne(User user){ int i = userService.addOne(user); if(i>0){ return "success"; } else{ return "fail"; } } @RequestMapping("/delOne") public String delOne(String name){ int i = userService.delOne(name); if(i>0){ return "success"; } else{ return "fail"; } }}编写jsp文件，这里只展示增加用户和查询用户
主页：
<a href="/queryAll">查询全部用户a> <br> <a href="/query.jsp">查询某用户a> <br> <a href="/add.jsp">增加用户a> <br> <a href="/del.jsp">删除用户a>增加页：
<%@ page contentType="text/html;charset=UTF-8" language="java" %><html><head> <title>Titletitle> <link href="https://cdn.staticfile.org/twitter-bootstrap/3.3.7/css/bootstrap.min.css" rel="stylesheet">head><body><div class="container"> <div class="row clearfix"> <div class="col-md-12 colum"> <div class="page-header"> <h1> 添加用户 h1> div> div> div> <div class="row clearfix"> <div class="row clearfix"> <table class="table table-hover table-striped"> <tbody> <form action="/addOne"> 输入用户名 <input type="text" name="name"/> <br> 输入密码 <input type="text" name="pass"/> <br> 输入年龄 <input type="text" name="age"/> <br> <input type="submit" value="添加"/> form> tbody> table> div> div>div>body>html>使用了bookstrap美化页面
查询页面(原生)：
<%@ page contentType="text/html;charset=UTF-8" language="java" %><html><head> <title>Titletitle>head><body><form action="/queryOne"> <input type="text" name="name"/> <input type="submit"/>form>body>html>查询结果页面(bookstrap):
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %><%@ page contentType="text/html;charset=UTF-8" language="java" %><html><head> <title>Titletitle> <link href="https://cdn.staticfile.org/twitter-bootstrap/3.3.7/css/bootstrap.min.css" rel="stylesheet">head><body><div class="container"> <div class="row clearfix"> <div class="col-md-12 colum"> <div class="page-header"> <h1> 用户列表 h1> div> div> div> <div class="row clearfix"> <div class="row clearfix"> <table class="table table-hover table-striped"> <thead> <tr> <th>Nameth> <th>Passth> <th>Ageth> tr> thead> <tbody> <tr> <td>${user.name}td> <td>${user.pass}td> <td>${user.age}td> tr> tbody> table> div> div>div>body>html>成功页面：
<%@ page contentType="text/html;charset=UTF-8" language="java" %><html><head> <title>Titletitle>head><body>成功！！！！！body>html>失败页面：
<%@ page contentType="text/html;charset=UTF-8" language="java" %><html><head> <title>Titletitle>head><body>失败!!!!!!!body>html>配置Tomcat
启动服务器
原始数据库
主页
查询页
查询结果
增加用户页
