学生选课系统J2EE源码

package com.ssh.dao; import java.util.ArrayList; import java.util.Iterator; import java.util.List; import org.apache.struts2.ServletActionContext; import org.hibernate.Session; import org.hibernate.SessionFactory; import org.hibernate.Transaction; import org.hibernate.cfg.Configuration; import com.ssh.tools.ConnDB; import com.ssh.tools.IncreamentID; import com.ssh.vo.SelCourseInf; import com.ssh.vo.Student; public class SelCourseDAO { @SuppressWarnings("unchecked") public List load( String courseno,String coursename,String priorcls){ List<SelCourseInf> selcourse = new ArrayList<SelCourseInf>(); Configuration conf = new Configuration().configure();// 1、读取配置文件 SessionFactory sf = conf.buildSessionFactory();// 2、创建SessionFactory Session session = null; Transaction tx = null; List list = null; try { session = sf.openSession();// 3、打开Session tx = session.beginTransaction();// 4、开始一个事务 String hql = "select c.courseno,c.coursename,tc.teaclsno," + "t.teaname,c.credit,c.coursehour,s.schname," + "tc.priorcls,tc.realnum,tc.limitnum from course c," + "teainf t,teacls tc,school s where tc.courseno = c.courseno " + "and tc.teano = t.teano and c.schno = s.schno and c.required='N'"; if(!"".equals(courseno)){ hql = hql + " and tc.courseno = '"+courseno+"'"; } if(!"".equals(coursename)){ hql = hql + " and c.coursename = '"+coursename+"'"; } if(!"".equals(priorcls)){ hql = hql + " and tc.priorcls like '%"+priorcls+"%'"; } list = session.createSQLQuery(hql).list(); for(Iterator iter = list.iterator();iter.hasNext();){ Object[] o = (Object[])iter.next(); SelCourseInf sc = new SelCourseInf(); sc.setCourseno((String)o[0]); sc.setCoursename((String)o[1]); //System.out.println((String)o[1]); sc.setTeacls((Integer)o[2]); sc.setTeacher((String)o[3]); sc.setCredit((Integer)o[4]); sc.setCoursehour((Integer)o[5]); sc.setSchool((String)o[6]); sc.setPriorcls((String)o[7]); sc.setRealnum((Integer)o[8]); sc.setLimitnum((Integer)o[9]); selcourse.add(sc); } tx.commit();// 6、 提交事务 } catch (Exception e) { if (null != tx) { tx.rollback(); } e.printStackTrace(); } finally { session.close();// 7、关闭Session } return selcourse; } @SuppressWarnings("unchecked") public int insert(String courseno1,int teaclsno){ Configuration conf = new Configuration().configure();// 1、读取配置文件 SessionFactory sf = conf.buildSessionFactory();// 2、创建SessionFactory Session session = null; Transaction tx = null; List list = null; int flag = 0; try { ConnDB conn = new ConnDB(); session = sf.openSession();// 3、打开Session tx = session.beginTransaction();// 4、开始一个事务 Student stu = (Student)ServletActionContext.getRequest().getSession().getAttribute("student"); //System.out.println(stu.getStuno()); String hql = "select * from tempchscs where courseno = '"+courseno1+"' and " + "stuno = '"+stu.getStuno().trim()+"'"; list = session.createSQLQuery(hql).list(); if(list.size()!=0){ flag = 2; return flag; } String hql1="select n.clsname from stuinf s,natcls n where s.stuno" + " = '"+stu.getStuno().trim()+"' and s.clsno = n.clsno"; list = session.createSQLQuery(hql1).list(); // Object[] obj =(Object[])list.get(0); // String clsname = (String)obj[0]; String clsname = (String)list.get(0); //System.out.println(clsname); String priorcls = ""; String hql2="select priorcls from teacls where teaclsno = "+teaclsno+" and courseno = '"+courseno1+"'"; list = session.createSQLQuery(hql2).list(); priorcls = (String)list.get(0); //System.out.println(priorcls); //Object[] o =(Object[])list.get(0); //String priorcls = (String)o[0]; String pricls="N"; if(priorcls.contains(clsname)){ pricls="Y"; }else{ pricls="N"; } String hql3 = "select sequence from tempchscs"; list = session.createSQLQuery(hql3).list(); int length = list.size(); String sequence = "0"; if(length==0){ sequence = "0"; }else{ sequence = (String)list.get(length-1); } //System.out.println(sequence); IncreamentID in = new IncreamentID(); sequence = in.addID(sequence); //System.out.println(sequence); String hql4 = "insert into tempchscs(teaclsno,courseno,stuno," + "pricls,sequence) values("+teaclsno+",'"+courseno1+"','"+stu.getStuno()+"','"+pricls+"','"+sequence+"')"; //session.createSQLQuery(hql4); flag = conn.executeUpdate(hql4); String hql5 = "update teacls set realnum = realnum+1 where teaclsno = "+teaclsno+" and courseno = '"+courseno1+"'"; conn.executeUpdate(hql5); conn.close(); tx.commit(); }catch(Exception e){ e.printStackTrace(); tx.rollback(); }finally{ session.close(); } return flag; } // public static void main(String[] args){ // SelCourseDAO s = new SelCourseDAO(); // List<SelCourseInf> a = s.load("","",""); // for(Iterator iter = a.iterator();iter.hasNext();){ // SelCourseInf o = (SelCourseInf)iter.next(); // System.out.print(o.getCourseno()); // System.out.print(o.getCoursename()); // System.out.print(o.getTeacls()); // System.out.print(o.getTeacher()); // System.out.print(o.getCredit()); // System.out.print(o.getCoursehour()); // System.out.print(o.getSchool()); // System.out.print(o.getPriorcls()); // System.out.print(o.getRealnum()); // System.out.println(o.getLimitnum()); // // } // } }