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

¾ÈÃü°¡£¡£¡JSPÁ¬½ÓSQL2000ÎÊÌ⣡

¸÷λ´óÏÀ¾ÈÃü°¡ £¡£¡
¸Õ×°ÁËSQL2000 sp3
ÏëÓÃJSPÁ¬½ÓÊý¾Ý¿âµ«ÊdzöÏÖÎÊÌâÁË
ÎÒÓõÄÊÇJDK6.0+tomcat5.0+SQL2000 SP3+JDBC sp3
ËüÏÔʾµÄÊÇ
javax.servlet.ServletException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.

ÎÒÔËÐмòµ¥µÄJSP¾Í¿ÉÒÔÔËÐУ¬µ«ÊÇÁ¬½ÓÊý¾Ý¿âµÄ¾Í²»ÐР
ÍøÉÏ˵µÄ°ì·¨ÎÒ¶¼ÊÔ¹ýÁË »¹ÊDz»ÐР

¸÷λ¾È¾ÈÎÒ°É 
ÎÒµÄϵͳÊÇvistaµÄ...
¾ÈÃü°¡ ÔõôûÈ˰¡

°Ñ´úÂëÌùÉÏÀ´¿´¿´°É¡£javaÊÇ¿çÆ½Ì¨µÄ¡£

Ã²ËÆÇý¶¯ÎÊÌ⣬µ¹°üÁËô

<html>
<head>
  <title>ÀûÓÃJDBC DriverÁ¬½ÓSQL Server 2000Êý¾Ý¿â</title>
</head>
<%@ page contentType="text/html;charset=GB2312"%>
<%@ page language="java" import="java.sql.* "%>
  <center>
  <h1>ÀûÓÃJDBC DriverÁ¬½ÓSQL Server 2000Êý¾Ý¿â</h1>
</center> 
  <table>
  <tr>
  <td>Óû§ID</td>
  <td>ÐÕÃû</td>
  <td>ÄêÁä</td>
  <td>Óʼþ</td>
  <td>µØÖ·</td>
</tr>
</table>
<% /*¼ÓÔØJDBC Driver*/
  java.lang.Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
 


Ïà¹ØÎÊ´ð£º

sql¿ÉÒÔÓÐÁ½¸öÒÔÉϵĴ¥·¢Æ÷Â𣿣¿

sql¿ÉÒÔÓÐÁ½¸öÒÔÉϵĴ¥·¢Æ÷Â𣿣¿ÎÒÖ¸µÄÊÇfor´¥·¢Æ÷£¬ÄÇÆäËûµÄÄØ£¿£¿
ʲôÒâ˼£¿

¿ÉÒÔµÄ

10¸ö¶¼Ã»ÎÊÌâ

¿ÉÊÇÎÒдÁËÁ½¸öfor insert ´¥·¢Æ÷£¬Ôì³É½ø³Ì×èÈûÁËÄØ£¿Ôõô°ìÄØ£¿Çë¸ßÈËÖ¸µã
......

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

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

jspÌø×ª

ÎÒµãºóÍËʱÊǿհ×Ò³Ãæ
ÐèˢвÅÄÜÏÔʾ
Õâ¸öÔõô´¦Àí°¡
Çë´ó¼Ò°ï°ïæ
°ÑÎÊÌâ˵µÄÏêϸһЩ£¬ÕâÑùÓÐÖúÓÚÎÊÌâµÄ»Ø¸´£¬¼°´ð°¸µÄ׼ȷÐÔ£¡

ÎÒ¾õµÃÊÇÄãµÄä¯ÀÀÆ÷Æ÷µÄÎÊÌâ°É£¬ÎÒÒÔǰÓöµ½¹ýÕâÑùµÄÎÊÌ⣬°ÑIEµÄËùÓÐÊôÐÔÖ ......

jspÁ´½Ósql2000µÄÒÉÎÊ£¿



type Exception report


message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

org.apache.jas ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ