Giuseppa Cefalu wrote:The result is update tablename set varciable1 = number, variable2 = 'string', variable3 = 'date', variable4 = number where pkey = number;
Giuseppa Cefalu wrote:But coul I create PreparedStatement ps = conn.prepareStatement(
"UPDATE Messages SET description = ?, author = ? WHERE id = ? AND seq_num = ?"); using a loop?
Would using a loop in the following way work? for(in i = 0; i < N; i++){ "UPDATE Messages SET variable_name = ? WHERE id = ?) and then ps.setDataType(i, variableName)?
}
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime. |