mati_suni
سه شنبه 14 اسفند 1386, 14:32 عصر
سورس کدتون رو لطف کنید اینجا بذارید.
<%@page contentType="text/html; charset=UTF-8"%>
<%@page pageEncoding="UTF-8"%>
<%@page import="java.sql.*" %>
<jsp:useBean id="db" scope="page" class="saveh.db"/>
<DIV style="WIDTH: 232px; HEIGHT: 25px"></DIV>
<DIV id="RanBan" style="WIDTH: 232px">
<TABLE cellSpacing="0" cellPadding="0" width="232" border="0">
<TBODY>
<TR>
<TD noWrap borderColor="#d2f0ff" width="1" background="img/dot_horz.gif" colSpan="3" height="1"></TD>
</TR>
<TR>
<TD noWrap borderColor="#d2f0ff" width="1" background="img/dot_vert.gif" height="150"></TD>
<TD borderColor="#d2f0ff" width="230">
<TABLE cellSpacing="0" cellPadding="0" width="100%" border="0">
<TBODY>
<TR>
<TD align="right" width="100%" height="150"><A href="http://www.saveh.net/"><IMG src="img/Savehnet.jpg" border="0"></A></TD>
</TR>
</TBODY>
</TABLE>
</TD>
<TD noWrap borderColor="#d2f0ff" width="1" background="img/dot_vert.gif" height="150"></TD>
</TR>
<TR>
<TD noWrap borderColor="#d2f0ff" width="1" background="img/dot_horz.gif" colSpan="3" height="1"></TD>
</TR>
</TBODY>
</TABLE>
</DIV>
<DIV style="WIDTH: 232px; HEIGHT: 25px"></DIV>
<DIV style="WIDTH: 232px">
<TABLE cellSpacing="0" cellPadding="0" width="100%" border="0">
<TBODY>
<TR>
<TD width="100%">
<TABLE cellSpacing="0" cellPadding="4" width="100%" border="0">
<TBODY>
<TR>
<TD class="title" width="100%"><A class="class37" style="FONT-SIZE: 11px" href="agahi.aspx">آگهی های ساوه نت</A></TD>
<TD noWrap><IMG src="img/saveh.gif" border="0"></TD>
</TR>
</TBODY>
</TABLE>
</TD>
</TR>
<TR>
<TD width="100%" height="1"></TD>
</TR>
<TR>
<TD vAlign=top noWrap width=232>
<TABLE cellSpacing=0 cellPadding=0 width=100% background="img/boxcontent.gif" border=0>
<TBODY>
<%
int a = 0;
Statement stmt = db.con();
java.sql.ResultSet col = stmt.executeQuery("SELECT * FROM save_agahi WHERE agahi_value = 'on' ORDER BY agahi_id DESC");
while (col.next()) {
++a;
if (a==11){break;}
%>
<TR>
<TD noWrap width=18></TD>
<TD Style="PADDING-RIGHT:20px; BACKGROUND-POSITION:right 50%; FONT-SIZE:11px; COLOR:#999999; BACKGROUND-REPEAT:no-repeat" width=100% height=21>
<A class=class35 href="<%= "agahi/index.jsp?id=" + col.getString("agahi_id") %>"><%= col.getString("agahi_item") %></A></TD></TR>
<% } %>
</TBODY></TABLE></TD></TR>
<TR>
<TD width="100%" STYLE="font-size:10" ALIGN="LEFT">آگهی خود را به ما بسارید.
<BR>برای افزودن آگهی
<BR><A HREF="agahi/ad.jsp"> اینجا کلیک کنید.</A></TD>
</TR>
</TBODY></TABLE>
</DIV>