hfdao.java

来自「java带进度条上传尽量不要让站长把时间都花费在为您修正说明上」· Java 代码 · 共 98 行

package com.jmwl.dao;

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

import com.jmwl.vo.HFVO;
import com.jmwl.common.DateTime;
import com.jmwl.dto.HFDTO;

public class HFDAO extends BasicDAO
{
	/**
	 * 插入一条留言
	 * @param info
	 * @return
	 */
	public boolean addhf(HFDTO info)
	{
		boolean b=false;
		DateTime time=new DateTime();
		String sql="insert into logreply (user_id,uid,context,pub_time) values (?,?,?,?)";
		try {
			PreparedStatement ps=this.getConn().prepareStatement(sql);
			ps.setInt(1, info.getUser_id());
			ps.setInt(2, info.getUid());
			ps.setString(3, info.getContext());
			ps.setString(4,time.getCurTime());
			int i=ps.executeUpdate();
			if(i!=0)
			{
				b=true;
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return b;
	}
/**
 * 得到留言总数
 * @param id
 * @return
 */
	public int getcounthf(int id)
	{
		String sql="select count(*) from logreply where uid=?";
		int n=0;
		try {
			PreparedStatement ps=this.getConn().prepareStatement(sql);
			ps.setInt(1, id);
			ResultSet rs=ps.executeQuery();
			while(rs.next())
			{
				n=rs.getInt(1);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return n;
	}
	/**
	 * 得到指定页面的留言
	 * @param id
	 * @param currpage
	 * @return
	 */
	public List<HFVO> gethf(int id,int currpage)
	{
		 List<HFVO> list=new ArrayList();
		 String sql="select * from logreply where uid=? order by pub_time desc limit "+((currpage-1)*8)+",8";
		 try {
			PreparedStatement ps=this.getConn().prepareStatement(sql);
			ps.setInt(1, id);
			ResultSet rs=ps.executeQuery();
			while(rs.next())
			{
				HFVO info=new HFVO();
				info.setId(rs.getInt(1));
				info.setUser_id(rs.getInt(2));
				info.setUid(rs.getInt(3));
				info.setContext(rs.getString(4));
				info.setPub_time(rs.getTimestamp(5));
				list.add(info);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		 return list;
	}
	
}