fellowdaoimpl.java

struts2+spring+Hibernate整合的一个网站案例

package myitem.dao.impl;
import myitem.db.*;
import java.util.*;
import java.sql.*;
import myitem.dao.FellowDAO;
import myitem.vo.Fellow;

public class FellowDAOImpl implements FellowDAO  {
	
	public List fellowAll() throws Exception
	{
		List allFellow=new ArrayList();
		String sql="select id,name,url,degree from fellow";
		PreparedStatement pstmt=null;
		ConnectionDatabase dbc=null;
		dbc=new ConnectionDatabase();
		try
		{
			pstmt=dbc.getConn().prepareStatement(sql);
			ResultSet rs=pstmt.executeQuery();
			while(rs.next())
			{
				Fellow fellow=new Fellow();
				fellow.setId(rs.getInt(1));
				fellow.setName(rs.getString(2));
				fellow.setUrl(rs.getString(3));
				fellow.setDegree(rs.getInt(4));
				allFellow.add(fellow);
			}
			 rs.close();
			 pstmt.close();
		}
		catch(Exception e)
		{
			
		}
		finally
		{
			try
			{
				if(dbc!=null)
				{
					dbc.close();
				}
			}
			catch(Exception e)
			{
				
			}
			
		}
		return allFellow;
	}

}