Banana-Coding.com - Java Knuddels Emulator

Zitat

CREATE TABLE `vermisst` (`name` VARCHAR( 25 ) NOT NULL ,
`vermisst` VARCHAR( 25 ) NOT NULL) ENGINE = MYISAM ;

Zitat

PoolConnection pcon2E = ConnectionPool.getConnection();
PreparedStatement ps2E = null;

try {
Connection con2E = pcon2E.connect();
ps2E = con2E.prepareStatement("insert into vermisst set name = ?, vermisst = ?");
ps2E.setString(1, client.getName());
ps2E.setString(2, target.getName());
ps2E.execute();


} catch (SQLException e) {
e.printStackTrace();
} finally {
if (ps2E != null) {
try {
ps2E.close();
} catch (SQLException e) {
}
}

pcon2E.close();

}

Zitat

PoolConnection pconla = ConnectionPool.getConnection();
PreparedStatement psla = null;
PreparedStatement pslb = null;
PreparedStatement pslc = null;
try {
Connection conla = pconla.connect();
psla = conla.prepareStatement("SELECT count(name) as summe FROM `vermisst` where vermisst = ?");
psla.setString(1, client.getName());
ResultSet rsla = psla.executeQuery();
Connection conlb = pconla.connect();
pslb = conlb.prepareStatement("SELECT name FROM `vermisst` where vermisst = ? group by name");
pslb.setString(1, client.getName());
ResultSet rslb = pslb.executeQuery();
String vermisst = "";
int lol = 1;
String ha = "";
while(rsla.next()) {
if(rsla.getInt("summe") >= 3) {

while(rslb.next()) {
if(lol != 1) {
vermisst += ", ";
ha = "haben";
}else{
ha = "hat";
}
vermisst += String.format("_°>_h%s|/serverpp \"|/w \"<°_", rslb.getString("name"));
lol++;
}



}

}

if(!vermisst.isEmpty()) {
client.sendButlerMessage(name, String.format("°BB°%s %s dich ziemlich arg vermisst...", vermisst, ha));
Connection conlc = pconla.connect();
pslc = conlc.prepareStatement("delete from vermisst where vermisst = ?");
pslc.setString(1, client.getName());
pslc.execute();
}


} catch (SQLException e) {
e.printStackTrace();
} finally {
if (psla != null) {
try {
psla.close();
} catch (SQLException e) {
}
}

pconla.close();
}

Zitat

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

import tools.database.ConnectionPool;
import tools.database.PoolConnection;

Zitat von »Diebspiel«

Danke für das Snippet, sehr interessant.

Bitte für Codeteile den [java] BB-Code benutzen und nicht den [zitat] BB-Code.