我有服务器错误，我需要帮助调试...java.sql.SQLSyntaxErrorException： Table/View 'CATEGORY'不存在

我正在使用netbeans。为在线零售商店设计数据库驱动的网站。我在为主页编写代码后遇到错误

    javax.servlet.ServletException: 
    SELECT * FROM category
    : Table/View 'CATEGORY' does not exist.
    java.sql.SQLSyntaxErrorException:
    Table/View 'CATEGORY' does not exist.
    org.apache.derby.client.am.SqlException: 
    Table/View 'CATEGORY' does not exist.

请我需要帮助调试错误并启动和运行我的主页...

<%@taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<%@taglib prefix="sql" uri="http://java.sun.com/jsp/jstl/sql"%>
<html>
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
        <link rel="stylesheet" type="text/css" href="css/affablebean.css">
        <title>Groceries</title>
    </head>

    <body>
        <sql:query var="categories" dataSource="jdbc/affablebean">
            SELECT * FROM category
        </sql:query>

        <div id="indexLeftColumn">
            left column
            <div id="welcomeText">
                <p>[ welcome text ]</p>
                <!-- test to access context parameters -->
                categoryImagePath: ${initParam.categoryImagePath} productImagePath: ${initParam.productImagePath}
            </div>
        </div>

        <div id="indexRightColumn">
            <c:forEach var="category" items="${categories.rows}">
                <div class="categoryBox">
                    <a href="category?${category.id}">
                        <span class="categoryLabelText">${category.name}</span>
                        <img src="${initParam.categoryImagePath}${category.name}.jpg" alt="${category.name}">
                    </a>
                </div>
            </c:forEach>
            <a href="#">
                <span class="categoryLabelText">dairy</span>
            </a>
            <a href="#">
                <span class="categoryLabelText">meats</span>
            </a>
            <a href="#">
                <span class="categoryLabelText">bakery</span>
            </a>
            <a href="#">
                <span class="categoryLabelText">fruit & veg</span>
            </a>
        </div>
    </body>
</html>

尝试像这样写你的sql:query JSTL：

   <sql:query dataSource="${jdbc/affablebean}" var="categories">
    SELECT * FROM category;
   </sql:query>

使用${...}表示dataSource，当然要确保jdbc/affablebean是正确的名称。

同样，您错过了像这样的事情datasource：

   <sql:setDataSource var="jdbc/affablebean" driver="someNameofDriver"
 url="jdbc:mysql://localhost/db"
 user="root"  password="password"/>

有关更多信息，请转到链接

相关内容

最新更新

热门标签：