2 回答

TA貢獻(xiàn)1828條經(jīng)驗(yàn) 獲得超3個(gè)贊
我認(rèn)為您不能同時(shí)運(yùn)行這兩個(gè):
if(null != jdbcTemplate) {
// Performing The Sql 'Insert' Operation
String sql = "insert into patient(id_patient, description) values(?,?);" +
"insert into attachment(id_data, file_data, patientID) values (?, ?, (select patientID from patient where patientID = id_patient));";
jdbcTemplate.update(sql, patient.getDescription(), attachment.getId_data(), attachment.getData(), attachment.getPatientID());
也許嘗試:
if(null != jdbcTemplate) {
// Performing The Sql 'Insert' Operation
String sql = "insert into patient(id_patient, description) values(?,?);";
String sqlTwo = "insert into attachment(id_data, file_data, patientID) values (?, ?, (select patientID from patient where patientID = id_patient));";
jdbcTemplate.update(sql, patient.getDescription(), attachment.getId_data(), attachment.getData(), attachment.getPatientID());
jdbcTemplate.update(sqlTwo, patient.getDescription(), attachment.getId_data(), attachment.getData(), attachment.getPatientID());
還
您不能使用嵌套子查詢(xún)綁定參數(shù):
values (?, ?, (select patientID from patient where patientID = id_patient))
添加回答
舉報(bào)