作者：蔡容森 Email:accp_sen@163.com QQ:330366418


使用前，


1.把DataBase文件夾Copy到C:\ ;

2.安裝tomcat5.0或5.5
把Access、MySQL、Oracle9、SQLServer這4個文件夾Copy到C:\Program Files\Apache Software Foundation\Tomcat 5.0\webapps
(注意：具體路徑自己看著辦，OK!)

3.附加SQL Server數(shù)據(jù)庫(c:\DataBase\books_Data.MDF);

4.創(chuàng)建SQL Server數(shù)據(jù)源(名稱為：books);

5.建MySQL數(shù)據(jù)庫

create database books;

use books;
create table book(bookId varchar(50),bookName varchar(50),publisher varchar(100),price float,constraint pk_book primary key(bookId));

insert into book values('1001','JSP應用開發(fā)詳解','電子工業(yè)出版社',55.00);
insert into book values('1002','EJB應用開發(fā)詳解','清華大學出版社',60.0);
insert into book values('1003','精通Struts','電子工業(yè)出版社',45.50);
insert into book values('1004','精通JBuilder X','清華大學出版社',45.50);

6.用scott/tiger登錄Oracle(sqlplus)
create table book(bookId varchar2(50),bookName varchar2(50),publisher varchar2(50),price number(5,2),constraint pk_book primary key(bookId));

insert into book values('1001','JSP應用開發(fā)詳解','電子工業(yè)出版社',55.00);
insert into book values('1002','EJB應用開發(fā)詳解','清華大學出版社',60.0);
insert into book values('1003','精通Struts','電子工業(yè)出版社',45.50);
insert into book values('1004','精通JBuilder X','清華大學出版社',45.50);


****************************************************************************************************************************
本程序采用多種方式連接各種常用的數(shù)據(jù)庫：

1.連接ACCESS
  http://127.0.0.1:8080/Access/access.jsp

2.連接SQL Server2000
  http://127.0.0.1:8080/SQLServer/mssql.jsp.jsp    //JDBC-ODBC
  
  http://127.0.0.1:8080/SQLServer/testmssql.jsp	   //JDBC驅動

3.連接Oracle 9i
  http://127.0.0.1:8080/Oracle/oracle9_thin.jsp    //thin模式

  http://127.0.0.1:8080/Oracle/oracle9_oci.jsp	   //OCI模式

4.連接MySQL
  http://127.0.0.1:8080/MySQL/mysql.jsp


作者：蔡容森 Email:accp_sen@163.com QQ:330366418