Created
October 19, 2019 16:30
-
-
Save Nahasean94/6aebc5b86d0f7922aab66d4a791f5a5a to your computer and use it in GitHub Desktop.
Calling a stored procedure from Spring boot using JDBC template
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
import org.springframework.beans.factory.annotation.Autowired; | |
import org.springframework.jdbc.core.JdbcTemplate; | |
import org.springframework.jdbc.core.namedparam.MapSqlParameterSource; | |
import org.springframework.jdbc.core.namedparam.SqlParameterSource; | |
import org.springframework.jdbc.core.simple.SimpleJdbcCall; | |
import org.springframework.stereotype.Repository; | |
import javax.annotation.PostConstruct; | |
import javax.sql.DataSource; | |
import java.util.Map; | |
@Repository | |
public class DatabaseImpl implements RegistrationDao { | |
@Autowired | |
DataSource dataSource; | |
private JdbcTemplate jdbcTemplate; | |
private SimpleJdbcCall spStoreTempData; | |
@PostConstruct | |
private void postConstruct() { | |
jdbcTemplate = new JdbcTemplate(dataSource); | |
spStoreTempData = new SimpleJdbcCall(jdbcTemplate).withProcedureName("STMT_TEMP_STORE"); | |
} | |
@Override | |
public Map<String, Object> storeTempData(String V_USER_TYPE, String V_REFID, String V_PHONE, String V_SCODE, String V_ID_NUMBER, String V_EMAIL, | |
String V_TNC, String V_CHANNEL, String V_TEMP_UUID, String V_TOTP, String V_TOTP_EXPPERIOD, String V_SVC_TYPE, String V_REASON, String V_MAX_RETRIES) { | |
SqlParameterSource in = new MapSqlParameterSource() | |
.addValue("V_USER_TYPE", V_USER_TYPE) | |
.addValue("V_REFID", V_REFID) | |
.addValue("V_PHONE", V_PHONE) | |
.addValue("V_SCODE", V_SCODE) | |
.addValue("V_ID_NUMBER", V_ID_NUMBER) | |
.addValue("V_EMAIL", V_EMAIL) | |
.addValue("V_TNC", V_TNC) | |
.addValue("V_CHANNEL", V_CHANNEL) | |
.addValue("V_TEMP_UUID", V_TEMP_UUID) | |
.addValue("V_TOTP", V_TOTP) | |
.addValue("V_TOTP_EXPPERIOD", V_TOTP_EXPPERIOD) | |
.addValue("V_SVC_TYPE", V_SVC_TYPE) | |
.addValue("V_REASON", V_REASON) | |
.addValue("V_MAX_RETRIES", V_MAX_RETRIES); | |
return spStoreTempData.execute(in); | |
} | |
} | |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment