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

List of usage examples for org.springframework.jdbc.core SqlParameter SqlParameter

  1. HOME
  2. Java
  3. org.springframework
  4. org.springframework.jdbc.core.*
  5. SqlParameter
  6. SqlParameter

Introduction

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

Prototype

public SqlParameter(SqlParameter otherParam)

Source Link

Document

Copy constructor.

Usage

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

public SfFirstNameById(DataSource dataSource) {
    super(dataSource, SQL);
    declareParameter(new SqlParameter(Types.INTEGER));
    compile();
}

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

public StoreFunctionQuery(DataSource dataSource) {
    super(dataSource, SQL);
    super.declareParameter(new SqlParameter(Types.INTEGER));
    compile();//from  www. j  a  va 2  s .co  m
}

From source file:org.osmsurround.ae.dao.NodeDelete.java

@Autowired
public NodeDelete(DataSource dataSource) {
    setDataSource(dataSource);//from w  w w  .  j a  va2 s. c o m
    setSql("DELETE FROM nodes WHERE node_id=?");
    declareParameter(new SqlParameter(Types.INTEGER));
}

From source file:org.osmsurround.ae.dao.NodeTagDelete.java

@Autowired
public NodeTagDelete(DataSource dataSource) {
    setDataSource(dataSource);/*from w  ww. j  a  v  a 2  s .  c om*/
    setSql("DELETE FROM node_tags WHERE node_id = ?");
    declareParameter(new SqlParameter(Types.INTEGER));
}

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

public MetricInserter(DataSource dataSource) {
    setDataSource(dataSource);/* www .j  a va  2s .c o m*/
    setSql("insert into metrics " + "(build_id, message_key, metric_type, data) " + "values (?, ?, ?, ?)");

    declareParameter(new SqlParameter(Types.NUMERIC));
    declareParameter(new SqlParameter(Types.VARCHAR));
    declareParameter(new SqlParameter(Types.CHAR));
    declareParameter(new SqlParameter(Types.VARCHAR));

    compile();
}

From source file:org.osmsurround.ae.dao.NodeValueSearchByKey.java

@Autowired
public NodeValueSearchByKey(DataSource dataSource) {
    setDataSource(dataSource);/*from w w  w  .j a  v  a  2s. co  m*/

    setSql("SELECT DISTINCT k, 0 FROM keyvalues WHERE lower(k) LIKE lower(?) ORDER BY k LIMIT 20");
    declareParameter(new SqlParameter(Types.VARCHAR));
}

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

public BuildMessageInserter(DataSource dataSource) {
    setDataSource(dataSource);//from w  ww  .j  a v  a  2 s.c o  m
    setSql("insert into build_messages " + "(build_id, message_type, message, line_number, file, code) "
            + "values (?, ?, ?, ?, ?, ?)");

    declareParameter(new SqlParameter(Types.NUMERIC));
    declareParameter(new SqlParameter(Types.VARCHAR));
    declareParameter(new SqlParameter(Types.VARCHAR));
    declareParameter(new SqlParameter(Types.NUMERIC));
    declareParameter(new SqlParameter(Types.VARCHAR));
    declareParameter(new SqlParameter(Types.VARCHAR));

    compile();
}

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

public DependencyInserter(DataSource dataSource) {
    setDataSource(dataSource);/*  w w  w.j a  v a  2  s.  c o  m*/
    setSql("insert into build_dependencies " + "(build_id, dependency_build_id) " + "values ("
            + "(select id from builds where uuid=?), " + "(select id from builds where uuid=?))");

    declareParameter(new SqlParameter(Types.VARCHAR));
    declareParameter(new SqlParameter(Types.VARCHAR));

    compile();
}

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

public ModifiedPathInserter(DataSource dataSource) {
    setDataSource(dataSource);//from   w ww  .ja  v a2  s.c  o  m
    setSql("insert into modified_paths " + "(build_id, change_set_id, modified_path, modification_type) "
            + "values (?, ?, ?, ?)");

    declareParameter(new SqlParameter(Types.NUMERIC));
    declareParameter(new SqlParameter(Types.NUMERIC));
    declareParameter(new SqlParameter(Types.VARCHAR));
    declareParameter(new SqlParameter(Types.CHAR));

    compile();
}

From source file:org.osmsurround.ae.dao.NodeTagInsert.java

@Autowired
public NodeTagInsert(DataSource dataSource) {
    setDataSource(dataSource);//from www .  j a va2s.  com
    setSql("INSERT INTO node_tags (node_id, k, v) VALUES (?,?,?)");
    declareParameter(new SqlParameter(Types.INTEGER));
    declareParameter(new SqlParameter(Types.VARCHAR));
    declareParameter(new SqlParameter(Types.VARCHAR));
}