谁帮我看看这个程序蛮

Question

stat.executeUpdate("update Medical set 姓名='" + txtName.getText()+
                                 "set 性别=" + txtSex.getText() +
                                 "set 入院日期=" + txtInDate.getText() +
                                 "set 医师=" + txtDoc.getText() +
                                 "set 病人所属单位=" + txtUnit.getText() +
                                 "set 所属科室=" + txtDep.getText() +
                                 "set 年龄=" + txtAge.getText() +
                                 "set 总费用=" + txtTotal.getText()+
                                 "set 病情="+ txtCase.getText() +
                                 "set 出院日期=" + txtOutDate.getText() +"where 床号="+ txtNumbed.getText() + "'"); // 更新Medical表中学号相关的记录
这个程序没有实现更新的作用啊

Answer 1

stat.executeUpdate("update Medical set 姓名='" + txtName.getText()+
                                 "',性别='" + txtSex.getText() +
                                 "',入院日期='" + txtInDate.getText() +
                                 "', 医师='" + txtDoc.getText() +
                                 "', 病人所属单位='" + txtUnit.getText() +
                                 "', 所属科室='" + txtDep.getText() +
                                 "',年龄='" + txtAge.getText() +
                                 "', 总费用='" + txtTotal.getText()+
                                 "', 病情='"+ txtCase.getText() +
                                 "', 出院日期='" + txtOutDate.getText() +"' where 床号='"+ txtNumbed.getText() + "'");