How read query from properties file in Java with Statement class?

HMS·2022년 7월 28일
0

checkMemberCode=SELECT COUNT(*) FROM MEMBER_TBL WHERE MEMBER_ID = '" + memberCode + "'

How to change +membercode+ part?

public int checkMemberCode(String memberCode, Connection conn) {
		Statement stmt = null;
		ResultSet rset = null;
		int result = 0;
		String query = temp.prop().getProperty("checkMemberCode"+ memberCode+ "'");
		try {
			stmt = conn.createStatement();
			rset = stmt.executeQuery(query);
			if (rset.next()) {
				result = rset.getInt("COUNT(*)");

			}

		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return result;
	}
profile
안녕하세요

0개의 댓글