@@ -0,0 +1,1001 @@
+package database_comm;%0Aimport java.sql.*;%0Aimport com.microsoft.sqlserver.jdbc.*;%0A%0Apublic class DatabaseComm%0A%7B%0A%09static final String JDBC_DRIVER = %22com.mysql.jdbc.Driver%22;%0A%09static final String DB_URL = %22jdbc:mysql://localhost/EMP%22;%0A%0A%09static final String USER = %22sa%22;%0A%09static final String PASS = %22brianbrian%22;%0A%0A%09//TODO make not main%0A%09public static void main(String%5B%5D args) throws SQLException%0A%09%7B%0A%09%09System.out.println(%22starting%22);%0A%09%09try%0A%09%09%7B%0A%09%09%09Class.forName(%22com.microsoft.sqlserver.jdbc.SQLServerDriver%22);%0A%0A%09%09%09//Debug localhost string%0A%09%09%09String connectionUrl = %22jdbc:sqlserver://150.250.147.167:1433;DatabaseName=REDFOX;user=sa;password=brianbrian;%22;%0A%09%09%09%0A%09%09%09//Debug RBMS string%0A%09%09%09//String connectionUrl = %22jdbc:sqlserver://rbmsdemo.dyndns.org:1433;DatabaseName=REDFOX;user=Brian;password=brianbrian;%22;%0A%0A%09%09%09Connection con = DriverManager.getConnection(connectionUrl);%0A%09%09%09System.out.println(%22done%22);%0A%09%09%09System.out.println(con);%0A%0A%09%09%7D%0A%09%09catch (ClassNotFoundException e)%0A%09%09%7B%0A%09%09%09e.printStackTrace();%0A%09%09%7D%0A%09%7D%0A%7D%0A

Create DatabaseComm class and establish local connection