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

jspÁ¬½ÓmysqlÊý¾Ý¿â²éѯ£¬²¢ÔÚÒ³ÃæÏÔʾ

jspÁ¬½ÓmysqlÊý¾Ý¿â²éѯ£¬²¢ÔÚÒ³ÃæÏÔʾ Öм䲻ÓÃstruts£¬ÔõôʵÏÖ£¬ÇóÀý×Ó

javabean ×öÁ¬½Ó
jsp Ò³ÃæÊµÀý»¯Àà
jsp Ò³ÃæÏÔʾÊý¾Ý
<%@ page contentType="text/html;
charset=gb2312" language="java"
import="java.sql.*"%>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<%//*******************************
****************
JDBC_ODBCÁ¬½ÓMySqlÊý¾Ý¿â£¬²»ÐèÒªÉèÖÃÊý¾ÝÔ´***********
**********************/ 
//********** Êý¾Ý¿âÁ¬½Ó´úÂë¡¡¿ªÊ¼ ******/ 
//ÒÔϼ¸ÏîÇë×ÔÐÐÐÞ¸ÄString server="localhost";       
//MYSQL ·þÎñÆ÷µÄµØÖ·String dbname="test";         
//MYSQL Êý¾Ý¿âµÄÃû×ÖString user="root";               
//MYSQL Êý¾Ý¿âµÄµÇ¼Óû§ÃûString pass="chfanwsp";           
//MYSQL Êý¾Ý¿âµÄµÇ¼ÃÜÂëString port="3306";   
//SQL Server ·þÎñÆ÷µÄ¶Ë¿ÚºÅ£¬
ĬÈÏΪ1433//Êý¾Ý¿âÁ¬½Ó×Ö·û´®
String url ="jdbc:mysql://"+server+":"+port+"/"+dbname+"?
user="+user+"&passWord="+pass+"&useUnicode
=true&characterEncoding=GB2312";
//¼ÓÔØÇý¶¯³ÌÐòClass.forName("org.gjt.mm.mysql.Driver").newInstance


Ïà¹ØÎÊ´ð£º

jspÖÐ <c:if test> Ïà¹ØÎÊÌâ

ÔÚ²éѯºó½«²éѯ³öÀ´µÄÖµ¸³¸ø¸÷ÊäÈë¿ò
<c:if test="${not empty dataValue}">
      fm.SAMPLING_DATE.value=" <c:out value='${dataValue.SAMPLING_DATE}'/ ......

c,c++Á¬½Ómysql ÕÒ²»µ½Í·²¿Îļþ£¨ÐÂÊÖ£©

±àÒëÆ÷£ºC-Free4
mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓá£
×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£
Íü¸ßÊÖÖ¸µãÒ»¶ ......

htmlתjspºó²¼¾ÖΪʲô±äÁË

Ò»¸ö¾²Ì¬µÄhtmlÒ³Ãæ£¬ÃÀ»¯£¬½çÃæ²¼¾ÖÒѾ­´¦ÀíºÃÁË £¬ÔÚ±àд³ÌÐòµÄʱºòÐèÒªÔÚת»¯³ÉJSPÒ³Ãæ£¬

ËùÒÔн¨Ò»¸öJSPÒ³Ãæ£¬½²Ô­À´µÄ´úÂ뿽±´µ½ÀïÃæÈ¥£¬½á¹û²¼¾Ö±äÁË£¿

²»´æÔÚ·¾¶ÎÊÌâ!

ûÈË? ÕæÊ§°Ü!
......

JSP³öEXCEl±¨±íÖÐÎÄÃû³ÆÂÒÂë

ÎÒÔÚʹÓÿªÔ´µÄJXL ³öEXCEL±¨±íʱÓöµ½ÕâÑùµÄÎÊÌâ¡£
ÎÒÏë³öµÄÎļþÃû³ÆÊÇÕâÑùµÄ£ºÀý£ºtest_ÀîÇ¿.xls
´úÂëÊÇ ....test_+"UserID"+".xls";
µ«ÊÇ¿ØÖÆÌ¨ÎÒ¿´µ½µÄÊä³öÃû³ÆÐ§¹ûÊÇ£ºtest_µ ......

JSP´æÈëÊý¾Ý¿â

ÎÒÊÇÓÃSTRUTS £¬×öÁËÒ»¸öJSPÒ³Ãæ£¬Ìá½»ºóûÓдæÈëÊý¾Ý¿â¡£
JSP´úÂëÈçÏ£º
aa.jsp´úÂë
<%@ page contentType="text/html;charset=gb2312" language="java"%>
<%@ taglib uri=" ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ