private void showHelp(String help[]) {
txtCommand.setText(help[0]);
bHelp = true;
pResult.removeAll();
pResult.add(txtResultScroll, BorderLayout.CENTER);
pResult.doLayout();
txtResult.setText(help[1]);
pResult.repaint();
txtCommand.requestFocus();
txtCommand.setCaretPosition(help[0].length());
}
void addTextArea(JPanel panel, String key, String label) {
JLabel lab = new JLabel(label);
lab.setAlignmentX(LEFT_ALIGNMENT);
panel.add(lab);
JTextArea field = new JTextArea();
field.setText(sketch.configFile.get(key));
field.setLineWrap(true);
field.setWrapStyleWord(true);
fields.put(key, field);
JScrollPane scroll = new JScrollPane(field);
scroll.setAlignmentX(0.0f);
panel.add(scroll);
}
private void insertTestData() {
try {
DatabaseManagerCommon.createTestTables(sStatement);
refreshTree();
txtCommand.setText(DatabaseManagerCommon.createTestData(sStatement));
refreshTree();
for (int i = 0; i < DatabaseManagerCommon.testDataSql.length; i++) {
addToRecent(DatabaseManagerCommon.testDataSql[i]);
}
execute();
} catch (SQLException e) {
e.printStackTrace();
}
}
public void actionPerformed(ActionEvent e) {
Object o = e.getSource();
for (JRadioButton u : ub) {
if (o == u) {
mapTM.setUnitType(u.getText());
System.out.println("Set unit type - " + u.getText());
return;
}
}
if (o == timer) {
/*
mmLabel.setText("Main Menu ("+(cdTime--)+")");
if(cdTime == 0){
timer.stop();
gsButton.setText("Game Start");
mmLabel.setText("Main Menu");
ArrayList<Building> bArr = new ArrayList<Building>();
String temp = "Elixir Collector-24,8-960|Elixir Collector-31,8-960|Gold Mine-17,10-960|Elixir Collector-25,21-960|Elixir Collector-11,22-960";
String[] bs = temp.split("\\|");
for(String b : bs){
String[] bParts = b.split("-");
String[] cParts = bParts[1].split(",");
int x = Integer.parseInt(cParts[0].trim());
int y = Integer.parseInt(cParts[1].trim());
Building tb = new Building(bParts[0], new Coordinate(x,y));
tb.setHp(Integer.parseInt(bParts[2].trim()));
bArr.add(tb);
}
mapTM.setBuildings(bArr);
switchCards("TM");
}
*/
return;
}
if (o == gsButton) {
if (timer.isRunning()) {
// timer.stop();
gsButton.setText("Game Start");
mmLabel.setText("Main Menu");
// sends the leave command
client.sendUDP("leave~" + unameUDP);
return;
}
// sends the joinlobby command
client.sendUDP("joinlobby~" + unameUDP);
// gsButton.setText("Game Stop");
String serverResp = client.receiveUDP();
if (serverResp.trim().equals("false")) {
// place false handler here
} else {
String[] enemies = serverResp.trim().split(",");
ArrayList<Building> bArr = new ArrayList<Building>();
String mapConfig = getBaseConfig(enemies[0]);
String[] bs = mapConfig.split("\\|");
for (String b : bs) {
String[] bParts = b.split("-");
String[] cParts = bParts[1].split(",");
int x = Integer.parseInt(cParts[0].trim());
int y = Integer.parseInt(cParts[1].trim());
Building tb = new Building(bParts[0], new Coordinate(x, y));
tb.setHp(Integer.parseInt(bParts[2].trim()));
bArr.add(tb);
}
mapTM.setBuildings(bArr);
switchCards("TM");
}
// System.out.println(serverResp);
// cdTime = 10;
// timer.start();
return;
}
if (o == logout) {
client.sendMessage(new ChatMessage(ChatMessage.LOGOUT, ""));
chatArea.setText("");
switchCards("Login");
return;
}
if (o == cmButton) {
String baseConfig = getBaseConfig();
System.out.println("base config: " + baseConfig);
for (int i = 0; i < mapSize; i++) {
for (int j = 0; j < mapSize; j++) {
tiles[i][j].setValue("");
}
}
if (!baseConfig.equals("")) {
String[] bs = baseConfig.split("\\|");
for (String b : bs) {
String[] bParts = b.split("-");
String[] cParts = bParts[1].split(",");
int x = Integer.parseInt(cParts[0].trim());
int y = Integer.parseInt(cParts[1].trim());
int index = 0;
for (int i = 0; i < bb.size(); i++) {
if (bb.get(i).getText().split("-")[0].trim().equals(bParts[0])) {
index = i;
break;
}
}
insertBuilding(y, x, index);
}
}
switchCards("CM");
return;
}
if (o == tmButton) {
ArrayList<Building> bArr = new ArrayList<Building>();
for (int i = 0; i < 40; i++) {
for (int j = 0; j < 40; j++) {
if (tiles[i][j].getValue().equals("") || tiles[i][j].getValue().contains("-")) {
continue;
}
// weird part here
bArr.add(new Building(tiles[i][j].getValue(), new Coordinate(j, i)));
}
}
mapTM.setBuildings(bArr);
switchCards("TM");
return;
}
// if it the who is in button
if (o == whoIsIn) {
client.sendMessage(new ChatMessage(ChatMessage.WHOISIN, ""));
return;
}
if (o == cmBack) {
ArrayList<Building> bArr = new ArrayList<Building>();
for (int i = 0; i < 40; i++) {
for (int j = 0; j < 40; j++) {
if (tiles[i][j].getValue().equals("") || tiles[i][j].getValue().contains("-")) {
continue;
}
// weird part here
bArr.add(new Building(tiles[i][j].getValue(), new Coordinate(j, i)));
}
}
String temp = "mapdata~" + unameUDP + "~";
int tileCount = 40;
int dim = 600;
int tileDim = (int) (dim / tileCount);
int counter = 0;
for (Building b : bArr) {
int x, y, hp;
x = b.getPos().getX() / tileDim;
y = b.getPos().getY() / tileDim;
hp = b.getHp();
temp += b.getName() + "-" + x + "," + y + "-" + hp + "|";
counter += 1;
}
if (counter > 0) {
temp = temp.substring(0, temp.length() - 1); // removes the last '|'
} else {
temp += "none";
}
client.sendUDP(temp); // allows saving of the current state of the map into the user's account
switchCards("Menu");
return;
}
if (o == tmBack) {
switchCards("Menu");
return;
}
for (int i = 0; i < 40; i++) {
for (int j = 0; j < 40; j++) {
if (o == tiles[i][j]) {
for (int k = 0; k < bb.size(); k++) {
if (bb.get(k).isSelected()) {
if (bb.get(k).getText().equals("Remove Building")) {
removeBuilding(i, j);
return;
}
insertBuilding(i, j, k);
// JOptionPane.showMessageDialog(null, bb.get(k).getText());
return;
}
}
// JOptionPane.showMessageDialog(null, "i-"+i+" j-"+j);
return;
}
}
}
// ok it is coming from the JTextField
if (connected) {
// just have to send the message
client.sendMessage(new ChatMessage(ChatMessage.MESSAGE, chatField.getText()));
chatField.setText("");
return;
}
if (o == login) {
// ok it is a connection request
String username = usernameField.getText().trim();
String password = passwordField.getText().trim();
// empty username ignore it
if (username.length() == 0) return;
// empty serverAddress ignore it
String server = tfServer.getText().trim();
if (server.length() == 0) return;
// empty or invalid port numer, ignore it
String portNumber = tfPort.getText().trim();
if (portNumber.length() == 0) return;
int port = 0;
try {
port = Integer.parseInt(portNumber);
} catch (Exception en) {
return; // nothing I can do if port number is not valid
}
// try creating a new Client with GUI
client = new Client(server, port, username, password, this);
// test if we can start the Client
if (!client.start()) return;
unameUDP = username;
switchCards("Menu");
// fetching of the base_config string from the database
chatField.setText("");
chatArea.setText("");
}
}
/** Method declaration */
private void showResultInText() {
String col[] = gResult.getHead();
int width = col.length;
int size[] = new int[width];
Vector data = gResult.getData();
String row[];
int height = data.size();
for (int i = 0; i < width; i++) {
size[i] = col[i].length();
}
for (int i = 0; i < height; i++) {
row = (String[]) data.elementAt(i);
for (int j = 0; j < width; j++) {
int l = row[j].length();
if (l > size[j]) {
size[j] = l;
}
}
}
StringBuffer b = new StringBuffer();
for (int i = 0; i < width; i++) {
b.append(col[i]);
for (int l = col[i].length(); l <= size[i]; l++) {
b.append(' ');
}
}
b.append(NL);
for (int i = 0; i < width; i++) {
for (int l = 0; l < size[i]; l++) {
b.append('-');
}
b.append(' ');
}
b.append(NL);
for (int i = 0; i < height; i++) {
row = (String[]) data.elementAt(i);
for (int j = 0; j < width; j++) {
b.append(row[j]);
for (int l = row[j].length(); l <= size[j]; l++) {
b.append(' ');
}
}
b.append(NL);
}
b.append(NL + height + " row(s) in " + lTime + " ms");
txtResult.setText(b.toString());
}
private void clear() {
ifHuge = "";
txtCommand.setText(ifHuge);
}
public void actionPerformed(ActionEvent ev) {
String s = ev.getActionCommand();
if (s == null) {
if (ev.getSource() instanceof JMenuItem) {
JMenuItem i;
s = ((JMenuItem) ev.getSource()).getText();
}
}
/*
// button replace by toolbar
if (s.equals("Execute")) {
execute();
} else
*/
if (s.equals("Exit")) {
windowClosing(null);
} else if (s.equals("Transfer")) {
Transfer.work(null);
} else if (s.equals("Dump")) {
Transfer.work(new String[] {"-d"});
} else if (s.equals("Restore")) {
Transfer.work(new String[] {"-r"});
} else if (s.equals("Logging on")) {
javaSystem.setLogToSystem(true);
} else if (s.equals("Logging off")) {
javaSystem.setLogToSystem(false);
} else if (s.equals("Refresh Tree")) {
refreshTree();
} else if (s.startsWith("#")) {
int i = Integer.parseInt(s.substring(1));
txtCommand.setText(sRecent[i]);
} else if (s.equals("Connect...")) {
connect(ConnectionDialogSwing.createConnection(fMain, "Connect"));
refreshTree();
} else if (s.equals("Results in Grid")) {
iResult = 0;
pResult.removeAll();
pResult.add(gScrollPane, BorderLayout.CENTER);
pResult.doLayout();
gResult.fireTableChanged(null);
pResult.repaint();
} else if (s.equals("Open Script...")) {
JFileChooser f = new JFileChooser(".");
f.setDialogTitle("Open Script...");
// (ulrivo): set default directory if set from command line
if (defDirectory != null) {
f.setCurrentDirectory(new File(defDirectory));
}
int option = f.showOpenDialog(fMain);
if (option == JFileChooser.APPROVE_OPTION) {
File file = f.getSelectedFile();
if (file != null) {
StringBuffer buf = new StringBuffer();
ifHuge = DatabaseManagerCommon.readFile(file.getAbsolutePath());
if (4096 <= ifHuge.length()) {
buf.append("This huge file cannot be edited. Please execute\n");
txtCommand.setText(buf.toString());
} else {
txtCommand.setText(ifHuge);
}
}
}
} else if (s.equals("Save Script...")) {
JFileChooser f = new JFileChooser(".");
f.setDialogTitle("Save Script");
// (ulrivo): set default directory if set from command line
if (defDirectory != null) {
f.setCurrentDirectory(new File(defDirectory));
}
int option = f.showSaveDialog(fMain);
if (option == JFileChooser.APPROVE_OPTION) {
File file = f.getSelectedFile();
if (file != null) {
DatabaseManagerCommon.writeFile(file.getAbsolutePath(), txtCommand.getText());
}
}
} else if (s.equals("Save Result...")) {
JFileChooser f = new JFileChooser(".");
f.setDialogTitle("Save Result...");
// (ulrivo): set default directory if set from command line
if (defDirectory != null) {
f.setCurrentDirectory(new File(defDirectory));
}
int option = f.showSaveDialog(fMain);
if (option == JFileChooser.APPROVE_OPTION) {
File file = f.getSelectedFile();
if (file != null) {
showResultInText();
DatabaseManagerCommon.writeFile(file.getAbsolutePath(), txtResult.getText());
}
}
} else if (s.equals("Results in Text")) {
iResult = 1;
pResult.removeAll();
pResult.add(txtResultScroll, BorderLayout.CENTER);
pResult.doLayout();
showResultInText();
pResult.repaint();
} else if (s.equals("AutoCommit on")) {
try {
cConn.setAutoCommit(true);
} catch (SQLException e) {
}
} else if (s.equals("AutoCommit off")) {
try {
cConn.setAutoCommit(false);
} catch (SQLException e) {
}
} else if (s.equals("Commit")) {
try {
cConn.commit();
} catch (SQLException e) {
}
} else if (s.equals("Insert test data")) {
insertTestData();
} else if (s.equals("Rollback")) {
try {
cConn.rollback();
} catch (SQLException e) {
}
} else if (s.equals("Disable MaxRows")) {
try {
sStatement.setMaxRows(0);
} catch (SQLException e) {
}
} else if (s.equals("Set MaxRows to 100")) {
try {
sStatement.setMaxRows(100);
} catch (SQLException e) {
}
} else if (s.equals("SELECT")) {
showHelp(DatabaseManagerCommon.selectHelp);
} else if (s.equals("INSERT")) {
showHelp(DatabaseManagerCommon.insertHelp);
} else if (s.equals("UPDATE")) {
showHelp(DatabaseManagerCommon.updateHelp);
} else if (s.equals("DELETE")) {
showHelp(DatabaseManagerCommon.deleteHelp);
} else if (s.equals("CREATE TABLE")) {
showHelp(DatabaseManagerCommon.createTableHelp);
} else if (s.equals("DROP TABLE")) {
showHelp(DatabaseManagerCommon.dropTableHelp);
} else if (s.equals("CREATE INDEX")) {
showHelp(DatabaseManagerCommon.createIndexHelp);
} else if (s.equals("DROP INDEX")) {
showHelp(DatabaseManagerCommon.dropIndexHelp);
} else if (s.equals("CHECKPOINT")) {
showHelp(DatabaseManagerCommon.checkpointHelp);
} else if (s.equals("SCRIPT")) {
showHelp(DatabaseManagerCommon.scriptHelp);
} else if (s.equals("SHUTDOWN")) {
showHelp(DatabaseManagerCommon.shutdownHelp);
} else if (s.equals("SET")) {
showHelp(DatabaseManagerCommon.setHelp);
} else if (s.equals("Test Script")) {
showHelp(DatabaseManagerCommon.testHelp);
}
}
void main() {
CommonSwing.setDefaultColor();
fMain = new JFrame("HSQL Database Manager");
// (ulrivo): An actual icon.
fMain.getContentPane().add(createToolBar(), "North");
fMain.setIconImage(CommonSwing.getIcon());
fMain.addWindowListener(this);
JMenuBar bar = new JMenuBar();
// used shortcuts: CERGTSIUDOLM
String fitems[] = {
"-Connect...", "--", "-Open Script...", "-Save Script...", "-Save Result...", "--", "-Exit"
};
addMenu(bar, "File", fitems);
String vitems[] = {"RRefresh Tree", "--", "GResults in Grid", "TResults in Text"};
addMenu(bar, "View", vitems);
String sitems[] = {
"SSELECT",
"IINSERT",
"UUPDATE",
"DDELETE",
"---",
"-CREATE TABLE",
"-DROP TABLE",
"-CREATE INDEX",
"-DROP INDEX",
"--",
"-CHECKPOINT",
"-SCRIPT",
"-SET",
"-SHUTDOWN",
"--",
"-Test Script"
};
addMenu(bar, "Command", sitems);
mRecent = new JMenu("Recent");
bar.add(mRecent);
String soptions[] = {
"-AutoCommit on",
"-AutoCommit off",
"OCommit",
"LRollback",
"--",
"-Disable MaxRows",
"-Set MaxRows to 100",
"--",
"-Logging on",
"-Logging off",
"--",
"-Insert test data"
};
addMenu(bar, "Options", soptions);
String stools[] = {"-Dump", "-Restore", "-Transfer"};
addMenu(bar, "Tools", stools);
fMain.setJMenuBar(bar);
initGUI();
sRecent = new String[iMaxRecent];
Dimension d = Toolkit.getDefaultToolkit().getScreenSize();
Dimension size = fMain.getSize();
// (ulrivo): full size on screen with less than 640 width
if (d.width >= 640) {
fMain.setLocation((d.width - size.width) / 2, (d.height - size.height) / 2);
} else {
fMain.setLocation(0, 0);
fMain.setSize(d);
}
fMain.show();
// (ulrivo): load query from command line
if (defScript != null) {
if (defDirectory != null) {
defScript = defDirectory + File.separator + defScript;
}
// if insert stmet is thousands of records...skip showing it
// as text. Too huge.
StringBuffer buf = new StringBuffer();
ifHuge = DatabaseManagerCommon.readFile(defScript);
if (4096 <= ifHuge.length()) {
buf.append("This huge file cannot be edited. Please execute\n");
txtCommand.setText(buf.toString());
} else {
txtCommand.setText(ifHuge);
}
}
txtCommand.requestFocus();
}
