1ãè¿è¡Eclipseï¼æ°å»ºä¸ä¸ªJava Project å为 Test
2ãå³åå»srcï¼ä¾æ¬¡éæ© Build Path â Configure Build Pathï¼å¨æå¼ççªå£çå³è¾¹éæ© Libraries æ ç¾ï¼ç¶ååå» Add External JARsï¼æ¾å° sqljdbc4.jar æ件并æå¼ï¼ç¶ååå» OK å®ææ建路å¾çé
ç½®ã
3ãå¨Testä¸æ°å»ºå
pkgï¼å¨pkgä¸æ°å»ºä¸ä¸ªç±»Mainï¼å¨å
¶ä¸è¾å
¥ä»£ç å¦ä¸ï¼
package pkg;
import java.sql.*;
public class Main {
public static void main(String [] args)
{
String driverName="com.microsoft.sqlserver.jdbc.SQLServerDriver";
String dbURL="jdbc:sqlserver://localhost:1433;DatabaseName=ä½ çæ°æ®åºå";
String userName="å¡«åä½ çç¨æ·åï¼æçæ¯sa";
String userPwd="å¡«åä½ çå¯ç ";
try
{
Class.forName(driverName);
Connection dbConn=DriverManager.getConnection(dbURL,userName,userPwd);
System.out.println("è¿æ¥æ°æ®åºæå");
}
catch(Exception e)
{
e.printStackTrace();
System.out.print("è¿æ¥å¤±è´¥");
}
}
}
5ãç¹å»å³é®ï¼éæ© run as â> Java Application, æ§å¶å°åºç°ä¸å¾åè¿æ¥æåï¼
温馨提示:答案为网友推荐,仅供参考