<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<%@ page language="java" contentType="text/html; charset=GBK" %>
<%@ page import="my.helpsoft.HibernateQueryHelper"%>
<%@ page import="java.util.List" %>
<%@ page import="java.util.Iterator" %>
<%@ page import="org.hibernate.Query" %>
<%@ page import="my.entity.Grade" %>
<%@ page import="my.entity.Student" %>
<html>
  <body>
    <center>
<jsp:useBean id="queryHelper" class="my.helpsoft.HibernateQueryHelper"/>
<% 
   HibernateQueryHelper helper=new HibernateQueryHelper();
   request.setCharacterEncoding("GBK");
   String courseNo=request.getParameter("courseNo");//课程号
   String clazz=request.getParameter("clazz");//班级
   String all=request.getParameter("xueshengshu");//学生数
   out.print(all);
   int a=Integer.parseInt(all);
   out.print(a);
   String xuehao[]= new String[a];
    Grade grade=new Grade();
    String hql="from Student where clazz="+"\'"+clazz+"\'";
    Query query1=queryHelper.createQuery(hql);
    List list=query1.list();
    Iterator it=list.iterator();
    int k=0;
    if (it.hasNext())
    {
    while (it.hasNext())
         {   Student sp1=(Student)it.next();
             xuehao[k]=sp1.getXuehao();
              k++;
            }
     }          
   Grade grade1=new Grade();
   for(int i=0;i<a;i++)
    {
      grade1.setXuehao(xuehao[i]);
      grade1.setCourseNO(courseNo);
      grade1.setMark(Float.parseFloat(request.getParameter("text"+i)));
          queryHelper.save(grade1);
    }    if (queryHelper.save(grade1))
     {
       queryHelper.close();
       out.print("Add Sucessful!!!");
     }
    else
     {
       queryHelper.close();
       response.sendRedirect("SQLError.jsp");
     }
       queryHelper.close();
 %>
      </center>
  </body>
</html>