JdbcTemplate操作数据库（进行增删改查的实现类）

增添数据

以操作数据库中的表t_book为例，其中user_id,username,ustatus为数据库中表数据

public void add(Book book) {
    String sql="insert into t_book values(?,?,?)";
    Object[] args={book.getUserId(),book.getUsername(),book.getUstatus()};
    int update = jdbcTemplate.update(sql,args);
    System.out.println(update);
}

修改操作

public void updateBook(Book book) {
    String sql="update t_book set username=?,ustatus=? where user_id=?";
    Object[] args={book.getUsername(),book.getUstatus(),book.getUserId()};
    int update = jdbcTemplate.update(sql, args);
    System.out.println(update);
}

删除操作

public void delete(String id) {
    String sql="delete from t_book where user_id=?";
    int update = jdbcTemplate.update(sql,id);
    System.out.println(update);

}

查询个体

public Book findBookInfo(String id) {
    String sql="select * from t_book where user_id=?";
    Book book = jdbcTemplate.queryForObject(sql, new BeanPropertyRowMapper<Book>(Book.class), id);
    return book;
}

查询全部

public List<Book> findAllBook() {
    String sql="select * from t_book";
    List<Book> query = jdbcTemplate.query(sql, new BeanPropertyRowMapper<Book>(Book.class));
    return query;
}

book类

public class Book {
    private String userId;
    private String username;
    private String ustatus;

    @Override
    public String toString() {
        return "Book{" +
                "userId='" + userId + ''' +
                ", username='" + username + ''' +
                ", ustatus='" + ustatus + ''' +
                '}';
    }

    public String getUserId() {
        return userId;
    }

    public void setUserId(String userId) {
        this.userId = userId;
    }

    public String getUsername() {
        return username;
    }

    public void setUsername(String username) {
        this.username = username;
    }

    public String getUstatus() {
        return ustatus;
    }

    public void setUstatus(String ustatus) {
        this.ustatus = ustatus;
    }
}