MSSQL JDBC connection example added

Yogen · Yogen · commit 16b25a3f83a7 · 2017-04-05T13:27:15.000-05:00
diff --git a/pom.xml b/pom.xml
@@ -99,6 +99,20 @@
             <version>1.1.1</version>
         </dependency>
 
-
+        <!--jdbc mssql-->
+        <!-- https://mvnrepository.com/artifact/com.microsoft/sqljdbc4 -->
+        <dependency>
+            <groupId>com.microsoft</groupId>
+            <artifactId>sqljdbc4</artifactId>
+            <version>3.0</version>
+        </dependency>
     </dependencies>
+
+    <repositories>
+        <repository>
+            <id>Clojars</id>
+            <name>your custom repo</name>
+            <url>http://clojars.org/repo/</url>
+        </repository>
+    </repositories>
 </project>
diff --git a/src/main/java/com/eprogrammerz/examples/jdbc/mssql/Application.java b/src/main/java/com/eprogrammerz/examples/jdbc/mssql/Application.java
@@ -0,0 +1,48 @@
+package com.eprogrammerz.examples.jdbc.mssql;
+
+import java.sql.Connection;
+import java.sql.DatabaseMetaData;
+import java.sql.DriverManager;
+import java.sql.SQLException;
+
+/**
+ * Created by Yogen on 4/4/2017.
+ */
+public class Application {
+    public static void main(String[] args) {
+
+        /*try {
+            Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
+        } catch (ClassNotFoundException e) {
+            e.printStackTrace();
+        }*/
+
+        Connection conn = null;
+
+        try {
+
+            String dbURL = "jdbc:sqlserver://localhost:1432;databaseName=abixen-db";
+            String user = "sa";
+            String pass = "Pulch@w2";
+            conn = DriverManager.getConnection(dbURL, user, pass);
+            if (conn != null) {
+                DatabaseMetaData dm = (DatabaseMetaData) conn.getMetaData();
+                System.out.println("Driver name: " + dm.getDriverName());
+                System.out.println("Driver version: " + dm.getDriverVersion());
+                System.out.println("Product name: " + dm.getDatabaseProductName());
+                System.out.println("Product version: " + dm.getDatabaseProductVersion());
+            }
+
+        } catch (SQLException ex) {
+            ex.printStackTrace();
+        } finally {
+            try {
+                if (conn != null && !conn.isClosed()) {
+                    conn.close();
+                }
+            } catch (SQLException ex) {
+                ex.printStackTrace();
+            }
+        }
+    }
+}
