自定义MVC框架-增删查改
总的来说,这是我对我的最近三篇自定义MVC博客的一份总结,如果有什么不明白的话,可以参考我之前的博客 废话不多说,我现在用 学生表,班级表,老师表 来完成今天的内容
首先我们要导入所需jar包
欧克,关于学生表、老师表、班级表的实体类不需要太多复杂的属性,老师和班级写id和名字两个属性就好
学生属性写这几个就好,待会我们要跟据老师id或班级id找到该某同学
private int sid;
private String sname;
private String shobby;
private int tid;
private int cid;
准备在util工具包中创建》》》
BaseDao
关于< T >就不多说了,泛型,这是通用dao方法
package com.util;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.List;
import com.util.PageBean;
public class BaseDao<T> {
public static interface CallBack<E>{
//遍历ResultSet结果集
public List<E> forEach(ResultSet rs) throws SQLException, Exception;
}
/**
* 分页查询
* @param sql 普通的sql
* @param pageBean
* @return
*/
public List<T> executeQuery(String sql,PageBean pageBean,CallBack<T> callBack){
Connection conn=null;
PreparedStatement stmt=null;
ResultSet rs=null;
try {
conn=DBAccess.getConnection();
//判断是否分页
if(null!=pageBean&&pageBean.isPagination()) {
//第一次查询总记录数
String countSql=this.getCountSql(sql);
stmt=conn.prepareStatement(countSql);
rs=stmt.executeQuery();
if(rs.next()) {
Object obj = rs.getObject(1);
pageBean.setTotal(Integer.parseInt(obj.toString()));
}
//DBHelper.close(conn, stmt, rs);
//第二次满足条件的分页数据集
sql=this.getPagerSql(sql, pageBean);
}
stmt=conn.prepareStatement(sql);
rs=stmt.executeQuery();
//处理结果集
return callBack.forEach(rs);
} catch (Exception e) {
e.printStackTrace();
} finally {
DBAccess.close(conn, stmt, rs);
}
return null;
}
/**
* 将普通的Sql语句转换成查总记录数的Sql语句
* 例如:sql=="select * from t_book where bookname='123'"
* @param sql
* @return
*/
private String getCountSql(String sql) {
return "select count(1) from ("+sql+") t1";
}
/**
* 将普通Sql语句转换成查询分页的Sql语句
* 例如:sql=="select * from t_book where bookname='123'"
* @param sql
* @param pageBean
* @return
*/
private String getPagerSql(String sql,PageBean pageBean) {
return sql+" Limit "+pageBean.getStartIndex()+","+
pageBean.getRows();
}
}
CommonUtils
工具类
package com.util;
import java.lang.reflect.Field;
import java.lang.reflect.Method;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
public class CommonUtils {
/**
* 根据ResultSet数据集,利用反射机制动态赋值并返回List<T>
* @param rs ResultSet数据集
* @param clazz 实体类对象
* @return 返回List实体集合
* @throws Exception
*/
public static <T> List<T> toList(ResultSet rs,Class<T> clazz) throws Exception{
//定义实体集合
List<T> lst=new ArrayList<T>();
try {
//获取ResultSet的metadata列信息
ResultSetMetaData metaData = rs.getMetaData();
//获取对象属性集合
Field[] fields=clazz.getDeclaredFields();
//循环ResultSet
while(rs.next()) {
//反射机制实例化
T obj = clazz.newInstance();
for (int i = 0; i < metaData.getColumnCount(); i++) {
//获取列名
String columnName=metaData.getColumnLabel(i+1).toUpperCase();
for (Field field : fields) {
//判断属性名与列名是否相同
if(field.getName().toUpperCase().equals(columnName)) {
//获取属性对应的set方法名,方法名首字母大写
String methodName="set"+field.getName().substring(0, 1).toUpperCase()+field.getName().substring(1);
//获取属性对应的set方法
Method method = obj.getClass().getDeclaredMethod(methodName, field.getType());
//设置访问权限
method.setAccessible(true);
//执行set方法,将数据存储到对象中的相应属性中
method.invoke(obj, rs.getObject(columnName));
break;
}
}
}
lst.add(obj);
}
} catch (Exception e) {
e.printStackTrace();
}
return lst;
}
/**
* 多表查询时返回结果集,利用反射机制赋值
* @param rs
* @return 返回List<Map<String,Object>>
* @throws Exception
*/
public static List<Map<String,Object>> toList(ResultSet rs) throws Exception{
//定义实体集合
List<Map<String,Object>> lst=new ArrayList<Map<String,Object>>();
//获取ResultSet的metadata列信息
ResultSetMetaData metaData = rs.getMetaData();
Map<String,Object> set=null;
while(rs.next()) {
set=new HashMap<String,Object>();
for (int i = 0; i < metaData.getColumnCount(); i++) {
String columnName=metaData.getColumnLabel(i+1);
set.put(columnName, rs.getObject(columnName));
}
lst.add(set);
}
return lst;
}
}
DBAccess
连接数据库
package com.util;
import java.io.InputStream;
import java.security.KeyStore.ProtectionParameter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Properties;
/**
* 提供了一组获得或关闭数据库对象的方法
*
*/
public class DBAccess {
private static String driver;
private static String url;
private static String user;
private static String password;
static {// 静态块执行一次,加载 驱动一次
try {
InputStream is = DBAccess.class
.getResourceAsStream("config.properties");
Properties properties = new Properties();
properties.load(is);
driver = properties.getProperty("driver");
url = properties.getProperty("url");
user = properties.getProperty("user");
password = properties.getProperty("pwd");
Class.forName(driver);
} catch (Exception e) {
e.printStackTrace();
throw new RuntimeException(e);
}
}
/**
* 获得数据连接对象
*
* @return
*/
public static Connection getConnection() {
try {
Connection conn = DriverManager.getConnection(url, user, password);
return conn;
} catch (SQLException e) {
e.printStackTrace();
throw new RuntimeException(e);
}
}
public static void close(ResultSet rs) {
if (null != rs) {
try {
rs.close();
} catch (SQLException e) {
e.printStackTrace();
throw new RuntimeException(e);
}
}
}
public static void close(PreparedStatement ps) {
if (null != ps) {
try {
ps.close();
} catch (SQLException e) {
e.printStackTrace();
throw new RuntimeException(e);
}
}
}
public static void close(Connection conn) {
if (null != conn) {
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
throw new RuntimeException(e);
}
}
}
public static void close(Connection con, PreparedStatement ps, ResultSet rs) {
close(rs);
close(ps);
close(con);
}
public static boolean isOracle() {
return "oracle.jdbc.driver.OracleDriver".equals(driver);
}
public static boolean isSQLServer() {
return "com.microsoft.sqlserver.jdbc.SQLServerDriver".equals(driver);
}
public static boolean isMysql() {
return "com.mysql.jdbc.Driver".equals(driver);
}
public static void main(String[] args) {
Connection conn = DBAccess.getConnection();
DBAccess.close(conn);
System.out.println("isOracle:" + isOracle());
System.out.println("isSQLServer:" + isSQLServer());
System.out.println("isMysql:" + isMysql());
System.out.println("数据库连接(关闭)成功");
}
}
PageBean
通用分页
package com.util;
import java.util.HashMap;
import java.util.Map;
import javax.servlet.http.HttpServletRequest;
/**
* 分页工具类
*
*/
public class PageBean {
private int page = 1;// 页码
private int rows = 10;// 页大小
private int total = 0;// 总记录数
private boolean pagination = true;// 是否分页
private String url;
private Map<String, String[]> paramMap = new HashMap<>();
// 定义初始化方法,存入上一次请求的值
public void setRequest(HttpServletRequest req) {
this.setPage(req.getParameter("page"));
this.setRows(req.getParameter("rows"));
this.setPagination(req.getParameter("pagination"));
// getRequestURL获取到浏览器请求的全路径
this.setUrl(req.getRequestURL().toString());
// getParameterMap可以获取到一次url请求所携带的所有参数
this.setParamMap(req.getParameterMap());
}
public void setPagination(String pagination) {
if (StringUtils.isNotBlank(pagination)) {
this.setPagination(!"false".equals(pagination));
}
}
public void setRows(String rows) {
if (StringUtils.isNotBlank(rows))
this.setRows(Integer.valueOf(rows));
}
public void setPage(String page) {
if (StringUtils.isNotBlank(page)) {
this.setPage(Integer.valueOf(page));
}
}
public PageBean() {
super();
}
public String getUrl() {
return url;
}
public void setUrl(String url) {
this.url = url;
}
public Map<String, String[]> getParamMap() {
return paramMap;
}
public void setParamMap(Map<String, String[]> paramMap) {
this.paramMap = paramMap;
}
public int getPage() {
return page;
}
public void setPage(int page) {
this.page = page;
}
public int getRows() {
return rows;
}
public void setRows(int rows) {
this.rows = rows;
}
public int getTotal() {
return total;
}
public void setTotal(int total) {
this.total = total;
}
public void setTotal(String total) {
this.total = Integer.parseInt(total);
}
public boolean isPagination() {
return pagination;
}
public void setPagination(boolean pagination) {
this.pagination = pagination;
}
/**
* 获得起始记录的下标
*
* @return
*/
public int getStartIndex() {
return (this.page - 1) * this.rows;
}
@Override
public String toString() {
return "PageBean [page=" + page + ", rows=" + rows + ", total=" + total + ", pagination=" + pagination + "]";
}
/**
* 获取到总页数
* @return
*/
public int getMaxPage() {
return this.total % this.rows == 0 ?
this.total / this.rows :
(this.total / this.rows) + 1;
}
/**
* 获取下一页页码
* @return
*/
public int getNextPage() {
return this.page < this.getMaxPage() ? this.page+1 : this.page;
}
/**
* 获取上一页页码
* @return
*/
public int getPreviousPage() {
return this.page > 1 ? this.page-1 : this.page;
}
}
StringUtils
进行判空
package com.util;
public class StringUtils {
// 私有的构造方法,保护此类不能在外部实例化
private StringUtils() {
}
/**
* 如果字符串等于null或去空格后等于"",则返回true,否则返回false
*
* @param s
* @return
*/
public static boolean isBlank(String s) {
boolean b = false;
if (null == s || s.trim().equals("")) {
b = true;
}
return b;
}
/**
* 如果字符串不等于null或去空格后不等于"",则返回true,否则返回false
*
* @param
* @return
*/
public static boolean isNotBlank(String s) {
return !isBlank(s);
}
}
MySql连接库名
第二部在dao 创建》》》
StuDao
在实现Istudao的同时并继承BaseDao将< T >改成student
package com.dao;
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.entity.Clas;
import com.entity.Student;
import com.entity.Teacher;
import com.util.BaseDao;
import com.util.CommonUtils;
import com.util.DBAccess;
import com.util.PageBean;
import com.util.StringUtils;
public class StuDao extends BaseDao<Student> implements IStuDao {
Connection con=null;
PreparedStatement ps=null;
ResultSet rs=null;
/**
* 分页查询
* @param pageIndex
* @param pageSize
* @param str
* @param colName
* @return
*/
public List<Student> getAll(int pageIndex,int pageSize,String str){
List<Student> ls=new ArrayList<>();
try {
con=DBAccess.getConnection();
ps=con.prepareStatement("select * from tb_stu "+str+" limit "+(pageIndex-1)*pageSize+","+pageSize+"");
ResultSet rs=ps.executeQuery();
while(rs.next()) {
Student stu=new Student();
stu.setSid(rs.getInt(1));
stu.setSname(rs.getString(2));
stu.setShobby(rs.getString(3));
stu.setTid(rs.getInt(4));
stu.setCid(rs.getInt(5));
ls.add(stu);
}
} catch (Exception e) {
e.printStackTrace();
} finally {
DBAccess.close(con, ps, rs);
}
return ls;
}
public List<Student> List(Student stu,PageBean pageBean) throws InstantiationException, IllegalAccessException, IllegalArgumentException, SQLException {
String sql="select * from tb_stu where 1=1 ";
if(StringUtils.isBlank(stu.getSname())) {
sql+=" and sname like '%"+stu.getSname()+"%'";
}
return super.executeQuery(sql, pageBean,new CallBack<Student>() {
@Override
public java.util.List<Student> forEach(ResultSet rs) throws Exception {
return CommonUtils.toList(rs,Student.class);
}
});
}
/**
* 查出所有教员
* @return
*/
public List<Teacher> getTid(){
List<Teacher> ls=new ArrayList<>();
try {
con=DBAccess.getConnection();
ps=con.prepareStatement("select * from tb_teacher");
rs=ps.executeQuery();
while(rs.next()) {
Teacher t=new Teacher();
t.setTid(rs.getInt(1));
t.setTname(rs.getString(2));
ls.add(t);
}
} catch (Exception e) {
e.printStackTrace();
} finally {
DBAccess.close(con, ps, rs);
}
return ls;
}
/**
* 查出所有班级
* @return
*/
public List<Clas> getCid(){
List<Clas> ls=new ArrayList<>();
try {
con=DBAccess.getConnection();
ps=con.prepareStatement("select * from tb_class");
rs=ps.executeQuery();
while(rs.next()) {
Clas c=new Clas();
c.setCid(rs.getInt(1));
c.setCname(rs.getString(2));
ls.add(c);
}
} catch (Exception e) {
e.printStackTrace();
} finally {
DBAccess.close(con, ps, rs);
}
return ls;
}
@Override
public int add(Student stu) {
int n=0;
try {
con=DBAccess.getConnection();
ps=con.prepareStatement("insert into tb_stu(sname,shobby,tid,cid) values(?,?,?,?)");
ps.setString(1, stu.getSname());
ps.setString(2, stu.getShobby());
ps.setInt(3, stu.getTid());
ps.setInt(4, stu.getCid());
n=ps.executeUpdate();
} catch (Exception e) {
e.printStackTrace();
} finally {
DBAccess.close(con, ps, rs);
}
return n;
}
@Override
public int update(Student stu, int sid) {
int n=0;
try {
con=DBAccess.getConnection();
ps=con.prepareStatement("update tb_stu set sid=?,sname=?,shobby=?,tid=?,cid=? where sid=?");
ps.setInt(1, stu.getSid());
ps.setString(2, stu.getSname());
ps.setString(3, stu.getShobby());
ps.setInt(4, stu.getTid());
ps.setInt(5, stu.getCid());
ps.setInt(6, sid);
n=ps.executeUpdate();
} catch (Exception e) {
e.printStackTrace();
} finally {
DBAccess.close(con, ps, rs);
}
return n;
}
@Override
public int del(int sid) {
int n=0;
try {
con=DBAccess.getConnection();
ps=con.prepareStatement("delete from tb_stu where sid="+sid);
n=ps.executeUpdate();
} catch (Exception e) {
e.printStackTrace();
} finally {
DBAccess.close(con, ps, rs);
}
return n;
}
@Override
public Student getBySid(int sid) {
String sql="select * from tb_stu where sid=?";
List<Student> list = super.executeQuery(sql, null, new CallBack<Student>() {
@Override
public java.util.List<Student> forEach(ResultSet rs) throws SQLException, Exception {
return CommonUtils.toList(rs, Student.class);
}
});
if(null!=list||0!=list.size()) {
return list.get(0);
}
else {
return null;
}
}
@Override
public int getSid() {
// TODO Auto-generated method stub
return 0;
}
/**
* 获取最大行数
* @param str
* @return
*/
public int getRows(String str){
int n = 0;
try {
con=DBAccess.getConnection();
ps=con.prepareStatement("select count(*) from tb_stu "+str+"");
rs = ps.executeQuery();
if(rs.next()){
n = rs.getInt(1);
}
} catch (Exception e) {
e.printStackTrace();
} finally{
DBAccess.close(con, ps, rs);
}
return n;
}
public Clas getC(int cid) {
Clas c=new Clas();
try {
con=DBAccess.getConnection();
ps=con.prepareStatement("select * from tb_class where cid="+cid);
rs=ps.executeQuery();
if(rs.next()) {
c.setCid(rs.getInt(1));
c.setCname(rs.getString(2));
}
} catch (Exception e) {
e.printStackTrace();
} finally {
DBAccess.close(con, ps, rs);
}
return c;
}
public Teacher getT(int tid) {
Teacher t=new Teacher();
try {
con=DBAccess.getConnection();
ps=con.prepareStatement("select * from tb_teacher where tid="+tid);
rs=ps.executeQuery();
if(rs.next()) {
t.setTid(rs.getInt(1));
t.setTname(rs.getString(2));
}
} catch (Exception e) {
e.printStackTrace();
} finally {
DBAccess.close(con, ps, rs);
}
return t;
}
public List<Student> getAllName(){
List<Student> ls=new ArrayList<>();
try {
con=DBAccess.getConnection();
ps=con.prepareStatement("select sname from tb_stu");
ResultSet rs=ps.executeQuery();
while(rs.next()) {
Student stu=new Student();
stu.setSname(rs.getString(1));
ls.add(stu);
}
} catch (Exception e) {
e.printStackTrace();
} finally {
DBAccess.close(con, ps, rs);
}
return ls;
}
}
第三部 framework 创建 工具类,重要的一部分》》》
ModelDriver
模型驱动接口
package com.framework;
/**
* 模型驱动接口
* 是用来处理jsp页面传递过来的参数,
* 将所有的参数自动封装到实体类T中
* @author 86135
*
* @param <T>
*/
public interface ModelDriver<T> {
T getModel();
}
Action
子控制器
package com.framework;
import java.io.IOException;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
/**
* 子控制器
* 专门用来处理业务逻辑
* @author 86135
*
*/
public interface Action {
String execute(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException ;
}
ForwardModel
package com.framework;
public class ForwardModel {
private String name;
private String path;
private boolean redirect;
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getPath() {
return path;
}
public void setPath(String path) {
this.path = path;
}
public boolean isRedirect() {
return redirect;
}
public void setRedirect(boolean redirect) {
this.redirect = redirect;
}
}
ActionModel
package com.framework;
import java.util.HashMap;
import java.util.Map;
public class ActionModel {
private String path;
private String type;
private Map<String, ForwardModel> fMap=new HashMap<>();
public String getPath() {
return path;
}
public void setPath(String path) {
this.path = path;
}
public String getType() {
return type;
}
public void setType(String type) {
this.type = type;
}
public void push(ForwardModel forwardmodel) {
fMap.put(forwardmodel.getName(),forwardmodel);
}
public ForwardModel pop(String name) {
return fMap.get(name);
}
}
ActionSupport
增加版的子控制器
package com.framework;
import java.io.IOException;
import java.lang.reflect.InvocationTargetException;
import java.lang.reflect.Method;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
/**
* 之前的Action只能处理一个实体类的业务
*
* 现在这个是增加版的子控制器
* 凡是这个实体类的操作,对应方法都可以写在当前增强版的子控制器来完成
* @author 86135
*
*/
public class ActionSupport implements Action {
@Override
public final String execute(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
String methodName = req.getParameter("methodName");
String code=null;
try {
//获取到类对象,再获取方法
Method method = this.getClass().getDeclaredMethod(methodName, HttpServletRequest.class,HttpServletResponse.class);
method.setAccessible(true);
//具体调用了你自己所写的子控制器的方法来处理浏览器请求
code=(String)method.invoke(this, req,resp);
} catch (NoSuchMethodException | SecurityException e) {
e.printStackTrace();
} catch (IllegalAccessException e) {
e.printStackTrace();
} catch (IllegalArgumentException e) {
e.printStackTrace();
} catch (InvocationTargetException e) {
e.printStackTrace();
}
return code;
}
}
ConfigModel
package com.framework;
import java.util.HashMap;
import java.util.Map;
public class ConfigModel {
private Map<String, ActionModel> acmap=new HashMap<>();
public void push(ActionModel actionmodel) {
acmap.put(actionmodel.getPath(), actionmodel);
}
public ActionModel pop(String path) {
return acmap.get(path);
}
}
ConfigModelFatory
工具类
package com.framework;
import java.io.InputStream;
import java.util.List;
import org.dom4j.Document;
import org.dom4j.DocumentException;
import org.dom4j.Element;
import org.dom4j.io.SAXReader;import com.sun.corba.se.spi.orbutil.fsm.Action;
public class ConfigModelFatory {
public static ConfigModel build() throws Exception {
return build("config.xml");
}
public static ConfigModel build(String string) throws Exception {
ConfigModel configmodel=new ConfigModel();
InputStream in = ConfigModelFatory.class.getResourceAsStream("config.xml");
SAXReader reader=new SAXReader();
Document doc = reader.read(in);
ActionModel actionmodel=null;
ForwardModel forwardmodel=null;
List<Element> actionEles = doc.selectNodes("/config/action");
for (Element actionEle : actionEles) {
actionmodel=new ActionModel();
//接下来需要往actionModel中填充内容
actionmodel.setPath(actionEle.attributeValue("path"));
actionmodel.setType(actionEle.attributeValue("type"));
//拿到foward
List<Element> forword = actionEle.selectNodes("forward");
for (Element forwardEle : forword) {
forwardmodel=new ForwardModel();
//往forwardModel中填充内容
forwardmodel.setName(forwardEle.attributeValue("name"));
forwardmodel.setPath(forwardEle.attributeValue("path"));
forwardmodel.setRedirect(!"false".equals(forwardEle.attributeValue("redirect")));
actionmodel.push(forwardmodel);
}
configmodel.push(actionmodel);//调用存值方法
}
return configmodel;
}
}
DispatcherServlet
package com.framework;
import java.io.IOException;
import java.lang.reflect.Field;
import java.lang.reflect.InvocationTargetException;
import java.util.HashMap;
import java.util.Map;
import java.util.Map.Entry;
import java.util.Set;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.jsp.PageContext;
import org.apache.commons.beanutils.BeanUtils;
/**
* 中央控制器
* @author 86135
*
*/
public class DispatcherServlet extends HttpServlet {
private static final long serialVersionUID = -7094025920085803724L;
private ConfigModel configModel = null;
//初始化方法
public void init() {
try {
//将原来的读取框架的默认配置文件转变成读取可配置路径的配置文件
String xmlPath = this.getInitParameter("xmlPath");
if(xmlPath == null || "".equals(xmlPath)) {
configModel = ConfigModelFatory.build();
}
else {
configModel = ConfigModelFatory.build(xmlPath);
}
} catch (Exception e) {
e.printStackTrace();
}
}
@Override
protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
doPost(req, resp);
}
@Override
protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
init();//初始化
String url = req.getRequestURI();//Mvc/xxx.action
url = url.substring(url.lastIndexOf("/"), url.lastIndexOf("."));
//根据路径获取action的模型
ActionModel actionModel = configModel.pop(url);
if(actionModel==null) {
throw new RuntimeException("你没有配置对应的子控制器Action!!!");
}
try {
//原来子控制器的来源是map集合,这样的话子控制器被写死再map容器中,代码不够灵活
//现在将子控制器配置方式存放再config.xml中,未来可以通过改变config.xml中的内容
//随意给中央控制器添加子控制器
Action action = (Action)Class.forName(actionModel.getType()).newInstance();
// 调用模型驱动接口,获取所需要操作的实体类,然后将jsp传递过来的参数,封装到实体类中
if(action instanceof ModelDriver) {
ModelDriver modelDriver=(ModelDriver)action;
Object model = modelDriver.getModel();
//封装属性
BeanUtils.populate(model, req.getParameterMap());
}
// 每个子控制器,都需要对结果进行对应的处理,要么重定向,要么转发,代码重复量较大
// 针对于这一现象,将其交给配置文件来处理
// 调用了增强版的子控制器来处理业务逻辑
String code = action.execute(req, resp);
ForwardModel forwardModel = actionModel.pop(code);
if(forwardModel ==null) {
throw new RuntimeException("你没有配置对应的子控制器Action的处理方式Forward!!!");
}
String jspPath = forwardModel.getPath();
if(forwardModel.isRedirect()) {
resp.sendRedirect(req.getContextPath()+jspPath);//拼接上路径,相当于绝对路径
}
else {
req.getRequestDispatcher(jspPath).forward(req, resp);
}
} catch (InstantiationException | IllegalAccessException | ClassNotFoundException e) {
e.printStackTrace();
} catch (SecurityException e) {
e.printStackTrace();
} catch (InvocationTargetException e) {
e.printStackTrace();
}
}
}
XML配置
web.xml
<filter>
<filter-name>encodingFiter</filter-name>
<filter-class>util.EncodingFiter</filter-class>
</filter>
<filter-mapping>
<filter-name>encodingFiter</filter-name>
<url-pattern>/*</url-pattern>
</filter-mapping>
<servlet>
<servlet-name>dispatherServlet</servlet-name>
<servlet-class>com.framework.DispatherServlet </servlet-class>
<init-param>
<param-name>xmlPath</param-name>
<param-value>/mvc.xml</param-value>
</init-param>
</servlet>
<servlet-mapping>
<servlet-name>dispatherServlet</servlet-name>
<url-pattern>*.action</url-pattern>
</servlet-mapping>
mvc.xml
<config>
<action path="/StudentAction" type="com.web.StudentAction">
<forward name="index" path="/index.jsp" redirect="false" />
<forward name="add" path="/StudentAction.action?method=getAll" redirect="true" />
<forward name="update" path="/update.jsp" redirect="false" />
</action>
</config>
jsp页面
add.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<!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>增加学生</title>
<link rel="stylesheet" type="text/css" href="css/bootstrap.min.css"/>
<script type="text/javascript" src="js/jquery-3.3.1.js"></script>
<script type="text/javascript" src="js/bootstrap.min.js"></script>
</head>
<body>
<h1 align="center">增加学生</h1>
<form action="add.do" method="post">
<div align="center">
姓名:<input type="text" name="sname" /><br/><br/>
教员:<select name="tid">
<option value="null">请选择教员</option>
<option value="1">晓哥</option>
<option value="2">杰哥</option>
<option value="3">亮哥</option>
</select><br/><br/>
班级:<select name="cid">
<option value="null">请选择班级</option>
<option value="1">t224</option>
<option value="2">t225</option>
<option value="3">t226</option>
<option value="4">t227</option>
<option value="5">t228</option>
<option value="6">t229</option>
</select><br/><br/>
<div class="form-group">
学生爱好:
<label class="checkbox-inline">
<input type="checkbox" name="shobby" value="篮球" />篮球
</label>
<label class="checkbox-inline">
<input type="checkbox" name="shobby" value="rap" />rap
</label>
<label class="checkbox-inline">
<input type="checkbox" name="shobby" value="唱歌" />唱歌
</label>
<label class="checkbox-inline">
<input type="checkbox" name="shobby" value="跳舞" />跳舞
</label>
</div>
<input type="submit" value="增加" class="btn btn-default" />
<input type="reset" value="清空" class="btn btn-default" />
<input type="button" onclick="location.href='index.jsp'" value="取消" class="btn btn-default" />
</div>
</form>
</body>
</html>
index.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<!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>主页面</title>
<link rel="stylesheet" type="text/css" href="css/bootstrap.min.css"/>
<script type="text/javascript" src="js/jquery-3.3.1.js"></script>
<script type="text/javascript" src="js/bootstrap.min.js"></script>
<script type="text/javascript">
function myf(){
var go=$("#go").val();
location.href="index.do?pid="+go+"";
}
</script>
</head>
<body>
<div align="center">
<form action="index.do" method="post">
姓名:<input type="text" name="name" />
教员:<select name="tid">
<option value="k">请选择教员</option>
<c:forEach items="${lst }" var="t">
<option value="${t.tid}">${t.tname}</option>
</c:forEach>
</select>
班级:<select name="cid">
<option value="k">请选择班级</option>
<c:forEach items="${lsc}" var="c">
<option value="${c.cid}">${c.cname}</option>
</c:forEach>
</select>
<div class="form-group">
学生爱好:
<label class="checkbox-inline">
<input type="checkbox" name="shobby" value="篮球" />篮球
</label>
<label class="checkbox-inline">
<input type="checkbox" name="shobby" value="rap" />rap
</label>
<label class="checkbox-inline">
<input type="checkbox" name="shobby" value="唱歌" />唱歌
</label>
<label class="checkbox-inline">
<input type="checkbox" name="shobby" value="跳舞" />跳舞
</label>
<input type="submit" value="查询" class="btn btn-default" />
<a style="float: right;" href="add.jsp" class="btn btn-default">增加</a>
</div>
<table border="1px" class="table table-hover">
<tr align="center">
<td>学生编号</td>
<td>学生姓名</td>
<td>学生的教员</td>
<td>学生所在班级</td>
<td>学生爱好</td>
<td>操作</td>
</tr>
<c:if test="${empty myls }" >
<jsp:forward page="index.do"></jsp:forward>
</c:if>
<c:forEach items="${myls }" var="ls">
<tr align="center">
<td>${ls.sid}</td>
<td>${ls.sname}</td>
<td>${ls.t.tname}</td>
<td>${ls.c.cname}</td>
<td>${ls.shobby}</td>
<td><a onclick="return confirm('你确定要删除吗')" href="del.do?sid=${ls.sid}" class="btn btn-default">删除</a> <a href="pre.do?sid=${ls.sid}" class="btn btn-default">修改</a></td>
</tr>
</c:forEach>
</table>
</form>
</div>
<ul class="pager">
<li><a href="index.do?pid=1">首页(1)</a></li>
<li><a href="index.do?pid=${pageIndex>1?pageIndex-1:1}">上一页</a></li>
<li><input width="20" id="go" type="text" name="pid" /><a href="javascript:myf()">GO</a></li>
<li><a href="index.do?pid=${pageIndex<max?pageIndex+1:max}">下一页</a></li>
<li><a href="index.do?pid=${max}">末页(${max})</a></li>
</ul>
</body>
</html>
update.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<!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>修改学生</title>
<link rel="stylesheet" type="text/css" href="css/bootstrap.min.css"/>
<script type="text/javascript" src="js/jquery-3.3.1.js"></script>
<script type="text/javascript" src="js/bootstrap.min.js"></script>
<script type="text/javascript">
$(function(){
var checked='${s.shobby}';
var ck=checked.split(",");
$.each(ck,function(n,val){
$(":checkbox[name='shobby'][value="+val+"]").prop("checked",true);
});
})
function myf(){
}
</script>
</head>
<body>
<h1 align="center">修改学生</h1>
<form action="update.do" method="post">
<div align="center">
学号:<input type="text" name="sid" value="${s.sid}" /><br/><br/>
姓名:<input type="text" name="sname" value="${s.sname}" /><br/><br/>
教员:<select name="tid">
<c:forEach items="${lst }" var="t">
<c:if test="${s.t.tid==t.tid}">
<option value="${t.tid}">${t.tname}</option>
</c:if>
</c:forEach>
<c:forEach items="${lst }" var="t">
<c:if test="${s.t.tid!=t.tid}">
<option value="${t.tid}">${t.tname}</option>
</c:if>
</c:forEach>
</select><br/><br/>
班级:<select name="cid">
<c:forEach items="${lsc}" var="c">
<c:if test="${s.c.cid==c.cid}">
<option selected="selected" value="${c.cid}">${c.cname}</option>
</c:if>
</c:forEach>
<c:forEach items="${lsc }" var="c">
<c:if test="${s.c.cid!=c.cid}">
<option value="${c.cid}">${c.cname}</option>
</c:if>
</c:forEach>
</select><br/><br/>
<div class="form-group">
学生爱好:
<label class="checkbox-inline">
<input type="checkbox" name="shobby" value="1" />篮球
</label>
<label class="checkbox-inline">
<input type="checkbox" name="shobby" value="2" />rap
</label>
<label class="checkbox-inline">
<input type="checkbox" name="shobby" value="3" />唱歌
</label>
<label class="checkbox-inline">
<input type="checkbox" name="shobby" value="4" />跳舞
</label>
</div>
<input type="hidden" value="${s.sid}" name="sid1" />
<input type="submit" value="修改" class="btn btn-default" />
<a class="btn btn-default" href="index.jsp" >取消</a>
</div>
</form>
</body>
</html>