JDBC连接Azure SQL Server DB

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();
            }
        }
    }

}