JDBC

Apr

Select che ritorna unico record

admin No Comments

public Reference getReference(String idRole,String idUser){

String sql="SELECT * FROM refers WHERE id_role=? AND id_user=?";
Reference ref=(Reference)jdbcTemplate.queryForObject(sql, new Object[]{idRole,idUser},new BeanPropertyRowMapper(Reference.class){
public Reference extractData(ResultSet rs) throws SQLException,DataAccessException{
Reference ref=new Reference();

ref.setId(rs.getInt("id"));
ref.setIdRole(rs.getString("id_role"));
ref.setIdUser(rs.getString("id_user"));
ref.setDescription(rs.getString("description"));

return ref;
}
});

public Reference getReference(String idRole,String idUser){

String sql="SELECT * FROM refers WHERE id_role=? AND id_user=?";

Reference ref=(Reference)jdbcTemplate.queryForObject(sql, new Object[]{idRole,idUser},new BeanPropertyRowMapper(Reference.class){

public Reference extractData(ResultSet rs) throws SQLException,DataAccessException{

Reference ref=new Reference();

ref.setId(rs.getInt("id"));

ref.setIdRole(rs.getString("id_role"));

ref.setIdUser(rs.getString("id_user"));

ref.setDescription(rs.getString("description"));

return ref;

}

});

Apr

Select che ritorna unica colonna

admin No Comments

public String getUsernameBySapCode(StringsapCode){
String sql = "SELECT username FROM users WHERE sap_code=?";
String uname=(String)jdbcTemplate.queryForObject(sql,newObject[]{sapCode},String.class);

return uname;

}

public String getUsernameBySapCode(StringsapCode){

String sql = "SELECT username FROM users WHERE sap_code=?";

String uname=(String)jdbcTemplate.queryForObject(sql,newObject[]{sapCode},String.class);

return uname;

}

Apr

Select che ritorna unico record

Apr

Select che ritorna unica colonna

Articoli recenti

Categorie

Archivi