codeMirror支持sql输入提示

codeMirror 是一款非常不错的在线代码编辑插件。现在简单介绍对sql编辑的支持。

1. 初始化

(function (){
   
   
            window.top._editor = CodeMirror.fromTextArea($("#codeTypeArea")[0], {
                mode: 'text/x-sql',
                indentWithTabs: true,
                smartIndent: true,
                lineNumbers: true,
                matchBrackets: true,
                autofocus: false,
                styleSelectedText: true,
                extraKeys: {
                    "'a'": completeAfter,
                     "'b'": completeAfter,
                     "'c'": completeAfter,
                     "'d'": completeAfter,
                     "'e'": comp