mySQL更新表操作异常
//向各位老哥求救。。。
//异常信息如下
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();
}
}