private void moviesMouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_moviesMouseClicked
        try {
            int row = movies.getSelectedRow();
            String movieId = movies.getModel().getValueAt(row, 0).toString();
            String s = (movies.getModel().getValueAt(row,0).toString());
            String sql = "SELECT * FROM movies WHERE movieID=" + s;
            //            pst = conn.prepareStatement(sql);
            /*ResultSet rs = db.executeQuery(sql); //TODO fix this so it populates the blanks
            if(rs.next()){
                String add1 =rs.getString("title");
                titleTxt.setText(add1);

                String add2 =rs.getString("actor");
                actorTxt.setText(add2);

                String add3 =rs.getString("userRating");
                userRatingTxt.setText(add3);

                String add4 =rs.getString("mpaaRating");
                mpaarRatingTxt.setText(add4);

                String add5 =rs.getString("director");
                directorTxt.setText(add5);
            }*/

        }
        catch(Exception e) {
            System.out.println(e);
        }
    }