JspÁ¬½ÓMSSQL2000µÄÁ½ÖÖ·½·¨
JspÁ¬½ÓMSSQL2000µÄÁ½ÖÖ·½·¨
×î½üÔÚѧϰJSPWeb£¨Tomcat·þÎñÆ÷£©Ó¦Óÿª·¢ºÍ»ùÓÚWeblogicºÍMyelcipseµÄJEE5µÄ¿ª·¢£¬ÔÚѧϰ¹ý³ÌÖÐÉæ¼°µ½Á¬½ÓSQL 2000 Êý¾Ý¿âʱ£¬ÓÉÓÚÈí¼þ»·¾³µÄ²îÒìÐÔºÍһЩ°æ±¾ÎÊÌ⣬»¨Á˺ô󹦷ò²ÅÁ¬ÉÏ£¬ËùÒÔÔÚ´Ë×÷¸ö×ܽᣬϣÍûÄܸø´ó¼ÒһЩ°ïÖú£¬²»ÒªÔÚ»ù±¾µÄ¶«Î÷ÉÏ»¨·ÑÌ«¶àµÄʱ¼ä¡£
·½·¨Ò»£ºÀûÓÃSQL Server 2000 For JDBC Çý¶¯³ÌÐòÁ¬½Ó
ÐèÒªÌõ¼þ£º£¨1£©ÏÂÔØ°²×°SQL Server 2000 For JDBCÇý¶¯³ÌÐò
£¨2£©ÅäÖû·¾³±äÁ¿
£¨3£©Èç¹ûͨ¹ýÇ°Á½²½Á¬²»Éϳ¢ÊÔһϸøSQL Server 2000´ò¸ö²¹¶¡
£¨SQL2000-KB884525-SP4-x86-CHS.EXE£©
¾ßÌå²½Ö裺
£¨1£©´Ó΢ÈíÍøÕ¾http://download.microsoft.comÉÏÏÂÔØÇý¶¯³ÌÐò£ºSQL Server 2000 For JDBC
ÈôÕÒ²»µ½ÔÙÌṩһ¸öÍøÖ·£º
http://download.microsoft.com/download/3/0/f/30ff65d3-a84b-4b8a-a570-27366b2271d8/setup.exe
Jdbc_setup.exe ĬÈϵݲװ·¾¶ÎªC:\Program Files\Microsoft SQL Server 2000 Driver for JDBC£¬°²×°Ä¿Â¼\lib\ϵÄÈý¸öjar ÎļþÊÇJDBC Ö§³ÖSQL Server Êý¾Ý¿âµÄÇý¶¯ºËÐÄ¡£½«ÕâÈý¸öjarÎļþ£¨msbase.jar, mssql-server.jar, msutil.jar£©¸´ÖƵ½TomcatĿ¼ÏµÄcommon\lib×ÓĿ¼¡£
£¨2£©»·¾³ÅäÖãºÔÚ»·¾³±äÁ¿ÖÐÐÂÔöJDBC_HOMEϵͳ»·¾³±äÁ¿£¬ÖµÎªC:\Program Files\Microsoft SQL Server 2000 Driver for JDBC
°ÑSQL Server 2000 For JDBC Çý¶¯³ÌÐò°²×°Ä¿Â¼ÏµÄÈý¸öjarÎļþÌí¼Óµ½»·¾³±äÁ¿CALSSPATHµÄÖµÖУ¬Ä¿µÄÊÇ·ÀÖ¹jspÒ³ÃæÔڱ༹ý³ÌÖлá³öÏÖÕÒ²»µ½sql server driverÀà¿âµÄÎÊÌâ¡£Ìí¼ÓµÄÄÚÈÝÈçÏ£º%JDBC_HOME%\lib\msbase.jar;
%JDBC_HOME%\lib\mssqlserver.jar; %JDBC_HOME%\lib\msutil.jar;
ÖÁ´Ë£¬»ù±¾µÄÅäÖÃÒѾÍê³É£¬ÖØÆôһϻú×Ó£¬ÓÃÄãµÄÀý×Ó²âÊÔ¿´ÊÇ·ñÁ¬½ÓµÃÉÏ£¬Èç¹ûÁ¬²»ÉÏ¿ÉÄÜÊÇÄãµÄÊý¾Ý¿âÐèÒª´ò¸ö²¹¶¡£¬Éý¸ö¼¶¡£
£¨3£©¸øÄãµÄSQL Server 2000´ò¸ö²¹¶¡¡£
ÔÚ´ËÎÒËù´òµÄ²¹¶¡°æ±¾Îª SQL2000-KB884525-SP4-x86-CHS Õâ¸ö¿ÉÒÔÔÚÍøÉÏÕÒµ½¡£
°²×°¹ý³Ì£ºÏÂÔØÖ®ºóË«»÷Ëü£¬½«Ëü½âѹµ½Ò»¸öÅÌ£¨ÈÎÒ⣩£¬È»ºóÔÚÆä½âѹĿ¼˫»÷setup.batÅú´¦ÀíÎļþÀ´´ò²¹¶¡£¬Ö®ºó¸ù¾Ý°²×°³ÌÐòµÄÒýµ¼Íê³É²¹¶¡µÄ°²×°£¨×¢Òâ´Ë¹ý³ÌÓÐÁ½¸´Ñ¡¿òÑ¡Ïîʱ Ö»¹´Ñ¡¡¾Éý¼¶Mcrosoft Search ²¢Ó
Ïà¹ØÎĵµ£º
½ñÌìÔÚѧϰjspÖÐÊý¾Ý¿âµÄʹÓÃʱ£¬Óöµ½Ò»¸öºÜÆæ¹ÖµÄÇé¿ö£¨ÖÁÉÙÏÖÔÚ¿´À´Êǵģ©¡£jspÖÐÁ¬½ÓmysqlÊý¾Ý¿â£¬¿ªÆômysqlÊý¾Ý¿âºó£¬ÔÚjspÒ³ÃæÖÐǶÈëµÄjavaÁ¬½ÓmysqlÊý¾Ý¿âµÄÄǼ¸¾ä´úÂë¡£ºÃÏñ Class.forName("org.gjt.mm.mysql.Driver");ûÆðµ½×÷Óã¬Ö»ÐèÒªConnection con=DriverManager.getConnection("jdbc:mysql://localhost/test? ......
×î»ù±¾µÄÂÒÂëÎÊÌâ
Õâ¸öÂÒÂëÎÊÌâÊÇ×î¼òµ¥µÄÂÒÂëÎÊÌâ¡£Ò»°ãлá³öÏÖ¡£¾ÍÊÇÒ³Ãæ±àÂë²»Ò»Öµ¼ÖµÄÂÒÂë¡£
Html´úÂ룺
£¼%@ page language="java" pageEncoding="UTF-8"%£¾
£¼%@ page contentType="text/html;charset=iso8859-1"%£¾
£¼html£¾
£¼head£¾
£¼title ......
µÚÒ»ÖÖ£º
<script language="javascript" type="text/javascript">
window.location.href="login.jsp?backurl="+window.location.href;
</script>
µÚ¶þÖÖ£º
<script language="javascript">
alert("·µ»Ø");
window.history.back ......
ÔÚÒø¹âÖйúÍø£¨SilverlightChina.Net£©ÓÐһƪ"SilverlightÓë³£ÓÃÊý¾Ý¿â»¥²Ù×÷ϵÁÐ"ÎÄÕ£¬ÆäÖнéÉÜÁËʹÓÃSilverlight´æÈ¡²»Í¬Êý¾Ý¿âµÄ·½·¨ºÍ²½Öè¡£µ«ÊǶÔÓÚSilverlight´æÈ¡MS SQL½éÉܵIJ»¹»È«Ã棬ÕâÀïÎÒÏë½éÉÜSilverlightÈçºÎͨ¹ýWCF·ÃÎÊMSSQLÊý¾Ý¿â´æ´¢¹ý³ÌµÄ¡£Ï£Íû¶Ô´ó¼ÒÄܹ»ÓÐËù°ïÖú¡£
ÎÒÃÇҪʵÏÖ£¬ Óû§ÊäÈëÓû§ÃûºÍÃÜ ......
±êÇ©¿âTaglib
±êÇ©±»¶¨ÒåºÍ·Ö²¼ÔÚÒ»¸ö³ÆΪ±êÇ©¿âµÄ½á¹¹ÖУ¬Ò»¸ö±êÇ©¿âÊÇÓÉÔªÐÅÏ¢ºÍÀà×é³ÉµÄ¼¯ºÏ£º
1.±êÇ©´¦ÀíÆ÷£ºÊµÏÖ¶¨ÖƱêÇ©¹¦ÄܵÄJavaÀà¡£
2.±êÇ©¸½¼ÓÐÅÏ¢£¨TEI£©£ºÏòJSPÈÝÆ÷Ìṩ±ß¼ÒÔÈ·ÈϱêÇ©ÊôÐԺʹ´½¨±äÁ¿µÄÀà¡£
3.±êÇ©¿âÃèÊöÆ÷£¨TLD£©£ºÃèÊöµ¥¸ö±êÇ©ºÍÕû¸ö±êÇ©¿âÊôÐÔµÄXMLÎĵµ¡£
±êÇ©´¦ÀíÆ÷ºÍ±êÇ©¸½¼ÓÐÅÏ¢Ðè ......