tagdaoimpl.java

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

package com.fxe.dcl1.dao.impl;

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

import com.fxe.dcl1.dao.TagDAO;
import com.fxe.dcl1.util.DBUtil;
import com.fxe.dlc1.entity.Tag;

public class TagDAOImpl extends DBUtil implements TagDAO {

	/**
	 * 获得所以标签
	 */
	public List getAllTags() {
		// TODO Auto-generated method stub
		List tags=new ArrayList();
		super.openConn();
		String sql="select * from tag";
		try {
			stmt=con.createStatement();
			rs=stmt.executeQuery(sql);
			while(rs.next())
			{
				Tag tag=new Tag();
				tag.setId(rs.getLong("t_id"));
				tag.setName(rs.getString("t_name"));
				tag.setCount(rs.getLong("t_count"));
				tags.add(tag);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			super.closeAll();
		}
		
		return tags;
	}

	public void add(Tag tag) {
		// TODO Auto-generated method stub
		super.openConn();
		String sql="insert into tag values(?,?)";
		try {
			pstmt=con.prepareStatement(sql);
			pstmt.setString(1,tag.getName());
			pstmt.setLong(2,tag.getCount());
			pstmt.execute();
		} catch (SQLException e) {
			System.out.println("添加tag异常:");
			e.printStackTrace();
		}finally{
			super.closeAll();
		}
	}

	public void update(Tag tag) {
		// TODO Auto-generated method stub
		super.openConn();
		String sql="update tag set t_count="+tag.getCount()+"where t_id="+tag.getId()+"";
		try {
			stmt=con.createStatement();
			stmt.executeUpdate(sql);
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			System.out.println("更新tag异常:");
			e.printStackTrace();
		}finally{
			super.closeAll();
		}
	}

	public Tag serch(String tagName) {
		// TODO Auto-generated method stub
		Tag tag=null;
		super.openConn();
		String sql="select * from tag where t_name='"+tagName+"'";
		try {
			stmt=con.createStatement();
			rs=stmt.executeQuery(sql);
			if(rs.next())
			{
				tag=new Tag();
				tag.setId(rs.getLong("t_id"));
				tag.setName(rs.getString("t_name"));
				tag.setCount(rs.getLong("t_count"));
			}
			
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			System.out.println("查找tag异常:");
			e.printStackTrace();
		}finally{
			super.closeAll();
		}
		return tag;
	}

}