语句中找不到表 [英] Table not found in statement

问题描述

Class.forName("org.hsqldb.jdbcDriver");
    conn = DriverManager.getConnection("jdbc:hsqldb:file:Pokemondaten","sa","");
    getData = conn.createStatement();
    ResultSet rs = getData.executeQuery
    ("SELECT HP FROM PKMN WHERE ID = " + basicnumber); 
    int hpp = rs.getInt(1);
    System.out.println(hpp);

我所能得到的

java.sql.SQLException: Table not found in statement [SELECT HP FROM PKMN]
    at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
    at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
    at org.hsqldb.jdbc.jdbcStatement.executeQuery(Unknown Source)
    at pokeWpRechner.Main.main(Main.java:46)

我的数据库名为 Pokemondaten ，而我的表称为 PKMN ，我的表也是在程序中继承的.

My Databased is called Pokemondatenand my table is called PKMN, also my table is inherited in the programm.

那我做错了什么?我不明白.

So what did i do wrong? i dont get it.

推荐答案

尝试以下操作

conn = DriverManager.getConnection("jdbc:hsqldb:file:Pokemondaten;shutdown=true","sa","")

这应该防止表定义丢失

这篇关于语句中找不到表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！