JSP和Action类，dao类间的关系details.

最新推荐文章于 2022-08-21 09:40:56 发布

FreedomRoad~

最新推荐文章于 2022-08-21 09:40:56 发布

阅读量318

点赞数 1

分类专栏： SSH 文章标签：开发工具数据库

SSH 专栏收录该内容

32 篇文章 0 订阅

订阅专栏

一、在.jsp中用form传入参数：

<html:form action="/stuUser?method=findCourse">
 <table border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#afdf69" width="100%">
 <tr>
 <td height="28" colspan="4" bordercolor="#FFFFFF" bgcolor="#FFFFFF"> 请输入搜索条件：

 </td>
 </tr>
 <tr>
 <td height="28" bordercolor="#FFFFFF" bgcolor="#FFFFFF" align="center">课程类型：
 <html:select property="courseType">
 <html:option value=""></html:option>
 <html:option value="校选人文">校选人文</html:option>
 <html:option value="校选自然">校选自然</html:option>
 </html:select>
 </td>
 <td height="24" bordercolor="#FFFFFF" bgcolor="#FFFFFF" align="center">有无余量：
 <html:select property="left">
 <html:option value=""></html:option>
 <html:option value="有">有</html:option>
 <html:option value="无">无</html:option>
 </html:select>
 </td>
 <td>上课时间 : <html:select property="week">
 <html:option value=""></html:option>
 <html:option value="周一">周一</html:option>
 <html:option value="周二">周二</html:option>
 <html:option value="周三">周三</html:option>
 <html:option value="周四">周四</html:option>
 <html:option value="周五">周五</html:option>
 <html:option value="周六">周六</html:option>
 <html:option value="周日">周日</html:option>
 </html:select>
 <html:select property="time">
 <html:option value=""></html:option>
 <html:option value="第1,2,3节">第1,2,3节</html:option>
 <html:option value="第4,5节">第4,5节</html:option>
 <html:option value="第6,7,8节">第6,7,8节</html:option>
 <html:option value="第10,11,12节">第10,11,12节</html:option>
 </html:select>
 </td>

 <td height="24" bordercolor="#FFFFFF" bgcolor="#FFFFFF" align="center"><html:submit value="搜索"/></td>
 </tr>
 </table>
 </html:form>

二、在Action类中读取参数调用dao操作数据库方法或业务逻辑处理：

public ActionForward findCourse(ActionMapping mapping,ActionForm form,//用form作为一个传递参数set.
 HttpServletRequest request, HttpServletResponse response) {

 DynaActionForm courseForm = (DynaActionForm) form;
 String courseType = courseForm.getString("courseType");
 String left = courseForm.getString("left");
 String week = courseForm.getString("week");
 String time = courseForm.getString("time");

 Map<String,String> map = new HashMap<String,String>();

 map.put("courseType", courseType);
 map.put("left", left);
 map.put("week", week);
 map.put("time", time);

 List<Course> list = courseDao.findBySearch(map) ;//调用点，为dao类方法
 Iterator it = list.iterator();
 int number = 0;
 while(it.hasNext()){
 it.next();
 number++;
 }
 request.setAttribute("list", list);//和后面的迭代设置list
 request.setAttribute("number", number);
 return findSch(mapping, form, request, response) ;//调用点，为action类中方法
 }

三、findBySearch在dao类中处理

public List<Course> findBySearch(Map<String,String> map) {///根据map中的条件查找

 List<Course> list=null;
 String courseType=map.get("courseType");
 String remain = map.get("left");
 String week = map.get("week");
 String time = map.get("time");
 if(!courseType.equals("")){
 String sql="FROM Course WHERE ";
 sql += " courseType ="+"'"+courseType+"'";
 if(remain.equals("")||remain.equals("有")){//courseType不为空，remain不为空
 sql += " AND remain > 0";
 }
 if(remain.equals("无")){
 sql += " AND remain = 0";
 }
 if(!week.equals("")){
 sql += " AND week ="+"'"+week+"'";
 }
 if(!time.equals("")){
 sql += " AND time ="+"'"+time+"'";
 }
 list = getHibernateTemplate().find(sql);
 return list;
 }
 if(courseType.equals("")){
 String sql="FROM Course WHERE courseType IN ('校选人文','校选自然') ";
 if(remain.equals("")||remain.equals("有")){courseType不为空，remain不为空
 sql += " AND remain > 0";
 }else if(remain.equals("无")){
 sql += " AND remain = 0";
 }
 if(!week.equals("")){
 sql += " AND week ="+"'"+week+"'";
 }
 if(!time.equals("")){
 sql += " AND time ="+"'"+time+"'";
 }
 list = getHibernateTemplate().find(sql);
 return list;
 }
 else{
 list=list = getHibernateTemplate().find("FROM Course");
 return list;

 }
 }

四、在同一个Action类中调用处理：

public ActionForward findSch (ActionMapping mapping, ActionForm form,///找出可选的和已选的校选课
 HttpServletRequest request, HttpServletResponse response) {

 int stuId = (Integer)request.getSession().getAttribute("loginId");/学生序号
 Map map = stuUserDao.findSchCourse(); //dao类调用点
 List<Course> list = (List)map.get("list");//查询学生可选的校选课程
 int number = (Integer)map.get("number");
 List<Course> clist = stuUserDao.findSelectedSch(stuId);/ ///查询学生所选校选课程，dao类调用点

 if(request.getAttribute("list")==null){
 request.setAttribute("list", list);//关键的返回值设置，使得在jsp中可以直接用${list.成员}将其取得值
 request.setAttribute("number", number);
 }
 request.setAttribute("clist", clist); //关键的返回值设置
 return mapping.findForward("selectSch");//关键的 转到选择校选课页面，也就是取list,clist的页面
 }

public List<Course> findSelectedSch (int stuId){根据学生编号查找已选的校选修课程

 Query q = getSession().createQuery("FROM Course WHERE id IN(SELECT courseId FROM StuCourse WHERE stuId=?) AND courseType IN('校选人文','校选自然')");
 q.setInteger(0, stuId);
 List<Course> list = q.list() ;
 System.out.println("查询出学生已选的课程");
 return list;
 }

五、再调用了stuUserDao类：

public Map<String,Object> findSchCourse (){//查出学生可选的校选课

 Map map =new HashMap();
 String sql = "FROM Course WHERE courseType IN('校选人文','校选自然') AND remain>0 AND selective='可选'";
 List<Course> list = getHibernateTemplate().find(sql);
 map.put("list", list);
 Iterator it = list.iterator();
 int i=0;
 while(it.hasNext()){
 it.next();
 i++;
 }
 map.put("number", i);
 return map;
 }

六、返回到.jsp

1.<html:form action="/stuUser.do?method=insertSch">
 <table width="760" align="center" cellspacing="0">
 <tr>
 <td height="30" align="center" > </td>
 <td align="center" >课程名称</td>
 <td align="center" >课程安排</td>
 <td align="center" >上课时间</td>
 <td align="center" >上课地点</td>
 <td align="center" >授课教师</td>
 <td align="center" >课程学分</td>
 <td align="center" >课程类型</td>
 <td align="center" >总量</td>
 <td align="center" >余额</td>
 <td align="center" >是否可选</td>
 </tr>
 <%int i=0;%>
 <logic:iterate id="list" name="list">
 <%i++;request.setAttribute("nt",i); %>
 <tr>
 <td height="30" valign="middle">
 <html:checkbox property="id" value="${list.id}" οnclick="validate(${requestScope.nt})"></html:checkbox>
 </td>
 <td valign="middle" bgcolor="#ffffff">${list.courseName}</td>
 <td valign="middle" bgcolor="#ffffff">第${list.startTime}-${list.finishTime}周</td>
 <td valign="middle" bgcolor="#ffffff">${list.week}${list.time}</td>
 <td valign="middle" bgcolor="#ffffff">${list.courseAddr}</td>
 <td valign="middle" bgcolor="#ffffff">${list.courseTch}</td>
 <td valign="middle" bgcolor="#ffffff">${list.courseCredit}</td>
 <td valign="middle" bgcolor="#ffffff">${list.courseType}</td>
 <td valign="middle" bgcolor="#ffffff">${list.total}</td>
 <td valign="middle" bgcolor="#ffffff">${list.remain}</td>
 <td valign="middle" bgcolor="#ffffff">${list.selective}</td>
 </tr>
 </logic:iterate>
 <tr>
 <td align="left"> <html:submit>提交</html:submit></td>
 </tr>
 </table>
 </html:form>
 2.<table width="780" align="center" cellspacing="0">
 <tr>
 <td>已选课程</td>
 </tr>
 <tr>

 <td >课程名称</td>
 <td >课程安排</td>
 <td >上课时间</td>
 <td >上课地点</td>
 <td >授课教师</td>
 <td >课程学分</td>
 <td >课程类型</td>
 <td >总量</td>
 <td >余额</td>
 <td >是否可选</td>
 </tr>
 <c:if test="${!empty clist}">
 <logic:iterate id="clist" name="clist">
 <tr>

 <td valign="middle" bgcolor="#ffffff">${clist.courseName}</td>
 <td valign="middle" bgcolor="#ffffff">第${clist.startTime}-${clist.finishTime}周</td>
 <td valign="middle" bgcolor="#ffffff">${clist.week}${clist.time}</td>
 <td valign="middle" bgcolor="#ffffff">${clist.courseAddr}</td>
 <td valign="middle" bgcolor="#ffffff">${clist.courseTch}</td>
 <td valign="middle" bgcolor="#ffffff">${clist.courseCredit}</td>
 <td valign="middle" bgcolor="#ffffff">${clist.courseType}</td>
 <td valign="middle" bgcolor="#ffffff">${clist.total}</td>
 <td valign="middle" bgcolor="#ffffff">${clist.remain}</td>
 <td valign="middle" bgcolor="#ffffff">已选</td>
 <td >
 <html:link page="/stuUser.do?method=dropCourse"
 paramId="id" paramName="clist" paramProperty="id">退选</html:link>
 </td>
 </tr>
 </logic:iterate>
 </c:if>

<tr>
 <td height="85" colspan="2" align="center" background="images/bottomU.gif"> </td>
</tr>
</table>

FreedomRoad~

关注

1
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
JSP和Action类，dao类间的关系details.

一、在.jsp中用form传入参数：&lt;html:form action="/stuUser?method=findCourse"&gt; &lt;table border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#afdf69" width=&q
复制链接

扫一扫

专栏目录