Examples of org.springframework.jdbc.core.SqlParameter

org.springframework.jdbc.core.SqlParameter
Object to represent a SQL parameter definition.
Parameters may be anonymous, in which case "name" is null. However, all parameters must define a SQL type according to {@link java.sql.Types}. @author Rod Johnson @author Thomas Risberg @author Juergen Hoeller @see java.sql.Types

    class CustomerQuery extends MappingSqlQuery {


      public CustomerQuery(DataSource ds) {
        super(ds, SELECT_ID_FORENAME_WHERE_ID_REUSED_2);
        setResultSetType(ResultSet.TYPE_SCROLL_SENSITIVE);
        declareParameter(new SqlParameter("id1", Types.NUMERIC));
        compile();
      }

View Full Code Here

    class CustomerQuery extends MappingSqlQuery {


      public CustomerQuery(DataSource ds) {
        super(ds, SELECT_ID_FORENAME_WHERE_ID_REUSED_1);
        setResultSetType(ResultSet.TYPE_SCROLL_SENSITIVE);
        declareParameter(new SqlParameter("id1", Types.NUMERIC));
        compile();
      }

View Full Code Here


    class CustomerUpdateQuery extends UpdatableSqlQuery {


      public CustomerUpdateQuery(DataSource ds) {
        super(ds, SELECT_ID_FORENAME_WHERE_ID);
        declareParameter(new SqlParameter(Types.NUMERIC));
        compile();
      }

View Full Code Here


      public NamedParameterUpdater() {
        setSql(UPDATE_NAMED_PARAMETERS);
        setDataSource(mockDataSource);
        if (namedDeclarations) {
          declareParameter(new SqlParameter("priceId", Types.DECIMAL));
          declareParameter(new SqlParameter("perfId", Types.NUMERIC));
        }
        else {
          declareParameter(new SqlParameter(Types.NUMERIC));
          declareParameter(new SqlParameter(Types.DECIMAL));
        }
        compile();
      }


      public int run(int performanceId, int type) {

View Full Code Here


      public NamedParameterUpdater() {
        setSql(UPDATE_NAMED_PARAMETERS);
        setDataSource(mockDataSource);
        if (namedDeclarations) {
          declareParameter(new SqlParameter("priceId", Types.DECIMAL));
          declareParameter(new SqlParameter("perfId", Types.NUMERIC));
        }
        else {
          declareParameter(new SqlParameter(Types.NUMERIC));
          declareParameter(new SqlParameter(Types.DECIMAL));
        }
        compile();
      }

View Full Code Here


    };
    query.setDataSource(mockDataSource);
    query.setSql(SELECT_ID_WHERE);
    query.declareParameter(
      new SqlParameter(COLUMN_NAMES[0], COLUMN_TYPES[0]));
    query.declareParameter(
      new SqlParameter(COLUMN_NAMES[1], COLUMN_TYPES[1]));
    query.compile();


    try {
      List list = query.execute();
      fail("Shouldn't succeed in running query without enough params");

View Full Code Here

      }
    };
    query.setDataSource(mockDataSource);
    query.setSql(SELECT_ID_WHERE);
    query.declareParameter(
      new SqlParameter(COLUMN_NAMES[0], COLUMN_TYPES[0]));
    query.declareParameter(
      new SqlParameter(COLUMN_NAMES[1], COLUMN_TYPES[1]));
    query.compile();


    try {
      Map params = new HashMap();
      params.put(COLUMN_NAMES[0], "Value");

View Full Code Here


    class CustomerQuery extends MappingSqlQuery {


      public CustomerQuery(DataSource ds) {
        super(ds, SELECT_ID_WHERE);
        declareParameter(new SqlParameter(Types.NUMERIC));
        declareParameter(new SqlParameter(Types.NUMERIC));
        compile();
      }


      protected Object mapRow(ResultSet rs, int rownum) throws SQLException {
        Customer cust = new Customer();

View Full Code Here


    class CustomerQuery extends MappingSqlQuery {


      public CustomerQuery(DataSource ds) {
        super(ds, SELECT_ID_FORENAME_WHERE);
        declareParameter(new SqlParameter(Types.VARCHAR));
        compile();
      }


      protected Object mapRow(ResultSet rs, int rownum) throws SQLException {
        Customer cust = new Customer();

View Full Code Here

    class CustomerQuery extends MappingSqlQuery {


      public CustomerQuery(DataSource ds) {
        super(ds, SELECT_ID_WHERE);
        declareParameter(
          new SqlParameter(COLUMN_NAMES[0], COLUMN_TYPES[0]));
        declareParameter(
          new SqlParameter(COLUMN_NAMES[1], COLUMN_TYPES[1]));
        compile();
      }


      protected Object mapRow(ResultSet rs, int rownum) throws SQLException {
        Customer cust = new Customer();

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

Related Classes of org.springframework.jdbc.core.SqlParameter

com.apress.prospring.data.jdbc.JdbcAbstractAttachmentDao$Delete

com.apress.prospring.data.jdbc.JdbcAbstractAttachmentDao$Insert

com.apress.prospring.data.jdbc.JdbcAbstractAttachmentDao$InsertComment

com.apress.prospring.data.jdbc.JdbcAbstractAttachmentDao$InsertEntry

com.apress.prospring.data.jdbc.JdbcAbstractAttachmentDao$SelectByComment

com.apress.prospring.data.jdbc.JdbcAbstractAttachmentDao$SelectByEntry

com.apress.prospring.data.jdbc.JdbcAbstractAttachmentDao$SelectById

com.github.hakko.musiccabinet.dao.jdbc.JdbcLibraryAdditionDao

com.github.hakko.musiccabinet.dao.jdbc.JdbcLibraryDeletionDao

com.github.hakko.musiccabinet.dao.jdbc.JdbcTagDao

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.