jsp+access ²éѯ²»³ö½á¹û
<% request.setCharacterEncoding("gb2312");%>
<%
String Recordset__t1 = "0";
if (request.getParameter("items") !=null) {Recordset__t1 = (String)request.getParameter("items");}
%>
<%
String Recordset__t2 = "0";
if (request.getParameter("search") !=null) {Recordset__t2 = (String)request.getParameter("search") ;}
%>
<%
Driver DriverRecordset = (Driver)Class.forName(MM_conn_DRIVER).newInstance();
Connection ConnRecordset = DriverManager.getConnection(MM_conn_STRING,MM_conn_USERNAME,MM_conn_PASSWORD);
PreparedStatement StatementRecordset = ConnRecordset.prepareStatement("SELECT * from Publisher WHERE ? like ? ORDER BY newsdata DESC");
StatementRecordset.setObject(1, Recordset__t1);
StatementRecordset.setObject(2, "%" + Recordset__t2 + "%");
ResultSet Recordset = StatementRecordset.executeQuery();
boolean Recordset_isEmpty = !Recordset.next();
boolean Recordset_hasData = !Recordset_isEmpty;
Object Recordset_data;
int Recordset_numRows = 0;
%>
Ϊʲô²é²»³ö½á¹ûÄØ£¿ÄǸösqlÓï¾äÓÐÎÊÌâô¡·Ó¦¸ÃÔõôÐÞ¸ÄÄØ
´íÎóÌáʾÌùһϡ£¡£¡£¡£¡£
ÎÞ´íÎ󣬾ÍÊDzéѯ²»³ö
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃSTRUTS £¬×öÁËÒ»¸öJSPÒ³Ãæ£¬Ìá½»ºóûÓдæÈëÊý¾Ý¿â¡£
JSP´úÂëÈçÏ£º
aa.jsp´úÂë
<%@ page contentType="text/html;charset=gb2312" language="java"%>
<%@ taglib uri=" ......
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
org.apache.jas ......
ÎÊÌâÊÇÕâÑùµÄ£º
ÎÒÓÐÒ»¸öÎļþnagiv.jsp ÁíÒ»¸öÎļþfailure.jsp°üº¬Ëû£¬Í¬Ê±nagivÎļþÖÐÓÐÒ»¸ö¿ÉÒÔÌø×ªµ½yy.jspµÄcommandButton£¬µ«ÊÇÎÒ½«failureÖеã»÷nagivÖеÄÄĸöcommandButton£¬Ò²Ãæ²»»áÌø×ª ......
×î½üÓöµ½Ò»Ð© jspÒ³ÃæµÄȡֵ¡£Ã»Óмû¹ý¡£Ò²²»ÖªµÀʲôÒâ˼¡£ÄÄλ´óÏÀ¸øÎÒ˵˵ ȡֵµÄÖÖÀàºÍ·½·¨°¡
request.getParameter£¬»òÕßÓÃbean£¬¼´ÔÚjspÒ³ÃæÖÐÉùÃ÷jsp:usebeanÖ®ºó¿ÉÒÔÖ±½Ósetproperty »òÕßgetproperty¡£Ò ......