连接jdbc

1.配置

spring.datasource.url=jdbc:mysql://localhost/test
spring.datasource.password=root
spring.datasource.username=root
spring.datasource.driver-class-name=com.mysql.jdbc.Driver

2.注入jdbc模板JdbcTemplate

例子

@Service
public class UserService {

    @Autowired
    private JdbcTemplate template;

    public void insert(Person person) {
        template.update("insert into person(name)value(?)",person);
    }

    public void delete(int id) {
        template.update("delete from person where id=?",id);
    }

    public void update(Person person) {
        template.update("update person set name=?",person);
    }

    public List<Person> select() {
        List<Person> list=template.queryForList("select * from person", Person.class);
        return list;
    }