org.springframework.jdbc.core.JdbcTemplate 不可以,但org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate这个可以,用法和JDBCTemplate类似:SqlParameterSource namedParameters = new MapSqlParameterSource().addValue("id", 1); return namedParameterJdbcTemplate.queryForObject( "SELECT FIRST_NAME FROM EMPLOYEE WHERE ID = :id", namedParameters, String.class); //.......... Employee employee = new Employee(); employee.setFirstName("James"); String SELECT_BY_ID = "SELECT COUNT(*) FROM EMPLOYEE WHERE FIRST_NAME = :firstName"; SqlParameterSource namedParameters = new BeanPropertySqlParameterSource(employee); return namedParameterJdbcTemplate.queryForObject( SELECT_BY_ID, namedParameters, Integer.class);
org.springframework.jdbc.core.JdbcTemplate
不可以,但org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate
这个可以,用法和JDBCTemplate
类似: