配置数据,添加依赖,创建DAO类,创建实体类entity,使用dao
添加依赖<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-jdbc</artifactId>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
</dependency>
创建DAO
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.stereotype.Repository;
@Repository public class XXXDao {
@Autowired
private JdbcTemplate jdbcTemplate;
public void insert(XXXEntity entity) {
String sql = "INSERT INTO xxx_table (column1, column2, ...) VALUES (?, ?, ...)"; jdbcTemplate.update(sql, entity.getColumn1(), entity.getColumn2(), ...);
}
public void update(XXXEntity entity) {
String sql = "UPDATE xxx_table SET column1 = ?, column2 = ... WHERE id = ?"; jdbcTemplate.update(sql, entity.getColumn1(), entity.getColumn2(), ..., entity.getId());
}
public void delete(Long id) {
String sql = "DELETE FROM xxx_table WHERE id = ?";
jdbcTemplate.update(sql, id);
}
public List<XXXEntity> findAll() {
String sql = "SELECT * FROM xxx_table";
return jdbcTemplate.query(sql, new RowMapper<XXXEntity>() {
public XXXEntity mapRow(ResultSet rs, int rowNum) throws SQLException {
XXXEntity entity = new XXXEntity();
entity.setColumn1(rs.getString("column1")); entity.setColumn2(rs.getString("column2"));
// ...
return entity;
}
});
}
public XXXEntity findById(Long id) {
String sql = "SELECT * FROM xxx_table WHERE id = ?";
return jdbcTemplate.queryForObject(sql, new Object[]{id}, new RowMapper<XXXEntity>() { public XXXEntity mapRow(ResultSet rs, int rowNum) throws SQLException {
XXXEntity entity = new XXXEntity();
entity.setColumn1(rs.getString("column1")); entity.setColumn2(rs.getString("column2"));
// ... return entity;
}
});
}
、}
实体类
private Long id;
private String column1;
private String column2;
// ...
// Getters and setters
}
使用DAO
public class XXXService {
@Autowired
private XXXDao xxxDao;
public void insertXXX(XXXEntity entity) {
xxxDao.insert(entity); }
public void updateXXX(XXXEntity entity) {
xxxDao.update(entity); }
public void deleteXXX(Long id) {
xxxDao.delete(id); }
public List<XXXEntity> getAllXXX() {
return xxxDao.findAll(); }
public XXXEntity getXXXById(Long id) {
return xxxDao.findById(id); } }