KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > org > netbeans > test > db > 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.test.db.util;
21
22 import java.io.File JavaDoc;
23 import java.net.MalformedURLException JavaDoc;
24 import java.net.URL JavaDoc;
25 import java.sql.Connection JavaDoc;
26 import java.sql.Driver JavaDoc;
27 import java.util.Properties JavaDoc;
28 import org.netbeans.modules.derby.DbURLClassLoader;
29
30 /**
31  *
32  * @author luke
33  */
34 public class DbUtil {
35     public static final String JavaDoc DRIVER_CLASS_NAME = "org.apache.derby.jdbc.ClientDriver";
36     private String JavaDoc location;
37     
38     public DbUtil(String JavaDoc location){
39         this.location=location;
40     }
41     
42     private File JavaDoc getDerbyFile(String JavaDoc relPath) {
43         return new File JavaDoc(location, relPath);
44     }
45     
46     private URL JavaDoc[] getDerbyNetDriverURLs() throws MalformedURLException JavaDoc {
47         URL JavaDoc[] driverURLs = new URL JavaDoc[1];
48         driverURLs[0] = getDerbyFile("lib/derbyclient.jar").toURI().toURL();
49         return driverURLs;
50     }
51     
52     private Driver JavaDoc getDerbyNetDriver() throws Exception JavaDoc {
53         URL JavaDoc[] driverURLs = getDerbyNetDriverURLs();
54         DbURLClassLoader l = new DbURLClassLoader(driverURLs);
55         Class JavaDoc c = Class.forName(DRIVER_CLASS_NAME, true, l);
56         return (Driver JavaDoc)c.newInstance();
57     }
58     
59     public Connection JavaDoc createConnection(String JavaDoc url) throws Exception JavaDoc{
60         Driver JavaDoc driver=getDerbyNetDriver();
61         Properties JavaDoc p=new Properties JavaDoc();
62         Connection JavaDoc con=driver.connect(url,new Properties JavaDoc());
63         return con;
64     }
65     
66 }
67
Popular Tags