IDC资讯中心
2002年1月16日
整理人：wangyl
注意
l 以下文档都是以mydomain为例
l 本系列文档都是使用相同的配置，即使用以前文档的配置，
1. 将附件中的classes12.zip拷贝到wlserver6.0\lib目录下
2. 修改config\mydomain\startweblogic.cmd文件，在set classpath=。。。一行的最后加入如下语句
;.\lib\classes12.zip
3. 修改mydomain\config.xml文件,在最后加入如下语句
<jdbcconnectionpool
capacityincrement="1"
drivername="oracle.jdbc.driver.oracledriver"
initialcapacity="2"
maxcapacity="4"
name="oraclethinpool"
properties="user=zjcenter;password=zjcenter;dll=ocijdbc8;protocol=thin"
targets="myserver"
url="jdbc:oracle:thin:@172.16.91.36:1521:orcl"//此处根据你的服务器地址做调整//
/>
<jdbctxdatasource
jndiname="webapp.oraclethintxds"
name="otxds"
poolname="oraclethinpool"
targets="myserver"
/>
4. 将附件中的sss.class拷贝到mydomain\applications\webapp\web-inf\classes目录下
5. 修改mydomain\applications\webapp\web-inf\web.xml文件,在
<web-app>
。。。。。。
。。。。。。
</web-app>
之间加入如下语句
<servlet>
<servlet-name>datasourcetest</servlet-name>
<servlet-class>sss</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>datasourcetest</servlet-name>
<url-pattern>/dst/*</url-pattern>
</servlet-mapping>
6. 启动weblogic default server
7. 访问我们的例子http://127.0.0.1:7001/webapp/dst
8. 测试成功!
9. 例子sss.java
// source file name: sss.java
import java.io.ioexception;
import java.io.printwriter;
import java.sql.*;
import javax.naming.context;
import javax.naming.initialcontext;
import javax.servlet.servletresponse;
import javax.servlet.http.*;
import javax.sql.datasource;
public class sss extends httpservlet
{
public sss()
{
}
public void service(httpservletrequest httpservletrequest, httpservletresponse httpservletresponse)
throws ioexception
{
httpservletresponse.setcontenttype("text/html");
printwriter printwriter = httpservletresponse.getwriter();
printwriter.println("<html><head><title>hello datasource!</title></head><body>");
printwriter.println("<p><img src=images/bea_button_final_web.gif align=right>");
printwriter.println("<h1>simplesqlservlet.java</h1> attempting connection….");
connection connection = null;
statement statement = null;
try
{
initialcontext initialcontext = new initialcontext();
datasource datasource = (datasource)initialcontext.lookup("bbb.oraclethintxds");
connection = datasource.getconnection();
printwriter.println("<p>connection successful…<p>executing sql…<p>");
statement = connection.createstatement();
try
{
statement.execute("drop table empdemo");
printwriter.println("table empdemo dropped…<p>");
}
catch(sqlexception sqlexception)
{
printwriter.println("<p>table empdemo does not need to be dropped…<p>");
}
statement.execute("create table empdemo (empid int, name varchar(30), dept int)");
printwriter.println("<p>table empdemo created…");
int i = statement.executeupdate("insert into empdemo values (0,john smith, 12)");
printwriter.println("<p>number of rows inserted = " + i);
statement.execute("select * from empdemo");
resultset resultset = statement.getresultset();
printwriter.println("<hr>querying data …<br>");
for(; resultset.next(); printwriter.println("<br><b>id: </b> " + resultset.getstring("empid") + "<br><b>name:</b> " + resultset.getstring("name") + "<br><b>dept:</b> " + resultset.getstring("dept") + "<hr>"));
resultsetmetadata resultsetmetadata = resultset.getmetadata();
printwriter.println("querying table meta data…<p>");
printwriter.println("number of columns: " + resultsetmetadata.getcolumncount() + "<b>");
for(int j = 1; j <= resultsetmetadata.getcolumncount(); j++)
{
printwriter.println("<p>column name: " + resultsetmetadata.getcolumnname(j));
printwriter.println("<br>nullable: " + resultsetmetadata.isnullable(j));
printwriter.println("<br>precision: " + resultsetmetadata.getprecision(j));
printwriter.println("<br>scale: " + resultsetmetadata.getscale(j));
printwriter.println("<br>size: " + resultsetmetadata.getcolumndisplaysize(j));
printwriter.println("<br>column type: " + resultsetmetadata.getcolumntype(j));
printwriter.println("<br>column type name: " + resultsetmetadata.getcolumntypename(j));
printwriter.println("<br><hr>");
}
}
catch(exception exception)
{
printwriter.println("connection error:" + exception);
}
finally
{
try
{
if(connection != null)
connection.close();
printwriter.println("********************************");
printwriter.println("\n");
printwriter.println("stmt is");
printwriter.println(statement);
printwriter.println("\n");
printwriter.println("conn is");
printwriter.println(connection);
printwriter.println("********************************");
if(statement != null)
statement.close();
}
catch(sqlexception sqlexception1)
{
printwriter.println("exception during close()" + sqlexception1.getmessage());
}
}
printwriter.println("</b><h3>example finished…</h3></body></html>");
}
}
