java基础练习项目--比较乱,仅供自己作为笔记
SelectCourseTeacherServlet.java
package com.aaa.servlet; import java.io.IOException; import java.util.List; import java.util.Map; import javax.servlet.ServletException; import javax.servlet.annotation.WebServlet; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import com.aaa.service.ICourseServerDAO; import com.aaa.service.impl.CourseServerDaoImpl; import com.alibaba.fastjson.JSON; @WebServlet("/SCTS") public class SelectCourseTeacherServlet extends HttpServlet { @Override protected void service(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { // TODO Auto-generated method stub request.setCharacterEncoding("utf-8"); //得到课程编号,查询教课老师 String classnum=request.getParameter("classnum"); String classstatus=request.getParameter("classstatus"); System.out.println("传递递过来的课程编号"+classnum+"传递过来的课程性质"+classstatus); //调用CourseServerDaoImpl创建对象,连接数据库 ICourseServerDAO icsd= new CourseServerDaoImpl(); List<Map<String,Object>> list= icsd.selectcourseteacher(classnum); System.out.println("查询的教师名字结果集"+list); String res=JSON.toJSONString(list); response.setContentType("text/html;charset=utf-8"); response.getWriter().write(res); } }
SelectCourseBySelectedServlet.java
package com.aaa.servlet; import java.io.IOException; import java.util.HashMap; import java.util.List; import java.util.Map; import javax.servlet.ServletException; import javax.servlet.annotation.WebServlet; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import com.aaa.entity.Course; import com.aaa.entity.Teacher; import com.aaa.service.ICourseServerDAO; import com.aaa.service.impl.CourseServerDaoImpl; import com.alibaba.fastjson.JSON; @WebServlet("/SCBSS") public class SelectCourseBySelectedServlet extends HttpServlet { protected void service(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { System.out.println("欢迎来到...............SCDSS...................."); request.setCharacterEncoding("utf-8"); //实例化对象 Course course=new Course(); Teacher teacher=new Teacher(); //获得selectinfo.jsp的传值 String classnum=request.getParameter("classnum"); String classstatus=request.getParameter("classstatus"); String teacherjobnum=request.getParameter("teacherjobnum"); //向实体类写入信息 // int classid=Integer.parseInt(classnum); // int tjobnum=Integer.parseInt(teacherjobnum); // course.setId(classid); // course.setStatus(classstatus); // teacher.setJobnum(tjobnum); System.out.println(classnum+"课程名称 "+classstatus+"课程性质 "+teacherjobnum+"任课老师"); ICourseServerDAO icsd=new CourseServerDaoImpl(); List<Map<String,Object>> list=icsd.selectcoursebytea(classnum, classstatus, teacherjobnum); System.out.println(list); //如果查出来结果就返回结果集,如果没有查出来结果,就返回错误信息给用户 if(list.size()>0&&list!=null) { String s=JSON.toJSONString(list); response.setContentType("text/html;charset=utf-8"); response.getWriter().write(s); }else { Map<String,Object> map=new HashMap<String,Object>(); //返回错误代码 map.put("code", "000000"); String map1=JSON.toJSONString(map); response.setContentType("text/html;charset=utf-8"); response.getWriter().write(map1); } } }
SelectCourseInfoServlet.java
package com.aaa.servlet; import java.io.IOException; import java.util.ArrayList; import java.util.List; import java.util.Map; import javax.servlet.ServletException; import javax.servlet.annotation.WebServlet; import javax.servlet.http.*; import javax.servlet.http.HttpServlet; import com.aaa.entity.Course; import com.aaa.entity.PageBean; import com.aaa.entity.Student; import com.aaa.entity.Teacher; import com.aaa.service.ICourseServerDAO; import com.aaa.service.impl.CourseServerDaoImpl; @WebServlet("/SCIS") public class SelectCourseInfoServlet extends HttpServlet { //查询选课管理页面中下拉列框中的信息 protected void service(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { System.out.println("欢迎bbbbbbbbbbbbbbbbbbbbbbbbbb"); request.setCharacterEncoding("utf-8"); response.setContentType("text/html;charset=uft-8"); Course course=new Course(); Teacher teacher=new Teacher(); Student student=new Student(); //分页查询数据库 String pageC=request.getParameter("pageCode"); System.out.println("当前页数"+pageC); int pageCode=1;//第一次登录默认第一页 if(pageC!=null&&pageC.trim().length()>0) { pageCode=Integer.parseInt(pageC); } int pageSize=5; //调用courseServerDaoImpl获得类对象连接数据库 ICourseServerDAO icsd=new CourseServerDaoImpl(); PageBean bypage=icsd.findByPage(pageCode, pageSize,course,teacher); //下拉列表中的值 //调用方法进行查询课程表中课程名和id List<Map<String,Object>> list=icsd.selectcourseinfo(); //调用方法查询课程表中的课程性质 List<Map<String,Object>> list2=icsd.selectcoursestatusinfo(); System.out.println(list); System.out.println(list2); List<Object> listall=new ArrayList<Object>(); listall.add(list); listall.add(list2); request.setAttribute("list", listall); request.setAttribute("bypage", bypage); request.getRequestDispatcher("/selectclass/selectinfo.jsp").forward(request,response); } }
Selectinfo.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %> <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <% String path = request.getContextPath(); String basePath = request.getScheme() + "://" + request.getServerName() + ":" + request.getServerPort() + path + "/"; %> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <meta name="viewport" content="width=device-width,initial-scale=1.0,user-scalable=no,maximum-scalable=1.0"> <title>Insert title here</title> <link rel="stylesheet" href="<%=basePath%>/css/bootstrap.min.css"> <script type="text/javascript" src="<%=basePath%>/css/jquery-2.1.3.js"></script> <style> .t1:hover{ color:#0D73CB; } </style> <script type="text/javascript"> function ajax(){ var classnum=$("#classname option:selected").val(); var classstatus=$("#classstatus option:selected").val(); //alert(classnum+" "+classstatus); $("#teachername option:gt(0)").remove(); $.ajax({ type:"post", url:"<c:url value='/SCTS'/>", data:{"classnum":classnum,"classstatus":classstatus}, dataType:"json", success:function(backresult,ststus,xmlHttpServlet){ //alert(backresult); $.each(backresult,function(i,res){ $("#teachername").append("<option value="+res.jobnum+">"+res.name+"</option>"); }) }, error:function (XMlHttpServlet,status,errorThrown){ alert("执行错误"); } }); } </script> <script type="text/javascript"> function selectby(){ document.getElementById("divboot").style.visibility="hidden"; //alert("欢迎查询"); var classnum=$("#classname option:selected").val();//课程代码 var classstatus=$("#classstatus option:selected").val();//课程性质 var teacherjobnum=$("#teachername option:selected").val();//教师编号 $.ajax({ type:"post", url:"<c:url value='/SCBSS'/>", data:{"classnum":classnum,"classstatus":classstatus,"teacherjobnum":teacherjobnum}, dataType:"json", success:function(backresult,ststus,xmlHttpServlet){ //alert(backresult); if(backresult.code=="000000"){ alert("请核对课程信息后,进行重新选择"); }else{ var no="人数已满"; var yes="选课"; //得到原页面中table的行数 var alltr=$("#tbody").find("tr").length; //alert("共有"+alltr); //将原页面中的tr删除 for(var i=0;i<alltr;i++){ document.getElementById("tbody").deleteRow(0); } $.each(backresult,function(i,res){ if(res.fixed<res.num){ $("#tbody").append("<tr><td>"+res.code+"</td><td>"+res.cname+"</td><td>"+res.tname+"</td><td>"+res.status+"</td><td>"+res.credit+"</td><td>"+res.num+"</td><td>"+res.fixed+"</td><td><a href='javascript:void(0)' onclick='xuanke(" + res.code + "," + res.jobnum + ")'>"+yes+"</a></td></tr>"); }else{ $("#tbody").append("<tr><td>"+res.code+"</td><td>"+res.cname+"</td><td>"+res.tname+"</td><td>"+res.status+"</td><td>"+res.credit+"</td><td>"+res.num+"</td><td>"+res.fixed+"</td><td>"+no+"</td></tr>"); } }) } }, error:function(XMlHttpServlet,status,errorThrown){ alert("执行错误"); } }) } </script> </head> <body> <h2>选课管理</h2> 课程名称<select id="classname" class="btn btn-default"> <option value="">---请选择课程名称---</option> <c:forEach items="${list[0]}" var="lis"> <option value="${lis.id}">${lis.name}</option> </c:forEach> </select> 课程性质<select id="classstatus" class="btn btn-default" onchange="ajax()"> <option value="">---课程性质---</option> <c:forEach items="${list[1]}" var="lis1"> <option value="${lis1.status}">${lis1.status}</option> </c:forEach> </select> 任课老师<select id="teachername" class="btn btn-default"> <option value="0">---任课老师---</option> </select> <!--<button type="button" name="selected" class="btn btn-primary btn-sm" onclick="selectby()">查询</button> --> <input type="submit" name="selected" class="btn btn-primary btn-sm" onclick="selectby()" value="查询"/> <table class="table table-striped"> <!-- 设置表格斑马线 --> <thead> <!-- 下面都能改 --> <tr> <th>课程编码</th> <th>课程名称</th> <th>任课老师</th> <th>课程性质</th> <th>学分</th> <th>容量</th> <th>已选人数</th> <th>操作</th> </tr> </thead> <tbody id="tbody"> <c:forEach items="${bypage.queryLists}" var="course"> <tr class="t1"> <td>${course.code}</td> <td>${course.cname}</td> <td>${course.tname}</td> <td>${course.status}</td> <td>${course.credit}</td> <td>${course.num}</td> <td>${course.fixed}</td> <c:choose> <c:when test="${course.num>course.fixed}"> <td><a href="<c:url value="/ISCS?c_code=${course.code}&t_jobnum=${course.jobnum}"/>">选课</a></td> </c:when> <c:otherwise> <td>人数已满</td> </c:otherwise> </c:choose> </tr> </c:forEach> <c:choose> <c:when test="${success==000000}"> <!-- <p style="color:red; margin-left:1600px;">选课成功,请等待审核</p> --> <script> alert("选课成功,请等待审核"); </script> </c:when> <c:when test="${success==111111}"> <!--<p style="color:red; margin-left:1600px;">已经选过该课程,请重新选择</p> --> <script> alert("已经选过该课程,请重新选择"); </script> </c:when> </c:choose> </tbody> </table> <div id="divboot" style="visibility:none"> <ul class="pagination"> <!-- disabled不可用 active变色 --> <li class="disabled"><a href="#">第${bypage.pageCode}页</a></li> <li class="disabled"><a href="#">共${bypage.totalPage}页</a></li> <li ><a href="<c:url value="/SCIS?pageCode=1"/>">首页</a></li> <li > <c:if test="${bypage.pageCode>1}"> <a href="<c:url value='/SCIS?pageCode=${bypage.pageCode-1}'/>">上一页</a> </c:if> </li> <li > <c:if test="${bypage.pageCode<bypage.totalPage}"> <a href="<c:url value="/SCIS?pageCode=${bypage.pageCode+1}"/>">下一页</a> </c:if> </li> <li ><a href="<c:url value="/SCIS?pageCode=${bypage.totalPage}"/>">尾页</a></li> </ul> </div> </body> <script> function xuanke( code, jobnum){ var code1=code; var jobnum1=jobnum; //alert(code1); //alert(jobnum1); window.location.href="/courseProject/ISCS?c_code="+code1+"&t_jobnum="+jobnum1+""; } </script> </html>
selectresult.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %> <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <% String path = request.getContextPath(); String basePath = request.getScheme() + "://" + request.getServerName() + ":" + request.getServerPort() + path + "/"; %> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <meta name="viewport" content="width=device-width,initial-scale=1.0,user-scalable=no,maximum-scalable=1.0"> <title>Insert title here</title> <link rel="stylesheet" href="<%=basePath%>/css/bootstrap.min.css"> <script src="https://cdn.staticfile.org/jquery/2.1.1/jquery.min.js"></script> <script type="text/javascript" src="<%=basePath%>/css/jquery-2.1.3.js"></script> <style> .t1:hover{ color:#0D73CB; } </style> </head> <body> <h2>选课状态展示</h2> <form action="<c:url value="/SRS"/>" method="get"> 课程名称<select id="classcode" name="classcode" class="btn btn-default"> <option value="0">-------课程名称------</option> <c:forEach items="${resultlist[0]}" var="list1"> <option value="${list1.code}">${list1.name}</option> </c:forEach> </select> 课程性质<select id="classstatus" name="classstatus" class="btn btn-default"> <option value="">------课程性质------</option> <c:forEach items="${resultlist[1]}" var="list2"> <option value="${list2.status}">${list2.status}</option> </c:forEach> </select> 任课老师<select id="teacherjobnum" name="teacherjobnum" class="btn btn-default"> <option value="">-----教师姓名-----</option> <c:forEach items="${resultlist[2]}" var="list3"> <option value="${list3.jobnum}">${list3.name}</option> </c:forEach> </select> <button type="submit" class="btn btn-primary btn-sm">查询</button> </form> <table class="table table-striped"> <!-- 设置表格斑马线 --> <thead> <!-- 下面都能改 --> <tr> <th>课程编码</th> <th>课程名称</th> <th>任课老师</th> <th>课程性质</th> <th>学分</th> <th>容量</th> <th>已选人数</th> <th>状态</th> <th>备注</th> </tr> </thead> <tbody> <c:forEach items="${resultlist[3].queryLists}" var="list4"> <tr class="t1"> <td>${list4.code}</td> <td>${list4.cname}</td> <td>${list4.tname}</td> <td>${list4.status}</td> <td>${list4.credit}</td> <td>${list4.num}</td> <td>${list4.fixed}</td> <c:if test="${list4.state==0}"> <td>待审核</td> </c:if> <c:if test="${list4.state==1}"> <td style="color:blue">通过</td> </c:if> <c:if test="${list4.state==2}"> <td style="color:red">未通过</td> </c:if> <td>${list4.comment}</td> </tr> </c:forEach> </tbody> </table> <ul class="pagination"> <!-- disabled不可用 active变色 --> <li class="disabled"><a href="#">第${resultlist[3].pageCode}页</a></li> <li class="disabled"><a href="#">共${resultlist[3].totalPage}页</a></li> <li ><a href="<c:url value="/SRS?pageCode=1"/>">首页</a></li> <li > <c:if test="${resultlist[3].pageCode>1}"> <a href="<c:url value="/SRS?pageCode=${resultlist[3].pageCode-1}"/>">上一页</a> </c:if> </li> <li > <c:if test="${resultlist[3].pageCode<resultlist[3].totalPage}"> <a href="<c:url value="/SRS?pageCode=${resultlist[3].pageCode+1}"/>">下一页</a> </c:if> </li> <li ><a href="<c:url value="/SRS?pageCode=${resultlist[3].totalPage}"/>">尾页</a></li> </ul> </body> </html>