Unix系统-myBatis+Spring+SpringMVC的CRUD-分页

超、凢脫俗 2022-06-07 14:06 142阅读 0赞

1.jar包

![Image 1][]![Center][]

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" id="WebApp\_ID" version="2.5">

<display-name>NetCtoss01</display-name>

<welcome-file-list>

<welcome-file>index.jsp</welcome-file>

</welcome-file-list>

<servlet-name>SpringMVC</servlet-name>

<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>

<init-param>

<param-name>contextConfigLocation</param-name>

<param-value>classpath:applicationContext.xml</param-value>

</init-param>

</servlet>

<servlet-mapping>

<servlet-name>SpringMVC</servlet-name>

<url-pattern>\*.do</url-pattern>

</servlet-mapping>

<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>

</web-app>

3.POJO类

package com.lanou3g.entity;

import java.sql.Timestamp;

public class Cost \{

private Integer id;

private String name;

private Integer base\_duration;

private Double base\_cost;

private Double unit\_cost;

private String status;

private String descr;

private Timestamp creatime;

private Timestamp startime;

private String cost\_type;

public Integer getId() \{

return id;

public void setId(Integer id) \{

this.id = id;

public String getName() \{

return name;

public void setName(String name) \{

this.name = name;

public Integer getBase\_duration() \{

return base\_duration;

public void setBase\_duration(Integer base\_duration) \{

this.base\_duration = base\_duration;

public Double getBase\_cost() \{

return base\_cost;

public void setBase\_cost(Double base\_cost) \{

this.base\_cost = base\_cost;

public Double getUnit\_cost() \{

return unit\_cost;

public void setUnit\_cost(Double unit\_cost) \{

this.unit\_cost = unit\_cost;

public String getStatus() \{

return status;

public void setStatus(String status) \{

this.status = status;

public String getDescr() \{

return descr;

public void setDescr(String descr) \{

this.descr = descr;

public Timestamp getCreatime() \{

return creatime;

public void setCreatime(Timestamp creatime) \{

this.creatime = creatime;

public Timestamp getStartime() \{

return startime;

public void setStartime(Timestamp startime) \{

this.startime = startime;

public String getCost\_type() \{

return cost\_type;

public void setCost\_type(String cost\_type) \{

this.cost\_type = cost\_type;

实体类映射

<?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">

select \* from cost

</select>

insert into cost (id,name,base\_duration,base\_cost,unit\_cost,

status,descr,cost\_type)

values

(COST\_SEQ.nextval,

\#\{name,jdbcType=VARCHAR\},

\#\{base\_duration,jdbcType=NUMERIC\},

\#\{base\_cost,jdbcType=NUMERIC\},

\#\{unit\_cost,jdbcType=NUMERIC\},

\#\{status,jdbcType=VARCHAR\},

\#\{descr,jdbcType=VARCHAR\},

\#\{cost\_type,jdbcType=VARCHAR\}

)

</insert>

select \* from cost where id=\#\{id\}

</select>

update cost set

name=\#\{name,jdbcType=VARCHAR\},

base\_duration=\#\{base\_duration,jdbcType=NUMERIC\},

base\_cost=\#\{base\_cost,jdbcType=NUMERIC\},

unit\_cost=\#\{unit\_cost,jdbcType=NUMERIC\},

descr=\#\{descr,jdbcType=VARCHAR\},

cost\_type=\#\{cost\_type,jdbcType=VARCHAR\}

where

id=\#\{id,jdbcType=NUMERIC\}

</update>

delete from cost where id=\#\{id\}

</delete>

select a.\* from (select cost.\*,rownum rn from cost) a where rn between \#\{begin\} and \#\{end\}

</select>

select count(1) from cost

</select>

update cost set status=\#\{status\} where id=\#\{id\}

</update>

</mapper>

分页Page

package com.lanou3g.entity;

public class Page \{

//每页数据量

private int pageSize=4;

//当前页码数

private int  currentPage;

private int begin;

private int end;

//数据总行数

private int rows;

//总页数

private int totalPage;

public Page() \{

super();

// TODO Auto-generated constructor stub

public Page(int currentPage,int rows) \{

begin = (currentPage - 1) \* pageSize +1;

end =  currentPage \* pageSize;

totalPage = (rows - 1) / pageSize + 1;

this.currentPage = currentPage;

this.rows = rows;

public int getPageSize() \{

return pageSize;

public void setPageSize(int pageSize) \{

this.pageSize = pageSize;

public int getCurrentPage() \{

return currentPage;

public void setCurrentPage(int currentPage) \{

this.currentPage = currentPage;

public int getBegin() \{

return begin;

public void setBegin(int begin) \{

this.begin = begin;

public int getEnd() \{

return end;

public void setEnd(int end) \{

this.end = end;

public int getRows() \{

return rows;

public void setRows(int rows) \{

this.rows = rows;

public int getTotalPage() \{

return totalPage;

public void setTotalPage(int totalPage) \{

this.totalPage = totalPage;

applicationContext.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:jdbc="http://www.springframework.org/schema/jdbc"

xmlns:jee="http://www.springframework.org/schema/jee"

xmlns:tx="http://www.springframework.org/schema/tx"

xmlns:aop="http://www.springframework.org/schema/aop"

xmlns:mvc="http://www.springframework.org/schema/mvc"

xmlns:util="http://www.springframework.org/schema/util"

xmlns:jpa="http://www.springframework.org/schema/data/jpa"

xsi:schemaLocation="

http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.2.xsd

http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-3.2.xsd

http://www.springframework.org/schema/jdbc http://www.springframework.org/schema/jdbc/spring-jdbc-3.2.xsd

http://www.springframework.org/schema/jee http://www.springframework.org/schema/jee/spring-jee-3.2.xsd

http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-3.2.xsd

http://www.springframework.org/schema/data/jpa http://www.springframework.org/schema/data/jpa/spring-jpa-1.3.xsd

http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-3.2.xsd

http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc-3.2.xsd

http://www.springframework.org/schema/util http://www.springframework.org/schema/util/spring-util-3.2.xsd">

<util:properties id="jdbc" location="classpath:jdbc.properties"/>

</bean>

</bean>

<!-- 二.整合Spring:4.5.6

spring整合其他2大框架:各种组件,同时运行,是一个多线程

-->

</bean>

<context:component-scan base-package="com.lanou3g"/>

<mvc:annotation-driven />

</bean>

</beans>

jdbc.properties

url=jdbc:oracle:thin:@localhost:1521:orcl

driver=oracle.jdbc.OracleDriver

user=lanou3g

password=lanou3g

Dao层

package com.lanou3g.dao;

import java.util.List;

import com.lanou3g.annotation.MyBatisDao;

import com.lanou3g.entity.Cost;

import com.lanou3g.entity.Page;

/\*\*

\* @author lanou3g

\*    盖章:在所有dao的接口下

\*/

@MyBatisDao

public interface CostDao \{

//查询所有

List<Cost> findAll();

//增加

void add(Cost cost);

//根据id查询

Cost findById(Integer id);

//更新

void update(Cost cost);

//删除

void delete(Integer id);

//分页

List<Cost> page(Page page);

//得到所有数据量

Integer rows();

//改变状态值

void updateStatus(Cost cost);

自定义注解

package com.lanou3g.annotation;

/\*\*

\* @author lanou3g

\* 开发SpringMVC支持的自定义注解:

\* 1.new接口

\* 2.在接口前+@

\*/

public  @interface MyBatisDao \{

controller层

package com.lanou3g.controller;

import java.util.List;

import javax.annotation.Resource;

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.RequestParam;

import com.lanou3g.dao.CostDao;

import com.lanou3g.entity.Cost;

import com.lanou3g.entity.Page;

@Controller

@RequestMapping("cost")

public class CostController \{

//注入dao

@Resource

private CostDao costDao;

@RequestMapping("findCost.do")

public String findAll(Model model,Integer currentPage)\{

/\*

\* 总结:

\* 查:查询从dao层返回的结果

\* 绑:绑定到服务器上的容器里,存对象/集合

\*         常见的容器:

\*             request

\*             session

\*            context

\*            root/valueStack(用add方式添加)

\*            model

\*        特点:都可以存key-value

\* 跳:跳转页面

\*         转发:默认

\*         重定向:服务器之间的内部跳转

\*/

if(currentPage==null)\{

currentPage=1;

Page page = new Page(currentPage,costDao.rows());

page.setCurrentPage(currentPage);

List<Cost> costs = costDao.page(page);

model.addAttribute("costs",costs);

model.addAttribute("page",page);

//对应cost\_list.jsp

return "cost/cost\_list";

@RequestMapping("preAdd.do")

public String preAdd()\{

return "cost/cost\_add";

@RequestMapping("addCost.do")

public String add(Cost cost)\{

cost.setStatus("1");

costDao.add(cost);

return "redirect:findCost.do";

@RequestMapping("preUpdate.do")

public String preUpdate(Integer id,Model model)\{

Cost cost = costDao.findById(id);

model.addAttribute("cost", cost);

return "cost/cost\_update";

@RequestMapping("update.do")

public String update(Cost cost)\{

costDao.update(cost);

return "redirect:findCost.do";

@RequestMapping("delete.do")

public String delete(@RequestParam("id") Integer id)\{

costDao.delete(id);

return "redirect:findCost.do";

@RequestMapping("updateStates.do")

public String updateStates(Integer id)\{

Cost cost = costDao.findById(id);

if(cost.getStatus().equals("1"))\{

cost.setStatus("0");

\}else\{

cost.setStatus("1");

costDao.updateStatus(cost);

return "redirect:findCost.do";

jsp页面

展示全部页面

<%@ page language="java" contentType="text/html; charset=UTF-8"

pageEncoding="UTF-8"%>

<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>

<%@taglib uri="http://java.sun.com/jsp/jstl/fmt"  prefix="fmt"%>

String path = request.getContextPath();

String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<head>

//排序按钮的点击事件

function sort(btnObj) \{

if (btnObj.className == "sort\_desc")

btnObj.className = "sort\_asc";

else

btnObj.className = "sort\_desc";

//启用

function startFee(id) \{

var r = window.confirm("确定要启用此资费吗？资费启用后将不能修改和删除。");

if(r)\{

window.location.href="updateStates.do?id="+id;

//删除

function deleteFee(id) \{

var r = window.confirm("确定要删除此资费吗？");

if(r)\{

window.location.href="delete.do?id="+id;

</script>

</head>

<body>

</div>

</ul>

</div>

<div>

</div>

<input type="button" value="增加" class="btn\_add" οnclick="location.href='<%=basePath%>/cost/preAdd.do';" />

</div>

删除成功！

</div>

<tr>

</tr>

<c:forEach items="$\{costs\}" var="c">

<tr>

<td>$\{c.base\_duration \}</td>

<td>

<!--    标签父子关系:

choose

when

otherwise -->

<%-- <c:choose>

<c:when test="$\{c.status==0\}">

开通

</c:when>

<c:otherwise>

暂停

</c:otherwise>

</c:choose> --%>

<c:if test="$\{c.status==0\}">

开通

</c:if>

<c:if test="$\{c.status!=0\}">

暂停

</c:if>

</td>

<td>

<input type="button" value="修改" class="btn\_modify"

οnclick="location.href='<%=basePath%>/cost/preUpdate.do?id=$\{c.id\}';" />

</td>

</tr>

</c:forEach>

</table>

1、创建资费时，状态为暂停，记载创建时间；<br />

2、暂停状态下，可修改，可删除；<br />

3、开通后，记载开通时间，且开通后不能修改、不能再停用、也不能删除；<br />

4、业务账号修改资费时，在下月底统一触发，修改其关联的资费ID（此触发动作由程序处理）

</p>

</div>

<c:if test="$\{page.currentPage > 1 \}">

<a href="<%=basePath%>/cost/findCost.do?currentPage=$\{page.currentPage - 1\}">上一页</a>

</c:if>

<c:forEach begin="1" end="$\{page.totalPage\}" var="i" step="1">

<a href="<%=basePath%>/cost/findCost.do?currentPage=$\{i\}" class="current\_page" >$\{i\}</a>

</c:forEach>

<c:if test="$\{page.currentPage != page.totalPage \}">

<a href="<%=basePath%>/cost/findCost.do?currentPage=$\{page.currentPage + 1\}">下一页</a>

</c:if>

</div>

</form>

</div>

<p>\[源自北美的技术，最优秀的师资，最真实的企业环境，最适用的实战项目\]</p>

</div>

</body>

</html>

增加页面

<%@ page language="java" contentType="text/html; charset=UTF-8"

pageEncoding="UTF-8"%>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<head>

//保存结果的提示

function showResult() \{

showResultDiv(true);

window.setTimeout("showResultDiv(false);", 3000);

function showResultDiv(flag) \{

var divResult = document.getElementById("save\_result\_info");

if (flag)

divResult.style.display = "block";

else

divResult.style.display = "none";

//切换资费类型

function feeTypeChange(type) \{

var inputArray = document.getElementById("main").getElementsByTagName("input");

if (type == 1) \{

inputArray\[4\].readOnly = true;

inputArray\[4\].value = "";

inputArray\[4\].className += " readonly";

inputArray\[5\].readOnly = false;

inputArray\[5\].className = "width100";

inputArray\[6\].readOnly = true;

inputArray\[6\].className += " readonly";

inputArray\[6\].value = "";

else if (type == 2) \{

inputArray\[4\].readOnly = false;

inputArray\[4\].className = "width100";

inputArray\[5\].readOnly = false;

inputArray\[5\].className = "width100";

inputArray\[6\].readOnly = false;

inputArray\[6\].className = "width100";

else if (type == 3) \{

inputArray\[4\].readOnly = true;

inputArray\[4\].value = "";

inputArray\[4\].className += " readonly";

inputArray\[5\].readOnly = true;

inputArray\[5\].value = "";

inputArray\[5\].className += " readonly";

inputArray\[6\].readOnly = false;

inputArray\[6\].className = "width100";

</script>

</head>

<body>

</div>

</ul>

</div>

<div id="save\_result\_info" class="save\_fail">保存失败，资费名称重复！</div>

<div class="validate\_msg\_short">50长度的字母、数字、汉字和下划线的组合</div>

</div>

</div>

<div class="validate\_msg\_long">1-600之间的整数</div>

</div>

<div class="validate\_msg\_long error\_msg">0-99999.99之间的数值</div>

</div>

<div class="validate\_msg\_long error\_msg">0-99999.99之间的数值</div>

</div>

<div class="validate\_msg\_short error\_msg">100长度的字母、数字、汉字和下划线的组合</div>

</div>

</div>

</form>

</div>

<span>\[源自北美的技术，最优秀的师资，最真实的企业环境，最适用的实战项目\]</span>

<br />

</div>

</body>

</html>

更新页面

<%@ page language="java" contentType="text/html; charset=UTF-8"

pageEncoding="UTF-8"%>

<%@taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<head>

//保存结果的提示

function showResult() \{

showResultDiv(true);

window.setTimeout("showResultDiv(false);", 3000);

function showResultDiv(flag) \{

var divResult = document.getElementById("save\_result\_info");

if (flag)

divResult.style.display = "block";

else

divResult.style.display = "none";

//切换资费类型

function feeTypeChange(type) \{

var inputArray = document.getElementById("main").getElementsByTagName("input");

if (type == 1) \{

inputArray\[5\].readOnly = true;

inputArray\[5\].value = "";

inputArray\[5\].className += " readonly";

inputArray\[6\].readOnly = false;

inputArray\[6\].className = "width100";

inputArray\[7\].readOnly = true;

inputArray\[7\].className += " readonly";

inputArray\[7\].value = "";

else if (type == 2) \{

inputArray\[5\].readOnly = false;

inputArray\[5\].className = "width100";

inputArray\[6\].readOnly = false;

inputArray\[6\].className = "width100";

inputArray\[7\].readOnly = false;

inputArray\[7\].className = "width100";

else if (type == 3) \{

inputArray\[5\].readOnly = true;

inputArray\[5\].value = "";

inputArray\[5\].className += " readonly";

inputArray\[6\].readOnly = true;

inputArray\[6\].value = "";

inputArray\[6\].className += " readonly";

inputArray\[7\].readOnly = false;

inputArray\[7\].className = "width100";

</script>

</head>

<body>

</div>

</ul>

</div>

</div>

<div class="validate\_msg\_short">50长度的字母、数字、汉字和下划线的组合</div>

</div>

<!--

需要根据查询到的cost.cost\_type的值，

来设置下面3个radio的默认勾选。

如果查询结果=1，则勾选包月，即在包月的radio

上添加checked属性；

如果查询结果=2，则勾选套餐，即在套餐的radio

上添加checked属性；

如果查询结果=3，则勾选计时，即在计时的radio

上添加checked属性；

-->

<input type="radio" name="cost\_type" value="1"  <c:if test="$\{cost.cost\_type==1\}">checked</c:if>   id="monthly" οnclick="feeTypeChange(1);" />

<input type="radio" name="cost\_type" value="2" <c:if test="$\{cost.cost\_type==2\}">checked</c:if> id="package" οnclick="feeTypeChange(2);" />

<input type="radio" name="cost\_type" value="3" <c:if test="$\{cost.cost\_type==3\}">checked</c:if>  id="timeBased" οnclick="feeTypeChange(3);" />

</div>

<div class="validate\_msg\_long">1-600之间的整数</div>

</div>

<div class="validate\_msg\_long">0-99999.99之间的数值</div>

</div>

<div class="validate\_msg\_long">0-99999.99之间的数值</div>

</div>

<textarea name="descr" class="width300 height70">$\{cost.descr\}</textarea>

<div class="validate\_msg\_short">100长度的字母、数字、汉字和下划线的组合</div>

</div>

</div>

</form>

</div>

<span>\[源自北美的技术，最优秀的师资，最真实的企业环境，最适用的实战项目\]</span>

<br />

</div>

</body>

</html>

[Image 1]: 
[Center]: /images/20220607/6cf38325fbd54ba0b58719d3e450c923.png

Unix系统-myBatis+Spring+SpringMVC的CRUD-分页

发表评论取消回复

还没有评论，来说两句吧...

相关阅读

相关 MybatisPlus标准数据层开发(CRUD、lombok、分页)

相关 mybatis-plus CRUD及分页查询代码示例

相关 Java的PDF分页操作：分页读取、分页拆分

相关 MyBatis-Plus（六）Mapper的CRUD接口3：分页查询

相关 Unix系统-myBatis+Spring+SpringMVC的CRUD-分页

相关分页介绍；分页的种类，分页的原理

相关 Unix-2-CRUD-分页+模糊查询-状态更改

相关 SSM框架整合-实现CRUD，登录和分页操作

相关汽车出租2客户crud和分页

相关 Mybatis第二篇【CRUD、分页】