mySQL更新表操作异常

[ComAppleTree]

//向各位老哥求救。。。
//异常信息如下
java.sql.SQLException: No value specified for parameter 1
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:963)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:896)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:885)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:860)
at com.mysql.jdbc.PreparedStatement.checkAllParametersSet(PreparedStatement.java:2205)
at com.mysql.jdbc.PreparedStatement.fillSendPacket(PreparedStatement.java:2185)
at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2052)
at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2009)
at com.mysql.jdbc.PreparedStatement.executeLargeUpdate(PreparedStatement.java:5098)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1994)
at DataBaseControl.DataBaseControl.main(DataBaseControl.java:71)



//代码如下
public static void main(String[] args) throws Exception {
// TODO Auto-generated method stub
Connection connection = null;
try {
connection=DataBaseConnection.getConnection();

String sql="INSERT INTO customer(personalID,First_name,Last_name,Acount_ID,balance) VALUES (?,?,?,?,?)";

PreparedStatement ps=connection.prepareStatement(sql);
ps.executeUpdate();//这里就是第71
ps.setString(1, "3322");
ps.setString(2, "yuan");
ps.setString(3, "xiu");
ps.setString(4, "1230");
ps.setFloat(5, (float) 0.0);
ps.close();
//connection.close();

//preparedStatement=connection.prepareStatement(sql);

//preparedStatement.executeLargeUpdate(sql);

}catch(Exception e) {
e.printStackTrace();
}finally{
connection.close();
}
}

[回炉重造，学习编程中。。。]

ps.executeUpdate();//这里就是第71
ps.setString(1, "3322");
ps.setString(2, "yuan");
ps.setString(3, "xiu");
ps.setString(4, "1230");
ps.setFloat(5, (float) 0.0);

ps.executeUpdate();//这里就是第71
这个得放下面，你顺序搞错了

[wildyy]

先赋值再执行executeUpdate()，顺序搞反了