bulletindao.java

java开发购物车+网上书城

package com.xaccp.aj3q8073.dao;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.List;

import com.xaccp.aj3q8073.db.DBManager;
import com.xaccp.aj3q8073.db.RowMapper;
import com.xaccp.aj3q8073.vo.NewsInfoVo;

public class BulletinDao {
	DBManager db=new DBManager();
	
	/**
	 * 查询所有的公告信息
	 * @return
	 */
	public List findAllBulletin(){
		String sql="select * from newsInfo";
		List list= db.queryForList(sql, null, new BulletinMapper());
		return list;
	}
	/**
	 * 查询所有的公告信息
	 * @return
	 */
	public List findTopBulletin(){
		String sql="select * from newsInfo where newsHide=? order by newsId desc limit ?,?";
		Object[] obj=new Object[]{1,0,2};
		List list= db.queryForList(sql, obj, new BulletinMapper());
		return list;
	}
	/**
	 * 根据第查询公告信息
	 * @param newsId
	 * @return
	 */
	public Object findTopBull(int newsId){
		String sql="select * from newsInfo where newsId=? and newsHide=?";
		Object[] obj=new Object[]{newsId,1};
		Object jt= db.queryForObject(sql, obj, new BulletinMapper());
		return jt;
	}
	/**
	 * 添加公告
	 * @param vo
	 * @return
	 */
	public int saveBulletin(NewsInfoVo vo){
		String sql="insert into newsInfo values(default,?,?,?,sysdate())";
		Object[] obj=new Object[]{vo.getNewsTitle(),vo.getNewsContent(),0};
		int i= db.executeUpdate(sql, obj);
		return i;
	}
	
	/**
	 * 根据Id查找要修改的公告信息
	 * @param id
	 * @return
	 */
	public Object findBulletinById(int id){
		String sql="select * from newsInfo where newsId=?";
		Object[] obj=new Object[]{id};
		Object jt=db.queryForObject(sql, obj, new BulletinMapper());
		return jt;
	}
	
	/**
	 * 根据Id修改公告信息
	 * @param vo
	 * @return
	 */
	public int editBulletin(NewsInfoVo vo){
		String sql="update newsInfo set newsTitle=?,newsContent=?,newsHide=?,newsTime=sysdate() where newsId=?";
		Object[] obj=new Object[]{vo.getNewsTitle(),vo.getNewsContent(),vo.getNewsHide(),vo.getNewsId()};
		int i=db.executeUpdate(sql, obj);
		return i;
	}
	/**
	 * 根据id删除公告信息
	 * @param id
	 * @return
	 */
	public int delBulletin(int id){
		String sql="delete from newsInfo where newsId=?";
		Object[] obj=new Object[]{id};
		int i=db.executeUpdate(sql, obj);
		return i;
	}
	
	/**
	 * 根据id修改是否发布
	 * @param id
	 * @return
	 */
	public int editType(int id){
		String sql="update newsInfo set newsHide=? where newsId=?";
		Object[] obj=new Object[]{1,id};
		int i=db.executeUpdate(sql, obj);
		return i;
	}
	/**
	 * 根据id修改是否发布
	 * @param id
	 * @return
	 */
	public int editTypeById(int id){
		String sql="update newsInfo set newsHide=? where newsId=?";
		Object[] obj=new Object[]{0,id};
		int i=db.executeUpdate(sql, obj);
		return i;
	}
	
	class BulletinMapper implements RowMapper{

		public Object rowMapper(ResultSet rt) throws SQLException {
			SimpleDateFormat sdf=new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
			NewsInfoVo vo=new NewsInfoVo();
			vo.setNewsId(rt.getInt("newsId"));
			vo.setNewsTitle(rt.getString("newsTitle"));
			vo.setNewsContent(rt.getString("newsContent"));
			vo.setNewsHide(rt.getInt("newsHide"));
			try {
				vo.setNewsTime(sdf.parse(rt.getString("newsTime")));
			} catch (ParseException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
			return vo;
		}
		
	}
}