cxf 开发web services 利用spring 集成了hibernate

package com.dx.test; import java.io.UnsupportedEncodingException; import java.util.Date; import java.util.List; import java.util.Random; import javassist.expr.NewArray; import org.junit.Test; import org.springframework.context.ApplicationContext; import org.springframework.context.support.ClassPathXmlApplicationContext; import com.dx.dao.BaseDao; import com.dx.model.Course; import com.dx.model.Produ; import com.dx.model.Score; import com.dx.model.Student; import com.dx.model.Teacher; import com.dx.model.User; import com.dx.service.IHelloService; public class DxTest { @Test public void test_010(){ ApplicationContext context = new ClassPathXmlApplicationContext("context/applicationContext-*.xml"); } @Test public void test_020(){ System.out.println(); } @Test public void testSave_010(){ IHelloService service = (IHelloService) getBean("hellos"); User user = new User(); user.setName("杨钰莹12"); service.add(user); System.out.println(new Date().toLocaleString()); } @Test public void testGet_010(){ BaseDao baseDao = (BaseDao) getBean("baseDao"); System.out.println(new Date().toLocaleString()); User user = null; user = baseDao.get(User.class, 1); System.out.println(user.getName()); User user2 = baseDao.get(User.class, 1); System.out.println(user2.getName()); System.out.println(new Date().toLocaleString()); } private Object getBean(String name){ ApplicationContext context = new ClassPathXmlApplicationContext("context/applicationContext-*.xml"); return context.getBean(name); } @Test public void testUpdate(){ BaseDao baseDao = (BaseDao) getBean("baseDao"); Student student = new Student(); Teacher teacher = new Teacher(); Score score = new Score(); Course course = new Course(); Random random = new Random(); course = baseDao.get(Course.class, 2); for (int i = 11; i <= 15; i++) { score = baseDao.get(Score.class, i); score.setCourse(course); baseDao.update(score); } } @Test public void testQuery(){ //查询选择1号课程比2号课程成绩高的学生 /*String sql2 = "select a.id as id,b.score as b_score,a.score as a_score " + "from (select * from dx_score where course_id=1) as a,(select * from dx_score where course_id=2) as b " + "where a.score>b.score and a.student_id=b.student_id";*/ //查询选择1号课程的成绩比平均成绩大的学生 String hql = "select a.student_id,a.score,temp.avg_score " + "from (select avg(score) as avg_score from dx_score where course_id=1) temp,dx_score a " + "where a.score>temp.avg_score"; String sql2 = "select a.student_id,a.score,sc.avg_score " + "from (select avg(score) as avg_score from dx_score group by course_id) as sc,score as a" + "where a..score>sc.avg_score"; //查询平均分大于60的学生号以及平均成绩 String sql3 = "select distinct a.student_id,tm.avg_score " + "from (select student_id,avg(score) as avg_score from dx_score group by student_id) tm,dx_score a " + "where tm.avg_score>60 and a.student_id=tm.student_id"; //查询平均分大于60的学生名称以及平均成绩 String sql4 = "select distinct a.name,tm.avg_score " + "from (select student_id,avg(score) as avg_score from dx_score group by student_id) tm,dx_student a " + "where tm.avg_score>60 and a.id=tm.student_id"; //查询平均分大于60的学生名称以及平均成绩 String sql5 = "select a.name,tm.avg_score " + "from (select student_id,avg(score) as avg_score " + "from dx_score group by student_id " + "having avg(score)>60) tm,dx_student a " + "where a.id=tm.student_id"; BaseDao baseDao = (BaseDao) getBean("baseDao"); System.out.println(new Date().toLocaleString()); List<Object[]> list = (List<Object[]>) baseDao.queryBySql(sql5,0,3); for (Object[] objects : list) { System.out.println(objects[0]+" "+objects[1]); } System.out.println(new Date().toLocaleString()); } @Test public void testQueryByHql(){ String hql2 = "from Produ"; BaseDao baseDao = (BaseDao) getBean("baseDao"); System.out.println(new Date().toLocaleString()); List<Produ> list = (List<Produ>) baseDao.query(hql2); System.out.println(new Date().toLocaleString()); for (Produ score : list) { System.out.println(score.getName()); } /*for (Object[] objects : list) { System.out.println(objects[0]+" "+objects[1]+" "+objects[2]); }*/ } @Test public void testQueryBySql(){ String hql2 = "select id,student_id,course_id,score from dx_score"; String hql3 = "select * from dx_produ"; BaseDao baseDao = (BaseDao) getBean("baseDao"); System.out.println(new Date().toLocaleString()); List<Object[]> list = (List<Object[]>) baseDao.queryBySql(hql3); System.out.println(new Date().toLocaleString()); /*for (Score score : list) { System.out.println(score.getScore()); }*/ for (Object[] objects : list) { System.out.println(objects[0]+" "+objects[1]+" "+objects[2]); } } @Test public void testProcedureQuery(){ BaseDao baseDao = (BaseDao) getBean("baseDao"); System.out.println(new Date().toLocaleString()); List<Object[]> list = (List<Object[]>) baseDao.queryBySql("{call getProduList()}"); System.out.println(new Date().toLocaleString()); /*for (Score score : list) { System.out.println(score.getScore()); }*/ for (Object[] objects : list) { System.out.println(objects[0]+" "+objects[1]+" "+objects[2]); } } }