fork download
copy 
  1. //STEP 1. Import required packages
  2. import java.sql.*;
  3.  
  4. public class Main {
  5.    // JDBC driver name and database URL
  6.    static final String JDBC_DRIVER = "com.mysql.jdbc.Driver";  
  7.    static final String DB_URL = "jdbc:mysql://localhost/EMP";
  8.  
  9.    //  Database credentials
  10.    static final String USER = "username";
  11.    static final String PASS = "password";
  12.  
  13. public static void main(String[] args) {
  14.    Connection conn = null;
  15.    Statement stmt = null;
  16.    try{
  17.       //STEP 2: Register JDBC driver
  18.       Class.forName("com.mysql.jdbc.Driver");
  19.  
  20.       //STEP 3: Open a connection
  21.       System.out.println("Connecting to database...");
  22.       conn = DriverManager.getConnection(DB_URL,USER,PASS);
  23.  
  24.       //STEP 4: Execute a query to create statment with
  25.       // required arguments for RS example.
  26.       System.out.println("Creating statement...");
  27.       stmt = conn.createStatement(
  28.                            ResultSet.TYPE_SCROLL_INSENSITIVE,
  29.                            ResultSet.CONCUR_READ_ONLY);
  30.       String sql;
  31.       sql = "SELECT id, first, last, age FROM Employees";
  32.       ResultSet rs = stmt.executeQuery(sql);
  33.  
  34.       // Move cursor to the last row.
  35.       System.out.println("Moving cursor to the last...");
  36.       rs.last();
  37.  
  38.       //STEP 5: Extract data from result set
  39.       System.out.println("Displaying record...");
  40.       //Retrieve by column name
  41.       int id  = rs.getInt("id");
  42.       int age = rs.getInt("age");
  43.       String first = rs.getString("first");
  44.       String last = rs.getString("last");
  45.  
  46.       //Display values
  47.       System.out.print("ID: " + id);
  48.       System.out.print(", Age: " + age);
  49.       System.out.print(", First: " + first);
  50.       System.out.println(", Last: " + last);
  51.  
  52.       // Move cursor to the first row.
  53.       System.out.println("Moving cursor to the first row...");
  54.       rs.first();
  55.  
  56.       //STEP 6: Extract data from result set
  57.       System.out.println("Displaying record...");
  58.       //Retrieve by column name
  59.       id  = rs.getInt("id");
  60.       age = rs.getInt("age");
  61.       first = rs.getString("first");
  62.       last = rs.getString("last");
  63.  
  64.       //Display values
  65.       System.out.print("ID: " + id);
  66.       System.out.print(", Age: " + age);
  67.       System.out.print(", First: " + first);
  68.       System.out.println(", Last: " + last);
  69.      // Move cursor to the first row.
  70.  
  71.       System.out.println("Moving cursor to the next row...");
  72.       rs.next();
  73.  
  74.       //STEP 7: Extract data from result set
  75.       System.out.println("Displaying record...");
  76.       id  = rs.getInt("id");
  77.       age = rs.getInt("age");
  78.       first = rs.getString("first");
  79.       last = rs.getString("last");
  80.  
  81.       //Display values
  82.       System.out.print("ID: " + id);
  83.       System.out.print(", Age: " + age);
  84.       System.out.print(", First: " + first);
  85.       System.out.println(", Last: " + last);
  86.  
  87.       //STEP 8: Clean-up environment
  88.       rs.close();
  89.       stmt.close();
  90.       conn.close();
  91.    }catch(SQLException se){
  92.       //Handle errors for JDBC
  93.       se.printStackTrace();
  94.    }catch(Exception e){
  95.       //Handle errors for Class.forName
  96.       e.printStackTrace();
  97.    }finally{
  98.       //finally block used to close resources
  99.       try{
  100.          if(stmt!=null)
  101.             stmt.close();
  102.       }catch(SQLException se2){
  103.       }// nothing we can do
  104.       try{
  105.          if(conn!=null)
  106.             conn.close();
  107.       }catch(SQLException se){
  108.          se.printStackTrace();
  109.       }//end finally try
  110.    }//end try
  111.    System.out.println("Goodbye!");
  112. }//end main
  113. }//end JDBCExample
Success #stdin #stdout #stderr 0.09s 55492KB
comments (?)
stdin
copy 
Standard input is empty
stdout
copy 
Goodbye!
stderr
copy 
java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
	at java.base/jdk.internal.loader.BuiltinClassLoader.loadClass(BuiltinClassLoader.java:583)
	at java.base/jdk.internal.loader.ClassLoaders$AppClassLoader.loadClass(ClassLoaders.java:178)
	at java.base/java.lang.ClassLoader.loadClass(ClassLoader.java:521)
	at java.base/java.lang.Class.forName0(Native Method)
	at java.base/java.lang.Class.forName(Class.java:332)
	at Main.main(Main.java:18)
https://ideone.com/Qzfpxo
language:
Java (HotSpot 12)
created:
36 days ago
visibility:
public

Share or Embed source code

Discover > Sphere Engine API

The brand new service which powers Ideone!

Discover > IDE Widget

Widget for compiling and running the source code in a web browser!