Breaking News: Grepper is joining You.com. Read the official announcement!

spring jdbc

Innocent Iguana answered on March 1, 2023 Popularity 8/10 Helpfulness 4/10

answer spring jdbc

related Spring JDBC

spring jdbc

Comment

// Course.java
public class Course {
	private long id;
	private String name;
	private String author;

	public Course() {}

	public Course(long id, String name, String author) {
		super();
		this.id = id;
		this.name = name;
		this.author = author;
	}

	// setters
	// getters
	// toString

}

// CourseJdbcRepository.java
@Repository
public class CourseJdbcRepository {
	
	@Autowired
	private JdbcTemplate springJdbcTemplate; // This is what connects with JDBC
	
	private static String INSERT_QUERY =  """ insert into course (id, name, author) values(?, ?,?); """;
	private static String DELETE_QUERY = """ delete from course where id = ? """;
	private static String SELECT_QUERY = """ select * from course where id = ? """;
	
	public void insert(Course course) { // .update() is used for insert, update, delete; Here we are inserting
		springJdbcTemplate.update(INSERT_QUERY, course.getId(), course.getName(), course.getAuthor());
	}
	
	public void deleteById(long id) {  // .update() is used for insert, update, delete; Here we are deleting
		springJdbcTemplate.update(DELETE_QUERY,id);
	}
	
	public Course findById(long id) { // .queryForObject uses the query string, retrieve using id field, maps the result set to the entity
		return springJdbcTemplate.queryForObject(SELECT_QUERY, new BeanPropertyRowMapper<>(Course.class), id);
	}
}

// CourseCommandLineRunner.java that makes sure to run everything on startup
@Component
public class CourseCommandLineRunner implements CommandLineRunner{

	@Autowired
	private CourseJdbcRepository repository;
	
	@Override
	public void run(String... args) throws Exception {
		// Insert operations
		repository.insert(new Course(1, "Learn AWS!", "Udemy"));
		repository.insert(new Course(2, "Learn Azure!", "Udemy"));
		repository.insert(new Course(3, "Learn GCP!", "Udemy"));
		// Delete operation
		repository.deleteById(1);
		// Read operations
		System.out.println(repository.findById(2));
		System.out.println(repository.findById(3));
	}
}

Popularity 8/10 Helpfulness 4/10 Language java

Source: Grepper

Tags: java spring-jdbc

Link to this answer
Share Copy Link

Contributed on Apr 02 2024

Innocent Iguana

0 Answers Avg Quality 2/10

Closely Related Answers

Spring JDBC

Comment

jdbcTemplate
.update
("Update todo set user=?, desc=?, target_date=?, is_done=? where itodo.getUser(), todo.getDesc(),
new Timestamp(todo.getTargetDate().getTime()),
todo.isDone(), todo.getId());
jdbcTemplate.update("delete from todo where id=?",
id);

Popularity 9/10 Helpfulness 2/10 Language java

Source: Grepper

Tags: java

Link to this answer
Share Copy Link

Contributed on Mar 01 2023

Pragya Keshap

0 Answers Avg Quality 2/10

spring jdbc

Contents

More Related Answers

spring jdbc

Closely Related Answers

Spring JDBC

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.