Install mplayer on Centos 7

Question

I'm having trouble inserting data inside my database..this is my codes looks like..

rs = stat.executeQuery("Select * from students;");
while (rs.next()) {
    idNum = rs.getString("idNum");
    stat.executeUpdate(
        "INSERT INTO record VALUES (null,'" + idNum + "','" + descript +
             "'," + value + ",'" + user.getText() + "','" + timeStamp + "')"
                            );
}//while

As you can see I want to insert a data for every student rs = stat.executeQuery("Select * from students;"); and get all their student number idNum = rs.getString("idNum"); this is what inside the students table:

idNum..............Name

11000001.........Leonardo

11000002.........David

11000003.........Robert

11000004.........Anna

11000005.........May

now when I get all their idNum I want them to be inserted inside the table record that will looks like this:

idNum.........descript.........amount........blablablabla

11000001.......Fee...............30

11000002.......Fee...............30

11000003.......Fee...............30

11000004.......Fee...............30

11000005.......Fee...............30

the problem is only the first idNum is being inserted inside the table record like this:

idNum.........descript.........amount........blablablabla

11000001.......Fee...............30

Solution 1

Thank you for your help, I find a solution, I've download on rpmfind.net and install the missing dependencies one by one but for Fedora 20 64 bits (dependencies for Fedora 19 64 bits is uncomplete), it works perfectly.

Solution 2

Mplayer for EL7/CentOS7 is in RPM Fusion.

So just do

curl -O https://download1.rpmfusion.org/free/el/rpmfusion-free-release-7.noarch.rpm

to get the Free repo RPM, plus

curl -O https://download1.rpmfusion.org/nonfree/el/rpmfusion-nonfree-release-7.noarch.rpm

if you also want the non-free codecs, then do

sudo yum localinstall *.rpm

and then

sudo yum install mplayer

Comments

[user1469306]

It may be multiple repos offering mplayer and treading on each other's feet. Have you tried using --disablerepo=atrpms, to get purely rpmforge-based components?

[Nathan C]

I don't think the atrpms repo is right ...I found the RPM here: rpmfind.net/linux/RPM/atrpms/el7/x86_64/stable/index.html I would expect the entry to be atrpms/el7/x86_64 and not atrpms/7/x86_64.

[Admin]

mplayer is not on any other repo i use, only on atrpms. I've reinstall atrpms with your link, but nothing has changed the entry is atrpms/7/x86_64. I think the problem is that the libraries were not updated for Centos 7 but I would find a way to make it work on Centos 7 beacause downgrade to Centos 6 would be problematic for me.

[Nathan C]

You might be stuck compiling it from source in that case.

[Amitav Pajni]

Unless you're actually looking for mencoder, you're probably better off using a different video player, such as vlc.

[PhantomKid]

so i just need to remove the stat from this? stat.executeUpdate( "INSERT INTO record VALUES (null,'" + idNum + "','" + descript + "'," + value + ",'" + user.getText() + "','" + timeStamp + "')" );

[Md. Abdul Bari]

ArrayList list = new ArrayList(); while (rs.next()) { list.add(rs.getString("idNum"));} for(int i=0; i<list.size(); i++){stat2.executeUpdate( "INSERT INTO record VALUES (null,'" + list.get(i) + "','" + descript + "'," + value + ",'" + user.getText() + "','" + timeStamp + "')" );}

[PhantomKid]

when i compiled it says ... Blank.java uses unchecked or unsafe operations how can i fix that?

[upog]

i guess that is only the warning as you have not specified the object type that the array collection stores

[PhantomKid]

thank you CL. i really really appreciate it alot.. =]

[G. Gotchel]

FWIW, this technique shown by @Tantallion worked fine on Sci Linux 7.6 (Nitrogen) with the exact commands shown. I liked this technique because it showed precise commands.