Archief - [PROG][JAVA] connectie met sql server express :s

public bowlingconnection() throws SQLException {
        laadDriver();
        String connectionUrl = "jdbc:sqlserver://SQLEXPRESS;" +  "databaseName=test;user=WELLESDESK\\Welles;password=;";
        Connection con = DriverManager.getConnection(connectionUrl);
    }

private void laadDriver() {
        final String driverName = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
        try {
            Class.forName(driverName);
        } catch (ClassNotFoundException e) {
            System.err.println("Fatal error: cannot load database driver" + driverName);
            System.exit(1);
        }
    }

public class Database
{
	//Instance Vars
	String host = "localhost";
	String dbName = databasenaam;
	String url = "jdbc:mysql://" + host + "/" + dbName;
	String user = username;
	String password = password;
	
	java.sql.Statement statement;
	Connection conn = null;
	static Database deDatabase;

        public Database()
	{
		System.out.println("Attempting to connect...");

		
		try 
		{	
			Class.forName("com.mysql.jdbc.Driver").newInstance();
			conn = DriverManager.getConnection(url,user,password);
			System.out.println("Connected succesfully!");
			
			statement = conn.createStatement();
		} 
		
		catch (Exception e) 
		{
			JOptionPane.showMessageDialog(null,"Kan niet verbinden met database");
			e.printStackTrace();
		}
	}
	
	public static Database getInstance() 
	{
		if (deDatabase == null)
		{
			deDatabase= new Database();
		}
			
		return deDatabase;
	}