|
楼主 |
发表于 2016-1-18 23:01:38
|
显示全部楼层
是用的3.3版本。是自定义action。java代码如下:
public static JSONObject getTxnDetail(JSONObject params, ActionContext context) throws SQLException, NamingException {
HttpServletRequest request = (HttpServletRequest) context.get(ActionContext.REQUEST);
User user = (User) request.getSession().getAttribute("user");
System.out.println("--------------");
Connection conn = context.getConnection(DATASOURCE_TAKEOUT);
try {
String sql = " select * "
+ " from txfposp.tbl_n_txn t "
+" where UPDT_DATE between '20160111000000' and '999999999' "
+ " ORDER BY UPDT_DATE DESC ";
Table table = null;
table = DataUtils.queryData(conn, sql, null, null, null, 10000);
System.out.println("jsonObj===" + Transform.tableToJson(table));
return Transform.tableToJson(table);
} finally {
conn.close();
}
}
应该怎么写才能进入界面自动显示数据?是不是应为DataUtils.queryData(conn, querysql, sqlParams, columns, offset, limit);里面的columns没有传过来?应该怎么传?
谢谢了~
|
|