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;
}