|
楼主 |
发表于 2016-5-10 09:56:09
|
显示全部楼层
1、action 代码端,注意函数名称和 UI2文件对应
public static Table person(String strName){
java.sql.Connection conn;
System.out.println(strName);
try {
conn = com.justep.model.ModelUtils.getConnection("/jxc/inware/data");
java.sql.CallableStatement proc = conn.prepareCall("{ call person(?,?) }");
proc.setString(1,strName);
proc.registerOutParameter(2,oracle.jdbc.OracleTypes.CURSOR);
proc.execute();
//ResultSet rt = proc.executeQuery();
ResultSet rt = (ResultSet)proc.getObject(2);
Table table = com.justep.system.util.BizUtils.resultSet2Table( rt,"/jxc/inware/data");
System.out.println(table.size());
return table;
//com.justep.system.util.BizUtils.resultSet2Table( rt,"/jxc/inware/data");
} catch (NamingException e) {
// TODO Auto-generated catch block
e.printStackTrace();
return null;
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
return null;
}}
2、UI端
Model.prototype.button1Click = function(event){
var rd=this.comp("reportData1");//rd2这是 reportData(报表数据) 对象
rd.setStringVar("strName",this.comp('input1').val());
//rd.setStringVar("strName", "于昊");
this.comp('report1').refresh();
};
管理员可以结贴了。 |
|