Connection connGlobal = getConnection();

// base on sample: connectURL.java      
import java.sql.*;
public class GetCardNfo {
	
	public static void main(String[] args) {
		
		// Create a variable for the connection string.
		String connectionUrl = "jdbc:sqlserver://blablabla:1433;" +
			"databaseName=discount;user=sa;password=sa;";

		// Declare the JDBC objects.
		Connection con = null;
		Statement stmt = null;
		ResultSet rs = null;

		System.setErr(System.out);
		
        	try {
        		// Establish the connection.
        		Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
            		con = DriverManager.getConnection(connectionUrl);
            
            		// Create and execute an SQL statement that returns some data.
            		String SQL = "select c.* from (select 1 k) t outer apply(select top 1 card_holder,card_number,card_balance,discount_type_01,discount_type_02,is_blocked from card c where c.card_number='"+args[0]+"')c";

            		stmt = con.createStatement();
            		rs = stmt.executeQuery(SQL);
            
            		// Iterate through the data in the result set and display it.
            		while (rs.next()) {
            		  System.out.println( 
            		     rs.getString("card_holder") + "\t" 
            		     + rs.getString("card_number")+"\t"
            		     + rs.getDouble("card_balance")+"\t"
            		     + rs.getDouble("discount_type_01")+"\t"
            		     + rs.getDouble("discount_type_02")+"\t"
            		     + rs.getInt("is_blocked") // numeric
            		  );
            		}
        	}
        
		// Handle any errors that may have occurred.
		catch (Exception e) {
			e.printStackTrace();
		}

		finally {
			if (rs != null) try { rs.close(); } catch(Exception e) {}
	    		if (stmt != null) try { stmt.close(); } catch(Exception e) {}
	    		if (con != null) try { con.close(); } catch(Exception e) {}
		}
	}
}