favoritedaoimpl.java

一个简单的标签搜索.通过标签可以模糊查询数据.

package com.fxe.dcl1.dao.impl;

import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import com.fxe.dcl1.dao.FavoriteDAO;
import com.fxe.dcl1.util.DBUtil;
import com.fxe.dlc1.entity.Fav;

public class FavoriteDAOImpl extends DBUtil implements FavoriteDAO {

	public List serch(String type) {
		// TODO Auto-generated method stub
		List ret=new ArrayList();
		String sql="select * from Favorite where 1=1";
		if("-1".equals(type))//全部
		{
 			
		}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+"%'";
		}
	    super.openConn();
	    try {
			stmt=con.createStatement();
			rs=stmt.executeQuery(sql);
			while(rs.next())
			{
				Fav fav=new Fav();
				fav.setId(rs.getLong("f_id"));
				fav.setLabel(rs.getString("f_label"));
				fav.setUrl(rs.getString("f_url"));
				fav.setTags(rs.getString("f_tags"));
				fav.setDesc(rs.getString("f_desc"));
				ret.add(fav);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			super.closeAll();
		}
		return ret;
	}

	public void add(Fav item) {
		// TODO Auto-generated method stub
		super.openConn();
		String sql="insert into Favorite(f_label,f_url,f_tags,f_desc)"+
		" values(?,?,?,?);select @@identity";
		try {
			pstmt=con.prepareStatement(sql);
			//设置参数值
			pstmt.setString(1,item.getLabel());
			pstmt.setString(2,item.getUrl());
			pstmt.setString(3,item.getTags());
			pstmt.setString(4,item.getDesc());
			rs=pstmt.executeQuery();
			if(rs.next())
			{
				item.setId(rs.getLong(1));
			}
			
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			super.closeAll();
		}
		
	}


}