请各位大神,帮忙看看这是什么问题,明天中期检查。。求指点
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'use,remarks,time)values('258','璐㈡斂閮?,'寮犱竴','100','','',now())' at line 1请问下这是什么问题?下面是代码:
amount=new String(t[1].getText());
use=new String(t[3].getText());
remarks=new String(t[5].getText());
System.out.println(s1+s2+amount+use+remarks);
s = "insert into borrow(id,department,borroworapply,amount,use,remarks,time)values(?,?,?,?,?,?,now())";
ps = conn.prepareStatement(s);
ps.setString(1,Main.s1);ps.setString(2,s1);ps.setString(3,s2);
ps.setString(4,amount);ps.setString(5,use);ps.setString(6,remarks);
ps.executeUpdate();