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);
        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(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_FORENAME_WHERE);
        setResultSetType(ResultSet.TYPE_SCROLL_SENSITIVE);
        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);
        setResultSetType(ResultSet.TYPE_SCROLL_SENSITIVE);
        declareParameter(new SqlParameter(Types.NUMERIC));
        compile();
      }


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

View Full Code Here


      public CustomerQuery(DataSource ds) {
        super(ds, SELECT_ID_FORENAME_NAMED_PARAMETERS);
        setResultSetType(ResultSet.TYPE_SCROLL_SENSITIVE);
        if (namedDeclarations) {
          declareParameter(new SqlParameter("country", Types.VARCHAR));
          declareParameter(new SqlParameter("id", Types.NUMERIC));
        }
        else {
          declareParameter(new SqlParameter(Types.NUMERIC));
          declareParameter(new SqlParameter(Types.VARCHAR));
        }
        compile();
      }


      protected Object mapRow(ResultSet rs, int rownum) throws SQLException {

View Full Code Here

    class CustomerQuery extends MappingSqlQuery {


      public CustomerQuery(DataSource ds) {
        super(ds, SELECT_ID_FORENAME_WHERE_ID_IN_LIST_2);
        setResultSetType(ResultSet.TYPE_SCROLL_SENSITIVE);
        declareParameter(new SqlParameter("ids", 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_ID_REUSED_2);
        setResultSetType(ResultSet.TYPE_SCROLL_SENSITIVE);
        declareParameter(new SqlParameter("id1", 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_ID_REUSED_1);
        setResultSetType(ResultSet.TYPE_SCROLL_SENSITIVE);
        declareParameter(new SqlParameter("id1", Types.NUMERIC));
        compile();
      }


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

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


      protected Object updateRow(ResultSet rs, int rownum, Map context) throws SQLException {
        rs.updateString(2, "" + context.get(new Integer(rs.getInt(COLUMN_NAMES[0]))));

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.