checkmark.java

《JSP程序设计实用教程》-梁建武-源代码-4567.rar

 package stu;
 
 import java.sql.*;

public class checkmark {
	String stu_id;
    public void setStu_id(String id){stu_id=id;}
    public String getStu_id(){return stu_id;}
    public ResultSet getScore(){
     String	sql="select enrol.score , course.name ,course.mark "+
 	         "from enrol ,course ,classes "+
		     "where stu_id='"+stu_id+"' "+
		     "and enrol.class_id=classes.id "+
			 "and classes.cour_id=course.id ";
		sqlBean db = new sqlBean();
		ResultSet rs= db.executeQuery(sql);	 
		return rs;
    	                       }
    public ResultSet getTotal(){
    	String sql="select mark from student where id='"+stu_id+"'";
    	sqlBean db = new sqlBean();
    	ResultSet rs = db.executeQuery(sql);
    	return rs;
    	}    	                       

	
}