数据库里面一个类型为int 的列orderid
页面部分关键代码:
ResultSet rs_orderid=conn.executeQuery("select orderid,status from order_item where username='"+session.getAttribute("username")+"' and teaid='"+session.getAttribute("shangpin")+"' and number='"+number+"' and price='"+price+"' ");
int orderid=rs_orderid.getInt(1);
int status=rs_orderid.getInt(2);出现下面的错误:org.apache.jasper.JasperException: Exception in JSP: /page/memcenter/dingdan.jsp:238235: int rows=conn.executeUpdate(sql);
236:
237: ResultSet rs_orderid=conn.executeQuery("select orderid,status from order_item where username='"+session.getAttribute("username")+"' and teaid='"+session.getAttribute("shangpin")+"' and number='"+number+"' and price='"+price+"' ");
238: int orderid=rs_orderid.getInt(1);
239: int status=rs_orderid.getInt(2);
240: %>
241: <tr>
Stacktrace:
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:506)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
起 因 javax.servlet.ServletException: [Microsoft][SQLServer 2000 Driver for JDBC]Value can not be converted to requested type.
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:843)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:776)
org.apache.jsp.page.memcenter.dingdan_jsp._jspService(dingdan_jsp.java:400)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:334)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
大家帮我看下,该怎么改才是正确的??
页面部分关键代码:
ResultSet rs_orderid=conn.executeQuery("select orderid,status from order_item where username='"+session.getAttribute("username")+"' and teaid='"+session.getAttribute("shangpin")+"' and number='"+number+"' and price='"+price+"' ");
int orderid=rs_orderid.getInt(1);
int status=rs_orderid.getInt(2);出现下面的错误:org.apache.jasper.JasperException: Exception in JSP: /page/memcenter/dingdan.jsp:238235: int rows=conn.executeUpdate(sql);
236:
237: ResultSet rs_orderid=conn.executeQuery("select orderid,status from order_item where username='"+session.getAttribute("username")+"' and teaid='"+session.getAttribute("shangpin")+"' and number='"+number+"' and price='"+price+"' ");
238: int orderid=rs_orderid.getInt(1);
239: int status=rs_orderid.getInt(2);
240: %>
241: <tr>
Stacktrace:
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:506)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
起 因 javax.servlet.ServletException: [Microsoft][SQLServer 2000 Driver for JDBC]Value can not be converted to requested type.
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:843)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:776)
org.apache.jsp.page.memcenter.dingdan_jsp._jspService(dingdan_jsp.java:400)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:334)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
大家帮我看下,该怎么改才是正确的??
解决方案 »
- 投票限制方法
- 如何检查用户名已经存在
- 急,html servlet配置问题
- 求jsp--获取列表框list值显示的功能---在线等--即刻给分
- tomcat6.0在使用System.out.println("aa")的时候,我在哪里可以看的到aa?测试用
- 一个局部刷新的问题???????????答者有分!!!!高分酬谢!!!!!!!!!!
- 关于分词搜索
- 关于聊天室
- 我在JB中编写Servlet,为什么在第一次请求时,其会再调用init()?
- 一个关于菜单的问题(很初级的,我才学jsp),请帮忙,谢谢!
- FCK上传时出现的问题:the server didn't send back a proper XML response.
- 纯页面的问题.
status 也为int类型吗
和数据类型错误 自己好好看看
int orderid=rs_orderid.getInt("orderid");
int status=rs_orderid.getInt("status");
(orderid,status对应数据库字段)
1 . Class.forName( )
2. connection conn = DriverManager.getConnection()
3. preparedstatement ppstmt = conn.prepareStatement(sql)
4.ResultSet rs = ppstmt.executeQuery( )
5. rs.next( ). //要移动游标才能取到值
connDB conn=new connDB();
ResultSet rs_new=conn.executeQuery("select name,price from tea where id='"+session.getAttribute("shangpin")+"'");
while(rs_new.next()){
String name=rs_new.getString(1);
float price=rs_new.getFloat(2);String n=request.getParameter("num");
int number= Integer.parseInt(n) ;
float all=price*number;
String sql="insert into order_item ( username,teaid,number,price) Values('"+session.getAttribute("username")+"', '"+session.getAttribute("shangpin")+"' ,'"+number+"','"+price+"')";
int rows=conn.executeUpdate(sql);ResultSet rs_orderid=conn.executeQuery("select orderid,status from order_item where username='"+session.getAttribute("username")+"' and teaid='"+session.getAttribute("shangpin")+"' and number='"+number+"' and price='"+price+"' ");
int orderid=rs_orderid.getInt(1);
int status=rs_orderid.getInt(2);
%>
int orderid=rs_orderid.getInt(1);
int status=rs_orderid.getInt(2);
}