public class MicrosoftSqlStyle extends AbstractSqlStyle {

	@Override
	public String getConcatOp() {
		return "+";
	}

	@Override
	public String getLikeWildcard() {
		return "%";
	}

	@Override
	protected int getMaxListSize() {
		return 1000;
	}

	@Override
	public boolean isLargeString(String s) {
		return (s.length() > 4000);
	}

	@Override
	public boolean isBlobEnabled() {
		return true;
	}

	@Override
	public boolean isClobEnabled() {
		return true;
	}

	@Override
	public String createDateTimeIsNow(String attribute) {
		return "TRUNC(" + attribute + ", 'MI')=TRUNC(SYSDATE, 'MI')";
	}

	@Override
	public String createDateTimeIsNotNow(String attribute) {
		return "TRUNC(" + attribute + ", 'MI')!=TRUNC(SYSDATE, 'MI')";
	}

	@Override
	public void testConnection(Connection conn) throws SQLException {
		Statement testStatement = null;
		try {
			testStatement = conn.createStatement();
			testStatement.execute("SELECT count(1) FROM dbo.sysobjects");
		} finally {
			if (testStatement != null)
				try {
					testStatement.close();
				} catch (Throwable t) {
				}
		}
	}
}

public class MSSqlService extends AbstractSqlService {

	@Override
	protected Class<? extends ISqlStyle> getConfiguredSqlStyle() {
		return MicrosoftSqlStyle.class;
	}

	@Override
	protected String getConfiguredJdbcDriverName() {
		return "com.microsoft.sqlserver.jdbc.SQLServerDriver";
	}

	@Override
	protected String getConfiguredJdbcMappingName() {
		return "jdbc:sqlserver://localhost:1433;database=testdb;encrypt=false;";
	}

	@Override
	protected String getConfiguredUsername() {
		return "ADMIN";
	}

	@Override
	protected String getConfiguredPassword() {
		return "12345";
	}

}

public static void main(String[] args) {
		try {
			Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		}
        String connectionUrl =
                "jdbc:sqlserver://localhost:1433;"
                        + "database=testdb;"
                        + "user=ADMIN;"
                        + "password=12345;"
                        + "encrypt=false;";

        try (Connection connection = DriverManager.getConnection(connectionUrl);) {
            // Code here.
        	Statement statement = connection.createStatement();
        	
        	ResultSet result = statement.executeQuery("SELECT * FROM MYTABLE");
        	while(result.next()) {
        		System.out.println(result.getString(1));
        	}
        }
        // Handle any errors that may have occurred.
        catch (SQLException e) {
            e.printStackTrace();
        }
    }