Banana-Coding.com - Java Knuddels Emulator

MySQL-Abfrage(n)

CREATE TABLE `career` (
id int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
name varchar(25) NOT NULL,
datum varchar(10) NOT NULL,
text varchar(200) NOT NULL
);

Java-Quelltext

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import tools.database.ConnectionPool;
import tools.database.PoolConnection;

Java-Quelltext

Popup popup = new Popup(title, title, whois.toString(), 460, 350);
        Panel panel = new Panel();
        panel.addComponent(new Button("   OK   "));

Java-Quelltext

if (target.getRank() > 0) {
            Button buttonMessage = new Button("Career");
            buttonMessage.setCommand(String.format("/showcareer %s", nickname));
            buttonMessage.disableClose();
            panel.addComponent(buttonMessage);
        }

Java-Quelltext

if (cmd.equals("a")) {

Java-Quelltext

if (cmd.equals("showcareer")) {
            String nickname = KCodeParser.escape(arg);
           
            if(nickname.isEmpty()) {
                nickname = client.getName();
            }
           
            Client target = Server.get().getClient(nickname);
           
            if (target == null) {
                target = new Client(null);
                target.loadStats(nickname);
 
                if (target.getName() == null) {
                    client.sendButlerMessage(channel.getName(), String.format("Wer ist %s?", nickname));
                    return;
                }
            }
           
            StringBuilder career = new StringBuilder();
            String title = String.format("Laufbahn von %s", target.getName());
            career.append("#°%04°").append(target == Server.get().getButler() ? "21.05.1935" : target.getRegistrationDate()).append("°%34°Registration°%00°");
               
            PoolConnection pcon = ConnectionPool.getConnection();
            PreparedStatement ps = null;
 
            try {
                Connection con = pcon.connect();
                ps = con.prepareStatement("SELECT `datum`, `text` FROM `career` WHERE `name` = ? ORDER BY `id`");
                ps.setString(1, target.getName());
                ResultSet rs = ps.executeQuery();
           
                while(rs.next()) {
                    career.append("#°%04°").append(rs.getString("datum").isEmpty() ? "?" : rs.getString("datum")).append("°%34°").append(rs.getString("text")).append("°%00°");
                }
            } catch (SQLException e) {
                e.printStackTrace();
            } finally {
                if (ps != null) {
                    try {
                        ps.close();
                    } catch (SQLException e) {
                    }
                }
 
                pcon.close();
            }
       
            client.send(Popup.create(title, title, career.toString(), 400, 250));
        }

} elseif (cmd.equals("a")) {