J a v a 编程中常见的错误有哪些？ sql 错误 找不到列 Unknown column „fillMen‟ in „field list‟ 2.列名在sql 语句中写了2次 Column „fillMan‟ specified twice 3.下面2条 数据库插入对应的列都是int 类型的 所插入的数据类型不符合要求时报错 Data truncated for column „gatheringMoney‟ at row 1 Data truncation: Out of range value adjusted for column „amount‟ at row 1 4. Mixing of GROUP columns (MIN(),MAX(),COUNT(),…) with no GROUP columns is illegal if there is no GROUP BY clause 5.修改一个表时无法取得同一个表的数据 ERROR 1093 (HY000): You can‟ t specify target table „context‟ for update in FROM clause 6.主键 未自动增长 ERROR 1062 ： 7.int 类型字符过长 com.mysql.jdbc.exceptions.MySQLDataException: ‟ 2.5026744582E10′ in column ‟ 1′ is outside valid range for the datatype INTEGER. 8.没找到错误 没影响数据读取 java.sql.SQLException: Operation not allowed after ResultSet closed 9.类型错误 最常见的是数字类型错误 Data truncated for column „gatheringMoney‟ at row 1 10.换另一个项目时 数据库连接池没换 （未解） Name java: is not bound in this Context 换了之后 似乎还是不行 ===== java:/comp/env/jdbc/ConnSqlSer 前面多了一个‟ /‟ 应为 java:comp/env/jdbc/ConnSqlSer ======= 11.\（未解） java.sql.SQLException: QueryRunner requires a DataSource to be invoked in this way, or a Connection should be passed in 12.executeQuery()方法改成 execute()（未解） Can not issue data manipulation statements with executeQuery(). Can not issue data manipulation statements with executeQuery(). struts 错误 Failed to obtain specified collection 下拉框没值 警告: No FormBeanConfig found under „yuanLiaoRuKuForm‟ 配置文件 Form 出错 Cannot find bean: “ org.apache.struts.taglib.html.BEAN” in any scope < html:text >标签外面没有嵌套标签 No getter method for property: “outDate” of...
