从RestulSet表编辑JTable [英] Editing JTable from RestulSet Table
问题描述
继续此问题.
我的问题是我无法编辑JTable.我得到了一个异常,并且得到了Object值,而不是我应该看到的.
My problem is that I can not edit my JTable. I get an exception and the Object value instead of what I should be seeing.
我正在将 ResultSet Table 代码与MS-Access数据库,并进行了一些修改.可以在此处找到我的代码.调用rs.updateRow()
时遇到错误. java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver]Error in row
.
I am using the ResultSet Table code with a MS-Access database and with a few modifications. My code can be found here. I run into an error when I rs.updateRow()
is called. java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver]Error in row
.
我用updateRow()
在此错误上进行了google搜索,但结果不多.我看到的唯一真正的答案是使用准备好的语句,但我不是SQL命令的专业人士.
I did a google search on this error with updateRow()
and not much came up. The only real answer I saw was to use a prepared statement but I am not a pro with SQL commands.
如果您能告诉我使它成为GlazedList的最佳方法的话,也是一个加号,这样我可以轻松进行过滤.除非您能为我提供可以轻松过滤常规JTables的内容.
Also a plus if you could tell me the best approach in making this become a GlazedList so I can filter easily. Unless you can provide me something that filters regular JTables easily.
推荐答案
尝试提供更多帮助,因为初始解决方案无法100%正常工作.
Trying to offer more help since the initial solution didn't work 100%.
在此处尝试信息:可更新的结果集了解如何从Connection
创建Statement
对象时通过指定参数来使ResultSet
可更新.我意识到默认情况下可能未设置此选项.如果您的驱动程序支持此模式,则应允许代码正常工作.
Try the info here: Updatable ResultSets to see how to make your ResultSet
updatable by specifying arguments when creating a Statement
object from your Connection
. I realized this option may not have been set by default for you. If you driver supports this mode, it should allow the code to work.
它不一定是驱动程序(尽管如果您要更改它,则需要JAR).创建表时需要启用ResultSet.TYPE_SCROLL_SENSITIVE
-驱动程序可能仍支持此模式.有多种方法可以探查JDBC驱动程序支持的功能,但是除非您使用SquirrelSQL Client这样的GUI来获取功能的完整列表,否则使用它们会有些痛苦.
It's not necessarily the driver (though you will need a JAR if you wish to change that). You need to enable ResultSet.TYPE_SCROLL_SENSITIVE
when creating the table -- the driver may still support this mode. There are ways to probe what the JDBC driver supports, but they're kind of a pain to use unless you use a GUI like SquirrelSQL Client to get a full list of capabilities.
这篇关于从RestulSet表编辑JTable的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!