首先,先把软件的JDK装好,以下是压缩包连接,里面有相关的调试程序、JDK以及JDBC扩展包下载,JDK的安装可参考网站:
JDBC连接数据库(Mysql&&SQLserver)
https://download.csdn.net/download/Tian208/73879547
JDBC连接SQLServer,导入相关的扩展包即可:如:sqljdbc41.jar
复制以下代码调试:
package JDBC连接MySQL;
import java.sql.*;
import java.util.Scanner;
public class demo1 {
public static void main(String[] args) {
DBHelper();
}
public static void DBHelper() {
String USER = "sa";//以sql账户登录,账号
String PWD = "sa";//密码
//声明URL(端口号和数据库名称)
String URL = "jdbc:sqlserver://localhost:1433;DatabaseName=CommogitySystem";//CommogitySystem为需要连接的数据库名
//加载驱动
String DRIVER = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
/* String url = "jdbc:sqlserver://localhost:1433;DatabaseName=CommogitySystem"+
"USER=sa"+"PWD=sa";
String DRIVER = "com.microsoft.sqlserver.jdbc.SQLServerDriver";*/
Connection con = null;
Statement st = null;
ResultSet rs = null;
try {
Class.forName(DRIVER);
con = DriverManager.getConnection(URL,USER,PWD);
System.out.println("连接成功");
} catch (Exception e) {
e.printStackTrace();
System.out.println("连接失败");
}
}
}
JDBC连接MySQL,则换成相关的扩展包:如:mysql-connector-java-5.1.7-bin.jar
MYSQL加载驱动及连接数据库的语句和SQLserver不同:
相关测试代码如下:
package JDBC连接MySQL;
import java.sql.*;
import java.util.Scanner;
public class demo1 {
public static void main(String[] args) {
DBHelper();
}
public static void DBHelper() {
String USER = "sa";//以sql账户登录,账号
String PWD = "sa";//密码
//声明URL(端口号和数据库名称)
String URL = "jdbc:mysql://localhost:3306/CommogitySystem";//CommogitySystem为需要连接的数据库名
//加载驱动
String DRIVER = "com.mysql.jdbc.Driver";
/* String url = "jdbc:sqlserver://localhost:1433;DatabaseName=CommogitySystem"+
"USER=sa"+"PWD=sa";
String DRIVER = "com.microsoft.sqlserver.jdbc.SQLServerDriver";*/
Connection con = null;
Statement st = null;
ResultSet rs = null;
try {
Class.forName(DRIVER);
con = DriverManager.getConnection(URL,USER,PWD);
System.out.println("连接成功");
} catch (Exception e) {
e.printStackTrace();
System.out.println("连接失败");
}
}
}
测试结果: