序言:
通过我们的自定义MVC(一)我们对自定义mvc框架有了初步的了解,下面让我们通过更加具体的实例让我们对自定义mvc框架有更深刻的认识。
案例:
利用我们以前所学的知识,加上我们的自定义mvc框架来实现对内容的增删改查。
我们先来做好我们的准备工作
首先;
我们把所需要的架包和以前我们写的通用分页的所需要的.tid文件先导进来,如图所示:
然后在把我们的自定义mvc框架所需要的web.xml导入进来,如图所示:
然后在导入我们的工具类(自定义mvc框架代码,通用分页自定义标签的帮助类,连接数据库以及解决中文乱码问题的类),如图所示:
我们先来完善我们的后端代码
实体类(book.java)
代码如下:
package com.dengrenli.entity;
public class Book {
private int bid;
private String bname;
private float price;
public int getBid() {
return bid;
}
public void setBid(int bid) {
this.bid = bid;
}
public String getBname() {
return bname;
}
public void setBname(String bname) {
this.bname = bname;
}
public float getPrice() {
return price;
}
public void setPrice(float price) {
this.price = price;
}
@Override
public String toString() {
return "Book [bid=" + bid + ", bname=" + bname + ", price=" + price + "]";
}
}
BookDao.java
package com.dengrenli.dao;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.util.List;
import com.dengrenli.entity.Book;
import com.dengrenli.util.BaseDao;
import com.dengrenli.util.DBAccess;
import com.dengrenli.util.PageBean;
import com.dengrenli.util.StringUtils;
public class BookDao extends BaseDao<Book> {
/**
* 查询方法
* @param book
* @param pageBean
* @return
* @throws InstantiationException
* @throws IllegalAccessException
* @throws SQLException
*/
public List<Book> list(Book book, PageBean pageBean) throws InstantiationException, IllegalAccessException, SQLException{
String sql = "select * from t_mvc_book where true ";
String bname=book.getBname();
int bid = book.getBid();
if(StringUtils.isNotBlank(bname)) {
sql += " and bname like '%"+bname+"%'";
}
if(bid != 0) {
sql += " and bid =" +bid;
}
return super.executeQuery(sql, Book.class, pageBean);
}
/**
* 修改方法
* @param book
* @return
* @throws SQLException
* @throws NoSuchFieldException
* @throws SecurityException
* @throws IllegalArgumentException
* @throws IllegalAccessException
*/
public int edit (Book book) throws SQLException, NoSuchFieldException, SecurityException, IllegalArgumentException, IllegalAccessException {
String sql = "update t_mvc_book set bname=?,price=? where bid=?";
return super.executeUpdate(sql, new String[] {"bname","price","bid"}, book);
}
/**
* 新增
* @param book
* @return
* @throws SQLException
* @throws NoSuchFieldException
* @throws SecurityException
* @throws IllegalArgumentException
* @throws IllegalAccessException
*/
public int add (Book book) throws SQLException, NoSuchFieldException, SecurityException, IllegalArgumentException, IllegalAccessException {
String sql = "insert into t_mvc_book values(?,?,?)";
return super.executeUpdate(sql, new String[] {"bid","bname","price"}, book);
}
/**
* 删除
* @param book
* @return
* @throws SQLException
* @throws NoSuchFieldException
* @throws SecurityException
* @throws IllegalArgumentException
* @throws IllegalAccessException
*/
public int del (Book book) throws SQLException, NoSuchFieldException, SecurityException, IllegalArgumentException, IllegalAccessException {
String sql = "delete from t_mvc_book where bid=?";
return super.executeUpdate(sql, new String[] {"bid"}, book);
}
}
对我们的BaseDao.java进行重写
代码如下:
package com.dengrenli.util;
import java.lang.reflect.Field;
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.dengrenli.entity.Book;
/**
* T代表你要对哪个实体类对应表进行分页查询
*
* @author Administrator
*
* @param <T>
*/
public class BaseDao<T> {
/**
*
* @param sql
* 查询不同的实体类,那么对应的sql不同,所以需要传递
* @param clz
* 生产出不同的实体类对应的实例,然后装进list容器中返回
* @param pageBean
* 决定是否分页
* @return
* @throws SQLException
* @throws IllegalAccessException
* @throws InstantiationException
*/
public List<T> executeQuery(String sql, Class clz, PageBean pageBean)
throws SQLException, InstantiationException, IllegalAccessException {
Connection con = DBAccess.getConnection();
PreparedStatement pst = null;
ResultSet rs = null;
if (pageBean != null && pageBean.isPagination()) {
// 需要分页
// 算符合条件的总记录数
String countSql = getCountSql(sql);
pst = con.prepareStatement(countSql);
rs = pst.executeQuery();
if (rs.next()) {
pageBean.setTotal(rs.getLong(1) + "");
}
// 查询出符合条件的结果集
String pageSql = getPageSql(sql, pageBean);
pst = con.prepareStatement(pageSql);
rs = pst.executeQuery();
} else {
pst = con.prepareStatement(sql);
rs = pst.executeQuery();
}
List<T> list = new ArrayList<>();
T t;
while (rs.next()) {
/*
* 1、实例化一个book对象(该对象是空的) 2、取book的所有属性,然后给其赋值 2.1 获取所有属性对象 2.2 给属性对象赋值
* 3、赋完值的book对象装进list容器中
*/
// list.add(new Book(rs.getInt("bid"), rs.getString("bname"),
// rs.getFloat("price")));
t = (T) clz.newInstance();
Field[] fields = clz.getDeclaredFields();
for (Field field : fields) {
field.setAccessible(true);
field.set(t, rs.getObject(field.getName()));
}
list.add(t);
}
DBAccess.close(con, pst, rs);
return list;
}
/**
* 利用原生sql拼接出符合条件的结果集的查询sql
*
* @param sql
* @param pageBean
* @return
*/
private String getPageSql(String sql, PageBean pageBean) {
return sql + " limit " + pageBean.getStartIndex() + "," + pageBean.getRows();
}
/**
* 获取符合条件的总记录数的sql语句
*
* @param sql
* @return
*/
private String getCountSql(String sql) {
return "select count(1) from (" + sql + ") t";
}
/**
* 通用的增删改方法
* @param sql 决定增删改的一种
* @param attrs 决定?位置 new String[]{"bid","bname","price"}
* @param t 要操作的实体类
* @return
* @throws SQLException
* @throws SecurityException
* @throws NoSuchFieldException
* @throws IllegalAccessException
* @throws IllegalArgumentException
*/
public int executeUpdate(String sql, String[] attrs, T t) throws SQLException, NoSuchFieldException, SecurityException, IllegalArgumentException, IllegalAccessException{
Connection con = DBAccess.getConnection();
PreparedStatement pst = con.prepareStatement(sql);
// pst.setString(2, book.getBname());
// pst.setFloat(3, book.getPrice());
// pst.setInt(1, book.getBid());
for (int i = 1; i <= attrs.length; i++) {
Field f = t.getClass().getDeclaredField(attrs[i-1]);
f.setAccessible(true);
pst.setObject(i, f.get(t));
}
int num = pst.executeUpdate();
DBAccess.close(con, pst, null);
return num;
}
}
BookAction.java
代码如下:
package com.dengrenli.web;
import java.sql.SQLException;
import java.util.List;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import com.dengrenli.dao.BookDao;
import com.dengrenli.entity.Book;
import com.dengrenli.framework.ActionSupport;
import com.dengrenli.framework.ModelDrivern;
import com.dengrenli.util.PageBean;
public class BookAction extends ActionSupport implements ModelDrivern<Book> {
private Book book = new Book();
private BookDao bookDao = new BookDao();
/**
* 分页查询
* @param req
* @param resp
* @return
*/
public String list(HttpServletRequest req,HttpServletResponse resp) {
PageBean pageBean = new PageBean();
pageBean.setRequest(req);
try {
List<Book> list = this.bookDao.list(book, pageBean);
req.setAttribute("bookList", list);
req.setAttribute("pageBean", pageBean);
} catch (InstantiationException | IllegalAccessException | SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return "list";
}
/**
* 跳转到增加或者修改页面
* @param req
* @param resp
* @return
*/
public String preSave(HttpServletRequest req,HttpServletResponse resp) {
// bid的类型是int类型,而int类型的默认值是0,如果jsp未传递bid的参数值,那么bid=0
if(book.getBid() == 0) {
System.out.println("增加逻辑.....");
}else {
// 修改数据回显逻辑
try {
// 查单个
Book b = this.bookDao.list(book, null).get(0);
req.setAttribute("book", b);
} catch (InstantiationException | IllegalAccessException | SQLException e) {
e.printStackTrace();
}
}
// 新增页面与修改页面是同一个jsp
return "edit";
}
/**
* 新增
* @param req
* @param resp
* @return
*/
public String add(HttpServletRequest req,HttpServletResponse resp) {
try {
this.bookDao.add(book);
} catch (NoSuchFieldException | SecurityException | IllegalArgumentException | IllegalAccessException
| SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
// 新增完了后需要刷新页面
return "toList";
}
/**
* 修改
* @param req
* @param resp
* @return
*/
public String edit(HttpServletRequest req,HttpServletResponse resp) {
try {
this.bookDao.edit(book);
} catch (NoSuchFieldException | SecurityException | IllegalArgumentException | IllegalAccessException
| SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
// 修改完了后需要刷新页面
return "toList";
}
/**
* 删除
* @param req
* @param resp
* @return
*/
public String del(HttpServletRequest req,HttpServletResponse resp) {
try {
this.bookDao.del(book);
} catch (NoSuchFieldException | SecurityException | IllegalArgumentException | IllegalAccessException
| SQLException e) {
e.printStackTrace();
}
// 新增完了后需要刷新页面
return "toList";
}
@Override
public Book getModel() {
return book;
}
}
mvc.xml
代码如下:
<?xml version="1.0" encoding="UTF-8"?>
<!--
config标签:可以包含0~N个action标签
-->
<config>
<action path="/book" type="com.dengrenli.web.BookAction">
<forward name="list" path="/bookList.jsp" redirect="false" />
<forward name="edit" path="/bookEdit.jsp" redirect="false" />
<!-- 增删改一定要用重定向 -->
<forward name="toList" path="/book.action?methodName=list"></forward>
</action>
</config>
后端代码我们已经完成,现在我们来写前端的代码
bookList.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="/deng" prefix="z" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
</head>
<body>
<h2>小说目录</h2>
<br>
<form action="${pageContext.request.contextPath}/book.action?methodName=list"
method="post">
书名:<input type="text" name="bname"> <input type="submit"
value="确定">
<!-- <input type="hidden" name="pagination" value="false"> -->
<!-- <input type="hidden" name="rows" value="20"> -->
</form>
<a href="${pageContext.request.contextPath}/book.action?methodName=preSave">增加</a>
<table border="1" width="100%">
<tr>
<td>编号</td>
<td>名称</td>
<td>价格</td>
<td>操作</td>
</tr>
<c:forEach items="${bookList }" var="b">
<tr>
<td>${b.bid }</td>
<td>${b.bname }</td>
<td>${b.price }</td>
<td>
<a href="${pageContext.request.contextPath}/book.action?methodName=preSave&&bid=${b.bid}">修改</a>
<a href="${pageContext.request.contextPath}/book.action?methodName=del&&bid=${b.bid}">删除</a>
</td>
</tr>
</c:forEach>
</table>
<z:page pageBean="${pageBean}"></z:page>
</body>
</html>
bookEdit.jsp
代码如下:
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
</head>
<body>
<form action="${pageContext.request.contextPath}/book.action" method="post">
<input type="hidden" name="methodName" value="${book.bname == null ? 'add' : 'edit'}">
书籍ID:<input type="text" name="bid" value="${book.bid }"><br>
书籍名称:<input type="text" name="bname" value="${book.bname }"><br>
书籍价格:<input type="text" name="price" value="${book.price }"><br>
<input type="submit" value="提交">
</form>
</body>
</html>
结果如图所示:
注意: method="get"就不能引用转码的帮助类,否则还是一样会出现乱码问题, method="post"就一定要引用我们的中文转码帮助类,这样才不会乱码了
这里我感觉最厉害之处就是它把增加和修改都跳到了同一个界面,然后在页面的提交的时候给它进行了判断,判断是增加
方法还是修改方法。
代码量不是很多,因为大部分都是引用之前写的代码,需要的就是好好的去理解,理清思路,理清了你就会感觉还是蛮简单的
我们再来了解一下怎么把自己写好的工具类打成jar包(方便以后使用)
1、首先把所要打包的文件全部选中,然后右键找到Export
如图所示:
2、找到JAR file选择你要导出的文件路径
如图所示:
点击Next,然后如图所示:
选择你要导出的路径,最后点击Finish,这样就把文件成功的导出来了
如图所示:
谢谢大家,多多指教!