使用準(zhǔn)備好的語(yǔ)句設(shè)置表名我試圖使用準(zhǔn)備好的語(yǔ)句來(lái)設(shè)置一個(gè)表名以從中選擇數(shù)據(jù)，但是在執(zhí)行查詢(xún)時(shí)，我一直會(huì)收到一個(gè)錯(cuò)誤。錯(cuò)誤和示例代碼顯示在下面。[Microsoft][ODBC Microsoft Access Driver] Parameter 'Pa_RaM000' specified where a table name is required.private
String query1 = "SELECT plantID, edrman, plant, vaxnode FROM [?]"; //?=datepublic 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();對(duì)造成這一切的原因有什么想法嗎？
3 回答
臨摹微笑
TA貢獻(xiàn)1982條經(jīng)驗(yàn) 獲得超2個(gè)贊
private String query1 = "SELECT plantID, edrman, plant, vaxnode FROM [" + reportDate + "?]";
FFIVE
TA貢獻(xiàn)1797條經(jīng)驗(yàn) 獲得超6個(gè)贊
String sql = "IF ? = 99\n";sql += "SELECT * FROM first_table\n"; sql += "ELSE\n";sql += "SELECT * FROM second_table"; PreparedStatement ps = con.prepareStatement(sql);
ps.setInt(1, 99);
添加回答
舉報(bào)
0/150
提交
取消