高校学生在线选课系统（java）

package com.action; import java.io.IOException; import java.util.ArrayList; import java.util.List; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import javax.servlet.http.HttpSession; //import org.apache.commons.beanutils.BeanUtils; import net.sf.json.JSONObject; import org.apache.struts.action.ActionServlet; import com.bean.Student; import org.apache.struts2.ServletActionContext; import com.opensymphony.xwork2.ActionSupport; import com.service.StudentService; public class StudentAction extends ActionSupport { private StudentService service; private String sname; private String sex; private String birthday; private String pid; private String cname; private String password; private String national; private String susername; private String origin; //查询 private String sname1; private String pid1; private String sex1; public String delete() { HttpServletResponse response=ServletActionContext.getResponse(); HttpServletRequest request=ServletActionContext.getRequest(); response.setContentType("text/json;charset=UTF-8"); String cid=request.getParameter("cid"); Student student=(Student)service.findById(Integer.valueOf(cid)); if(student!=null) { service.deleteStudent(student); } try { response.getWriter().println("y"); } catch (IOException e) { // TODO Auto-generated catch block e.printStackTrace(); } return null; } public String fetch() { HttpServletResponse response=ServletActionContext.getResponse(); HttpServletRequest request=ServletActionContext.getRequest(); response.setContentType("text/html;charset=UTF-8"); String cid=request.getParameter("cid"); Student s1=(Student)service.findById(Integer.valueOf(cid)); if(s1!=null) { Student s2=new Student(); s2.setBirthday(s1.getBirthday()); s2.setOrigin(s1.getOrigin()); s2.setPassword(s1.getPassword()); s2.setPid(s1.getPid()); s2.setSex(s1.getSex() ); s2.setSid(s1.getSid()); s2.setSname(s1.getSname()); s2.setSnational(s1.getSnational()); s2.setCname(s1.getCname()); s2.setUsername(s1.getUsername()); String _m = JSONObject.fromObject(s2).toString(); try { response.getWriter().println(_m); } catch (IOException e) { // TODO Auto-generated catch block e.printStackTrace(); } } return null; } public String nextGet() { HttpServletRequest request=ServletActionContext.getRequest(); int currPage=1; String curr_page=request.getParameter("currPage"); System.out.println("curr_page: "+curr_page); int totalPage=countPage(); if(curr_page==null||curr_page.length()<1) curr_page="1"; currPage=Integer.parseInt(curr_page); request.setAttribute("currPage", new Integer(currPage)); request.setAttribute("totalPage", new Integer(totalPage)); request.setAttribute("previous", new Integer((currPage>1)?currPage-1:1)); request.setAttribute("next", new Integer((currPage<totalPage)?currPage+1:totalPage)); System.out.println("currPage="+currPage); System.out.println("totalPage="+totalPage); System.out.println("previous="+new Integer((currPage>1)?currPage-1:1)); System.out.println("next="+new Integer((currPage<totalPage)?currPage+1:totalPage)); HttpSession session=request.getSession(); String hql=(String)session.getAttribute("hql"); List mlist=service.listStudent(currPage, 10,hql); request.setAttribute("mlist", mlist); return this.SUCCESS; } public String get(){ HttpServletRequest request=ServletActionContext.getRequest(); StringBuffer hql = new StringBuffer(); hql.append(" From Student ad where 1=1"); if(sname1!=null&&sname1.length()>=1) { /*hql.append(" and ad.cname like ?"); params.add("%"+scname+"%"); hql=hql+" and ad.cname like '"+cname+"%'"; */ hql.append(" and ad.sname like '%"+sname1+"%' "); } if(sex1!=null&&sex1.length()>=1) { /* hql.append(" and ad.tname like ?"); params.add("%"+stname+"%"); */ hql.append(" and ad.sex like '%"+sex1+"%' "); } if(pid1!=null&&pid1.length()>=1) { hql.append(" and ad.pid like '%"+pid1+"%' "); } HttpSession session=request.getSession(); session.setAttribute("hql", hql.toString()); int totalPage=countPage(); List mlist=service.getStudent(hql.toString()); request.setAttribute("currPage", "1"); request.setAttribute("previous", "1"); request.setAttribute("next", new Integer((1<totalPage)?2:totalPage)); request.setAttribute("totalPage", String.valueOf(totalPage)); request.setAttribute("mlist", mlist); return this.SUCCESS; } public String save() throws Exception { System.out.println("save~~~~~~~~~"); HttpServletRequest request=ServletActionContext.getRequest(); String flag=request.getParameter("flag"); if("".equals(flag)||flag==null) { Student student=new Student(); student.setSname(sname); student.setSex(sex); student.setBirthday(birthday); student.setPid(pid); student.setCname(cname); // student.setTname(tname); student.setPassword(password); student.setSnational(national); student.setOrigin(origin); student.setUsername(susername); service.save(student); } if("update".equals(flag)) { String cid=request.getParameter("cid"); Student student=(Student)service.findById(Integer.valueOf(cid)); if(student!=null) { //BeanUtils.copyProperties(clazz, memberForm); student.setSname(sname); student.setSex(sex); student.setBirthday(birthday); student.setPid(pid); student.setCname(cname); // student.setTname(tname); student.setPassword(password); student.setSnational(national); student.setOrigin(origin); student.setUsername(susername); service.updateStudent(student); } /*String cid=request.getParameter("cid"); Clazz clazz=(Clazz)dao.findById(Integer.valueOf(cid)); if(clazz!=null) { BeanUtils.copyProperties(clazz, memberForm); dao.update(clazz); }*/ } return this.SUCCESS; } @Override public String execute() throws Exception { /* Manager manager = service.findManagerByName(username); //ActionServlet a=ActionContext. HttpServletRequest request=ServletActionContext.getRequest(); if(manager==null) { request.setAttribute("msg", "0");//不存在用户 return this.INPUT; } else { if(password.equals(manager.getPassword())) { System.out.println("密码对了"); //request.setAttribute("msg", "1"); HttpSession session=request.getSession(); session.setAttribute("username", username); return this.SUCCESS; } else { System.out.println("密码错误了"); request.setAttribute("msg", "1"); return this.INPUT; } } */ System.out.println("~~~~~~~~StudentAction success"); return SUCCESS; } public int countPage() { int count=0; int total=service.count(); int n=total%10; if(n==0) count=total/10; else count=total/10+1; return count; } public StudentService getService() { return service; } public void setService(StudentService service) { this.service = service; } public String getSname() { return sname; } public void setSname(String sname) { this.sname = sname; } public String getSex() { return sex; } public void setSex(String sex) { this.sex = sex; } public String getBirthday() { return birthday; } public void setBirthday(String birthday) { this.birthday = birthday; } public String getPid() { return pid; } public void setPid(String pid) { this.pid = pid; } public String getCname() { return cname; } public void setCname(String cname) { this.cname = cname; } // public String getTname() { //