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

相关表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">
 <!--
 <link rel="stylesheet" type="text/css" href="styles.css">
 -->

  </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>

<html>
<head>

<LINK href="css/user_css.css" type=text/css rel=stylesheet>
</head>

<script language="javascript" >
var tempColor = "#000000";
function returnColor(obj,field){
 var rtn = window.showModalDialog("color.jsp","","dialogWidth:223px;dialogHeight:177px;status:no;help:no;scrolling=no;scrollbars=no");
   if(rtn!=null)
 field.style.background=rtn;
 
    
obj.value = rtn.replace("#", "");
zyiis_sample();
obj1.style.border = "0px solid "+rtn+"";
return;
}

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"><!--#include virtual="/user/left.asp"--></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>
                        &nbsp; ! 定义横向的高度 </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="选取颜色!"  οnclick="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="选取颜色!"  οnclick="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="选取颜色!"  οnclick="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="选取颜色!"  οnclick="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">&nbsp;</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">&nbsp;</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">&nbsp;</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;
      
       %>

  <style type="text/css"  >
 <!--

 .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>

<script>

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>

   <tr bgcolor="#<%=b %>" ><td colspan="<%=num %>">中易广告</td></tr>
  </table>

<%  }

    
    
   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>
  <%} %>

   <tr bgcolor="#<%=b %>" ><td colspan="<%=num %>">中易广告</td></tr>
  </table>         
<%  
    }
 db.closeConnection();
 %>

 

  </body>
</html>

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值