æ¹æ³/æ¥éª¤
1
é¦å
ï¼é
ç½®ç¯å¢åéãå¦å¤ï¼å¦æä½ çæºåä¸æ²¡ææ°æ®åºé©±å¨jarå
çè¯ï¼éè¦ä¸è½½ä¸ä¸ªsqljdbc4.jarãä¸é¢ï¼å³å»âæççµèâããéæ©âå±æ§âããåéæ©âé«çº§âããéä¸âç¯å¢åéâã
2
å¨å¼¹åºç对è¯æ¡ä¸ï¼ç³»ç»åéæ å¦æå·²ç»æäºCLASSPATHç³»ç»åéï¼æ³¨æ大åï¼ï¼é£ä¹å¨æåæ·»ä¸jarå
çç»å¯¹è·¯å¾ï¼;d:\sqljdbc4.jarï¼ï¼æ³¨æå ä¸åé符âï¼âãå¦æ没æCLASSPATHï¼é£ä¹æ°å»ºä¸ä¸ªï¼å¦å¾ä¸æ示ãã
3
å
¶æ¬¡ï¼å¯¹SqlServeré
置管çå¨è¿è¡è®¾ç½®ãé¦å
æå¼SqlServeré
置管çå¨ãå
·ä½æ¥éª¤å¦å¾ç¤ºã
4
è¿å
¥SQLé
置管çå¨åï¼éä¸å·¦ä¾§âSQL Serverç½ç»é
ç½®âããåéä¸âMSSQLSERVERçåè®®âåå»åï¼å³ä¾§çªå£ä¼æâTCP/IPâé项ãåå»è¿å
¥ãå¦å¾ç¤ºã
5
å¨TCP/IPå±æ§ä¸å¯¹IPå°åè¿è¡è®¾ç½®ï¼IPå°å设为â127.0.0.1âï¼å³æ¬å°ipã端å£å¼å¨åé¢ä¼ç¨å°ï¼å
è®°ä½ãå¦å¾ç¤ºã注æï¼TCP/IPè¥ä¸æ¯å¤äºå¯å¨ç¶æï¼è¦å³å»åéæ©âå¯å¨âã
6
è¿
è¡å®ä¸è¿°è®¾ç½®åï¼æå¼MyEclipseè¿å
¥æ°æ®åºæä½çé¢ãæå¼åï¼ä¾æ¬¡éæ©âwindowâããâopen
perspectiveâ>>"other..."è¿å
¥å¯¹è¯æ¡ï¼éæ©âMyEclipse DataBase
Explorerâåå°±è¿å
¥äºãå¦å¾ç¤ºã
7
å¨å³ä¾§çªå£ç©ºç½åºåå³å»é¼ æ ï¼éæ©"New....."ï¼æå¼æ°æ®åºé©±å¨å¯¹è¯æ¡ï¼å
·ä½æä½æ¥éª¤è§å¾æ示ã
8
对
DatabaseDriverè¿è¡è®¾ç½®ï¼âDriver templateâä¸éæ©Sqlserverï¼âDriver
nameâå¯ä»¥é便åï¼âConnection
URLâå¦å¾æ示设置ï¼æ³¨æï¼1433ï¼å³ä¸ºä¸é¢æå°ç端å£å¼ãåé¢çâdatabaseName=bankâæ¯Sqlä¸å·²åå¨çä¸ä¸ªæ°æ®åºåãè´¦å·ãå¯
ç ä¸è¬æ¯âsaâ,ç¶åï¼ç¹å»âAdd JARsâæjarå
导å
¥ãç¹å»âfinishâå®æ设置ã
9
ä¸
述设置å®æåï¼MyEclipse左侧çªå£å°±ä¼åºç°å设置çâDriver
nameâå³sqlserverï¼å¦å¾ç¤ºãå³å»âsqlserverâï¼éæ©âopen
connection...â,å¨å¼¹åºç对è¯æ¡ä¸è¾å
¥è´¦å·å¯ç ï¼å°±æ¯ä¸é¢çâsaâãç¹å»âOKâå°±å¯ä»¥äºï¼æ°æ®åºè¿æ¥æåäºãææå¦å¾ç¤ºã
http://jingyan.baidu.com/article/7c6fb42869932380652c9075.html