private void _displayRespStrInFrame() {
final JFrame frame = new JFrame("Google Static Map - Error");
GUIUtils.setAppIcon(frame, "69.png");
// frame.setDefaultCloseOperation(DISPOSE_ON_CLOSE);
JTextArea response = new JTextArea(_respStr, 25, 80);
response.addMouseListener(
new MouseListener() {
public void mouseClicked(MouseEvent e) {}
public void mousePressed(MouseEvent e) {
/*frame.dispose();*/
}
public void mouseReleased(MouseEvent e) {}
public void mouseEntered(MouseEvent e) {}
public void mouseExited(MouseEvent e) {}
});
frame.setContentPane(new JScrollPane(response));
frame.pack();
GUIUtils.centerOnScreen(frame);
frame.setVisible(true);
}
public void save() {
for (String key : fields.keySet()) {
JComponent comp = fields.get(key);
if (comp instanceof JTextField) {
JTextField c = (JTextField) comp;
if (c.getText().trim().equals("")) {
sketch.configFile.unset(key);
} else {
sketch.configFile.set(key, c.getText());
}
} else if (comp instanceof JTextArea) {
JTextArea c = (JTextArea) comp;
if (c.getText().trim().equals("")) {
sketch.configFile.unset(key);
} else {
sketch.configFile.set(key, c.getText());
}
}
}
sketch.saveConfig();
}
private void initGUI() {
JPanel pCommand = new JPanel();
pResult = new JPanel();
nsSplitPane = new JSplitPane(JSplitPane.VERTICAL_SPLIT, pCommand, pResult);
pCommand.setLayout(new BorderLayout());
pResult.setLayout(new BorderLayout());
Font fFont = new Font("Dialog", Font.PLAIN, 12);
txtCommand = new JTextArea(5, 40);
txtCommand.setMargin(new Insets(5, 5, 5, 5));
txtCommand.addKeyListener(this);
txtCommandScroll = new JScrollPane(txtCommand);
txtResult = new JTextArea(20, 40);
txtResult.setMargin(new Insets(5, 5, 5, 5));
txtResultScroll = new JScrollPane(txtResult);
txtCommand.setFont(fFont);
txtResult.setFont(new Font("Courier", Font.PLAIN, 12));
/*
// button replaced by toolbar
butExecute = new JButton("Execute");
butExecute.addActionListener(this);
pCommand.add(butExecute, BorderLayout.EAST);
*/
pCommand.add(txtCommandScroll, BorderLayout.CENTER);
gResult = new GridSwing();
gResultTable = new JTable(gResult);
gScrollPane = new JScrollPane(gResultTable);
// getContentPane().setLayout(new BorderLayout());
pResult.add(gScrollPane, BorderLayout.CENTER);
// Set up the tree
rootNode = new DefaultMutableTreeNode("Connection");
treeModel = new DefaultTreeModel(rootNode);
tTree = new JTree(treeModel);
tScrollPane = new JScrollPane(tTree);
tScrollPane.setPreferredSize(new Dimension(120, 400));
tScrollPane.setMinimumSize(new Dimension(70, 100));
txtCommandScroll.setPreferredSize(new Dimension(360, 100));
txtCommandScroll.setMinimumSize(new Dimension(180, 100));
gScrollPane.setPreferredSize(new Dimension(460, 300));
ewSplitPane = new JSplitPane(JSplitPane.HORIZONTAL_SPLIT, tScrollPane, nsSplitPane);
fMain.getContentPane().add(ewSplitPane, BorderLayout.CENTER);
doLayout();
fMain.pack();
}
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 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());
}
private void updateResult() {
if (iResult == 0) {
// in case 'help' has removed the grid
if (bHelp) {
pResult.removeAll();
pResult.add(gScrollPane, BorderLayout.CENTER);
pResult.doLayout();
gResult.fireTableChanged(null);
pResult.repaint();
bHelp = false;
}
} else {
showResultInText();
}
txtCommand.selectAll();
txtCommand.requestFocus();
}
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("");
}
}
// Constructor connection receiving a socket number
public ClientGUI(String host, int port, int udpPort) {
super("Clash of Clans");
defaultPort = port;
defaultUDPPort = udpPort;
defaultHost = host;
// the server name and the port number
JPanel serverAndPort = new JPanel(new GridLayout(1, 5, 1, 3));
tfServer = new JTextField(host);
tfPort = new JTextField("" + port);
tfPort.setHorizontalAlignment(SwingConstants.RIGHT);
// CHAT COMPONENTS
chatStatus = new JLabel("Please login first", SwingConstants.LEFT);
chatField = new JTextField(18);
chatField.setBackground(Color.WHITE);
JPanel chatControls = new JPanel();
chatControls.add(chatStatus);
chatControls.add(chatField);
chatControls.setBounds(0, 0, 200, 50);
chatArea = new JTextArea("Welcome to the Chat room\n", 80, 80);
chatArea.setEditable(false);
JScrollPane jsp = new JScrollPane(chatArea);
jsp.setBounds(0, 50, 200, 550);
JPanel chatPanel = new JPanel(null);
chatPanel.setSize(1000, 600);
chatPanel.add(chatControls);
chatPanel.add(jsp);
// LOGIN COMPONENTS
mainLogin = new MainPanel();
mainLogin.add(new JLabel("Main Login"));
usernameField = new JTextField("user", 15);
passwordField = new JTextField("password", 15);
login = new CButton("Login");
login.addActionListener(this);
sideLogin = new SidePanel(new FlowLayout(FlowLayout.LEFT));
sideLogin.add(usernameField);
sideLogin.add(passwordField);
sideLogin.add(login);
// MAIN MENU COMPONENTS
mainMenu = new MainPanel();
mmLabel = new JLabel("Main Menu");
timer = new javax.swing.Timer(1000, this);
mainMenu.add(mmLabel);
sideMenu = new SidePanel(new FlowLayout(FlowLayout.LEFT));
cmButton = new CButton("Customize Map");
tmButton = new CButton("Troop Movement");
gsButton = new CButton("Game Start");
logout = new CButton("Logout");
cmButton.addActionListener(this);
tmButton.addActionListener(this);
gsButton.addActionListener(this);
logout.addActionListener(this);
sideMenu.add(cmButton);
// sideMenu.add(tmButton);
sideMenu.add(gsButton);
sideMenu.add(logout);
// CM COMPONENTS
mainCM = new MainPanel(new GridLayout(mapSize, mapSize));
tiles = new Tile[mapSize][mapSize];
int tileSize = mainCM.getWidth() / mapSize;
for (int i = 0; i < mapSize; i++) {
tiles[i] = new Tile[mapSize];
for (int j = 0; j < mapSize; j++) {
tiles[i][j] = new Tile(i, j);
tiles[i][j].setPreferredSize(new Dimension(tileSize, tileSize));
tiles[i][j].setSize(tileSize, tileSize);
tiles[i][j].addActionListener(this);
if ((i + j) % 2 == 0) tiles[i][j].setBackground(new Color(102, 255, 51));
else tiles[i][j].setBackground(new Color(51, 204, 51));
mainCM.add(tiles[i][j]);
}
}
sideCM = new SidePanel(new FlowLayout(FlowLayout.LEFT));
cmBack = new CButton("Main Menu");
cmBack.setSize(150, 30);
cmBack.setPreferredSize(new Dimension(150, 30));
cmBack.addActionListener(this);
sideCM.add(cmBack);
// TM COMPONENTS
mainTM = new MainPanel(null);
mapTM = new Map(600);
mapTM.setPreferredSize(new Dimension(600, 600));
mapTM.setSize(600, 600);
mapTM.setBounds(0, 0, 600, 600);
mainTM.add(mapTM);
sideTM = new SidePanel(new FlowLayout(FlowLayout.LEFT));
tmBack = new CButton("Main Menu");
tmBack.setSize(150, 30);
tmBack.setPreferredSize(new Dimension(150, 30));
tmBack.addActionListener(this);
sideTM.add(tmBack);
JRadioButton button;
ButtonGroup group;
ub = new ArrayList<JRadioButton>();
group = new ButtonGroup();
button = new JRadioButton("Barbarian");
button.addActionListener(this);
ub.add(button);
sideTM.add(button);
group.add(button);
button = new JRadioButton("Archer");
button.addActionListener(this);
ub.add(button);
sideTM.add(button);
group.add(button);
createBuildings();
bb = new ArrayList<JRadioButton>();
group = new ButtonGroup();
JRadioButton removeButton = new JRadioButton("Remove Building");
bb.add(removeButton);
sideCM.add(removeButton);
group.add(removeButton);
for (int i = 0; i < bList.size(); i++) {
button = new JRadioButton(bList.get(i).getName() + '-' + bList.get(i).getQuantity());
bb.add(button);
sideCM.add(button);
group.add(button);
}
mainPanels = new MainPanel(new CardLayout());
mainPanels.add(mainLogin, "Login");
mainPanels.add(mainMenu, "Menu");
mainPanels.add(mainCM, "CM");
mainPanels.add(mainTM, "TM");
sidePanels = new SidePanel(new CardLayout());
sidePanels.add(sideLogin, "Login");
sidePanels.add(sideMenu, "Menu");
sidePanels.add(sideCM, "CM");
sidePanels.add(sideTM, "TM");
JPanel mainPanel = new JPanel(null);
mainPanel.setSize(1000, 600);
mainPanel.add(sidePanels);
mainPanel.add(mainPanels);
mainPanel.add(chatPanel);
add(mainPanel, BorderLayout.CENTER);
try {
setIconImage(ImageIO.read(new File("images/logo.png")));
} catch (IOException exc) {
exc.printStackTrace();
}
setDefaultCloseOperation(EXIT_ON_CLOSE);
setSize(1000, 600);
setVisible(true);
setResizable(false);
chatField.requestFocus();
}
public static JTextArea getTextArea(String s) {
JTextArea ret = new JTextArea(s);
ret.setFont(new Font("Courier", Font.PLAIN, 12));
ret.setTabSize(4);
return ret;
}
// called by the Client to append text in the TextArea
void append(String str) {
chatArea.append(str);
chatArea.setCaretPosition(chatArea.getText().length() - 1);
}
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);
}
}
public static void main(String args[]) throws Exception {
final JFrame frame = new JFrame();
final JTextArea textArea = new JTextArea(30, 60);
final JScrollPane scrollPane = new JScrollPane(textArea);
frame.getContentPane().add(scrollPane);
JMenuBar menuBar = new JMenuBar();
frame.setJMenuBar(menuBar);
JMenu menu = new JMenu("File");
ScreenCapture.createImage(menu, "menu.jpg");
menuBar.add(menu);
JMenuItem menuItem = new JMenuItem("Frame Image");
menu.add(menuItem);
menuItem.addActionListener(
new ActionListener() {
public void actionPerformed(ActionEvent e) {
// Let the menu close and repaint itself before taking the image
new Thread() {
public void run() {
try {
Thread.sleep(50);
System.out.println("Creating frame.jpg");
frame.repaint();
ScreenCapture.createImage(frame, "frame.jpg");
} catch (Exception exc) {
System.out.println(exc);
}
}
}.start();
};
});
final JButton button = new JButton("Create Images");
button.addActionListener(
new ActionListener() {
public void actionPerformed(ActionEvent e) {
try {
System.out.println("Creating desktop.jpg");
ScreenCapture.createDesktopImage("desktop.jpg");
System.out.println("Creating frame.jpg");
ScreenCapture.createImage(frame, "frame.jpg");
System.out.println("Creating scrollpane.jpg");
ScreenCapture.createImage(scrollPane, "scrollpane.jpg");
System.out.println("Creating textarea.jpg");
ScreenCapture.createImage(textArea, "textarea.jpg");
System.out.println("Creating button.jpg");
ScreenCapture.createImage(button, "button.jpg");
button.setText("button refreshed");
button.paintImmediately(button.getBounds());
System.out.println("Creating refresh.jpg");
ScreenCapture.createImage(button, "refresh.jpg");
System.out.println("Creating region.jpg");
Rectangle r = new Rectangle(0, 0, 100, 16);
ScreenCapture.createImage(textArea, r, "region.png");
} catch (Exception exc) {
System.out.println(exc);
}
}
});
frame.getContentPane().add(button, BorderLayout.SOUTH);
try {
FileReader fr = new FileReader("ScreenCapture.java");
BufferedReader br = new BufferedReader(fr);
textArea.read(br, null);
br.close();
} catch (Exception e) {
}
frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
frame.pack();
frame.setLocationRelativeTo(null);
frame.setVisible(true);
}
private void clear() {
ifHuge = "";
txtCommand.setText(ifHuge);
}
private void execute() {
gResult.clear();
String sCmd = null;
if (4096 <= ifHuge.length()) {
sCmd = ifHuge;
} else {
sCmd = txtCommand.getText();
}
if (sCmd.startsWith("-->>>TEST<<<--")) {
testPerformance();
return;
}
String g[] = new String[1];
try {
lTime = System.currentTimeMillis();
sStatement.execute(sCmd);
int r = sStatement.getUpdateCount();
if (r == -1) {
formatResultSet(sStatement.getResultSet());
} else {
g[0] = "update count";
gResult.setHead(g);
g[0] = "" + r;
gResult.addRow(g);
}
lTime = System.currentTimeMillis() - lTime;
addToRecent(txtCommand.getText());
gResult.fireTableChanged(null);
} catch (SQLException e) {
lTime = System.currentTimeMillis() - lTime;
g[0] = "SQL Error";
gResult.setHead(g);
String s = e.getMessage();
s += " / Error Code: " + e.getErrorCode();
s += " / State: " + e.getSQLState();
g[0] = s;
gResult.addRow(g);
gResult.fireTableChanged(null);
}
updateResult();
System.gc();
}
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();
}
/** 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 testPerformance() {
String all = txtCommand.getText();
StringBuffer b = new StringBuffer();
long total = 0;
for (int i = 0; i < all.length(); i++) {
char c = all.charAt(i);
if (c != '\n') {
b.append(c);
}
}
all = b.toString();
String g[] = new String[4];
g[0] = "ms";
g[1] = "count";
g[2] = "sql";
g[3] = "error";
gResult.setHead(g);
int max = 1;
lTime = System.currentTimeMillis() - lTime;
while (!all.equals("")) {
int i = all.indexOf(';');
String sql;
if (i != -1) {
sql = all.substring(0, i);
all = all.substring(i + 1);
} else {
sql = all;
all = "";
}
if (sql.startsWith("--#")) {
max = Integer.parseInt(sql.substring(3));
continue;
} else if (sql.startsWith("--")) {
continue;
}
g[2] = sql;
long l = 0;
try {
l = DatabaseManagerCommon.testStatement(sStatement, sql, max);
total += l;
g[0] = "" + l;
g[1] = "" + max;
g[3] = "";
} catch (SQLException e) {
g[0] = g[1] = "n/a";
g[3] = e.toString();
}
gResult.addRow(g);
System.out.println(l + " ms : " + sql);
}
g[0] = "" + total;
g[1] = "total";
g[2] = "";
gResult.addRow(g);
lTime = System.currentTimeMillis() - lTime;
updateResult();
}