public List<String> getProductNames(String proMgrName){
		
		PreparedStatement stmt = null;
		ResultSet rs = null;
		List<String> proNames=null;
		
		try {

			stmt = conn
					.prepareStatement("select proName from ProductInfo where productManager = ? ");

			stmt.setString(1, proMgrName);
			
			rs = stmt.executeQuery();
			
			String name="";

			proNames=new ArrayList<String>();
			
			while (rs.next()) {

				name=rs.getString(1);
				proNames.add(name);
				
			}

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

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