|
自定义动作是这样:
package hxzc;
import java.sql.Connection;
import java.sql.SQLException;
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;
public class Jvyggh {
public static JSONObject dlyz(JSONObject params, ActionContext context) throws SQLException, NamingException {
String tableName = params.getString("imsi"); //获得调用动作时传入的参数
Table table = null;
Connection conn = context.getConnection("khgl"); //获得数据库连接
try {
String sql = "SELECT zhjb FROM yggh where imsi='" + tableName +"' and aqxy is not null";
table = DataUtils.queryData(conn, sql, null, null, null, null);//从数据库查询数据
String sqlTotal = "SELECT COUNT(*) FROM yggh where imsi='" + tableName +"'";
Object total = DataUtils.getValueBySQL(conn, sqlTotal, null);
table.setTotal(Integer.parseInt(total.toString()));
return Transform.tableToJson(table); //将table 序列化后返回前端
} finally {
conn.close(); //关闭数据库连接
}
}
}
那么前台这样为什么获取不到数据?
Model.prototype.modelLoad = function(event){
var zhjb= this.comp("baasData1").get
var rows=this.comp("baasData1").find(['imsi','153326168531']);
justep.Baas.sendRequest(
{
"url":"/hxzc/Jvyggh",
"action":"dlyzaction",
"async":false,
"params":{"imsi":"153326168531"},
"success":function(date)
{
alert(data,table);
}
})
if(rows.leght==0)
alert("不存在");
else
alert("存在");
};
return Model;
}); |
|