猿蜕变18——一文掌控SSM玩耍方式
看过之前的蜕变系列文章，相信你对SpringMVC 、Spring、 Mybatis的整合有了一定的心得，学会了搭建属于自己的开发框架。今天我们就在这个基础上写一个demo程序，演示下怎么在框架下进行开发。
使用框架编写代码，有利于让代码保持相对稳定的方式进行开发，模式也比较固定，一套框架产出的代码也十分便于后期的维护。
我们搭建的框架中，对代码进行了分层处理。Controller负责和页面进行交互，关注web层后端的逻辑，Service关心功能层面的业务逻辑，为web层的功能点，提供业务层面的功能实现。Dao层，供service调用，为具体的业务服务提供数据支撑。
接下来我们通过一个小demo来感受下怎么使用SpringMVC、Spring、Mybatis框架进行开发。
第一步 编写你的页面
addTravelRoute.jsp
<%@page language="java" contentType="text/html; charset=utf-8"
pageEncoding="utf-8"isELIgnored="false"%>
<html>
<head>
<title>ssm框架测试页面</title>
</head>
<body>
<form action="/addTravelRoute"method=post>
<lable>线路名称：</lable>
<input type="text"name="travelRouteName" id="travelRouteName" /><br/>
<lable>价格：</lable>
<input type="text"name="travelRoutePrice" id="travelRoutePrice" /><br/>
<lable>线路介绍：</lable>
<input type="text"name="travelRouteIntroduce" id="travelRouteIntroduce"/><br />
<lable>线路日期：</lable>
<input type="text"name="travelRouteDate" id="travelRouteDate" /><br/>
<input type="submit"value="提交"id="submit" /><br />
</form>
</body>
</html>
第二步 编写你的web层
package com.pz.web.study.ssm.controller;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import com.pz.web.study.ssm.domain.TravelRoute;
import com.pz.web.study.ssm.service.TravelRouteService;
@Controller
publicclass TravelRouteController {
private TravelRouteService travelRouteService;
@RequestMapping("/addTravelRouteFrom")
public String addTraveFrom() throws Exception {
return"addTravelRoute";
}
@RequestMapping("/addTravelRoute")
public String addTravelRoute(TravelRoutetravelRoute) throws Exception {
travelRoute.setTravelRouteCid(1);
travelRoute.setIsThemeTour("1");
travelRoute.setTravelRouteFlag(1);
travelRoute.setTravelSellerId(1L);
travelRoute.setTravelRouteImage("img/product/small/m3db4d2277b5df3d98597f79082ef92d6d.jpg");
travelRouteService.addTravelRoute(travelRoute);
return"success";
}
publicvoidsetTravelRouteService(TravelRouteServicetravelRouteService) {
this.travelRouteService = travelRouteService;
}
}
第三步 编写你的服务层
package com.pz.web.study.ssm.service;
import com.pz.web.study.ssm.domain.TravelRoute;
public interface TravelRouteService {
public voidaddTravelRoute(TravelRoute travelRoute);
}
package com.pz.web.study.ssm.service.impl;
import com.pz.web.study.ssm.dao.TravelRouteDao;
import com.pz.web.study.ssm.domain.TravelRoute;
import com.pz.web.study.ssm.service.TravelRouteService;
public class TravelRouteServiceImpl implements TravelRouteService {
private TravelRouteDao travelRouteDao;
@Override
publicvoidaddTravelRoute(TravelRoute travelRoute) {
travelRouteDao.add(travelRoute);
}
publicvoidsetTravelRouteDao(TravelRouteDao travelRouteDao) {
this.travelRouteDao =travelRouteDao;
}
}
第四步 编写你的数据层
package com.pz.web.study.ssm.dao;
import java.util.List;
import com.pz.web.study.ssm.domain.TravelRoute;
/**
*
* @author pangzi
*
*/
public interface TravelRouteDao {
/**
* 添加线路
* @param travelRoute
*/
void add(TravelRoute travelRoute);
/**
* 按id删除记录
* @param travelRouteId
*/
void deleteById(Long travelRouteId);
/**
* 更新
* @param travelRoute
*/
void updateById(TravelRoute travelRoute);
/**
* 分页查询TravelRoute列表
* @param startRow
* @param endRow
* @return
*/
List<TravelRoute>queryTravelByPage(Long startRow,Long endRow);
/**
* 根据Id查询
* @param travelRouteId
* @return
*/
TravelRoute queryTravelById(LongtravelRouteId);
/**
* 分页查询TravelRoute列表
* @param travelRouteName
* @return
*/
List<TravelRoute> queryTravelByName(StringtravelRouteName);
/**
* 模糊查询TravelRoute列表
* @param travelRoute
* @return
*/
List<TravelRoute>queryTravelByQuery(TravelRoute travelRoute);
/**
* 模糊查询TravelRoute列表
* @param travelRoute
* @return
*/
List<TravelRoute>queryTravelByChooseQuery(TravelRoute travelRoute);
/**
* 根据travelRouteIdList返回列表
* @param travelRouteIdList
* @return
*/
List<TravelRoute>queryTravelByForEach(List<Long> travelRouteIdList);
}
第五步 编写你的Mapper
TravelRouteMapper.xml
<?xml version="1.0"encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTDMapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.pz.web.study.ssm.dao.TravelRouteDao">
<resultMap id="TravelRouteType"type="TravelRoute" >
<result column = "travel_route_id"property="travelRouteId"/>
<result column = "travel_route_name"property="travelRouteName"/>
<result column = "travel_route_price"property="travelRoutePrice"/>
<result column = "travel_route_introduce"property="travelRouteIntroduce"/>
<result column = "travel_route_flag"property="travelRouteFlag"/>
<result column = "travel_route_date"property="travelRouteDate"/>
<result column = "isThemeTour"property="isThemeTour"/>
<result column = "travel_route_count"property="travelRouteCount"/>
<result column = "travel_route_cid"property="travelRouteCid"/>
<result column = "travel_route_image"property="travelRouteImage"/>
<result column ="travel_route_seller_id"property="travelRouteSellerId"/>
</resultMap>
<insert id="add"parameterType="com.pz.web.study.ssm.domain.TravelRoute">
INSERT
INTO travel_route
(travel_route_name,travel_route_price,travel_route_introduce,travel_route_flag,travel_route_date,isThemeTour,travel_route_count,travel_route_cid,travel_route_image,travel_route_seller_id)
values(#{travelRouteName},#{travelRoutePrice},#{travelRouteIntroduce},#{travelRouteFlag},#{travelRouteDate},#{isThemeTour},#{travelRouteCount},#{travelRouteCid},#{travelRouteImage},#{travelRouteSellerId})
<selectKey resultType="Long"keyProperty="travelRouteId" order="AFTER">
SELECT @@identity
</selectKey>
</insert>
<delete id="deleteById"parameterType="Long">
delete from travel_route where travel_route_id=#{travelRouteId}
</delete>
<update id="updateById">
update
travel_route
set
<if test="travelRouteName!= null and travelRouteName != ''">
travel_route_name=#{travelRouteName},
</if>
<if test="travelRoutePrice!= null and travelRoutePrice >0 ">
travel_route_price=#{travelRoutePrice},
</if>
<if test="travelRouteIntroduce!= null and travelRouteIntroduce != ''">
travel_route_introduce=#{travelRouteIntroduce},
</if>
<if test="travelRouteFlag!= null ">
travel_route_flag=#{travelRouteFlag},
</if>
<if test="travelRouteFlag!= null ">
travel_route_date=#{travelRouteDate},
</if>
<if test="travelRouteFlag!= null ">
isThemeTour=#{isThemeTour},
</if>
<if test="travelRouteCount!= null and travelRouteCount > 0 ">
travel_route_count=#{travelRouteCount},
</if>
<if test="travelRouteCid!= null and travelRouteCid > 0 ">
travel_route_cid=#{travelRouteCid},
</if>
<if test="travelRouteImage!= null and travelRouteImage != ''">
travel_route_image=#{travelRouteImage},
</if>
<if test="travelRouteSellerId!= null and travelRouteSellerId >0 ">
travel_route_seller_id=#{travelRouteSellerId}
</if>
where travel_route_id =#{travelRouteId}
</update>
<select id="queryTravelByPage"resultMap="TravelRouteType" parameterType="java.util.Map">
select
travel_route_id ,
travel_route_name ,
travel_route_price ,
travel_route_introduce ,
travel_route_flag ,
travel_route_date ,
isThemeTour ,
travel_route_count ,
travel_route_cid ,
travel_route_image ,
travel_route_seller_id
from travel_route order by travel_route_id desc limit #{startRow},#{endRow}
</select>
<select id="queryTravelById"resultMap="TravelRouteType" parameterType="Long">
select
travel_route_id ,
travel_route_name ,
travel_route_price ,
travel_route_introduce ,
travel_route_flag ,
travel_route_date ,
isThemeTour ,
travel_route_count,
travel_route_cid ,
travel_route_image ,
travel_route_seller_id
from travel_route where travel_route_id =#{travelRouteId}
</select>
<select id="queryTravelByName"resultType="TravelRoute" parameterType="String">
select
travel_route_id as travelRouteId,
travel_route_name as travelRouteName,
travel_route_price as travelRoutePrice,
travel_route_introduce astravelRouteIntroduce,
travel_route_flag as travelRouteFlag,
travel_route_date as travelRouteDate,
isThemeTour as isThemeTour,
travel_route_count as travelRouteCount,
travel_route_cid as travelRouteCid,
travel_route_image as travelRouteImage,
travel_route_seller_id astravelRouteSellerId
from travel_route where travel_route_name like '%' #{travelRouteName} '%'
</select>
<select id="queryTravelByQuery"resultMap="TravelRouteType" parameterType="TravelRoute">
select
travel_route_id ,
travel_route_name ,
travel_route_price ,
travel_route_introduce ,
travel_route_flag ,
travel_route_date ,
isThemeTour ,
travel_route_count,
travel_route_cid ,
travel_route_image ,
travel_route_seller_id
from travel_route
<where>
<if test="travelRouteName!= null and travelRouteName != ''">
and travel_route_name like '%' #{travelRouteName} '%'
</if>
<if test="travelRoutePrice!= null and travelRoutePrice >0 ">
and <![CDATA[travel_route_price >= #{travelRoutePrice}]]>
</if>
</where>
</select>
<select id="queryTravelByChooseQuery"resultMap="TravelRouteType" parameterType="TravelRoute">
select
travel_route_id ,
travel_route_name ,
travel_route_price ,
travel_route_introduce ,
travel_route_flag ,
travel_route_date ,
isThemeTour ,
travel_route_count,
travel_route_cid ,
travel_route_image ,
travel_route_seller_id
from travel_route
<where>
<choose>
<when test="travelRouteName!= null and travelRouteName != ''">
and travel_route_name like '%' #{travelRouteName} '%'
</when>
<when test="travelRoutePrice!= null and travelRoutePrice >0 ">
andtravel_route_price>#{travelRoutePrice}
</when>
<otherwise>
1 >2
</otherwise>
</choose>
</where>
</select>
<select id="queryTravelByForEach"resultMap="TravelRouteType" >
select
<include refid="commonselect"/>
from travel_route
<where>
<choose>
<when test="list != nulland list.size>0">
travel_route_id IN
<foreach collection="list"open="(" close=")"item="id" separator=",">
#{id}
</foreach>
</when>
<otherwise>
1 >2
</otherwise>
</choose>
</where>
</select>
<sql id = "commonselect">
travel_route_id ,
travel_route_name ,
travel_route_price ,
travel_route_introduce ,
travel_route_flag ,
travel_route_date ,
isThemeTour ,
travel_route_count,
travel_route_cid ,
travel_route_image ,
travel_route_seller_id
</sql>
</mapper>本文参与 腾讯云自媒体分享计划，分享自微信公众号。
原始发表：2020-06-17，如有侵权请联系 cloudcommunity@tencent.com 删除
评论
登录后参与评论
推荐阅读
目录