...
b) Connect using SQL Server Management Studio
c) Connect using Java
Code Block | ||||||
---|---|---|---|---|---|---|
| ||||||
import java.sql.*;
import com.microsoft.sqlserver.jdbc.*;
public class Main {
public static void main(String[] args)
throws SQLException {
String connectionUrl =
"jdbc:sqlserver://sqlseclab-lsnr1.its.yale.edu:1433;" +
"databaseName=master;user=sa;password=userpassword;" +
"encrypt=true;trustServerCertificate=false;" +
"trustStore=/Users/mpoddar/IdeaProjects/keystore;" +
"trustStorePassword=keystorepass";
Connection connection = DriverManager.getConnection(connectionUrl);
Statement statement = connection.createStatement();
ResultSet resultSet = statement.executeQuery("select GetDate()");
while (resultSet.next()) {
System.out.println(resultSet.getString(1));
}
}
} |