Exp 14

Introduction to JDBC

//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);

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***************

Connecting to database...

ID:90,Age:35,First:abc,Last:xyz

Goodbye!