求老师帮帮忙这个问题要怎么解决呢,,
这里是我写的:
// SQL生成
StringBuilder sb = new StringBuilder();
sb.append(" INSERT INTO workers_user ( ");
sb.append(" company_cd, user_id, last_name, first_name, ordnum, datenum,telphonenum,sex ");
sb.append(" , zip_no, address01, address02, address03, address04, jk, jobaddress,ydtime ");
sb.append(" ,sjtime, sxtime, timemoney, jmoney, zmoney");
sb.append(" , create_date, create_company_cd, create_user_id, update_date, update_company_cd, update_user_id) ");
sb.append(" VALUES (?, ?, ?, ?, ?, ? ,?,?");
sb.append(" , ?, ?, ?, ?, ?, ?, ?, ? ");
sb.append(" , ?, ?, ?, ?, ?");
sb.append(" , ?, ?, ?, ?, ?, ?) ");
然后显示的错误是 : org.postgresql.util.PSQLException: 错误: 在字段 "jmoney" 中空值违反了非空约束
还是有一个问题是 org.postgresql.util.PSQLException: 栏位索引超过许可范围:27,栏位数:26。
这两个问题要怎么解决啊,,,求老师指导