filedao.java~14~

《struts应用开发完全手册》中的源代码及安装指导

package com.dao;

import java.util.*;
import com.actionForm.FileActionForm;
import java.sql.*;

public class FileDao {
    private JDBConnection connection = new JDBConnection();
    public List selectFile() {
        FileActionForm form = null;
        List list = new ArrayList();
        String sql = "select * from tb_file";
        ResultSet rs = connection.executeQuery(sql);
        try {
            while (rs.next()) {
                form = new FileActionForm();
                form.setFileName(rs.getString("filename"));
                 form.setFileSize(rs.getString("filesize"));
                 form.setFileDate(rs.getString("filedate"));
                form.setFilePath(rs.getString("filepath"));
            list.add(form);
            }
        } catch (SQLException ex) {
        }
        return list;
    }
}