MYSQL语句的一些用法和坑的记录

1.mysql get方法

String sqlStr = "SELECT * FROM TABLE";
List<POJO> list = jdbcTemplate.query(sqlStr, new BeanPropertyRowMapper<>(POJO.class));

2.mysql update方法

String updateStr = "UPDATE TABLE SET NAME = ?,NAME = ?";
try {
  jdbcTemplate.update(updateStr,,value,value);
}catch (DataAcessException){
  throws...
}

3.mysql add方法

String insertStr = "INSERT INTO TABLE (name, name) VALUE(?,?)";
jdbcTemplate.update(insertStr, value, value);

4.mysql delete方法

String deleteStr = "DELETE FROM TABLE WHERE NAME = ?";
jdbcTemplate.update(deleteStr, value);