aquaballoon

Java - JDBC

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