public List<ProductInfoDto> getProductInfos(){
		
		List<ProductInfoDto> productInfos=null;
		PreparedStatement stmt = null;
		ResultSet rs = null;

		try {

			stmt = conn
					.prepareStatement("select proName,investManager,proInfo from ProductInfo");

			rs = stmt.executeQuery();

			String proName = "";
			String investManager = "";
			String proInfo = "";

			productInfos = new ArrayList<ProductInfoDto>();
			
			while (rs.next()) {

				proName = rs.getString(1);
				investManager = rs.getString(2);
				proInfo = rs.getString(3);

				ProductInfoDto proInfoDto = new ProductInfoDto();
				
				proInfoDto.setName(proName);
				proInfoDto.setInvestManager(investManager);
				proInfoDto.setInfo(proInfo);

				productInfos.add(proInfoDto);

			}

			if (stmt != null)
				stmt.close();
			if (rs != null)
				rs.close();

		} catch (Exception e) {
			// TODO: handle exception
			
			logger.debug(e.getMessage());
		}
		
		return productInfos;
		
	}