import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;
import java.sql.ResultSet;
public class DBConnect {

    private Connection con;
    private Statement st;
    private ResultSet rs;

    public DBConnect(){
        try{
            Class.forName("com.mysql.cj.jdbc.Driver");

            con = DriverManager.getConnection("jdbc:mysql://localhost:3306/baseplace?&serverTimezone=UTC","root","");

            st = con.createStatement();

        }catch(Exception ex){
            System.out.println("Error"+ex);
        }
    }

    public void getData(){
        try{

            String query = "select * from place";
            rs = st.executeQuery(query);
            System.err.println("Records from place");
            while(rs.next()){
                String name = rs.getString("name");
                String city = rs.getString("city");
                String desc = rs.getString("desc");
                String posX = rs.getString("posX");
                String posY = rs.getString("posY");
                System.out.println("name "+name +" city "+city+" desc "+desc+" posX "+posX+" posY "+posY);
            }

        }catch(Exception ex){
            System.err.println(ex);
        }
    }
}