classpath中添加了mssqlserver.jar, msbase.jar, msutil.jar的路徑import java.sql.*; public class SQL { public static void main(String[] args) throws Exception { Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver"); String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=Farwin"; String user="sa"; String password="xxxx"; Connection conn= DriverManager.getConnection(url,user,password); } } ---------------------------------------------------------------------------------出現了這樣的錯誤Exception in thread "main" java.lang.ClassNotFoundException: com.microsoft.jdbc. sqlserver.SQLServerDriver at java.net.URLClassLoader$1.run(URLClassLoader.java:199) at java.security.AccessController.doPrivileged(Native Method) at java.net.URLClassLoader.findClass(URLClassLoader.java:187) at java.lang.ClassLoader.loadClass(ClassLoader.java:289) at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:274) at java.lang.ClassLoader.loadClass(ClassLoader.java:235) at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:302) at java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Class.java:141) at SQL.main(SQL.java:5) 請按任意鍵繼續 . . .
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=mydb";
//mydb为数据库
String user="sa";
String password="";
Connection conn= DriverManager.getConnection(url,user,password); 先把那三个jar包放到classpath里,
然后把你的odbc桥的那部分代码换成上面的就可以了
public class SQL {
public static void main(String[] args) throws Exception
{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=Farwin";
String user="sa";
String password="xxxx";
Connection conn= DriverManager.getConnection(url,user,password);
}
} ---------------------------------------------------------------------------------出現了這樣的錯誤Exception in thread "main" java.lang.ClassNotFoundException: com.microsoft.jdbc.
sqlserver.SQLServerDriver
at java.net.URLClassLoader$1.run(URLClassLoader.java:199)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:187)
at java.lang.ClassLoader.loadClass(ClassLoader.java:289)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:274)
at java.lang.ClassLoader.loadClass(ClassLoader.java:235)
at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:302)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:141)
at SQL.main(SQL.java:5)
請按任意鍵繼續 . . .
try {
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=Farwin";
String user="sa";
String password="xxxx";
Connection conn= DriverManager.getConnection(url,user,password);
}
catcth (Exception e)
{
e.printStackTrace();
}