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="zh_recommed" id="zh_recommed">
      <h2><span>网站新闻</span></h2>
      <div class="info"><%
	sql="select * from xtxw";
	rs=db.query(sql);
	while(rs.next()){
	%>
	<li><span><%=rs.getString("sj")%></span><a href="axinwen.jsp?keyid=<%=rs.getString("xtxwid")%>"><%=rs.getString("bt")%></a></li>
	
	<% }%>
	   </div>
    </div>
  
  
	
	
	<%
	sql="select * from clzl";
	rs=db.query(sql);
	while(rs.next()){
	%>
    <div class="recomed">
      <h2><span><%=rs.getString("zl")%></span></h2>
      <a href="cheliang.jsp"  class="more">更多>></a>
      <ul>
    <ul>
    <%
	  sql="select  * from cheliang where 1=1 and zl='"+rs.getString("zl")+"' limit 0,8  ";//查询sql语句
		db.open();//打开数据库链接
 	ResultSet	r=db.query(sql);//查询结果
		while(r.next()){
	%>
			 <li><a href="acheliang.jsp?keyid=<%=r.getString("clid")%>"><%=r.getString("cl")%></a></li>     
	<%