【SSM整合】-项目搭建

于 2017-05-14 19:41:41 发布
阅读量445 收藏
点赞数 1
分类专栏： web后端
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.youkuaiyun.com/nuolamian3803/article/details/72057515
版权

先放出我的目录结构
目录结构

各配置文件已经在其他博文里提到了，这里是整合项目剩余的部分，简单做个小例子测试下
事先创建好了三个页面这里写图片描述

addStudent.jsp

<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <base href="<%=basePath%>">

    <title>My JSP 'addStudent.jsp' starting page</title>

    <meta http-equiv="pragma" content="no-cache">
    <meta http-equiv="cache-control" content="no-cache">
    <meta http-equiv="expires" content="0">    
    <meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
    <meta http-equiv="description" content="This is my page">
    <!--
    <link rel="stylesheet" type="text/css" href="styles.css">
    -->

  </head>

  <body>
    <form action="addStudent.do" method="post">
        姓名：<input type="text" name="name"/>
        性别：<label for="sex1">男</label><input id="sex1" type="radio" name="sex" value="1"/>
        <label for="sex2">女</label><input id="sex2" type="radio" name="sex" value="2"/>
        <button type="submit">添加</button>
    </form>
  </body>
</html>

showStudent.jsp

<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%
    String path = request.getContextPath();
    String basePath = request.getScheme() + "://" + request.getServerName() + ":" + request.getServerPort()
            + path + "/";
%>
<%@taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<base href="<%=basePath%>">

<title>My JSP 'showStudent.jsp' starting page</title>

<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">
<!--
    <link rel="stylesheet" type="text/css" href="styles.css">
    -->

</head>

<body>
    <c:forEach items="${user }" var="item">
        姓名：【${item.name }】
        性别：【${item.sex }】
        <a href="listbyid.do?id=${item.id }">修改</a>
        <a href="delete.do?id=${item.id }">删除</a><br/>
    </c:forEach>
    <br>
</body>
</html>

updateStudent.jsp

<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<%@taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <base href="<%=basePath%>">

    <title>My JSP 'updateStudent.jsp' starting page</title>

    <meta http-equiv="pragma" content="no-cache">
    <meta http-equiv="cache-control" content="no-cache">
    <meta http-equiv="expires" content="0">    
    <meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
    <meta http-equiv="description" content="This is my page">
    <!--
    <link rel="stylesheet" type="text/css" href="styles.css">
    -->

  </head>

  <body>
    <form action="reedit.do" method="post">
        <input type="hidden" name="id" value="${s.id }"/>
        姓名：
        <input type="text" name="name" value="${s.name }"/>
        性别：
        <label for="sex1">男</label><input id="sex1" type="radio" name="sex" value="1" <c:if test="${s.sex==1 }">checked='checked'</c:if>/>
        <label for="sex2">女</label><input id="sex2" type="radio" name="sex" value="2" <c:if test="${s.sex==2 }">checked='checked'</c:if>/>
        <button type="submit">修改</button>
    </form>
  </body>
</html>

其实，addStudent和updateStudent完全可以用一个页面由于太懒就用了俩

整个业务过程从form提交表单到Controller，然后Controller调用service层去实现dao的sql查询，最终返回到controller实现页面跳转和数据传递

数据库链接配置
这里写图片描述

Controller层

package cn.fserve.controller;

import java.util.List;

import javax.annotation.Resource;

import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.ResponseBody;
import org.springframework.web.servlet.ModelAndView;

import cn.fserve.model.ModelStudent;
import cn.fserve.service.impl.ServiceStudentImpl;
import cn.fserve.util.AutoIdBySys;

@Controller
public class ControllerStudent {

    @Resource
    private ServiceStudentImpl service;

    private final static Logger logger = LoggerFactory.getLogger(ControllerStudent.class);

    @RequestMapping(value = "showStudent.do")
    public ModelAndView selectAllStudent() {
        List<ModelStudent> list = service.selectAllStudent();
        ModelAndView model = new ModelAndView();
        model.addObject("user", list);
        model.setViewName("showStudent");
        return model;
    }

//  @RequestMapping(value = "add.do")
//  public String add() {
//      return "addStudent";
//  }

    @RequestMapping(value = "addStudent.do")
    public String addStudent(ModelStudent student) {
        if(student.getName()==null||student.getSex()==0){
            return "addStudent";
        }else{
        student.setId(AutoIdBySys.getAutoId());
        service.addStudent(student);
        return "redirect:showStudent.do";
        }
    }

    @RequestMapping(value = "listbyid.do")
    public ModelAndView selectById(@RequestParam("id") String id) {
        ModelStudent s = service.selectById(id);
        ModelAndView model = new ModelAndView();
        model.addObject("s", s);
        model.setViewName("updateStudent");
        return model;
    }

    @RequestMapping(value = "reedit.do")
    public String updateStudent(ModelStudent student) {
        service.updateStudent(student);
        return "redirect:showStudent.do";
    }

    @RequestMapping(value = "delete.do")
    public String deleteStudent(@RequestParam("id")String id){
        service.deleteStudent(id);
        return "redirect:showStudent.do";
    }
}

Dao

package cn.fserve.dao;

import java.util.List;

import org.springframework.stereotype.Repository;

import cn.fserve.model.ModelStudent;

@Repository
public interface DaoStudent {

    public List<ModelStudent> selectAllStudent();

    public ModelStudent selectById(String id);

    public int addStudent(ModelStudent student);

    public int updateStudent(ModelStudent student);

    public int deleteStudent(String id);
}

DaoMapper

<?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="cn.fserve.dao.DaoStudent">

    <select id="selectAllStudent" resultType="cn.fserve.model.ModelStudent">
        select * from student
    </select>

    <select id="selectById" parameterType="java.lang.String" resultType="cn.fserve.model.ModelStudent">
        select * from student
        where id=#{id}
    </select>

    <insert id="addStudent" parameterType="cn.fserve.model.ModelStudent">
        insert into
        student(id,name,sex) values(#{id},#{name},#{sex})
    </insert>

    <update id="updateStudent" parameterType="cn.fserve.model.ModelStudent">
        update student
        <set>
            <if test="name!=null">
                name=#{name},
            </if>
            <if test="sex!=null">
                sex=#{sex}
            </if>
        </set>
        where id=#{id}
    </update>

    <delete id="deleteStudent" parameterType="java.lang.String">
        delete from student
        where id=#{id}
    </delete>

</mapper>

Service

package cn.fserve.service;

import java.util.List;
import cn.fserve.model.ModelStudent;

public interface ServiceStudent {

    public List<ModelStudent> selectAllStudent();

    public ModelStudent selectById(String id);

    public int addStudent(ModelStudent student);

    public int updateStudent(ModelStudent student);

    public int deleteStudent(String id);

}

ServiceImpl

package cn.fserve.service.impl;

import java.util.List;

import javax.annotation.Resource;

import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.test.context.ContextConfiguration;
import org.springframework.transaction.annotation.Transactional;
import org.springframework.web.servlet.ModelAndView;

import cn.fserve.dao.DaoStudent;
import cn.fserve.model.ModelStudent;
import cn.fserve.service.ServiceStudent;

//@ContextConfiguration({"classpath:spring-mybatis.xml"})


@Service
public class ServiceStudentImpl implements ServiceStudent {

    @Resource
    private DaoStudent dao;

    private final static Logger logger = LoggerFactory.getLogger(ServiceStudent.class);

    @Override
    public List<ModelStudent> selectAllStudent() {
        return dao.selectAllStudent();
    }

    @Override
    public ModelStudent selectById(String id) {
        return dao.selectById(id);
    }

    @Override
    public int addStudent(ModelStudent student) {
        return dao.addStudent(student);
    }

    @Override
    public int updateStudent(ModelStudent student) {
        return dao.updateStudent(student);
    }

    @Override
    public int deleteStudent(String id) {
        return dao.deleteStudent(id);
    }

}

这里我调用了service的接口，实际上如果想要简单点，完全可以不要那个接口直接在service里实现dao的方法

util自己写的生成id的方法，是日期+随机数+本地ip构成

package cn.fserve.util;

import java.net.InetAddress;
import java.text.SimpleDateFormat;
import java.util.Date;

public class AutoIdBySys {
    public static String getAutoId() {
        String date = getDateSystem();
        String num = getRandomNum();
        String ip = getLocalIp();
        return date+num+ip;
    }

    private static String getDateSystem() {
        Date n = new Date();
        SimpleDateFormat sdf = new SimpleDateFormat("yyyyMMddHHmmss");
        String date = sdf.format(n);
        return date;
    }

    private static String getRandomNum() {
        Double random = Math.random();
        String str = random.toString().substring(2, 8);
        return str;
    }

    private static String getLocalIp() {
        InetAddress ia = null;
        String localip;
        String newLocalIp = null;
        try {
            ia = InetAddress.getLocalHost();
            localip = ia.getHostAddress();
            newLocalIp = localip.replace(".", "");
        } catch (Exception e) {
            e.printStackTrace();
        }
        return newLocalIp;
    }
}

测试：仅做添加测试
这里写图片描述
console打出来的log
这里写图片描述

到此就全部完成了，欢迎叨扰

评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值