时间戳

首页 > 解决方案 > JSP 在 apache tomcat 服务器中运行时显示原始代码

apache - JSP 在 apache tomcat 服务器中运行时显示原始代码

问题描述

    <%@page import="com.mysql.jdbc.Driver;" %>
    <%@page contentType="text/html" pageEncoding="UTF-8"%>
     <%@page import="java.sql.*" %>
     <!DOCTYPE HTML>
     <html>
       <head>
         <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
    <title>Service Provider</title>
    <link href="stylesheet.css" type="text/css" rel="stylesheet" media="all" 
      />
    <link href="vendor/bootstrap/css/bootstrap.min.css" rel="stylesheet">
          <link href="css/round-about.css" rel="stylesheet">
    </head>
   <body>
    <%
        int count=0;
                     Class.forName("com.mysql.jdbc.Driver");
                     Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/dbase","root","");
                     Statement st= con.createStatement();
                     ResultSet rs = st.executeQuery("select * from requests");
    %>
        <table border="0">
            <tr>
                <td class="top">
                </td>
            </tr>
            <tr>
                <td class="header">
                </td>
            </tr>
            <tr>
                <td class="menu">
                   <ul>
                        <li><a href="Admin.jsp">Add Car</a></li>
                        <li><a href="Delete.jsp">View Service Request</a></li>
                        <li><a href="Update.jsp">Update Request</a></li>
                        <li><a href="View.jsp">View Transactions</a></li>
                  </ul>
                </td>
            </tr>
            <tr>
                <td align="left">
                  <strong class="wel">Welcome&nbsp;</strong><strong class="bm"><%= session.getAttribute("userName") %></strong><br>
                   <a href="Login.jsp">Logout</a>
                </td>
            </tr>
            <tr>
                <td>
                    <h2>View Transaction</h2>
                </td>
            </tr>               
                <table border="0" align="center" cellpadding="2" 
                      cellspacing="2">
                    <tr class="field_name">
                        <td><div align="center"><strong>Rent ID</strong> 
                     </div></td>
                        <td><div align="center"><strong>Vehicle No.</strong> 
                    </div></td>
                        <td><div align="center"><strong>SP Name</strong> 
                    </div></td>
                        <td><div align="center"><strong>Pickup Date</strong> 
                    </div></td>
                        <td><div align="center"><strong>Return Date</strong> 
                   </div></td>
                        <td><div align="center"><strong>Rent Days</strong> 
                     </div></td>
                        <td><div align="center"><strong>Rent Price</strong> 
                          </div></td>
                        <td><div align="center"><strong>Total Rent</strong> 
                          </div></td>
                        <td><div align="center"><strong>Current 
                         Mileage</strong></div></td>
                        <td><div align="center"><strong>Gas Level</strong> 
                        </div></td>
                        <td><div align="center"><strong>Rent Status</strong> 
                             </div></td>
                        <td><div align="center"><strong>Reserved By</strong> 
                          </div></td>
                        <td colspan="2"><div align="center"> 
                        <strong>Action</strong></div></td>
                    </tr>
                     <%
                     while(rs.next())
                     {
                        rs.getInt("Rent_iD");
                    %>
                    <tr class="view_field">
                        <td><div align="center"><%=++count %></div></td>
                        <td><%= rs.getString("Vehicle_Number") %></td>
                        <td><%= rs.getString("SP_Name") %></td>
                        <td><%= rs.getString("Pickup_date") %></td>
                        <td><%= rs.getString("Return_Date") %></td>
                        <td><%= rs.getString("Rent_days") %></td>
                        <td><%= rs.getString("Rent_Price") %></td>
                        <td><%= rs.getString("Total_Rent") %></td>
                        <td><%= rs.getString("Current_Mileage") %></td>
                        <td><%= rs.getString("Gas_Level") %></td>
                        <td><%= rs.getString("Rent_status") %></td>
                        <td><%= rs.getString("ReservedBy") %></td>
                        <td><div align="center"><a 
                        href="Update.jsp">Update</a></div></td>       
                    </tr>
                </table>    
            <tr>
                <table border="0" width="100%" height="100%">
                    <tr>
                      <td class="footer">
                        <ul class="footer_ul">
                        <li><a href="Admin.jsp">Add Car</a></li>
                        <li><a href="Delete.jsp">View Service Request</a> 
                        </li>
                        <li><a href="Update.jsp">Update Request</a></li>
                        <li><a href="ViewTransaction.jsp">View 
                      Transactions</a></li>
                        </ul>
                      </td>
                   </tr>
                   <tr>
                      <td class="footer">

                      </td>
                   </tr>

                   </table>
                   </tr>
                 </table>
                </body>
               </html>

这是我们试图在 netbeans IDE 中运行的代码，当我们使用 apache tomcat 服务器通过 jsp 运行它时，它所做的只是在将代码运行到 localhost 时显示代码的原始文件。我们哪里出了问题？或者代码的哪一部分出错了，为什么它只显示原始代码或文件？非常感谢。

和 web.xml 文件在这里..

<?xml version="1.0" encoding="UTF-8"?>
 <web-app version="3.1" xmlns="http://xmlns.jcp.org/xml/ns/javaee" 
 xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
 xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee 
 http://xmlns.jcp.org/xml/ns/javaee/web-app_3_1.xsd">
  <servlet>
        <servlet-name>loginServlet</servlet-name>
       <servlet-class>org.servlet.loginServlet</servlet-class>
   </servlet>
   <servlet>
       <servlet-name>validate</servlet-name>
        <servlet-class>org.servlet.validate</servlet-class>
    </servlet>
       <servlet>
             <servlet-name>query</servlet-name>
             <servlet-class>org.servlet.query</servlet-class>
       </servlet>
        <servlet-mapping>
            <servlet-name>loginServlet</servlet-name>
            <url-pattern>/loginServlet</url-pattern>
        </servlet-mapping>
      <servlet-mapping>
         <servlet-name>validate</servlet-name>
         <url-pattern>/validate</url-pattern>
     </servlet-mapping>
     <servlet-mapping>
      <servlet-name>query</servlet-name>
       <url-pattern>/query</url-pattern>
     </servlet-mapping>
    <session-config>
      <session-timeout>
           30
      </session-timeout>
     </session-config>
    </web-app>

标签： apachejsptomcat

解决方案

推荐阅读