public void add(GenericVO vo) throws AppException, SysException { StaffWorkAreaSVO staffWorkArea = (StaffWorkAreaSVO) vo; StringBuffer sql = new StringBuffer("insert into"); sql.append( " STAFF_WORK_AREA(STAFF_WORK_AREA_ID,STAFF_ID,WORK_AREA_ID,GRANTOR,ADMIN_FLAG,STS,STS_DATE,CREATE_DATE) values(?,?,?,?,?,?,?,?)"); Connection connection = null; PreparedStatement ps = null; try { connection = ConnectionFactory.getConnection(); ps = connection.prepareStatement(sql.toString()); ps.setString(1, staffWorkArea.getStaffWorkAreaId()); ps.setString(2, staffWorkArea.getStaffId()); ps.setString(3, staffWorkArea.getWorkAreaId()); ps.setString(4, staffWorkArea.getGrantor()); ps.setString(5, staffWorkArea.getAdminFlag()); ps.setString(6, staffWorkArea.getSts()); ps.setDate(7, staffWorkArea.getStsDate()); ps.setDate(8, staffWorkArea.getCreateDate()); ps.execute(); connection.commit(); } catch (SQLException e) { throw new SysException("", "add error..", e); } finally { try { if (ps != null) { ps.close(); } } catch (SQLException e) { } } }