EOS运算构件开发之二：接数据库的连接方法

import com.primeton.tp.core.bizservice.EOSParameter;
import com.primeton.tp.core.api.PersistenceBroker;
import java.sql.Statement;
import java.sql.ResultSet;
import java.sql.Connection;

……………………………………
EOSParameter param = new EOSParameter();
param.setAppID(EOSAppConfiguration.getDefaultAppID());
param.setUnitName("EOSStudy");
param.setUnitId("0");
PersistenceBroker dbroker = null;
Statement stmt = null;
ResultSet rs = null;
StringBuffer buff = new StringBuffer("input 的测试：");
try
 { 
  Connection conn = param.getDBBroker().getConnection(); 
  String sql = "select * from CUST where CUSTID='"+property+"'";       
  stmt = conn.createStatement(); rs = stmt.executeQuery(sql); 
  if (rs.next())  
  {  
   String CUSTNAME = rs.getString(2);  
   buff.append("<input  type=/"text/" value=/"");  
   buff.append(CUSTNAME);  
   buff.append("/">"); 
  }
 }
 catch (Exception e)
 { 
  e.printStackTrace();    
  throw new JspException(e.toString());
 }
 finally
 { 
  try  
  {  
   if (rs == null)     
    rs.close();  
   if (stmt == null)    
    stmt.close();  
   param.closeDB(); 
  }     
  catch (Exception e1) 
  {  // TODO 自动生成 catch 块  e1.printStackTrace(); 
  }
 }