connect.java

一个非常简单的类

package DataBaseConnection;
import java.sql.*;


public class Connect {
	
	private static Connection con = null; //singleton pattern unique instance.
	public Connect(){
		// Exists only to defeat instantiation.
	}
	public static Connection getConnect() {
		String driverName = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
		String dbURL = "jdbc:sqlserver://Onuris.groept.be\\groept; DatabaseName=a07_SD203";                                  //server info
		String userName = "a07_SD203";                     
		String userPwd = "a07_SD203";
		if(con == null){
			try {
		          System.out.println("System is getting connection .......");
		          Class.forName(driverName).newInstance();
		          con = DriverManager.getConnection(dbURL, userName, userPwd);
		          System.out.println("Connection Successful!");
		        } catch (Exception e) {
		          System.out.println("Connection Failed!");
		          e.printStackTrace();
		          }
		}
		return con;
	}

}