语句中找不到表 [英] 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 Pokemondaten
and 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屋!
查看全文