package cn.edu.qust.news.dao;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.List;

import cn.edu.qust.news.dao.TypeDao;
import cn.edu.qust.news.domain.Type;
import cn.edu.qust.news.utils.JdbcUtil;

public class TypeDao {

	public TypeDao() {
		// TODO Auto-generated constructor stub
	}

	
	public List<Type> findType() {
		Connection conn=null;
		PreparedStatement stmt = null;
		ResultSet rs = null;
		List<Type> lTypes=new ArrayList<Type>();
		try {
			conn = JdbcUtil.getConnection();
			stmt = conn
					.prepareStatement("select f_typename from t_type order by f_typeid DESC");
			rs = stmt.executeQuery();
			while (rs.next()) {
				Type type=new Type();
				type.setTypeName(rs.getString("f_typename"));
				lTypes.add(type);
			} 
			return lTypes;
		} catch (Exception e) {
			throw new RuntimeException(e);
		} finally {
			JdbcUtil.release(rs, stmt, conn);
		}
	}

}