QueryRunner类的sql语句拼接无法拼接表名
在拼接时会给表名加上单引号,导致sql语句无法执行。
解决方法:
不使用有可变参数的重载方法,sql语句自己拼接:
publicT showUser(Connection connection, Class tClass, String tableName) { T t = null; QueryRunner queryRunner = new QueryRunner(); String sql = "select * from "+tableName; System.out.println(sql); BeanHandler beanHandler; beanHandler = new BeanHandler (tClass); try { t = queryRunner.query(connection, sql, beanHandler); } catch (SQLException e) { e.printStackTrace(); } System.out.println(t.toString()); return t; }