public InvestManagerDto getInvestManagerDto(String mgrName){
		


		PreparedStatement stmt = null;
		ResultSet rs = null;
		InvestManagerDto investManagerDto = null;
		try {

			stmt = conn
					.prepareStatement("select mgrName,mgrInfo from InvestManager where mgrName = ? ");

			stmt.setString(1, mgrName);

			rs = stmt.executeQuery();

			String name = "";
			String info="";

			if(rs.next()) {

				investManagerDto=new InvestManagerDto();				
				name = rs.getString(1);
				info = rs.getString(2);
				investManagerDto.setName(name);
				investManagerDto.setInfo(info);
			}

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

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