connect.java

来自「网上选课系统」· Java 代码 · 共 34 行

package student;
import java.io.*;
import java.text.*;
import java.util.*;
import java.sql.*; 
import java.net.*;
public class Connect{
	private Connection con;
	
	public Connection getCon(){
		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);
	        }
	        catch(Exception e){
	        	con=null;
	        }
	        finally{
	        	return con;
	        }
	}
	
}