Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

Interesting : JDBC getting database information

goproggoprog Member Posts: 7
How to get
1. the names of databases in a MySQL server
2. the names of tables in the database
3. types and names of fields in a table

all using JDBC in Java code. I need the information to create a dynamic form that changes according to the tables and fields.

Comments

  • JonathanJonathan Member Posts: 2,914
    : How to get
    : 1. the names of databases in a MySQL server
    : 2. the names of tables in the database
    : 3. types and names of fields in a table
    :
    : all using JDBC in Java code. I need the information to create a dynamic form that changes according to the tables and fields.
    :
    http://www.mysql.com/doc/en/Show_database_info.html

    Jonathan

    ###
    for(74,117,115,116){$::a.=chr};(($_.='qwertyui')&&
    (tr/yuiqwert/her anot/))for($::b);for($::c){$_.=$^X;
    /(p.{2}l)/;$_=$1}$::b=~/(..)$/;print("$::a$::b $::c hack$1.");

  • goproggoprog Member Posts: 7

    : http://www.mysql.com/doc/en/Show_database_info.html

    checking now.
    Thanks. Rather simple eh?

    Am i allowed to post such simle questions?
    (Please don't give a "forum rules link" for this , as an answer) (:-)
  • JonathanJonathan Member Posts: 2,914
    : : http://www.mysql.com/doc/en/Show_database_info.html
    :
    : checking now.
    : Thanks. Rather simple eh?
    :
    Yeah, I've done some work with this kind of thing before (not from JAVA though) and it's reasonably straightforward.

    : Am i allowed to post such simle questions?
    : (Please don't give a "forum rules link" for this , as an answer) (:-)
    :
    Sure you are - it was about MySQL so it's completely fine. My pasting in a link wasn't a "read the fine manual" thing; I just didn't really have anything to add to it as the manual page explains it quite well. :-)

    Jonathan

    ###
    for(74,117,115,116){$::a.=chr};(($_.='qwertyui')&&
    (tr/yuiqwert/her anot/))for($::b);for($::c){$_.=$^X;
    /(p.{2}l)/;$_=$1}$::b=~/(..)$/;print("$::a$::b $::c hack$1.");

  • goproggoprog Member Posts: 7
    : : Am i allowed to post such simle questions?
    : : (Please don't give a "forum rules link" for this , as an answer) :-)
    : :
    : Sure you are - it was about MySQL so it's completely fine. My pasting in a link wasn't a "read the fine manual" thing; I just didn't really have anything to add to it as the manual page explains it quite well. :-)

    Thanks a lot.
    until we meet again. bye:-)
Sign In or Register to comment.