Writing a Script for MySQL or Java

Question

I need to make a data file to hold two empty tables with many fields I have been successful at making a MySQL 5.5 Table with its DOS style IDE OK. And MySQL registers with NetBeans very well.

Can I make a script to build this from with in my program or can this be done directly in Java and get a Java file to read file parameters as its executed to create the data base file name.

I have no idea what direction to take to do this and what's possible. I'm writing in Java and Delphi and Delphi has no MySQL support. Has any one done anything similar before and how did they do it

The database is to hold 70 meduim size pictures, How slow will updates be when accessing pictures and should I use JPEG or BMP storage for wireless Java apps? Can Java manage JPEG files and display them?

you can easily execute DDL (your script to create database) using jdbc in java. — kdabir
– kdabir, Commented Aug 5, 2011 at 0:05

Alistair A. Israel · Accepted Answer · 2011-08-05 00:09:54Z

Lots of questions in one post. Let me try to address each point individually.

Yes, you can write Java code to create your MySQL database for you. On the other hand, tools such Liquibase can do this for you—you just need to learn its XML configuration syntax.
Lots of people have successfully written Java and Delphi code to access MySQL databases. If I recall correctly, at the very least Delphi supports MySQL access through ODBC, if not, through 3rd-party custom components.
Java can store & retrieve JPEG images to/from a database just like any other language, though, in practice, I wouldn't do it that way. Rather, I'd store the images themselves in the file system and just store their locations in the database. RDBMSes weren't really built with handling large binary BLOBs in mind.
How would you like to display the images? If on screen via a desktop client, then, yes, Java's Swing components can easily and readily display JPEG, even GIF & PNG images. If via a Web browser or remote client, then it's really just a matter of serving the images over HTTP to the browser/client app.

Collectives™ on Stack Overflow

Writing a Script for MySQL or Java

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related