如何在java odbc中编写"select column name as "别名" from table name"

Question

String sql="select ID as "Batch ID", NAME as "Batch Name",START_DATE as "Start date",END_DATE as "End date"FROM BATCH order by NAME;";      
try {
    pst = con.prepareStatement(sql);
    rs = pst.executeQuery();
    jTable1.setModel(DbUtils.resultSetToTableModel(rs));
}
catch(Exception e) {
    JOptionPane.showMessageDialog(null, e);
}     

这个代码返回一个错误

java.sql。SQLException异常:ora - 00911:无效的字符

我还尝试从查询中删除并替换为'。但它不适合我

Answer 1

分号;不是语句的一部分，所以您需要删除它

Answer 2

"End date"FROM

这就是你的问题。你忘记了一个空格，那么它就是"结束日期"。下次打印你的账单。然后直接在Oracle中运行:)