后台代码
public class DetailAjaxAction extends FrameAjaxCrassAction {
@Override
protected String doExecute(DataManager dm, PrintWriter out, HttpServletRequest request, SecurityForm form)
throws Exception {
String sid = request.getParameter("sid");
String sql="select * from v_user_tables where nm_sid='"+sid+"'";
DataObject dbo_result=dm.findByPrimaryKey(sql,null);
String tableName=dbo_result.getString("TABLE_NAME");
String sql1="select column_name from user_tab_columns where table_name='"+tableName+"'";
String sql2="select * from "+tableName;
Collection colResult = dm.find(sql1, null);
Collection colResult2 = dm.find(sql2, null);
JSONArray jsa = new JSONArray();
JSONArray jsa2 = new JSONArray();
JSONObject jo2 = new JSONObject();
try {
jsa = JSONUtil.converToJsa(colResult);
jsa2 = JSONUtil.converToJsa(colResult2);
jo2.element("head",jsa);
jo2.element("data",jsa2);
} catch (Exception e) {
}
out.write(jo2.toString());
return null;
}
}
前台
<body style="overflow: auto; width: 100%;" >
<div>
<html:form action="<%=url %>" styleId="dbaForm">
<table id="xccs" class="tableContentStyle" width="98%" border=1
cellpadding="5" cellspacing="0" align=center>
<thead>
<tr id="table"></tr>
<tbody id="table2"></tbody>
</table>
</html:form>
</div>
<script type="text/javascript">
$(function() {
$.post("dba/table/detailAjax.do?sid=<%=sid%>",function(result){
var html='';
var result=$.parseJSON(result);
console.info(result);
var head=result.head;
var data=result.data;
$.each(head, function(i,obj) {
html+='<th align="center" nowrap>'+obj.COLUMN_NAME+'</th>';
});
$("#table").html(html);
html='';
$.each(data, function(j,dataobj) {
html+='<tr>';
$.each(head, function(i,obj) {
var col_nm=obj.COLUMN_NAME;
html+='<td align="center" nowrap >'+dataobj[col_nm]+'</td>';
});
html+='</tr>'
});
html+=''
$("#table2").html(html);
});
});
</script>
</body>
</html>