812-345-7636

ÎÄÕÂÍƼö

[¶þºÏÒ»]C#¶ÁÈ¡ºÍµ¼³öEXCELÀà¿â(¿É²Ù×÷¶à¸öSHEET)

    ¸Ä½øµÄÒ»¸öEXCELÀà,¿ÉÒÔ¶ÁÈ¡EXCEL,Ò²¿ÉÒÔ½«ÄÚÈݵ¼³öµ½EXCEL.²Ù×÷¶à¸öSHEET±È½Ï·½±ã. ¶øÇÒÎÞÐë°²×°ÈκÎEXCEL. 1.¶ÁÈ¡ public void Read(string FileName) { AppLibrary.ReadExcel.Workbook workbook = null; workbook = AppLibrary.ReadExcel.Workbook.getWorkbook(FileName); int k = 0; System.Text.StringBuilder sb = new System.Text.StringBuilder(); foreach (AppLibrary.ReadExcel.Sheet sheet in workbook.Sheets) { k++; sb.Append("µ±Ç°ÎªµÚ" + k + "¸öSheet

    "); sb.Append("

    "); for (int iRow = 0; iRow < sheet.Rows; iRow++) { sb.Append(""); sb.Append(""); for (int iCol = 0; iCol < sheet.Columns; iCol++) { AppLibrary.ReadExcel.Cell cell = sheet.getCell(iCol, iRow); object val = cell.Value; string cellValue = (val != null) ? val.ToString() : ""; sb.Append(""); } sb.Append(""); } sb.Append("
    "); sb.Append("µ±Ç°ÎªµÚ" + (iRow + 1) + "ÐÐ"); sb.Append(""); sb.Append(cellValue); sb.Append("


    "); } Response.Write(sb.ToString()); }...

40527805842017-06-28×÷Õߣº²Æ±ê

[instant message]ÓÃasp.net+ jqueryʵÏÖcomet¼´Ê±ÏûÏ¢»úÖÆ

    1.asp.net µ±¿Í»§¶ÎµÚÒ»´ÎÁ¬½ÓµÄʱºòͨ¹ý ThreadPool.RegisterWaitForSingleObject(client.EventWaitHandle, new System.Threading.WaitOrTimerCallback(WaitOrTimerCallback), client, ConnectInterval, true)ÏòÏ̳߳ØÌí¼ÓÒ»¸ö¿ÉÒÔ¶¨Ê±Ö´Ðк¯Êý, ÉèÖà public AutoResetEvent EventWaitHandle = new AutoResetEvent(false); client.EventWaitHandle µÄ״̬,ʵÏÖÁ¢¼´Ïò¿Í»§¶Ë·¢ËÍÏûÏ¢,ͨ¹ýÕâ¸öº¯ÊýʵÏÖ¿Í»§¶ËµÄ³¤Á¬½Ó.±£³Ö¿Í»§¶ËµÄ¿É³ÖÐøÐÔ. ...

ÔĶÁÈ«ÎÄ>>2017-02-09×÷Õߣº²Æ±ê

oracleÓÅ»¯Ïà¹ØÄÚÈÝ

    1.°ó¶¨±äÁ¿ ÔÚoracle ÖУ¬¶ÔÓÚÒ»¸öÌá½»µÄsqlÓï¾ä,´æÔÚÁ½ÖÖ¿ÉÑ¡µÄ½âÎö¹ý³Ì, Ò»ÖÖ½Ð×öÓ²½âÎö,Ò»ÖÖ½Ð×öÈí½âÎö. Ò»¸öÓ²½âÎöÐèÒª¾­½âÎö,Öƶ¨Ö´Ðз¾¶,ÓÅ»¯·ÃÎʼƻ®µÈÐí¶àµÄ²½Öè.Ó²½âÊͲ»½ö½öºÄ·Ñ´óÁ¿µÄcpu£¬¸üÖØÒªµÄÊÇ»áÕ¼¾ÝÖØÒªµÄÃÇãÅ£¨latch£©×ÊÔ´£¬ÑÏÖصÄÓ°ÏìϵͳµÄ¹æÄ£µÄÀ©´ó£¨¼´ÏÞÖÆÁËϵͳµÄ²¢·¢ÐУ©£¬ ¶øÇÒÒýÆðµÄÎÊÌâ²»ÄÜͨ¹ýÔö¼ÓÄÚ´æÌõºÍcpuµÄÊýÁ¿À´½â¾ö¡£Ö®ËùÒÔÕâÑùÊÇÒòΪÃÅãÅÊÇΪÁË˳Ðò·ÃÎÊÒÔ¼°ÐÞ¸ÄһЩÄÚ´æÇøÓò¶øÉèÖõģ¬ÕâЩÄÚ´æÇøÓòÊDz»Äܱ»Í¬Ê±Ð޸ġ£µ±Ò»¸ösqlÓï¾äÌá½»ºó£¬oracle»áÊ×Ïȼì²éһϹ²Ïí»º³å³Ø£¨shared pool£©ÀïÓÐûÓÐÓëÖ®ÍêÈ«ÏàͬµÄÓï¾ä£¬Èç¹ûÓеĻ°Ö»ÐëÖ´ÐÐÈí·ÖÎö¼´¿É£¬·ñÔò¾ÍµÃ½øÐÐÓ²·ÖÎö¡£ ¶øΨһʹµÃoracle Äܹ»Öظ´ÀûÓÃÖ´Ðмƻ®µÄ·½·¨¾ÍÊDzÉÓð󶨱äÁ¿¡£°ó¶¨±äÁ¿µÄʵÖʾÍÊÇÓÃÓÚÌæ´úsqlÓï¾äÖеij£Á¿µÄÌæ´ú±äÁ¿¡£°ó¶¨±äÁ¿Äܹ»Ê¹µÃÿ´ÎÌá½»µÄsqlÓï¾ä¶¼ÍêÈ«Ò»Ñù¡£ ÆÕͨsqlÓï¾ä£º SELECT fname, lname, pcode FROM cust WHERE id = 674; SELECT fname, lname, pcode FROM cust WHERE id = 234; SELECT fname, lname, pcode FROM cust WHERE id = 332;...

ÔĶÁÈ«ÎÄ>>2017-01-26×÷Õߣº²Æ±ê

ORACLE DBAѧϰ±Ê¼Ç--ʹÓÃLOGON TRIGGERÏÞÖÆÓû§µÇ½

    ͨ¹ýTRIGGER ÏÞÖÆÓû§µÇ½ʱµÄIPµØÖ·,Ó¦ÓóÌÐò.¼ÓÇ¿¶ÔORACLEÓû§µÄ²Ù×÷Éó¼Æ£¬ Ò²¿ÉÒÔ¸ù¾ÝÐèÒª¼ÓÈëÆäËûµÄһЩÏÞÖÆ£® ·ÇDBAȨÏÞ¿ÉÒÔͨ¹ýSYS_CONTEXTº¯Êý»ñÈ¡µ±Ç°V$SESSIONµÄ»á»°ÐÅÏ¢. SYS_CONTEXTº¯ÊýµÄÓ÷¨£ºSYS_CONTEXT('namespace', 'parameter' [, length ]); ͨ¹ýÒÔÏÂÓï¾ä¿ÉÒԲ鿴V$SESSION²¿·ÖÐÅÏ¢.....

ÔĶÁÈ«ÎÄ>>2017-01-15×÷Õߣº²Æ±ê

ORACLE DBAѧϰ±Ê¼Ç--¹ÜÀí¹éµµÈÕÖ¾Îļþ

    ¹éµµÈÕÖ¾Îļþ£ºÊÇ´¦Óڷǻ£¨INACTIVE£©µÄ״̬µÄÖØ×öÈÕÖ¾ÎļþµÄ±¸·Ý¡£Ëü¶ÔORACLEÊý¾Ý¿âµÄ±¸·ÝºÍ»Ö¸´ÆðÖÁ¹ØÖØÒªµÄ×÷Óá£ÊÇÁª»úÖØ×öÈÕÖ¾ÎļþµÄÒ»¸ö¸±±¾£¬Óë±»¸´ÖƵijÉÔ±Íê³ÉÒ»Ñù£¬¼´ÖØ×ö¼Ç¼Ïàͬ£¬ÈÕÖ¾ÐòÁкÅÏàͬ¡£ Ò»¡¢Êý¾Ý¿âµÄ¹éµµÓë·Ç¹éµµÄ£Ê½£º 1£® µ±Êý¾Ý¿â´¦ÓÚNOACRCHIVELOGģʽʱ£¬²»¶ÔÖØ×öÈÕÖ¾Îļþ½øÐй鵵£¬Ö±½Ó¸²¸Ç¾ÉµÄÖØ×öÈÕÖ¾Îļþ£¬´ËʱÊý¾Ý¿âÖ»ÄÜ´ÓÀý³Ìʧ°ÜÖнøÐлָ´¡£ Ìص㣺 a. ·¢ÉúÈÕÖ¾Çл»Ê±£¨alter system switch logfile£©£¬LGWRºǫ́½ø³Ì¿ÉÒÔÎÞÌõ¼þ¸²¸ÇÔ­À´µÄÒѾ­±äΪ·Ç»î¶¯µÄ£¨INACTIVE£©ÖØ×öÈÕÖ¾ÎļþµÄÄÚÈÝ¡£ b. ½øÐÐÊý¾Ý¿â±¸·Ýʱ£¬±ØÐëÏÈʹÓÃSHUTDOWN »òÕßSHUTDOWN IMMEDIATEÃüÁîÏȹرÕÊý¾Ý¿â£¬È»ºó²ÅÄÜͨ¹ý²Ù×÷ϵͳ±¸·ÝËùÓеÄÎïÀíÎļþ¡£¼´À䱸·Ý¡£²»ÄܽøÐÐÁª»úµÄÈȱ¸·Ý¡£ c. NOACRCHIVELOGģʽʱ£¬Ö»Äܱ£»¤Êý¾Ý¿âÃâÓÚÀý³Ìʧ°Ü£¬µ«²»Äܱ£»¤Êý¾Ý¿âÃâÓÚ½éÖÊʧ°Ü¡£ d. NOACRCHIVELOGģʽ²»ÐèÒª¿¼ÂÇ´æ´¢¿Õ¼äµÄÎÊÌâ¡£ 2£® µ±Êý¾Ý¿â´¦ÓÚACRCHIVELOGģʽʱºò£¬ÏµÍ³Í¨¹ýºǫ́½ø³ÌARCnÀ´°ïÖúDBA×Ô¶¯Íê³É¶ÔÖØ×öÈÕÖ¾Îļþ½øÐй鵵£¬¹éµµÖ®ºó²Å¸²¸Ç¾ÉµÄÖØ×öÈÕÖ¾Îļþ£¬²¢½«Æ临ÖƵ½Ò»¸öÖ¸¶¨µÄλÖ㬳ÉΪ¹éµµÈÕÖ¾Îļþ£¬´ËʱÊý¾Ý¿â»¹ÄܽøÒ»²½´Ó½éÖÊʧ°ÜÖлָ´¡£¼´¿É½«Êý¾ÝµÄËðʧ¼õÉÙµ½×îС£¬¿ÉÓÃÐÔÌá¸ßµ½×î¸ß¡£ Ìص㣺 a. µ±ACRCHIVELOGģʽʱ¡£¿ÉÒÔ¶ÔÊý¾Ý¿â½øÐÐÁª»úµÄÈȱ¸·Ý¡£ b. µ±³öÏÖÊý¾ÝÎļþËð»µÊ±£¬³ýÁËSYSTEM±í¿Õ¼äµÄÊý¾ÝÎļþ£¬ÆäËû±í¿Õ¼ä¶¼¿ÉÒÔÔÚÊý¾Ý¿â´¦ÓÚOPENʱ»Ö¸´¡£ c. Ö´ÐÐÊý¾Ý¿â±¸·Ýʱ£¬²»½ö¿ÉÒÔ½øÐÐÍê³É»Ö¸´£¬Ò²¿ÉÒÔÖ¸¶¨»Ö¸´µ½Ä³¸öÌض¨µÄʱ¼äµã¡£ Ò»¡¢Êý¾Ý¿â¹éµµ²ÎÊý...

ÔĶÁÈ«ÎÄ>>2017-01-04×÷Õߣº²Æ±ê

ORACLE DBAѧϰ±Ê¼Ç--ÈÕÖ¾Îļþ(ʹÓÃLogMiner·ÖÎöÈÕÖ¾)

    REDOÈÕÖ¾Îļþ ÖØ×öÈÕÖ¾ÎļþÖ÷ÒªÒÔÖØ×ö¼Ç¼µÄÐÎʽ¼Ç¼£¬±£´æ¶ÔÊý¾Ý¿âËù×öµÄÐ޸ģ¨»òÕßÊÂÎñµÄ±ä»¯£©£¬°üÀ¨Óû§Ö´ÐÐDML»òÕßDDLÓï¾ä¶ÔÊý¾Ý¿âµÄÐ޸ģ¬ Ò²°üÀ¨DBA¶ÔÊý¾Ý¿â½á¹¹µÄÐÞ¸Ä,ÖØ×öÈÕÖ¾ÎļþÒ²ÐèÒª¶à·¸´ÓᣠÈÕÖ¾ÎļþµÄдÈëÔ­Ôò£º 1£® дÈëµÄ´ÎÐòÒªÑϸñ°´²¢·¢ÊÂÎñµÄÖ´ÐÐ˳Ðò 2£® ±ØÐëдÈëÖØ×öÈÕÖ¾ÎļþÔÙдÈëÊý¾ÝÎļþ ÖØ×öÈÕÖ¾µÄÑ­»·Ð´È룺 µ±µÚÒ»×éÈÕÖ¾±»Ð´ÂúÖ®ºó¾Í½øÐÐÖØ×öÈÕÖ¾µÄÇл»£¨ALTER SYSTEM SWITCH LOGFILE£©£¬ÒԱ㽫ÖØ×öÈÕÖ¾µÄ¼Ç¼дÈëµÚ¶þ¸öÖØ×öÈÕÖ¾Îļþ£¬ÒÀ´ÎÀàÍÆ¡£...

ÔĶÁÈ«ÎÄ>>2016-11-24×÷Õߣº²Æ±ê