public void addAccount(Account account) throws DAOException { if (account == null) { return; } String sql = "insert into account values(seq_account.nextval,?,?,?,'1',sysdate,?,?,?,?,?,?,?,?,?,?,?,?,?,?)"; Connection conn = DBUtil.getConnection(); try { conn.setAutoCommit(false); PreparedStatement pstmt = conn.prepareStatement(sql); pstmt.setObject(1, account.getRecommenderId()); pstmt.setObject(2, account.getLoginName()); pstmt.setObject(3, account.getLoginPassword()); pstmt.setObject(4, account.getPauseDate()); pstmt.setObject(5, account.getCloseDate()); pstmt.setObject(6, account.getRealName()); pstmt.setObject(7, account.getIdcardNo()); pstmt.setObject(8, account.getBirthdate()); pstmt.setObject(9, account.getGender()); pstmt.setObject(10, account.getOccupation()); pstmt.setObject(11, account.getTelephone()); pstmt.setObject(12, account.getEmail()); pstmt.setObject(13, account.getMailaddress()); pstmt.setObject(14, account.getZipcode()); pstmt.setObject(15, account.getQq()); pstmt.setObject(16, account.getLastLoginTime()); pstmt.setObject(17, account.getLastLoginIp()); pstmt.executeUpdate(); conn.commit(); } catch (SQLException e) { try { conn.rollback(); } catch (SQLException e1) { // TODO Auto-generated catch block e1.printStackTrace(); } e.printStackTrace(); throw new DAOException("账务账号插入失败!", e); } }