package com.dao;

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

import com.entity.Notice;
import com.util.DBUtil;

public class NoticeDao {
	/**
	 * 添加
	 * @param no
	 * @return
	 */
	public static int add(Notice no){
		String sql="insert into notice(n_title,n_desc) values(?,?)";
		Object obj[]={no.getN_title(),no.getN_desc()};
		int k=DBUtil.Update(sql, obj);
		return k;
	}
	/**
	 * 修改
	 * @param no
	 * @return
	 */
	public static int update(Notice no){
		String sql="update notice set n_title=?,n_desc=? where n_id=?";
		Object obj[]={no.getN_title(),no.getN_desc(),no.getN_id()};
		int k=DBUtil.Update(sql, obj);
		return k;
	}
	/**
	 * 删除
	 * @param no
	 * @return
	 */
	public static int delete(String n_id){
		String sql="delete from notice where n_id=?";
		Object obj[]={n_id};
		int k=DBUtil.Update(sql, obj);
		return k;
	}
	/**
	 * 查询所有
	 * @param no
	 * @return
	 */
	public static List<Notice> queryAll(Integer pageStart,Integer pageSize){
		String sql="select * from notice limit ?,?";
		Object obj[]={pageStart,pageSize};
		ResultSet res=DBUtil.query(sql, obj);
		List<Notice> list=new ArrayList<Notice>();
		try {
			while (res.next()) {
				Notice no=new Notice(res.getInt(1), res.getString(2), res.getString(3));
				list.add(no);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			DBUtil.close();
		}
		return list;
	}
	/**
	 * 查询所有数据条数
	 * @param 
	 * @return count
	 */
	public static int queryCount(){
		String sql="select count(*) from notice";
		Object obj[]={};
		ResultSet res=DBUtil.query(sql, obj);
		int count=0;
		try {
			if (res.next()) {
				count=res.getInt(1);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			DBUtil.close();
		}
		return count;
	}
	/**
	 * 查询公告信息
	 * @param no
	 * @return
	 */
	public static List<Notice> query(String n_id){
		String sql="select * from notice where n_id=?";
		Object obj[]={n_id};
		ResultSet res=DBUtil.query(sql, obj);
		List<Notice> list=new ArrayList<Notice>();
		try {
			while (res.next()) {
				Notice no=new Notice(res.getInt(1), res.getString(2), res.getString(3));
				list.add(no);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			DBUtil.close();
		}
		return list;
	}
}