headlinedao.java

java web网络编程示例,原代码资源

package edu.liusong.dao;

import java.sql.ResultSet;
import java.sql.SQLException;

import edu.liusong.common.DBConnect;
import edu.liusong.mo.HeadLine;

public class HeadLineDAO {
	private DBConnect conn;
	private ResultSet rs;
	public void save(HeadLine headLine){
		try {
			conn=new DBConnect();
			String sql="insert into headline values(?,?,?,?,?)";
			String[] values={headLine.getTitle(),headLine.getContent(),headLine.getImg(),headLine.getAtime().toString(),headLine.getIntro()};
			conn.executeUpdate(sql, values);
		} catch (Exception e) {
			e.printStackTrace();
		}finally{
			if(conn!=null)
				try {
					conn.close();
				} catch (SQLException e) {
					e.printStackTrace();
				}
		}
	}

	public HeadLine getHeadLine(){
		HeadLine headLine=null;
		try {
			conn=new DBConnect();
			String sql="select * from headline order by atime desc limit 0,1";
			rs=conn.executeQuery(sql, null);
			if(rs.next()){
				headLine=new HeadLine();
				headLine.setTitle(rs.getString(1));
				headLine.setContent(rs.getString(2));
				headLine.setImg(rs.getString(3));
				headLine.setAtime(rs.getTimestamp(4));
				headLine.setIntro(rs.getString(5));
			}else{
				headLine=new HeadLine();
				headLine.setTitle("暂时没有头条");
				headLine.setContent("暂时没有头条");
				headLine.setImg("images/Sorry.jpg");
				headLine.setIntro("111");
			}
		} catch (Exception e) {
			e.printStackTrace();
		}finally{
			if(conn!=null)
				try {
					conn.close();
				} catch (SQLException e) {
					e.printStackTrace();
				}
		}
		return headLine;		
	}
}