思维导图 :
用到的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; } @Override public int doStartTag() throws JspException { // 没有标签体,要输出内容 JspWriter out = pageContext.getOut(); try { out.print(toHTML()); } catch (IOException