List of queryForInt() Examples

Examples of queryForInt()

liquibase.executor.Executor.queryForInt()
net.hasor.db.jdbc.core.JdbcTemplate.queryForInt()
org.springframework.jdbc.core.JdbcOperations.queryForInt()
Execute a query that results in an int value, given static SQL.
Uses a JDBC Statement, not a PreparedStatement. If you want to execute a static query with a PreparedStatement, use the overloaded queryForInt method with null as argument array.
This method is useful for running static SQL with a known outcome. The query is expected to be a single row/single column query that results in an int value. @param sql SQL query to execute @return the int value, or 0 in case of SQL NULL @throws IncorrectResultSizeDataAccessException if the query does not returnexactly one row, or does not return exactly one column in that row @throws DataAccessException if there is any problem executing the query @see #queryForInt(String,Object[])
org.springframework.jdbc.core.JdbcTemplate.queryForInt()
org.springframework.jdbc.core.namedparam.NamedParameterJdbcOperations.queryForInt()
Query given SQL to create a prepared statement from SQL and a list of arguments to bind to the query, resulting in an int value.
The query is expected to be a single row/single column query that results in an int value. @param sql SQL query to execute @param paramSource container of arguments to bind to the query @return the int value, or 0 in case of SQL NULL @throws org.springframework.dao.IncorrectResultSizeDataAccessException if the query does not returnexactly one row, or does not return exactly one column in that row @throws org.springframework.dao.DataAccessException if the query fails @see org.springframework.jdbc.core.JdbcTemplate#queryForInt(String)
org.springframework.jdbc.core.simple.SimpleJdbcTemplate.queryForInt()

Examples of liquibase.executor.Executor.queryForInt()

          throw new LockException("Did not update change log lock correctly.\n\n"
              + updatedRows
              + " rows were updated instead of the expected 1 row using executor "
              + executor.getClass().getName()
              + " there are "
              + executor.queryForInt(new RawSqlStatement("select count(*) from "
                  + database.getDatabaseChangeLogLockTableName())) + " rows in the table");
        }
        database.commit();
        hasChangeLogLock = false;

View Full Code Here

Examples of net.hasor.db.jdbc.core.JdbcTemplate.queryForInt()

        JdbcTemplate hJDBC = app.getInstance("hsql");
        //3.初始化表
        this.initData(mJDBC, hJDBC);
        //
        System.out.println("MySQL User Count :" + mJDBC.queryForInt("select count(*) from TB_User"));
        System.out.println("HSQL User Count :" + hJDBC.queryForInt("select count(*) from TB_User"));
        //
    }
    private void initData(JdbcTemplate mJDBC, JdbcTemplate hJDBC) throws SQLException, IOException {
        String insertUser_1 = "insert into TB_User values(?,'默罕默德','muhammad','123','muhammad@hasor.net','2011-06-08 20:08:08');";
        String insertUser_2 = "insert into TB_User values(?,'安妮.贝隆','belon','123','belon@hasor.net','2011-06-08 20:08:08');";

View Full Code Here

Examples of net.hasor.db.jdbc.core.JdbcTemplate.queryForInt()

        System.out.println("--->>simple_InsertJDBCTest<<--");
        //
        AppContext app = Hasor.createAppContext("net/test/simple/db/jdbc-config.xml", new OneDataSourceWarp());
        JdbcTemplate jdbc = app.getInstance(JdbcTemplate.class);
        //
        System.out.println(jdbc.queryForInt("select count(*) from TB_User where userUUID='deb4f4c8-5ba1-4f76-8b4a-c2be028bf57b'"));
        //
        String insertUser = "insert into TB_User values('deb4f4c8-5ba1-4f76-8b4a-c2be028bf57b','安妮.贝隆','belon','123','belon@hasor.net','2011-06-08 20:08:08');";
        jdbc.execute(insertUser);//执行插入语句
        //
        System.out.println(jdbc.queryForInt("select count(*) from TB_User where userUUID='deb4f4c8-5ba1-4f76-8b4a-c2be028bf57b'"));

View Full Code Here

Examples of net.hasor.db.jdbc.core.JdbcTemplate.queryForInt()

        System.out.println(jdbc.queryForInt("select count(*) from TB_User where userUUID='deb4f4c8-5ba1-4f76-8b4a-c2be028bf57b'"));
        //
        String insertUser = "insert into TB_User values('deb4f4c8-5ba1-4f76-8b4a-c2be028bf57b','安妮.贝隆','belon','123','belon@hasor.net','2011-06-08 20:08:08');";
        jdbc.execute(insertUser);//执行插入语句
        //
        System.out.println(jdbc.queryForInt("select count(*) from TB_User where userUUID='deb4f4c8-5ba1-4f76-8b4a-c2be028bf57b'"));
    }
}

View Full Code Here

Examples of org.springframework.jdbc.core.JdbcOperations.queryForInt()

    String sql = "SELECT COUNT(0) FROM BAR";
    int expectedResult = 666;


    MockControl mc = MockControl.createControl(JdbcOperations.class);
    JdbcOperations jo = (JdbcOperations) mc.getMock();
    jo.queryForInt(sql);
    mc.setReturnValue(expectedResult);
    mc.replay();


    SimpleJdbcTemplate jth = new SimpleJdbcTemplate(jo);

View Full Code Here

Examples of org.springframework.jdbc.core.JdbcOperations.queryForInt()

    int arg1 = 24;
    String arg2 = "foo";


    MockControl mc = MockControl.createControl(JdbcOperations.class);
    JdbcOperations jo = (JdbcOperations) mc.getMock();
    jo.queryForInt(sql, new Object[]{arg1, arg2});
    mc.setDefaultMatcher(new ArrayMatcher());
    mc.setReturnValue(expectedResult);
    mc.replay();


    SimpleJdbcTemplate jth = new SimpleJdbcTemplate(jo);

View Full Code Here

Examples of org.springframework.jdbc.core.JdbcOperations.queryForInt()

    String sql = "SELECT COUNT(0) FROM BAR";
    int expectedResult = 666;


    MockControl mc = MockControl.createControl(JdbcOperations.class);
    JdbcOperations jo = (JdbcOperations) mc.getMock();
    jo.queryForInt(sql);
    mc.setReturnValue(expectedResult);
    mc.replay();


    SimpleJdbcTemplate jth = new SimpleJdbcTemplate(jo);

View Full Code Here

Examples of org.springframework.jdbc.core.JdbcOperations.queryForInt()

    int arg1 = 24;
    String arg2 = "foo";


    MockControl mc = MockControl.createControl(JdbcOperations.class);
    JdbcOperations jo = (JdbcOperations) mc.getMock();
    jo.queryForInt(sql, new Object[]{arg1, arg2});
    mc.setDefaultMatcher(new ArrayMatcher());
    mc.setReturnValue(expectedResult);
    mc.replay();


    SimpleJdbcTemplate jth = new SimpleJdbcTemplate(jo);

View Full Code Here

Examples of org.springframework.jdbc.core.JdbcTemplate.queryForInt()


        assertTrue(userTO.getPropagationTOs().isEmpty());


        Exception exception = null;
        try {
            jdbcTemplate.queryForInt("SELECT id FROM test WHERE id=?", userTO.getUsername());
        } catch (EmptyResultDataAccessException e) {
            exception = e;
        }
        assertNotNull(exception);

View Full Code Here

Examples of org.springframework.jdbc.core.JdbcTemplate.queryForInt()


    // initialize drop procedure, if database has been dropped
    jdbcTemplate.execute(new ResourceUtil(DROP_FUNCTION.getURI()).getContent());


    // drop previous function version, if necessary
    jdbcTemplate.queryForInt("select util.drop_function( ?,? )", 
        dbFunction.getSchema(), dbFunction.getFunctionName());


    // load new function body
    jdbcTemplate.execute(new ResourceUtil(dbFunction.getURI()).getContent());
  }

View Full Code Here

0 1 2 3 4 5

TOP

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.