Struts2图书管理系统

1.创建数据库

book_id   int   主键 自增

book_name     varchar(64)

book_author    varchar(64)

book_publish   varchar(64)

book_isbn        varchar(64)

2.创建Struts2 框架

（参考第一篇博客）

3.根据三层结构创建包和jsp页面

4.各个包下的详细代码

action包下BookAction类的代码：

package com.hnpi.action;

import java.util.ArrayList;
import java.util.List;

import javax.servlet.http.HttpServletRequest;

import org.apache.struts2.ServletActionContext;

import com.hnpi.bean.Book;
import com.hnpi.service.BookService;
import com.hnpi.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;
	}
	
	//查询图书

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

}

action包下LoginAction类的代码：

package com.hnpi.action;

import java.util.Map;
import javax.servlet.http.HttpSession;

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(name.equals("hjx") && pwd.equals("123")){
				Map <String,Object> session = ActionContext.getContext()
						.getSession();
				session.put("user", name);
				return "success";
			}else{
				return "fail";	
			}			
		}else{
			return "fail";
		}
	}

}

bean包下Book类的代码：

package com.hnpi.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 getBookIsbn() {
		return bookIsbn;
	}
	public void setBookIsbn(String bookIsbn) {
		this.bookIsbn = bookIsbn;
	}
	public String getBookPublish() {
		return bookPublish;
	}
	public void setBookPublish(String bookPublish) {
		this.bookPublish = bookPublish;
	}

	public Book() {
		super();
	}
	public Book(int id, String bookName, String bookAuthor, String bookPublish,
			String bookIsbn) {
		super();
		this.id = id;
		this.bookName = bookName;
		this.bookAuthor = bookAuthor;		
		this.bookPublish = bookPublish;
		this.bookIsbn = bookIsbn;
	}
	
	public String toString() {
		return "Book [[bookAuthor=" + bookAuthor + ", bookIsbn=" + bookIsbn
				+ ", bookName=" + bookName + ", bookPublish=" + bookPublish
				+ ", id=" + id + "]";
	}
}

dao包下的impi包下的BookDaoImpl类的代码：

package com.hnpi.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.hnpi.bean.Book;
import com.hnpi.dao.BookDao;
import com.hnpi.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_publish,book_isbn) 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.getBookPublish());
			ps.setString(4, book.getBookIsbn());
			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.setBookPublish(rs.getString(4));
				book.setBookIsbn(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_publish = ?,book_isbn = ? 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.getBookPublish());
			ps.setString(4, book.getBookIsbn());
			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;
	}


}

dao包下BookDao类的代码：

package com.hnpi.dao;

import java.util.List;

import com.hnpi.bean.Book;

public interface BookDao {
//	查询所有图书
	public List<Book> selectBooks();

//	增加图书
	public boolean addBook(Book book);

//	根据图书ID删除图书
	public boolean deleteBook(int bookId);
	
//	根据图书ID查询图书
	public Book selectBookId(int bookId);
	
//	更新图书信息
	public boolean updateBook(Book book);
	//public List<Book> updateBook(Book book);

}

interceptor包下UserInterceptor类的代码：

package com.hnpi.interceptor;

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();
	}
	

}

service包下的impl包下的BookServiceImpl类的代码：

package com.hnpi.service.impl;

import java.util.List;

import com.hnpi.bean.Book;
import com.hnpi.dao.BookDao;
import com.hnpi.dao.impl.BookDaoImpl;
import com.hnpi.service.BookService;
/*
 * 作用1 数据的清洗
 * 作用2 可以调用多个dao组合成页面需要显示的数据
 */
public class BookServiceImpl implements BookService{

	//  查询所有图书
	public List<Book> selectBooks() {
		// TODO 从数据库获取内容进行数据组织
		BookDao bookDao = new BookDaoImpl();
		List<Book> books = bookDao.selectBooks();
		return books;
	}
	// 增加图书
	public boolean addBook(Book book) {
		BookDao bookDao = new BookDaoImpl();
		return  bookDao.addBook(book);	
	}
	// 根据图书ID删除图书
	public boolean deleteBook(int bookId) {
		BookDao bookDao = new BookDaoImpl();
		return  bookDao.deleteBook(bookId);				
	}	
	 // 根据图书ID查询图书
	public Book selectBookId(int bookId) {
		BookDao bookDao = new BookDaoImpl();
		Book book =  bookDao.selectBookId(bookId);
		return book;
	}
	 // 更新图书信息
	public boolean updateBook(Book book) {
		BookDao bookDao = new BookDaoImpl();
		return  bookDao.updateBook(book);
	}


}

service包下BookService 类的代码：

package com.hnpi.service;

import java.util.List;

import com.hnpi.bean.Book;

public interface BookService {
//	查询所有图书
	public List<Book> selectBooks();
	
//	增加图书
	public boolean addBook(Book book);
	
//	根据图书ID删除图书
	public boolean deleteBook(int bookId);
	
//	根据图书编号查询图书
	public Book selectBookId(int bookId);
	
//	更新图书信息
	public boolean updateBook(Book book);
	
	
	
}

util包下DBUtil 类的代码：

package com.hnpi.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=MySql";
		String user = "sa";
		String pwd = "1";
		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();
		}

	}

}

6.修改sutrs的配置

<?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.hnpi.action.LoginAction" method="login">
    			<result name="success" type="chain">
					<param name="actionName">bookList</param>
					<param name="namespace">/book</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.hnpi.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>
    	
    		<action name="bookList" class="com.hnpi.action.BookAction" method="bookList">
    			<result name="success">/book/bookList.jsp</result>
    		</action>  
    		
    		
    		<action name="toAddBook" class="com.hnpi.action.BookAction"
			method="toAddBook">
			<result name="success">/book/addBook.jsp</result>
			</action>
	
			<action name="addBook" class="com.hnpi.action.BookAction"
				method="addBook">
				<result name="success" type="chain">bookList
					<param name="actionName">bookList</param>
					<param name="namespace">/book</param>
					<param name="method">bookList</param>
				</result>
			</action>

			<action name="selectBookId" class="com.hnpi.action.BookAction"
				method="selectBookId">
				<result name="success">/book/modifyBook.jsp</result>
			</action>

			
			<action name="updateBook" class="com.hnpi.action.BookAction"
				method="updateBook">
				<result name="success" type="chain">bookList
					<param name="actionName">bookList</param>
					<param name="namespace">/book</param>
					<param name="method">bookList</param>
				</result>
			</action>



			<action name="delBook" class="com.hnpi.action.BookAction"
				method="delBook">
				<result name="success" type="chain">bookList
					<param name="actionName">bookList</param>
					<param name="namespace">/book</param>
					<param name="method">bookList</param>
				</result>
			</action>			
    	</package>		
    </struts>

7.添加jsp显示页面

因为我们的图书馆开系统需要登录才可以操作，所以我们的显示页面分为user文件下的登录页面和book文件下的图书管理页面

user文件下的login.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>登录页面</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>

book文件下的bookList.jsp

<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%@taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"  %>
<%@ taglib prefix="s" uri="/struts-tags" %>
<%
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>
    
    <title>图书列表</title>
    
    <style type="text/css">
    body{
    	margin-left: 300pt;
    }
    table,table tr th, table tr td 
    	{
    		border: 1px solid grey
   		 }
    </style>
  </head>
  
  <body>
  <a href='<%=basePath %>book/toAddBook'>新增图书</a>
  <table>
  <thead>
  	<tr>
  		<td>ID</td>
  		<td>书名</td>
  		<td>作者</td>
  		<td>出版社</td>
  		<td>ISBN</td>
  		<td>操作</td>
  	</tr>
  </thead>
  
  <s:iterator value="#request.books" status="book">
	<tr>
  		<td><s:property value="id"/></td>
  		<td><s:property value="bookName"/></td>
  		<td><s:property value="bookAuthor"/></td>
  		<td><s:property value="bookPublish"/></td>
  		<td><s:property value="bookIsbn"/></td>
		<td><a href='<%=basePath %>book/selectBookId?book.id=<s:property value="id"/>'>更新</a>&nbsp;<a href='<%=basePath %>book/delBook?book.id=<s:property value="id"/>'>删除</a></td>
  	</tr>
</s:iterator> 
    </table>
  </body>
</html>

book文件下的addBook.jsp

<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%@taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>

<title>添加图书</title>
<style type="text/css">
    body{
    	margin-left: 300pt;
    }
   </style>
</head>

<body>

	<form action="book/addBook" method="post">

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

book文件下的modifyBook.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"  %>
<%@ 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="bookPublish"/>" name="book.bookPublish"/></td>
			  		<td><input type="text" value=" <s:property value="bookIsbn"/>" name="book.bookIsbn"/></td>
		  		</tr>		  	
		  	</s:iterator> 
	    </table>
	    <input type="submit" value="提交"/>
    </form>
  </body>
</html>

 最后还是给大家看下效果图：