Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- //java -classpath "/home/acridic/JConnector/mysql-connector-java-5.1.18;." SQLTest host database uname pw
- import java.sql.*;
- public class SQLTest{
- public static void main(String[] args){
- Connection myCon;
- Statement myState;
- try{
- Class.forName("com.mysql.jdbc.Driver").newInstance();
- //args[0] host (localhost:portNumber)
- //args[1] database
- //args[2] uname
- //args[3] pw
- myCon = DriverManager.getConnection("jdbc:mysql://"+args[0]+"/"+args[1] , args[2] , args[3]);
- myState = myCon.createStatement();
- ResultSet result = myState.executeQuery("SELECT * FROM book");
- while(result.next())
- System.out.println(result.getString("Author"));
- myCon.close();
- }catch(Exception e){
- System.out.println(e);
- }
- }
- }
Add Comment
Please, Sign In to add comment