public int create$($Employee employee$)\{$ int id $=$ ; try $\{$ String query $=$ "INSERT INTO employee $($badgeid$,$ firstname, middlename, lastname, employeetypeid, departmentid, shiftid, active, inactive$)$ VALUES $(?,?,?,?,?,?,?,?,?)"$; PreparedStatement ps $=$ conn.prepareStatement$($query$,$ PreparedStatement.RETURN$\_$GENERATED$\_$KEYS$)$; ps$.(,$ employee.getBadgeid$())$; ps$.(,$ employee.getFirstname$())$; ps$.(,$ employee.getMiddlename$())$; ps$.(,$ employee.getLastname$())$; ps$.(,$ employee.getEmployeetypeid$())$; ps$.(,$ employee.getDepartmentid$())$; ps$.(,$ employee.getShiftid$())$; ps$.(,$ java.sql$.$Date.valueOf$($employee$.$getActive$()))$; if $($employee$.$getInactive$()!=$ null$)$ ps$.(,$ java.sql$.$Date.valueOf$($employee$.$getInactive$()))$; else ps$.(,)$; int rows $=$ ps$.$executeUpdate$()$; if $($rows $==)\{$ ResultSet keys $=$ ps$.$getGeneratedKeys$()$; if $($keys$.$next$())\{$ id $=$ keys.getInt$()$; $\}\}\}$ catch $($Exception e$)\{$ e$.$printStackTrace$()$; $\}$ return id;$\}$