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

来源：互联网发布：健身会所软件编辑：程序博客网时间：2024/06/05 20:03

代码如下：

注意那行红色的，当改为

<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();}}

0 0