字典的设计界面.docx
- 文档编号:18321048
- 上传时间:2023-08-15
- 格式:DOCX
- 页数:11
- 大小:77.17KB
字典的设计界面.docx
《字典的设计界面.docx》由会员分享,可在线阅读,更多相关《字典的设计界面.docx(11页珍藏版)》请在冰点文库上搜索。
字典的设计界面
字典的设计界面
代码如下:
<%@pagecontentType="text/html;charset=gb2312"language="java"import="java.sql.*"errorPage=""%>
<%@includefile="Connections/myconnection.jsp"%>
<%
DriverDriverRecordset1=(Driver)Class.forName(MM_myconnection_DRIVER).newInstance();
ConnectionConnRecordset1=DriverManager.getConnection(MM_myconnection_STRING,MM_myconnection_USERNAME,MM_myconnection_PASSWORD);
PreparedStatementStatementRecordset1=ConnRecordset1.prepareStatement("SELECT*FROMtest.dict");
ResultSetRecordset1=StatementRecordset1.executeQuery();
booleanRecordset1_isEmpty=!
Recordset1.next();
booleanRecordset1_hasData=!
Recordset1_isEmpty;
ObjectRecordset1_data;
intRecordset1_numRows=0;
%>
<%
intRepeat1__numRows=10;
intRepeat1__index=0;
Recordset1_numRows+=Repeat1__numRows;
%>
<%
//***RecordsetStats,MoveToRecord,andGoToRecord:
declarestatsvariables
intRecordset1_first=1;
intRecordset1_last=1;
intRecordset1_total=-1;
if(Recordset1_isEmpty){
Recordset1_total=Recordset1_first=Recordset1_last=0;
}
//setthenumberofrowsdisplayedonthispage
if(Recordset1_numRows==0){
Recordset1_numRows=1;
}
%>
<%StringMM_paramName="";%>
<%
//***MoveToRecordandGoToRecord:
declarevariables
ResultSetMM_rs=Recordset1;
intMM_rsCount=Recordset1_total;
intMM_size=Recordset1_numRows;
StringMM_uniqueCol="";
MM_paramName="";
intMM_offset=0;
booleanMM_atTotal=false;
booleanMM_paramIsDefined=(MM_paramName.length()!
=0&&request.getParameter(MM_paramName)!
=null);
%>
<%
//***MoveToRecord:
handle'index'or'offset'parameter
if(!
MM_paramIsDefined&&MM_rsCount!
=0){
//useindexparameterifdefined,otherwiseuseoffsetparameter
Stringr=request.getParameter("index");
if(r==null)r=request.getParameter("offset");
if(r!
=null)MM_offset=Integer.parseInt(r);
//ifwehavearecordcount,checkifwearepasttheendoftherecordset
if(MM_rsCount!
=-1){
if(MM_offset>=MM_rsCount||MM_offset==-1){//pastendormovelast
if(MM_rsCount%MM_size!
=0)//lastpagenotafullrepeatregion
MM_offset=MM_rsCount-MM_rsCount%MM_size;
else
MM_offset=MM_rsCount-MM_size;
}
}
//movethecursortotheselectedrecord
inti;
for(i=0;Recordset1_hasData&&(i Recordset1_hasData=MM_rs.next(); } if(! Recordset1_hasData)MM_offset=i;//setMM_offsettothelastpossiblerecord } %> <% //***MoveToRecord: ifwedontknowtherecordcount,checkthedisplayrange if(MM_rsCount==-1){ //walktotheendofthedisplayrangeforthispage inti; for(i=MM_offset;Recordset1_hasData&&(MM_size<0||i Recordset1_hasData=MM_rs.next(); } //ifwewalkedofftheendoftherecordset,setMM_rsCountandMM_size if(! Recordset1_hasData){ MM_rsCount=i; if(MM_size<0||MM_size>MM_rsCount)MM_size=MM_rsCount; } //ifwewalkedofftheend,settheoffsetbasedonpagesize if(! Recordset1_hasData&&! MM_paramIsDefined){ if(MM_offset>MM_rsCount-MM_size||MM_offset==-1){//checkifpastendorlast if(MM_rsCount%MM_size! =0)//lastpagehaslessrecordsthanMM_size MM_offset=MM_rsCount-MM_rsCount%MM_size; else MM_offset=MM_rsCount-MM_size; } } //resetthecursortothebeginning Recordset1.close(); Recordset1=StatementRecordset1.executeQuery(); Recordset1_hasData=Recordset1.next(); MM_rs=Recordset1; //movethecursortotheselectedrecord for(i=0;Recordset1_hasData&&i Recordset1_hasData=MM_rs.next(); } } %> <% //***MoveToRecord: updaterecordsetstats //setthefirstandlastdisplayedrecord Recordset1_first=MM_offset+1; Recordset1_last=MM_offset+MM_size; if(MM_rsCount! =-1){ Recordset1_first=Math.min(Recordset1_first,MM_rsCount); Recordset1_last=Math.min(Recordset1_last,MM_rsCount); } //setthebooleanusedbyhideregiontocheckifweareonthelastrecord MM_atTotal=(MM_rsCount! =-1&&MM_offset+MM_size>=MM_rsCount); %> <% //***GoToRecordandMoveToRecord: createstringsformaintainingURLandFormparameters StringMM_keepBoth,MM_keepURL="",MM_keepForm="",MM_keepNone=""; String[]MM_removeList={"index",MM_paramName}; //createtheMM_keepURLstring if(request.getQueryString()! =null){ MM_keepURL='&'+request.getQueryString(); for(inti=0;i =0;i++){ intstart=MM_keepURL.indexOf(MM_removeList[i])-1; if(start>=0&&MM_keepURL.charAt(start)=='&'&& MM_keepURL.charAt(start+MM_removeList[i].length()+1)=='='){ intstop=MM_keepURL.indexOf('&',start+1); if(stop==-1)stop=MM_keepURL.length(); MM_keepURL=MM_keepURL.substring(0,start)+MM_keepURL.substring(stop); } } } //addtheFormvariablestotheMM_keepFormstring if(request.getParameterNames().hasMoreElements()){ java.util.Enumerationitems=request.getParameterNames(); while(items.hasMoreElements()){ StringnextItem=(String)items.nextElement(); booleanfound=false; for(inti=0;! found&&i if(MM_removeList[i].equals(nextItem))found=true; } if(! found&&MM_keepURL.indexOf('&'+nextItem+'=')==-1){ MM_keepForm=MM_keepForm+'&'+nextItem+'='+.URLEncoder.encode(request.getParameter(nextItem)); } } } StringtempStr=""; for(inti=0;i if(MM_keepURL.charAt(i)=='<')tempStr=tempStr+"<"; elseif(MM_keepURL.charAt(i)=='>')tempStr=tempStr+">"; elseif(MM_keepURL.charAt(i)=='"')tempStr=tempStr+"""; elsetempStr=tempStr+MM_keepURL.charAt(i); } MM_keepURL=tempStr; tempStr=""; for(inti=0;i if(MM_keepForm.charAt(i)=='<')tempStr=tempStr+"<"; elseif(MM_keepForm.charAt(i)=='>')tempStr=tempStr+">"; elseif(MM_keepForm.charAt(i)=='"')tempStr=tempStr+"""; elsetempStr=tempStr+MM_keepForm.charAt(i); } MM_keepForm=tempStr; //createtheForm+URLstringandremovetheintial'&'fromeachofthestrings MM_keepBoth=MM_keepURL+MM_keepForm; if(MM_keepBoth.length()>0)MM_keepBoth=MM_keepBoth.substring (1); if(MM_keepURL.length()>0)MM_keepURL=MM_keepURL.substring (1); if(MM_keepForm.length()>0)MM_keepForm=MM_keepForm.substring (1); %> <% //***MoveToRecord: setthestringsforthefirst,last,next,andpreviouslinks StringMM_moveFirst,MM_moveLast,MM_moveNext,MM_movePrev; { StringMM_keepMove=MM_keepBoth;//keepbothFormandURLparametersformoves StringMM_moveParam="index="; //ifthepagehasarepeatedregion,remove'offset'fromthemaintainedparameters if(MM_size>1){ MM_moveParam="offset="; intstart=MM_keepMove.indexOf(MM_moveParam); if(start! =-1&&(start==0||MM_keepMove.charAt(start-1)=='&')){ intstop=MM_keepMove.indexOf('&',start); if(start==0&&stop! =-1)stop++; if(stop==-1)stop=MM_keepMove.length(); if(start>0)start--; MM_keepMove=MM_keepMove.substring(0,start)+MM_keepMove.substring(stop); } } //setthestringsforthemovetolinks StringBufferurlStr=newStringBuffer(request.getRequestURI()).append('? ').append(MM_keepMove); if(MM_keepMove.length()>0)urlStr.append('&'); urlStr.append(MM_moveParam); MM_moveFirst=urlStr+"0"; MM_moveLast=urlStr+"-1"; MM_moveNext=urlStr+Integer.toString(MM_offset+MM_size); MM_movePrev=urlStr+Integer.toString(Math.max(MM_offset-MM_size,0)); } %> <% intRepeat2__numRows=-1; intRepeat2__index=0; Recordset1_numRows+=Repeat2__numRows; %> DOCTYPEHTMLPUBLIC"-//W3C//DTDHTML4.01Transitional//EN""http: //www.w3.org/TR/html4/loose.dtd"> <%while((Recordset1_hasData)&&(Repeat1__numRows--! =0)){%> "": Recordset1_data)%> "": Recordset1_data)%> "": Recordset1_data)%> <% Repeat1__index++; Recordset1_hasData=Recordset1.next(); } %> <% Recordset1.close(); StatementRecordset1.close(); ConnRecordset1.close(); %> 运行结果如图:id word explain <%=(((Recordset1_data=Recordset1.getObject("id"))==null||Recordset1.wasNull())? <%=(((Recordset1_data=Recordset1.getObject("word"))==null||Recordset1.wasNull())? <%=(((Recordset1_data=Recordset1.getObject("explain"))==null||Recordset1.wasNull())?
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- 字典 设计 界面