log4j ¼Ç¼ÈÕÖ¾·ÅÔÚoracleÖÐ
Ò»¸ödbÀà ÀàËÆÓÚjdbcµÄÇý¶¯ºÍÁ´½ÓÅäÖÃ
package com.assi;
import org.apache.log4j.jdbc.JDBCAppender;
public class DB extends JDBCAppender {
public DB(){
this.setDriver("oracle.jdbc.driver.OracleDriver");
this.setURL("jdbc:oracle:thin:@172.18.220.10:1521:orcl");
this.setUser("log");
this.setPassword("log");
}
}
¾ßÌåдÈÕÖ¾µÄÀà //ûÓÐ×¢ÊÍ ´úÂë±È½Ï¼òµ¥
package com.assi;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.text.DateFormat;
import java.text.SimpleDateFormat;
import java.util.Date;
import org.apache.log4j.Level;
import org.apache.log4j.Logger;
public class CataLogs extends DB {
private DateFormat df = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss:SSS");
private Logger logger;
public CataLogs(){
logger=Logger.getLogger(CataLogs.class.getName());
}
//×Ô¶¯Ö´ÐеÄ
protected void execute(String sql){
Connection con=null;
PreparedStatement stmt=null;
try{
con=getConnection();
stmt=con.prepareStatement(this.getSql());
stmt.execute();
}
catch(Exception e){
e.printStackTrace();
&
Ïà¹ØÎĵµ£º
oracle±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
oracle10gÐÂÌØÐÔ£ºÉÁ»Ø»Ö¸´Çø(Flash recovery area)
Oracle9i¿ªÊ¼ÌṩÉÁ»Ø²éѯ£¬ÒÔ±ãÄÜÔÚÐèÒªµÄʱºò²éµ½¹ýȥij¸öʱ¿ÌµÄÒ»ÖÂÐÔÊý¾Ý£¬ÕâÊÇͨ¹ýUndoʵÏֵġ£Õâ¸ö¹¦ÄÜÓкܴóµÄÏÞÖÆ£¬¾ÍÊÇÏà¹ØÊÂÎñµÄundo²»Äܱ»¸²¸Ç£¬·ñÔò¾ÍÎÞÁ¦»ØÌìÁË¡£oracle10g´ó´óµÄÔöÇ¿ÁËÉÁ»Ø²éѯµÄ¹¦ÄÜ£¬²¢ÇÒÌṩÁ˽«Õû¸öÊý¾Ý¿â»ØÍ˵½¹ýȥij¸öʱ¿ÌµÄÄÜÁ¦£¬ ......
»ù±¾¸ÅÄî
ORACLEÊý¾Ý¿â±»»®·Ö³É³Æ×÷Ϊ±í¿Õ¼äµÄÂß¼ÇøÓò——ÐγÉORACLEÊý¾Ý¿âµÄÂß¼½á¹¹¡£Ò»
¸öORACLEÊý¾Ý¿âÄܹ»ÓÐÒ»¸ö»ò¶à¸ö±í¿Õ¼ä,¶øÒ»¸ö±í¿Õ¼äÔò¶ÔÓ¦×ÅÒ»¸ö»ò¶à¸öÎïÀíµÄÊý¾Ý¿â
Îļþ¡£±í¿Õ¼äÊÇORACLEÊý¾Ý¿â»Ö¸´µÄ×îСµ¥Î»,ÈÝÄÉ×ÅÐí¶àÊý¾Ý¿âʵÌå,Èç±í¡¢ÊÓͼ¡¢Ë÷Òý
¡¢¾Û´Ø¡¢»ØÍ˶κÍÁÙʱ¶ÎµÈ¡£
ÿ¸öORACLEÊý¾ ......
Êý¾Ý¿âÁ¬½ÓÊÇÒ»ÖֹؼüµÄÓÐÏ޵ݺ¹óµÄ×ÊÔ´£¬ÕâÒ»µãÔÚ¶àÓû§µÄÍøÒ³Ó¦ÓóÌÐòÖÐÌåÏÖµÃÓÈΪͻ³ö¡£¶ÔÊý¾Ý¿âÁ¬½ÓµÄ¹ÜÀíÄÜÏÔÖøÓ°Ïìµ½Õû¸öÓ¦ÓóÌÐòµÄÉìËõÐԺͽ¡×³ÐÔ£¬Ó°Ïìµ½³ÌÐòµÄÐÔÄÜÖ¸±ê¡£Êý¾Ý¿âÁ¬½Ó³ØÕýÊÇÕë¶ÔÕâ¸öÎÊÌâÌá³öÀ´µÄ¡£
Êý¾Ý¿âÁ¬½Ó³Ø¸ºÔð·ÖÅä¡¢¹ÜÀíºÍÊÍ·ÅÊý¾Ý¿âÁ¬½Ó£¬ËüÔÊÐíÓ¦ÓóÌÐòÖØ¸´Ê¹ÓÃÒ»¸öÏÖÓеÄÊý¾Ý¿ ......