Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- package com.sqldbsamples;
- import java.sql.Connection;
- import java.sql.Statement;
- import java.sql.PreparedStatement;
- import java.sql.ResultSet;
- import java.sql.DriverManager;
- public class App {
- public static void main(String[] args) {
- // Connect to database
- String hostName = "vo6901-sql-server.database.windows.net";
- String dbName = "cs-dsa-4513-sql-db";
- String user = "vo6901";
- String url = String.format("jdbc:sqlserver://%s:1433;database=%s;user=%s;password=%s;encrypt=true;hostNameInCertificate=*.database.windows.net;loginTimeout=30;", hostName, dbName, user, password);
- Connection connection = null;
- try {
- connection = DriverManager.getConnection(url);
- String schema = connection.getSchema();
- System.out.println("Successful connection - Schema: " + schema);
- System.out.println("Query data example:");
- System.out.println("=========================================");
- // Create and execute a SELECT SQL statement.
- String selectSql = "SELECT TOP 20 pc.Name as CategoryName, p.name as ProductName "
- + "FROM [SalesLT].[ProductCategory] pc "
- + "JOIN [SalesLT].[Product] p ON pc.productcategoryid = p.productcategoryid";
- try (Statement statement = connection.createStatement();
- ResultSet resultSet = statement.executeQuery(selectSql)) {
- // Print results from select statement
- System.out.println("Top 20 categories:");
- while (resultSet.next())
- {
- System.out.println(resultSet.getString(1) + " "
- + resultSet.getString(2));
- }
- connection.close();
- }
- }
- catch (Exception e) {
- e.printStackTrace();
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement