java调用SQL2000存储过程的问题！（急）

Question

留给你点正确代码，自己研究去吧
package com.tradelook.packages.storedprod;import java.sql.*;
import java.util.*;
import com.tradelook.jdbc.JDBCConnectionHandler;
import com.tradelook.util.NumericUtil;
import com.tradelook.util.StringUtil;public class n_Package_Display_Check {
private JDBCConnectionHandler JDBCHandler;
private Connection con;
private String CompanyId;
private com.tradelook.packages.bean.PackagesEdit data;

public n_Package_Display_Check(String CompanyId, com.tradelook.packages.bean.PackagesEdit data) {
this.CompanyId = CompanyId;
this.data = data;
JDBCHandler = new JDBCConnectionHandler();
}

public void execute() throws Exception {
openConnection();

CallableStatement Callable1 = con.prepareCall("{?= call n_Package_Display_check(?,?,?)}");
//Callable1.setQueryTimeout(0);
Callable1.registerOutParameter(1,Types.LONGVARCHAR);
Callable1.setString(2,CompanyId);
Callable1.setString(3,data.getnPackages_packages());
Callable1.setString(4,data.getnPackages_Pgroup()); ResultSet rs = Callable1.executeQuery();
if (rs.next()) {
data.setnPackages_packages(StringUtil.getNonNullString(rs.getString("Description")));
data.setnPackages_re(StringUtil.getNonNullString(rs.getString("Re")));
data.setnPackages_cpackages(StringUtil.getNonNullString(rs.getString("CDescription")));
data.setnPackages_Thickness(StringUtil.getNonNullString(rs.getString("Thickness")));
data.setnPackages_Unit(StringUtil.getNonNullString(rs.getString("Unit")));
data.setnPackages_Pgroup(StringUtil.getNonNullString(rs.getString("Pgroup")));
data.setnPackages_FileName(StringUtil.getNonNullString(rs.getString("FileName")));
/*
data.setnPackages_CompanyId(rs.getString("CompanyId") == null ? "" : rs.getString("CompanyId").trim());
data.setnPackages_packages(rs.getString("Description") == null ? "" : rs.getString("Description").trim());
data.setnPackages_cpackages(rs.getString("CDescription") == null ? "" : rs.getString("CDescription").trim());
data.setnPackages_re(rs.getString("Re") == null ? "" : rs.getString("Re").trim());
data.setnPackages_Thickness(NumericUtil.trimTrailingZero(rs.getString("Thickness") == null ? "" : rs.getString("Thickness")).trim());
data.setnPackages_Unit(rs.getString("Unit") == null ? "" : rs.getString("Unit").trim());
*/ } else {
throw new Exception("No such package was found in the database.");
}
closeConnection();
}

private void openConnection() throws Exception {
con = JDBCHandler.getConnection();
}

private void closeConnection() throws Exception {
con.close();
}
}