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