/** * 执行sql */ private function _execute($command = '') { $exeSql = empty($command) ? trim($this->_gets->getParam('command')) : $command; $formatExeSql = XUtils::splitsql($exeSql); foreach ($formatExeSql as $sql) { if (empty($sql)) { continue; } try { $resultData = self::_executeCommand($sql); if (false !== $resultData['result']) { if ($resultData['type'] == 'query') { if (empty($resultData['result'])) { echo '执行完成'; } $fields = array_keys($resultData['result'][0]); echo $this->render('query_result', array('fields' => $fields, 'dataList' => $resultData['result'], 'command' => $command), true); } else { echo "<div style='color:red;padding:10px 0'>执行完成: {$sql}</div>"; } } else { echo "执行失败"; } } catch (Exception $e) { echo "<div style='color:red;padding:10px 0'>执行失败: {$sql}</div>"; } } }