my code

Deepak Kumar

How to create connection string to Mysql from Java
by Deepak Kumar

This requires commons-dbcp.jar file to connect to mysql database using java

Snippet options

Download: Download snippet as
Copy snippet: For this you need a free my code account.
Embed code : You will find the embed code for this snippet at the end of the page, if you want to embed it into a website or a blog!

public static Connection getConnection(String connectionString) throws SQLException {
		ResourceBundle bundle = ResourceBundle.getBundle("");
		String dbName = bundle.getString("");
		String userName = bundle.getString("db.user");
		String password = bundle.getString("db.passwd");
		String host = bundle.getString("");
		BasicDataSource connectionPool;

        if (dataSources.containsKey(connectionString)) {
        	connectionPool = dataSources.get(connectionString);
        } else {
        	connectionPool = new BasicDataSource();
    		connectionPool.setUrl("jdbc:mysql://" + host + ":3306/" + dbName);
            dataSources.put(dbName, connectionPool);

        return connectionPool.getConnection();

Create a free my code account now.

my code is a free service, which allows you to save and manage code snippes of any kind and programming language. We provide many advantages for your daily work with code-snippets, also for your teamwork. Give it a try!

Find out more and register now

You can customize the height of iFrame-Codes as needed! You can find more infos in our API Reference for iframe Embeds.