java.sql.SQLException: Parameter metadata not available for the given statement

static void readMeta(String sql, Object[] params) throws SQLException {
        Connection conn = null;
        PreparedStatement ps = null;
        ResultSet rs = null;
        try {
            conn = DBConnectionManager.getConnection();
            ps = conn.prepareStatement(sql);
            ParameterMetaData pmd=ps.getParameterMetaData();
            int count=pmd.getParameterCount();
            for(int i=1;i<=count;i++){
                System.out.print(pmd.getParameterClassName(i)+"  ");
                System.out.print(pmd.getParameterMode(i)+"  ");
                System.out.print(pmd.getParameterType(i)+"  ");
                System.out.println(pmd.getParameterTypeName(i));
            }
        } finally {
            DBConnectionManager.free(rs, ps, conn);
        }
    }

获取元数据时出错：java.sql.SQLException: Parameter metadata not available for the given statement
将登陆数据库时的链接更改一下就可以了，原来

private static final String DB_URL = "jdbc:mysql://localhost:3306/test";

改为

private static final String DB_URL = "jdbc:mysql://localhost:3306/test?generateSimpleParameterMetadata=true";

<script type="text/javascript"> $(function () { $('pre.prettyprint code').each(function () { var lines = $(this).text().split('\n').length; var $numbering = $('<ul/>').addClass('pre-numbering').hide(); $(this).addClass('has-numbering').parent().append($numbering); for (i = 1; i <= lines; i++) { $numbering.append($('<li/>').text(i)); }; $numbering.fadeIn(1700); }); }); </script>