JdbcTemplate.QueryForObject JPAクエリを使用して文字列を返す
1701 ワード
public String getStatus(String tel){
String sql =
" SELECT status FROM cus_info WHERE telephone = ?;";
return jdbcTemplate.queryForObject(sql,String.class, new Object[]{tel});
}
public Integer getStatus(String tel){
String sql =
" SELECT status FROM cus_info WHERE telephone = ?;";
return jdbcTemplate.queryForObject(sql,Integer.class, new Object[]{tel});
}