SQL¹® Áú¹® ÀÔ´Ï´Ù.


[ ´ÙÀ½ ±Ûµé ] [ À̾ ±Û¿Ã¸®±â(´äÇϱâ) ] [ ÀÚ¹Ù ¹¯°í ´äÇϱâ ]

±Û¾´ÀÌ :°­Á¤È­ 2000³â 2¿ù 19ÀÏ 12:23:35

if(mkym.equals("9999"))
{
if(saam.equals("9999"))
{
query = new String("SELECT BASAYM, BASASQ, BAMDNM, BAMKYM, BAMISS, BACONM, BASAAM, BAFTDT FROM MCATDTA.ATBT01 WHERE BAMDNM LIKE '%"+mdnm+"%' AND (BARDAC <> 'S' OR BARDAC <> 'D' OR BARDAC <> 'B') ORDER BY BAFTDT DESC");
//out.println( query + "<br>");
}
else if(saam.equals("1000"))
{
query= new String("SELECT BASAYM, BASASQ, BAMDNM, BAMKYM, BAMISS, BACONM, BASAAM, BAFTDT FROM MCATDTA.ATBT01 WHERE BAMDNM LIKE '%"+mdnm+"%' AND BASAAM BETWEEN "+saam+" AND 9999 AND (BARDAC <> 'S' OR BARDAC <> 'D' OR BARDAC <> 'B') ORDER BY BAFTDT DESC ");
//out.println( query + "<br>");


}
else if(saam.equals("0"))
{
query= new String("SELECT BASAYM, BASASQ, BAMDNM, BAMKYM, BAMISS, BACONM, BASAAM, BAFTDT FROM MCATDTA.ATBT01 WHERE BAMDNM LIKE '%"+mdnm+"%' AND BASAAM <= 99 AND (BARDAC <> 'S' OR BARDAC <> 'D' OR BARDAC <> 'B') ORDER BY BAFTDT DESC ");
//out.println( query + "<br>");


}
else
{
query= new String("SELECT BASAYM, BASASQ, BAMDNM, BAMKYM, BAMISS, BACONM, BASAAM, BAFTDT FROM MCATDTA.ATBT01 WHERE BAMDNM LIKE '%"+mdnm+"%' AND BASAAM BETWEEN "+saam+" AND "+saam1+" AND (BARDAC <> 'S' OR BARDAC <> 'D' OR BARDAC <> 'B') ORDER BY BAFTDT DESC ");
//out.println( query + "<br>");

}
}
else
{
if(saam.equals("9999"))
{
query = new String("SELECT BASAYM, BASASQ, BAMDNM, BAMKYM, BAMISS, BACONM, BASAAM, BAFTDT FROM MCATDTA.ATBT01 WHERE BAMDNM LIKE '%"+mdnm+"%' AND BAMKYM BETWEEN "+mkym1+" AND "+mkym2+" AND (BARDAC <> 'S' OR BARDAC <> 'D' OR BARDAC <> 'B') ORDER BY BAFTDT DESC ");
//out.println( query + "<br>");


}
else if(saam.equals("1000"))
{
query= new String("SELECT BASAYM, BASASQ, BAMDNM, BAMKYM, BAMISS, BACONM, BASAAM, BAFTDT FROM MCATDTA.ATBT01 WHERE BAMDNM LIKE '%"+mdnm+"%' AND BASAAM BETWEEN "+saam+" AND 9999 AND (BARDAC <> 'S' OR BARDAC <> 'D' OR BARDAC <> 'B') ORDER BY BAFTDT DESC ");
//out.println( query + "<br>");


}
else if(saam.equals("0"))
{
query= new String("SELECT BASAYM, BASASQ, BAMDNM, BAMKYM, BAMISS, BACONM, BASAAM, BAFTDT FROM MCATDTA.ATBT01 WHERE BAMDNM LIKE '%"+mdnm+"%' AND BASAAM BETWEEN 0 AND 99 AND BAMKYM BETWEEN "+mkym1+" AND "+mkym2+" AND (BARDAC <> 'S' OR BARDAC <> 'D' OR BARDAC <> 'B') ORDER BY BAFTDT DESC ");
//out.println( query + "<br>");


}
else
{
query= new String("SELECT BASAYM, BASASQ, BAMDNM, BAMKYM, BAMISS, BACONM, BASAAM, BAFTDT FROM MCATDTA.ATBT01 WHERE BAMDNM LIKE '%"+mdnm+"%' AND BASAAM BETWEEN "+saam+" AND "+saam1+" AND (BARDAC <> 'S' OR BARDAC <> 'D' OR BARDAC <> 'B') ORDER BY BAFTDT DESC ");
//out.println( query + "<br>");

}
}
À§ÀÇ ¹®Àå¿¡¼­ BARDAC°¡ 'D' °ÍÀÌ ³ª¿ÀÁö ¾Ê¾Æ¾ß Çϴµ¥ ³ª¿É´Ï´Ù.
´©°¡ Ʋ¸°°÷ÀÌ ÀÖ´ÂÁö Á» ÁöÀûÇØ ÁÖ¼¼¿ä....



´ÙÀ½ ±Ûµé:



À̾ ±Û¿Ã¸®±â(´äÇϱâ)

À̸§:
E-Mail:
Á¦¸ñ:
³»¿ë:
HTML ÅÂ±× Æ÷ÇÔ ¿©ºÎ: HTML ¹®¼­ÀÏ °æ¿ì üũ
°ü·Ã URL(¼±ÅÃ):
URL Á¦¸ñ(¼±ÅÃ):
°ü·Ã À̹ÌÁö URL:


[ ´ÙÀ½ ±Ûµé ] [ À̾ ±Û¿Ã¸®±â(´äÇϱâ) ] [ ÀÚ¹Ù ¹¯°í ´äÇϱâ ]