1.搭建项目结构层级搭建
这就是我们的整个项目的层级机构！！！注意每个包的层级关系！！！
2.在lib导入jar包
这里要注意的是因为这个项目要用到sql server数据库，所以多了一个sqljdbc4.jar包！！！
3.在WEB-INF配置web.xml
下面是配置web.xml文件的代码
<?xml version="1.0" encoding="UTF-8"?>
<web-app version="2.5"
xmlns="http://java.sun.com/xml/ns/javaee"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://java.sun.com/xml/ns/javaee
http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd">
<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>
4.新建并完善登录页面
！！！我们为了完善层级结构所以我们要在Web-Root下新建一个文件夹，然后在这个文件夹下新建一个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="user/login" method="post">
用户名：<input type="text" name="name"/><br />
密码：<input type="text" name="pwd"/><br />
<input type="submit" value="提交" />
</form>
</body>
</html>
5.新建并修改登录Action
我们要在action包下新建一个类！！！
部分代码截图如下
代码如下
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(){
System.out.println(name+":"+pwd);
if(name !=null &&!"".equals(name) && pwd !=null &&!"".equals(pwd)){
//判断
if(name.equals("fuxian")&&pwd.equals("123")){
Map<String, Object> session = ActionContext.getContext().getSession();
session.put("user", name);
return "success";
}else{
return "error";
}
}else{
return "error";
}
}
}
6.新建并修改图书管理页面
！！！我们为了完善层级结构所以我们要在Web-Root下新建一个文件夹，然后在这个文件夹下新建一个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>ISBN</td>
<td>出版社</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="bookIsbn"/></td>
<td><s:property value="bookPublish"/></td>
<td><a href='<%=basePath %>book/toUpdateBook?book.id=<s:property value="id"/>'>更新</a> <a href='<%=basePath %>book/delBook?book.id=<s:property value="id"/>'>删除</a></td>
</tr>
</s:iterator>
<!--
<c:forEach items="${requestScope.books}" var="book">
<tr>
<td>${book.id }</td>
<td>${book.bookName }</td>
<td>${book.bookAuthor }</td>
<td>${book.bookIsbn }</td>
<td>${book.bookPublish }</td>
<td><a href='<%=basePath %>book/toUpdateBook?book.id=${book.id }'>更新</a> <a href='<%=basePath %>book/delBook?book.id=${book.id }'>删除</a></td>
</tr>
</c:forEach>
-->
</table>
</body>
</html>
7.新建并修改图书页面Action
我们要在action包下新建一个类！！！
部分代码截图如下
代码如下
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;
}
/**
* 图书列表
* @return
*/
public String listBook() {
BookService bookService = new BookServiceImpl();
List<Book> books = new ArrayList<Book>();
books = bookService.selectAllBook();
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";
}
}
8.新建并修改util类
我们要在util包下新建util类
部分代码截图如下
代码如下
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=MyDB";
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();
}
}
}
9.新建类接收图书信息
我们要在bean包下新建一个类
代码部分如下
代码如下
package com.hnpi.bean;
public class Book {
private int id;
private String bookName;
private String bookAuthor;
private String bookIsbn;
private String bookPublish;
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 bookIsbn,
String bookPublish) {
super();
this.id = id;
this.bookName = bookName;
this.bookAuthor = bookAuthor;
this.bookIsbn = bookIsbn;
this.bookPublish = bookPublish;
}
public String toString() {
return "Book [bookAuthor=" + bookAuthor + ", bookIsbn=" + bookIsbn
+ ", bookName=" + bookName + ", bookPublish=" + bookPublish
+ ", id=" + id + "]";
}
}
10.在dao包新建类并修改
部分代码截图如下
代码如下
package com.hnpi.dao;
import java.util.List;
import com.hnpi.bean.Book;
//本页面为端口
public interface BookDao {
/**
* 查询所有的图书信息
* @return 返回值：图书列表
*/
public List<Book> findAll();
/**
* 根据ID查询一条图书信息
* @param bookId 参数：图书ID
* @return 返回值：一条图书信息
*/
public Book findById(int bookId);
/**
* 修改
* @param book 参数：要修改的对象信息
* @return 返回值：修改的行数
*/
public int update(Book book);
/**
* 添加
* @param book 参数：要添加的对象信息
* @return 返回值：添加的行数
*/
public int add(Book book);
/**
* 删除
* @param bookId 参数：要删除的ID
* @return 返回值：删除的行数
*/
public int delete(int bookId);
}
11.在dao.impl包下新建类并修改
部分代码截图如下
代码如下
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.dao.BookDao;
import com.hnpi.util.DBUtil;
import com.hnpi.bean.Book;
public class BookDaoImpl implements BookDao {
PreparedStatement stat = null;
ResultSet rs = null;
public int add(Book book) {
// 定义一个返回值变量
int num = 0;
// 获取数据库连接
Connection conn = DBUtil.getConn();
// 编写SQL语句
String sql = "insert into books values (?, ?, ?, ?, ?)";
try {
// 预处理SQL语句
stat = conn.prepareStatement(sql);
stat.setString(1, book.getBookIsbn());
stat.setString(2, book.getBookName());
stat.setString(3, book.getBookAuthor());
stat.setString(4, book.getBookPublish());
// 执行SQL语句
num = stat.executeUpdate();
} catch (SQLException e) {
e.printStackTrace();
} finally {
DBUtil.closeConn(conn, stat, rs);
}
return num;
}
public int delete(int bookId) {
// 定义一个返回值变量
int num = 0;
// 获取数据库连接
Connection conn = DBUtil.getConn();
// 编写SQL语句
String sql = "delete from books where booidId = ?";
try {
// 预处理SQL语句
stat = conn.prepareStatement(sql);
stat.setInt(1, bookId);
// 执行SQL语句
num = stat.executeUpdate();
} catch (SQLException e) {
e.printStackTrace();
} finally {
DBUtil.closeConn(conn, stat, rs);
}
return num;
}
public List<Book> findAll() {
// 定义一个返回值变量
List<Book> list = null;
// 获取数据库连接
Connection conn = DBUtil.getConn();
// 编写SQL语句
String sql = "select * from books";
try {
// 预处理SQL语句
stat = conn.prepareStatement(sql);
// 执行SQL语句
rs = stat.executeQuery();
// 将结果集转化为对象列表
list = new ArrayList<Book>();
while(rs.next()){
Book book = new Book();
book.setId(rs.getInt("booidId"));
book.setBookIsbn(rs.getString("isbn"));
book.setBookName(rs.getString("name"));
book.setBookAuthor(rs.getString("author"));
book.setBookPublish(rs.getString("publish"));
list.add(book);
}
} catch (SQLException e) {
e.printStackTrace();
} finally {
DBUtil.closeConn(conn, stat, rs);
}
return list;
}
public Book findById(int bookId) {
// 定义一个返回值变量
Book book = null;
// 获取数据库连接
Connection conn = DBUtil.getConn();
// 编写SQL语句
String sql = "select * from books where booidId = ?";
try {
// 预处理SQL语句
stat = conn.prepareStatement(sql);
stat.setInt(1, bookId);
// 执行SQL语句
rs = stat.executeQuery();
// 将结果集转化为对象
if(rs.next()){
book = new Book();
book.setId(rs.getInt("booidId"));
book.setBookIsbn(rs.getString("isbn"));
book.setBookName(rs.getString("name"));
book.setBookAuthor(rs.getString("author"));
book.setBookPublish(rs.getString("publish"));
}
} catch (SQLException e) {
e.printStackTrace();
} finally {
DBUtil.closeConn(conn, stat, rs);
}
return book;
}
public int update(Book book) {
// 定义一个返回值变量
int num = 0;
// 获取数据库连接
Connection conn = DBUtil.getConn();
// 编写SQL语句
String sql = "update books set isbn=?, name=?, author=?, price=?, store=? where booidId = ?";
try {
// 预处理SQL语句
stat = conn.prepareStatement(sql);
stat.setString(1, book.getBookIsbn());
stat.setString(2, book.getBookName());
stat.setString(3, book.getBookAuthor());
stat.setString(4, book.getBookPublish());
// 执行SQL语句
num = stat.executeUpdate();
} catch (SQLException e) {
e.printStackTrace();
} finally {
DBUtil.closeConn(conn, stat, rs);
}
return num;
}
}
12.在service包新建类并修改
部分代码截图如下
代码如下
package com.hnpi.service;
import java.util.List;
import com.hnpi.bean.Book;
public interface BookService {
/**
* 增加图书
* @param book
* @return
*/
public boolean addBook(Book book);
/**
* 根据图书ID删除图书
* @param bookId
* @return
*/
public boolean deleteBook(int bookId);
/**
* 更新图书信息
* @param book
* @return
*/
public boolean updateBook(Book book);
/**
* 根据图书编号查询图书
* @param BookId
* @return
*/
public Book selectBookById(int bookId);
/**
* 查询所有图书
* @return
*/
public List<Book> selectAllBook();
}
13.在service.impl包下新建类并修改
部分代码截图如下
代码如下
package com.hnpi.service.impl;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.List;
import com.hnpi.bean.Book;
import com.hnpi.service.BookService;
import com.hnpi.util.DBUtil;
public class BookServiceImpl implements BookService {
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 List<Book> selectAllBook() {
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.setBookIsbn(rs.getString(4));
book.setBookPublish(rs.getString(5));
books.add(book);
}
} catch (Exception e) {
e.printStackTrace();
} finally {
DBUtil.closeConn(conn, ps, null);
}
return books;
}
public Book selectBookById(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(6, book.getId());
count = ps.executeUpdate();
} catch (Exception e) {
e.printStackTrace();
} finally {
DBUtil.closeConn(conn, ps, null);
}
if (count > 0)
return true;
else
return false;
}
}
14.在interceptor包下新建拦截器类并修改
代码截图如下
代码如下
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();
}
}
15.新建添加图书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 />
ISBN：<input type="text" name="book.bookIsbn" /><br />
出版商：<input type="text" name="book.bookPublish" /><br />
<input type="submit" value="提交" />
</form>
</body>
</html>
16.在src下新建并配置struts文件
部分代码截图如下
代码如下
<?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" extends="struts-default" namespace="/user">
<action name="login" class="com.hnpi.action.LoginAction"
method="login">
<result name="success" type="chain">
<param name="actionName">listBookAction</param>
<param name="namespace">/book</param>
<param name="method">listBook</param>
</result>
<result name="error" type="redirect">/user/login.jsp</result>
</action>
</package>
<package name="default" extends="struts-default" namespace="/book">
<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="listBookAction" class="com.hnpi.action.BookAction"
method="listBook">
<result name="success">/book/listBook.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">listBookAction</result>
</action>
<action name="toModifyBook" class="com.hnpi.action.BookAction"
method="toModifyBook">
<result name="success">/book/modifuBook.jsp</result>
</action>
<action name="modifyBook" class="com.hnpi.action.BookAction"
method="modifyBook">
<result name="success" type="chain">listBookAction</result>
</action>
<action name="delBook" class="com.hnpi.action.BookAction"
method="delBook">
<result name="success" type="chain">listBookAction</result>
</action>
</package>
</struts>
新建数据库和表
表结构如图
总结
一个简单的图书管理系统就完成了，可能有的功能笔者未完善，敬请见谅！！
如有问题请联系笔者qq:1967893975
1490
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
