任务卡2：Spring Data JDBC

• 学习使用Spring Data JDBC
• 学习使用Spring Boot如何自动配置Spring Data的JDBC存储库

IDEA一直在下载jar包，一直在导包，没办法测试

1.在Spring JDBC中，哪个类用来执行SQL查询，更新语句和存储过程调用，在ResultSet上执行迭代并提取返回的参数值 C
Controller
jdbcTemplateObject
JdbcTemplate
PreparedStatementSetter
2.以下使用Spring JDBC 进行插入数据的方式正确的为 A
String insertQuery = “insert into user (age) values (age = ?)”; jdbcTemplateObject.update( insertQuery, 10);
String insertQuery = “insert into user (age) values (?)”; jdbcTemplateObject.update( insertQuery, 10);
String insertQuery = “insert into user (age) values (age = ?)”; jdbcTemplateObject.update( insertQuery, age = 10);
String insertQuery = “insert into user (age) values (?)”; jdbcTemplateObject.update( insertQuery, age = 10);
3.以下使用Spring JDBC 进行查询数据的方式正确的为A
String insertQuery = “select from user”; List user = jdbcTemplateObject.query(selectQuery, new UserMapper());
String insertQuery = “select from user”; List > user = jdbcTemplateObject.query(selectQuery, new UserMapper());
String insertQuery = “select from user”; List user = jdbcTemplateObject.update(selectQuery, new UserMapper());
String insertQuery = “select from user”; List user = jdbcTemplateObject.select(selectQuery, new UserMapper());
4.以下使用Spring JDBC 进行更新数据的方式正确的为D
String updateQuery = “update User set age = ? where id = ?”; jdbcTemplateObject.set(updateQuery, age, id);
String updateQuery = “update User set age = ? where id = ?”; jdbcTemplateObject.query(updateQuery, age, id);
String updateQuery = “update User set age = ? where id = ?”; jdbcTemplateObject.select(updateQuery, age, id);
String updateQuery = “update User set age = ? where id = ?”; jdbcTemplateObject.update(updateQuery, age, id);
5.以下使用Spring JDBC 进行删除数据的方式正确的为B
String deleteQuery = “delete from user where id = ?”; jdbcTemplateObject.select(updateQuery, id);
String deleteQuery = “delete from user where id = ?”; jdbcTemplateObject.delete(updateQuery, id);
String deleteQuery = “delete from user where id = ?”; jdbcTemplateObject.update(updateQuery, id);
String deleteQuery = “delete from user where id = ?”; jdbcTemplateObject.set(updateQuery, id);