Skip to content

Instantly share code, notes, and snippets.

@Nahasean94
Created October 19, 2019 16:30
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save Nahasean94/6aebc5b86d0f7922aab66d4a791f5a5a to your computer and use it in GitHub Desktop.
Save Nahasean94/6aebc5b86d0f7922aab66d4a791f5a5a to your computer and use it in GitHub Desktop.
Calling a stored procedure from Spring boot using JDBC template
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