ssm框架（SpringSpringmvcMybatis框架）整合及案例增删改查
三⼤框架介绍
ssm框架是由Spring springmvc和Mybatis共同组成的框架。Spring和Springmvc都是spring公司开发的，因此他们之间不需要整合。也可以说是⽆缝整合。mybatis公司开发的mybatis，因为需要和Spring整合，但是他们之间是有缝的。因此mybatis公司就做出了jar包 mybatis-spring的核⼼整合包。
Q：什么叫⽆缝整合，有缝整合？
A：最⽅便的理解就是有Jar包就是有缝，没有jar包就是⽆缝。
整合准备条件
三个⽂件：l （名字⼀般都这样起，因为我们还需要对他们进⾏配置，需要⽤⽂件名，同时也能让其他⼈明⽩）
下图是项⽬的架构图
⾥⾯包含数据源的读取properties，配置dataSource，事务管理对象transactionManager、
sqlsession⼯⼚SqlSessionFactory 以及Mapper扫描（xml名和接⼝名相同）。主要负责与mybatis整合
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="/schema/beans"
xmlns:context="/schema/context" xmlns:p="/schema/p"
xmlns:aop="/schema/aop" xmlns:tx="/schema/tx"
xmlns:xsi="/2001/XMLSchema-instance"
xsi:schemaLocation="/schema/beans /schema/beans/spring-beans-4.0.xsd
/schema/context /schema/context/spring-context-4.0.xsd
/schema/aop /schema/aop/spring-aop-4.0.xsd /schema/tx /schema/tx/spring-tx-4.0.xsd /schema/util /schema/util/spring-util-4.0.xsd">
<!-- 配置读取properties⽂件 jdbc.properties -->
<context:property-placeholder location="classpath:jdbc.properties" />
<!-- 配置数据源 -->
<bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource">
<property name="driverClassName" value="${jdbc.driver}" />
<property name="url" value="${jdbc.url}" />
<property name="username" value="${jdbc.username}" />
<property name="password" value="${jdbc.password}" />
</bean>
<bean name="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource" ref="dataSource"></property>
</bean>
<tx:annotation-driven transaction-manager="transactionManager"/>
<!-- 配置SqlSessionFactory -->
<bean class="batis.spring.SqlSessionFactoryBean">
<!-- 设置MyBatis核⼼配置⽂件 -->
<property name="configLocation" value="l" />
<!-- 设置数据源 -->
<property name="dataSource" ref="dataSource" />
</bean>
<!-- 配置Mapper扫描 -->
<bean class="batis.spring.mapper.MapperScannerConfigurer">
<!-- 设置Mapper扫描包 -->
<property name="basePackage" value="cn.tsu.ssm.dao" />
</bean>
</beans>
主要负责注解，springmvc的三⼤组件（处理器映射器、处理器适配器、视图解析器，这三个有默认的类，但是已经过时了。）
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="/schema/beans"
xmlns:xsi="/2001/XMLSchema-instance" xmlns:p="/schema/p"
xmlns:context="/schema/context"
xmlns:mvc="/schema/mvc"
xsi:schemaLocation="/schema/beans /schema/beans/spring-beans-4.0.xsd
/schema/mvc /schema/mvc/spring-mvc-4.0.xsd
/schema/context /schema/context/spring-context-4.0.xsd">
<!-- 配置Controller扫描 -->
<context:component-scan base-package="cn.tsu.ssm" />
<!-- 配置注解驱动 ,⾃动对处理器映射器和处理器适配器寻最新的类-->
<mvc:annotation-driven />
<!--对静态资源放⾏ -->
<mvc:default-servlet-handler/>
<!-- 配置视图解析器 -->
<bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
<!-- 前缀 -->
<property name="prefix" value="/WEB-INF/jsp/" />
</beans>
mybatis可以只配⼀个别名，⼤⼩写不敏感，可以不配置，但是不配置的话必须使⽤包名+类名。
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration PUBLIC "-////DTD Config 3.0//EN"
"/dtd/mybatis-3-config.dtd">
<configuration>
<typeAliases>
<package name="cn.tsu.ssm.pojo"/>
</typeAliases>
</configuration>
ssm配置完了，但是tomcat启动后并不会对Spring的框架进⾏读取，因此我们还需要配置⼀个。
<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns:xsi="/2001/XMLSchema-instance" xmlns="java.sun/xml/ns/javaee" xsi:schemaLocation="java.sun/xml/ns/javaee java.sun/xml/ns/javaee/web-app_2_5.xsd" id="WebApp_ID" ve <display-name>ssmDemo</display-name>
<welcome-file-list>
<welcome-file>index.jsp</welcome-file>
</welcome-file-list>
<!-- 配置spring -->
<context-param>
<param-name>contextConfigLocation</param-name>
<param-value>l</param-value>
</context-param>
<!-- 配置加载spring -->
<listener>
<listener-class>org.t.ContextLoaderListener</listener-class>
</listener>
<!-- 配置过滤器，解决post的乱码问题 -->
<filter>
<filter-name>encoding</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>encoding</filter-name>
<url-pattern>/*</url-pattern>
</filter-mapping>
<!-- 配置SpringMVC -->
<servlet>
<servlet-name>ssm-crm</servlet-name>
<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
<init-param>
<param-name>contextConfigLocation</param-name>
<param-value>l</param-value>
</init-param>
<!-- 配置springmvc什么时候启动，参数必须为整数 -->
<!-- 如果为0或者⼤于0，则springMVC随着容器启动⽽启动 -->
<!-- 如果⼩于0，则在第⼀次请求进来的时候启动 -->
<load-on-startup>1</load-on-startup>
</servlet>
<servlet-mapping>
<servlet-name>ssm-crm</servlet-name>
<!-- 所有的请求都进⼊springMVC -->
<url-pattern>/</url-pattern>
</servlet-mapping>
</web-app>
在这⾥ssm的三⼤框架基本上就整合完毕了。
下⾯这个案例是⼀个客户的增删改查的分页⼩Demo
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
PUBLIC "-////DTD Mapper 3.0//EN"
"/dtd/mybatis-3-mapper.dtd">
<mapper namespace="cn.tsu.ssm.dao.CustomerMapper">
<!-- 根据类别代码查询数据 -->
<select id="findBaseDictByCode" parameterType="String"
resultType="BaseDict">
SELECT * FROM base_dict WHERE dict_type_code =
#{dict_type_code}
</select>
<select id="findCustomerByPage" parameterType="queryvo" resultType="customer">
SELECT
a.cust_id,
a.cust_name,
a.cust_user_id,
a.cust_create_id,
b.dict_item_name cust_source,
c.dict_item_name cust_industry,
d.dict_item_name cust_level,
a.cust_linkman,
a.cust_phone,
a.cust_mobile,
a.cust_zipcode,
a.cust_address,
a.cust_createtime
FROM
customer a
LEFT JOIN base_dict b ON a.cust_source = b.dict_id
LEFT JOIN base_dict c ON a.cust_industry = c.dict_id
LEFT JOIN base_dict d ON a.cust_level = d.dict_id
<include refid="ifyuju"/>
<if test="start !=null">
limit #{start},#{rows}
</if>
</select>
<select id="findCustomerCount" parameterType="queryvo" resultType="Integer">
select count(*) from customer a
<include refid="ifyuju"/>
</select>
<!--
private Long cust_id;
private String cust_name;
private String cust_source;
private String cust_linkman;
private String cust_phone;
private String cust_mobile;
private String cust_zipcode;
private String cust_address;
private Date cust_createtime;
-->
<update id="editCustomer" parameterType="customer">
update customer set cust_name = #{cust_name} ,
cust_source = #{cust_source} ,
cust_industry = #{cust_industry} ,
cust_level = #{cust_level} ,
cust_linkman = #{cust_linkman} ,
cust_phone = #{cust_phone} ,
cust_mobile = #{cust_mobile} ,
cust_zipcode = #{cust_zipcode} ,
springmvc选择题cust_address = #{cust_address} ,
cust_createtime = #{cust_createtime}
<where>
cust_id = #{cust_id}
</where>
</update>
<select id="edit" parameterType="Integer" resultType="customer">
select * from customer
<where>
cust_id = #{cust_id}
</where>
</select>
<delete id="deleteByid" parameterType="Integer">
delete from customer
<where>
cust_id = #{cust_id}
</where>
</delete>
<sql id="ifyuju">
<where>
<if test="custName != null and custName != ''">
AND a.cust_name LIKE '%${custName}%'
</if>
<if test="custSource != null and custSource != ''">
AND a.cust_source = #{custSource}
</if>
<if test="custIndustry != null and custIndustry != ''">
AND a.cust_industry = #{custIndustry}
</if>
<if test="custLevel != null and custLevel != ''">
AND a.cust_level = #{custLevel}
</if>
</where>
</sql>
</mapper>
CustomerMapper.java（接⼝⽂件）（写sql⽂件的，必须和l⽂件在⼀个包下，并且名字相同，两个⽂件遵循4⼤原则{名字相同，xml的mapper namespace 属性指向接⼝，⼊参类型相同，出参类型相同}）
package cn.tsu.ssm.dao;
import java.util.List;
import cn.tsumon.utils.Page;
import cn.tsu.ssm.pojo.Customer;
import cn.tsu.ssm.pojo.Queryvo;
public interface CustomerMapper {
public List<Customer> findBaseDictByCode(String code);
public List<Customer> findCustomerByPage(Queryvo vo);
public Integer findCustomerCount(Queryvo vo);
public void editCustomer(Customer customer);
public Customer edit(Integer id );
public void deleteByid (Integer id);
}
service层接⼝略
…
…
…
service实现类
service层主要写了分页的业务
package cn.tsu.ssm.service;
import java.util.List;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import ansaction.annotation.Isolation;
import ansaction.annotation.Propagation;
import ansaction.annotation.Transactional;
import cn.tsumon.utils.Page;
import cn.tsu.ssm.dao.CustomerMapper;
import cn.tsu.ssm.pojo.Customer;
import cn.tsu.ssm.pojo.Queryvo;
@Service
@Transactional(readOnly=false,isolation=Isolation.READ_COMMITTED,propagation=Propagation.REQUIRED)
public class CustomerServiceImpl implements CustomerService{
@Autowired
private CustomerMapper cm;
public List<Customer> findCustomer(String code) {
return cm.findBaseDictByCode(code);
}
public Page<Customer> findCustomerByPage(Queryvo vo) {
// TODO Auto-generated method stub
vo.setStart((vo.getPage()-1)*vo.getRows());
List<Customer> findCustomerByPage = cm.findCustomerByPage(vo);
Integer total = cm.findCustomerCount(vo);
Page<Customer> page = new Page<Customer>(total,Page(),vo.getRows());
}
public void editCustomer(Customer customer) {
cm.editCustomer(customer);
}
public Customer edit(Integer id) {
// TODO Auto-generated method stub
return cm.edit(id);
}
public void deleteByid(Integer id) {
cm.deleteByid(id);
}
}
DemoController层
主要写了web层，接收前端传递过来的数据，post，get，json等
package cn.ller;
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 org.springframework.web.bind.annotation.ResponseBody;
import cn.tsumon.utils.Page;
import cn.tsu.ssm.pojo.Customer;
import cn.tsu.ssm.pojo.Queryvo;
import cn.tsu.ssm.service.CustomerService;
@Controller
public class DemoController {
@Autowired
private CustomerService cs;
@RequestMapping("listUi")
public String listUi(Model model,Queryvo vo) {
List<Customer> fromType = cs.findCustomer("002");
List<Customer> industryType = cs.findCustomer("001");
List<Customer> levelType = cs.findCustomer("006");
model.addAttribute("fromType", fromType);
model.addAttribute("industryType", industryType);
model.addAttribute("levelType", levelType);
//分页查询
Page<Customer> page = cs.findCustomerByPage(vo);
model.addAttribute("page", page);
model.addAttribute("custName", vo.getCustName());
model.addAttribute("custSource", vo.getCustSource());
model.addAttribute("custIndustry", vo.getCustIndustry());
model.addAttribute("custLevel", vo.getCustLevel());
return "customer";
}
@RequestMapping("edit")
public @ResponseBody
Customer edit(Model model, Integer id) {
Customer customer = cs.edit(id);
return customer;
}
@RequestMapping("update")
public @ResponseBody
String update(Customer customer) {
cs.editCustomer(customer);
return "ok";//这⾥回复null前端也有响应
}
@RequestMapping(value="delete")
public @ResponseBody
String delete (Integer id) {
System.out.println(id);
cs.deleteByid(id);
return null;
}
}
下⾯把⼯具类的代码也写出来
page.java
package cn.tsumon.utils;
import java.util.List;
import cn.tsu.ssm.pojo.Customer;
public class Page<T> {
//⼀共有多少数据
private int total;
//当前页
private int page;
//当页显⽰多少数据
private int size;
//数据
private List<Customer> rows;
public Page(Integer total2, List<Customer> findCustomerByPage, Integer page2, Integer rows2) { al=total2;
this.page = page2;
this.size=rows2;
}
public int getTotal() {
return total;
}
public void setTotal(int total) {
}
public int getPage() {
public void setPage(int page) {
this.page = page;
}
public int getSize() {
return size;
}
public void setSize(int size) {
this.size = size;
}
public List<Customer> getRows() {
return rows;
}
public void setRows(List<Customer> rows) {
}
}
NavigationTag.java
package cn.tsumon.utils;
import java.io.IOException;
import java.util.Map;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.jsp.JspException;
import javax.servlet.jsp.JspWriter;
import javax.servlet.jsp.tagext.TagSupport;
/**
* 显⽰格式上⼀页 1 2 3 4 5 下⼀页
*/
public class NavigationTag extends TagSupport {
static final long serialVersionUID = 2372405317744358833L;
/**
* request 中⽤于保存Page<E> 对象的变量名，默认为“page”
*/
private String bean = "page";
/**
* 分页跳转的url地址，此属性必须
*/
private String url = null;
/**
* 显⽰页码数量
*/
private int number = 5;
@Override
public int doStartTag() throws JspException {
JspWriter writer = Out();
HttpServletRequest request = (HttpServletRequest) Request();
Page page = (Attribute(bean);
if (page == null)
return SKIP_BODY;
url = resolveUrl(url, pageContext);
try {
//计算总页数
int pageCount = Total() / Size();
if (Total() % Size() > 0) {
pageCount++;
}
writer.print("<nav><ul class=\"pagination\">");
//显⽰“上⼀页”按钮
if (Page() > 1) {
String preUrl = append(url, "page", Page() - 1);
preUrl = append(preUrl, "rows", Size());
writer.print("<li><a href=\"" + preUrl + "\">上⼀页</a></li>");
} else {
writer.print("<li class=\"disabled\"><a href=\"#\">上⼀页</a></li>");
}
//显⽰当前页码的前2页码和后两页码
//若1 则 1 2 3 4 5, 若2 则 1 2 3 4 5, 若3 则1 2 3 4 5,
//若4 则 2 3 4 5 6 ，若10 则 8 9 10 11 12
int indexPage = (Page() - 2 > 0)? Page() - 2 : 1;
for(int i=1; i <= number && indexPage <= pageCount; indexPage++, i++) {
if(indexPage == Page()) {
writer.print( "<li class=\"active\"><a href=\"#\">"+indexPage+"<span class=\"sr-only\">(current)</span></a></li>"); continue;
}
String pageUrl = append(url, "page", indexPage);
pageUrl = append(pageUrl, "rows", Size());
writer.print("<li><a href=\"" + pageUrl + "\">"+ indexPage +"</a></li>");
}
//显⽰“下⼀页”按钮
if (Page() < pageCount) {
String nextUrl = append(url, "page", Page() + 1);
nextUrl = append(nextUrl, "rows", Size());
writer.print("<li><a href=\"" + nextUrl + "\">下⼀页</a></li>");
} else {
writer.print("<li class=\"disabled\"><a href=\"#\">下⼀页</a></li>");
}
writer.print("</nav>");
} catch (IOException e) {
e.printStackTrace();
}
return SKIP_BODY;
}
private String append(String url, String key, int value) {
return append(url, key, String.valueOf(value));
}
/**
* 为url 参加参数对⼉
*
* @param url
* @param key
* @param value
* @return
*/
private String append(String url, String key, String value) {
if (url == null || im().length() == 0) {
版权声明：本站内容均来自互联网，仅供演示用，请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系QQ:729038198，我们将在24小时内删除。
发表评论