81,092
社区成员
发帖
与我相关
我的任务
分享
package com.federal.manager.service;
import java.sql.DatabaseMetaData;
import java.util.List;
import javax.servlet.http.HttpServletRequest;
import org.apache.commons.beanutils.DynaBean;
import net.sf.json.JSONArray;
import com.federal.manager.database.DataBaseOperator;
import com.federal.manager.util.JsonUtil;
import com.federal.manager.util.StringUtil;
public class Monster_Date {
/**
* @module:怪物管理
* @use:怪物查询
* @time 2013/02/12
* @author mjshu
*
*/
public static JSONArray GetMonsterDate(HttpServletRequest request){
JSONArray jsonArray =null;
String MonsterName = StringUtil.getRequestString(request, "MonsterName");
StringBuffer sql= new StringBuffer("select name,lvi,exp,hp,ac,dc,dcmax from test1 where 1=1 order by lvi desc");
if(MonsterName!=""){
sql.append("and name="+MonsterName+"");
}
List<DynaBean> list=DataBaseOperator.queryList(sql.toString());
jsonArray=JsonUtil.listDynaBeanToJson(list);
return jsonArray;
}
}
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%@page import="net.sf.json.JSONArray"%>
<%@page import="com.federal.manager.service.Monster_Date"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<% JSONArray jsonArray=Monster_Date.GetMonsterDate(request); %>
<script src="js/Jquery1.5.2.js"></script>
<script type="text/javascript" src=js/Monster_date.js></script>
<link href="css/templatemo_style.css" rel="stylesheet" type="text/css" />
<link href="css/smartpaginator.css" rel="stylesheet" type="text/css" />
<link rel="stylesheet" href="css/nivo-slider.css" type="text/css" media="screen" />
<link href="css/style.css" rel="stylesheet" />
<script src="js/jquery.paging.js"></script>
<link rel="stylesheet" type="text/css" href="style/pagination/css/pagination.css"/>
怪物名称查询
<input type="text" id="Monster_Name">
<input type="submit" name="button5" id="Monster_Name" value="搜索" />
<script>
var dataArray= <%=jsonArray%>;
</script>
<table id = "table" width="100%" border="1" cellspacing="0" cellpadding="0" ></table>
<div id="Pagination" ></div>
$(document).ready(function(){
init(dataArray);
if(typeof(dataArray)!="undefined"){
$("#Pagination").pagination(dataArray.length,{
callback:pageselectCallback,
prev_text: '上一页', //上一页按钮里text
next_text: '下一页 ', //下一页按钮里text
items_per_page: 10, //显示条数
num_display_entries: 5, //连续分页主体部分分页条目数
current_page: 0, //当前页索引
num_edge_entries: 3 //两侧首尾分页条目数
}
);
}
}
);
/**
* 设置分页参数
*
*/
function pageselectCallback(page_id, jq) {
var currentIndex = 10*(page_id+1);
var array;
if(typeof(page_id)!="undefined"){
//如果数量少于等于总数量执行
if(currentIndex<=dataArray.length){
var tableObj = document.getElementById("table");
if(tableObj!=null ){
tableObj.innerHTML = "";
}
array = dataArray.slice(10*page_id,currentIndex);
}else{
array = dataArray.slice(10*page_id,dataArray.length);
}
//alert("回调完成");
init(array);
}
}
function init(array){
var tableObj=document.getElementById("table");
var t = tableObj.insertRow(0);
t.width="800";
t.height="8";
t.align = "center";
var d_1=t.insertCell(0);
d_1.width="100";
d_1.height="18";
d_1.innerHTML="怪物名称";
var d_2=t.insertCell(1);
d_2.width="100";
d_2.height="18";
d_2.innerHTML="怪物等级";
var d_3=t.insertCell(2);
d_3.width="100";
d_3.height="18";
d_3.innerHTML="怪物血量";
var d_4=t.insertCell(3);
d_4.width="100";
d_4.height="18";
d_4.innerHTML="怪物防御力";
var d_5=t.insertCell(4);
d_5.width="100";
d_5.height="18";
d_5.innerHTML="怪物攻击力";
var d_6=t.insertCell(5);
d_6.width="100";
d_6.height="18";
d_6.innerHTML="怪物最大攻击力";
var d_7=t.insertCell(6);
d_7.width="100";
d_7.height="18";
d_7.innerHTML="怪物经验值";
var d_8=t.insertCell(7);
d_8.width="100";
d_8.height="18";
d_8.innerHTML="操作";
for(var i=0;i<array.length;i++){
var t_c= tableObj.insertRow(i+1);
t_c.id="tr_"+array[i].id;
t_c.width="800";
t_c.height="18";
t_c.align = "center";
var dc_1 = t_c.insertCell(0);
dc_1.width="100";
dc_1.height="18";
dc_1.innerHTML = array[i].name;
var dc_2 = t_c.insertCell(1);
dc_2.width="100";
dc_2.height="18";
dc_2.innerHTML =array[i].lvi;
var dc_3 = t_c.insertCell(2);
dc_3.width="100";
dc_3.height="18";
dc_3.innerHTML = array[i].hp;
var dc_4 =t_c.insertCell(3);
dc_4.width="100";
dc_4.height="18";
dc_4.innerHTML = array[i].ac;
var dc_5=t_c.insertCell(4);
dc_5.width="100";
dc_5.height="18";
dc_5.innerHTML = array[i].dc;
var dc_6=t_c.insertCell(5);
dc_6.width="100";
dc_6.height="18";
dc_6.innerHTML =array[i].dcmax;
var dc_7=t_c.insertCell(6);
dc_7.width="100";
dc_7.height="18";
dc_7.innerHTML =array[i].exp;
var dc_8=t_c.insertCell(7);
dc_8.width="100";
dc_8.height="18";
dc_8.innerHTML="<a>新年快乐</a>";
}}