mysql jdbc connection code

package com.test;

import java.sql.*;

 

public class MysqlConnect{

  public static void main(String[] args)throws Exception {

    System.out.println("MySQL Connect Example.");

    Connection conn = null;

    String url = "jdbc:mysql://localhost:3306/";

    String dbName = "test";

    String driver = "com.mysql.jdbc.Driver";

    String userName = "fff";

    String password = "bbb";

    try {

      Class.forName(driver).newInstance();

      conn = DriverManager.getConnection(url+dbName,userName,password);

      System.out.println("Connected to the database");

      conn.close();

      System.out.println("Disconnected from database");

    } catch (Exception e) {

      e.printStackTrace();

    }

  }

}

Comments

Popular posts from this blog

Rails Memcache issues

Enabling password authentication for new ec2 box | ssh, ssh config, EC2 setup, new user in EC2, PasswordAuthentication

What's the difference between "include" and "require" in Ruby?