📄 cons.jsp
字号:
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>jb-aptech毕业设计项目</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="<%=request.getContextPath()%>/css/style.css" rel="stylesheet" type="text/css">
<script type='text/javascript' src='<%=request.getContextPath()%>/dwr/engine.js'></script>
<script type='text/javascript' src='<%=request.getContextPath()%>/dwr/util.js'></script>
<script type='text/javascript' src='<%=request.getContextPath()%>/dwr/interface/Pager.js'></script>
<script type='text/javascript' src='<%=request.getContextPath()%>/js/PageCtl1.js'></script>
<script type="text/javascript" src='<%=request.getContextPath()%>/js/s1.js'></script>
<script type="text/javascript">
var tab1 = new TablePage('tab1','TBody1', 'pgCtl', 'cstcst_customer');
//以下是可选的
tab1.dateformat="yyyy年MM月dd日"; //如果包含日期列，这里可以定义日期的显示格式
tab1.sqlFilter="select cust_level_label,coun1=count(*) from cst_customer group by cust_level_label"; //查询条件
tab1.pagesize=10; //每页多少行
tab1.wait='waitCtl'; //等待的提示
tab1.default_callback=function over() //显示完成以后的回调函数
{
waitCtl.style.display = 'none';
};
function searchCust(){
//alert(document.getElementById('condition').value);
var condi = document.getElementById('condition').value;
tab1.sqlFilter ="select "+condi+",coun1=count(*) from cst_customer group by "+condi+"";
tab1.go(1);
}
function shose(id)
{
$('qq1'+id).style.background='#6ec2fd';
$('qq2'+id).style.background='#6ec2fd';
$('qq3'+id).style.background='#6ec2fd';
}
function go(id)
{
$('qq1'+id).style.background='eeeeff';
$('qq2'+id).style.background='eeeeff';
$('qq3'+id).style.background='eeeeff';
}
</script>
</head>
<body onload="javascript:{tab1.go(1)}">
<div class="page_title">客户构成分析</div>
<div class="button_bar">
<button class="common_button" onclick="helpq3();">帮助</button>
</div>
<table class="query_form_table">
<tr>
<th>报表方式</th>
<td>
<select id="condition" onchange="searchCust()">
<option selected value="cust_level_label">按等级</option>
<option value="cust_satisfy">按信用度</option>
<option value="cust_credit">按满意度</option>
</select>
</td>
<th> </th>
<td>
</td>
</tr>
</table>
<br />
<table class="data_list_table">
<tr>
<th>编号</th>
<th>等级</th>
<th>客户数量</th>
</tr>
<tbody id="TBody1">
<tr id="template" style="display:none" onmouseenter="shose(this.id.substring(8))" onmouseleave="go(this.id.substring(8))">
<td class="list_data_number" id="qq1"+template.id.substring(8)><span id="template:numb"/></td><!-- 列的命名规则采用template:列属性 -->
<td class="list_data_text" id="qq2"+template.id.substring(8)><span id="template:cust_level_label"/><span id="template:cust_satisfy"/><span id="template:cust_credit"/> </td>
<td class="list_data_number" id="qq3"+template.id.substring(8)><span id="template:coun"/><span id="template:coun1"/></td>
</tr>
</tbody>
<!-- 表格的分页控制部分 -->
<tr id="reveal" style="display:none"><td align="center" colspan="8">没有找到你所需要的数据</td></tr>
<tr>
<th colspan="100" class="pager">
<div align="left" id="waitCtl">正在加载...</div>
<div id="pgCtl" class="pager">
</th>
</tr>
</table>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -