在数据库里执行下面的SQL语句可得到正确结果,放在java代码里错误了!Stringsql="SELECTtradeId,t.cardNo,tradeType,tradeAmount,targetCard,poundage,tradeTime,acceptBankID,atmNoF...
在数据库里执行下面的SQL语句可得到正确结果,放在java代码里错误了!
String sql = "SELECT tradeId, t.cardNo, tradeType, tradeAmount, targetCard, poundage, tradeTime, acceptBankID, atmNo FROM Trade t JOIN BankCard b on t.cardNo = b.cardNo JOIN Customer c on b.custId = c.custId WHERE name = ? ";
错误信息:
java.sql.SQLException: com.microsoft.sqlserver.jdbc.SQLServerException: 列名 'name' 无效。 Query: SELECT tradeId, t.cardNo, tradeType, tradeAmount, targetCard, poundage, tradeTime, acceptBankID, atmNo FROM Trade t JOIN BankCard b on t.cardNo = b.cardNo JOIN Customer c on b.custId = c.custId WHERE name = ? Parameters: [xiaoxiao]
at org.apache.commons.dbutils.AbstractQueryRunner.rethrow(AbstractQueryRunner.java:363)
at org.apache.commons.dbutils.QueryRunner.query(QueryRunner.java:350)
at org.apache.commons.dbutils.QueryRunner.query(QueryRunner.java:211)
at com.javaweb.bank.dao.impl.BaseDAO.queryForList(BaseDAO.java:123)
at com.javaweb.bank.test.TradeDAOImplTest.testGetTradesWithName(TradeDAOImplTest.java:61)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
........
.....
展开