给你一个例子 Context ctx = getInitialContext();
Object ref = ctx.lookup("com/pagic/sas/BsSets"); //get Home
bsSetsHome = (BsSetsHome) PortableRemoteObject.narrow(ref, BsSetsHome.class);
bsSets = bsSetsHome.create(); str[0]=request.getParameter("flex_value_set_id")==null?"":request.getParameter("flex_value_set_id").trim();
str[1]=request.getParameter("flex_value_set_name")==null?"":chartype.UnicodeToGB(request.getParameter("flex_value_set_name").trim());
str[2]=request.getParameter("description")==null?"":chartype.UnicodeToGB(request.getParameter("description").trim());
str[3]=request.getParameter("format_type")==null?"":request.getParameter("format_type").trim();
str[4]=request.getParameter("Maxinum_Size")==null?"":request.getParameter("Maxinum_Size").trim();
str[5]=request.getParameter("Maximun_Value")==null?"":request.getParameter("Maximun_Value").trim();
str[6]=request.getParameter("Minimun_value")==null?"":request.getParameter("Minimun_value").trim();
str[7]=request.getParameter("Default_Value")==null?"":request.getParameter("Default_Value").trim();
str[8]=request.getParameter("Default_Meaning")==null?"":chartype.UnicodeToGB(request.getParameter("Default_Meaning").trim());
str[9]=request.getParameter("Alphanumeric_Allowed_Flag")==null?"":request.getParameter("Alphanumeric_Allowed_Flag").trim();
str[10]=request.getParameter("Enabled_Flag")==null?"":request.getParameter("Enabled_Flag").trim();
str[11]=request.getParameter("Number_Precision")==null?"":request.getParameter("Number_Precision").trim(); String str_page = request.getParameter("page")==null?"1":request.getParameter("page").trim();
String str_split_page = request.getParameter("split_page")==null?"N":request.getParameter("split_page").trim(); crs=(CachedRowSet)bsSets.findSasFlexValueSets(new java.math.BigDecimal(java.lang.Long.parseLong(str[0]))); SimpleDateFormat formatter = new SimpleDateFormat("yyyy-MM-dd H:mm:ss");
java.util.Date d=new java.util.Date();
String stime=formatter.format(d); while(crs.next()){
crs.updateString("flex_value_set_name",str[1]);
crs.updateString("description",str[2]);
crs.updateString("format_type",str[3]);
if(str[4].length()>0){
crs.updateBigDecimal("Maxinum_Size",new java.math.BigDecimal(java.lang.Long.parseLong(str[4])));
}
crs.updateString("Maximun_Value",str[5]);
crs.updateString("Minimun_value",str[6]);
crs.updateString("Default_Value",str[7]);
crs.updateString("Default_Meaning",str[8]);
crs.updateString("Alphanumeric_Allowed_Flag",str[9]);
crs.updateString("Enabled_Flag",str[10]);
if(str[11].length()>0){
crs.updateBigDecimal("Number_Precision",new java.math.BigDecimal(java.lang.Long.parseLong(str[11])));
}
crs.updateDate("last_update_date",new java.sql.Date(formatter.parse(stime.toString()).getTime()));
crs.updateString("last_updated_by",str_username);
crs.updateRow();
} int operate_symbol = (int)bsSets.updateRowSet(crs);
EJB中
public RowSet ejbHomeGetValues(String str_sql, String TableName) throws PsSetsException {
DataManager db = new DataManager();
ResultSet rs = null;
CachedRowSet crs = null;
try{
if(str_sql == null){
str_sql="";
}
if(db.DBConnect()==super.OK){
rs = db.DBSelect(str_sql);
crs = new CachedRowSet();
crs.populate(rs);
crs.setTableName(TableName);
}else{
crs = null;//连接数据库失败。
}
}catch(Exception ex){
//Logger.LOG(Level.SEVERE,"Entity Bean::PsSasFlexValueSets::ejbHomeGetValues()",ex);
return null;
}finally{
try{
rs.close();
db.DBClose();
}catch(Exception e){}
}
return crs;
} public int ejbHomeUpdateSet(RowSet rs) throws PsSetsException {
int returnValue = super.ERROR;
DataManager db = new DataManager();
try{
if(db.DBConnect()==super.OK){
returnValue = db.UpdateRowSet(rs);
}
}catch(Exception ex){
try{
db.DBRollback();
}catch(Exception e){}
//Logger.LOG(Level.SEVERE,"Entity Bean::PsSasFlexValueSets::ejbHomeUpdateSet()",ex);
return super.ERROR;
}finally{
try{
db.DBClose();
}catch(Exception ex){}
}
return returnValue;
}其实它跟ResultSet 差不多,不过多了一些功能,
能够对数据库操作。
你可以去sun下载,上面有好多例子。
Object ref = ctx.lookup("com/pagic/sas/BsSets"); //get Home
bsSetsHome = (BsSetsHome) PortableRemoteObject.narrow(ref, BsSetsHome.class);
bsSets = bsSetsHome.create(); str[0]=request.getParameter("flex_value_set_id")==null?"":request.getParameter("flex_value_set_id").trim();
str[1]=request.getParameter("flex_value_set_name")==null?"":chartype.UnicodeToGB(request.getParameter("flex_value_set_name").trim());
str[2]=request.getParameter("description")==null?"":chartype.UnicodeToGB(request.getParameter("description").trim());
str[3]=request.getParameter("format_type")==null?"":request.getParameter("format_type").trim();
str[4]=request.getParameter("Maxinum_Size")==null?"":request.getParameter("Maxinum_Size").trim();
str[5]=request.getParameter("Maximun_Value")==null?"":request.getParameter("Maximun_Value").trim();
str[6]=request.getParameter("Minimun_value")==null?"":request.getParameter("Minimun_value").trim();
str[7]=request.getParameter("Default_Value")==null?"":request.getParameter("Default_Value").trim();
str[8]=request.getParameter("Default_Meaning")==null?"":chartype.UnicodeToGB(request.getParameter("Default_Meaning").trim());
str[9]=request.getParameter("Alphanumeric_Allowed_Flag")==null?"":request.getParameter("Alphanumeric_Allowed_Flag").trim();
str[10]=request.getParameter("Enabled_Flag")==null?"":request.getParameter("Enabled_Flag").trim();
str[11]=request.getParameter("Number_Precision")==null?"":request.getParameter("Number_Precision").trim(); String str_page = request.getParameter("page")==null?"1":request.getParameter("page").trim();
String str_split_page = request.getParameter("split_page")==null?"N":request.getParameter("split_page").trim(); crs=(CachedRowSet)bsSets.findSasFlexValueSets(new java.math.BigDecimal(java.lang.Long.parseLong(str[0]))); SimpleDateFormat formatter = new SimpleDateFormat("yyyy-MM-dd H:mm:ss");
java.util.Date d=new java.util.Date();
String stime=formatter.format(d); while(crs.next()){
crs.updateString("flex_value_set_name",str[1]);
crs.updateString("description",str[2]);
crs.updateString("format_type",str[3]);
if(str[4].length()>0){
crs.updateBigDecimal("Maxinum_Size",new java.math.BigDecimal(java.lang.Long.parseLong(str[4])));
}
crs.updateString("Maximun_Value",str[5]);
crs.updateString("Minimun_value",str[6]);
crs.updateString("Default_Value",str[7]);
crs.updateString("Default_Meaning",str[8]);
crs.updateString("Alphanumeric_Allowed_Flag",str[9]);
crs.updateString("Enabled_Flag",str[10]);
if(str[11].length()>0){
crs.updateBigDecimal("Number_Precision",new java.math.BigDecimal(java.lang.Long.parseLong(str[11])));
}
crs.updateDate("last_update_date",new java.sql.Date(formatter.parse(stime.toString()).getTime()));
crs.updateString("last_updated_by",str_username);
crs.updateRow();
} int operate_symbol = (int)bsSets.updateRowSet(crs);
EJB中
public RowSet ejbHomeGetValues(String str_sql, String TableName) throws PsSetsException {
DataManager db = new DataManager();
ResultSet rs = null;
CachedRowSet crs = null;
try{
if(str_sql == null){
str_sql="";
}
if(db.DBConnect()==super.OK){
rs = db.DBSelect(str_sql);
crs = new CachedRowSet();
crs.populate(rs);
crs.setTableName(TableName);
}else{
crs = null;//连接数据库失败。
}
}catch(Exception ex){
//Logger.LOG(Level.SEVERE,"Entity Bean::PsSasFlexValueSets::ejbHomeGetValues()",ex);
return null;
}finally{
try{
rs.close();
db.DBClose();
}catch(Exception e){}
}
return crs;
} public int ejbHomeUpdateSet(RowSet rs) throws PsSetsException {
int returnValue = super.ERROR;
DataManager db = new DataManager();
try{
if(db.DBConnect()==super.OK){
returnValue = db.UpdateRowSet(rs);
}
}catch(Exception ex){
try{
db.DBRollback();
}catch(Exception e){}
//Logger.LOG(Level.SEVERE,"Entity Bean::PsSasFlexValueSets::ejbHomeUpdateSet()",ex);
return super.ERROR;
}finally{
try{
db.DBClose();
}catch(Exception ex){}
}
return returnValue;
}其实它跟ResultSet 差不多,不过多了一些功能,
能够对数据库操作。
你可以去sun下载,上面有好多例子。
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货