Ö÷Á÷Êý¾Ý¿âMYSQL/MSSQL/ORACLE²âÊÔÊý¾Ý¿â½Å±¾´úÂë
/******************************************************************************/
/*
Ö÷Á÷Êý¾Ý¿âMYSQL/MSSQL/ORACLE²âÊÔÊý¾Ý¿â½Å±¾´úÂë
½Å±¾ÈÎÎñ:½¨Á¢4¸ö±í,Ìí¼ÓÖ÷¼ü,Íâ¼ü£¬²åÈëÊý¾Ý,½¨Á¢ÊÓͼ
ÔËÐл·¾³1:microsoft sqlserver 2000 ²éѯ·ÖÎöÆ÷
ÔËÐл·¾³2:mysql5.0 phpMyAdminÍøÒ³½çÃæ
ÔËÐл·¾³3:oracle 9i SQL*PLUSÃüÁîÐнçÃæ
author£ºchinayaosir
blog: http://blog.csdn.net/chinayaosir/
QQ: 44633197
ÉùÃ÷£ºÑϽûÆäËüÍøÕ¾²»¾¹ý×÷ÕßchinayaosirͬÒâÈÎÒâתÔØ
*/
/******************************************************************************/
/*script test ok with microsoft sqlserver 2000 ²éѯ·ÖÎöÆ÷ */
/******************************************************************************/
/*DB:MSSQL2000 SCRIPT*/
/*0.drop table list*/
drop table Employee;
drop table Department;
drop table Post;
drop table Account;
/*********************************************************/
/*DB:MSSQL2000 SCRIPT*/
/*1.create all table*/
create table Account(
oid int not null,
username varchar(30) not null,
password varchar(10) null,
invalid varchar(1) null
);
create table bab.Post(
/*oid int identity(1,1) not null primary key,*/
oid int not null,
postName varchar(30) not null
);
create table Department(
oid int not null,
deptName varchar(30) not null,
parentid int null,
manager varchar(30) null,
email varchar(30) null
);
create table Employee(
oid
Ïà¹ØÎĵµ£º
Windows 7ÕæÊÇÈÃÈËÓÖ°®ÓÖºÞ°¡£¡±¾È˵çÄÔ֮ǰÒÑ°²×° SQL Server 2005£¬°²×°¹ý³Ì¶¼Ã»Ê²Ã´ÎÊÌ⣬ºÜ¿ì¸ã¶¨£¬¿ÉÊÇ×°Ò»¸öOracle 10gÈ´»¨ÁËÎÒÒ»¸öÍíÉϵÄʱ¼ä£¡²»¹ý×ÜËã°²×°³É¹¦ÁË£¡ËäÈ»»¹Ã»ÓÐÕýʽ¿ªÊ¼Ê¹Ó㬵«ÊÇÐË·ÜÖ®ÓàÆȲ»¼°´ýÒªºÍ´ó¼Ò·ÖÏíһϾÑ飡
Ê×ÏÈÒªÏÂÔØÖ§³ÖVista°æ±¾µÄOracle 10g£¨ÒÔÏÂÁ´½ÓµØÖ·ÔÚä¯ÀÀÆ÷Öдò¿ªÃ»Ó㬸´ ......
ÔÚoracleÖе±ÎÒÃÇн¨Á˶à¸öÊý¾Ý¿âºó£¬ÔٴεǼʱ£¬ÏµÍ³Ä¬ÈϵÄÊÇ×îºó´´½¨µÄÄǸöÊý¾Ý¿â¡£
ÈçºÎÉèÖÃÎÒÃÇ×Ô¼ºÏëÒªµÄĬÈÏÊý¾Ý¿âÄØ£¿
·½·¨ºÜ¼òµ¥£¬ÎÒÃÇÖ»ÐèÔÚÔËÐд°¿ÚÀïÊäÈëregedit£¬¼´¿É½øÈë×¢²á±í±à¼Æ÷£¬ÔÚHKEY_LOCAL_MACHI ......
ÔÚʵ¼ÊµÄ¹¤×÷»·¾³ÖУ¬Ðí¶àÈËΪÁËÊÊÓ¦¿Í»§µÄ»·¾³£¬×ÜÊÇÐèҪƵ·±¸ü¸ÄIPµØÖ·£¬µ«ÊÇÔÚIPµØÖ·±ä»»ºó£¬Oracle 10g¾Í»á³öÏÖÆô¶¯²»Á˵ÄÏÖÏó¡£ÍøÉÏÏà¹ØÎÊÌâµÄ¼¼ÊõÎÄÕ´ó¶àÊýÊÇÕë¶ÔOracle 9i£¬»òÕßÒÔÇ°µÄOracle 8iµÄ°æ±¾£¬¶ÔÓëOracle 10gµÄ°æ±¾£¬´ó¶àÖ»ÊǽéÉÜÁË´ó¸Å£¬²¢Ã»Óиø³ö¾ßÌåµÄ²½Öè!±¾ÎÄÖУ¬ÎÒÃǽ«Õë¶ÔÕâÒ»ÎÊÌâ¸ø³ö¾ßÌåµÄ½â¾ö² ......
Linux + JDK + Tomcat + MySQL + JDBC °²×°ÊÖ¼Ç
Ò»¡¢Red Hat Linux
1.·ÖÇø
| swap & ......