Java JDBC MySQL Connection getConnection()

Description

get Connection

License

Apache License

Declaration

public static Connection getConnection() throws SQLException 

Method Source Code

//package com.java2s;
//License from project: Apache License 

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

public class Main {
    static String ip = "127.0.0.1";
    static int port = 3306;
    static String database = "db_abbey";
    static String encoding = "UTF-8";
    static String loginName = "root";
    static String password = "698970s";

    public static Connection getConnection() throws SQLException {
        String url = String.format("jdbc:mysql://%s:%d/%s?characterEncoding=%s", ip, port, database, encoding);
        return DriverManager.getConnection(url, loginName, password);
    }//from  w  w w  . jav a  2s  .  com
}

Related

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