KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > org > netbeans > modules > db > sql > execute > ui > util > DbUtil


1 /*
2  * The contents of this file are subject to the terms of the Common Development
3  * and Distribution License (the License). You may not use this file except in
4  * compliance with the License.
5  *
6  * You can obtain a copy of the License at http://www.netbeans.org/cddl.html
7  * or http://www.netbeans.org/cddl.txt.
8  *
9  * When distributing Covered Code, include this CDDL Header Notice in each file
10  * and include the License file at http://www.netbeans.org/cddl.txt.
11  * If applicable, add the following below the CDDL Header, with the fields
12  * enclosed by brackets [] replaced by your own identifying information:
13  * "Portions Copyrighted [year] [name of copyright owner]"
14  *
15  * The Original Software is NetBeans. The Initial Developer of the Original
16  * Software is Sun Microsystems, Inc. Portions Copyright 1997-2006 Sun
17  * Microsystems, Inc. All Rights Reserved.
18  */
19
20 package org.netbeans.modules.db.sql.execute.ui.util;
21
22
23
24 import java.io.File JavaDoc;
25 import java.net.URL JavaDoc;
26 import java.net.URLClassLoader JavaDoc;
27 import java.sql.Connection JavaDoc;
28 import java.sql.Driver JavaDoc;
29 import java.sql.DriverManager JavaDoc;
30 import java.util.*;
31 import org.netbeans.junit.Manager;
32
33 /**
34  *
35  * @author luke
36  */
37
38
39 public class DbUtil {
40     
41     public static String JavaDoc DRIVER_CLASS_NAME="driver_class_name";
42     public static String JavaDoc URL="url";
43     public static String JavaDoc USER="user";
44     public static String JavaDoc PASSWORD="password";
45     
46     public static Connection JavaDoc createConnection(Properties p,File JavaDoc[] f) throws Exception JavaDoc{
47         String JavaDoc driver_name=p.getProperty(DRIVER_CLASS_NAME);
48         String JavaDoc url=p.getProperty(URL);
49         String JavaDoc user=p.getProperty(USER);
50         String JavaDoc passwd=p.getProperty(PASSWORD);
51         ArrayList list=new java.util.ArrayList JavaDoc();
52         for(int i=0;i<f.length;i++){
53             list.add(f[i].toURI().toURL());
54         }
55         URL JavaDoc[] driverURLs=(URL JavaDoc[])list.toArray(new URL JavaDoc[0]);
56         URLClassLoader JavaDoc l = new URLClassLoader JavaDoc(driverURLs);
57         Class JavaDoc c = Class.forName(driver_name, true, l);
58         Driver JavaDoc driver=(Driver JavaDoc)c.newInstance();
59         Connection JavaDoc con=driver.connect(url,p);
60         return con;
61     }
62     
63     
64     
65     
66 }
67
68
Popular Tags