SQLException：并非所有变量都已关联

代码如下：

注意那行红色的，当改为

<span style="color:#ff0000;">preparedstatement.execute();<span style="font-family: Arial, Helvetica, sans-serif;"></span></span><span style="font-family: Arial, Helvetica, sans-serif;">就不会报错了</span>

public void  addPerson(Person person)
	{
		String sql="insert into person(id,name,password,age,email,image) values(?,?,?,?,?,?)";
		
		try{
			PreparedStatement preparedstatement=connection.getconnection().prepareStatement(sql);
			
			preparedstatement.setString(1,person.getID());
			preparedstatement.setString(2,person.getName());
			preparedstatement.setString(3,person.getPassword());
			preparedstatement.setInt(4,person.getAge());
			preparedstatement.setString(5,person.getEmail());
			preparedstatement.setString(6,person.getImage());
			
<span style="color:#ff0000;">			<span style="color:#ff0000;">preparedstatement.execute(sql);</span></span>
			preparedstatement.close();
			
			JOptionPane.showMessageDialog(null, "添加已成功");
		}
		
		catch(SQLException e)
		{
			JOptionPane.showMessageDialog(null, "添加未成功");
			e.printStackTrace();
		}
	
	}