Results 1 to 6 of 6
  1. #1
    Join Date
    Sep 2011
    Posts
    10
    Rep Power
    0

    Default Java interface for Mysql DB

    I am currently enrolled in a Database course that requires the creation of a simple database. I believe that my teacher expects us to use php as an interface between the database. He left the end-user interface fairly open. I was wondering what the creation of a Java interface would entail. Does Java use php to interact with the database?? I am familiar with basic Java constructs. I know that the swing library is a way of easily creating a user interface. Is there a way to tie all of this together to create this interface? Any help is appreciated. Even pointing me in the direction of a tutorial would be of much help.
    Last edited by TerminatingZero; 02-15-2012 at 08:00 PM.

  2. #2
    doWhile is offline Moderator
    Join Date
    Jul 2010
    Location
    California
    Posts
    1,642
    Rep Power
    7

    Default Re: Java interface for Mysql DB

    Are you familiar with how to use JDBC? If not, it allows you to create SQL queries directly in java code. See Trail: JDBC(TM) Database Access (The Java™ Tutorials)

  3. #3
    Join Date
    Sep 2011
    Posts
    10
    Rep Power
    0

    Default Re: Java interface for Mysql DB

    No, I have no knowledge of this API. I'm looking into it now. I feel like I should know more about this. Does this require any extra server side software packages? If so I will probably be required to scrap the idea because I doubt I can get the systems workers to deploy any extra software for just one student. So for the most part SQL queries are called through this API?

  4. #4
    Tolls is offline Moderator
    Join Date
    Apr 2009
    Posts
    12,009
    Rep Power
    20

    Default Re: Java interface for Mysql DB

    Do you have to use PHP?
    What is the current architecture?
    You mention server-side software, so is that a web server, or simply the database on the network?

  5. #5
    Join Date
    Sep 2011
    Posts
    10
    Rep Power
    0

    Default Re: Java interface for Mysql DB

    Well I am not sure if I am restricted to PHP. I plan on asking the professor in class tomorrow. I want to get his feed back. I believe there is a server on campus that we can host a site for. The two interfaces that my professor mentioned was a web interface or a terminal interface(using PHP). I believe that the server is an Apache server. I access the database through an SSH connection to the linux server running on campus. From there I can use the mysql terminal interface. We can also use PHPmyadmin.

    So for the most part I just need to create an end-user interface. I felt like Java would be the best because I am more accustom to it. I also want a more intuitive interface. Seeing as I am not well versed in web programming, I feel that a webpage is out of the question.

  6. #6
    Tolls is offline Moderator
    Join Date
    Apr 2009
    Posts
    12,009
    Rep Power
    20

    Default Re: Java interface for Mysql DB

    Until you get clarification of what you are targhetting it's going to be difficult to provide any pointers.

Similar Threads

  1. Help with Java Interface.
    By NewbieJavie in forum New To Java
    Replies: 17
    Last Post: 04-09-2011, 08:02 AM
  2. Replies: 1
    Last Post: 05-31-2009, 10:57 PM
  3. Replies: 1
    Last Post: 05-31-2009, 02:17 PM
  4. Replies: 16
    Last Post: 05-28-2009, 03:41 PM
  5. MySQL/JDBC Mysql query output
    By thelinuxguy in forum Advanced Java
    Replies: 4
    Last Post: 02-13-2009, 01:57 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •