Struts2+spring+MyBatis增删改查操作（1）

最新推荐文章于 2019-10-11 10:05:22 发布

dingqinghu

最新推荐文章于 2019-10-11 10:05:22 发布

阅读量7.1k

点赞数 1

分类专栏： iBatis 文章标签： struts spring string exception html action

本文链接：https://blog.csdn.net/dingqinghu/article/details/6266521

版权

iBatis 专栏收录该内容

9 篇文章 0 订阅

订阅专栏

主页面

http://localhost:8080/book/index.jsp

index.jsp页面代码

<%@ page language="java" pageEncoding="utf-8"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
    <title>图书管理页面</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">
</head>
<body>
    <a href="addBook.jsp">添加图书</a>
    <a href="book/viewSBook.action">浏览图书</a>
</body>
</html>

浏览图书操作

http://localhost:8080/book/book/viewSBook.action

viewBook.jsp页面代码

    <body>
        <table align="center" border="1" style="width:80%;">
            <tr>
                <th colspan="7" align="center">库存图书</th>
            </tr>
            <tr>
                <td align="left" colspan="7"><a href="<%=request.getContextPath()%>/addBook.jsp">添加新书</a></td>
            </tr>
            <tr>
                <td>书名</td>
                <td>作者</td>
                <td>价格</td>
                <td>库存量</td>
                <td>ISBN号</td>
                <td>出版社</td>
                <td>操作</td>
            </tr>
            <s:iterator value="bookList">
                <tr>
                    <td>
                        <s:property value="title"/>
                    </td>
                    <td>
                        <s:property value="author"/>
                    </td>
                    <td>
                        <s:property value="price"/>
                    </td>
                    <td>
                        <s:property value="total"/>
                    </td>
                    <td>
                        <s:property value="isbn"/>
                    </td>
                    <td>
                        <s:property value="publisher"/>
                    </td>
                    <td>
                        <a href="<%=request.getContextPath()%>/sbook/modifySBook.action?bookId=${id}">修改信息</a>
                        <a href="<%=request.getContextPath()%>/sbook/removeSBook.action?bookId=${id}">删除</a>
                    </td>
                </tr>
            </s:iterator>
            <s:property value="tips"/>
        </table>
    </body>
</html>

点击修改按钮则进入修改页面

bookMsg.jsp页面代码

    <body>
        <s:form action="/sbook/updateSBook.action">
            <s:hidden name="sbook.id">${id}</s:hidden>
            <s:textfield name="sbook.title" label="书名" readonly="true">${title}</s:textfield>
            <s:textfield name="sbook.author" label="作者">${author}</s:textfield>
            <s:textfield name="sbook.price" label="价格">${price}</s:textfield>
            <s:textfield name="sbook.total" label="总量">${total}</s:textfield>
            <s:textfield name="sbook.isbn" label="ISBN">${isbn}</s:textfield>
            <s:textfield name="sbook.publisher" label="出版社">${publisher}</s:textfield>
            <s:submit/>
        </s:form>
        <s:property value="tips" />
    </body>
</html>

点击删除操作，直接将对应记录删除

增加操作

http://localhost:8080/book/addBook.jsp

addBook.jsp页面代码

<%@ page language="java" pageEncoding="utf-8"%>
<%@ taglib prefix="s" uri="/struts-tags" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
    <title>添加图书</title>
</head>
<body>
      <s:property value="tips"/>
    <s:form action="addSBook" >
        <s:textfield name="sbook.title" label="书名"/>
        <s:textfield name="sbook.author" label="作者"/>
        <s:textfield name="sbook.price" label="价格"/>
        <s:textfield name="sbook.total" label="数量"/>
        <s:textfield name="sbook.isbn" label="ISBN号"/>
        <s:textfield name="sbook.publisher" label="出版社"/>
        <s:submit value="添加"/>
    </s:form>
    <a href="<%=request.getContextPath() %>/viewSBook.action">查看现有图书</a>
</body>
</html>

配置struts.xml文件

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE struts PUBLIC
"-//Apache Software Foundation//DTD Struts Configuration 2.0//EN"
"http://struts.apache.org/dtds/struts-2.0.dtd">

<struts>
    <include file="struts-default.xml" />
    <package name="book" extends="struts-default" >
        
        <action name="addSBook" class="com.dou.book.action.SBookAction" method="addSBook">
            <result name="success">/success.jsp</result>
            <result name="error">/error.jsp</result>
        </action>

<action name="viewSBook" class="com.dou.book.action.SBookAction" method="viewSBook">
            <result name="success">/viewBook.jsp</result>
            <result name="error">/error.jsp</result>
        </action>
        
        <action name="modifySBook" class="com.dou.book.action.SBookAction" method="modifySBook">
            <result name="success">/bookMsg.jsp</result>
            <result name="error">/error.jsp</result>
        </action>
        
        <action name="updateSBook" class="com.dou.book.action.SBookAction" method="updateSBook">
            <result name="success">/success.jsp</result>
            <result name="error">/error.jsp</result>
        </action>
        
        <action name="removeSBook" class="com.dou.book.action.SBookAction" method="removeSBook">
            <result name="success">/success.jsp</result>
            <result name="error">/error.jsp</result>
        </action>
     </package>

</struts>

实现com.dou.book.action.SBookAction类中的addSBook方法

package com.dou.book.action;

import java.util.List;

import org.springframework.beans.factory.annotation.Autowired;

import com.dou.book.data.pojo.SBook;
import com.dou.book.data.services.ISBookServices;

@SuppressWarnings("unchecked")
public class SBookAction {
    @Autowired
    ISBookServices bookServices;
    private SBook sbook;
    private String tips;
    private String bookId;
    private List bookList;

    /**
     * 添加图书信息
     *
     * @return 返回添加是否成功
     */
    public String addSBook() {
        String result = "error";
        try {
            bookServices.saveBook(sbook);
            this.setTips("添加成功");
            result = "success";
        } catch (Exception e) {
            e.printStackTrace();
            this.setTips("系统出现问题");
        }
        return result;
    }

    /**
     * 查看所有图书
     *
     * @return
     */
    public String viewSBook() {
        String result = "error";
        try {
            bookList = bookServices.findAllBook();
            result = "success";
        } catch (Exception e) {
            e.printStackTrace();
            this.setTips("系统出现问题，请稍后访问");
        }
        return result;
    }

    /**
     * 修改图书信息
     *
     * @return
     */
    public String modifySBook() {
        String result = "error";
        try {
            sbook = bookServices.getBookById(Integer
                    .parseInt(this.getBookId()));
            result = "success";
        } catch (Exception e) {
            e.printStackTrace();
            this.setTips("系统出现问题");
        }
        return result;
    }

    public String updateSBook() {
        String result = "error";
        try {
            bookServices.updateBook(sbook);
            result = "success";
        } catch (Exception e) {
            e.printStackTrace();
            this.setTips("更新操作失败");
        }
        return result;
    }

    /**
     * 删除图书
     *
     * @return
     */
    public String removeSBook() {
        String result = "error";
        try {
            bookServices.removeBook(Integer.parseInt(this.getBookId()));
            result = "success";
        } catch (Exception e) {
            e.printStackTrace();
            this.setTips("删除操作失败");
        }
        return result;
    }