Hi
I have a program code in java which is able to retrive and store information in text in a Access database but need the program to be able to do same for Images. Please can anyone help.
Code Below
import java.awt.image.*;
import java.awt.*;
import java.sql.*;
import java.util.*;
import javax.swing.*;
public class Histogram extends JFrame {
//JDBc driver name and database URL
static final String driver= "sun.jdbc.odbc.JdbcOdbcDriver";
static final String url="jdbc
dbc:Histogram Database_1";
//declare Connection and Statement for accessing and querying database
private Connection connection;
private Statement statement;
//Constructor connects to database, quries database, processes
//results and display results in window
public Histogram()
{
super("Picture Table of Histogram Database_1");
//connect to database Histogram and query database
try{
//load database driver class
Class.forName(driver);
//establish connection to database
connection = DriverManager.getConnection(url);
//create Statement for querying database
statement = connection.createStatement();
//query database
ResultSet resultSet =
statement.executeQuery("SELECT Filename FROM PictureTable");
/////////////$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$
//String CurrentFile = NULL;
//Image image1.open(CurrentFile);
//CurrentFile = statement.executeQuery("SELECT Filename FROM PictureTable WHERE PictureID=1");
////////////$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$
//process query result
StringBuffer results = new StringBuffer();
ResultSetMetaData metaData = resultSet.getMetaData();
int numberOfColumns = metaData.getColumnCount();
for(int i = 1; i <=numberOfColumns; i++ )
results.append( metaData.getColumnName(i) + "\t");
results.append("\n");
while( resultSet.next()){
for(int i = 1; i <=numberOfColumns; i++)
results.append( resultSet.getObject(i) + "\t");
results.append("\n");
}
//set up GUI and display window
JTextArea textArea = new JTextArea( results.toString() );
Container container = getContentPane();
container.add( new JScrollPane( textArea ) );
setSize(300, 100 );
setVisible(true);
}
//detect problem interacting with the database
catch ( SQLException sqlException ) {
JOptionPane.showMessageDialog ( null, sqlException.getMessage(),
"Database Error", JOptionPane.ERROR_MESSAGE );
System.exit(1);
}
//detect problem loading database driver
catch ( ClassNotFoundException classNotFound ){
JOptionPane.showMessageDialog ( null, classNotFound.getMessage(),
"Driver Not Found", JOptionPane.ERROR_MESSAGE );
System.exit(1);
}
//ensure statement and connection are closed properly
finally{
try{
statement.close();
connection.close();
}
//handle exception closing statement and connection
catch ( SQLException sqlException ) {
JOptionPane.showMessageDialog( null, sqlException.getMessage(), "Database Error",
JOptionPane.ERROR_MESSAGE );
System.exit(1);
}
}
}//end Histogram Database_1
//Lunch the application
public static void main( String args[] )
{
//error found here
Histogram window = new Histogram();
window.setDefaultCloseOperation( JFrame.EXIT_ON_CLOSE);
}
}//end class Histogram Database_1