J2EE_mvc框架——增删改查

思维导图 ：

用到的jar包 ：

 

代码：

 dao方法 ：

package com.zking.dao;

import java.util.List;

import com.zking.entity.Blog;
import com.zking.util.BaseDao;
import com.zking.util.PageBean;
import com.zking.util.StringUtils;

public class BlogDao extends BaseDao<Blog>{
//		查询
		public List<Blog> list(Blog blog,PageBean pageBean) throws Exception{
			String sql = "select * from t_mysql_beauty where 1 =1 ";
			String name=blog.getName();
			int id =blog.getId();
			if(StringUtils.isNotBlank(name)) {
				sql+= " and name like '%" + name + "%'";
			}
			if(id !=0) {
				sql+=" and id ="+id;
			}
			return super.executeQuery(sql, Blog.class, pageBean);
		}
		
//		增加
		public void add(Blog blog) throws Exception {
			String sql="insert into t_mysql_beauty(id,name,sex)values(?,?,?)";
			super.executeUpdate(sql, blog, new String[] {"id","name","sex"});
		}	
		
//		删除	
		public void delete(Blog blog) throws Exception {
			String sql="delete from  t_mysql_beauty where id=?";
			super.executeUpdate(sql, blog, new String[] {"id"});
		}
		
//		修改
		public void exit(Blog blog) throws Exception {
			String sql="update t_mysql_beauty set name=?,sex=? where id=?";
			super.executeUpdate(sql, blog, new String[] {"name","sex","id"});
		}
		
}

实体 ：

package com.zking.entity;

public class Blog {
	private int id;
	private String name;
	private String sex;
	public int getId() {
		return id;
	}
	public void setId(int id) {
		this.id = id;
	}
	public String getName() {
		return name;
	}
	public void setName(String name) {
		this.name = name;
	}
	public String getSex() {
		return sex;
	}
	public void setSex(String sex) {
		this.sex = sex;
	}

	
	
	
	

}

tag

package com.zking.tag;

import java.io.IOException;

import java.util.Map;
import java.util.Map.Entry;
import java.util.Set;

import javax.servlet.jsp.JspException;
import javax.servlet.jsp.JspWriter;
import javax.servlet.jsp.tagext.BodyTagSupport;

import com.zking.util.PageBean;

public class PageTag extends BodyTagSupport{
	private PageBean pageBean;// 包含了所有分页相关的元素
	
	public PageBean getPageBean() {
		return pageBean;
	}

	public void setPageBean(PageBean pageBean) {
		this.pageBean = pageBean;