mailaffixdao.java

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

package com.comingnet.bean;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.List;

import com.comingnet.bean.EmailInfor;
import com.comingnet.bean.MailFileAffix;
import com.db.DBUtils;

public class MailAffixDAO {	
	public MailAffixDAO(){
		
	}
	 	
	Connection conn=null;
	PreparedStatement stmt=null;
	ResultSet rs=null; 
	/**
	 * 根据id查询对应的附件
	 * @param id	附件对应的id
	 * @return	MailFileAffix[]	附件信息数组
	 */
	public ArrayList<MailFileAffix> queryAppFilesById(int id){
		ArrayList<MailFileAffix> files = new ArrayList<MailFileAffix>();		
		try
		{
		   conn=DBUtils.getConnection();
		   stmt=conn.prepareStatement("select fjoldname, fjnewname from yjfj where yjid=?");
		   stmt.setInt(1, id);
		   rs=stmt.executeQuery();
		   MailFileAffix file=null;
		   while(rs.next())
		   {
		      String oldFilename = rs.getString("fjoldname");
		      String newFilename = rs.getString("fjnewname");      
		      //设置AppFiles
		      file = new MailFileAffix();
		      file.setOldFilename(oldFilename);
		      file.setNewFilename(newFilename);
			   System.out.println("MailAffixDAO*****************************************"+file.getNewFilename());
		      files.add(file);
	
		   }		   
		}catch(Exception e)
		{
		   System.out.println(e);
		}finally
		{
		  DBUtils.closeResultSet(rs);
		  DBUtils.closeStatement(stmt);
		  DBUtils.closeConnection(conn);
		}

		return files;
	}

}