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