±Û¾´ÀÌ :°Á¤È 2000³â 2¿ù 02ÀÏ 11:45:48
else if(check.equals("C"))
query = new String("SELECT * FROM MCATDTA.MCAT01A "+
"WHERE MARDAC <> 'D' AND MAKDC2 = '20' OR MAKDC2 = '30' AND MAKDC1 = '10' ORDER BY MAFTDT, MASASQ ") ;
¾Æ·¡ ´ë´äÇϽźР±×°Íµµ Çغ¸´Ï ¾Æ´Ï³×¿ä
À§ÀÇ sql¹®¿¡¼ Á¦°¡ »ý°¢Çϱâ·Î´Â MARDAC°¡ 'D'ÀÎ °ÍÀÌ ³ª¿ÀÁö ¾Ê´Â °ÍÀÌ Á¤»óÀÎ°Í °°Àºµ¥ ÀÚ²Ù MARDAC°¡ 'D'ÀÎ ·¹Äڵ尡 ³ª¿È´Ï´Ù. ¿øÀÎÀ» ¸ð¸£°Ú½À´Ï´Ù.