|
老师您好,自定义queryAction,debugger报错,请问是哪里出现问题。我做的是两张表的关联
js如下:
Model.prototype.modelLoad = function(event){
var YongHXXData = this.comp("YongHXXData");
justep.Baas.sendRequest({
"url" : "/HeXYY/HeXYY",
"action" : "QueryUserInforAtion",
"async" : false,
"params" : {},
"success" : function(data) {
YongHXXData.loadData(data);
}
});
};
java代码如下:
package HeXYY;
import java.sql.Connection;
import java.util.ArrayList;
import java.util.List;
import javax.naming.NamingException;
import com.alibaba.fastjson.JSONObject;
import com.justep.baas.action.ActionContext;
import com.justep.baas.data.DataUtils;
import com.justep.baas.data.Table;
import com.justep.baas.data.Transform;
import com.justep.baas.data.sql.SQLException;
public class HeXYY2 {
public static JSONObject QueryUserInforAtion(JSONObject params, ActionContext context) throws SQLException, NamingException, java.sql.SQLException {
List<Object> sqlParams = new ArrayList<Object>();
Table table = null;
Connection conn = context.getConnection("HeXYY");
try {
String sql = "select TYongHXX.*,TJiCXX.tfSHuJMC from TYongHXX join TJiCXX on TYongHXX.tfSuoSYQID = TJiCXX.fID where tfSHuJLX = '园区类型'";
table = DataUtils.queryData(conn, sql, sqlParams, null, null, null);
return Transform.tableToJson(table);
} finally {
conn.close();
}
}
}
|
|