import java.sql.*;public class TestConnection
{
public static void main(String[] args) throws Exception
{
String driverName = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
String dbURL = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=myDataBase";
String userName = "sa";
String userPwd = "";
Connection dbConn=null;
try
{
Class.forName(driverName);
dbConn = DriverManager.getConnection(dbURL, userName, userPwd);
System.out.println("Connection Successful...");
}
catch (Exception e) { e.printStackTrace(); }
finally{dbConn.close();}
}
}异常描述:
{
public static void main(String[] args) throws Exception
{
String driverName = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
String dbURL = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=myDataBase";
String userName = "sa";
String userPwd = "";
Connection dbConn=null;
try
{
Class.forName(driverName);
dbConn = DriverManager.getConnection(dbURL, userName, userPwd);
System.out.println("Connection Successful...");
}
catch (Exception e) { e.printStackTrace(); }
finally{dbConn.close();}
}
}异常描述:
改成下面的试试,九成都能成功。
String driverName = "sun.jdbc.odbc.JdbcOdbcDriver";
String dbURL = "jdbc:odbc:yourDataBaseName";
你写在一个主程序类中public static void main(String[] args) throws Exception
{}
把void main 改掉换一个类,这个类一般是用来调用的不用void main()的。。刚连接上,,最后又关闭了,,
根本都没有对数据进于相应操作。。或者是你的数据问题。。
可能是你登陆数据库时,是用Windows 身份去登陆了,,而不是用SQL server 身份去登陆启动数据时留意一下看看
2.其次检查你是否已经把jar包导入到项目下面;
3.将 String dbURL = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=myDataBase";
改成 String dbURL = "jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=myDataBase";
或者 String dbURL = "jdbc:microsoft:sqlserver://127.0.0.1:1433/myDataBase";