aquaballoon

Java - JDBC (mysql)

Apr 15th, 2014
131
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 1.35 KB | None | 0 0
  1. package mysql;
  2.  
  3. import java.sql.*;
  4.  
  5. public class Console {
  6.    
  7.     //String sqlite_Driver = "org.sqlite.JDBC";
  8.     //String sqlite_Url = "jdbc:sqlite:test.db";
  9.  
  10.     String driver = "com.mysql.jdbc.Driver";
  11.    
  12.     String url = "jdbc:mysql://localhost/ITDB";
  13.     String user = "root";
  14.     String pass = "abc123";
  15.    
  16.     Connection conn;
  17.     Statement stmt;
  18.     String sql;
  19.     ResultSet result;
  20.  
  21.     Console() {
  22.  
  23.         try {
  24.             // Loading JDBC Driver Class
  25.             Class.forName(driver);
  26.            
  27.             conn = DriverManager.getConnection(url, user, pass);
  28.             stmt = conn.createStatement();
  29.             sql = "SELECT id, name, email FROM GradeTB";
  30.             //sql = "SELECT id, name, email FROM GradeTB WHERE name='Orange Lee' ";
  31.             result = stmt.executeQuery(sql);
  32.            
  33.             while(result.next()){
  34.                 String id = result.getString("id");
  35.                 String name = result.getString("name");
  36.                 String email = result.getString("email");
  37.                
  38.                 System.out.println(id + "\n" + name + "\n" + email);
  39.             }
  40.            
  41.             result.close();
  42.             stmt.close();
  43.             conn.close();
  44.  
  45.         } catch (Exception e){
  46.             System.out.println("Error: " + e.getMessage());
  47.         }
  48.     }
  49. }
Advertisement
Add Comment
Please, Sign In to add comment