SQL server语句查询，加'

Question

SQL server语句查询，加'

String UpdateSql = "update RegularEmployeeWorkLog set Remark = '..........' where now_time = ? ";
                ps = conn.prepareStatement(UpdateSql);
                ps.setDate(1,date);
                ps.executeUpdate();

date是一个日期，例如：2023-04-04 07:55:38，运行出来是 now_time= 2023-04-04 07:55:38 ,不是now_time= '2023-04-04 07:55:38'
少了'一直报错，请问有什么办法可以加上'

Answer 1

sql中加上单引号就好了，拼接一下
String UpdateSql = "update RegularEmployeeWorkLog set Remark
= '..........' where now_time = '"+?+"'";
                ps = conn.prepareStatement(UpdateSql);
                ps.setDate(1,date);
                ps.executeUpdate();