Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie
Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

Java/Mysql Please help me

  • 16-07-2009 1:40am
    #1
    SoItsMe
    Closed Accounts Posts: 32 ✭


    Hey guys. I am working on a project for college using java and mysql. I so far have managed to successfully connect to the mysql through java, and view the records in the database, but after this point I become stuck. I am developing this project on a vista operating system.

    Basically I need to be able to insert, delete and update information on the tables in my database through a java gui, and run various other queries on the database. I have exhausted google and cannot seem to find any good examples or tutorials to help me out. Nearly everything I have come across has been to do with netbeans.

    I am now desperate at this stage. If anybody can offer any help, idea's or tips it would very much appreciated.

    Many thanks


Comments

  • #2
    Idleater
    Registered Users, Registered Users 2 Posts: 6,236 ✭✭✭Idleater


    netbeans is an ide or Integrated development environment. It is one tool that can aid you when writing code by providing syntax highlighting, available options, class navigation etc as well as graphical wizards for doing things like connecting to databases.
    What are you using for writing your code at the moment? If it's not an ide, i'd suggest downloading one as a first port of call. Netbeans is okay, but i prefer eclipse. Both are free.
    Next you will have to outline further what you are actually using- java swing or Web front end? Ejb? Jpa?...
    If it is a simple web fronted database there are possibly easier tools than java. If it is a learning experience, provide more background.


  • #3
    SoItsMe
    Closed Accounts Posts: 32 ✭SoItsMe


    I have just been typing all my code up using edit plus. It is java swing that I am using.
    Basically the project that I am trying to create is a staff scheduling system. I need to have a database which stores all employee information such as their personal details, their work details, their availabilty to work, and their holidays. I then need to be able to query the database to tell me which staff are available to work and when. I also need to be able to insert, delete and update this information in the database. Basically I any processing that I do on the database needs to be done through java, and I need to have a nice gui on the whole system.


  • #4
    Giblet
    Registered Users, Registered Users 2 Posts: 11,989 ✭✭✭✭Giblet


    You need to set up a query using the java sql library. If you can do a select, you can do an update. Have a look at Prepared statements in java. Get a simple insert working just through java, then try get column data from a textbox when doing an insert, and build it up from there.


  • #5
    marco_polo
    Moderators, Science, Health & Environment Moderators Posts: 10,088 Mod ✭✭✭✭marco_polo


    If this is something you need to get done in a hurry then Hibernate is your friend (bit of a learning curve but not too bad for simpler tasks like insertions etc), plenty of tutorials available too. If it is just educational then no harm to do it with JDBC so you get a better feel of how it all works.


Advertisement