WebRoot/shouye.jsp

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@ page import="com.util.*"%>
<%
request.setCharacterEncoding("gb2312");//设置页面字符集
DBO db=new DBO();//初始链接数据库类
String sql=" ";//
db.open();//打开数据库链接
ResultSet rs=null;//
	
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />

<link href="images/style1.css" rel="stylesheet" type="text/css" />

<title></title>
</head>
<body>
<jsp:include page="header.jsp"/>
<div class="path">
	<p>您的位置：网站首页</p>
</div>
<div class="basic btm10">
  <div class="left">
 <div class="info">

			
					<%

					sql="select * from gonggao where 1=1";
				
					rs=db.query(sql);
					if(rs!=null){
					while(rs.next()){
					%>
               
<li><span><%=rs.getString("fbsj")%></span><a href="agonggao.jsp?keyid=<%=rs.getString("ggid")%>"><%=rs.getString("bt")%></a></li>
                 <%
				 }
				 }
				 %>
    </TBODY></TABLE>
	  
	  </div>
	
	
	<%
	sql="select * from zhuti";
	rs=db.query(sql);
	while(rs.next()){
	%>
    <div class="recomed">
      <h2><span><%=rs.getString("zt")%></span></h2>
      <a href="xinxi.jsp?zt='<%=rs.getString("ztid")%>'"  class="more">更多>></a>
      <ul>
    <ul>
    <%
	  sql="select  * from tiezi where 1=1 and zt='"+rs.getString("ztid")+"' limit 0,8  ";//查询sql语句