Experiment No 14 (JDBC Program)

//STEP 1. Import required packages

import java.sql.*;

public class FirstExample {

// JDBC driver name and database URL

static final String JDBC_DRIVER = "com.mysql.jdbc.Driver";

static final String DB_URL = "jdbc:mysql://localhost/EMP";

// Database credentials

static final String USER = "username";

static final String PASS = "password";

public static void main(String[] args) {

Connection conn = null;

Statement stmt = null;

try{

//STEP 2: Register JDBC driver

Class.forName("com.mysql.jdbc.Driver");

//STEP 3: Open a connection System.out.println("Connecting to database...");

Conn = DriverManager.getConnection(DB_URL,USER,PASS);

Statement stmt=con.createStatement(); 

ResultSet rs=stmt.executeQuery("select * from emp"); 

while(rs.next()) 

{

Int id = rs.getInt(“ID”);

int age = rs.getInt("age");

String first = rs.getString("first");

String last = rs.getString("last");

//Display values

System.out.print("ID: " + id);

System.out.print(", Age: " + age);

 System.out.print(", First: " + first);

System.out.println(", Last: " + last);

}

//STEP 6: Clean-up environment

rs.close(); stmt.close(); conn.close();

}catch(SQLException se){

//Handle errors for JDBC

se.printStackTrace();

}

System.out.println("Goodbye!");

}//end main

}//end FirstExample

Output

ID: 21, Age: 45,First: ABC, Last: XYZ