Java程序通过JDBC连接远程的数据库SQL Server

代码如下：

/** * @作者：刘猛 * @时间：2017.11.12 * @功能：纯JDBC连接数据库 */package com.jdbc;import java.sql.*;import javax.xml.crypto.Data;@SuppressWarnings("unused")public class Jdbc {public static void main(String[] args) {// TODO Auto-generated method stubDatabaseConnection databaseConnection = new DatabaseConnection();}}//定义一个连接数据库的类class DatabaseConnection{//创建一个用于连接的对象Connection ct = null;//创建一个发送sql语句的对象PreparedStatement ps = null;//创建一个用于保存结果集的对象ResultSet rs = null;//构造函数public DatabaseConnection(){try {//加载驱动Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); //得到连接ct = DriverManager.getConnection("jdbc:sqlserver://rm-wz9lf7c7u0iker54no.sqlserver.rds.aliyuncs.com:3433;DatabaseName=SMOS","wtuliumeng","1");//进行crud操作//增加操作ps = ct.prepareStatement("insert into student(SNo,SName) values(?,?)");ps.setString(1, "1513120188");ps.setString(2, "阿三");ps.executeUpdate();//删除操作ps = ct.prepareStatement("delete from student where SName = ?");ps.setString(1, "刘猛");ps.executeUpdate();//修改操作ps = ct.prepareStatement("update student set SNo = ? where SName = ?");ps.setString(1, "1");ps.setString(2, "马云");ps.executeUpdate();//查询操作ps = ct.prepareStatement("select * from student");//收集结果集rs = ps.executeQuery();//循环输出while(rs.next()){String a = rs.getString(1);String b = rs.getString(2);//输出结果System.out.println(a + " " + b );}} catch (Exception e) {// TODO: handle exceptione.printStackTrace();}finally{//关闭资源try {if(rs != null){rs.close();}if(ps != null){ps.close();}if(ct != null){ct.close();}} catch (Exception e2) {// TODO: handle exceptione2.printStackTrace();}}}}