courseread.java

jsp+access简易选课系统

package student;
import java.io.*;
import java.text.*;
import java.util.*;
import java.sql.*; 
import java.net.*;
public class CourseRead{
	private ResultSet course;
	private String sid;
	private String semester;
	Connection con=null;
	
	public void setSid(String sid){
		this.sid=sid;
	}
	
	public void setSemester(String semester){
		this.semester=semester;
	}
	
	public String getSid(){
		return sid;
	}
	
	public ResultSet getCourse(){
	    String sql,specialty="";
	    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");
	        con = DriverManager.getConnection(constr);
	        Statement smt = con.createStatement();
	        sql="select Specialty from Student where S_ID='"+sid+"'";
	        ResultSet result = smt.executeQuery(sql);
	        if(result.next())
	          specialty=result.getString(1);
	        sql = "select * from Course where semester='"+semester+"' and specialty like '%"+specialty+"%'";
	        course = smt.executeQuery(sql);
	    }
	    catch(SQLException e)
	    {
	    	course=null;
	    }
	    finally{
	      return course;
	    }
	}
	
	public void Close(){
		try{
			con.close();
		}
		catch(Exception e){
			
		}
	}			
}