String sql3 = "UPDATE bank SET money='" + ab+ "' WHERE cardNumber='" + number1 + "'";
System.out.print(sql3);
st.executeUpdate(sql3);
报错是这个,怎么回事啊?
UPDATE bank SET money='6500.0' WHERE cardNumber='9999999999999999'java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] UPDATE 语句的语法错误。
at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.SQLExecDirect(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcStatement.execute(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcStatement.executeUpdate(Unknown Source)
System.out.print(sql3);
st.executeUpdate(sql3);
报错是这个,怎么回事啊?
UPDATE bank SET money='6500.0' WHERE cardNumber='9999999999999999'java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] UPDATE 语句的语法错误。
at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.SQLExecDirect(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcStatement.execute(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcStatement.executeUpdate(Unknown Source)
如果是字符型就看看设置的长度是多少,是不是超过了设定的长度。