java - Spring MVC jdbc 模板

Question

我正在使用 Spring MVC 和 JDBC 模板。

String SQL = "select * from storeTable"; 

使用上面的SQL语句，并将所有结果打印在网页上，效果很好。但是，我必须使用下面的 SQL 语句，该语句也应该在网页上看到。

String sql = "select * from storeTable where STORE_NO = ? and Register_NO = ?";

如何解决这个问题？

Answer 1

查询字符串:

String lastName = this.jdbcTemplate.queryForObject(
        "select last_name from t_actor where id = ?",
        new Object[]{1212L}, String.class);

查询并填充单个域对象:

Actor actor = this.jdbcTemplate.queryForObject(
        "select first_name, last_name from t_actor where id = ?",
        new Object[]{1212L},
        new RowMapper<Actor>() {
            public Actor mapRow(ResultSet rs, int rowNum) throws SQLException {
                Actor actor = new Actor();
                actor.setFirstName(rs.getString("first_name"));
                actor.setLastName(rs.getString("last_name"));
                return actor;
            }
        });

查询并填充多个域对象:

List<Actor> actors = this.jdbcTemplate.query(
        "select first_name, last_name from t_actor",
        new RowMapper<Actor>() {
            public Actor mapRow(ResultSet rs, int rowNum) throws SQLException {
                Actor actor = new Actor();
                actor.setFirstName(rs.getString("first_name"));
                actor.setLastName(rs.getString("last_name"));
                return actor;
            }
        });

对你来说，它会是这样的。

 Object obj = this.jdbcTemplate.queryForObject(
            "select * from storeTable where STORE_NO = ? and Register_NO = ?",
            new Object[]{1212L,46575L}, Returning.class);

queryForObject 或查询取决于您的 sql 将返回的内容。返回的类可以是一个简单的类或一个行映射器对象，如上面的示例，并且 obj 将是映射器将结果映射到的类/List<>。相应修改

查看 doc