sql语句查询天气数据库,sql语句如下
String currentDaySql ="select week,date_Solar,date_Lunar,weather,temperature,wind" +
"from table_currentday" +
"where cityName like '%" + cityName + "%'";
执行这个语句时,MyEclipse控制台老是提示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 'cityName like '%浦东%'' at line 1,可问题是我在mysql中执行这条语句是没问题的啊,怎么回事啊??
String currentDaySql ="select week,date_Solar,date_Lunar,weather,temperature,wind" +
"from table_currentday" +
"where cityName like '%" + cityName + "%'";
执行这个语句时,MyEclipse控制台老是提示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 'cityName like '%浦东%'' at line 1,可问题是我在mysql中执行这条语句是没问题的啊,怎么回事啊??
解决方案 »
- MQ是单独使用还是要部署到J2EE服务器中?
- 因为JAVA,日子过得很慌张——中专生
- 数据库主键问题
- 在telnet中设置了本地回显后,再次打开又关闭了本地回显,怎么办呢?
- 请教tomcat http用户认证的问题
- 关于重启tomcat的问题?
- 为什么在JTable的tableChanged(TableModelEvent e),用model.setValueAt()会出现 异常?
- 单机双tomcat无需Apache,怎么配置?高手请进
- 我的JSP文件可以在默认目录下运行,我想让JSP文件在我指定的目录下运行,CONFIG.XML文件要怎么样配置?
- 新人写项目,service方面求问啊
- 高分求解: java如何从表达式中分离出变量
- 关于Session 的问题?
"from table_currentday" +
"where cityName like '%" + cityName + "%'";改成
String currentDaySql ="select week,date_Solar,date_Lunar,weather,temperature,wind" +
" from table_currentday" +
" where cityName like '%" + cityName + "%'"; from,where前面都加个空格试试。
然后就会发现sql语句的,from,where前后没有空格。
"from table_currentday" +
"where cityName like '%" + cityName + "%'";解决问题的办法啊,不能从代码中看出就输出 sql 语句来放到 MySql 客户端执行下就知道了,有几个地方少了空格啊。String currentDaySql ="select week,date_Solar,date_Lunar,weather,temperature,wind" +
" from table_currentday" +
" where cityName like '%" + cityName + "%'";而且用户输入一个单引号,或是其他的 sql 注入咋办!
" from table_currentday" +
" where cityName like '%" + cityName + "%'";