ooad - OO design and hibernate -


i have tried model job portal use case in class diagram below. have made skill entity shareable both job job seeker hoping reuse.

i have revised oo design since sharing skill suppose means m:n relation instead of 1:n.

questions:

how can below things using hibernate ? need resort sql ?

  1. since skill has m:n relation need association table jobskill , seekerskill. how create job or seeker instance use existing skill in database ?
  2. i need skill matching such job skill requirement subset of candidate skills for:
    a) employer e1: find candidates - 1{job + 1{candidate}n }n
    b) candidate c1: find jobs - 1{job + employer }n

i thinking add business service class case jobportal methods below pseudo code. if 1 can answer hql query needed method findjobsforseeker:

public class jobportal { public int createemployer(string name, address address) { employer e = null; hbutil.create(e = new employer(name, address)); return e.getid(); } public void addjobtoemployer(int empid, string jobname, string[][] skills) { employee e = hbutil.get(empid, employee.class); job j = new job(jobname); skill s = null; for(int i=0; i<skills.length; i++) { s = hbutil.find(skills[i][0], skills[i][1], skill.class); if (null == s) { s = new skill(skills[0], interger.parseint(skills[1])); //name, experience } j.add(s); } e.add(j); hbutil.save(e); } public int createseeker(string name) { seeker s = null; dbutil.create(s = new seeker(name)); return s.getid(); } public void addskillstoseeker(int sid, string[][] skills) { seeker seeker = hbutil.get(sid, seeker.class); for(int i=0; i<skills.length; i++) { s = hbutil.find(skills[i][0], skills[i][1], skill.class); if (null == s) { s = new skill(skills[0], interger.parseint(skills[1])); //name, experience } seeker.add(s); } hbutil.save(seeker); } public void findjobsforseeker(int sid) { //what hql use ? } }

to answer first question: search skills want attach new job or seeker (with hql query). once have found skills, add them collection of skills of new job or seeker:

list<skill> skills = session.createquery("select skill skill skill ...") .list(); (skill skill : skills) { newjob.addskill(skill); }

i don't understand syntax used in second question. if want find seekers have skills in given set of skills:

select seeker seeker seeker not exists ( select skill.id skill skill skill in (:skillset) , skill.id not in (select skill2.id seeker seeker2 inner join seeker2.skills skill2 seeker2 = seeker))

Comments

Post a Comment

Popular posts from this blog

javascript - backbone.js Collection.add() doesn't `construct` (`initialize`) an object -

<!doctype html public "-//w3c//dtd xhtml 1.0 strict//en" "http://www.w3.org/tr/xhtml1/dtd/xhtml1-strict.dtd"> <html> <head> <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.7.2/jquery.min.js"></script> <script src="http://documentcloud.github.com/underscore/underscore-min.js"></script> <script src="http://documentcloud.github.com/backbone/backbone-min.js"></script> </head> <body> <button id="cmd_create_event" name="cmd_create_event" type="button">create new `event`</button> <script type="text/javascript"> var eventmodel = backbone.model.extend({ initialize : function() { console.log("`event` initialized. id: " + this.cid); this.bind("change:status", function() { console.log(this.get("status") + " value `status`"); }); this.bind("error", function(model, e...
Read more

php - Get uncommon values from two or more arrays -

is there function in php give array of uncommon values 2 or more arrays? for example: $array1 = array( "green", "red", "blue"); $array2 = array( "green", "yellow", "red"); .... $result = function_needed($array1, $array2,...); print_r($result); should give output: array("blue", "yellow", ...); use array_diff , array_merge : $result = array_merge(array_diff($array1, $array2), array_diff($array2, $array1)); here's demo. for multiple arrays, combine callback , array_reduce : function unique(&$a, $b) { return $a ? array_merge(array_diff($a, $b), array_diff($b, $a)) : $b; } $arrays = array( array('green', 'red', 'blue'), array('green', 'yellow', 'red') ); $result = array_reduce($arrays, 'unique'); and here's demo of that.
Read more

Adding duplicate array rows in Php -

i create function in php adds rows of array shared column value. so input. $test = array( array("c", 5, 6), array("c", 2, 3), array("test", 5, 6) ); and output. $testduplicatefree = array( array("c", 7, 9), array("test", 5, 6) ) ); i'm thinking function combine_duplicates($array,$col){ ... ... return $duplicatefreearray; } where $col duplicate free array. so, in case, combine_duplicates($test,0); would me desired output. this. <?php function combine_duplicates($array,$col) { $index = array(); foreach ($array $row) { $key = $row[$col]; if (!isset($index[$key])) { $index[$key] = $row; } else { ($i = 0; $i < count($row); ++$i) { if ($i != $col) { $index[$key][$i] += $row[$i]; } } } } return array_values($index); } $array = array( array("c", 5, 6), array("c", 2, 3), array("test", 5, 6) ); print_r(combine_duplicates($array, 0)); try here: http://codepad.org/mdhesqhi
Read more