JDBC连接Azure SQL Server DB
直接上代码。
package test;
import java.sql.Connection;
/**
* @author :
* @date :
*/
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
public class Mssql2AzureDemo {
public static void main(String[] args) throws Exception {
Connection dbConn = null;
String sql = null;
String driverName = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
String dbURL = "jdbc:sqlserver://xxxxxxxx.database.chinacloudapi.cn:1433;DatabaseName=xxxxxxxxdb";
String userName = "xxxxxxxx";
String userPwd = "xxxxxxxx";
try {
// sqljdbcXX.jar需要导入可以到[这里](https://www.microsoft.com/zh-cn/download/details.aspx?id=11774)下载
Class.forName(driverName);
dbConn = DriverManager.getConnection(dbURL, userName, userPwd);
System.out.println("连接数据库成功");
Statement stmt = dbConn.createStatement();
sql = "create table student(NO char(20),name varchar(20),primary key(NO))";
int result = stmt.executeUpdate(sql);
if (result != -1) {
System.out.println("创建数据表成功");
sql = "insert into student(NO,name) values('2011001','徐欢欢')";
result = stmt.executeUpdate(sql);
sql = "insert into student(NO,name) values('2011002','张曦')";
result = stmt.executeUpdate(sql);
sql = "insert into student(NO,name) values('2011003','王伟')";
result = stmt.executeUpdate(sql);
sql = "select * from student";
ResultSet rs = stmt.executeQuery(sql);
System.out.println("AA\tBB");
while (rs.next()) {
System.out.println(rs.getString(1) + "\t" + rs.getString(2));
}
}
} catch (Exception e) {
e.printStackTrace();
System.out.print("连接失败");
} finally {
if (dbConn != null) {
dbConn.close();
}
}
}
}