<%@ page contentType="application/msexcel" %>
<%
//¶ÀÁ¢´ò¿ªexcelÈí¼þ
response.setHeader("Content-disposition","attachment; filename=MyExcel.xls");
//ǶÌ×ÔÚieÀï´ò¿ªexcel
//response.setHeader("Content-disposition","inline; filename=MyExcel.xls");
//WordÖ»ÐèÒª°ÑcontentType="application/msexcel"¸ÄΪcontentType="application/msword"
%>
<html>
<head>
<title>²âÊÔµ¼³öExcelºÍWord</title>
</head>
<body>
<table width="500" border="1" align="center">
<tr>
<td colspan="4" align="center">µç×Ó²úÆ·²âÊÔͳ¼Æ</td>
</tr>
<tr>&n ......
jspÒ³Ãæµ÷Óà <link type="text/css" rel="stylesheet" href="css/style.css"/>Ñùʽ±í
ÆäËûÑùʽ¶¼¿ÉÒÔÔÙÒ³ÃæÕý³£ÏÔʾ
.button-qingchu{background:url(images/qingchu.jpg); width:70px; height:30px; border:0px;} ÏñÕâÑùµÄ±³¾°Í¼Æ¬Ñùʽ¾ÍÏÔʾ²»³öͼƬÊÇʲôÎÊÌ⣡ Myeclipse 6.5
ÔÚhtmlÖж¼¿ÉÒÔÏÔʾ ÔÚjspÖÐÏÔʾ²»³öÀ´£¡²»¹ý°ÑÑùʽдÔÚjspÒ³Ãæ ²¿·Ö ¾Í¿ÉÒÔÏÔʾ³öÀ´
<style type="text/css">
.button-qingchu{background:url(images/qingchu.jpg); width:70px; height:30px; border:0px;} </style>
µ÷ÓÃÑùʽ±í¾ÍÏÔʾ²»³ö£¡
images/qingchu.JPG ¸Ä³ÉÕâÑù ·¾¶Ò²¸ÄÁË url(../images/qingchu.JPG); Ò»ÑùÏÔʾ²»³öÀ´
====½â¾ö========================================================================
·ÅÔÚcss/style.cssÕâÀïÃæÊ±£¬ÒòΪÔÚcssĿ¼Ï£¬
·ÅJSPÒ³ÃæÊ±³öÀ´images/qingchu.jpgÖ¤Ã÷imagesºÍcssºÍjspÒ³ÃæÔÚͬһĿ¼
ÄãµÄ½á¹¹ÊÇÕâÑùµÄ
css/style.css
images/qingchu.jpg
*.jsp
ËùÒÔÄãÖ±½ÓдÔÚjspÒ³ÃæÉÏʱ»áÏÔʾ³öÀ´£¬µ«Äã·ÅÔÚcss/style.cssÖÐʱ£¬Í¼Æ¬Â·¾¶ÒªÏà¶ÔÓÚcssÎļþ
¼´Òª¸Ä³É../images/qingchu.jpg
¶øÇÒÎļþÃûµÄ´óСдһÑùÒªÌØ± ......
jspÒ³Ãæµ÷Óà <link type="text/css" rel="stylesheet" href="css/style.css"/>Ñùʽ±í
ÆäËûÑùʽ¶¼¿ÉÒÔÔÙÒ³ÃæÕý³£ÏÔʾ
.button-qingchu{background:url(images/qingchu.jpg); width:70px; height:30px; border:0px;} ÏñÕâÑùµÄ±³¾°Í¼Æ¬Ñùʽ¾ÍÏÔʾ²»³öͼƬÊÇʲôÎÊÌ⣡ Myeclipse 6.5
ÔÚhtmlÖж¼¿ÉÒÔÏÔʾ ÔÚjspÖÐÏÔʾ²»³öÀ´£¡²»¹ý°ÑÑùʽдÔÚjspÒ³Ãæ ²¿·Ö ¾Í¿ÉÒÔÏÔʾ³öÀ´
<style type="text/css">
.button-qingchu{background:url(images/qingchu.jpg); width:70px; height:30px; border:0px;} </style>
µ÷ÓÃÑùʽ±í¾ÍÏÔʾ²»³ö£¡
images/qingchu.JPG ¸Ä³ÉÕâÑù ·¾¶Ò²¸ÄÁË url(../images/qingchu.JPG); Ò»ÑùÏÔʾ²»³öÀ´
====½â¾ö========================================================================
·ÅÔÚcss/style.cssÕâÀïÃæÊ±£¬ÒòΪÔÚcssĿ¼Ï£¬
·ÅJSPÒ³ÃæÊ±³öÀ´images/qingchu.jpgÖ¤Ã÷imagesºÍcssºÍjspÒ³ÃæÔÚͬһĿ¼
ÄãµÄ½á¹¹ÊÇÕâÑùµÄ
css/style.css
images/qingchu.jpg
*.jsp
ËùÒÔÄãÖ±½ÓдÔÚjspÒ³ÃæÉÏʱ»áÏÔʾ³öÀ´£¬µ«Äã·ÅÔÚcss/style.cssÖÐʱ£¬Í¼Æ¬Â·¾¶ÒªÏà¶ÔÓÚcssÎļþ
¼´Òª¸Ä³É../images/qingchu.jpg
¶øÇÒÎļþÃûµÄ´óСдһÑùÒªÌØ± ......
½ñÌìѧ»áÁËÈçºÎ×Ô¼º±àд JSP ÓÃÀ´´¦Àí CKEditor µÄͼƬÉÏ´«¡£
<%@ page import="org.apache.commons.fileupload.FileItem" %>
<%@ page import="java.util.List" %>
<%@ page import="org.apache.commons.fileupload.disk.DiskFileItemFactory" %>
<%@ page import="org.apache.commons.fileupload.servlet.ServletFileUpload" %>
<%@ page import="org.apache.commons.io.FilenameUtils" %>
<%@ page import="java.io.File" %>
<%@ page import="org.apache.commons.lang.StringUtils" %>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%
String callback = request.getParameter("CKEditorFuncNum");
try {
if (ServletFileUpload.isMultipartContent(request)) {
ServletFileUpload servletFileUpload = new ServletFileUpload(new DiskFileItemFactory());
List<FileItem> fileItemsList = servletFileUpload.parseRe ......
jsp(java server pages)ÊÇÒ»ÖÖ¼¼Êõ,ÓÃÀ´´¦Àí¿Í»§¶ËÇëÇóµÄ,(Ä¿µÄÊÇΪÁË´ïµ½¶¯Ì¬ÍøÒ³µÄЧ¹û),´¦Àíºó´«¸ø¿Í»§¶Ë(Ò²¿ÉÒÔ˵¸øÁËä¯ÀÀÆ÷),¾Í³ÉÁËÎÒÃÇ¿´µ½µÄ¾²Ì¬ÍøÒ³(HTML)
HTML ¼ÓÈëJava´úÂë(±ÈÈç<%...%>)²»»áÓÖÈκÎЧ¹û,Ö»»á½²<%...%>ÏÔʾµ½Ò³ÃæÐÐ,»òÕ߸ù¾ÝλÖÃÓ°Ïì±àÒë. JSP(Java Server Page)Ò³ÃæÆäʵ¾ÍÊÇÔÚHTML´úÂëÖмÓÈëJava´úÂëºÍJsp±êÇ©µÄÒ³Ãæ, JSPÊÇ·þÎñ¶ËÒ³Ãæ,ÔÚ·þÎñÆ÷ÊÇ¿ÉÒÔ¿´µ½Java´úÂëµÄ,µ«ÊÇÔÚ¿Í»§¶ËÖ»ÄÜ¿´µ½¸ù¾ÝJava´úÂëºÍJsp±êÇ©Éú³ÉÖ®ºóµÄ¾²Ì¬Ò³Ãæ.
ÓÐjspºó׺µÄ¾Í½ÐjspÒ³Ãæ£¬ÒòΪÓÐjspºó׺µÄ»á±»webÈÝÆ÷£¨Èçtomcat£©½âÊͳÉservlet,±ä³É.classµÄjava¿ÉÖ´ÐÐÎļþ
HTMLÎļþÖ»Êǵ¥´¿µÄHTMLÓïÑÔ.²»°üº¬JAVA½Å±¾.Òò´Ë²»ÐèÒªWEB·þÎñÆ÷ÀýÈçTOMCATµÈ½âÎö¾Í¿ÉÒÔÖ±½Óä¯ÀÀ.
JSPÒ³Ãæ¾ÍÊÇHTML+JAVA½Å±¾µÄÒ³Ãæ.±ØÐëÖ»Óкó׺ÃûΪJSPµÄ²Å¿ÉÒÔ°üº¬JAVA½Å±¾.²¢ÇÒÐèÒªWEB·þÎñÆ÷²ÅÄÜä¯ÀÀ¡£
ÔÚHTMLÀïÃæºÍJSPÀïÃæ дJAVASCRIPTÔÚÈκÎλÖÃÓÃ<script type='JavaScript'></script>Öмäд¾ÍÐÐ ......
jsp(java server pages)ÊÇÒ»ÖÖ¼¼Êõ,ÓÃÀ´´¦Àí¿Í»§¶ËÇëÇóµÄ,(Ä¿µÄÊÇΪÁË´ïµ½¶¯Ì¬ÍøÒ³µÄЧ¹û),´¦Àíºó´«¸ø¿Í»§¶Ë(Ò²¿ÉÒÔ˵¸øÁËä¯ÀÀÆ÷),¾Í³ÉÁËÎÒÃÇ¿´µ½µÄ¾²Ì¬ÍøÒ³(HTML)
HTML ¼ÓÈëJava´úÂë(±ÈÈç<%...%>)²»»áÓÖÈκÎЧ¹û,Ö»»á½²<%...%>ÏÔʾµ½Ò³ÃæÐÐ,»òÕ߸ù¾ÝλÖÃÓ°Ïì±àÒë. JSP(Java Server Page)Ò³ÃæÆäʵ¾ÍÊÇÔÚHTML´úÂëÖмÓÈëJava´úÂëºÍJsp±êÇ©µÄÒ³Ãæ, JSPÊÇ·þÎñ¶ËÒ³Ãæ,ÔÚ·þÎñÆ÷ÊÇ¿ÉÒÔ¿´µ½Java´úÂëµÄ,µ«ÊÇÔÚ¿Í»§¶ËÖ»ÄÜ¿´µ½¸ù¾ÝJava´úÂëºÍJsp±êÇ©Éú³ÉÖ®ºóµÄ¾²Ì¬Ò³Ãæ.
ÓÐjspºó׺µÄ¾Í½ÐjspÒ³Ãæ£¬ÒòΪÓÐjspºó׺µÄ»á±»webÈÝÆ÷£¨Èçtomcat£©½âÊͳÉservlet,±ä³É.classµÄjava¿ÉÖ´ÐÐÎļþ
HTMLÎļþÖ»Êǵ¥´¿µÄHTMLÓïÑÔ.²»°üº¬JAVA½Å±¾.Òò´Ë²»ÐèÒªWEB·þÎñÆ÷ÀýÈçTOMCATµÈ½âÎö¾Í¿ÉÒÔÖ±½Óä¯ÀÀ.
JSPÒ³Ãæ¾ÍÊÇHTML+JAVA½Å±¾µÄÒ³Ãæ.±ØÐëÖ»Óкó׺ÃûΪJSPµÄ²Å¿ÉÒÔ°üº¬JAVA½Å±¾.²¢ÇÒÐèÒªWEB·þÎñÆ÷²ÅÄÜä¯ÀÀ¡£
ÔÚHTMLÀïÃæºÍJSPÀïÃæ дJAVASCRIPTÔÚÈκÎλÖÃÓÃ<script type='JavaScript'></script>Öмäд¾ÍÐÐ ......
AjaxºÍjspµÄ¹ÖÏÖÏó
Èç¹ûÓÃAjaxÈ¥ÇëÇóÒ»¸öjspÒ³Ãæ£¬¸ÃjspÒ³Ãæ·µ»ØµÄÊÇxml£¨response.setContentType("text/xml; charset=GB2312");£©£¬²¢ÇÒ¸Ãjsp°üº¬ÏÂÃæÕâЩͷ@pageÖ¸ÁîµÄ»°£¬ÔòÔÚ¿Í»§¶Ëxml=XMLHttpRequest.responseXMLµÃµ½µÄÊÇÒ»¸ö²»°üº¬ÈÎÎñ¶«Î÷µÄxml¶ÔÏ󣬼´xml.childNodes.length½«»áÊÇ0.
<%@ page contentType="text/html; charset=GBK" %>
<%@ page import="com.suntek.notes.sql.DBGrid"%>
<%@ page import="java.util.Vector" %>
ÔÒòÊÇÒÔÉϵÄ@pageÖ¸Áî(ÆäʵÊÇÈκÎÒ»¸öÖ¸Áî)»á²úÉú¿ÕÐС£¼´ÔÚjspÀï±ßµÄout.print(xml)µ½¿Í»§¶ËµÄ֮ǰ£¬ÒѾÓпÕÐÐÊä³öÁË¡£½â¾ö°ì·¨¿ÉÒÔÊÇÈ¥µôÉÏÃæµÄÓï¾ä£¬»ò°Ñjsp¸ÄΪservlet
ͬʱ£¬jspÀï±ßµÄÈκοÕÐж¼ÓпÉÄܻᵼÖÂͬÑùµÄÎÊÌâ¡£
Ó¦¸ÃÓÃservlet½ÏºÃ¡£
......
AjaxºÍjspµÄ¹ÖÏÖÏó
Èç¹ûÓÃAjaxÈ¥ÇëÇóÒ»¸öjspÒ³Ãæ£¬¸ÃjspÒ³Ãæ·µ»ØµÄÊÇxml£¨response.setContentType("text/xml; charset=GB2312");£©£¬²¢ÇÒ¸Ãjsp°üº¬ÏÂÃæÕâЩͷ@pageÖ¸ÁîµÄ»°£¬ÔòÔÚ¿Í»§¶Ëxml=XMLHttpRequest.responseXMLµÃµ½µÄÊÇÒ»¸ö²»°üº¬ÈÎÎñ¶«Î÷µÄxml¶ÔÏ󣬼´xml.childNodes.length½«»áÊÇ0.
<%@ page contentType="text/html; charset=GBK" %>
<%@ page import="com.suntek.notes.sql.DBGrid"%>
<%@ page import="java.util.Vector" %>
ÔÒòÊÇÒÔÉϵÄ@pageÖ¸Áî(ÆäʵÊÇÈκÎÒ»¸öÖ¸Áî)»á²úÉú¿ÕÐС£¼´ÔÚjspÀï±ßµÄout.print(xml)µ½¿Í»§¶ËµÄ֮ǰ£¬ÒѾÓпÕÐÐÊä³öÁË¡£½â¾ö°ì·¨¿ÉÒÔÊÇÈ¥µôÉÏÃæµÄÓï¾ä£¬»ò°Ñjsp¸ÄΪservlet
ͬʱ£¬jspÀï±ßµÄÈκοÕÐж¼ÓпÉÄܻᵼÖÂͬÑùµÄÎÊÌâ¡£
Ó¦¸ÃÓÃservlet½ÏºÃ¡£
......
AjaxºÍjspµÄ¹ÖÏÖÏó
Èç¹ûÓÃAjaxÈ¥ÇëÇóÒ»¸öjspÒ³Ãæ£¬¸ÃjspÒ³Ãæ·µ»ØµÄÊÇxml£¨response.setContentType("text/xml; charset=GB2312");£©£¬²¢ÇÒ¸Ãjsp°üº¬ÏÂÃæÕâЩͷ@pageÖ¸ÁîµÄ»°£¬ÔòÔÚ¿Í»§¶Ëxml=XMLHttpRequest.responseXMLµÃµ½µÄÊÇÒ»¸ö²»°üº¬ÈÎÎñ¶«Î÷µÄxml¶ÔÏ󣬼´xml.childNodes.length½«»áÊÇ0.
<%@ page contentType="text/html; charset=GBK" %>
<%@ page import="com.suntek.notes.sql.DBGrid"%>
<%@ page import="java.util.Vector" %>
ÔÒòÊÇÒÔÉϵÄ@pageÖ¸Áî(ÆäʵÊÇÈκÎÒ»¸öÖ¸Áî)»á²úÉú¿ÕÐС£¼´ÔÚjspÀï±ßµÄout.print(xml)µ½¿Í»§¶ËµÄ֮ǰ£¬ÒѾÓпÕÐÐÊä³öÁË¡£½â¾ö°ì·¨¿ÉÒÔÊÇÈ¥µôÉÏÃæµÄÓï¾ä£¬»ò°Ñjsp¸ÄΪservlet
ͬʱ£¬jspÀï±ßµÄÈκοÕÐж¼ÓпÉÄܻᵼÖÂͬÑùµÄÎÊÌâ¡£
Ó¦¸ÃÓÃservlet½ÏºÃ¡£
......
ÁùÖÖÒì³£´¦ÀíµÄªϰ
Äã¾õµÃ×Ô¼ºÊÇÒ»¸öJavaר¼ÒÂð£¿ÊÇ·ñ¿Ï¶¨×Ô¼ºÒÑ¾È«ÃæÕÆÎÕÁËJavaµÄÒì³£´¦Àí»úÖÆ£¿ÔÚÏÂÃæÕâ¶Î´úÂëÖУ¬ÄãÄܹ»Ñ¸ËÙÕÒ³öÒì³£´¦ÀíµÄÁù¸öÎÊÌâÂð£¿
Java´úÂë
OutputStreamWriter out = ...
java.sql.Connection conn = ...
try { //²¶»ñÒì³£
¡¡Statement stat = conn.createStatement();
¡¡ResultSet rs = stat.executeQuery(
¡¡¡¡"select uid, name from user");
¡¡while (rs.next())
¡¡{
¡¡¡¡out.println("ID£º" + rs.getString("uid") // ¢Ê
¡¡¡¡¡¡"£¬ÐÕÃû£º" + rs.getString("name"));
¡¡} &nb ......