java¶àÏ̱߳£´æoracleµÄblob×Ö¶ÎÔÚ±¾µØÉú³ÉͼÏñ
ǰЩÈÕ×ÓÕÛÌÚµÄÔÚÏßÅÄÕÕ£¬ÓÉÓÚÖ»ÊǸüÐÂblob×ֶΣ¬Ã»ÓÐÔÚ±¾µØ±£´æÕÕÆ¬£¬µ¼Ö¿ͻ§ÅÄÄÔÃÅÏëÒªµÄʱºò²»ÄÜÂíÉÏÄóöÀ´¡£Ã»ËµµÄËÈù˿ÍÊÇÉϵÛÄØ£¬×ö°É¡£Ê¹ÓÃÏ̳߳ش´½¨Èý¸öÏß³ÌÈÃ×Ô¶¨Ò»¸öÏß³ÌÄ¿±ê¹²Ïí£¨Ò²¾ÍÊǰѱíÀïµÄ¼Ç¼·Ö³Én×éͬʱִÐе¼³ö£©¡£³ÌÐòºÜ¼òµ¥£¬Ò»¹²ËĸöÀàºÍÒ»¸öojdbc14.jar°ü¡£ÓÉÓÚsqlÓï¾äд´íÁËÔì³É¶à¸öÏ̶߳ÔÒ»¸öÎļþ½øÐÐд²Ù×÷£¬º¦µÄÎÒ²éÁ˰ëÌì¡£
Ê×Ïȶ¨Òå·ÖÒ³¶ÔÏóÒ²¾ÍÊÇÿ¸öÏß³ÌÒª´¦ÀíµÄÊý¾ÝÁ¿£¨Í¨¹ý´«ÈëµÄ×ÜÒ³ÊýºÍ×ÜÐÐÊýµÃµ½Ã¿Ò³ÊýÁ¿£©
package com.main;
import java.util.ArrayList;
import java.util.List;
public class PageVO {
private String startRowNum;//·µ»Ø²éѯµÄÆðʼÐÐ
private String endRowNum;//·µ»Ø²éѯµÄÖÕÖ¹ÐÐ
private int totalRows; // Êý¾Ý²éѯ×ܼǼÊý
private int totalPages; // ·Ö³ÉÒ³Êý
private int pageRows;//ÿҳÐÐÊý
public PageVO(){
}
public PageVO(int totalRows,int totalPages){
this.totalPages = totalPages;
this.totalRows = totalRows;
}
public PageVO(String startNum,String endNum){
this.startRowNum = startNum;
this.endRowNum = endNum;
}
public String getStartRowNum() {
return startRowNum;
}
public void setStartRowNum(String startRowNum) {
this.startRowNum = startRowNum;
}
public String getEndRowNum() {
return endRowNum;
}
public void setEndRowNum(String endRowNum) {
this.endRowNum = endRowNum;
}
public List<PageVO> getPageVOList(){
List<PageVO> list = new ArrayList<PageVO>();
pageRows = totalRows/totalPages;
int currentRow = 1;//¶¨ÒåÆðʼֵ
for (int i = 0; i<totalPages; i ++){
list.add(new PageVO(new Integer(currentRow).toString(),new Integer(pageRows + currentRow).toString()));
currentRow = currentRow + pageRows + 1;
}
return list;
}
}
Æä´Î»ñµÃconnectionÀà
package com.main;
impo
Ïà¹ØÎĵµ£º
ÔڵǼemµÄʱºò¡£
²é¿´Ò»Ï emctl status dbconsole
ÕÒµ½urlµØÖ·
ÔÚÆô¶¯ºÍ¹Ø±ÕÊý¾Ý¿âµÄʱºò³öÏÖ
oracle 10g remoteoperationexception error wrong password for user
¿ÉÒÔÔÚ
×é²ßÂÔ -- >±¾µØ²ßÂÔ -->Óû§È¨ÀûÖ¸. -- >×÷ΪÅú´¦Àí×÷ÒµµÇ¼ÖмÓÈëÕâ¸öÓû§
¼´¿É. ......
HA
ÊÇHigh Availability
µÄÊ××Öĸ×éºÏ£¬·Òë¹ýÀ´£¬¿ÉÒÔ½Ð×ö¸ß¿ÉÓ㬻ò¸ß¿ÉÓÃÐÔ£¬¸ß¿ÉÓ㨻·¾³£©¡£ÎÒ¾õµÃÓ¦¸Ã˵HAÊÇÒ»¸ö¹ÛÄî¶ø²»ÊÇÒ»Ïî»òһϵÁоßÌå¼¼Êõ£¬¾ÍÏóÍø¸ñÒ»Ñù¡£×÷¹ýϵͳ
·½°¸¾ÍÖªµÀÁË£¬ÆÀ¼ÛϵͳµÄÐÔÄܵ±ÖоÍÓÐÒ»Ïî¸ß¿ÉÓ᣹ãÒåµÄ¸ß¿ÉÓÃÉæ¼°µ½ÏµÍ³µÄ¸÷¸ö·½Ã棬¼òµ¥À´Ëµ£¬ÈÃϵͳ²»»áÖжÏ
ÔËÐУ¬¾ÍÊǸ߿ÉÓᣰüÀ¨È ......
.Frm644 { display:none; }
¡¡¡¡1¡£ÒѾ¼ìÑéµÄÓï¾äºÍÒÑÔÚ¹²Ïí³ØÖеÄÓï¾äÖ®¼äÒªÍêȫһÑù
¡¡¡¡2¡£±äÁ¿Ãû³Æ¾¡Á¿Ò»ÖÂ
¡¡¡¡3¡£ºÏÀíʹÓÃÍâÁª½Ó
¡¡¡¡4¡£ÉÙ
Óöà²ãǶÌ×
¡¡¡¡5¡£¶àÓò¢·¢
¡¡¡¡
¡¡¡¡Óï¾äµÄÓÅ»¯²½ÖèÒ»°ãÓУº
¡¡¡¡1¡£µ÷ÕûsgaÇø£¬Ê¹µÃsgaÇøµÄÊÇÓÃ×îÓÅ¡£
¡¡
¡¡2¡£sqlÓï¾ä±¾ÉíµÄÓÅ»¯£¬¹¤¾ßÓÐexplain,sql trace ......
˵µ½OAϵͳ¾Í»áÏëµ½·¢²¼¹«¸æ¡¢ÉóÅúÎļþ¡¢Îļþ¹ÜÀíµÈµÈÕâЩ¹¦ÄÜ£¬£¬µ½ÁË¿ª·¢ÈËÔ±ÊÖÀï¾ÍÊÇ´æ´¢Êý¾Ý¡¢²éѯÊý¾Ý£¬ÍùÍù²»Í£µÄ×öÖØ¸´¹¤×÷£¬ÓÚÊǾÍÓÐÁËOA±íµ¥ÒýÇæµÄÉèÏëºÍ¹¹Ë¼¡£ÓÃjavascript¶¨Òå±íµ¥£¬ÓÃjavaÇý¶¯XML£¬×Ô¶¯´´½¨¡¢ÐÞ¸ÄÊý¾Ý¿â¡£ÊµÏÖ¶Ô±íµ¥µÄͼÐλ¯ÖÆ×÷£¬¼´Ê¹ÊǷǼ¼ÊõÈËÔ±Ò²¿ÉËæÒâÉè¼Æ³ö×Ô¼º¹¹ÏëµÄ±íµ¥¹¦ÄÜ¡£
JAVA³ÌÐ ......
×î½üÓ¦ÀÏʦµÄÒªÇó¿´ÁËÊý¾Ý¿â¡£ÔÚÍøÉÏÕÒÁËÊÓÆµ£¬ÊǸö½ÌÓý»ú¹¹·¢µÄ¡£ÄǸöÊÓÆµ¿´µÃÎÒÖ±·¸À§£¬³ýÁËÀÏʦ½²¿Î½²´íµÄʱºò¡£
ÊÓÆµ½²µÃºÜdzÏÔ£¬µÚÒ»Õ½²ÁËsqlÊý¾Ý¿â½á¹¹£¬ÓÐʲôģÐÍ¡£½Ó׎²Ö÷¼ü£¬Íâ¼ü£¬È»ºóÊǽ¨±íÓï¾ä£¬²éѯÓï¾äµÈµÈ¡£
show databases ÏÔʾÊý¾Ý¿â¡£
use ** ʹÓÃÊý¾Ý¿â¡£
create table ** (**,**,**) ½¨±í¡£
se ......