看了网上很多在家数据库的方法,都显示驱加载不了。后来自己琢磨原来是这样的,ODBC实例如下:
package connection;
import java.sql.*;
public class ConnectionSQL {
public ConnectionSQL(){
String driverName = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
System.out.println("驱动加载成功");
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
} catch (Exception ex) {
System.out.println("驱动加载失败");
ex.printStackTrace();
}
try {
Connection con=DriverManager.getConnection("jdbc:odbc:Test", "sa", "wzq1314520");
System.out.println("数据库加载成功");
con.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public static void main(String[] args) {
ConnectionSQL getConn = new ConnectionSQL();
}
}
JDBC实例如下(注意导入相应的sqljdbc.jar):
package connection;
import java.sql.*;
public class ConnecJDBC {
public ConnecJDBC(){
try {
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
System.out.println("数据库驱动加载成功");
try {
Connection con = DriverManager.getConnection(
"jdbc:sqlserver://localhost:1433;DatabaseName=Test",
"sa", "wzq1314520");
System.out.println("数据库加载成功");
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
} catch (ClassNotFoundException e) {
System.out.println("数据库驱动加载失败");
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public static void main(String[] args) {
new ConnecJDBC();
}
}