debug 每次执行到while 就跳到异常处理

Question

报错提示：
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '? and t.colpas=?' at line 1

插入一条记录可以实现，就是取数出现了问题

Answer 1

把 ResultSet rs = ps.executeQuery(sql); 改为 ResultSet rs = ps.executeQuery();