📄 newspage.jsp

📁 用JSP写的一个在线购物网站的代码

💻 JSP

字号:

<%@ page contentType="text/html;charset=gb2312" import="java.sql.*" %>
<jsp:useBean id="data" scope="page" class="shop.data.conn" />
<style type="text/css">
<!-- @import url(images/css.css); -->
</style> 
<%
String show=request.getParameter("show");
String sql="select * from news where id='"+show+"'";
ResultSet rs=data.executeQuery(sql);
rs.next();
String title=rs.getString("title");
String text=rs.getString("text");
String addid=rs.getString("addid");
String addtime=rs.getString("addtime").substring(0,16);
String pic=rs.getString("pic");
int counter=rs.getInt("counter");
rs.close();
%>
<head>
<title><%=title%></title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312"></head>
<body leftmargin="0" topmargin="0">
<%
sql="select * from adpic where id='"+2+"'";
rs=data.executeQuery(sql);
rs.next();
String adpic=rs.getString("pic");
rs.close();
%>
<table width="480" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr> 
    <td width="441"><img src="ad/<%=adpic%>" border="0" height="80"></td>
  </tr>
  <tr> 
    <td height="3" background="images/news_dot_line.gif"></td>
  </tr>
  <tr> 
    <td height="20"></td>
  </tr>
  <tr> 
    <td height="25"><div align="center"><font color="#8080C0"><strong><%=title%></strong></font></div></td>
  </tr>
  <tr> 
    <td height="10"></td>
  </tr>
  <tr> 
    <td><div align="center">文章作者:<font color="#FF0000"><%=addid%></font> 　　　添加时间:<%=addtime%></div></td>
  </tr>
  <tr> 
    <td height="20"></td>
  </tr>
  <tr> 
  <%if(pic.equals("")){%>
  <td>
  <%}else{%>
  <td><div align="center"><a target="_blank" href="news/<%=pic%>"><img src="news/<%=pic%>"  width="460" border="0"></a></div>
  <%}%>
  </td>
  </tr>
  <tr>
  <td height="25"></td>
  </tr>
  <tr> 
    <td><table width="90%" border="0" align="center" cellpadding="0" cellspacing="0">
        <tr>
          <td><%=text%></font></td>
        </tr>
      </table></td>
  </tr>
  <tr>
    <td height="10"></td>
  </tr>
</table>
<%
sql="update news set counter='"+(counter+1)+"' where id='"+show+"'";
rs=data.executeQuery(sql);
%>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -