代码如下:
import java.sql.DriverManager;
import java.sql.SQLException;public class Text { /**
* @param args
*/
public static void main(String[] args) throws SQLException {
// TODO Auto-generated method stub
try {
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver")
.newInstance();
} catch (InstantiationException e) { e.printStackTrace();
} catch (IllegalAccessException e) { e.printStackTrace();
} catch (ClassNotFoundException e) { e.printStackTrace();
}
String url = "jdbc:microsoft:sqlserver://mengxianfeng.:1433;DatabaseName=student";
// student为数据库
String user = "sa";
String password = "000";
java.sql.Connection conn = DriverManager.getConnection(url, user,
password);
}}
提示错误如下:
java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver
at java.net.URLClassLoader$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClassInternal(Unknown Source)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Unknown Source)
at mxf20090313.Text.main(Text.java:14)
Exception in thread "main" java.sql.SQLException: No suitable driver found for jdbc:microsoft:sqlserver://mengxianfeng.:1433;DatabaseName=student
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at mxf20090313.Text.main(Text.java:30)
环境:xp home版 sql2000打过sp4补丁,sp3补丁打不上,提示说打过sp4补丁,无需打sp3补丁。1433端口是开的,可以查看到。
import java.sql.DriverManager;
import java.sql.SQLException;public class Text { /**
* @param args
*/
public static void main(String[] args) throws SQLException {
// TODO Auto-generated method stub
try {
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver")
.newInstance();
} catch (InstantiationException e) { e.printStackTrace();
} catch (IllegalAccessException e) { e.printStackTrace();
} catch (ClassNotFoundException e) { e.printStackTrace();
}
String url = "jdbc:microsoft:sqlserver://mengxianfeng.:1433;DatabaseName=student";
// student为数据库
String user = "sa";
String password = "000";
java.sql.Connection conn = DriverManager.getConnection(url, user,
password);
}}
提示错误如下:
java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver
at java.net.URLClassLoader$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClassInternal(Unknown Source)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Unknown Source)
at mxf20090313.Text.main(Text.java:14)
Exception in thread "main" java.sql.SQLException: No suitable driver found for jdbc:microsoft:sqlserver://mengxianfeng.:1433;DatabaseName=student
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at mxf20090313.Text.main(Text.java:30)
环境:xp home版 sql2000打过sp4补丁,sp3补丁打不上,提示说打过sp4补丁,无需打sp3补丁。1433端口是开的,可以查看到。
下载一个sqlserver的驱动程序,加入到工程路径下