Java Database Connectivity with MySQL

To connect Java application with the MySQL database, we need to follow 5 following steps.

In this example we are using MySql as the database. So we need to know following informations for the mysql database:

Driver class: The driver class for the mysql database is com.mysql.jdbc.Driver.
Connection URL: The connection URL for the mysql database is jdbc:mysql://localhost/om where jdbc is the API, mysql is the database, localhost is the server name on which mysql is running, we may also use IP address and om is the database name. We may use any database, in such case, we need to replace the sonoo with our database name.
Username: The default username for the mysql database is root.
Password: It is the password given by the user at the time of installing the mysql database. In this example, we are going to use blank value "" as the password.

Step 1:-

create table user
(id int,
name varchar(200),
city varchar(200)

);

Step 2:- Simple program to select id,name,city column data from user table.

import java.sql.*;

import java.sql.*;
public class Sample {
public static void main(String args[]){
try{
Class.forName("com.mysql.jdbc.Driver");
Connection con=DriverManager.getConnection(
"jdbc:mysql://localhost/om","root","");
//here sonoo is database name, root is username and password
Statement stmt=con.createStatement();
ResultSet rs=stmt.executeQuery("select * from user");
while(rs.next())
System.out.println(rs.getInt(1)+" "+rs.getString(2)+" "+rs.getString(3));
con.close();
}catch(Exception e){ System.out.println(e);}
}

}

JAVA DEVELOPMENT Training By Om Sir

Mysql Database Connection in Java

Java Database Connectivity with MySQL