Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

MsSQL,MySQL,Oracle,Êý¾Ý¿âÁ¬½Ó×Ö¶Î

Ms sql 2000
drivername=com.microsoft.jdbc.sqlserver.SQLServerDriver
url=jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=books
username=sa
password=sa
MySQL
drivername=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost/books
username=root
password=root
Oracle
drivername=oracle.jdbc.driver.OracleDriver
url=jdbc:oracle:thin:@localhost:1521:orcl
Username=root
Password=root


Ïà¹ØÎĵµ£º

ORACLE¸´Ï°(¶þ)

Èý¡¢     PL/SQL³ÌÐòµ¥Ôª
1¡¢ÎÞÂÛÊǵ¥¶ÀµÄ¹ý³Ì/º¯Êý£¬»¹ÊǰüÖеĹý³Ì/º¯Êý£¬¶¼Í³³ÆÎª×Ó³ÌÐò¡£
2¡¢¹ý³Ì
 
1)       Òì³£´¦Àí²¿·ÖÊÇ¿ÉÑ¡µÄ¡£
2)       ¹ý³ÌÃûÓ¦¸ÃÓö¯´Ê£¬ÒòΪ¹ý³Ìͨ³£ÊÇÖ´ÐÐijÖÖ¶¯×÷¡£¹ý³Ì²¢²»Ò»¶¨¾ßÓвÎÊý¡£µ±´ ......

»ùÓÚ OCI ʵÏÖµÄ oracle ×î¸ßЧdump³ÌÐò

»ùÓÚOCI ʵÏֵĠ×î¸ßЧdump³ÌÐò£¬ ±ÈOTL ÒÔ¼°ÆäËûµÄ½Ó¿Ú¶¼¿ìºÜ¶à
ÄÜÖ´ÐÐÈκÎsql , ×Ô¶¯Ê¶±ð×Ö¶ÎÃûºÍ×Ö¶ÎÀàÐÍ£¬½øÐÐÊä³öÊä³ö
/*
* oracle_dump.cpp
*
* Created on: 2010-2-1
* Author: clm971910@gmail.com
*
* ѹËõ
* 4216351 dump done
* ÍêÕû 106 Ãë
* д·Ö¸ô·û 8Ãë
* ѹËõд´Å ......

ÈçºÎÊÖ¹¤´´½¨OracleÊý¾Ý¿â

ÈçºÎÊÖ¹¤´´½¨OracleÊý¾Ý¿â
http://www.cnhacker.com/Security/System/200808/t20080818_6325.html
½ñÌ죬ÎÒÔÚ²âÊÔ»úÆ÷ÉÏÀ´Á˸öÎó²Ù×÷rm * backup/*,°ÑÕýÔÚÔËÐеÄÊý¾Ý¿âÖеÄÊý¾ÝÎļþÈ«²¿É¾³ýÁË£¬ÕæÊÇÓôÃÆ!»¹ºÃÕâ¸öÊǸøÎÒÃÇÐÂÈËÃDzâÊÔÍæµÄ£¬Òª²»È»¾ÍËÀ¶¨ÁË!ÔÚ´ËÒ²×öÒ»¸öÌáÐÑ£¬ÉíΪDBA£¬ÒªÓÀÔ¶¼ÇסʲôÉ÷ÓûòÕß½ûֹʹÓÃrmÃüÁ ......

Oracle¹éµµÃüÁî£¨×ªÔØ£©

Ê×ÏȲ鿴Êý¾Ý¿âÏÖÓÐģʽ¿ÉʹÓÃÒÔÏÂÓï¾ä
select name,log_mode from v$database;
Ò²¿ÉÒÔÓÃÏÂÃæµÄÓï¾ä
archive log list£»(¸Ã·½·¨ÐèÒªas sysdba)
¶ÔÓڷǹ鵵ģʽµÄÊý¾Ý¿â¸ÃΪ¹éµµÄ£Ê½£¨Ö÷ÒªÒÔOracle 10gΪ²Î¿¼£©Ê¹ÓÃÒÔϲ½Ö裺
1. SQL> alter system set log_archive_dest_1='location=/oracle/oracle10g/log/archive ......

ʹÓÃJavaµ÷ÓÃOracleÊý¾Ý¿âµÄ´æ´¢¹ý³ÌʵÀý

Ò»£ºÎÞ·µ»ØÖµµÄ´æ´¢¹ý³Ì
1¡¢½¨Á¢´æ´¢¹ý³Ì
CREATE OR REPLACE PROCEDURE TESTA(PARA1 IN VARCHAR2,PARA2 IN VARCHAR2) AS
BEGIN
INSERT INTO T_TEST (I_ID,I_NAME) VALUES (PARA1, PARA2);
END TESTA;
2¡¢ÏàÓ¦µÄJAVA³ÌÐò
import java.sql.*;
import java.io.OutputStream;
import java.io.Writer;
import java.sq ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ