多表连接处理查询结果.docxVIP

要查询的数据存在在多个表中，需要使用这些数据，有三种方式获取（一对多）需要在一个实体类中封装另一个实体类的实体变量，（eg:list另一个实体类）通过表连接一次性查询所有数据通过list集合获取public ListUser queryTeacher() {//查询教师的信息Connection conn = JdbcUtilConf.getConnection();PreparedStatement pstm = null;ResultSet rs = null;String sql = select t1.user_id,t1.username,t1.password,t1.realname,t1.department,t1.role,c.course_id,c.course_name from (select * from t_user u inner join course_user cu on u.user_id = cu.u_id) t1 inner join t_course c on t1.c_id=c.course_id;ListCourse listcourse = null;ListUser listuser = new ArrayListUser();User user = null;try {pstm = conn.prepareStatement(sql);rs = pstm.executeQuery();Course c = null;while(rs.next()){Integer cid = rs.getInt(course_id);String course = rs.getString(course_name);c = new Course(cid,course);if(!listuser.isEmpty()){for(int i =0;ilistuser.size();i++){user = listuser.get(i);if(user.getUserId()==rs.getInt(user_id)){for(int j =0;juser.getListcourse().size();j++){if(user.getListcourse().get(j).getCourseId()!=cidj==user.getListcourse().size()-1)user.getListcourse().add(c);}}else{if(i==listuser.size()-1){listcourse = new ArrayListCourse();listcourse.add(c);user = new User(rs.getInt(user_id),rs.getString(username),rs.getString(password),rs.getString(realname),rs.getString(department),rs.getString(role),listcourse);listuser.add(user);}}}}else{listcourse = new ArrayListCourse();listcourse.add(c);user = new User(rs.getInt(user_id), rs.getString(username),rs.getString(password),rs.getString(realname),rs.getString(department),rs.getString(role),listcourse);listuser.add(user);}}} catch (SQLException e) {System.out.println(异常位置和信息为 +e.getMessage());e.printStackTrace();}finally{JdbcUtilConf.release(rs, pstm, conn);}return listuser;}通过map集合获取public ListUser findALLCourseAndTeacher() throws Exception {Connection conn = null;PreparedStatement pstm = null;ResultSet rs = null;ListUser list = new ArrayListUser();MapString,User map = new HashMapString,User();try {conn=JdbcUtil.getConn();String sql=select * from t_us