Java Database Connectivity with MySQL
Setting up MySQL as the Database for Java_JDBC. A short demo to read records from MySQL table using JAVA program.
JDK8: https://www.oracle.com/java/technolog...
MySQL: https://dev.mysql.com/downloads/mysql/
JDBC Driver: https://dev.mysql.com/downloads/conne...
-----------------
MySQL commands used in the video to create db, table and Insert records:
create database mktest;
use mktest;
create table stud(roll char(10), name varchar(20), cgpa float(10,2));
insert into stud values ("kiit111", "Amit", 8.0);
insert into stud values ("kiit123", "Enadu", 7.5);
. . . . .
JAVA Source (db: mktest, table: stud)
------------------------------------------------------------
import java.sql.*;
public class App {
static final String DB_URL = "jdbc:mysql://localhost:3306/mktest";
static final String USER = "root";
static final String PASS = "password";
static final String QUERY = "SELECT * FROM stud";
public static void main(String[] args) {
// Open a connection
try(Connection conn = DriverManager.getConnection(DB_URL, USER, PASS);
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery(QUERY);) {
// Extract data from result set
while (rs.next()) {
// Retrieve by column name
System.out.print("Roll: " + rs.getString("roll"));
System.out.print(", Name: " + rs.getString("name"));
System.out.println(", CGPA: " + rs.getFloat("cgpa"));
}
} catch (SQLException e) {
e.printStackTrace();
}
}
}