Java JDBC MySQL Connection getConnection()

Description

get Connection

License

Open Source License

Declaration

public static Connection getConnection() 

Method Source Code

//package com.java2s;
/*/*from  w  w w  . j  a va  2  s  .  co  m*/
 * Copyright (c) 2005-2012, WSO2 Inc. (http://www.wso2.org) All Rights Reserved.
 *
 *   WSO2 Inc. licenses this file to you under the Apache License,
 *   Version 2.0 (the "License"); you may not use this file except
 *   in compliance with the License.
 *   You may obtain a copy of the License at
 *
 *     http://www.apache.org/licenses/LICENSE-2.0
 *
 *  Unless required by applicable law or agreed to in writing,
 *  software distributed under the License is distributed on an
 *  "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
 *  KIND, either express or implied.  See the License for the
 *  specific language governing permissions and limitations
 *  under the License.
 */

import java.sql.*;

public class Main {
    public static Connection getConnection() {

        Connection conn = null;
        //  jdbc:mysql://localhost/rss01
        String jdbcUrl = System.getProperty("jdbcurl");
        //  com.mysql.jdbc.Driver
        String driverClass = System.getProperty("driver");
        String userName = System.getProperty("username");
        String userPassword = System.getProperty("password");

        try {
            Class.forName(driverClass).newInstance();
            conn = DriverManager.getConnection(jdbcUrl, userName, userPassword);
        } catch (ClassNotFoundException ex) {
            System.err.println(ex.getMessage());
        } catch (IllegalAccessException ex) {
            System.err.println(ex.getMessage());
        } catch (InstantiationException ex) {
            System.err.println(ex.getMessage());
        } catch (SQLException ex) {
            System.err.println(ex.getMessage());
        }
        return conn;
    }
}

Related

1. getConnection()
2. getConnection()
3. getConnection()
4. getConnection()
5. getConnection()
6. getConnection()
7. getConnection()
8. getConnection()
9. getConnection()