SQL Server 2012加载驱动和URL路径的语句是

SQL Server 2012加载驱动和URL路径的语句是什么
2025-05-17 14:56:21
推荐回答(1个)
回答1:

package com.lovo.javadb;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLClientInfoException;
import java.sql.SQLException;
import java.sql.Statement;

public class JdbcTest {

public static void main(String[] args){

Connection conn = null;
Statement st = null;
try {
String url = "jdbc:jtds:sqlserver://127.0.0.1:1433/wh123";
//加载数据库驱动
Class.forName("net.sourceforge.jtds.jdbc.Driver");
//通过驱动管理器来得到连接,链接的地址就是URL,用户名,密码都是sa
conn = DriverManager.getConnection(url,"sa","sa");
//通过连接来得到一个statement
st = conn.createStatement();
//数据库操作,添加数据
for(int i = 1; i < 1000; i++){
String sql = "insert into dept(deptno,deptname,address) values (" +
+ i + ",'wanghui" + i + "','sky " + i + "')";
System.out.print(sql + "\t");
st.executeUpdate(sql); //对应insert ,update,delete
System.out.println("插入数据成功" + i);
}
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
try{
//切忌要关闭
st.close();
conn.close();
}catch (SQLException e) {
e.printStackTrace();
}
}

}

}
追问:
你确信是net.sourceforge.jtds.jdbc.Driver?
SQL Server 2005 中加载驱动为 com.microsoft.sqlserver.jdbc.SQLServerDriver,差别太大了