<!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>
<%@ 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>
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货