标题:请各位大神,帮忙看看这是什么问题,明天中期检查。。求指点
只看楼主
晴雨天
Rank: 1
等 级:新手上路
帖 子:1
专家分:0
注 册:2014-3-14
 问题点数:0 回复次数:0 
请各位大神,帮忙看看这是什么问题,明天中期检查。。求指点
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();
搜索更多相关主题的帖子: version manual server amount values 
2014-03-14 20:40



参与讨论请移步原网站贴子:https://bbs.bccn.net/thread-428534-1-1.html




关于我们 | 广告合作 | 编程中国 | 清除Cookies | TOP | 手机版

编程中国 版权所有,并保留所有权利。
Powered by Discuz, Processed in 0.389122 second(s), 8 queries.
Copyright©2004-2024, BCCN.NET, All Rights Reserved