ما کردیم شد
این تغییرات رو من روی entity ها دادم و کار می کنه هم entity رو برات می زارم هم کد نوشته شده هم تست
@Entity
@Table(name = "question", schema = "babak")
public class Question implements Serializable{
@Id
@GeneratedValue(strategy = GenerationType.AUTO)
private Integer id;
private String question;
@OneToMany(cascade = CascadeType.ALL ,fetch = FetchType.LAZY,mappedBy = "question")
private List<Answer> answerList;
public Question() {
}
public Integer getId() {
return id;
}
public void setId(Integer id) {
this.id = id;
}
public String getQuestion() {
return question;
}
public void setQuestion(String question) {
this.question = question;
}
public List<Answer> getAnswerList() {
return answerList;
}
public void setAnswerList(List<Answer> answerList) {
this.answerList = answerList;
}
}
@Entity
@Table(name = "answer", schema = "babak")
public class Answer implements Serializable {
@Id
@GeneratedValue(strategy = GenerationType.AUTO)
private Integer id;
private String correctAnswer;
private String wrongAnswerOne;
private String wrongAnswerTwo;
private String wrongAnswerThree;
@ManyToOne(cascade = CascadeType.ALL, fetch = FetchType.LAZY)
@JoinColumn(name = "fk_question",referencedColumnName = "id")
private Question question;
public Answer() {
}
public Integer getId() {
return id;
}
public void setId(Integer id) {
this.id = id;
}
public String getCorrectAnswer() {
return correctAnswer;
}
public void setCorrectAnswer(String correctAnswer) {
this.correctAnswer = correctAnswer;
}
public String getWrongAnswerOne() {
return wrongAnswerOne;
}
public void setWrongAnswerOne(String wrongAnswerOne) {
this.wrongAnswerOne = wrongAnswerOne;
}
public String getWrongAnswerTwo() {
return wrongAnswerTwo;
}
public void setWrongAnswerTwo(String wrongAnswerTwo) {
this.wrongAnswerTwo = wrongAnswerTwo;
}
public String getWrongAnswerThree() {
return wrongAnswerThree;
}
public void setWrongAnswerThree(String wrongAnswerThree) {
this.wrongAnswerThree = wrongAnswerThree;
}
public Question getQuestion() {
return question;
}
public void setQuestion(Question question) {
this.question = question;
}
}
لایه dao
public class CommonDao {
@PersistenceContext(unitName = "myTest")
private EntityManager em;
public Question getAnswersByQuestionId(Integer questionId) throws Exception {
Query query = em.createQuery("select q From Question as q where q.id = :id");
query.setParameter("id", questionId);
return (Question) query.getSingleResult();
}
}
لایه business
public class MyBiz {
@Autowired
@Qualifier("commonDao")
private CommonDao commonDao;
@Transactional
public List<Answer> getAnswersByQuestionId(Integer questionId) throws Exception {
Question question = commonDao.getAnswersByQuestionId(questionId);
if(question == null) throw new Exception();
ArrayList<Answer> answers = new ArrayList<Answer>();
for(Answer answer : question.getAnswerList()) {
answers.add(answer);
}
return answers;
}
}
تست انجام گرفته با فرض اینکه قبلا یک رکورد هم برای question وهم برای answer وجود داره
@ContextConfiguration
@RunWith(SpringJUnit4ClassRunner.class)
@Transactional
public class MyBizTest {
@Autowired
private MyBiz myBiz;
@Autowired
private CommonDao commonDao;
@Test
public void testAnswerByQuestionId() throws Exception {
List<Answer> answers = this.myBiz.getAnswersByQuestionId(1);
int result = answers.size();
Assert.assertEquals(1, result);
for (Answer answer : answers) {
Assert.assertEquals("Yes I am",answer.getWrongAnswerOne());
Assert.assertEquals("Maybe",answer.getWrongAnswerThree());
Assert.assertEquals("One day",answer.getWrongAnswerTwo());
Assert.assertEquals("No I am not",answer.getCorrectAnswer());
}
}
}