Method querySql

src/main/java/MySQLHelper.java:203–230

(String sql)

    }

    public ResultSet querySql(String sql)
    {
        try {
            if(!conn.isValid(1000))
            {
                if(!init())
                {
                    return null;
                }
            }
            conn.setAutoCommit(true);
            if(statement!=null)
            {
                statement.close();
            }
            statement=conn.createStatement();
            ResultSet  rs = statement.executeQuery(sql);
            return rs;
        } catch (SQLException e) {
            logger.error("querySql error!sql="+sql);
            StringWriter sw = new StringWriter();
            PrintWriter pw = new PrintWriter(sw);
            e.printStackTrace(pw);
            logger.error(e.toString());
            logger.error(sql);
        }
        return null;
    }

    /**
     *