Database problem
Jeg har et problem jeg kan sku ikke lige se hvor fejlen er i min kode. Den siger den skal bruge 13 parametre, men jeg updater kun 12. I databasen er der 13 elementer. Men den ene af dem skal ikke kunne updateres. Koden ser sådan ud:public void updatePlayer(Player p, String memberID) throws Exception
{
Connection con = DriverManager.getConnection(url);
try
{
PreparedStatement ps = con.prepareStatement("UPDATE Members SET [First name] = ?, [Last name] = ?, Address = ?, City = ?, Zipcode = ?, Birthday = ?, Phonenumber = ?, UserLvl = ?, Elite = ?, Coach = ?, Inactive = ? WHERE memberID = ?");
ps.setString(1, p.getFirstName());
ps.setString(2, p.getLastName());
ps.setString(3, p.getAddress());
ps.setString(4, p.getCity());
ps.setInt(5, p.getZip());
ps.setString(6, "0");
ps.setInt(7, p.getPhone());
ps.setString(8, p.getUserLevel());
ps.setBoolean(9, p.isElite());
ps.setBoolean(10, p.isTrainer());
ps.setBoolean(11, p.isInactive());
ps.setString(12, memberID); // ID there is being updated
ps.executeUpdate();
} finally
{
con.close();
}
}
