jspÓëSQL Server 2000 µÄÁ¬½Ó
ÖÕÓڸ㶨JSPÁ¬½ÓSQL Server 2000Êý¾Ý¿âµÄÎÊÌâÁË
2008Äê01ÔÂ29ÈÕ ÐÇÆÚ¶þ 15:54
Ç°¼¸Ì죬ƽƽͬѧһֱÔÚ¸ãJSP Á¬½ÓSQL Server 2000Êý¾Ý¿âµÄÎÊÌ⣬һֱÁ¬²»ÉÏ£¬È»ºó½ÐÎÒÈ¥°ïËû¿´¿´£¬Æ¾×ÅÒÔÇ°µÄ¾Ñ飬¸ãÁËÒ»¸öÏÂÎ磬ºÙºÙ£¡ÖÕÓÚ°ïËûÁ¬½ÓÉÏÁË£¬Ö÷Òª²½ÖèÈçÏ£º
1¡¢ÐèÒªµÄ¶«Î÷´ó¼Ò¿ÉÒÔµ½ÎÒµÄѸÀײ©¿Í×ÊÔ´ÄÇÀïÈ¥ÏÂÔØ£º
http://317225483.blog.xunlei.com/index.html£¬×¨¼ÃûΪ£ºSQL Server 2000£¬ÏÂÄǸöSQL°²×°³ÌÐò£¬»¹ÐèÏÂÔØSQL Server 2000µÄ²¹¶¡SQL2000-KB884525-SP4-x86- CHS.EXEºÍSQL Server 2000 driver for JDBC¡£
2¡¢°²×°SQL Server 2000£¬°²×°¹ý³ÌÖÐÐèҪעÒâµÄµØ·½ÈçÏ£º
ÔËÐÐpersonalĿ¼ÏµÄAutorun.exeÎļþ»òÆäËü¿ÉÖ´ÐÐÎļþ£¬µ÷³ö°²×°³ÌÐòºó£¬³öÏÖÉÏͼËùʾ½çÃ档ѡÔñ“±¾µØ¼ÆËã»ú”ºó£¬µã»÷“ÏÂÒ»²½”¡£
Ñ¡´´½¨ÐµÄSQL ServerʵÀý……”£¬µãÏÂÒ»²½
Ñ¡ÖГ·þÎñÆ÷ºÍ¿Í»§¶Ë¹¤¾ß”£¬µãÏÂÒ»²½
×¢ÒâÉÏͼÕâÀï±È½Ï¹Ø¼ü£¬Éí·ÝÑé֤ѡÔñ“»ìºÏģʽ”£¨ÉÏͼ£©¡£Çë×¢Ò⣬saµÄµÇ¼ÃÜÂëÓëWindoesµÄµÇ¼ÃÜÂë²»ÄÜÏàͬ¡£Èç³öÏÖÏàͬ£¬Èí¼þÔòÎÞ·¨Á¬½ÓÊý¾Ý¿â¡£saΪ¸ß¼¶Óû§Ãû£¬saµÄÃÜÂë¼´ÊÇÈí¼þµÄ³õʼÃÜÂë¡£
ºóÃæµÄ¾Í¿ÉÒÔĬÈÏ°²×°ÏÂÈ¥ÁË¡£
3¡¢°²×°SQL Server 2000²¹¶¡SQL2000-KB884525-SP4-x86- CHS.EXE£¬Ë«»÷ºó³öÏÖ
È»ºóһֱĬÈÏ°²×°¼´¿É£¬ÔÙµ½CÅ̵ÄSQL2KSP4Ŀ¼ÏÂÕÒµ½setup.bat£¬È»ºóË«»÷£¬È»ºóÒ»Ö±µ½ÕâÀïÑ¡Ôñ:
SQL Serverϵͳ¹ÜÀíÔ±.....,£¬ÊäÈëÄã¸Õ²Å°²×°SQL Server 2000ʱÉèÖõÄsaÃÜÂë
ÏÂÃæµÄ¾ÍOK À²£¡
4¡¢°²×°SQL Server 2000 driver for JDBCÇý¶¯£¬°ÑÏÂÔØÏÂÀ´µÄÄǸösetup.exeÖ±½ÓË«»÷ĬÈÏ°²×°¼´¿É¡£
5¡¢×îºóÕÒµ½°ÑC:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\libϵÄmsbase.jar¡¢mssqlserver.jar¡¢msutil.jarÈý¸öÎļþ¸´ÖƵ½TomcatϵÄbinĿ¼ÏÂF:\tomcat-5.5.20\bin¡£
6¡¢ÏÖÔÚ¸ÃÊDzâÊÔһϵÄʱºòÁË£º´ò¿ªSQLµÄÆóÒµ¹ÜÀíÆ÷´´½¨Êý¾Ý¿âΪstudent£¬ÔÙн¨Ò»¸ö±ístu£¬È»ºóÌí¼Ó¼¸Ìõ¼Ç¼¡£Æô¶¯MyEclipse£¬Ð½¨JSPÎļþ£¬³ÌÐò´úÂë(ƽƽͬѧÄǸ´ÖÆÀ´µÄ£¬ºÇºÇ£¡ÕýÈ·µÄ£¡£¡)ÈçÏ£º
<%@page import="java.lang.*, java.io.*, java.sql.*, java.util.*" contentType="text/html;charset=gb2312"%>
<html>
<bod
Ïà¹ØÎĵµ£º
Êý¾Ý²É¼¯Öг£ÓõÄSQLÓï¾ä
ÏàͬµÄSQLÓï¾äÔËÓõ½²»Í¬Êý¾Ý¿âÖлáÓÐÂÔ΢µÄ²î±ð£¬¶Ô×Ö·û±äÁ¿µÄÒªÇó£¬Ïà¹Øº¯ÊýµÄ±ä»¯£¬ÒÔ¼°Óï·¨¹æÔòµÄ²»Í¬µÈµÈ£¬ÀýÈ磺oracleÊý¾Ý¿âÖжÔ×Ö¶ÎÃüÃû±ðÃûʱ²»ÐèÒªas ×Ö·û£¬Ã»ÓÐmonth()£¬year£¨£©µÈʱ¼äº¯ÊýµÈµÈ£¬accessÊý¾Ý¿âÖÐÔÚʹÓÃinner joinÖ´ÐÐÄÚ²¿ÁªºÏʱÌõ¼þÐèÓ㨣©£¬µ±È»»¹Óкܶ ......
Ôړн¨”²Ëµ¥ÖУ¬ÓÐProgram window£¬Test window£¬SQL windowºÍCommand windowµÈ¡£
SQL windowºÍCommand windowÓÐʲôÇø±ð£¿£¿
Command windowʵÏÖÁËSQL*PlusµÄËùÓй¦ÄÜ£¬ÔÊÐíÔËÐÐsql*plusÃüÁsqlÃüÁsql½Å±¾¡£
SQL windowÓÃÓÚÖ´ÐÐsqlÓï¾ä£¬ÏÔʾsqlÊä³ö£¬Ö´ÐÐͳ¼ÆÐÅÏ¢¡££¨²âÊÔsqlÓï¾ä£¬²é¿´±íÖеÄÊý¾Ý£¬ ......
SQL Server 2005µÄжÔØÊÇÒ»¸ö·Ç³£Í·ÌÛµÄÎÊÌâ¡£ÎÒÔø¾³¢ÊÔ¹ýÖ±½ÓʹÓá¾Ìí¼Ó»òɾ³ý³ÌÐò¡¿¹¤¾ßжÔØ¡¢Çå³ý°²×°Ä¿Â¼¡¢É¾³ý×¢²á±íÄÚÈݵȵȸ÷ÖÖ·½Ê½×ÛºÏжÔØ£¬ÃãÇ¿³É¹¦¡£ÏÖÔÚÖÕÓÚÕÒµ½ÁËÒ»¸öÊ°빦±¶µÄ·½·¨£¬¶à´Î³¢ÊÔ£¬Î´ÓÐʧ°Ü,¾ßÌåÈçÏÂ:
1.ÏÂÔØжÔع¤¾ß£¬ÓÐÁ½ÖÖ£º
µÚÒ»ÖÖÊÇ΢Èí¹Ù·½ÌṩµÄ¹¤¾ß(msicuu2.exe)
http://support.mic ......
ÓõÚÒ»ÖÖ·½·¨£¬ÉÏ´«·þÎñÆ÷ºó£¬ÔÚһЩ·þÎñÆ÷ÖУ¬¿ÉÄÜ»á³öÏÖÒÔÏ´íÎó£º
±ØÐëÔÚweb.configÖÐ¼Ó <system.web><identity impersonate="false"/></system.web> ,·ñÔò³öÏÖ´íÎó£ºSystem.Data.OleDb.OleDbException: δָ¶¨µÄ´íÎó¡£¼ÓÁËÒԺ󣬵ã¶à¼¸´ÎÁ´½Ó£¬» ......