我想查找货物重量在5-10kg范围的货物运送单价。我建了一个重量价格表:
create table weighprice(
weightid int not null,
ranUp int null, // 重量上限
ranDn int null, //重量下限
price float null, //价格
primary key (weightid)); String weight = request.getParameter("weight");
Integer weigh = Integer.parseInt(weight);
int we = weigh.intValue();
String SqlQue="select wp.price from weighprice wp "
+"where wp.ranDn <"+ we + "and wp.ranUp >" + we;
错误:
exception javax.servlet.ServletException: 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 'wp.ranUp >8' at line 1
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:825)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:758)
org.apache.jsp.priceSearch_jsp._jspService(priceSearch_jsp.java:128)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:298)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
create table weighprice(
weightid int not null,
ranUp int null, // 重量上限
ranDn int null, //重量下限
price float null, //价格
primary key (weightid)); String weight = request.getParameter("weight");
Integer weigh = Integer.parseInt(weight);
int we = weigh.intValue();
String SqlQue="select wp.price from weighprice wp "
+"where wp.ranDn <"+ we + "and wp.ranUp >" + we;
错误:
exception javax.servlet.ServletException: 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 'wp.ranUp >8' at line 1
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:825)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:758)
org.apache.jsp.priceSearch_jsp._jspService(priceSearch_jsp.java:128)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:298)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
解决方案 »
- 一张图片地址连接N次tomcat
- jsp乱码
- 大侠们教我!
- 奇怪了!JSP分页问题为什么获取不到page
- 大家帮我看下这是什么错啊~? struts2 的!
- jsp里,当一个函数执行3秒后,自动执行另一个函数,如何解决?
- 一个初级的问题:编译文件 出现错误package com.microsoft.jdbc.sqlserver does not exist
- 谁有JSP用的在线编辑器代码?
- struts2怎么样用ajax传输接受集合(集合的内容已经获取到了)
- 一个tomcat 的问题(入门级)
- Tomcat5.0.28启动时出现Error filterStart 急急!!!!!!!!!!!
- 关于手机短信开发的几个问题-----女工程师问问题。。。
+"where wp.ranDn <"+ we + " and wp.ranUp >" + we;在and wp.ranUp 加个空格,是你的
语句出了问题