Question

eclipse怎么链接sql server数据库

Answer 1

eclipse链接sql server数据库主要代码如下
public static void main(String [] args)
{
String driverName="com.microsoft.sqlserver.jdbc.SQLServerDriver";
String dbURL="jdbc:sqlserver://localhost:1433;DatabaseName=填写数据库名";
String userName="填写用户名，sa";
String userPwd="填写密码";
try
{
Class.forName(driverName);
System.out.println("加载驱动成功！");
}catch(Exception e){
e.printStackTrace();
System.out.println("加载驱动失败！");
}
try{
Connection dbConn=DriverManager.getConnection(dbURL,userName,userPwd);
System.out.println("连接数据库成功！");
}catch(Exception e)
{
e.printStackTrace();
System.out.print("SQL Server连接失败！");
}
}