<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%@page import="cn.syau.dao.StudentgradeDao,com.syau.javabean.Grade"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>提交成绩</title>
</head>
<body>
<form action="addgrade.action" method="post">
<table border="1">
<tr>
<td>学号</td>
<td>课号</td>
<td>学生名</td>
<td>课程名</td>
<td>教师名</td>
<td>成绩</td>
</tr>
<%
StudentgradeDao dao=new StudentgradeDao();
List<Grade> list= dao.submitgrade();
for(Grade g1:list)
{%>
<tr>
<td><%=g1.getUid() %> </td>
<td><%=g1.getCid() %></td>
<td><%=g1.getUname() %></td>
<td><%=g1.getCname() %></td>
<td><%=g1.getTname() %></td>
<td><input type="text" name="grade"/></td>
<td><input type="hidden" name="uid" value="<%=g1.getUid() %>"/></td>
</tr>
<%}
%>
<tr><td> <input type="submit" value="提交"/></td></tr>
</table>
</form>
</body>
</html>
jsp页面
package cn.syau.action;
import java.util.List;
import cn.syau.dao.StudentgradeDao;
import com.opensymphony.xwork2.ActionSupport;
import com.syau.javabean.Grade;
@SuppressWarnings("serial")
public class GradeAction extends ActionSupport{
private int uid;
private int grade;
public int getUid() {
return uid;
}
public int getGrade() {
return grade;
}
public String grade(){
StudentgradeDao dao=new StudentgradeDao();
List<Grade> list=dao.submitgrade();
if(list!=null&&list.size()>0){
return SUCCESS;//
}
return ERROR;
}
public String addgrade(){
String sql="update studentgrade set grade="+getGrade()+"where uid="+getUid();
StudentgradeDao dao=new StudentgradeDao();
if(dao.addgrade(sql)>=1){
System.out.println(dao.addgrade(sql));
return "yes";
}else{
return "no";
}
}
}
action代码段。。。。
。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。
打印sql的话 为啥uid和grade都等于零。。。。