UNICORN3
UNICORN3 Áú¹®&´äº¯UNICORN3 Å×½ºÆ®°Ô½ÃÆÇUNICORN3 FAQUNICORN3 Á¤½Äµî·Ï ¹®ÀÇ
Unicorn Áú¹®/´äº¯
Unicorn Áú¹®/´äº¯
Unicorn3 Áú¹®/´äº¯ °Ô½ÃÆÇ ÀÔ´Ï´Ù
¿À·ù½Ã output.logÀÇ ·Î±×µµ ÇÔ²² ¾Ë·ÁÁֽðí, Áú¹®Àº ±¸Ã¼ÀûÀ¸·Î ÇØÁÖ¼¼¿ä
table »ý¼º½Ã ¿¡·¯
java
À̹ÌÁö ½½¶óÀÌ´õ º¸±â

Á¦°¡ ¾à°£ ¼öÁ¤Çߴµ¥ tableÀÌ »ý¼ºÀÌ ¾ÈµË´Ï´Ù.

HashMap ºÎºÐ¿¡¼­ <String,Object> ÇÏ°í Class.forName("oracle.jdbc.driver.OracleDriver");
À¸·Î ¹Ù²Ù¾ú½À´Ï´Ù. ±×·±µ¥ ±âÃÊ Å×À̺íÀÌ »ý¼ºÀÌ ¾ÈµÅ³×¿ä.Tomcat5.1¿¡¼­ ¼öÇàÇß½À´Ï´Ù.

 

 

public boolean dbConfig(String username, String password, String url, String characterset)   {
  ResourceBundle bundle = null;

  Connection connection = null;
  Statement statement = null;
  boolean result = true;

     try {
         bundle = ResourceBundle.getBundle("db");
            Class.forName("oracle.jdbc.driver.OracleDriver");
        // Class.forName("org.gjt.mm.mysql.Driver");
         connection = DriverManager.getConnection(url, username, password);

   statement = connection.createStatement();
          
   HashMap<String,Object> db = new HashMap<String,Object>();
   Enumeration enumeration = bundle.getKeys();
         while (enumeration.hasMoreElements()) {
          boolean exists = false;
             String bkey = (String)enumeration.nextElement();
             String value = bundle.getString(bkey);

             db.put(bkey, value);
   }
           

   for (int i = 0; i < 100; i++) {
    String keys = "query"+(i<10? "0"+i:""+i);
    
    if (db.containsKey(keys)) {
     
   
    String query = (String)db.get(keys);
    
     int key = Integer.parseInt(keys.substring(5,7));
                 
     try {
 
      if("456".indexOf(characterset) > -1) query = ko(query);
      else if ("789".indexOf(characterset) > -1) query = en(query);
      else query = query;
                        statement.executeUpdate(query);
      
      if (key < 20)
       log(ko("key "+key+" : Å×ÀÌºí »ý¼º µÇ¾ú½À´Ï´Ù"));
      else if (30 <= key && key < 40)
       log(ko("key "+key+" : À妽º°¡ »ý¼º µÇ¾ú½À´Ï´Ù"));
      else if (40 <= key && key < 50)
       log(ko("key "+key+" : µ¥ÀÌÅÍ ÃʱâÈ­ ½ÇÇàµÇ¾ú½À´Ï´Ù"));
      else if (50 <= key)
       log(ko("key "+key+" : ÃʱⵥÀÌÅÍ ÀÔ·Â ½ÇÇàµÇ¾ú½À´Ï´Ù"));
     } catch (SQLException sqle) {
      if (key < 20)
       log(ko("key "+key+" : Á¸ÀçÇÏ´Â Å×À̺íÀÔ´Ï´Ù"));
      else if (30 <= key && key < 40)
       log(ko("key "+key+" : ÀÌ¹Ì Á¸ÀçÇÏ´Â À妽º ÀÔ´Ï´Ù"));
      else if (40 <= key && key < 50)
       log(ko("key "+key+" : µ¥ÀÌÅÍ ÃʱâÈ­ ½ÇÆеǾú½À´Ï´Ù"));
      else if (50 <= key)
       log(ko("key "+key+" : ÃʱⵥÀÌÅÍ ÀÔ·Â ½ÇÆеǾú½À´Ï´Ù"));
     }
    }
   }
   

     } catch (Exception e) {
      result = false;
         log(e.toString());
     } finally {
      if (statement != null) try { statement.close(); } catch (Exception ignre) {}
      if (connection != null) try { connection.close(); } catch (Exception ignre) {}
     }

     return result;
 }

2005-04-14 15:37:23
203.245.127.***
0Á¡ (0¸í)
µ¡±Û 0°³ | ÅÂ±× 0°³ | °ü·Ã±Ûº¸±â
ű×ÀÔ·Â
½±Ç¥(,)±¸ºÐÀ¸·Î Çѹø¿¡ ¿©·¯ ű׸¦ ÀÔ·ÂÇÒ¼ö ÀÖ½À´Ï´Ù
À̸§ ºñ¹Ð¹øÈ£
Unicorn Áú¹®/´äº¯
Unicorn3 Áú¹®/´äº¯ °Ô½ÃÆÇ ÀÔ´Ï´Ù
¿À·ù½Ã output.logÀÇ ·Î±×µµ ÇÔ²² ¾Ë·ÁÁֽðí, Áú¹®Àº ±¸Ã¼ÀûÀ¸·Î ÇØÁÖ¼¼¿ä
! ¹øÈ£ Á¦¸ñ ±Û¾´ÀÌ ÀÏÀÚ Á¶È¸
¶óÀ̼¾½º ¶óÀ̼¾½º Àç½Åû ȤÀº ¼­¹ö IP º¯µ¿À¸·Î ÀÎÇÑ ¶óÀ̼¾½º ÀçÀÎÁõ ¹æ¹ý 1 GoodBug 2010-01-31 7,257
Unicorn ÇöÀç JakartaProject.com¿¡¼­ »ç¿ëÇÏ´Â JSP (Unicorn3.33) ÀÔ´Ï´Ù 5 2 GoodBug 2007-01-14 9,823
Unicorn Unicorn Test °Ô½ÃÆÇÀÌ Ãß°¡µÇ¾ú½À´Ï´Ù. 1 8 GoodBug 2005-03-28 8,571
Unicorn Unicorn °ü·Ã Q&A ÀÔ´Ï´Ù. 5 GoodBug 2005-03-03 9,089
2056 °Ô½ÃÆÇ °Ô½ÃÆÇ ¼Ö·ç¼Ç Áú¹®ÀÔ´Ï´Ù. 1 ±è¹üÁÖ 2017-07-20 224
2055 À¯´ÏÄÜ 3 ¶óÀ̼¾½º ½ÅûÇß½À´Ï´Ù. È®ÀÎ ¿äûÇÕ´Ï´Ù. dndlti 2017-04-08 406
2054 µ¥ÀÌÅͺ£À̽º¿Í Ä¿³Ø¼Ç ¿¬°áÀÌ ½ÇÆÐÇÏ¿´½À´Ï´Ù ±è»óÇö 2017-02-25 433
2053 °Ë»ö ¿¡·¯ °ü·Ã kyun 2017-02-14 385
2052 INVALID LICENSE DATA ¹®ÀÇÀÔ´Ï´Ù. ºÓÀºÅë 2016-07-02 623
2051 °ü¸® ¾÷ü º¯°æÀ¸·Î ±âÁ¸»ç¿ëÇÏ´ø ¼­¹ö¿¡¼­ ´Ù¸¥ ¼­¹ö·Î ÀÌ°ü¿¡ ´ëÇÑ ¶óÀ̼¾½º °ü·Ã.. ºÓÀºÅë 2016-04-14 990
2050 [Áú¹®] SQL ¿À·ù: ORA-01704: ¹®ÀÚ¿­ÀÌ ³Ê¹« ±é´Ï´Ù ºÓÀºÅë 2016-04-14 1,162
2049 È£½ºÆà ¼­ºñ½º¸¦ ÀÌ¿ëÇÏ´Â °æ¿ì IP ºÎºÐÀ» ¾î¶»°Ô Çϳª¿ä? ¼ÒÁÖÇѦ 2016-03-23 863
2048 °Ô½ÃÆÇ ¼³Ä¡ÇÏ·Á°íÇϴµ¥ µµ¿ÍÁÖ¼¼¿ä.. ³ë¸®Å©¸¸ 2015-11-16 950
2047 ¶óÀ̼¾½º ¿äû È®ÀκÎŹµå¸³´Ï´Ù. ³ë¸®Å©¸¸ 2015-11-13 880
2046 ¼³Ä¡¿Ï·áÈÄ ·Î±×Àι®Á¦ redori 2015-09-22 1,211
2045 Àúµµ À̹®Á¦·Î °³°í»ýÇÏ´Ù ÇØ°áÇ߳׿ä.. ÄÚ·ª 2015-11-09 1,355
2044 ¼­¹öÀÌÀü ½Ã ¶óÀ̼¾½º ¹®Á¦ ¹®ÀÇ 1 ¹Ù´Ù±î¸¶±Í 2015-06-01 1,255
2043 ¶óÀ̼¾½º °ü·Ã ¹®ÀÇ µå¸³´Ï´Ù. mak 2015-05-13 1,097
2042 À¯´ÏÄÜ º¸µå ¼³Ä¡ Áß DB ¿¡·¯ 1 JSP¹è¿ìÀÚ 2015-04-04 2,457
2041 ¼³Ä¡ ¿Ï·á ÈÄ admin.do¿¡¼­ °ü¸®ÀÚ ·Î±×ÀÎÀÌ ¾ÈµË´Ï´Ù. 1 ÂìÂêÂê 2015-03-25 1,245
copyright 2005-2024 by Unicorn