作者:蔡容森 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数据库(c:\DataBase\books_Data.MDF);
4.创建SQL Server数据源(名称为:books);
5.建MySQL数据库
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应用开发详解','电子工业出版社',55.00);
insert into book values('1002','EJB应用开发详解','清华大学出版社',60.0);
insert into book values('1003','精通Struts','电子工业出版社',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应用开发详解','电子工业出版社',55.00);
insert into book values('1002','EJB应用开发详解','清华大学出版社',60.0);
insert into book values('1003','精通Struts','电子工业出版社',45.50);
insert into book values('1004','精通JBuilder X','清华大学出版社',45.50);
****************************************************************************************************************************
本程序采用多种方式连接各种常用的数据库:
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