get files from database

[Bobes Calin]

Hello! I want to make a litle backup tool in java.I made a sample java class that stores files in mysql database:

  
public class SaveFileDB 
{
public static void main(String[] args) throws SQLException
{
Connection conn = null;
String url = "jdbc:mysql://localhost:3306/bak";
ResultSet rs = null;
PreparedStatement ps = null;
FileInputStream fis;

try
{
Class.forName("com.mysql.jdbc.Driver").newInstance();
conn = DriverManager.getConnection(url,"root","1234");
String fileName = "/home/calin/Desktop/nature.jpg";
File file = new File(fileName);
String sql = "insert into save_files(name,file)" +  "values(" + "\"" + fileName + "\"," + "?);";
ps = conn.prepareStatement(sql);
fis = new FileInputStream(file);
ps.setBinaryStream(1, (InputStream)fis, (int)(file.length()));
int s = ps.executeUpdate();
if(s>0) 
{
System.out.println("Uploaded successfully !");
}
else 
{
System.out.println("unsucessfull to upload file.");
}

System.out.println(sql);

}
catch (Exception e)
{
e.printStackTrace();
}

finally 
{
// close all the connections.
conn.close();
ps.close();
}
 
}
}

The save_files table look like this:

  
+-------+-------------+------+-----+---------+----------------+
| Field | Type        | Null | Key | Default | Extra          |
+-------+-------------+------+-----+---------+----------------+
| id    | int(5)      | NO   | PRI | NULL    | auto_increment | 
| name  | varchar(40) | NO   |     | NULL    |                | 
| file  | longblob    | NO   |     | NULL    |                | 
+-------+-------------+------+-----+---------+----------------+
 

i can put files in the database.

The problem is how can i get the files out from the database? did i made a good choice to store the files into a database?

Thakyou, Calin

[Dragan Jovanovic]

Of course you can read it.
Just make a select statement, retrieve it to ResultSet object, and you can access that blob with ResultSet.getBytes() method. It returns byte[].