文字计数,刷新了有文字广告的页就计数

原创于 2008-03-12 16:29:00 发布 · 374 阅读

1 ·

本内容遵循CC 4.0 BY-SA版权协议

标签

#border #class #string #table #stylesheet

java 专栏收录该内容

252 篇文章

订阅专栏

相关表cm_css(id b c font1 title)

cm_txt( id title money url alt yds okok otype tfl display addtime)文字广告,标题title,文本alt,网址url

username (id Username Psw txt_xs) 计数

txtad.jsp

<%@ page language="java" import="java.util.*,java.math.*" contentType="text/html; charset=GB2312"%>
<jsp:directive.page import="java.sql.ResultSet"/>
<jsp:useBean id="db" class="com.pp.db.DBOperation"></jsp:useBean>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
    <base href="<%=basePath%>">

    <title>My JSP 'wenzi2.jsp' starting page</title>

<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">

</head>

<body>

<TABLE class=border height=400 cellSpacing=0 cellPadding=0 width="96%"
align=center bgColor=#ffffff border=0>
<TBODY>
<TR>
    <TD vAlign=top align=middle>
      <TABLE id=demo cellSpacing=1 cellPadding=1 width="92%" align=center
      bgColor=#cccccc border=0>
        <TBODY>
        <TR>
          <TD noWrap bgColor=#eaeaea>
            <DIV align=center>名称</DIV></TD>
          <TD align=middle bgColor=#eaeaea>说明</TD>
          <TD align=middle bgColor=#eaeaea>单价</TD>
          <TD align=middle bgColor=#eaeaea>投放量</TD>
          <TD align=middle width="10%" bgColor=#eaeaea>获取代码</TD></TR>

        <%
    db.creatConnection();
    ResultSet rs=db.executeQuery("select * from cm_txt ");
    while(rs.next()){
    int id=rs.getInt("id");
    String title=rs.getString("title");
   // String money=(rs.getFloat("money")).toString();

        float money = rs.getFloat("money");
        //BigDecimal bg = new BigDecimal(f);
       // bg=bg.setScale(3);//3表示精度位数
       // String money = bg.toString();

    String alt=rs.getString("alt");
    int tfl=rs.getInt("tfl");

   %>
        <TR>
          <TD bgColor=#ffffff height=30>
            <DIV align=center><%=title %></DIV></TD>
          <TD align=middle bgColor=#ffffff><%=alt %></TD>
          <TD align=middle bgColor=#ffffff><FONT color=#ff0000><%=money %> </FONT></TD>
          <TD align=middle bgColor=#ffffff><FONT
          color=#ff0000><%=tfl %></FONT>次</TD>
          <TD align=middle bgColor=#ffffff><A
            href="txtad2.jsp?id=<%=id %>">获取代码</A></TD></TR>



            <%

            }
    db.closeConnection();

             %>


            </TBODY></TABLE>
      <TABLE cellSpacing=0 cellPadding=0 width="96%" align=center
      bgColor=#f1f8fc border=0>
        <TBODY>
        <TR>
          <TD width="29%" height=30><FONT color=red>总共</FONT>有 <B>5</B>
          个点击广告</TD>
          <TD width="71%">
            <TABLE cellSpacing=0 cellPadding=0 width="100%" border=0>
              <TBODY>
              <TR>
                <TD align=middle>共1页/5条当前页次 1/1分页每页10条信息首页上一页下一页
              尾页</TD></TR></TBODY></TABLE>
</body>
</html>
txtad2.jsp

<%@ page language="java" contentType="text/html; charset=GB2312" import="java.sql.*" %>
<jsp:useBean id="db" class="com.pp.db.DBOperation"></jsp:useBean>

function copy(adob){
var obj=findObj(adob); if (obj){
obj.select();js=obj.createTextRange();js.execCommand("Copy");}
alert('代码复制成功请放入网页！');
}

function findObj(n, d){
var p,i,x; if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length){
d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}
if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n];
for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=findObj(n,d.layers[i].document);
if(!x && document.getElementById) x=document.getElementById(n); return x;
}
function okokok()
{
var style=document.form1.style.value;
css = style.split("-");
c = css[0].replace("#", "");
font1 = css[1].replace("#", "");
b= css[2].replace("#", "");

document.all.c.value=c;
document.all.font1.value=font1;
document.all.b.value=b;

document.all.cc.style.backgroundColor = css[0];
document.all.font11.style.backgroundColor = css[1];
document.all.bb.style.backgroundColor = css[2];
document.all.bgg.style.backgroundColor = document.all.bg.value;
zyiis_sample();
}
function zyiis_sample() {

var zyiis=document.form1.zyiis.value;
var style=document.form1.style.value;
var unitwidth=document.form1.unitwidth.value;

var unitheight=document.form1.unitheight.value;
if(document.form1.frame[0].checked){
  frame = 1;
}else{
  frame = 0;
}

if(document.form1.zyiis[1].checked){
  zyiis = 1;
}else{
  zyiis = 0;
}

if(document.form1.num[0].checked){
num = 1;
}
if(document.form1.num[1].checked){
num = 2;
}

if(document.form1.num[2].checked){
  num = 3;
}
if(document.form1.num[3].checked){
  num = 4;
}
if(document.form1.num[4].checked){
  num= 5;
}
/*alert("num"+num);*/
var totalheight;
var totalwidth;

if(zyiis == 1 ) {
  totalheight=unitheight*num;

}
if(zyiis == 0 ) {
  totalwidth=unitwidth*num;

}
   var id=document.all.myid.value;

if(zyiis==0){   //嵌入广告
document.all.codeiframe.value= "<iframe src=text.jsp?id="+id+"&username=admin&zyiis=0&unitheight="+unitheight+"&totalwidth="+totalwidth+"&c="+document.all.c.value+"&font="+document.all.font1.value+"&b="+document.all.b.value+"&frame="+frame+"&num="+num+" height="+unitheight+" width="+totalwidth+" scrolling=no frameborder=0></iframe>";
//复制该代码,嵌入网页中
document.all.ifrSample.innerHTML = "<iframe src=text.jsp?id="+id+"&username=admin&zyiis=0&unitheight="+unitheight+"&totalwidth="+totalwidth+"&c="+document.all.c.value+"&font="+document.all.font1.value+"&b="+document.all.b.value+"&frame="+frame+"&num="+num+" height="+unitheight+" width="+totalwidth+" scrolling=no frameborder=0></iframe>";
}   //下面的一个iframe框架中显示这个有广告的页
else{
document.all.codeiframe.value= "<iframe src=text.jsp?id="+id+"&username=admin&zyiis=1&unitwidth="+unitwidth+"&totalheight="+totalheight+"&c="+document.all.c.value+"&font="+document.all.font1.value+"&b="+document.all.b.value+"&frame="+frame+"&num="+num+" height="+totalheight+" width="+unitwidth+" scrolling=no frameborder=0 ></iframe>";
document.all.ifrSample.innerHTML= "<iframe src=text.jsp?id="+id+"&username=admin&zyiis=1&unitwidth="+unitwidth+"&totalheight="+totalheight+"&c="+document.all.c.value+"&font="+document.all.font1.value+"&b="+document.all.b.value+"&frame="+frame+"&num="+num+" height="+totalheight+" width="+unitwidth+" scrolling=no frameborder=0 ></iframe>";
}
}
</script>
<BODY onLoad="okokok()">

<div id="top"></div>
<div class="center">
<div class="left"></div>
<div class="right">
    <div class="right_bt">Member Center <font color="#FF9900">网站主管理中心</font></div>
      <div class="right_nr"><br />
      <table class="border" cellspacing="0" cellpadding="0" width="96%" height="400" align="center"
    bgcolor="#ffffff" border="0">
              <tr>
                <td valign="top" align="center">

<form action="" method="post" name="form1">
                    <table width="95%" border="0" align="center" cellpadding="3" cellspacing="1" bgcolor="cccccc" >
                      <tr class="listbody">
                        <td width="20%" align="center" bgcolor="#f4fbff"><strong>广告高度</strong></td>
                        <td align="left" bgcolor="#f4fbff"><select name="unitheight" onChange="zyiis_sample()">
                            <option value="120" selected >100</option>
                            <option value="140" >200</option>
                            <option value="160" >300</option>
                          </select>
                        ! </td>
                      </tr>
                      <tr class="listbody">
                        <td align="center" bgcolor="#d7f0ff"><strong>广告风格</strong></td>
                        <td align="left" bgcolor="#d7f0ff"><select name="style" onChange="okokok()">
<%
String id=request.getParameter("id");
   db.creatConnection();
   String title="";
   String font1="";
ResultSet rs= db.executeQuery("select * from Cm_Css");

   while(rs.next()){

   title=rs.getString("title");

   %>
     <option value="<%=rs.getString("c")%>-<%=rs.getString("font1")%>-<%=rs.getString("b")%>" style="background-color:<%=rs.getString("title")%>">   <%=title %></option>

   <% } %>

         </select>
         <input type="text" name="myid" value="<%=id %>">
! 选择广告的风格 </td>
                      </tr>
                      <tr class="listbody">
                        <td align="center" bgcolor="#f4fbff"><strong>广告宽度</strong></td>
                        <td align="left" bgcolor="#f4fbff"><select name="unitwidth" id="select2" onChange="zyiis_sample()">
                            <option value="200">宽140 </option>
                            <option value="300" >宽150 </option>
                            <option value="400" selected>宽180 </option>
                          </select>
                          ! 定义横向的高度 </td>
                      </tr>
                      <tr class="listbody">
                        <td align="center" bgcolor="#d7f0ff"><strong>广告个数</strong></td>
                        <td align="left" bgcolor="#d7f0ff"><input name="num" type="radio" onClick="zyiis_sample()" value=1 checked>
                          1个
                          <input name="num" type="radio" onClick="zyiis_sample()" value=2 >
2个
<input name="num" type="radio" onClick="zyiis_sample()" value=3 >
3个
<input name="num" type="radio" onClick="zyiis_sample()" value=4 >
4个
<input name="num" type="radio" onClick="zyiis_sample()" value=5 >
5个
                      </tr>
                      <tr class="listbody">
                        <td align="center" bgcolor="#f4fbff"><strong>边框颜色</strong></td>
                        <td align="left" bgcolor="#f4fbff"><input name="c" type="text" id="c" size="10" onKeyUp="zyiis_sample()">
                        <span class="TableRow2"><img id="cc" src="images/Rect.gif" border="0" style="cursor:pointer;background-Color:<%=font1%>" title="选取颜色!" onclick="returnColor(c,this)"></span></td>
                      </tr>
                      <tr class="listbody">
                        <td align="center" bgcolor="#d7f0ff"><strong>标题颜色</strong></td>
                        <td align="left" bgcolor="#d7f0ff"><input name="font1" type="text" id="font1" size="10">
                        <span class="TableRow2"><img id="font11" src="images/Rect.gif" border=0 style="cursor:pointer;background-Color:<%=font1%>" title="选取颜色!" onclick="returnColor(font1,this)"></span></td>
                      </tr>

                      <tr class="listbody">
                        <td align="center" bgcolor="#f4fbff"><strong>标志背景</strong></td>
                        <td align="left" bgcolor="#f4fbff"><input name="b" type="text" id="b" size="10">
                        <span class="TableRow2"><img id="bb" src="images/Rect.gif" border=0 style="cursor:pointer;background-Color:<%=font1%>" title="选取颜色!" onclick="returnColor(b,this)"></span></td>
                      </tr>
                      <tr class="listbody">
                        <td align="center" bgcolor="#d7f0ff"><strong>背景颜色</strong></td>
                        <td align="left" bgcolor="#d7f0ff"><input name="bg" type="text" id="bg" value="FFFFFF" size="10">
                        <span class="TableRow2"><img id="bgg" src="images/Rect.gif" border=0 style="cursor:pointer;background-Color:<%=font1%>" title="选取颜色!" onclick="returnColor(bg,this)"></span></td>
                      </tr>
                      <tr class="listbody">
                        <td align="center" bgcolor="#f4fbff"><strong>广告方向</strong></td>
                        <td align="left" bgcolor="#f4fbff"><input name="zyiis" type="radio" onClick="zyiis_sample()" value=0 checked>
横
<input type="radio" name="zyiis" value=1 onClick="zyiis_sample()">
竖</td>
                      </tr>
                      <tr class="listbody">
                        <td align="center" bgcolor="#d7f0ff"><strong>有无框架</strong></td>
                        <td align="left" bgcolor="#d7f0ff"><input type="radio" name="frame" value=1 checked onClick="zyiis_sample()">
                          有 <input type="radio" name="frame" value=0 onClick="zyiis_sample()">
                        无</td>
                      </tr>
                      <tr class="listbody">
                        <td colspan="2" align="left" bgcolor="#f4fbff">说明：<br>
                          1.!宽度的定义是只是对广告方向的纵向才有效,横向宽度选取广告个数自动拉长．<br>
                        2.!高度的定义是对横向的高度,纵向广告个数自动拉长 <br><strong>IFRAME代码脚本（拷贝该代码嵌入页面即可）</strong></td>
                      </tr>
                </table>
                    <table width="95%" border="0" cellpadding="0" cellspacing="0">
                      <tr>
                        <td height="70" colspan="3" align="center" bgcolor="#f4fbff" class="listbody">
                        <textarea name="codeiframe" id="codeiframe" cols="70" rows="3" >

                        </textarea></td>
                        <td align="center" bgcolor="#f4fbff" class="listbody"><a href="#"></a><a href="#"></a></td>
                        <td bgcolor="#f4fbff"> </td>
                      </tr>
                    </table></form>
                    <table width="95%" border="0">
                   <tr></tr>
                 </table>
                    <table width="95%" border="0" cellpadding="0" cellspacing="0">
                      <tr>
                        <td colspan="3" bgcolor="#f4fbff" class="listbody"> </td>
                        <td align="center" bgcolor="#f4fbff" class="listbody">
                          <INPUT class=none type=image height=26
                              width=85 src="images/seexg.gif"
                              border=0 name=imageField onClick=copy('codeiframe')>
                        </td>
                        <td bgcolor="#f4fbff"> </td>
                      </tr>
                    </table>

<table width="98%" border="0" align="center" cellpadding="3" cellspacing="1" bgcolor="#D8D8D8">
                      <tr class="listbody">
                        <td align="center" bgcolor="#FFFFFF">

      <div id="ifrSample" name="ifrSample" align="left" style='width:700px; height:150x; overflow: auto;'>


                        </div></td>
                      </tr>
                    </table>
                 </td>
              </tr>
</table>
<%
db.closeConnection();

%>
</body>
</html>

text.jsp(根据id等其它参数取广告)

<%@ page language="java" contentType="text/html; charset=GB2312" import="java.sql.*" %>
<jsp:useBean id="db" class="com.pp.db.DBOperation"></jsp:useBean>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<%
               String title="";
               String url="";
               String alt="";
             int zyiis=Integer.parseInt(request.getParameter("zyiis"));//广告方向横0 竖1

             String username=request.getParameter("username");
             String c=request.getParameter("c");//边框颜色
             String font=request.getParameter("font");//标题颜色
             String b=request.getParameter("b");//标志背景
             int frame=Integer.parseInt(request.getParameter("frame"));
             int num=Integer.parseInt(request.getParameter("num"));
             int unitheight=0;
             int totalwidth=0;
             int unitwidth=0;
             int totalheight=0;

       %>

.border /*总表格CSS定义*/
{
border: 1px solid #<%=c%>;
}

A:link {
FONT-SIZE: 12px; COLOR: #fff; TEXT-DECORATION: none
}
A:visited {
FONT-SIZE: 12px; COLOR: #fff; TEXT-DECORATION: none
}
A:hover {
FONT-SIZE: 12px; COLOR: #000; TEXT-DECORATION: underline
}
table{
margin-left: 0px;
margin-top: 0px;
margin-right: 0px;
margin-bottom: 0px;
font-size: 12px;
}

.url{
FONT-SIZE: 10px;
COLOR: #<%=font%>;
LINE-HEIGHT: 12px;
TEXT-DECORATION: none;
font-family: arial,sans-serif;
}

-->
</style>
<head>
<title>显示广告的页</title>

var a=parent.location.href;

</script>

</head>

<body>
<%
String id=request.getParameter("id");
//System.out.println(id);
   db.creatConnection();
   //
    String[] sid=new String[num-1];

    String strid="";
   String sql2="select id from cm_txt where id<>"+id;
   String sql3="";
    ResultSet rs2=db.executeQuery(sql2);
     for(int i=0;i<num-1;i++)
      {
        rs2.next();
        sid[i]=rs2.getString(1);

       if(i<num-2)
       {
        strid+=sid[i]+",";
       }
      else
      {
        strid+=sid[i];
      }

    }
   //
   String sql1="";
// System.out.println("strid"+strid);
    if(strid.equals("")){
     sql1="select * from cm_txt where id in("+id+")";
    }
    else{
    sql1="select * from cm_txt where id in("+id+","+strid+")";
    }

//System.out.println(sql1);
ResultSet rs= db.executeQuery(sql1);

// ResultSet rs= db.executeQuery("select * from cm_txt where id="+id);


   if(zyiis==0){
     unitheight=Integer.parseInt(request.getParameter("unitheight"));
     totalwidth=Integer.parseInt(request.getParameter("totalwidth"));
       if(frame==1){ %>
<table <%=totalwidth%>" height="<%=unitheight %>"   cellpadding="1" cellspacing="1" class="border" >
     <% }
    else{
     %>
   <table width="<%=totalwidth%>" height="<%=unitheight %>"   cellpadding="1" cellspacing="1" border="0" >


<%   }

%>
   <tr>   <% for(int i=0;i<num;i++){ rs.next(); title=rs.getString("title");
   sql3="update username set txt_xs=txt_xs+1 where username='"+username+"' and okok=1";
   if(db.executeUpdate(sql3))
   {
   // System.out.println("计数了");
   }
%><td> <font color="#<%=font %>"><%=title %></font></td><%}%></tr>
<tr><% for(int i=0;i<num;i++){
   rs.beforeFirst();
   rs.next(); alt=rs.getString("alt"); %> <td><%=alt %></td><%} %></tr>
<tr> <% for(int i=0;i<num;i++){ rs.beforeFirst(); rs.next(); url=rs.getString("url"); %><td><font color="#4ddb4d"><%=url %></font></td><%} %></tr>

<% }

   else{
     unitwidth=Integer.parseInt(request.getParameter("unitwidth"));
     totalheight=Integer.parseInt(request.getParameter("totalheight"));

      if(frame==1){

%>
   <table <%=unitwidth%>" height="<%=totalheight %>"     cellpadding="1" cellspacing="1" class="border" >
     <% }
    else{
     %>
   <table width="<%=unitwidth%>" height="<%=totalheight %>"    cellpadding="1" cellspacing="1" border="0" >


<%
   }
for( int i=0;i<num;i++){
    sql3="update username set txt_xs=txt_xs+1 where username='"+username+"' and okok=1";
   if(db.executeUpdate(sql3))
   {
    //System.out.println("计数了");
   }
rs.next();
title=rs.getString("title");
alt=rs.getString("alt");
url=rs.getString("url");
   %>
   <tr> <td class="url"><%=title %><br></td></tr>
<tr><td> <%=alt %></td></tr>
<tr><td><font color="#4ddb4d"><%=url %></font></td></tr>
<%} %>