通过sql语句查询出来然后存储到结果集里,然后从HTML里面显示出来
解决方案 »
- spring quartz并发问题 求教!
- Struts 1.X 頁面加載問題
- 向A发送请求,同时传送用户名给A,A根据用户名返回密码,并显示在页面上,怎么实现(已知A的url和接口协议)
- 一个JMS系统技术方案选型的问题,来者有分,不够再开帖
- 请教一算法问题。。。。
- 请教一个jsp小问题,谢谢大家了!!!!!!!!
- 高分求GB 8566 计算机软件开发规范文档
- 关于EJB编译的问题
- ssh struts2 表单注入问题
- 菜鸟求问jpa/spring的@Resource的原理是怎样的
- 使用WebSphere做应用服务器,Tomcat做为web服务器,servlet怎样访问EJB?
- 浏览器提示:不支持嵌入式框架,或被配置为不显示嵌入式框架,请问怎么显示呀?
我现在是这样写的:String MN=request.getParameter("MoNumber");
ResultSet rs=stmt.executeQuery("select * from Table where PAMONO=MN");while(rs.next()) {%>
<table>
<tr>
<td>
Mo.Number:<%=rs.getString("PAMONO")%>
Line:<%=rs.getString(15)%>
Model Name:<%=rs.getString(22) %>
Mo.Lot.No.:<%=rs.getString(24) %>
可是不对阿!
通过sql语句查询出来然后存储到结果集里,然后从HTML里面显示出来
--------------------
小马哥:ResultSet rs=stmt.executeQuery("select * from Table where PAMONO=MN");
这样子对吗?
你给的代码又不全
连接的一些东东省虐掉...
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String MN=request.getParameter("MoNumber");String sql="select * from ZEP0A0P where PAMONO=MN"; ResultSet rs=stmt.executeQuery(sql); while(rs.next()) {%>
<table>
<tr>
<td>
Mo.Number:<%=rs.getString("PAMONO")%>
</td></tr>
<tr>
<td>
Line:<%=rs.getString(15)%>
</td></tr>
<tr>
<td>
Model Name:<%=rs.getString(22) %>
</td></tr>
<tr>
<td>
Mo.Lot.No.:<%=rs.getString(24) %>
</td>
</tr>
<tr>
<td>
Qty:<%=rs.getString(25) %>
</td>
</tr>
<hr>
<%}%> <%out.print("数据库操作成功,恭喜你");%> <%rs.close(); stmt.close(); conn.close(); %> </body> </html>
费劲等了,想要解答加群吧。
QQ群:13020336
---------------------------------------
你太好了!现在我们公司把QQ和MSN给屏蔽掉了,晚上来加
String MN=request.getParameter("MoNumber");String sql="select * from ZEP0A0P where PAMONO=MN"; 整个程序都是KAO过来的,我就改了上面几句...
pe Exception reportmessage description The server encountered an internal error () that prevented it from fulfilling this request.exception javax.servlet.ServletException: [SQL0206] 轼MN馵!R$?x.礼R錉
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:867)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:800)
org.apache.jsp.result_jsp._jspService(result_jsp.java:129)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:133)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:311)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:301)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:248)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
root cause java.sql.SQLException: [SQL0206] 轼MN馵!R$?x.礼R錉
com.ibm.as400.access.JDError.throwSQLException(JDError.java:533)
com.ibm.as400.access.JDError.throwSQLException(JDError.java:504)
com.ibm.as400.access.AS400JDBCStatement.commonPrepare(AS400JDBCStatement.java:1302)
com.ibm.as400.access.AS400JDBCStatement.executeQuery(AS400JDBCStatement.java:1733)
org.apache.jsp.result_jsp._jspService(result_jsp.java:68)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:133)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:311)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:301)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:248)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
note The full stack trace of the root cause is available in the Tomcat logs.