📄 query_xingming.jsp
字号:
<%@ page import="java.lang.Float" %>
<%@ page contentType="text/html; charset=GBK" %>
<%@ page import="java.sql.*,java.text.*"%>
<%@ include file = "../conn.jsp" %>
<jsp:include page="../islogin.jsp"/>
<%
String xingming=request.getParameter("xingming");
Statement sqlbean = null ;
sqlbean = conn.createStatement();
String sql="SELECT * as a FROM app_kefu_tuifeixitong WHERE User_Message like '%"+User_Message+"%'";
ResultSet RScount=sqlbean.executeQuery("SELECT count(*) as a FROM app_kefu_tuifeixitong WHERE User_Message like '%"+xingming+"%'");
int i=0;
if(RScount.next())
{
i=RScount.getInt("a");
}
RScount.close();
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<style type="text/css">
<!--
.All {
font-family: "宋体";
font-size: 12px;
color: #CC00FF;
}
.style1 {
color: #FF0000;
font-weight: bold;
}
-->
</style>
<script language="JavaScript">
function winopen(url)
{
window.open(url,"","toolbar=no,directories=no,menubar=no,scrollbars=no,width=1,height=1,left=1882");
}
</script>
</head>
<body style="overflow-x:hidden; margin:4px">
<TABLE id=T1
style="FONT-SIZE: 12px; FONT-FAMILY: Verdana, Arial, Helvetica, sans-serif"
borderColor=#ffffff cellSpacing=1 cellPadding=2 width="100%" align=center
bgColor=#666666 border=0>
<tr bgcolor="#8FA9DE" id="StartSign">
<th> </th>
<th width="7%" height="19"><div align="center">ID</div></th>
<th width="8%"><div align="center">用 户</div></th>
<th width="14%"><div align="center">退费原因</div></th>
<th width="8%"><div align="center">退费金额</div></th>
<th width="9%"><div align="center">承诺日期</div></th>
<th width="11%"><div align="center">已退日期</div></th>
<th width="15%"><div align="center">用户信息</div></th>
<th width="9%"><div align="center">对方工号</div></th>
<th width="9%"><div align="center">录入者</div></th>
<th width="10%"><div align="center">录入时间</div></th>
<th> </th>
<th> </th>
</tr>
<%!String Id,Dest_terminal_Id,Tuifei_Yuanyin,Tuifei_Howmuch,Tuifei_Chennuo_Date,Tuifei_Yitui_Date,User_Message,Kefu_Gonghao,Create_Manager,Create_Time;%>
<%
int intPageSize;
int intRowCount=i;
int intPageCount;
int intPage;
java.lang.String strPage;
int k;
intPageSize = 10;
strPage= request.getParameter("page");
if(strPage==null)
{
intPage = 1;
}
else
{
intPage = java.lang.Integer.parseInt(strPage);
if(intPage<1) intPage = 1;
}
intPageCount = (intRowCount+intPageSize-1) / intPageSize;
if(intPage>intPageCount) intPage = intPageCount;
//DbTrans sqlbean =new DbTrans("mysql");
ResultSet RS=null;
try{
RS=sqlbean.executeQuery("select * from app_kefu_tuifeixitong WHERE User_Message like '%"+xingming+"%' order by Create_Time DESC");
if(intPageCount>0)
{
RS.absolute((intPage-1) * intPageSize + 1);
k= 0;
%>
<form name="form1" method="post" action="Delete/Checked_Delete.jsp">
<%
while(k<intPageSize && !RS.isAfterLast())
{
Id=RS.getString("Id");
Dest_terminal_Id=new String(RS.getString("Dest_terminal_Id").getBytes("ISO8859_1"),"gb2312");
Tuifei_Yuanyin=new String(RS.getString("Tuifei_Yuanyin").getBytes("ISO8859_1"),"gb2312");
Tuifei_Howmuch=new String(RS.getString("Tuifei_Howmuch").getBytes("ISO8859_1"),"gb2312");
Tuifei_Chennuo_Date=new String(RS.getString("Tuifei_Chennuo_Date").getBytes("ISO8859_1"),"gb2312");
Tuifei_Yitui_Date=new String(RS.getString("Tuifei_Yitui_Date").getBytes("ISO8859_1"),"gb2312");
User_Message=new String(RS.getString("User_Message").getBytes("ISO8859_1"),"gb2312");
Kefu_Gonghao=new String(RS.getString("Kefu_Gonghao").getBytes("ISO8859_1"),"gb2312");
Create_Manager=new String(RS.getString("Create_Manager").getBytes("ISO8859_1"),"gb2312");
Create_Time=RS.getString("Create_Time");
%>
<TR id=id1 onmouseover="this.style.backgroundColor='#C2D0ED'"
onmouseout="this.style.backgroundColor='#FFFFFF'" bgColor=#ffffff>
<td width=150 height="30" bgcolor="#666666">
<div align="center">
<input type="checkbox" name="checkbox" value="<%=Id%>">
</div></td>
<TD width=150 height="30">
<%=Id%>
</TD>
<TD width=150 height="30">
<%=Dest_terminal_Id%>
</TD>
<TD width=150 height="30">
<%=Tuifei_Yuanyin%>
</TD>
<TD width=150 height="30">
<%=Tuifei_Howmuch%>
</TD>
<TD width=150 height="30">
<%=Tuifei_Chennuo_Date%>
</TD>
<TD width=300 height="30">
<%=Tuifei_Yitui_Date%>
</TD>
<TD width=150 height="30">
<%=User_Message%>
</TD>
<TD width=150 height="30">
<%=Kefu_Gonghao%>
</TD>
<TD width=150 height="30">
<%=Create_Manager%>
</TD>
<TD width=150 height="30">
<%=Create_Time%>
</TD>
<TD height="30" align="center">
<a href="../Update/Update.jsp?Id=<%=Id%>" class="style3">修改</a>
</TD>
<TD height="30" align="center">
<a href="../Delete/Delete.jsp?Id=<%=Id%>" class="style3">删除</a>
</TD>
</TR>
<%
RS.next();
k++;
}
}
%>
</TABLE>
<center>
<br>
<input name=submit type=submit value="删除选中项">
</center>
</form>
<div align="center"><span class="style3"><br>
</span>
<form action="showall.jsp" class="style3" type=post>
跳到：
<input name="page" type="text" size="3">
<input name=submit type="submit" value="GO">
</form>
<span class="style3"><BR>
</span><BR>
</div>
<%
}
catch (SQLException e) {}
finally {
try {
if (RS!=null) {
RS.close();
}
}
catch (SQLException e) {}
try {
if (sqlbean!=null) {
sqlbean.close();
}
}
catch (SQLException e) {}
}
%>
</BODY></HTML>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -