Posted By

syedhussim on 06/27/17

Tagged

mysql

Versions (?)

Last Edited at 06/27/17 06:42pm

Statistics

Viewed 3545 times

Favorited by 0 user(s)

Related snippets

Connect To A MySQL Database

/ Published in: Java

This code snippet shows how to connect to a MySQL database using Connector/J.

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

import  java.sql.*;
import  java.sql.Connection;
import  java.sql.DriverManager;
 
class  Example{
        public  static  void  main(String  args[]){
                String  driver  =  "com.mysql.jdbc.Driver";
                String  connection  =  "jdbc:mysql://localhost:3306/database_name";
                String  user  =  "";
                String  password  =  "";
                try{
                        Class.forName(driver);
                        Connection  con  =  DriverManager.getConnection(connection,  user,  password);
                        if  (!con.isClosed()){
                                Statement  stmt  =  con.createStatement();    
 
                                ResultSet  rs  =  stmt.executeQuery("SELECT * FROM employees");      
 
                                while(rs.next()){
                                        System.out.println(rs.getString("First_Name"));    
                                }
                        }
                }catch(Exception  e){
                        System.out.println(e.getMessage());
                }
        }
}

URL: http://www.snippetcentral.net/java/connect-to-a-mysql-database.html

Report this snippet Tweet

Comments

Subscribe to comments

Comment:

You need to login to post a comment.