Guest User

Untitled

a guest
Jul 9th, 2018
129
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 0.91 KB | None | 0 0
  1. //java -classpath "/home/acridic/JConnector/mysql-connector-java-5.1.18;." SQLTest host database uname pw
  2.  
  3. import java.sql.*;
  4.  
  5. public class SQLTest{
  6.     public static void main(String[] args){
  7.         Connection myCon;
  8.         Statement myState;
  9.         try{
  10.             Class.forName("com.mysql.jdbc.Driver").newInstance();
  11.             //args[0] host  (localhost:portNumber)
  12.             //args[1] database
  13.             //args[2] uname
  14.             //args[3] pw
  15.             myCon = DriverManager.getConnection("jdbc:mysql://"+args[0]+"/"+args[1] , args[2] , args[3]);
  16.             myState = myCon.createStatement();
  17.             ResultSet result = myState.executeQuery("SELECT * FROM book");
  18.             while(result.next())
  19.                 System.out.println(result.getString("Author"));
  20.                
  21.             myCon.close();
  22.         }catch(Exception e){
  23.             System.out.println(e);
  24.         }
  25.     }
  26. }
Add Comment
Please, Sign In to add comment