[Oracle] jdbc (Select 원하는 항목 검사 )

String kind ="회원등급";
		String keyword ="준";
		
		Map<String,String> map = new HashMap<>();
		map.put("회원아이디", "member_id");
		map.put("회원닉네임", "member_nick");
		map.put("회원등급", "member_grade");
		map.put("회원이메일", "member_email");
		map.put("회원전화번호", "member_phone");
		
		if(!map.containsKey(kind)) {
			System.out.println("분류 선택오류");
			System.exit(-1);
		}
		
		kind =map.get(kind);
		
		Class.forName("oracle.jdbc.OracleDriver");
		Connection con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe", "kh", "kh");
		
		
		String sql = "select * from member where instr(#1,?) > 0 order by #1 asc ";
		sql=sql.replace("#1", kind);
		
		PreparedStatement ps= con.prepareStatement(sql);
		ps.setString(1, keyword);
		
		ResultSet rs = ps.executeQuery();
		
		   while(rs.next()) {
		        System.out.print("ID:" + rs.getString("member_id"));
		        System.out.print(" / ");
		        System.out.print("nickname:" + rs.getString("member_nick"));
		        System.out.print(" / ");
		        System.out.print("email:" + rs.getString("member_email"));
		        System.out.print(" / ");
		        System.out.print("Phone:" + rs.getString("member_phone"));
		        System.out.print(" / ");
		        System.out.print("Point:" + rs.getString("member_point"));
		        System.out.print(" / ");
		        System.out.println("Grade:" + rs.getString("member_grade"));
		    }
		
		con.close();
		System.out.println("조회가완료되엇습니다");
}

}

Map collection 을사용하여 별칭처럼 사용도 가능하다.