28

Calling Stored Procedure That Returns A Result Set Via JdbcTemplate

 4 years ago
source link: https://github.com/AnghelLeonard/Hibernate-SpringBoot/tree/master/HibernateSpringBootCallStoredProcedureJdbcTemplate
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.

Calling Stored Procedure That Returns A Result Set Via JdbcTemplate

Note:Most probably you'll like to process the result set via BeanPropertyRowMapper as here . This is less verbose than the approach used here. Nevertheless, this approach is useful to understand how the result set looks like.

Description:This application is an example of calling a MySQL stored procedure that returns a result set via JdbcTemplate .

Key points:

  • rely on JdbcTemplate and SimpleJdbcCall
If you need a deep dive into the performance recipes exposed in this repository then I am sure that you will love my book "Spring Boot Persistence Best Practices" If you need a hand of tips and illustrations of 100+ Java persistence performance issues then "Java Persistence Performance Illustrated Guide" is for you. VBZjay7.jpg!webZVZvUve.jpg!web

About Joyk


Aggregate valuable and interesting links.
Joyk means Joy of geeK