new_goods.jsp

jsp的技术教程

<%@ include file="head.inc"%>
<%@ page language="java" import="java.sql.*" %>
<jsp:useBean id="workM" scope="page" class="test.faq" />
<jsp:useBean id='clock' scope='page' class='dates.JspCalendar' type="dates.JspCalendar" />      
<%!
public String getStr(String str)
{
	try
	{
		String temp_p=str;
		byte[] temp_t=temp_p.getBytes("GBK");
		String temp=new String(temp_t,"ISO8859_1");
		return temp;
	}
	catch(Exception e)
	{
	 
	}
	return "null";
}
%> 
<%!
public static String category(int id)
{
	try
	{
		switch(id)
		{
			case 1:
				return "计算机类";
				//break;
			case 2:
				return "英语类";
				//break;
			default:
				return "其他类";
				//break;
		}
	}
	catch(Exception e)
	{
	
	}
	return "null";
}
%>                       
<TABLE border=0 cellPadding=0 cellSpacing=0 width=760 align="center">
  <TBODY>
  <tr><td align="left" height=25><%if(session.getAttribute("username")!=null){out.println(session.getAttribute("username"));}%>  当前位置：<a href="../index.jsp">首页</a> -&gt; 新货上架   </td>
 <%@ include file="../member/date.inc"%>
  </tr>
  <TR bgColor=#3399ff>
    <TD height=1 colspan="2"><IMG height=1 src="images/spacer.gif" 
  width=16></TD></TR>
  <tr><td height=10 colspan="2"><IMG height=1 src="images/spacer.gif" 
  width=16></td></tr>
  </TBODY></TABLE>

  <table align="center" border="0" width="760" cellspacing="0" cellpadding="0" height="355">                  
	<tr>                  
		<td width="150" height="355" valign="top">                  
					               
	                
		</td>                  
		<td width="10" height="100%"></td>
		<td width="1" height="100%" bgcolor="#3399ff"></td>
		<td width="10" height="100%"></td>
		<td width="589" height="331" valign="top" background="images/bg1.gif">                       
        <table border="0" width="100%" cellspacing="0" cellpadding="0">        
		<tr>
		<td colspan="2">
		最新10本新书：
		</td>
		<td colspan="2">
		<a href="index.jsp" target="_blank">查看其他书籍</a>
		</td>
		</tr>          
          <tr>                  
            <td width="62%" height="20" bgcolor="#3399ff">&nbsp;<font color="#ffffff">标题</font>       
			</td>
            <td width="15%" height="20" bgcolor="#3399ff">&nbsp;<font color="#ffffff">作者</font>       
			</td>
            <td width="15%" height="20" bgcolor="#3399ff">&nbsp;<font color="#ffffff">类别</font>       
			</td>
            <td width="8%" height="20" bgcolor="#3399ff">&nbsp;<font color="#ffffff">人气</font>       
			</td>
		  </tr>
		  <ul>
	

	
	<%
		String strSQL="SELECT top 10 * FROM book order by on_sale_time desc";
		ResultSet RSa = workM.executeQuery(strSQL);
		
		
		while (RSa.next()) {
			

				out.print("<tr height='23'><td><li><a href=javascript:show('book.jsp?id="+RSa.getInt("id")+"','详细资料',480,500)");
				out.print(">"+getStr(RSa.getString("name"))+"</a></td><td></td><td>"+(category(RSa.getInt("category")))+"</td><td></td></tr>");
			
			}
			
		RSa.close();

	%>

<%////////////////////////////////////////////%>

		  <tr><td height="1" bgcolor="" colspan="2">
		  <hr color="#3399ff">
	
			<td align="left" colspan="2" height="32">
			
			</td>
			<form name="form2" action="index.jsp" method="post">
			<input type="hidden" name="pageNo" value="">
			</form>
			<script language="javascript">
			function sub_page(id)
			{
				if(id==0)
					document.form2.pageNo.value=0;
				else if(id==1)
					document.form2.pageNo.value=2;
				document.form2.submit();
			}
			</script>
		  </tr>
        </table>                  



</form>
	商品分类：<a href="category.jsp?id=1">计算机类</a> |
    		<a href="category.jsp?id=2">英语类 </a> |
			<a href="category.jsp?id=3">其他类 </a> |

        </td>
		
    </tr>
	
  </table>
<%@ include file="footer.inc"%>