score_record_list.jsp

来自「一个用java编写的功能强大的OA系统」· JSP 代码 · 共 130 行

JSP
130 行
字号 
<%@ page contentType="text/html;charset=utf-8"%>
<%@ page import="cn.js.fan.db.*"%>
<%@ page import="cn.js.fan.util.*"%>
<%@ page import="cn.js.fan.web.*"%>
<%@ page import="com.redmoon.forum.person.*"%>
<%@ page import="com.redmoon.forum.plugin.*"%>
<%@ taglib uri="/WEB-INF/tlds/LabelTag.tld" prefix="lt" %>
<%
String skincode = UserSet.getSkin(request);
if (skincode.equals(""))
	skincode = UserSet.defaultSkin;
SkinMgr skm = new SkinMgr();
Skin skin = skm.getSkin(skincode);
if (skin==null)
	skin = skm.getSkin(UserSet.defaultSkin);
String skinPath = skin.getPath();
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<link href="<%=skinPath%>/skin.css" rel="stylesheet" type="text/css">
<title><lt:Label res="res.label.forum.score_transfer" key="score_transfer_list"/> - <%=Global.AppName%></title>
<style type="text/css">
<!--
body {
	margin-left: 0px;
	margin-top: 0px;
}
-->
</style></head>
<body>
<%@ include file="inc/header.jsp"%>
<jsp:useBean id="StrUtil" scope="page" class="cn.js.fan.util.StrUtil"/>
<jsp:useBean id="privilege" scope="page" class="com.redmoon.forum.Privilege"/>
<div id="newdiv" name="newdiv">
<%
//安全验证
	String querystring = StrUtil.getNullString(request.getQueryString());
	String privurl=request.getRequestURL()+"?"+StrUtil.UrlEncode(querystring,"utf-8");
	if (!privilege.isUserLogin(request)) {
		response.sendRedirect("../index.jsp");
		return;
	}
	
	String operate = ParamUtil.get(request, "operate");
	String sql = "select id from sq_score_record where buyer="+StrUtil.sqlstr(privilege.getUser(request)) + " and operation=" + StrUtil.sqlstr(operate) + " order by lydate desc";
	if (operate.equals("")) {
		sql = "select id from sq_score_record where buyer="+StrUtil.sqlstr(privilege.getUser(request)) + " order by lydate desc";
	}

	ScoreRecordDb srd = new ScoreRecordDb();
	int pagesize = 10;
	Paginator paginator = new Paginator(request);
	int curpage = paginator.getCurPage();
				
	ListResult lr = srd.listResult(sql, curpage, pagesize);
	int total = lr.getTotal();
	Vector v = lr.getResult();
	Iterator ir = null;
	if (v!=null)
		ir = v.iterator();
	paginator.init(total, pagesize);
	// 设置当前页数和总页数
	int totalpages = paginator.getTotalPages();
	if (totalpages==0)
	{
		curpage = 1;
		totalpages = 1;
	}
%>
  <div align="center"><font color="#706AD9"><br>
    <strong><lt:Label res="res.label.forum.score_transfer" key="score_record"/></strong></font><strong><br>
    <br>
    </strong></div> 
  <TABLE width="80%" border=0 align=center cellPadding=0 cellSpacing=1 bgcolor="#edeced">
    <TBODY>
      <TR class="td_title"> 
        <TD width=181 height=23 align="center"><lt:Label res="res.label.forum.score_transfer" key="from_user_name"/></TD>
        <TD width=167 height=23 align="center"><lt:Label res="res.label.forum.score_transfer" key="to_use_name"/></TD>
        <TD width=162 height=23 align="center"><lt:Label res="res.label.forum.score_transfer" key="date"/></TD>
        <TD width=165 height="23" align="center"><lt:Label res="res.label.forum.score_transfer" key="value"/></TD>
        <TD width=107 align="center"><lt:Label res="res.label.forum.score_transfer" key="operation"/></TD>
      </TR>
<%		
	String lydate="", buyer="", seller="", fromScore="", toScore="", operation="";
	double fromValue=0, toValue=0;
	UserDb fud = new UserDb();
	UserDb tud = new UserDb();
	while (ir.hasNext()) {
		srd = (ScoreRecordDb)ir.next();
		fud = fud.getUser(srd.getBuyer());
		tud = tud.getUser(srd.getSeller());
		
		java.util.Date date = new java.util.Date();	
		date.setTime(Long.parseLong(srd.getLydate()));
		lydate = DateUtil.format(date, "yyyy-MM-dd HH:mm");
		
		fromScore = srd.getFromScore();
		ScoreMgr sm = new ScoreMgr();
		ScoreUnit pu = sm.getScoreUnit(fromScore);
		
		toValue = srd.getToValue();
%>
      <TR bgColor=#f8f8f8> 
        <TD width=181 height=23 align="center"><%=fud.getNick()%></TD>
        <TD width=167 height=23 align="center"><%=tud.getNick()%></TD>
        <TD width=162 height=23 align="center"><%=ForumSkin.formatDate(request, DateUtil.parse(lydate))%></TD>
        <TD height="23" align="center"><%=pu.getName()%> <%=toValue%></TD>
        <TD width=107 height=23 align="center">
		<%if (srd.getOperation().equals(ScoreRecordDb.OPERATION_TRANSFER)) {%>
		<lt:Label res="res.label.forum.score_transfer" key="score_transfer"/>
		<%}else if (srd.getOperation().equals(ScoreRecordDb.OPERATION_EXCHANGE)) {%>
		<lt:Label res="res.label.forum.score_exchange" key="score_exchange"/>
		<%}else{%>
		<lt:Label res="res.label.forum.score_transfer" key="score_pay"/>
		<%}%>
		</TD>
      </TR>
<%
	}
%>
    </TBODY>
  </TABLE>
</div>
<%@ include file="inc/footer.jsp"%>
</body>
</html>

score_record_list.jsp - 源码说明

本页面展示了「一个用java编写的功能强大的OA系统」中的 score_record_list.jsp 源码文件，采用 JSP 编程语言编写，共 130 行代码。您可以在线阅读完整代码内容，也可以返回资源详情页下载完整源码包进行本地学习和开发。

虫虫下载站收录了大量与Java相关的技术资源，包括源代码、技术文档、电路图等，是电子工程师和嵌入式开发者的专业学习平台。

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?