ÔÚweblogic8.14ÀïÃæ²Ù×÷oracle´ó×Ö¶Î
1.Ê×ÏÈ˵Ã÷һϣº
ÔÒòÊÇÒòΪÎÒÔÚ×öÕâ¸öÏîĿʱ£¬±»ÏÞÖÆµÃÌ«¶à£¬weblogicºÍoracleµÄ°æ±¾²»Äܱ䣬ҪʹÓÃÔÀ´µÄ°æ±¾¡£
Òò´ËÄØ¡£²Ù×÷ÆðÀ´±È½ÏÂé·³¡£¶øÇÒ²»Äܸü¸ÄÔ±¾¹¤³ÌÀïÃæµÄJar°ü£¨ËüÀïÃæ´æÔÚÁËoracle14.jar°ü£¬µ«±È½Ï¾É£©
weblogic°æ±¾Îª£º8.14
oracle°æ±¾Îª£º9i
2.ÔÚÕâÀïÄØ£¬Ê¹ÓÃhibernate£¬ÒÔÁ÷µÄÐÎʽ¶ÁÈ¡µ½Êý¾ÝÀïÃæ¡£
3.Êý¾Ý±íÄØ£ºÊÇÒ»Õű£´æÎļþµÄ±í
ÈçÏ£º
CREATE TABLE T_UPLOAD_FILE (
FILE_ID VARCHAR2(60) PRIMARY KEY NOT NULL,
FILE_NAME VARCHAR2(250) NOT NULL,
OLD_FILE_NAME VARCHAR2(250) NOT NULL,
FILE_PATH VARCHAR2(250) NOT NULL,
FILE_TYPE VARCHAR2(10),
FILE_SIZE LONG,
STATUS CHAR(1) NOT NULL,
UPLOAD_TIME TIMESTAMP,
OPERATOR_ID VARCHAR2(30),
FILE_CONTENT BLOB
);
4.Ò»¸öÉÏ´«ÎļþµÄÎļþ¶ÔÏó£º
UploadFileBFO£º
private java.lang.String fileId;
private java.lang.String fileName;
private java.lang.String filePath;
private java.lang.Long fileSize;
private java.lang.String fileType;
private java.lang.String oldFileName;
private java.lang.String status;
private java.sql.Timestamp uploadTime;
private java.lang.String operatorId;
private java.sql.Blob fileContent;
//....get/set·½·¨
5.ÔÚDAOÀïÃæÊµÏÖ£º
/**
* ±£´æÎļþµ½Êý¾Ý¿â±íÖÐ
*/
public boolean saveFileToDatabase(UploadFileBFO uploadFileBFO) {
boolean result = true;
Session s = null;
byte[] buffer = new byte[1];
buffer[0] = 1;
OutputStream out = null;
FileInputStream fin = null;
try {
SessionFactory sf = this.getSessionFactory();
s = sf.openSession();
Transaction tx = s.beginTransaction();
// »ñÈ¡ÒѾ±£´æµ½Êý¾Ý¿âµÄ¶ÔÏó
TUploadFileBO fileBO = getById(uploadFileBFO.getFileId());
fileBO.setFileContent(Hibernate.createBlob(buffer));
s.update(fileBO); // ¸üжÔÏó
s.flush();
s.refresh(fileBO, LockMode.UPGRADE);
SerializableBlob
Ïà¹ØÎĵµ£º
¹éµµÈÕÖ¾¼Ç¼×ÅÊý¾Ý¿âµÄ²Ù×÷¼Ç¼£¬ÊÇ×öÊý¾Ý»Ö¸´µÄÒÀ¾Ý£¬Èç¹ûÊý¾Ý¿â¿ªÆôÁ˹鵵ģʽ£¬ÄÇô¾Í»á²úÉú´óÁ¿µÄ¹éµµÈÕÖ¾£¬µ±È»Èç¹ûÓÐRMAN±¸·ÝµÄ»°£¬¿ÉÒÔÔÚ±¸·ÝÖ®ºóɾ³ýÒѾ±¸·Ý¹ýµÄÈÕÖ¾£¬Èç¹ûÊÇûÓвÉÓÃrman±¸·ÝµÄ»°£¬¾ÍÐèÒª×Ô¼ºÀ´É¾³ýÕâд¹éµµÈÕÖ¾¡£ ÏÂÃæµÄ¼¸¸ö½Å±¾¾Í¼õÇáÁËDBAµÄ¹¤×÷Á¿¡£
Linux ƽ̨:
0 2 * * * ......
1¡¢ÊýÖµÐͳ£Óú¯Êý
¡¡
¡¡º¯Êý¡¡¡¡·µ»ØÖµ¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡ÑùÀý¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡ÏÔʾ
ceil(n) ´óÓÚ»òµÈÓÚÊýÖµnµÄ×îСÕûÊý¡¡¡¡select ceil(10.6) from dual; 11
floor(n) СÓÚµÈÓÚÊýÖµnµÄ×î´óÕûÊý¡¡ select ceil(10.6) from dual; 10
mod(m,n) m³ýÒÔnµÄÓàÊý,Èôn=0,Ôò·µ»Øm select mod(7,5) from dual; 2
p ......
http://blog.csdn.net/lzysystem/archive/2009/03/05/3960853.aspx
http://www.linuxidc.com/Linux/2009-06/20390.htm
http://www.linuxdiyf.com/viewarticle.php?id=163893
http://blog.sina.com.cn/s/blog_4ed66efa0100gfjx.html### ......
ORACLE SQLÐÔÄÜÓÅ»¯
ÎÒÒª½²µÄÌâÄ¿ÊÇOracle SQLÐÔÄÜÓÅ»¯£¬Ö»ÊÇOracleÐÔÄÜÓÅ»¯ÖеÄÒ»Ïî¡£OracleµÄÐÔÄÜÓÅ»¯°üº¬ºÜ¶à·½Ã棬±ÈÈçµ÷ÕûÎïÀí´æÈ¡£¬µ÷ÕûÂß¼´æÈ¡£¬µ÷ÕûÄÚ´æÊ¹Ó㬼õÉÙÍøÂçÁ÷Á¿µÈ¡£ÕâÀïÑ¡ÔñSQLÐÔÄÜÓÅ»¯ÊÇÒòΪÕⲿ·ÖÄÚÈÝÎÒÃDzâÊÔÈËÔ±×îÈÝÒ×½Ó´¥µ½£¬ÁíÍ⿪·¢ÈËԱдSQL½Å±¾Ê±ÓÐʱºÜËæÒ⣬²»Öª²»¾õ¾Í»áÔì³É³ÌÐòÐÔÄÜÉϵÄÏ ......
°²×°oracleʱ£¬ÓÉÓÚ·´¸´°²×°Ð¶ÔØ£¬Óöµ½·þÎñûÓÐÐ¶ÔØ²»ÄܼÌÐø°²×°µÄÎÊÌ⣬´ÓÍøÉÏÕÒµ½ÁË×ÊÁÏ£¬Å¶ªÊ§ÔÚ´Ë×ªÔØÒ»Ï£¬ÄÚÈÝÈçÏÂ:
Èç¹ûÄãÒ²ºÍÎÒÒ»Ñù£¬Óù¤¾ß´´½¨ÁËÒ»¸ö·þÎñ£¬Ïëɾ³ýʱȴ·¢ÏÖɾ³ý²»µô¡£»òÕß°²×°ÁËDameWare Mini Remote ÒԺ󣨰üÀ¨×Ô¼º°²×°»òÕß»úÆ÷±»ºÚ£©ÔÚ·þÎñÀïÓÐÒ»¸ö“DameWare Mini Remote Control” ......