帮帮我！十万火急！！！

[0620]

我用JSP做管理系统。采用的软件是：weblogic server 6.1,JDBC驱动，SQL数据库。
和数据库的连接与交互编译成ction.class文件，代码如下：

package ction;

import java.lang.*;
import java.util.*;
import java.sql.*;
import java.text.*;

public class date
{
String sDBDriver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
String sConnStr = "jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=qiye";
String sUsername = "sa";
String sPassword = "qiye";
Statement stmt = null;
CallableStatement sp = null;
Connection conn = null;
ResultSet rs = null;
int iReturn = 0;

public date() throws Exception
{
try
{
Class.forName(sDBDriver);
}
catch(ClassNotFoundException classnotfoundexception)
{
System.err.println("装载JDBC驱动程序失败：" + classnotfoundexception.getMessage());
}
}

public int ExeInsert(String s)
{
try
{
conn = DriverManager.getConnection(sConnStr, sUsername, sPassword);
stmt = conn.createStatement();
iReturn = stmt.executeUpdate(s);
conn.close();
}
catch(SQLException sqlexception)
{
System.out.println("添加数据失败：" + sqlexception.getMessage());
}
return iReturn;
}

public int ExeEdit(String s)
{
try
{
conn = DriverManager.getConnection(sConnStr, sUsername, sPassword);
stmt = conn.createStatement();
iReturn = stmt.executeUpdate(s);
conn.close();
}
catch(SQLException sqlexception)
{
System.out.println("修改数据失败：" + sqlexception.getMessage());
}
return iReturn;
}

public int ExeDelete(String s)
{
try
{
conn = DriverManager.getConnection(sConnStr, sUsername, sPassword);
stmt = conn.createStatement();
iReturn = stmt.executeUpdate(s);
conn.close();
}
catch(SQLException sqlexception)
{
System.out.println("删除数据失败：" + sqlexception.getMessage());
}
return iReturn;
}

public ResultSet ExeQuery(String s)
{
try
{
rs = null;
conn = DriverManager.getConnection(sConnStr, sUsername, sPassword);
stmt =

conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
rs = stmt.executeQuery(s);
}
catch(SQLException sqlexception)
{
System.out.println("查询数据失败：" + sqlexception.getMessage());
}
return rs;
}

public CallableStatement ExeSP(String s)
throws Exception
{
try
{
sp = null;
conn = DriverManager.getConnection(sConnStr, sUsername, sPassword);
stmt =

conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
sp = conn.prepareCall(s);
}
catch(SQLException sqlexception)
{
System.out.println("存储过程出错：" + sqlexception.getMessage());
}
return sp;
}
}

在JSP页面中通过jsp:useBean调用,代码如下：
<jsp:useBean id="conn" scope="page" class="ction.date" />

如：

<%
sSQL ="select * from aa"
ResultSet rs = conn.ExeQuery(sSQL);
%>

问题：

1.怎样将以上的ction.class文件改为：连接池。
2.在JSP页面中怎样调用。

[httruly]

既然你选用了weblogic，就不需要改变代码了，因为它自带了连接池，只需在console配置一下了。

[chenyongcsdn]

是呀！
配置一下；
代码改为DataSource,调用方法都是一样的！

[qukmei]

装个weblogic8.1，自已配一个连接池，然后，再改一下那个.class
就OK了

[0620]

因为我是刚学的，怎样配置weblogic和修改.class文件。