java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver
来源:互联网 发布:ica 四阶统计量算法 编辑:程序博客网 时间:2024/06/04 18:01
转载自:http://blog.csdn.net/autofei/article/details/4064299
SQL Server 2000 JDBC driver使用:"com.microsoft.jdbc.sqlserver.SQLServerDriver"
SQL Server 2005 and 2008 JDBC drive使用:"com.microsoft.sqlserver.jdbc.SQLServerDriver"
而且URL prefix也从"jdbc:microsoft:sqlserver://"改为"jdbc:sqlserver://"了。
From:http://blogs.msdn.com/jdbcteam/archive/2007/06/15/java-lang-classnotfoundexception-com-microsoft-jdbc-sqlserver-sqlserverdriver.aspx
下面是一个例子,已经封装到函数:
- public static Connection linktoSQLServer() {
- //String connect to SQL server
- String strServerIPAddress = "localhost";
- String strDatabaseName = "AdventureWorks";
- String url = "jdbc:sqlserver://" + strServerIPAddress + ":1433" +
- ";DatabaseName=" + strDatabaseName;
- String strUserName = "sa";
- String strPassword = "123456";
- //Connection conn = null;
- try {
- // Register the driver
- Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver").newInstance();
- try {
- /* Get a connection to the database */
- conn = DriverManager.getConnection(url, strUserName, strPassword);
- } catch (SQLException ex) {
- System.out.println("Exception One:");
- ex.printStackTrace();
- }
- } catch (Exception ex) {
- System.out.println("Exception Two:");
- ex.printStackTrace();
- }
- System.out.println("Connected...");
- return conn;
- }
- public static void SQLServer_select() {
- //this code just for SQL Server
- try {
- String strCmd = "SELECT * FROM Production.Location";
- rs = stmt.executeQuery(strCmd);
- while (rs.next()) {
- System.out.println("Column 1 has value: " + rs.getString(1));
- System.out.println("Column 2 has value: " + rs.getString(2));
- System.out.println("Column 3 has value: " + rs.getString(3));
- }
- } catch (SQLException ex) {
- System.out.println("SQLException: " + ex.getMessage());
- System.out.println("SQLState: " + ex.getSQLState());
- System.out.println("VendorError: " + ex.getErrorCode());
- }
- }
0 0
- java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver
- java lang classnotfoundexception com microsoft jdbc sqlserver sqlserverdriver
- java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver
- java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver
- java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver
- java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver
- java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver
- java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver
- java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver
- java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver
- java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver
- java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver
- java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver
- 解决java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver问题
- java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver
- java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver问题解决
- java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver
- java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver的问题
- Android性能优化之数据库优化
- 数据入库代码
- ubuntu 13.10中的eclipse菜单项无法点击
- 给定一个整型数组,求数组元素大于等于所有元素平均值的元素个数
- 计算机图形学 - 高度图
- java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver
- ASP.NET下载文件的代码
- USACO Barn Repair
- 开端
- java Future用法和意义
- iOS开发之结合asp.net webservice实现文件上传下载
- Java常用正则表达式工具类
- Android性能优化之布局优化
- 打印:正三角形,倒的正三角形