A Sussy Java Program that demonstrate the connection and retrieve data from SQL

/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */
package testsql;
import java.sql.Connection;
import java.sql.DriverManager;
import static java.sql.DriverManager.getConnection;
import java.sql.ResultSet;
import java.sql.Statement;
/**
 *
 * @author anhki
 */
public class Testsql {
    private static String DB_URL = "jdbc:sqlserver://192.168.101.23:1433;" + "databaseName=info;"+ "integratedSecurity=false;" + "encrypt=false;" + "trustServerCertificate=true;";
    private static String USER_NAME = "sa";
    private static String PASSWORD = "Su$sybaka";
    public static void main(String args[]){
        System.out.println("Hello Sussybaka");
        try{
            Connection ketnoi = getConnection(DB_URL, USER_NAME, PASSWORD);
            Statement stmt = ketnoi.createStatement();
            ResultSet out = stmt.executeQuery("SELECT * FROM Company");
            while(out.next()){
                System.out.println(out.getString(1) + " " + out.getString(2) + " " + out.getString(3));
            }
            ketnoi.close();
        } catch (Exception ex){
            ex.printStackTrace();
        }
        System.out.println("Goodbye Sussybaka");
    }
}

/* Command to create Database and import data

CREATE TABLE Company(
   name VARCHAR(20) PRIMARY KEY,
   country VARCHAR(20),
   employees INT,
   for_profit CHAR(1));

-- Insert the tuples from the slides
INSERT INTO Company VALUES ('GizmoWorks', 'USA',  20000, 'y');
INSERT INTO Company VALUES ('Canon',     'Japan', 50000, 'y');
INSERT INTO Company VALUES ('Hitachi',   'Japan', 30000, 'y');
INSERT INTO Company VALUES ('HappyCam',  'Canada',  500, 'n');

*/