简单记一个灰常SB的错。
sql.append("select"
+"a.MEMBER_NAME, b.ACTION_NAME"
+"from CLUB_MEMBER a,CLUB c, MEMBER_ACTION_RECORD d");
sql.append("WHERE a.CLUB_MEMBER_ID = d.CLUB_MEMBER_ID"
+ "AND a.CLUB_ID = b.CLUB_ID"
+ "AND d.ACTION_ID = ?");
错了,为什么错了?没有空格,SQL打印:
selecta.MEMBER_NAME, b.ACTION_NAMEfrom CLUB_MEMBER a,CLUB c, MEMBER_ACTION_RECORD dWHERE a.CLUB_MEMBER_ID = d.CLUB_MEMBER_IDAND a.CLUB_ID = b.CLUB_IDAND d.ACTION_ID = ?
现在知道为什么错了吧?
正确姿势:
sql.append("select"
+" a.MEMBER_NAME, b.ACTION_NAME"
+" from CLUB_MEMBER a,CLUB c, MEMBER_ACTION_RECORD d");
sql.append(" WHERE a.CLUB_MEMBER_ID = d.CLUB_MEMBER_ID"
+ " AND a.CLUB_ID = b.CLUB_ID"
+ " AND d.ACTION_ID = ?");
看起来差别不大,但是足以让人花上半个小时的时间和库存不足的耐心去看代码。