dboperator.java

网上虚拟社区

import java.sql.*;
import java.io.FileInputStream;
import java.io.IOException;
import java.util.Properties;

public class DBOperator{
	   private  String url;
	   private  String username;
	   private  String password;
	   private  String driver;
	   	   
	   public DBOperator(){  
		   driver = "sun.jdbc.odbc.JdbcOdbcDriver";
           url = "jdbc:odbc:BankDB";
           username = null;
           password =null;
       }
	   public DBOperator(String driver,String url,String username,String password){
		   this.driver = driver;
		   this.url=url;
		   this.username = username;
		   this.password = password;
	   }
	   public DBOperator(String url,String username,String password){
		   this.url=url;
		   this.username = username;
		   this.password = password;
	   }
	   public DBOperator(String driver,String url){
		   this(driver,url,null,null);
	   }
	   public DBOperator(String url){
		   this(url,null,null);
	   }
	   
	   public  Connection getConnection() throws SQLException {
		   try{
			Class.forName(driver);
		   }
		   catch(ClassNotFoundException ex){
			   System.out.println(ex);
		   }
	       return DriverManager.getConnection(url,username,password);
	   }

}