filedao.java

来自「《struts应用开发完全手册》中的源代码及安装指导」· Java 代码 · 共 28 行

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;
    }
}