easyUI + servlet 展示datagrid数据列表
1：在jsp页面添加所用easyUI的js和css
2.前台代码示例：
<table id="dgObj" style="width: 100%;height:90%;" align="left" url="showAdminWwqyxycServlet" >
</table>
<script type="text/javascript">
$(function(){
$("#dgObj").datagrid({
//loader:myLoader,
pagination:true,
rownumbers:true,
singleSelect:false,
pageSize:50,
remoteSort:true,
fitColumns:false,
selectOnCheck:false,
checkOnSelect:false,
striped:true,
pageList:[50],
columns:[[
{field:'cd',checkbox:true},
{field:'OPINION_ID',title:'主键',width:100,align:'center',hidden:true},
/* {field:'THUMB_UP_NUM',title:'点赞数',width:100,halign:'center',align:'left'}, */
/* {field:'OPINION_TYPE',title:'意见归属',width:250,halign:'center',align:'left',formatter:approveResult}, */
{field:'TITLE',title:'标题',width:550,halign:'center',align:'left',formatter:go},
{field:'SUGGEST_TIME',title:'提问时间',width:250,halign:'center',align:'left'},
{field:'IS_AUDIT',title:'是否审核',width:100,halign:'center',align:'left',formatter:Type},
{field:'IS_ANSWER',title:'是否回复',width:100,halign:'center',align:'left',formatter:isType},
]],
toolbar: [{
text: '我要提建议',
iconCls: 'icon-add',
handler: function() {
var type="2";//我为企业献一策
url='addWwqyxyc.jsp?type='+type+'&isadmin=1';
var height = window.screen.availHeight;
var width = window.screen.availWidth;
window.open (url,'newwindow','height=1000,width=800,top=100,left=400,toolbar=no,menubar=no,scrollbars=no, resizable=no,location=no, status=no');
window.close(url);
}
}]
});
});
</script>
3.配置好对应的servlet
4.后台代码示例：（servlet部分）
package com.advice.servlet; import java.io.IOException; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import net.sf.json.JSON; import net.sf.json.JSONObject; import net.sf.json.JSONSerializer; import com.advice.dao.OpinionDao; import com.advice.entity.OpinionPo; import com.advice.util.PageBean; import com.advice.util.ResponseUtil; public class ShowAdminWwqyxycServlet extends HttpServlet { private static final long serialVersionUID = 1L; public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { this.doPost(request, response); } public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { int total = 0;//记录总数 String page=request.getParameter("page")==null?"1":request.getParameter("page"); String rows=request.getParameter("rows")==null?"50":request.getParameter("rows"); //处理筛选条件 String isAudit = request.getParameter("isAudit")==null?"0":request.getParameter("isAudit").toString();//
String isAnswer = request.getParameter("isAnswer")==null?"":request.getParameter("isAnswer").toString();//
OpinionPo OpinionXX = new OpinionPo(); OpinionXX.setIsAudit(isAudit); OpinionXX.setIsAnswer(isAnswer); PageBean pageBean = new PageBean(Integer.parseInt(page),Integer.parseInt(rows)); try{ JSONObject result = new JSONObject(); OpinionDao sd = new OpinionDao(); JSON json = JSONSerializer.toJSON(sd.selectOpinionListALL(pageBean,2,OpinionXX));//数据查询
total = sd.selectOpinionCountAll(2,OpinionXX); result.put("rows", json); result.put("total", total); ResponseUtil.write(response, result); }catch(Exception e){ e.printStackTrace(); } } }
5.后台取值部分示例：
public String selectOpinionListALL(PageBean pageBean, int type, OpinionPo opinionXX){ //处理筛选条件 String isAudit=opinionXX.getIsAudit();//是否审核 String isAnswer=opinionXX.getIsAnswer();//是否回复 StringBuffer filter = new StringBuffer();//查询确址任务管理列表当前页语句 if(isAudit != null && !"".equals(isAudit) && !isAudit.equals("--不限--")){ filter.append(" AND IS_AUDIT = '").append(isAudit).append("' "); } if(isAnswer != null && !"".equals(isAnswer) && !isAnswer.equals("--不限--")){ filter.append(" AND IS_ANSWER = '").append(isAnswer).append("' "); } JsonArray jsonArray = new JsonArray(); StringBuffer sql = new StringBuffer(); sql.append("SELECT * FROM ("); sql.append("SELECT ROW_NUMBER() OVER (ORDER BY suggest_time asc) as RNO, op.* FROM ADVICE_OPINION op"); sql.append(" WHERE 1=1"); sql.append(filter.toString());//查询条件一定要拼接在分页查询语句中 sql.append(" AND opinion_type = '").append(type).append("') WHERE RNO BETWEEN ").append(pageBean.getStart()); sql.append(" AND ").append(pageBean.getEnd()).append(" ORDER BY suggest_time asc"); DBManager dbManager = new DBManager(); Connection conn = null; ResultSet rs = null; conn = dbManager.getConnection(); try { rs = dbManager.executeQuery(sql.toString()); if(rs != null){ while(rs.next()){ JsonObject obj = new JsonObject(); obj.addProperty("OPINION_ID", rs.getString("OPINION_ID"));//
obj.addProperty("OPINION_TYPE", rs.getString("OPINION_TYPE"));// obj.addProperty("TITLE", rs.getString("TITLE"));//标题 obj.addProperty("NAME", rs.getString("NAME"));//姓名 obj.addProperty("DEPARTMENT", rs.getString("DEPARTMENT"));//部门 obj.addProperty("PHONE", rs.getString("PHONE"));//电话 obj.addProperty("EMAIL", rs.getString("EMAIL"));//邮箱 obj.addProperty("FILE_NAME", rs.getString("FILE_NAME"));// obj.addProperty("FILE_PATH", rs.getString("FILE_PATH"));// obj.addProperty("SUGGEST_TYPE", rs.getString("SUGGEST_TYPE"));// obj.addProperty("SUGGEST_CONTENTS", rs.getString("SUGGEST_CONTENTS"));// obj.addProperty("SUGGEST_STEP", rs.getString("SUGGEST_STEP"));// obj.addProperty("SUGGEST_IP", rs.getString("SUGGEST_IP"));//
obj.addProperty("SUGGEST_TIME", rs.getString("SUGGEST_TIME"));// obj.addProperty("IS_AUDIT", rs.getString("IS_AUDIT"));// obj.addProperty("AUDIT_USER_ID", rs.getString("AUDIT_USER_ID"));// obj.addProperty("AUDIT_USER_IP", rs.getString("AUDIT_USER_IP"));// obj.addProperty("AUDIT_TIME", rs.getString("AUDIT_TIME"));// obj.addProperty("IS_ANSWER", rs.getString("IS_ANSWER"));// obj.addProperty("ANSWER_USER_ID", rs.getString("ANSWER_USER_ID"));// obj.addProperty("ANSWER_USER_IP", rs.getString("ANSWER_USER_IP"));// obj.addProperty("ANSWER_TIME", rs.getString("ANSWER_TIME"));// obj.addProperty("THUMB_UP_NUM", rs.getString("THUMB_UP_NUM"));// jsonArray.add(obj); } } } catch (Exception e) { e.printStackTrace(); } finally { //关闭连接 dbManager.closeResultSet(); dbManager.closeStatement(); dbManager.closeConnection(conn); } Gson gson = new Gson(); return gson.toJson(jsonArray); }
