1:<!-- ===================== SQLUTIL ======================== 2:Common: Configurationfile for tsl.jartifex.JArtifex 3:Comment: an utility for sql-statements 4:Author: Thomas Schneider 5:Date: 16.01.2000 6:JDK: 1.2 7:Call: java -jar tsl.jar sqlutil 8:======================================================= --> 9:<JArtifex.sqlutil> 10:<group.Common> 11: LOOKANDFEEL ="Windows" 12: DEBUGMODUS ="ON" 13: LABEL ="LEFT" 14: GROWALL ="OFF" 15: DEVIDESIGN ="RET" 16: POSX ="10" 17: POSY ="0" 18: SIZX ="1014" 19: SIZY ="768" 20: DRIVER ="sun.jdbc.odbc.JdbcOdbcDriver" 21: URL ="jdbc:odbc:timedb" 22: DB ="timedb" 23: USER ="time" 24: PASSWD ="time" 25:</group.Common> 26: 27:<group.Swing> 28:<!-- Visible Fields --> 29: <Split name = "split1" 30: width = "6" 31: alignment= "vertical" 32: position1= "right"> 33: <Split name = "split2" 34: width = "6" 35: alignment= "horizontal" 36: position1= "right"> 37: <Spread name = "sprSqlStatements" 38: title = "Sql-Statements" 39: cmdtype = "READ" 40: command = "samples/data/sql.txt" 41: link = "medSql" 42: tooltip = "Previous executed SQL-Statements. Select one to see it in the SQL-Textfield" 43: width = "2" 44: position1= "right"> 45: </Spread> 46: <Spread name = "sprResults" 47: title = "Results" 48: cmdtype = "READ" 49: editable= "on" 50: command = "samples/data/results.txt" 51: link = "medSql" 52: tooltip = "The link of the SQL-Statement startet with the Button 'Execute' will appear here" 53: position1= "right"> 54: </Spread> 55: </Split> 56: <Text name = "medSql" 57: title = "Sql" 58: enabled = "on" 59: command = "text.txt" 60: link = "bnExecute" 61: tooltip = "The content of this field will be executed by the Buttons below" 62: width = "6"> 63: </Text> 64: </Split> 65:<!-- Execution-Buttons --> 66: <Button name = "bnExecute" 67: title = "Execute" 68: mnemonic= "x" 69: cmdtype = "SQL" 70: command = "[medSql]" 71: link = "split2, actionIsEqual" 72: tooltip = "The content of the SQL-Textfield will be executed as a SQL-Statement"> 73: </Button> 74: <Button name = "bnConnect" 75: title = "Connect" 76: mnem = "c" 77: cmdtype = "CLS" 78: command = "tsl.Database reconnect" 79: tooltip = "Reconnect to any database" 80: position = "right"> 81: </Button> 82: <Button name = "bnPrint" 83: title = "Print" 84: cmdtype = "PRINT" 85: command = "null" 86: tooltip = "Print the selected Component" 87: position = "right"> 88: </Button> 89: <Button name = "bnHelp" 90: title = "Help" 91: cmdtype = "EXE" 92: command = "C:/Programme/Netscape/Communicator/Program/netscape.exe c:/myutil/doc/documentation.html" 93: tooltip = "Show the documentation" 94: position = "right"> 95: </Button> 96: <Button name = "bnSaveSql" 97: title = "SaveSql" 98: cmdtype = "WRITE" 99: command = "sql.txt" 100: link = "sprSqlStatements" 101: position = "right"> 102: </Button> 103: <Button name = "bnSaveResult" 104: title = "SaveResult" 105: cmdtype = "WRITE" 106: command = "results.txt" 107: link = "sprResults" 108: position = "right"> 109: </Button> 110: <Button name = "actionFillTable" 111: title = "FillTable" 112: cmdtype = "APPEND" 113: command = "[medSql]" 114: link = "sprSqlStatements" 115: visible = "off" 116: position = "right"> 117: </Button> 118: <Button name = "actionIsEqual" 119: title = "IsEqual" 120: cmdtype = "CLS" 121: command = "tsl.StringUtil equals [sprSqlStatements] [medSql]" 122: link = "NULL:actionFillTable" 123: visible = "off" 124: position = "right"> 125: </Button> 126:<!-- DB/Loop-Buttons --> 127: <Button name = "bnWinExec" 128: title = "WinExec" 129: cmdtype = "SQL" 130: command = "[medSql]" 131: link = "NEWWINDOW, actionFillTable" 132: position = "down"> 133: </Button> 134: <Button name = "bnLoop" 135: title = "Loop" 136: cmdtype = "DOFOR" 137: command = "sprResults" 138: link = "actionLooper" 139: position = "right"> 140: </Button> 141: <Button name = "bnExport" 142: title = "DB-Export" 143: mnem = "o" 144: cmdtype = "CLS" 145: command = "tsl.Database exportDB" 146: position = "right"> 147: </Button> 148: <Button name = "bnImport" 149: title = "DB-Import" 150: mnem = "i" 151: cmdtype = "CLS" 152: command = "tsl.Database importDB" 153: position = "right"> 154: </Button> 155: <Button name = "bnConfigure" 156: title = "Configure" 157: mnem = "u" 158: cmdtype = "CLS" 159: command = "tsl.jartifex.JArtifex main fedit sqlutil.xml" 160: position = "right"> 161: </Button> 162: <Button name = "bnShowTable" 163: title = "ShowTable" 164: mnem = "t" 165: cmdtype = "SQL" 166: command = "select * from [cbbCommon]" 167: link = "NEWWINDOW" 168: position = "right"> 169: </Button> 170:<!-- Sql-Buttons --> 171: <Combo name = "cbbCommon" 172: title = "Common" 173: cmdtype = "TXT" 174: command = "sql.txt"> 175: </Combo> 176: <Button name = "bnInsert" 177: title = "Insert" 178: mnem = "i" 179: cmdtype = "CLS" 180: command = "_SqlUtil sql @sprResults [cbbCommon] INSERT" 181: position = "right"> 182: </Button> 183: <Button name = "bnUpdate" 184: title = "Update" 185: mnem = "u" 186: cmdtype = "CLS" 187: command = "_SqlUtil sql @sprResults [cbbCommon] UPDATE" 188: position = "right"> 189: </Button> 190: <Button name = "bnDelete" 191: title = "Delete" 192: mnem = "d" 193: cmdtype = "CLS" 194: command = "_SqlUtil sql @sprResults [cbbCommon] DELETE" 195: position = "right"> 196: </Button> 197: <Button name = "bnQuit" 198: title = "Quit" 199: mnem = "q" 200: cmdtype = "EXIT" 201: position = "right"> 202: </Button> 203: <Button name = "actionLooper" 204: visible = "off" 205: cmdtype = "SQL" 206: command = "[medSql]" 207: link = "NEWWINDOW" 208: position = "right"> 209: </Button> 210:</group.Swing> 211:</JArtifex.sqlutil>