import java.sql.*;class Conn{ public static void main(String[] args){ try{ Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
Connection con=DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=pubs","sa","ccc");
Statement stmt = con.createStatement(); //执行查询,返回结果集 ResultSet rs = stmt.executeQuery("SELECT a,b,c,d,key FROM Table1"); stmt.close(); con.close(); } catch(Exception ex){ ex.printStackTrace(); } }}错误代码
java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDri
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 Conn.main(Conn.java:9)
Press any key to continue...我已经注册了JDBC,CLASSPATH也写入了 路径
Connection con=DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=pubs","sa","ccc");
Statement stmt = con.createStatement(); //执行查询,返回结果集 ResultSet rs = stmt.executeQuery("SELECT a,b,c,d,key FROM Table1"); stmt.close(); con.close(); } catch(Exception ex){ ex.printStackTrace(); } }}错误代码
java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDri
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 Conn.main(Conn.java:9)
Press any key to continue...我已经注册了JDBC,CLASSPATH也写入了 路径
查一下CLASSPATH中sqlserver的jdbc包路径有没有写对,没有加上
ODBC 只需要建立一个数据源就可以了。
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection("dbc:odbc:数据源名");