相关表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>
! 定义横向的高度 </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"> </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;
%>
<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>