使用Prepared Statements设置表名 [英] Using Prepared Statements to set Table Name
本文介绍了使用Prepared Statements设置表名的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我正在尝试使用预准备语句来设置表名以从中选择数据,但在执行查询时我一直收到错误。
I'm trying to use prepared statements to set a table name to select data from, but I keep getting an error when I execute the query.
错误示例代码显示如下。
The error and sample code is displayed below.
[Microsoft][ODBC Microsoft Access Driver] Parameter 'Pa_RaM000' specified where a table name is required.
private String query1 = "SELECT plantID, edrman, plant, vaxnode FROM [?]"; //?=date
public Execute(String reportDate){
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn = DriverManager.getConnection(Display.DB_MERC);
PreparedStatement st = conn.prepareStatement(query1);
st.setString(1, reportDate);
ResultSet rs = st.executeQuery();
关于可能导致此问题的任何想法?
Any thoughts on what might be causing this?
推荐答案
表名不能用作参数。它必须是硬编码的。所以你可以这样做:
A table name can't be used as a parameter. It must be hard coded. So you can do something like:
private String query1 = "SELECT plantID, edrman, plant, vaxnode FROM [" + reportDate + "?]";
这篇关于使用Prepared Statements设置表名的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文