Banana-Coding.com - Java Knuddels Emulator

Java-Quelltext

  private void saveStats() {
    	PoolConnection pcon = ConnectionPool.getConnection();
    	PreparedStatement ps = null;

    	try {
        	Connection con = pcon.connect();
        	ps = con.prepareStatement("UPDATE `accounts` SET `kisses` = ?, `knuddels` = ?, `onlineTime` = ?, `ipAddress` = ?, `readme` = ?, `realname` = ?, `event` = ?, `team` = ?, `id` = ?, `comment` = ?, `cmcomment` = ? `stadt` = ?, `land` = ?, `hobbys` = ?, `job` = ?, `motto` = ?, `like` = ?, `wordmixpoints` = ? WHERE `name` = ?");
        	ps.setInt(1, kisses);
        	ps.setInt(2, knuddels);
        	ps.setInt(3, getOnlineTime());
        	ps.setString(4, ipAddress);
        	ps.setString(5, readme);
        	ps.setString(6, realname);
        	ps.setString(7, stadt);
        	ps.setString(8, land);
        	ps.setString(9, hobbys);
        	ps.setString(10, job);
        	ps.setString(11, motto);
        	ps.setString(12, like);
        	ps.setFloat(13, wordmixPoints);
        	ps.setString(14, name);
        	ps.setString(15, event);
        	ps.setString(16, team);
        	ps.setString(17, id);
        	ps.setString(18, comment);
        	ps.setString(19, cmcomment);
        	ps.executeUpdate();
    	} catch (SQLException e) {
        	e.printStackTrace();
    	} finally {
        	if (ps != null) {
            	try {
                	ps.close();
            	} catch (SQLException e) {
            	}
        	}

Quellcode

E:\Fertige Programme\Knuddels Chat>java -cp dist\bananachat.jar;lib\* knuddels.S
erver 2710
Lade den Butler
Lade die Channel styles
Lade alle Channels
Lade die Smileys
online auf port 2710
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in
your SQL syntax; check the manual that corresponds to your MySQL server version
for the right syntax to use near '`stadt` = 'Essen', `land` = 'Deutschland', `ho
bbys` = '', `job` = 'Sysadmin ??>s' at line 1
    	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

    	at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)

    	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Sou
rce)
    	at java.lang.reflect.Constructor.newInstance(Unknown Source)
    	at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
    	at com.mysql.jdbc.Util.getInstance(Util.java:382)
    	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
    	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3603)
    	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3535)
    	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1989)
    	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2150)
    	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2626)
    	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.ja
va:2119)
    	at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java
:2415)
    	at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java
:2333)
    	at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java
:2318)
    	at knuddels.Client.saveStats(Client.java:619)
    	at knuddels.Client.leaveChannel(Client.java:482)
    	at handler.LeaveChannelHandler.handle(LeaveChannelHandler.java:32)
    	at knuddels.SessionHandler.run(SessionHandler.java:90)

Java-Quelltext

`comment` = ?, `cmcomment` = ? `stadt` = ?,