databaname

<%

//链接SQL数据库

e("verDriver");

Stringurl="jdbc:microsoft:sqlrver://192.168.100.9:1433;DatabaName=ast";

Stringur="oa";

Stringpassword="oadb";

Connectionconn=nection(url,ur,password);

%>

<%

//链接Oracle数据库

e("Driver").newInstance();

Stringurl="jdbc:oracle:thin:@localhost:1521:oradb";

//orcl为你的数据库的SID

Stringur="system";

Stringpassword="manager";

Connectionconn=nection(url,ur,password);

%>

<%

//链接MySQL数据库

e("").newInstance();

Stringurl="jdbc:

mysql://localhost/softforum?ur=soft&password=soft1234&uUnicode=true&characterEncoding=885

9_1"

//testDB为你的数据库名

Connectionconn=nection(url);

%>

<%

//链接Access数据库

StringsourceURL=

"jdbc:odbc:driver={MicrosoftAccessDriver

(*.mdb)};DBQ=F:";//DataBa是Access

MDB文件的主文件名

e("bcDriver");

Connectionconn=nection(sourceURL);

%>

<%

//所有数据库连接采用ODBC的写法：[配置数据源]

e("bcDriver").newInstance();

Stringurl="jdbc:odbc:xuewei";

Stringur="";

Stringpassword="";

Connctionconn=nection(url,ur,password);

%>

reloadable="true">

factory

ataSourceFactory

driverClassName

verDriver

url

jdbc:microsoft:sqlrver://127.0.0.1:1433;DatabaName=pubs

urname

sa

password

789654

maxActive

20

maxIdle

20

maxWait

-1

reloadable="true">

factory

ataSourceFactory

driverClassName

Driver

url

jdbc:oracle:thin:@10.143.47.7:1521:ZYKJ

urname

test

password

test

maxActive

20

maxIdle

20

maxWait

-1

用法：

publicclassConn{

publicstaticConnectiongetConn(){

Connectionconn=null;

try{

Contextcontext=newInitialContext();

DataSourceds=(DataSource)("java:comp/env/jdbc/mssql");

conn=nection();

n("conn:"+conn);

}catch(NamingExceptione){

//TODO自动生成catch块

tackTrace();

}catch(SQLExceptione){

//TODO自动生成catch块

tackTrace();

}

returnconn;

}

}