(标签-前端|关键词-SET)

Question

在该项目前端提交学生信息 到这个函数块进行数据库中相应表的更新 报错显示sql语句有语法错误
想不明白问题出现在哪 哪位朋友可以帮忙看一下
以下是报错信息
java.sql.SQLException: com.microsoft.sqlserver.jdbc.SQLServerException: “,”附近有语法错误。 Query: UPDATE stureport SET telephone = ?,to_date = ?,to_time = ?,transport = ?,transport_num = ?,trsp_remark = ?,is_loan = ?,loan_amount = ?,loan_pay = ?,pay_way = ?,pay_remark = ?,is_photo = ? WHERE r_id = ?; Parameters: [117762149360, Fri Oct 27 00:00:00 CST 2023, Thu Jan 01 17:25:00 CST 1970, null, null, null, 0, null, null, null, null, 0, 201909601260]

 @Override
    public int updateNewStu(Report report) {
        Object[] params = { report.getTelephone(),report.getTo_date(),report.getTo_time(),report.getTransport(),
                report.getTransport_num(),report.getTrsp_remark(),report.getIs_loan(),report.getLoan_amount(),
                report.getLoan_pay(),report.getPay_way(),report.getPay_remark(),report.getIs_photo(),
                report.getR_id()
        };
        String sql =
                "UPDATE stureport SET telephone = ?,to_date = ?,to_time = ?,transport = ?,transport_num = ?,trsp_remark = ?,is_loan = ?," +
                        "loan_amount = ?,loan_pay = ?,pay_way = ?,pay_remark = ?,is_photo = ? WHERE r_id = ?;";
        try {
            int result = queryRunner.update(sql, params);
//                try {
//                FileWriter fileWriter = new FileWriter("D:/SoftwareEngineer/新生报到系统/output.txt"); // 指定要保存的文件路径
//                fileWriter.write(String.valueOf(result)); // 将字符串写入文件
//                fileWriter.close(); // 关闭文件写入流
//            }catch(IOException d){
//                d.printStackTrace();
//            }
            return result;
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return 0;
    }

Answer 1

语法看起来没啥问题，感觉可能是日期 “Fri Oct 27 00:00:00 CST 2023“，” Thu Jan 01 17:25:00 CST 1970”这两个你看看怎么转换下？