开通博客赚积分
发布资源赚积分
分类

源码开发语言/平台
当前位置：首页 > 源码/资料 > Java编程 > Jsp/Servlet > 查看源码
view_0005fmessage_0002ejsp_jsp.java
资源名称：JSP02.rar　[点击查看]
上传用户：top0756
上传日期：2022-08-11
资源大小：6501k
文件大小：7k
源码类别：

Jsp/Servlet

开发平台：

VBScript

view_0005fmessage_0002ejsp_jsp.java：源码内容
  1. import java.sql.*;
  2. import javax.servlet.*;
  3. import javax.servlet.http.*;
  4. import javax.servlet.jsp.*;
  5. import org.apache.jasper.runtime.*;
  8. public class view_0005fmessage_0002ejsp_jsp extends HttpJspBase {
  11.     static {
  12.     }
  13.     public view_0005fmessage_0002ejsp_jsp( ) {
  14.     }
  16.     private static boolean _jspx_inited = false;
  18.     public final void _jspx_init() throws org.apache.jasper.runtime.JspException {
  19.     }
  21.     public void _jspService(HttpServletRequest request, HttpServletResponse  response)
  22.         throws java.io.IOException, ServletException {
  24.         JspFactory _jspxFactory = null;
  25.         PageContext pageContext = null;
  26.         HttpSession session = null;
  27.         ServletContext application = null;
  28.         ServletConfig config = null;
  29.         JspWriter out = null;
  30.         Object page = this;
  31.         String  _value = null;
  32.         try {
  34.             if (_jspx_inited == false) {
  35.                 synchronized (this) {
  36.                     if (_jspx_inited == false) {
  37.                         _jspx_init();
  38.                         _jspx_inited = true;
  39.                     }
  40.                 }
  41.             }
  42.             _jspxFactory = JspFactory.getDefaultFactory();
  43.             response.setContentType("text/html; charset=GBK");
  44.             pageContext = _jspxFactory.getPageContext(this, request, response,
  45.              "", true, 8192, true);
  47.             application = pageContext.getServletContext();
  48.             config = pageContext.getServletConfig();
  49.             session = pageContext.getSession();
  50.             out = pageContext.getOut();
  52.             // HTML // begin [file="/view_message.jsp";from=(0,48);to=(1,0)]
  53.                 out.write("rn");
  55.             // end
  56.             // HTML // begin [file="/view_message.jsp";from=(1,31);to=(9,0)]
  57.                 out.write("rn<HTML>rn<HEAD>rn<TITLE> show the message in the table </TITLE>rn</HEAD>rn<BODY>rn<p align="center">所有访客留言</p>rn<hr>rn");
  59.             // end
  60.             // begin [file="/view_message.jsp";from=(9,2);to=(35,0)]
  61.                 
  62.                 try
  63.                 {
  64.                 Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
  65.                 String url="jdbc:odbc:dsn112";
  66.                 Connection con=DriverManager.getConnection(url,"insher","insher");
  67.                 Statement stm=con.createStatement();
  68.                 ResultSet result=stm.executeQuery("select count(*) from message");
  69.                 int message_count=0;
  70.                 if(result.next())
  71.                 {
  72.                 message_count=result.getInt(1);
  73.                 result.close();
  74.                 }
  75.                 if(message_count>0)
  76.                 {
  77.                 result=stm.executeQuery("select * from message order by time desc");
  78.                 while(result.next())
  79.                 {
  80.                 String title=result.getString("title");
  81.                 String name=result.getString("name");
  82.                 String mail=result.getString("mail");
  83.                 Timestamp time=result.getTimestamp("time");
  84.                 Date date_time=new Date(time.getTime());
  85.                 Time time_time=new Time(time.getTime());
  86.                 String content=result.getString("content");
  87.             // end
  88.             // HTML // begin [file="/view_message.jsp";from=(35,2);to=(38,14)]
  89.                 out.write("rn<TABLE width="100%" align="center" border=1 cellspacing="0" cellpadding="0" bordercolordark="#000000" bordercolorlight="#88a6dd">rn<tr><td bgcolor="#88a6dd"><font size=2>主题：</font></td>rn<td colspan=3>");
  91.             // end
  92.             // begin [file="/view_message.jsp";from=(38,17);to=(38,22)]
  93.                 out.print(title);
  94.             // end
  95.             // HTML // begin [file="/view_message.jsp";from=(38,24);to=(40,4)]
  96.                 out.write("</td></tr>rn<tr><td bgcolor="#88a6dd"><font size=2>留言人：</font></td>rn<td>");
  98.             // end
  99.             // begin [file="/view_message.jsp";from=(40,7);to=(40,11)]
  100.                 out.print(name);
  101.             // end
  102.             // HTML // begin [file="/view_message.jsp";from=(40,13);to=(42,0)]
  103.                 out.write("</td><td bgcolor="#88a6dd"><font size=2>E-mail：</font></td>rn<td>rn");
  105.             // end
  106.             // begin [file="/view_message.jsp";from=(42,2);to=(44,0)]
  107.                 
  108.                 out.println("<a href=mailto:"+mail+">"+mail+"</a>");
  109.             // end
  110.             // HTML // begin [file="/view_message.jsp";from=(44,2);to=(47,0)]
  111.                 out.write("rn</td></tr>rn<tr><td bgcolor="#88a6dd"><font size=2>留言时间：</font></td><td colspan=3>rn");
  113.             // end
  114.             // begin [file="/view_message.jsp";from=(47,2);to=(49,0)]
  115.                 
  116.                 out.println("<font size=2>"+date_time+" "+time_time+"</font>");
  117.             // end
  118.             // HTML // begin [file="/view_message.jsp";from=(49,2);to=(52,0)]
  119.                 out.write("rn</td></tr>rn<tr><td align="center">rn");
  121.             // end
  122.             // begin [file="/view_message.jsp";from=(52,2);to=(54,0)]
  123.                 
  124.                 out.println("("+message_count+")");
  125.             // end
  126.             // HTML // begin [file="/view_message.jsp";from=(54,2);to=(56,14)]
  127.                 out.write("rn</td>rn<td colspan=3>");
  129.             // end
  130.             // begin [file="/view_message.jsp";from=(56,17);to=(56,24)]
  131.                 out.print(content);
  132.             // end
  133.             // HTML // begin [file="/view_message.jsp";from=(56,26);to=(59,0)]
  134.                 out.write("rn</td></tr>rn</table>rn");
  136.             // end
  137.             // begin [file="/view_message.jsp";from=(59,2);to=(73,0)]
  138.                 
  139.                 out.println("<hr>");
  140.                 message_count--;
  141.                 }
  142.                 result.close();
  143.                 con.close();
  144.                 }
  145.                 else
  146.                 {
  147.                 out.println("目前还没有任何留言！");
  148.                 con.close();
  149.                 }
  150.                 } catch(Exception e)
  151.                 {out.println(e);}
  152.             // end
  153.             // HTML // begin [file="/view_message.jsp";from=(73,2);to=(78,0)]
  154.                 out.write("rn<p align="center"><a href="index1.jsp">我要留言</a></p>rn</body>rn</html>rnrn");
  156.             // end
  158.         } catch (Throwable t) {
  159.             if (out != null && out.getBufferSize() != 0)
  160.                 out.clearBuffer();
  161.             if (pageContext != null) pageContext.handlePageException(t);
  162.         } finally {
  163.             if (_jspxFactory != null) _jspxFactory.releasePageContext(pageContext);
  164.         }
  165.     }
  166. }