docappendixdao.java

来自「功能是公安和学校的管理系统,用struts+hibernate+spring等匡」· Java 代码 · 共 46 行

package com.comingnet.bean;

import java.sql.*;
import com.db.*;
import java.util.*;
public class DocAppendixDAO {
	Connection conn=null;
	PreparedStatement stmt=null;
	ResultSet rs=null;
	public DocAppendixDAO()
	{
		
	}
	public ArrayList<NoticeAppFiles>  getAppendix(int fwid)
	{
		ArrayList<NoticeAppFiles> filelist= new ArrayList<NoticeAppFiles>();
		NoticeAppFiles  noticefile=null;
		try
		{
			conn=DBUtils.getConnection();
			stmt=conn.prepareStatement("select * from docappendix where fwid=?");
			stmt.setInt(1,fwid);
			rs=stmt.executeQuery();
			while(rs.next())
			{
				noticefile=new NoticeAppFiles();
				noticefile.setNewFilename(rs.getString("newname"));
				noticefile.setOldFilename(rs.getString("oldname"));
				filelist.add(noticefile);
			}
			
		}catch(Exception e)
		{
			System.out.println(e);
		}finally
		{
			DBUtils.closeResultSet(rs);
			DBUtils.closeStatement(stmt);
			DBUtils.closeConnection(conn);
		}
		
		return filelist; 
	}

}