我登陆系统的时候已经获取了改名同学的系id、班级id,但是显示的时候,我发现打印出来的是“没有找到”,也就是说,在数据库中没有找到,而且System.out.print(sysId);if(sqlSelect.next()){ 这里打印出来的sysId是0,而且页面也没有显示。但是我数据库中有一条我查询的这个系、班级的信息。我课程表字段只有:系id、班级id,然后就是每节课的课程名字
页面超链接传值的时候是:<a href="showcurriculum.action?sysId=<s:property value="#session.sysId"/>">本 学 期 课 程</a>
我action里面的代码如下:
public class ManaAction extends ActionSupport{
private Manager manager=new Manager(); public Manager getManager() {
return manager;
} public void setManager(Manager manager) {
this.manager = manager;
}
//定义显示课程表的列表
private List<Manager> curriList=new ArrayList<Manager>();
public List<Manager> getCurriList() {
return curriList;
}
public void setCurriList(List<Manager> curriList) {
this.curriList = curriList;
}
//显示该生的本学期的课程表 public String selectCurri()throws Exception{
HttpServletRequest request=ServletActionContext.getRequest();
String s=request.getSession().getAttribute("sysId").toString(); //根据系号和班级号进行课表的查询(这两个字段之前进行了session)
int sysId=Integer.parseInt(s);
//String b=request.getSession().getAttribute("claId").toString();
//int claId=Integer.parseInt(b);
ResultSet sqlSelect=Dbcon.executeQuery("select * from curriculum where sysId='"+sysId+"'");
try{
System.out.print(sysId);
if(sqlSelect.next()){
System.out.print("curriculum");
System.out.print(sqlSelect.getString("xueqi"));
manager.setSysId(Integer.valueOf(sqlSelect.getString("sysId")));
manager.setClaId(Integer.valueOf(sqlSelect.getString("claId")));
manager.setStuName(sqlSelect.getString("xueqi"));
manager.setPassword(sqlSelect.getString("km11"));
manager.setSpersonid(sqlSelect.getString("km12"));
manager.setSpersonid(sqlSelect.getString("km13"));
manager.setSpersonid(sqlSelect.getString("km14"));
manager.setSpersonid(sqlSelect.getString("km15"));
manager.setPassword(sqlSelect.getString("km21"));
manager.setSpersonid(sqlSelect.getString("km22"));
manager.setSpersonid(sqlSelect.getString("km23"));
manager.setSpersonid(sqlSelect.getString("km24"));
manager.setSpersonid(sqlSelect.getString("km25"));
manager.setPassword(sqlSelect.getString("km31"));
manager.setSpersonid(sqlSelect.getString("km32"));
manager.setSpersonid(sqlSelect.getString("km33"));
manager.setSpersonid(sqlSelect.getString("km34"));
manager.setSpersonid(sqlSelect.getString("km35"));
manager.setPassword(sqlSelect.getString("km31"));
manager.setSpersonid(sqlSelect.getString("km32"));
manager.setSpersonid(sqlSelect.getString("km33"));
manager.setSpersonid(sqlSelect.getString("km34"));
manager.setSpersonid(sqlSelect.getString("km35"));
manager.setPassword(sqlSelect.getString("km41"));
manager.setSpersonid(sqlSelect.getString("km42"));
manager.setSpersonid(sqlSelect.getString("km43"));
manager.setSpersonid(sqlSelect.getString("km44"));
manager.setSpersonid(sqlSelect.getString("km45"));
manager.setPassword(sqlSelect.getString("km61"));
manager.setSpersonid(sqlSelect.getString("km62"));
manager.setSpersonid(sqlSelect.getString("km63"));
manager.setSpersonid(sqlSelect.getString("km64"));
manager.setSpersonid(sqlSelect.getString("km65"));
manager.setPassword(sqlSelect.getString("km71"));
manager.setSpersonid(sqlSelect.getString("km72"));
manager.setSpersonid(sqlSelect.getString("km73"));
manager.setSpersonid(sqlSelect.getString("km74"));
manager.setSpersonid(sqlSelect.getString("km75"));
sqlSelect.close();
}
else
System.out.print("没找到");
}catch(Exception e){
e.printStackTrace();
}
return SUCCESS;
}
页面超链接传值的时候是:<a href="showcurriculum.action?sysId=<s:property value="#session.sysId"/>">本 学 期 课 程</a>
我action里面的代码如下:
public class ManaAction extends ActionSupport{
private Manager manager=new Manager(); public Manager getManager() {
return manager;
} public void setManager(Manager manager) {
this.manager = manager;
}
//定义显示课程表的列表
private List<Manager> curriList=new ArrayList<Manager>();
public List<Manager> getCurriList() {
return curriList;
}
public void setCurriList(List<Manager> curriList) {
this.curriList = curriList;
}
//显示该生的本学期的课程表 public String selectCurri()throws Exception{
HttpServletRequest request=ServletActionContext.getRequest();
String s=request.getSession().getAttribute("sysId").toString(); //根据系号和班级号进行课表的查询(这两个字段之前进行了session)
int sysId=Integer.parseInt(s);
//String b=request.getSession().getAttribute("claId").toString();
//int claId=Integer.parseInt(b);
ResultSet sqlSelect=Dbcon.executeQuery("select * from curriculum where sysId='"+sysId+"'");
try{
System.out.print(sysId);
if(sqlSelect.next()){
System.out.print("curriculum");
System.out.print(sqlSelect.getString("xueqi"));
manager.setSysId(Integer.valueOf(sqlSelect.getString("sysId")));
manager.setClaId(Integer.valueOf(sqlSelect.getString("claId")));
manager.setStuName(sqlSelect.getString("xueqi"));
manager.setPassword(sqlSelect.getString("km11"));
manager.setSpersonid(sqlSelect.getString("km12"));
manager.setSpersonid(sqlSelect.getString("km13"));
manager.setSpersonid(sqlSelect.getString("km14"));
manager.setSpersonid(sqlSelect.getString("km15"));
manager.setPassword(sqlSelect.getString("km21"));
manager.setSpersonid(sqlSelect.getString("km22"));
manager.setSpersonid(sqlSelect.getString("km23"));
manager.setSpersonid(sqlSelect.getString("km24"));
manager.setSpersonid(sqlSelect.getString("km25"));
manager.setPassword(sqlSelect.getString("km31"));
manager.setSpersonid(sqlSelect.getString("km32"));
manager.setSpersonid(sqlSelect.getString("km33"));
manager.setSpersonid(sqlSelect.getString("km34"));
manager.setSpersonid(sqlSelect.getString("km35"));
manager.setPassword(sqlSelect.getString("km31"));
manager.setSpersonid(sqlSelect.getString("km32"));
manager.setSpersonid(sqlSelect.getString("km33"));
manager.setSpersonid(sqlSelect.getString("km34"));
manager.setSpersonid(sqlSelect.getString("km35"));
manager.setPassword(sqlSelect.getString("km41"));
manager.setSpersonid(sqlSelect.getString("km42"));
manager.setSpersonid(sqlSelect.getString("km43"));
manager.setSpersonid(sqlSelect.getString("km44"));
manager.setSpersonid(sqlSelect.getString("km45"));
manager.setPassword(sqlSelect.getString("km61"));
manager.setSpersonid(sqlSelect.getString("km62"));
manager.setSpersonid(sqlSelect.getString("km63"));
manager.setSpersonid(sqlSelect.getString("km64"));
manager.setSpersonid(sqlSelect.getString("km65"));
manager.setPassword(sqlSelect.getString("km71"));
manager.setSpersonid(sqlSelect.getString("km72"));
manager.setSpersonid(sqlSelect.getString("km73"));
manager.setSpersonid(sqlSelect.getString("km74"));
manager.setSpersonid(sqlSelect.getString("km75"));
sqlSelect.close();
}
else
System.out.print("没找到");
}catch(Exception e){
e.printStackTrace();
}
return SUCCESS;
}
查看该值是否正确取得。