Struts2框架实现图书管理

最新推荐文章于 2020-08-19 14:48:04 发布

PneumaticChina

最新推荐文章于 2020-08-19 14:48:04 发布

阅读量316

点赞数 1

文章标签： Struts2框架进行图书管理

本文链接：https://blog.csdn.net/PneumaticChina/article/details/83834293

版权

Struts2框架实现图书管理：（图书的增删改查）

**
1.首先我们得确保struts框架搭建完毕
在lib下放入我们所需要的jar包
在这里插入图片描述

2.先新建一个数据库来存储数据:
在MyDB库下创建一个book表：
在这里插入图片描述
注意：id设置成主键自增
3.创建一个web项目然后把包结构创建成mvc结构：

注意：user文件夹来放置用户登陆页面 book文件夹来存图书管理页面
登陆页面：login.jsp(在user下)

<%@ 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>登录页面</title>
  </head>
  
  <body>
    <form action="<%=basePath%>/user/login" method="post">
          用户名:<input type="text" name="name"/><br>
          密码:<input type="text" name="pwd"/><br>
    <input type="submit" value="提交"/>
    </form>
  </body>
</html>

图书管理bookList.jsp（在book下）：

<%@ 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"  %>
<%@ taglib prefix="s" uri="/struts-tags"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
   <style type="text/css">
    body{
    	margin-left: 200pt;
    }
    table,table tr th, table tr td 
    	{
    		border: 1px solid grey
   		 }
    </style>
    <base href="<%=basePath%>">
    
    <title>图书管理</title>
  </head>
  
  <body>
  <a href='<%=basePath %>book/toAddBook'>新增图书</a>
     <table>
       <thead>
         <tr>
           <th>编号</th>
           <th>书名</th>
           <th>作者</th>
           <th>出版社</th>
           <th>ISBN</th>
           <th>操作</th>
         </tr>
       </thead>
       <tbody>
       <s:iterator value="#request.books" status="book">
           <tr>
             <td><s:property value="id" /><br/></td>
             <td><s:property value="bookName" /><br/></td>
             <td><s:property value="bookAuthor" /><br/></td>
             <td><s:property value="bookPublish" /><br/></td>
             <td><s:property value="bookIsbn" /><br/></td>
             <td><a href="<%=basePath %>book/selectBookId?book.id=<s:property value="id"/>">更新</a> <a href="<%=basePath %>book/delBook?book.id=<s:property value="id"/>">删除</a></td>
           </tr>
           </s:iterator>
       </tbody>
    </table>
  </body>
</html>

新增图书页面addBook.jsp（在book下）：

<%@ 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>新增图书</title>

  </head>
  
  <body>
        <form  action="book/addBook" method="post">
		书名：<input type="text" name="book.bookName" /><br /> 
		作者：<input type="text" name="book.bookAuthor" /><br /> 
		ISBN：<input type="text" name="book.bookIsbn" /><br /> 
		出版商：<input type="text" name="book.bookPublish" /><br /> 
		<input type="submit" value="提交" />
	    </form>
  </body>
</html>

更新图书manage.jsp页面（在book下）：

<%@ 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"  %>
<%@ taglib prefix="s" uri="/struts-tags" %>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <base href="<%=basePath%>">
    
    <title>更新页面</title>
  </head>
  
  <body>
    更新内容：
    <form action="book/updateBook" method="post">
	    <table>
		    <thead>
		    		<tr>
		    			<th>编号</th>
		    			<th>图书名称</th>
		    			<th>作者</th>
		    			<th>出版社</th>
		    			<th>ISBN</th>   			
		    		</tr>
		    </thead>
		    <s:iterator value="#request.booksId" status="booksId">
		   		<tr>
			  		<td><input type="text" value=" <s:property value="id"/>" name="book.id"/></td>
			  		<td><input type="text" value=" <s:property value="bookName"/>" name="book.bookName"/></td>
			  		<td><input type="text" value=" <s:property value="bookAuthor"/>" name="book.bookAuthor"/></td>
			  		<td><input type="text" value=" <s:property value="bookIsbn"/>" name="book.bookIsbn"/></td>
			  		<td><input type="text" value=" <s:property value="bookPublish"/>" name="book.bookPublish"/></td>
		  		</tr>		  	
		  	</s:iterator> 
	    </table>
	    <input type="submit" value="提交"/>
    </form>
  </body>
</html>

4.接着来写action包的内容来实现登陆功能：
LoginAction.java(注意是class文件)

package com.cq.action;

import java.util.Map;

import com.opensymphony.xwork2.ActionContext;
import com.opensymphony.xwork2.ActionSupport;

public class LoginAction extends ActionSupport {
    private String name;
    private String pwd;
	public String getName() {
		return name;
	}
	public void setName(String name) {
		this.name = name;
	}
	public String getPwd() {
		return pwd;
	}
	public void setPwd(String pwd) {
		this.pwd = pwd;
	}
	public String login(){
		if(name!=null && !"".equals(name) &&pwd!=null && !"".equals(pwd) ){
    		if("admin".equals(name) && "123".equals(pwd)){
    		   Map<String,Object>session = ActionContext.getContext().getSession();
    		   session.put("user",name);
    			return "success";
    		}else{
    			return "fail";
    		}
    	}else{
    		return "fail";
    	}
    }
}

dao包内容：
BookDao.java

package com.cq.dao;

import java.util.List;

import com.cq.bean.Book;

public interface BookDao {
	/**
	 * 查询所有图书
	 * @return
	 */
	public List<Book> selectBooks();
	/**
	 * 增加图书
	 * @param book
	 * @return
	 */
	public boolean addBook(Book book);

	/**
	 * 根据图书ID删除图书
	 * @param bookId
	 * @return
	 */
	public boolean deleteBook(int bookId);
	
	/**
	 * 根据图书ID查询图书
	 * @param bookId
	 * @return
	 */
	public Book selectBookId(int bookId);
	
	/**
	 * 更新图书信息
	 * @param book
	 * @return
	 */
	public boolean updateBook(Book book);

}

dao.impl包内容：（注意要和BookDao实现接口）
BookDaoImpl.java

package com.cq.dao.impl;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import com.cq.bean.Book;
import com.cq.dao.BookDao;
import com.cq.util.DButil;

public class BookDaoImpl implements BookDao {

	public List<Book> selectBooks() {
		// TODO 交接数据库
		Connection conn = DButil.getConn();
		
		String sql = "select * from book";
		
		PreparedStatement ps = null;
		ResultSet rs = null;
		
		List<Book> books = new ArrayList<Book>();
		
		try{
			ps = conn.prepareStatement(sql);
			rs = ps.executeQuery();
			while(rs.next()){
				Book book = new Book();
				book.setId(rs.getInt(1));
				book.setBookName(rs.getString(2));
				book.setBookAuthor(rs.getString(3));
				book.setBookPublish(rs.getString(4));
				book.setBookIsbn(rs.getString(5));
				books.add(book);
			}
		}catch(SQLException e){
			e.printStackTrace();
		}finally{
			DButil.closeConn(conn, ps, rs);
		}
		return books;
	}

	public boolean addBook(Book book) {
		Connection conn = DButil.getConn();
		String sql = "insert into book (book_name,book_author,book_isbn,book_publish) values (?,?,?,?)";
		PreparedStatement ps = null;
		int count = 0;
		try {
			ps = conn.prepareStatement(sql);
			ps.setString(1, book.getBookName());
			ps.setString(2, book.getBookAuthor());
			ps.setString(3, book.getBookIsbn());
			ps.setString(4, book.getBookPublish());
			count = ps.executeUpdate();

		} catch (Exception e) {
			e.printStackTrace();
		} finally {
			DButil.closeConn(conn, ps, null);
		}

		if (count > 0)
			return true;
		else
			return false;
	}

	public boolean deleteBook(int bookId) {
		Connection conn = DButil.getConn();
		String sql = "delete from book where id = ?";
		PreparedStatement ps = null;
		int count = 0;
		try {
			ps = conn.prepareStatement(sql);
			
			ps.setInt(1, bookId);
			count = ps.executeUpdate();

		} catch (Exception e) {
			e.printStackTrace();
		} finally {
			DButil.closeConn(conn, ps, null);
		}

		if (count > 0)
			return true;
		else
			return false;
	}

	public Book selectBookId(int bookId) {
		Connection conn = DButil.getConn();
		String sql = "select * from book where id = ?";
		PreparedStatement ps = null;
		ResultSet rs = null;
		Book book = new Book();
		
		try {
			ps = conn.prepareStatement(sql);
			ps.setInt(1, bookId);
			rs = ps.executeQuery();
			if(rs.next()){
				
				book.setId(rs.getInt(1));
				book.setBookName(rs.getString(2));
				book.setBookAuthor(rs.getString(3));
				book.setBookIsbn(rs.getString(4));
				book.setBookPublish(rs.getString(5));
			
			}

		} catch (Exception e) {
			e.printStackTrace();
		} finally {
			DButil.closeConn(conn, ps, null);
		}
		return book;
	}

	public boolean updateBook(Book book) {
		Connection conn = DButil.getConn();
		String sql = "update  book  set book_name =  ?,book_author = ?,book_isbn = ?,book_publish = ? where id =?" ;
		PreparedStatement ps = null;
		int count = 0;
		try {
			ps = conn.prepareStatement(sql);
			ps.setString(1, book.getBookName());
			ps.setString(2, book.getBookAuthor());
			ps.setString(3, book.getBookIsbn());
			ps.setString(4, book.getBookPublish());
			ps.setInt(5, book.getId());
			count = ps.executeUpdate();

		} catch (Exception e) {
			e.printStackTrace();
		} finally {
			DButil.closeConn(conn, ps, null);
		}
		if (count > 0)
			return true;
		else
			return false;
	}

}

service包内容：
BookService.java

package com.cq.service;

import java.util.List;

import com.cq.bean.Book;

public interface BookService{
	/**
	 * 查询所有图书
	 * @return
	 */
	public List<Book> selectBooks();
	/**
	 * 增加图书
	 * @param book
	 * @return
	 */
	public boolean addBook(Book book);

	/**
	 * 根据图书ID删除图书
	 * @param bookId
	 * @return
	 */
	public boolean deleteBook(int bookId);
	
	/**
	 * 根据图书ID查询图书
	 * @param bookId
	 * @return
	 */
	public Book selectBookId(int bookId);
	
	/**
	 * 更新图书信息
	 * @param book
	 * @return
	 */
	public boolean updateBook(Book book);

}

service.impl包内容：
BookServiceImpl.java

package com.cq.service.impl;

import java.util.List;

import com.cq.bean.Book;
import com.cq.dao.BookDao;
import com.cq.dao.impl.BookDaoImpl;
import com.cq.service.BookService;

public class BookServiceImpl implements BookService {

	/**
	 * 查询所有图书
	 * @return
	 */
	public List<Book> selectBooks() {
		// TODO 从数据库获取内容进行数据组织
		BookDao bookDao = new BookDaoImpl();
		List<Book> books = bookDao.selectBooks();
		return books;
	}

	/**
	 * 增加图书
	 * @param book
	 * @return
	 */
	public boolean addBook(Book book) {
		BookDao bookDao = new BookDaoImpl();
		return  bookDao.addBook(book);
		
		
	}

	/**
	 * 根据图书ID删除图书
	 * @param bookId
	 * @return
	 */
	public boolean deleteBook(int bookId) {
		BookDao bookDao = new BookDaoImpl();
		return  bookDao.deleteBook(bookId);
		
		
	}
	
	/**
	 * 根据图书ID查询图书
	 * @param bookId
	 * @return
	 */
	public Book selectBookId(int bookId) {
		BookDao bookDao = new BookDaoImpl();
		Book book =  bookDao.selectBookId(bookId);
		return book;

	}


	/**
	 * 更新图书信息
	 * @param book
	 * @return
	 */

	public boolean updateBook(Book book) {
		BookDao bookDao = new BookDaoImpl();
		return  bookDao.updateBook(book);
	}

}

（service包内容和dao包内容差不多，是因为service把dao里边的内容又进行过滤）
bean包内容：
Book.java

package com.cq.bean;

public class Book {
   private int id;
   private String bookName;
   private String bookAuthor;
   private String bookPublish;
   private String bookIsbn;
   public int getId() {
	return id;
   }
   public void setId(int id) {
	this.id = id;
   }
   public String getBookName() {
	return bookName;
   }
   public void setBookName(String bookName) {
	this.bookName = bookName;
   }
	public String getBookAuthor() {
	return bookAuthor;
	}
	public void setBookAuthor(String bookAuthor) {
	this.bookAuthor = bookAuthor;
	}
	public String getBookPublish() {
	return bookPublish;
	}
	public void setBookPublish(String bookPublish) {
	this.bookPublish = bookPublish;
	}
	public String getBookIsbn() {
	return bookIsbn;
	}
	public void setBookIsbn(String bookIsbn) {
	this.bookIsbn = bookIsbn;
	}
   
}

interceptor包内容：（此包是实现拦截器功能）
UserInterceptor.java

package com.cq.interceptor;

import org.apache.logging.log4j.util.Strings;

import com.opensymphony.xwork2.ActionContext;
import com.opensymphony.xwork2.ActionInvocation;
import com.opensymphony.xwork2.interceptor.AbstractInterceptor;

public class UserInterceptor extends AbstractInterceptor  {
	@Override
	public String intercept(ActionInvocation invocation) throws Exception {
		String user=(String) ActionContext.getContext().getSession().get("user");
		if(user==null || "".equals(user)){
			return "fail";
		}
		return invocation.invoke();
	}
}

util包内容：（此包是实现数据库连接功能）
DButil.java

package com.cq.util;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

public class DButil {
	public static Connection getConn() {

		String url = "jdbc:sqlserver://localhost:1433;databaseName=MyDB";
		String user = "sa";
		String pwd = "147";
		Connection conn = null;

		try {
			Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
			conn = DriverManager.getConnection(url, user, pwd);
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return conn;
	}

	public static void closeConn(Connection conn, PreparedStatement ps,
			ResultSet rs) {

		try {
			if (conn != null) {
				conn.close();
			}
		} catch (SQLException e) {

			e.printStackTrace();
		}

		try {
			if (ps != null) {
				ps.close();
			}
		} catch (SQLException e) {

			e.printStackTrace();
		}

		try {
			if (rs != null) {
				rs.close();
			}
		} catch (SQLException e) {

			e.printStackTrace();
		}
	}
}

5.接下来在action包实现图书管理功能：
BookAction.java

package com.cq.action;

import java.util.List;

import javax.servlet.http.HttpServletRequest;

import org.apache.struts2.ServletActionContext;

import com.cq.bean.Book;
import com.cq.service.BookService;
import com.cq.service.impl.BookServiceImpl;
import com.opensymphony.xwork2.ActionSupport;

public class BookAction extends ActionSupport {
	private Book book;
	public Book getBook() {
		return book;
	}

	public void setBook(Book book) {
		this.book = book;
	}
	/**
	 * 查询图书
	 * @return
	 */
	public String bookList(){
		//从数据库获取数据 进行数据准备 然后将数据传至bookList.jsp
		BookService bookService = new BookServiceImpl();
		List<Book> books = bookService.selectBooks();
		
		HttpServletRequest request = ServletActionContext.getRequest();
		request.setAttribute("books", books);
		return "success";
	}
	
	/**
	 * 准备新增图书
	 * @return
	 */
	public String toAddBook() {
		return "success";
	}
	
	/**
	 * 新增图书
	 * @return
	 */
	public String addBook() {
		BookService bookService = new BookServiceImpl();
		bookService.addBook(book);
		return "success";
	}
	
	/**
	 * 删除图书
	 * @return
	 */
	public String delBook(){
		BookService bookService = new BookServiceImpl();
		bookService.deleteBook(book.getId());
		return "success";
	}
	
	/**
	 * 根据id查询图书  并跳转到更新图书页面
	 * @return
	 */
	public String selectBookId(){
		BookService bookService = new BookServiceImpl();
		Book booksId = bookService.selectBookId(book.getId());
		HttpServletRequest request = ServletActionContext.getRequest();
		request.setAttribute("booksId", booksId);
		return "success";
	}
	/**
	 * 更新图书
	 * @return
	 */
	public String updateBook(){
		BookService bookService = new BookServiceImpl();
		bookService.updateBook(book);
		return "success";
		
	}
}

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>
    <package name="user" namespace="/user" extends="struts-default">
        <action name="login" class="com.cq.action.LoginAction" method="login">
           <result name="success" type="chain">
           	    <param name="namespace">/book</param>
	            <param name="actionName">BookList</param>
	            <param name="method">bookList</param>
            </result>
			<result name="fail">/user/login.jsp</result>
        </action>
    </package>
    <package name="book" namespace="/book" extends="struts-default">
     <!-- 这段代码是配置拦截器功能 -->
		<interceptors>
			<interceptor name="userInterceptor" class="com.cq.interceptor.UserInterceptor"></interceptor>
			<interceptor-stack name="selfStack">
				<interceptor-ref name="userInterceptor"></interceptor-ref>
				<interceptor-ref name="defaultStack"></interceptor-ref>
			</interceptor-stack>
		</interceptors>
		<default-interceptor-ref name="selfStack"></default-interceptor-ref>
		<global-results>
			<result name="fail">/user/login.jsp</result>
		</global-results>
		 <!-- <global-results>标签来定义全局的-->
		<action name="BookList" class="com.cq.action.BookAction"
			method="bookList">
			<result name="success">/book/bookList.jsp</result>
		</action>
		<action name="toAddBook" class="com.cq.action.BookAction"
			method="toAddBook">
			<result name="success">/book/addBook.jsp</result>
		</action>
		<action name="addBook" class="com.cq.action.BookAction"
			method="addBook">
			<result name="success" type="chain">BookList</result>
		</action>
		<action name="selectBookId" class="com.cq.action.BookAction"
			method="selectBookId">
			<result name="success">/book/manage.jsp</result>
		</action>
		<action name="updateBook" class="com.cq.action.BookAction"
			method="updateBook">
			<result name="success" type="chain">BookList</result>
		</action>
		<action name="delBook" class="com.cq.action.BookAction"
			method="delBook">
			<result name="success" type="chain">BookList</result>
		</action>
	</package>
</struts>

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" version="2.5">
  <welcome-file-list>
    <welcome-file>index.jsp</welcome-file>
  </welcome-file-list>
  <filter>
    <filter-name>struts2</filter-name>
    <filter-class>org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter</filter-class>
  </filter>
  <filter-mapping>
    <filter-name>struts2</filter-name>
    <url-pattern>/*</url-pattern>
  </filter-mapping>
</web-app>

效果图：

就这样图书管理系统就完成了！

PneumaticChina

关注

1
点赞
踩
8

收藏

觉得还不错? 一键收藏
0
评论
Struts2框架实现图书管理

**Struts2框架实现图书管理：（图书的增删改查）**1.首先我们得确保struts框架搭建完毕在lib下放入我们所需要的jar包2.先新建一个数据库来存储数据:在MyDB库下创建一个book表：注意：id设置成主键自增3.创建一个web项目然后把包结构创建成mvc结构：注意：user文件夹来放置用户登陆页面 book文件夹来存图书管理页面登陆页面：login.j...
复制链接

扫一扫