Java Programming

I have an Accouting Program in my firm called ETA. She uses SQL Server.

I tried to connect it with jdt packet, but it did not work.
I tried to connect it with microsoft's packet, but it did not work.
I tried to connect it with configuring ODBC-SQLServer then JDBC-ODBC, the it worked.

I tried to sniff some data with
SELECT "+cn[0]+", "+cn[1]+" FROM "+tn+" WITH (NOLOCK) ORDER BY "+cn[0]
where
cn[0]="MUHKOD";
cn[1]="MUHADI1";
tn="MUHHESAP";
it worked

I tried to sniff some data with
"SELECT "+cn[0]+", "+cn[1]+" FROM "+tn+" WITH (NOLOCK) ORDER BY "+cn[0]
where
cn[0]="MUHKOD";
cn[1]="MUHADI1";
tn="MUHHESAP";
it worked

I tried to sniff some data with
"SELECT "+cn[0]+", "+cn[1]+", "+cn[2]+", "+cn[3]+" FROM "+tn+" WITH (NOLOCK) ORDER BY "+cn[0];
where
cn[0]="STKKOD";
cn[1]="STKCINSI";
cn[2]="STKBAKIYE";
cn[3]="STKBIRIM";
tn="STKKART";
it worked

Now I want to try another sqlCommand that ETA uses and works on my java program:
SELECT MUHHARTAR AS 'Tarih', MUHHARNO AS 'Fiş No', MUHHARACIKLAMA AS 'Açıklama', 'T' = CASE WHEN MUHHARBATIPI=1 THEN 'B' ELSE 'A' END, MUHHARTUTAR AS 'Tutar',MUHHARDOVKOD AS 'Döviz Kodu', MUHHARDOVTUR AS 'Döviz Türü', MUHHARDOVTUTAR AS 'Döviz Tutarı', MUHHARREFNO AS 'Fiş Ref.No',MUHHARYEVNO AS 'Yevmiye No', MUHFTKOD AS 'Fiş Cinsi' FROM MUHHAR WITH(NOLOCK) LEFT JOIN MUHFISTIP WITH(NOLOCK) ON MUHHAR.MUHHARCINSI=MUHFISTIP.MUHFTNO WHERE MUHHARMUHKOD=:MUHKOD ORDER BY MUHHARTAR,MUHHARREFNO,MUHHARSIRANO
but it returns
java.sql.SQLException: [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near ':'.
at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6957)
at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7114)
at sun.jdbc.odbc.JdbcOdbc.SQLExecDirect(JdbcOdbc.java:3110)
at sun.jdbc.odbc.JdbcOdbcStatement.execute(JdbcOdbcStatement.java:338)
at sun.jdbc.odbc.JdbcOdbcStatement.executeQuery(JdbcOdbcStatement.java:253)
at com.tugalsan.libraries.io.sql.TK_SQLQuery.<init>(TK_SQLQuery.java:62)
at com.tugalsan.libraries.io.sql.TK_SQLQuery.<init>(TK_SQLQuery.java:47)
at com.tugalsan.libraries.io.sql.TK_SQLConnection.executeQuery(TK_SQLConnection.java:70)
at javaapplication2.Main.main(Main.java:17)

could anyone help me? I could not find what it means =: on an sql statement and have no idea why it does not works.