Example usage for org.springframework.jdbc.core SqlParameter SqlParameter

Introduction

In this page you can find the example usage for org.springframework.jdbc.core SqlParameter SqlParameter.

Prototype

public SqlParameter(String name, int sqlType)

Source Link

Document

Create a new SqlParameter, supplying name and SQL type.

Usage

From source file:orz.neptune.prospring3.ch8.UpdateContact.java

public UpdateContact(DataSource dataSource) {
    super(dataSource, SQL_UPDATE_CONTACT);
    super.declareParameter(new SqlParameter("first_name", Types.VARCHAR));
    super.declareParameter(new SqlParameter("last_name", Types.VARCHAR));
    super.declareParameter(new SqlParameter("birth_date", Types.DATE));
    super.declareParameter(new SqlParameter("id", Types.INTEGER));
}

From source file:orz.neptune.prospring3.ch8.InsertContact.java

public InsertContact(DataSource dataSource) {
    super(dataSource, SQL_INSERT_CONTACT);
    super.declareParameter(new SqlParameter("first_name", Types.VARCHAR));
    super.declareParameter(new SqlParameter("last_name", Types.VARCHAR));
    super.declareParameter(new SqlParameter("birth_date", Types.DATE));
    super.setGeneratedKeysColumnNames(new String[] { "id" });
    super.setReturnGeneratedKeys(true);
}

From source file:com.home.ln_spring.ch8.dao.jdbc.annotation.InsertContact.java

public InsertContact(DataSource dataSource) {
    super(dataSource, SQL_INSERT_CONTACT);
    super.declareParameter(new SqlParameter("first_name", Types.VARCHAR));
    super.declareParameter(new SqlParameter("last_name", Types.VARCHAR));
    super.declareParameter(new SqlParameter("birth_date", Types.DATE));
    super.setGeneratedKeysColumnNames(new String[] { "contact_id" });
    super.setReturnGeneratedKeys(true);
}

From source file:com.home.ln_spring.ch8.dao.jdbc.annotation.UpdateContact.java

public UpdateContact(DataSource dataSource) {
    super(dataSource, SQL_UPDATE_CONTACT);
    super.declareParameter(new SqlParameter("first_name", Types.VARCHAR));
    super.declareParameter(new SqlParameter("last_name", Types.VARCHAR));
    super.declareParameter(new SqlParameter("birth_date", Types.DATE));
    super.declareParameter(new SqlParameter("contact_id", Types.INTEGER));
}

From source file:com.home.ln_spring.ch8.dao.jdbc.annotation.SelectContactByFirstName.java

public SelectContactByFirstName(DataSource dataSource) {
    super(dataSource, SQL_FIND_BY_FIRST_NAME);
    super.declareParameter(new SqlParameter("first_name", Types.VARCHAR));
}

From source file:com.home.ln_spring.ch8.dao.jdbc.annotation.InsertContactTelDetail.java

public InsertContactTelDetail(DataSource dataSource) {
    super(dataSource, SQL_INSERT_CONTACT_TEL);
    declareParameter(new SqlParameter("contact_id", Types.INTEGER));
    declareParameter(new SqlParameter("tel_type", Types.VARCHAR));
    declareParameter(new SqlParameter("tel_number", Types.VARCHAR));
    setBatchSize(BATCH_SIZE);//from   w  ww  . ja  v a 2  s . c om
}

From source file:net.sourceforge.vulcan.spring.jdbc.TestFailureQuery.java

public TestFailureQuery(DataSource dataSource) {
    super(dataSource, "select name, message, details, first_consecutive_build_number "
            + "from test_failures where build_id = ?");
    declareParameter(new SqlParameter("build_id", Types.NUMERIC));
    compile();//from  ww w. ja  v  a2  s  .  c o  m
}

From source file:net.sourceforge.vulcan.spring.jdbc.MetricsQuery.java

public MetricsQuery(DataSource dataSource) {
    super(dataSource,
            "select message_key, metric_type, data " + "from metrics where build_id = ? order by message_key");
    declareParameter(new SqlParameter("build_id", Types.NUMERIC));
    compile();/*from   www. j  a  v a2 s.  c  o m*/
}

From source file:com.mec.DAO.Passport.UserDAO.java

public Usuario getUser(String nombre, String clave) {
    Usuario u = null;/*from ww w.  jav  a  2  s.c o m*/
    SimpleJdbcCall jdbcCall = new SimpleJdbcCall(ds).withCatalogName("dbo")
            .withProcedureName("paValidarUsuario").withoutProcedureColumnMetaDataAccess()
            .declareParameters(new SqlParameter("NombreUsuario", Types.VARCHAR))
            .declareParameters(new SqlParameter("Clave", Types.VARCHAR))
            .declareParameters(new SqlOutParameter("UserId", Types.INTEGER))
            .declareParameters(new SqlOutParameter("ErrText", Types.VARCHAR));
    SqlParameterSource in = new MapSqlParameterSource().addValue("NombreUsuario", nombre).addValue("Clave",
            clave);
    Map<String, Object> r = jdbcCall.execute(in);
    Integer userId = null;
    String errText = "";
    for (Map.Entry<String, Object> entry : r.entrySet()) {
        String key = entry.getKey();
        if (key.equals("UserId")) {
            userId = (Integer) entry.getValue();
        } else if (key.equals("ErrText")) {
            errText = (String) entry.getValue();
        }
    }
    if (userId != null && errText.equals("Ok")) {
        List<GrantedAuthority> roles = getUserRoles(userId);
        u = new Usuario(userId, roles);
    }
    return u;
}

From source file:net.sourceforge.vulcan.spring.jdbc.BuildMessagesQuery.java

public BuildMessagesQuery(DataSource dataSource) {
    super(dataSource, "select message_type, message, code, file, line_number "
            + "from build_messages where build_id = ? order by message_type, file, line_number, message");
    declareParameter(new SqlParameter("build_id", Types.NUMERIC));
    compile();/*from  ww  w  .j  a  va 2s . com*/
}