jsp call ´æ´¢¹ý³ÌÎÊÌâ
Èç¹û´æ´¢¹ý³ÌÀïÓд´½¨ÁÙʱ±í£¬»òÕßdeclare @t table()Ö®ÀàµÄ£¬
ÓÃstmt.executequery('exec procedurename')»á³öÏÖ
"The statement did not return a result set."
´íÎ󣬴ó¼ÒÊÇÔõô½â¾öµÄ£¿
лл
²»¶®£¬°ï¶¥
call = connection.prepareCall("{call procedureName(?)}");
Procedure ÀïÃæÓзµ»Ø¼Í¼£¬
call¿ÉÒÔÒ»ÌõÒ»ÌõÈ¡³öÀïÃæµÄ¼Í¼²»£¿
executequery£¿ËµÃ÷Õâ¸ö´æ´¢¹ý³Ì¸ù±¾ÎÞ½á¹û¶øÑÔ¡£
conn.prepareCall È»ºóÔÙexecuteUpdate£» Èç¹ûÓнá¹û ÓÃÄǸö
{{
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃSTRUTS £¬×öÁËÒ»¸öJSPÒ³Ãæ£¬Ìá½»ºóûÓдæÈëÊý¾Ý¿â¡£
JSP´úÂëÈçÏ£º
aa.jsp´úÂë
<%@ page contentType="text/html;charset=gb2312" language="java"%>
<%@ taglib uri=" ......
<%@page language="java" contentType="text/html;charset=gb2312" import="java.sql.*"%>
<jsp:useBean id="db" class="wang.connectDB"/>
< ......
jsÖеķ½·¨£¬²»ÄÜÔÚjspÖе÷ÓÃÔõô½â¾ö£¿¼±£¡£¡!
²»Ã÷°×Òâ˼
ºÃºÃ¼ì²éÊDz»ÊÇ·¾¶µÄÎÊÌ⣬ºÜÓпÉÄÜ·¾¶²»¶Ôµ¼Öµ÷Óò»µ½
Ìùһϵ÷ÓõĴúÂë¿´¿´°¡~~
ÓÐûÓÐÕýÈ·ÒýÓÃjs£¿º¯ÊýÓÐûÓгõʼ»¯£¿....
jsp´úÂë±¾À´¾ ......
ÎÊÌâÃèÊö£º
ÀýÈçÎÒÒªÏÔʾµÄÄÚÈÝÈçÏÂËùʾ
Ò»¼¶Ä¿Â¼1
Ò»¼¶Ä¿Â¼1×ÓÀà1
×ÓÀà1
Ò»¼¶Ä¿Â¼1×ÓÀà2
......