package sqlEngine;

import java.sql.*;
import java.util.*;
import com.mysql.jdbc.Statement;

public class DBConnect {

    public static void main(String[] args){
//        try {
//            String host = "jdbc:mysql://localhost:3306/dominiondb";
//            String uName="root";
//            String uPass="";
//            Connection con = DriverManager.getConnection( host, uName, uPass);
//            System.out.println("jow");
//        }
//        catch ( SQLException err ) {
//            System.out.println( err.getMessage( ) );
//            }
    	try
		   {
			   viewTable(DriverManager.getConnection( "jdbc:mysql://localhost:3306/dominiondb", "root", ""),"dominiondb");
		   }
		   catch ( SQLException err )
		   {
	            System.out.println( err.getMessage( ) );
	            }
    }
    public static void viewTable(Connection con, String dbName)
	   {
		    //throws SQLException {

		    java.sql.Statement stmt = null;
		    String query = "SELECT playerId, playername, psswd FROM players" ;
		    //}


		    try {

		        stmt = con.createStatement();
		        ResultSet rs = stmt.executeQuery(query);
		        while (rs.next()) {
		            String playername = rs.getString("playername");
		            int playerID = rs.getInt("playerId");
		            String passwd = rs.getString("passwd");
		            System.out.println(playername + "\t" + playerID +
		                               "\t" + passwd );
		        }


		        rs.close();
		        stmt.close();
		        con.close();
		    } catch (SQLException sqlex) {

		    }
		    //finally {
		        //if (stmt != null)
		        //{ stmt.close();
		        //}
		    //}
	}


}