struts实现的收藏夹

package dao; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.util.ArrayList; import java.util.List; import dao.impl.FavDaoImpl; import entity.favorite; import entity.tag; public class FavDao extends BaseDao implements FavDaoImpl{ Connection conn=null; PreparedStatement pstmt=null; ResultSet rs=null; public void addItem(favorite fav) { String sql="insert into Favorite values(?,?,?,?)"; try { conn=this.getConn(); pstmt=conn.prepareStatement(sql); pstmt.setString(1,fav.getLabel()); pstmt.setString(2,fav.getUrl()); pstmt.setString(3,fav.getTags()); pstmt.setString(4,fav.getDesc()); pstmt.executeUpdate(); } catch (Exception e) { e.printStackTrace(); }finally { this.closeAll(conn, pstmt,null); } } //查询全部的tag标签 public List serachAllTag() { List taglist=new ArrayList(); String sql="select * from tag"; try { conn=this.getConn(); pstmt=conn.prepareStatement(sql); rs=pstmt.executeQuery(); while(rs.next()) { tag tag=new tag(); tag.setId(rs.getInt(1)); tag.setTag(rs.getString(2)); tag.setCount(rs.getInt(3)); taglist.add(tag); } } catch (Exception e) { e.printStackTrace(); }finally { this.closeAll(conn, pstmt, rs); } return taglist; } //根据tag名查找Tag public tag getTagByname(String tagName) { tag tag=null; String sql="select * from tag where t_name='"+tagName+"'"; try { conn=this.getConn(); pstmt=conn.prepareStatement(sql); rs=pstmt.executeQuery(); if(rs.next()) { tag=new tag(); tag.setId(rs.getInt(1)); tag.setTag(rs.getString(2)); tag.setCount(rs.getInt(3)); } } catch (Exception e) { e.printStackTrace(); } return tag; } //添加tag public void addTag(tag tag) { String sql="insert into tag values(?,?)"; try { conn=this.getConn(); pstmt=conn.prepareStatement(sql); pstmt.setString(1,tag.getTag()); pstmt.setInt(2,tag.getCount()); pstmt.executeUpdate(); } catch (Exception e) { e.printStackTrace(); }finally { this.closeAll(conn, pstmt, rs); } } public void update(tag tag) { String sql="update tag set t_count=? where t_id=?"; try { conn=this.getConn(); pstmt=conn.prepareStatement(sql); pstmt.setInt(1, tag.getCount()); pstmt.setInt(2, tag.getId()); pstmt.executeUpdate(); } catch (Exception e) { e.printStackTrace(); }finally { this.closeAll(conn, pstmt, rs); } } public List searchFavByTag(String type) { List list=new ArrayList(); String sql="select * from Favorite where 1=1"; if("-1".equals(type)) { sql+=""; }else if("0".equals(type)) { sql+=" and f_tags is null or f_tags=''"; }else if(type!=null&&!"".equals(type)) { sql+=" and f_tags like '%"+type+"%'"; } try { conn=this.getConn(); pstmt=conn.prepareStatement(sql); rs=pstmt.executeQuery(); while(rs.next()) { favorite fav=new favorite(); fav.setId(rs.getInt(1)); fav.setLabel(rs.getString(2)); fav.setUrl(rs.getString(3)); fav.setTags(rs.getString(4)); fav.setDesc(rs.getString(5)); list.add(fav); } } catch (Exception e) { e.printStackTrace(); }finally { this.closeAll(conn, pstmt, rs); } return list; } }