jsp 预览

最新推荐文章于 2024-05-11 15:57:21 发布

woailisha

最新推荐文章于 2024-05-11 15:57:21 发布

阅读量124

点赞数

文章标签： JSP SQL JavaScript Microsoft F# ViewUI

<%@ page contentType="text/html; charset=gb2312" errorPage="" %>
<%@page language="java"%>
<%@page import="java.io.*"%>
<%@page import="java.util.*"%>
<%@page import="java.util.Date"%>
<%@page import="java.sql.*"%>
<%@page import="java.net.*"%>
<%@page import="java.text.*"%>
<%@page import="com.mms.*"%>
<%@ page import="com.jspsmart.upload.*"%>
<%@page import="com.mms.db.ConnSql2000"%>

<%
String copy_tf= request
.getParameter("copytf") != null ? request.getParameter("copytf"): "";
String content_autid=null;
//判断是不是在本页调
String f_beijediao = request.getParameter("bd");
if(f_beijediao==null){
content_autid = request.getParameter("contentinfo_autiding");
session.setAttribute("autiding_session",content_autid);
}else if(f_beijediao.equals("yes")){
}
String content_autiding= (String)session.getAttribute("autiding_session");
if(content_autiding==null){content_autiding="";}
int contentinfo_id = 0;
String businessConfig_name = null;
String contentinfo_subject = null;
String businessConfig_company = null;
String businessConfig_province = null;
String contentinfo_intime = null;
String contentinfo_start_datetime = null;
String contentinfo_end_datetime=null;
String users_name =null;
int contentinfo_autiding =0;
String contentinfo_autiding_string = null;

String usernameYan = (String)session.getAttribute("username");

String plans_mobilenos = null;
String plans_flag = null;
String mobilegroup_mobilecount = null;
//String contentinfo_subject = null;
String strPage = request.getParameter("page");
if (strPage == null || strPage.equals("")) {
strPage = "1";
}

//共几页
int showPage = 0;
int Pagesize = 25;
int Pagecount = 0;
int recordcount = 0;

//链接数据库初始化
ConnSql2000 ConnSql2000 = new ConnSql2000();
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
String sql = "";
int count = 0;
int count2 = 2;
try {
conn = ConnSql2000.getCon();
stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_READ_ONLY);
}
catch (Exception e) {
System.out.println(e);
}
try {
if(content_autiding.equals("2")){
sql = "select contentinfo_id,businessConfig_name,contentinfo_subject,businessConfig_company,businessConfig_province,contentinfo_intime,users_name,contentinfo_autiding from businessconfig,contentinfo,users where contentinfo_autiding=2 and businessConfig.businessConfig_id = contentinfo.businessConfig_id and contentinfo.users_id = users.users_id order by contentinfo_intime desc";

}else{
sql = "select DISTINCT content.contentinfo_id,businessConfig_name,contentinfo_subject,businessConfig_company,businessConfig_province,contentinfo_intime,contentinfo_start_datetime,contentinfo_end_datetime,users_name,contentinfo_autiding from businessconfig,contentinfo,users,content where businessConfig.businessConfig_id = contentinfo.businessConfig_id and contentinfo.users_id = users.users_id and contentinfo.contentinfo_id=content.contentinfo_id order by contentinfo_intime desc";
}//System.out.println(sql);
rs = stmt.executeQuery(sql);

%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>MMS手机报管理平台</TITLE>
<META http-equiv=Content-Type content="text/html; charset=GB2312"><LINK
href="images/main.css" type=text/css rel=stylesheet>
<SCRIPT language=JavaScript src="<%=request.getContextPath() %>/images/main.js"
type=text/javascript></SCRIPT>

<SCRIPT language=JavaScript>
function del_contentinfo(id,subject){
window.location = "del_contentinfo.jsp?contentinfo_id="+id+"&contentinfo_subject="+subject;

}


function copy_content(contentinfo_id){

var url = "contentinfoadd.jsp?copy_contentinfo_id="+contentinfo_id;
var a = window.open(url,'','width=500,height=400');
a.moveTo((screen.width-500)/2,(screen.height-400)/2);

//window.close();
}
</SCRIPT>

<META content="MSHTML 6.00.2900.3268" name=GENERATOR>
<style type="text/css">

</style>
</HEAD>
<BODY>
<TABLE cellSpacing=0 cellPadding=4 width="100%" align=center border=0>
<TBODY>
<TR bgColor=#5a84da>
<TD height=28><span style="FONT-WEIGHT: bold; MARGIN-LEFT: 10px; COLOR: white">计划管理 -
群发计划分组列表</span></TD>
</TR></TBODY></TABLE><LINK
href="images/hot.css" rel=stylesheet>

<TABLE class=N id=HMTB cellSpacing=0 cellPadding=0 width="100%" align=center
border=0>
<TBODY>
<TR>
<TD colSpan=2><IMG height=1 src="<%=request.getContextPath() %>/images/spacer.gif"
width="100%"></TD></TR>
<TR>
<TD>
<TABLE class=O cellSpacing=0 cellPadding=0 width="100%" border=0>
<TBODY>
<TR>
<TD style="WIDTH: 8px"><IMG height=1 src="images/spacer.gif"
width=8></TD>
<TD class=P οnmοuseοver=MO() οnmοuseοut=MU() noWrap><IMG
alt=hspace=1 src="<%=request.getContextPath() %>/images/i.p.cont.group.gif" align=absMiddle
border=0> 计划管理</TD>
<TD width="100%"> </TD></TR></TBODY></TABLE></TD>
<TD style="CURSOR: auto"></TD></TR>
<TR bgColor=#ffffff>
<TD colSpan=2><IMG height=10 src="<%=request.getContextPath() %>/images/spacer.gif"
width="100%"></TD></TR></TBODY></TABLE>
<TABLE class=table_databorder cellSpacing=0 cellPadding=0 width="100%"
align=center border=0>
<TBODY>
<TR>
<TD class=table_databorder_bg vAlign=top width="100%">
<TABLE width="100%" align=center border=1 class=table_databorder cellSpacing=0 cellPadding=0 bordercolor="#66CCFF">
<TBODY>
<TR>
<TD colSpan=8 height=1></TD></TR>
<TR bgcolor="#66CCFF">
<TD width="4%"
height=20 align=middle noWrap class=table_dataheader_cell style="font-size: 3.5mm"><B>ID</B></TD>
<TD width="13%"
height=20 align=middle noWrap class=table_dataheader_cell style="font-size: 3.5mm"><strong>业务名称</strong></TD>
<TD width="13%" align=middle noWrap class=table_dataheader_cell style="font-size: 3.5mm"><strong>标题</strong></TD>
<TD width="5%" align=middle noWrap class=table_dataheader_cell style="font-size: 3.5mm"><strong>公司</strong></TD>
<TD width="4%" align=middle noWrap class=table_dataheader_cell style="font-size: 3.5mm"><strong>所在省</strong></TD>
<TD width="13%" align=middle noWrap class=table_dataheader_cell style="font-size: 3.5mm"><B>创建时间</B></TD>
<TD width="13%" align=middle noWrap class=table_dataheader_cell style="font-size: 3.5mm"><B>开始时间</B></TD>
<TD width="13%" align=middle noWrap class=table_dataheader_cell style="font-size: 3.5mm"><B>结束时间</B></TD>
<TD width="5%"
height=20 align=middle noWrap class=table_dataheader_cell style="font-size: 3.5mm"><B>创建者</B></TD>
<TD width="5%"
height=10 align=middle noWrap class=table_dataheader_cell style="font-size: 3.5mm"><B>是否审核</B></TD>
<TD width="13%" align=middle noWrap class=table_dataheader_cell style="font-size: 3.5mm"><B>操作</B></TD>
</TR>

<%
rs.last();
recordcount = rs.getRow();
// System.out.println("recordcount:" + recordcount);

Pagecount = (recordcount % Pagesize == 0) ? (recordcount / Pagesize)
: (recordcount / Pagesize + 1);

if (strPage != null && !strPage.equals("")) {
showPage = Integer.parseInt(strPage);
if (showPage > Pagecount) {
showPage = Pagecount;
} else if (showPage < 0) {
showPage = 1;
}
} else {
showPage = 1;
}

if (recordcount > 0) {
rs.absolute((showPage - 1) * Pagesize + 1); //

for (int i = 1; i < Pagesize + 1; i++) {
//yushu = i % 8;

contentinfo_id = rs.getInt("contentinfo_id");
businessConfig_name = rs.getString("businessConfig_name");
contentinfo_subject = rs.getString("contentinfo_subject");
businessConfig_company = rs.getString("businessConfig_company");
businessConfig_province = rs.getString("businessConfig_province");
contentinfo_intime = rs.getString("contentinfo_intime");
contentinfo_start_datetime = rs.getString("contentinfo_start_datetime");
contentinfo_end_datetime = rs.getString("contentinfo_end_datetime");
users_name = rs.getString("users_name");
contentinfo_autiding = rs.getInt("contentinfo_autiding");
if(contentinfo_autiding==0){
contentinfo_autiding_string = "未审核";
}else if(contentinfo_autiding==1){
contentinfo_autiding_string = "等待发送";
}else if(contentinfo_autiding==2){
contentinfo_autiding_string = "没通过";
}else if(contentinfo_autiding==3){
contentinfo_autiding_string = "已修改";
}else if(contentinfo_autiding==4){
contentinfo_autiding_string = "发送中...";
}else if(contentinfo_autiding==5){
contentinfo_autiding_string = "发送完毕";
}
%>

<TR onMouseOver="this.style.background='#f0f0f0'"
οnmοuseοut="this.style.background='#FFFFFF'" bgColor=#ffffff>
<TD align=middle height=20 style="font-size: 3.5mm"><A
href="<%=request.getContextPath() %>/content/autidingshow.jsp?contentinfo_id=<%=contentinfo_id%>&autingding=0"><%=contentinfo_id%></A></TD>
<TD height=20 style="font-size: 3.5mm"><%=businessConfig_name%></TD>
<TD align=middle style="font-size: 3.5mm"><%=contentinfo_subject%></TD>
<TD align=middle style="font-size: 3.5mm"><%=businessConfig_company%></TD>
<TD align=middle style="font-size: 3.5mm"><%=businessConfig_province%></TD>
<TD align=middle height=20 style="font-size: 3.5mm"><%=contentinfo_intime%></TD>
<TD align=middle height=20 style="font-size: 3.5mm"><%=contentinfo_start_datetime%></TD>
<TD align=middle height=20 style="font-size: 3.5mm"><%=contentinfo_end_datetime%></TD>
<TD height=20 style="font-size: 3.5mm"><span class="STYLE1"><%=users_name%></TD>
<TD height=30 style="font-size: 3.5mm"><span class="STYLE1"><%=contentinfo_autiding_string%></TD>

<%if(copy_tf.equals("") || copy_tf==null){
if(contentinfo_autiding==1){%>
<TD style="font-size: 3.5mm;background-color: green;"><div align="center">
<A href="#" >[已审核]</A>
<%if(usernameYan.equals(users_name) || "wapadmin".equals(users_name)){%>
<A href="<%=request.getContextPath() %>/content/contentinfoaddok.jsp?contentinfo_id=<%=contentinfo_id%>&contentinfo_subject=<%=contentinfo_subject %>"><font color="olive">[修改]</font></A>

<%}}else if(contentinfo_autiding==2){ %>

<TD style="font-size: 3.5mm;background-color: fuchsia;" align="center">
<A href="<%=request.getContextPath() %>/content/contentinfoaddok.jsp?contentinfo_id=<%=contentinfo_id%>&contentinfo_subject=<%=contentinfo_subject %>">[修改]</A>
<a href="javascript:if(confirm('确定要删除吗？')) del_contentinfo('<%=contentinfo_id %>','<%=contentinfo_subject%>')">[删除]</a>

<%}else if(contentinfo_autiding==0){ %>
<TD style="font-size: 3.5mm;background-color: yellow;"><div align="center"><A
href="<%=request.getContextPath() %>/content/autidingshow.jsp?contentinfo_id=<%=contentinfo_id%>&autingding=1">[审核...]</A>

<%}else if(contentinfo_autiding==3){ %>
<TD style="font-size: 3.5mm;background-color:yellow;"><div align="center"><A
href="<%=request.getContextPath() %>/content/autidingshow.jsp?contentinfo_id=<%=contentinfo_id%>&autingding=1">[重审...]</A>

<%}else if(contentinfo_autiding==4){ %>
<TD style="font-size: 3.5mm;background-color:olive;"><div align="center"><A
href="#">[发送中...]</A>

<%} else if(contentinfo_autiding==5){%>
<TD style="font-size: 3.5mm;background-color:silver;"><div align="center"><A
href="#">[发送完毕]</A>

<%} }else {%>
<TD style="font-size: 3.5mm;background-color:yellow;"><div align="center">
<a href="#" οnclick="copy_content('<%=contentinfo_id%>')">[复制到->]</a>
<%} %>
</div></TD>

</TR>

<%if (!rs.next()) {
break;
}}
}}
catch (Exception e) {
System.out.println(e);

}
try {
if (rs != null) {
rs.close();
rs = null;
}
if (stmt != null) {
stmt.close();
stmt = null;
}
if (conn != null) {
conn.close();
conn = null;
}
}
catch (Exception e) {
System.out.println(e);
}

%>

<TR height=25 >
<TD class=gr align=middle colSpan=5 >
<TABLE cellSpacing=0 cellPadding=0 width="230%" border=0>
<FORM name=navigator2 onSubmit="return jump(2)">
<INPUT type=hidden value=114 name=aid>
<INPUT type=hidden value=535 name=from>
<TBODY>
<TR>

<TD valign="bottom" bgcolor="#3DBAFC">
<div align="center">
<%if(copy_tf.equals("") || copy_tf==null){%>
<span class="STYLE3 STYLE2"> 共<%=recordcount%>条 <%=showPage%>/<%=Pagecount%>页
[<a href="autiding.jsp">首页</a>] <%
if (showPage != 1) {
%>[<a
href="autiding.jsp?bd=yes&page=<%=showPage - 1%>">上一页</a>]<%
}
if (showPage != Pagecount) {
%>[<a
href="autiding.jsp?bd=yes&page=<%=showPage + 1%>">下一页</a>]
<%
}
%>[<a
href="autiding.jsp?bd=yes&page=<%=Pagecount%>">末页</a>]
</span>
<%}else{ %>
<span class="STYLE3 STYLE2"> 共<%=recordcount%>条 <%=showPage%>/<%=Pagecount%>页
[<a href="autiding.jsp?copytf=copy">首页</a>] <%
if (showPage != 1) {
%>[<a
href="autiding.jsp?copytf=copy&bd=yes&page=<%=showPage - 1%>">上一页</a>]<%
}
if (showPage != Pagecount) {
%>[<a
href="autiding.jsp?copytf=copy&bd=yes&page=<%=showPage + 1%>">下一页</a>]
<%
}
%>[<a
href="autiding.jsp?copytf=copy&bd=yes&page=<%=Pagecount%>">末页</a>]
</span>
<%} %>
</div>
</TD>
</TR>
</TBODY>
<BR>
</TABLE>
</TBODY></TABLE></TD></TR></TBODY></TABLE>

</BODY></HTML>