flymis/src/com/fly/dao/AffDAO.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.AffVO;



public class AffDAO {

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

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

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

	public void addAff(AffVO aff) {

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

	public List affList() {

		List<AffVO> list = new ArrayList<AffVO>();
		AffVO aff = null;
		try {

			conn = DBConn.getConnection();
			pstm = conn.prepareStatement("select * from tb_aff order by aff_time desc");
			rs = pstm.executeQuery();
			while (rs.next()) {
				aff = new AffVO();
				
				aff.setAffTitle(rs.getString(1));
				aff.setAffContent(rs.getString(2));
				aff.setAffTime(rs.getString(3));
				aff.setUsername(rs.getString(4));
				aff.setId(rs.getInt(5));