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éѯ²»³ö
Ïà¹ØÎÊ´ð£º
ÓÐÒ»¸öÊý¾Ý¿âÀïÖ»ÓÐ2WÌõÊý¾Ý²»µ½£¬È´ÓÐ500MÄÇô´ó,Ôõô»ØÊ°¡£¿ÊÇACCESSµÄÊý¾Ý¿â¡£ºóÀ´ÎÒ°ÑACCESSµ¼Èëµ½MSSQLÖУ¬Ò²Õ¼ÓÃÁË500M×óÓҵĿռ䣬Èç¹ûѹËõÊý¾Ý¿âÄØ£¿Çë¸ßÊÖÖ¸µã
ѹËõÊý¾Ý¿â£¿ÄÜ×öµ½Ã´...
ÆÚ´ý¸ßÈËÖ¸µã ÎÒ ......
Óû§µÇ¼ϵͳ¾Í¿ÉÒÔÔÚÓÒϽǵ¯³ö×Ô¼ºÊÕµ½µÄÏûÏ¢Ìáʾ¿ò
ÇëÎʸ÷λ´ó¸çÕâ¸öÔÚǰ¶ËÈçºÎʵÏֱȽϺã¬ÐÔÄÜÓÅÏÈ
ÎÒµÄ˼·ÊÇ£º1.ǰ¶Ëͨ¹ýajax¼¼Êõ¸ôÒ»¶Îʱ¼äÇëÇóһϺǫ́£¬²é¿´µ±Ç°µÇ¼ÈËÊÇ·ñÓÐÏûÏ¢£¬Èç¹ûÓУ¬ÔòÏÔʾÒþ²ØµÄ ......
×î½üÓöµ½Ò»Ð© jspÒ³ÃæµÄȡֵ¡£Ã»Óмû¹ý¡£Ò²²»ÖªµÀʲôÒâ˼¡£ÄÄλ´óÏÀ¸øÎÒ˵˵ ȡֵµÄÖÖÀàºÍ·½·¨°¡
request.getParameter£¬»òÕßÓÃbean£¬¼´ÔÚjspÒ³ÃæÖÐÉùÃ÷jsp:usebeanÖ®ºó¿ÉÒÔÖ±½Ósetproperty »òÕßgetproperty¡£Ò ......
jspÒ³ÃæÖеÄJava±äÁ¿³ö´í£¬ÇëÎÊÒ»ÏÂJavaµÄ¸ßÊÖÃÇ£¬ÈçºÎ½â¾ö£¿ÐèÒªÌí¼ÓÄĸöjar°ü
<logic:notEqual name="parts" property="checkStatus2" value="1">
<label for ......