flymis/src/com/fly/dao/NewsDAO.java

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

package com.fly.dao;

import java.sql.Connection;
import java.sql.SQLException;
import java.sql.ResultSet;
import java.sql.PreparedStatement;
import java.util.ArrayList;
import java.util.List;
import com.fly.db.DBConn;
import com.fly.vo.NewsVO;


public class NewsDAO {

	// 定义连接对象
	private Connection conn = null;

	// 定义预编译对象
	private PreparedStatement pstm = null;

	// 定义结果集对象
	private ResultSet rs = null;

	public void addNews(NewsVO news) {

		try {
			conn = DBConn.getConnection();
			pstm = conn.prepareStatement("insert into tb_news values(?,?,?,?)");
			pstm.setString(1, news.getNewsTitle());
			pstm.setString(2, news.getNewsContent());
			pstm.setString(3, news.getNewsTime());
			pstm.setString(4, news.getUsername());
			pstm.executeUpdate();
			System.out.println("添加成功");
		} catch (SQLException e) {
			e.printStackTrace();
		} finally {
			DBConn.closePreparedStatement(pstm);
			DBConn.closeConnection(conn);
		}
	}

	public List newsList() {

		List<NewsVO> list = new ArrayList<NewsVO>();
		NewsVO news = null;
		try {

			conn = DBConn.getConnection();
			pstm = conn.prepareStatement("select * from tb_news order by new_time desc");
			rs = pstm.executeQuery();
			while (rs.next()) {
				news = new NewsVO();
				
				news.setNewsTitle(rs.getString(1));
				news.setNewsContent(rs.getString(2));
				news.setNewsTime(rs.getString(3));
				news.setUsername(rs.getString(4));
				news.setId(rs.getShort(5));
				list.add(news);