readscore.java

jsp+access简易选课系统

package student;
import java.io.*;
import java.text.*;
import java.util.*;
import java.sql.*; 
import java.net.*;
public class ReadScore{
	public ResultSet result;
	public String semester;
	public String CID;
	Connection con=null;
	
	public void setSemester(String semester){
		this.semester=semester;
	}
	
	public void setCID(String CID){
		this.CID=CID;
	}
	
	public ResultSet getResult(){
		String sql;
		try{
			String ss=getClass().getResource("/").getPath();
            String ss1=ss.substring(1).replace("%20"," ");
            URL str=getClass().getResource("/");
		
		    String s=str.toString();
            String url0=s.substring(6);
            String url=url0.replace("%20"," ");
		
		    String constr="jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};"+
    "DBQ="+url+"/data/system";
    
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
	        Connection con = DriverManager.getConnection(constr);
	        Statement smt = con.createStatement();
            sql="select Student.S_ID,Student.S_Name,Course.C_Name,Student_Course.Isexam,Student_Course.score from Student,Student_Course,Course where Student.S_ID=Student_Course.S_ID and Student_Course.C_ID=Course.C_ID and Student_Course.semester=Course.semester and Course.semester='"+semester+"' and Course.C_ID="+CID;
	        result=smt.executeQuery(sql);
		}
		catch(SQLException e)
		{
			result=null;
		}	
		finally{
			return  result;
		} 
	}
	
	public void Close(){
		try{
			con.close();
		}
		catch(Exception e){
			
		}
	}
}