java - 爪哇，db2。在同一列中插入下拉列表和复选框值

Question

//these are previous dropdown form variables
private int firstname;
private int lastname;

setters and getters for above variables

//my new checkbox form variables
private int ck1;
private int ck2;

//setters and getters 


//query to insert

insert into TEST(private int firstname, lastname, ck1, ck2)
values(?,?,?,?);

//update query 
update TEST set firstname=?, lastname=?, ck1=?, ck2=?
where id=name;

//i do not have any column ck1, ck2 in test table . i am trying to insert ck1,ck2 values in pre-existing column which are firstname, lastname (these  columns also hold values for firtname and lastname variables and now trying to insert values for ck1 and ck2 and thats where i am stuck) .

伙计们，我需要一些建议。假设我有一个包含两列的表——“名字”和“姓氏”，它们存储下拉列表中的值。现在我有一个 2 复选框，我需要将值存储在相同的列（姓氏、名字）中。为了将值保存在同一列中，我有 2 个带有 setter 和 getter 的表单变量（“check1”、“check2”）。现在我有点卡住了，请指导我如何将复选框值存储在同一列中的下拉列表中。

标签： javasql

Answer 1

UPDATE 语句的语法是

UPDATE TEST SET firstname = value1, lastname = value2

如果 firstname 和 lastname 是TEXT或VARCHAR将它们的值括在撇号中 like'this'
和 not

update TEST set firstname=?, lastname=?, ck1=?, ck2=?