Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

´¿JSP·ÖÒ³´úÂë

<%@ page contentType="text/html; charset=gb2312" %>
<%@ page language="java" %>
<%@ page import="java.sql.*" %>
<%
//Çý¶¯³ÌÐòÃû
String driverName="org.gjt.mm.mysql.Driver";
//Êý¾Ý¿âÓû§Ãû
String userName="root";
//ÃÜÂë
String userPasswd="<>?KL:IOP*()";
//Êý¾Ý¿âÃû
String dbName="gb_winguo_db";
//±íÃû
String tableName="keyword_type";
//Áª½á×Ö·û´®
String url="jdbc:mysql://127.0.0.1/"+dbName+"?user="+userName+"&password="+userPasswd;
Class.forName(driverName).newInstance();
Connection connection=DriverManager.getConnection(url);
Statement statement = connection.createStatement();
//ÿҳÏÔʾ¼Ç¼Êý
int PageSize = 20;
int StartRow = 0; //¿ªÊ¼ÏÔʾ¼Ç¼µÄ±àºÅ
int PageNo=0;//ÐèÒªÏÔʾµÄÒ³Êý
int CounterStart=0;//ÿҳҳÂëµÄ³õʼֵ
int CounterEnd=0;//ÏÔʾҳÂëµÄ×î´óÖµ
int RecordCount=0;//×ܼǼÊý;
int MaxPage=0;//×ÜÒ³Êý
int PrevStart=0;//ǰһҳ
int NextPage=0;//ÏÂÒ»Ò³
int LastRec=0;
int LastStartRecord=0;//×îºóÒ»Ò³¿ªÊ¼ÏÔʾ¼Ç¼µÄ±àºÅ
//»ñÈ¡ÐèÒªÏÔʾµÄÒ³Êý£¬ÓÉÓû§Ìá½»
if(request.getParameter("PageNo")==null){ //Èç¹ûΪ¿Õ£¬Ôò±íʾµÚ1Ò³
if(StartRow == 0){
PageNo = StartRow + 1; //É趨Ϊ1
}
}else{
PageNo = Integer.parseInt(request.getParameter("PageNo")); //»ñµÃÓû§Ìá½»µÄÒ³Êý
StartRow = (PageNo - 1) * PageSize; //»ñµÃ¿ªÊ¼ÏÔʾµÄ¼Ç¼±àºÅ
}
//ÒòΪÏÔʾҳÂëµÄÊýÁ¿ÊǶ¯Ì¬±ä»¯µÄ
//¼ÙÈç×ܹ²ÓÐÒ»°ÙÒ³£¬Ôò²»¿ÉÄÜͬʱÏÔʾ100¸öÁ´½Ó
//¶øÊǸù¾Ýµ±Ç°µÄÒ³ÊýÏÔʾһ¶¨ÊýÁ¿µÄÒ³ÃæÁ´½Ó
//ÉèÖÃÏÔʾҳÂëµÄ³õʼֵ
if(PageNo % PageSize == 0){
CounterStart = PageNo - (PageSize - 1);
}else{
CounterStart = PageNo - (PageNo % PageSize) + 1;
}
CounterEnd = CounterStart + (PageSize - 1);
%>
<html>
<head>
<title>·ÖÒ³ÏÔʾ¼Ç¼</title>
<link rel="stylesheet" href="style.css" mce_href="style.css" type="text/css">


Ïà¹ØÎĵµ£º

JSP Áгö·þÎñÆ÷»·¾³±äÁ¿

ÏÂÃæµÄÊÇÒ»¸öÔËÐÐЧ¹û£º
 
·þÎñÆ÷»·¾³±äÁ¿
¹¦ÄܼòÊö
localhost¡¡
·þÎñÆ÷µÄÓòÃû
192.168.0.5¡¡
·þÎñÆ÷µÄIPµØÖ·
Windows XP¡¡
·þÎñÆ÷²Ù×÷ϵͳ
1.6.0¡¡
·þÎñÆ÷ Java ÐéÄâ»ú°æ±¾
2.5¡¡
·þÎñÆ÷Ö§³ÖµÄ Servlet API °æ±¾
2.1¡¡
·þÎñÆ÷Ö§³ÖµÄ JSP API °æ±¾
Apache Tomcat/6.0.16¡¡
·þÎñÆ÷Èí¼þµÄÃû³Æ¼°°æ±¾(½ ......

һƪ²»´íµÄ¹ØÓÚjsp sessionµÄ½éÉÜ£¨×ª£©

 
ÕªÒª£ºËäÈ»session»úÖÆÔÚwebÓ¦ÓóÌÐòÖб»²ÉÓÃÒѾ­ºÜ³¤Ê±¼äÁË£¬µ«ÊÇÈÔÈ»ÓкܶàÈ˲»Çå³þsession»úÖÆµÄ±¾ÖÊ£¬ÒÔÖÁ²»ÄÜÕýÈ·µÄÓ¦ÓÃÕâÒ»¼¼Êõ¡£±¾ÎĽ«ÏêϸÌÖÂÛsessionµÄ¹¤×÷»úÖÆ²¢ÇÒ¶ÔÔÚJava web applicationÖÐÓ¦ÓÃsession»úÖÆÊ±³£¼ûµÄÎÊÌâ×÷³ö½â´ð¡£
Ŀ¼£º
Ò»¡¢ÊõÓïsession
¶þ¡¢HTTPЭÒéÓë״̬±£³Ö
Èý¡¢Àí½âcookie» ......

JSP¸ßÇåËõÂÔͼJMagickʹÓÃ

JSP¸ßÇåËõÂÔͼJMagickʹÓã¬ÊµÏÖÁ˶ÔͼƬµÄ¶àÖÖ²Ù×÷£¬ºÏ³ÉͼƬ£¬ËõÂÔͼ¡¢¸´ÖÆÊý¾ÝµÈµÈ...¡£
Ê×ÏÈÏÂÔØ£º
http://downloads.jmagick.org/6.3.9/ImageMagick-6.3.9-0-Q16-windows-dll.exe
http://downloads.jmagick.org/6.3.9/jmagick-win-6.3.9-Q16.zip
°²×°ImageMagick-6.3.9-0-Q16-windows-dll.exe³ÌÐòÔÚFÅÌÈ磺F:\Imag ......

jspÁ¬½ÓÊý¾Ý¿âʾÀý

1£¬Ð½¨Ò»web¹¤³Ì£¬½«Êý¾Ý¿âÁ¬½Ó°üÌí¼ÓÈëlibÎļþ¼ÐÏ¡£
2£¬Ð½¨jspÒ³Ãæ£¬ÄÚÈÝÈçÏ£º
<%@ page language="java" import="java.util.*" import="java.sql.*" pageEncoding="gb2312"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+re ......

jspÒ³Ãæ²éѯµÄÊý¾Ýµ¼³öµ½excel£¨¶þ£©


javaµ¼Èëµ¼³öexcel²Ù×÷(jxl)£¨2£©
¹Ø¼ü×Ö: javaµ¼Èëµ¼³öexcel²Ù×÷(jxl)£¨2£©(
¸ß¼¶²Ù×÷
Ò»¡¢ Êý¾Ý¸ñʽ»¯
ÔÚExcelÖв»Éæ¼°¸´ÔÓµÄÊý¾ÝÀàÐÍ£¬Äܹ»±È½ÏºÃµÄ´¦Àí×Ö´®¡¢Êý×ÖºÍÈÕÆÚÒѾ­Äܹ»Âú×ãÒ»°ãµÄÓ¦Óá£
×Ö´®¸ñʽ»¯
×Ö·û´®µÄ¸ñʽ»¯Éæ¼°µ½µÄÊÇ×ÖÌå¡¢´Öϸ¡¢×ֺŵÈÔªËØ£¬ÕâЩ¹¦ÄÜÖ÷ÒªÓÉWritableFontºÍWritableCellFormat ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ