How to upload file to MySQL database in java application GUI?

[ding]

I am facing problem to writting file to MySQL database in java application. Can show me a example code? Thanks!

[sicarie]

I am facing problem to writting file to MySQL database in java application. Can show me a example code? Thanks!

Have a look at this.

What part are you having trouble with?

[ding]

Have a look at this.

What part are you having trouble with?

I trouble in part reading file from FileChooser.

[sicarie]

What trouble are you having with FileChoosers? Is there an error message, are you not getting the right directory....?

[ding]

What trouble are you having with FileChoosers? Is there an error message, are you not getting the right directory....?

I create two function. one is for looking file function while another is upload file function. I have error when sending filename from looking file function to upload file function.

The error code is:

incompatible types
found : java.io.File
required: java.lang.String
String fileName = actionFindfile();
^
1 error

Tool completed with exit code 1

[sicarie]

I create two function. one is for looking file function while another is upload file function. I have error when sending filename from looking file function to upload file function.

The error code is:

incompatible types
found : java.io.File
required: java.lang.String
String fileName = actionFindfile();
^
1 error

Tool completed with exit code 1

Ok, so it's saying that actionFindfile() is not returning a String. Can you post the declaration of actionFindfile()?

[ding]

Ok, so it's saying that actionFindfile() is not returning a String. Can you post the declaration of actionFindfile()?

The declaration of actionFindfile is:

public File actionFindfile() {

JFileChooser fileChooser = new JFileChooser();
fileChooser.setFileSelectionMode( JFileChooser.FILES_AND_DIRECTORIES);

int result = fileChooser.showOpenDialog(this);
if(result == JFileChooser.CANCEL_OPTION)
System.exit(1);

File fileName = fileChooser.getSelectedFile();

if ((fileName == null) || (fileName.getName().equals("")))
{
JOptionPane.showMessageDialog(this, "Invalid File Name", "Invalid File Name", JOptionPane.ERROR_MESSAGE);
System.exit(1);
}
return fileName;

}

[sicarie]

The declaration of actionFindfile is:

public File actionFindfile() {

JFileChooser fileChooser = new JFileChooser();
fileChooser.setFileSelectionMode( JFileChooser.FILES_AND_DIRECTORIES);

int result = fileChooser.showOpenDialog(this);
if(result == JFileChooser.CANCEL_OPTION)
System.exit(1);

File fileName = fileChooser.getSelectedFile();

if ((fileName == null) || (fileName.getName().equals("")))
{
JOptionPane.showMessageDialog(this, "Invalid File Name", "Invalid File Name", JOptionPane.ERROR_MESSAGE);
System.exit(1);
}
return fileName;

}

And there's your issue. You are returning a File, and trying to save it in a String. What do you want to do here? Turn the filename into a string, or just return the file and use it later?

[ding]

And there's your issue. You are returning a File, and trying to save it in a String. What do you want to do here? Turn the filename into a string, or just return the file and use it later?

i wan to return the value of the file and filename. And both will be calling in function upload file so tat file can be upload.

[sicarie]

i wan to return the value of the file and filename. And both will be calling in function upload file so tat file can be upload.

So to get your code working, you can change your declaration to File (instead of String). That will remove that code, and then you can use the getFileName function you use in the actionFindfile to get the name - I'm pretty sure that returns a string.

[ding]

So to get your code working, you can change your declaration to File (instead of String). That will remove that code, and then you can use the getFileName function you use in the actionFindfile to get the name - I'm pretty sure that returns a string.

So how to get the value of file in function upload file?

[sicarie]

So how to get the value of file in function upload file?

Not sure what you are asking. As long as you declare it as File, you can call that same function to get the filename, and then pass that variable you declared.

[ding]

Not sure what you are asking. As long as you declare it as File, you can call that same function to get the filename, and then pass that variable you declared.

I have error in function upload file
The code is :

private void actionAdd() {

Class.forName("com.mysql.jdbc.Driver");
Connection con=DriverManager.getConnection("jdbc:mysql://localhost/im","root","1234");

File fileName = actionFindfile();
PreparedStatement ps = con.prepareStatement("insert into assignment values('henry','"+fileName.toString() + "',?)");
int fileLength = (int) fileName.length();
InputStream streamedFile = new FileInputStream(fileName);
ps.setBinaryStream(1, streamedFile, fileLength);
ps.executeUpdate();
ps.close();
streamedFile.close();

}

[sicarie]

I have error in function upload file
The code is :

private void actionAdd() {

Class.forName("com.mysql.jdbc.Driver");
Connection con=DriverManager.getConnection("jdbc:mysql://localhost/im","root","1234");

File fileName = actionFindfile();
PreparedStatement ps = con.prepareStatement("insert into assignment values('henry','"+fileName.toString() + "',?)");
int fileLength = (int) fileName.length();
InputStream streamedFile = new FileInputStream(fileName);
ps.setBinaryStream(1, streamedFile, fileLength);
ps.executeUpdate();
ps.close();
streamedFile.close();

}

Ummmm, I wouldn't recommend connecting as root, but besides that... did you associate the driver with the project, either in the classpath, or attach it as a library?

[ding]

Ummmm, I wouldn't recommend connecting as root, but besides that... did you associate the driver with the project, either in the classpath, or attach it as a library?

i already install JDBC driver and already successful connecting to database through other program.

[ding]

I have successfully run the code. However it call back the function FileChooser in function upload file. This is not what i want and i just want to pass the value.How to solve this?

[r035198x]

I have successfully run the code. However it call back the function FileChooser in function upload file. This is not what i want and i just want to pass the value.How to solve this?

Can you explain more? When is it calling back FileChooser?

[ding]

Can you explain more? When is it calling back FileChooser?

The function fileChooser is calling when i click the button "browse". When the file was chooser, i need to pass the value and name of the file to function upload so that when i click the button "upload" it can automatic get the value and save it to database. So how to call the value between two function?

[r035198x]

The function fileChooser is calling when i click the button "browse". When the file was chooser, i need to pass the value and name of the file to function upload so that when i click the button "upload" it can automatic get the value and save it to database. So how to call the value between two function?

Maybe if you post the full code we can understand better what you are trying to do.

[ding]

Maybe if you post the full code we can understand better what you are trying to do.

This is my code
please help:

import java.awt.BorderLayout;
import java.awt.Component;
import java.awt.event.*;
import java.io.*;
import javax.swing.*;
import java.sql.*;


public class JUploadManager extends JFrame {

private JTextField addTextField = new JTextField(30);

public JUploadManager() {

super(":::Upload Manager:::");

setSize(600, 300);
addWindowListener(new WindowAdapter() {
public void windowClosing(WindowEvent e) {
System.exit(0);
}
});
JMenuBar menuBar = new JMenuBar();
JMenu fileMenu = new JMenu("File");
fileMenu.setMnemonic(KeyEvent.VK_F);
JMenuItem fileExitMenuItem = new JMenuItem("Exit", KeyEvent.VK_X);
fileExitMenuItem.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent e) {


}
});
fileMenu.add(fileExitMenuItem);
menuBar.add(fileMenu);
setJMenuBar(menuBar);

// Set up add panel.
JPanel addPanel = new JPanel();

addPanel.add(addTextField);
JButton addButton = new JButton("Upload");
addButton.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent e) {
actionAdd();
}
});
JButton findButton = new JButton("Find File");
findButton.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent e) {
actionFindfile();
}
});
addPanel.add(findButton);
addPanel.add(addButton);


JPanel buttonsPanel = new JPanel();



getContentPane().setLayout(new BorderLayout());
getContentPane().add(addPanel, BorderLayout.NORTH);


}

private void actionAdd() {
File fileName = actionFindfile();
try
{
Class.forName("com.mysql.jdbc.Driver");
Connection con=DriverManager.getConnection("jdbc:mysql://localhost/im","root","1234");


PreparedStatement ps = con.prepareStatement("insert into assignment values('henry','"+fileName.getName() + "',?)");
int fileLength = (int) fileName.length();
InputStream streamedFile = new FileInputStream(fileName);
ps.setBinaryStream(1, streamedFile, fileLength);
ps.executeUpdate();
ps.close();
streamedFile.close();
}
catch(Exception err)
{
System.err.println("Exception: " + err.getMessage());
}


}

public File actionFindfile() {

JFileChooser fileChooser = new JFileChooser();
fileChooser.setFileSelectionMode( JFileChooser.FILES_AND_DIRECTORIES);

int result = fileChooser.showOpenDialog(this);
if(result == JFileChooser.CANCEL_OPTION)
System.exit(1);

File fileName = fileChooser.getSelectedFile();

if ((fileName == null) || (fileName.getName().equals("")))
{
JOptionPane.showMessageDialog(this, "Invalid File Name", "Invalid File Name", JOptionPane.ERROR_MESSAGE);
System.exit(1);
}
return fileName;

}



// Run the Upload Manager.
public static void main(String[] args) {
JUploadManager manager = new JUploadManager();
manager.setVisible(true);
}

}

[r035198x]

This is my code
please help:

import java.awt.BorderLayout;
import java.awt.Component;
import java.awt.event.*;
import java.io.*;
import javax.swing.*;
import java.sql.*;


public class JUploadManager extends JFrame {

private JTextField addTextField = new JTextField(30);

public JUploadManager() {

super(":::Upload Manager:::");

setSize(600, 300);
addWindowListener(new WindowAdapter() {
public void windowClosing(WindowEvent e) {
System.exit(0);
}
});
JMenuBar menuBar = new JMenuBar();
JMenu fileMenu = new JMenu("File");
fileMenu.setMnemonic(KeyEvent.VK_F);
JMenuItem fileExitMenuItem = new JMenuItem("Exit", KeyEvent.VK_X);
fileExitMenuItem.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent e) {


}
});
fileMenu.add(fileExitMenuItem);
menuBar.add(fileMenu);
setJMenuBar(menuBar);

// Set up add panel.
JPanel addPanel = new JPanel();

addPanel.add(addTextField);
JButton addButton = new JButton("Upload");
addButton.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent e) {
actionAdd();
}
});
JButton findButton = new JButton("Find File");
findButton.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent e) {
actionFindfile();
}
});
addPanel.add(findButton);
addPanel.add(addButton);


JPanel buttonsPanel = new JPanel();



getContentPane().setLayout(new BorderLayout());
getContentPane().add(addPanel, BorderLayout.NORTH);


}

private void actionAdd() {
File fileName = actionFindfile();
try
{
Class.forName("com.mysql.jdbc.Driver");
Connection con=DriverManager.getConnection("jdbc:mysql://localhost/im","root","1234");


PreparedStatement ps = con.prepareStatement("insert into assignment values('henry','"+fileName.getName() + "',?)");
int fileLength = (int) fileName.length();
InputStream streamedFile = new FileInputStream(fileName);
ps.setBinaryStream(1, streamedFile, fileLength);
ps.executeUpdate();
ps.close();
streamedFile.close();
}
catch(Exception err)
{
System.err.println("Exception: " + err.getMessage());
}


}

public File actionFindfile() {

JFileChooser fileChooser = new JFileChooser();
fileChooser.setFileSelectionMode( JFileChooser.FILES_AND_DIRECTORIES);

int result = fileChooser.showOpenDialog(this);
if(result == JFileChooser.CANCEL_OPTION)
System.exit(1);

File fileName = fileChooser.getSelectedFile();

if ((fileName == null) || (fileName.getName().equals("")))
{
JOptionPane.showMessageDialog(this, "Invalid File Name", "Invalid File Name", JOptionPane.ERROR_MESSAGE);
System.exit(1);
}
return fileName;

}



// Run the Upload Manager.
public static void main(String[] args) {
JUploadManager manager = new JUploadManager();
manager.setVisible(true);
}

}

You can use code tags next time when posting code like I've done here

 
import java.awt.BorderLayout;
import java.awt.Component;
import java.awt.event.*;
import java.io.*;
import javax.swing.*;
import java.sql.*;
 
public class JUploadManager extends JFrame {
 private JTextField addTextField = new JTextField(30);
 public JUploadManager() {
  super(":::Upload Manager:::");
  setSize(600, 300);
  addWindowListener(new WindowAdapter() {
  public void windowClosing(WindowEvent e) {
   System.exit(0);
   }
  });
  JMenuBar menuBar = new JMenuBar();
  JMenu fileMenu = new JMenu("File");
  fileMenu.setMnemonic(KeyEvent.VK_F);
  JMenuItem fileExitMenuItem = new JMenuItem("Exit", KeyEvent.VK_X);
  fileExitMenuItem.addActionListener(new ActionListener() {
  public void actionPerformed(ActionEvent e) {
 
  }
  });
  fileMenu.add(fileExitMenuItem);
  menuBar.add(fileMenu);
  setJMenuBar(menuBar); 
  // Set up add panel.
  JPanel addPanel = new JPanel();
  addPanel.add(addTextField);
  JButton addButton = new JButton("Upload");
  addButton.addActionListener(new ActionListener() {
  public void actionPerformed(ActionEvent e) {
  actionAdd();
  }
  });
  JButton findButton = new JButton("Find File");
  findButton.addActionListener(new ActionListener() {
  public void actionPerformed(ActionEvent e) {
  actionFindfile();
  }
  });
  addPanel.add(findButton);
  addPanel.add(addButton);
  JPanel buttonsPanel = new JPanel();
  getContentPane().setLayout(new BorderLayout());
  getContentPane().add(addPanel, BorderLayout.NORTH);
 
 }
 
 private void actionAdd() {
  File fileName = new File(addTextField.getText()); //changed here
  try {
   Class.forName("com.mysql.jdbc.Driver");
   Connection con=DriverManager.getConnection("jdbc:mysql://localhost/im","root","1234");
   PreparedStatement ps = con.prepareStatement("insert into assignment values('henry','"+fileName.getName() + "',?)");
   int fileLength = (int) fileName.length();
   InputStream streamedFile = new FileInputStream(fileName);
   ps.setBinaryStream(1, streamedFile, fileLength);
   ps.executeUpdate();
   ps.close();
   streamedFile.close();
  }
  catch(Exception err) {
   System.err.println("Exception: " + err.getMessage());
  }
 }
 public File actionFindfile() {
  JFileChooser fileChooser = new JFileChooser();
  fileChooser.setFileSelectionMode( JFileChooser.FILES_AND_DIRECTORIES);
  int result = fileChooser.showOpenDialog(this);
  if(result == JFileChooser.CANCEL_OPTION)
  System.exit(1);
  File fileName = fileChooser.getSelectedFile();
  if ((fileName == null) || (fileName.getName().equals(""))) {
   JOptionPane.showMessageDialog(this, "Invalid File Name", "Invalid File Name", JOptionPane.ERROR_MESSAGE);
      System.exit(1);
  }
  addTextField.setText(fileName.getName()); //added here
  return fileName;
    }
 // Run the Upload Manager.
 public static void main(String[] args) {
  JUploadManager manager = new JUploadManager();
  manager.setVisible(true);
 }
}
 
 

[ding]

You can use code tags next time when posting code like I've done here

 
import java.awt.BorderLayout;
import java.awt.Component;
import java.awt.event.*;
import java.io.*;
import javax.swing.*;
import java.sql.*;
 
public class JUploadManager extends JFrame {
 private JTextField addTextField = new JTextField(30);
 public JUploadManager() {
  super(":::Upload Manager:::");
  setSize(600, 300);
  addWindowListener(new WindowAdapter() {
  public void windowClosing(WindowEvent e) {
   System.exit(0);
   }
  });
  JMenuBar menuBar = new JMenuBar();
  JMenu fileMenu = new JMenu("File");
  fileMenu.setMnemonic(KeyEvent.VK_F);
  JMenuItem fileExitMenuItem = new JMenuItem("Exit", KeyEvent.VK_X);
  fileExitMenuItem.addActionListener(new ActionListener() {
  public void actionPerformed(ActionEvent e) {
 
  }
  });
  fileMenu.add(fileExitMenuItem);
  menuBar.add(fileMenu);
  setJMenuBar(menuBar); 
  // Set up add panel.
  JPanel addPanel = new JPanel();
  addPanel.add(addTextField);
  JButton addButton = new JButton("Upload");
  addButton.addActionListener(new ActionListener() {
  public void actionPerformed(ActionEvent e) {
  actionAdd();
  }
  });
  JButton findButton = new JButton("Find File");
  findButton.addActionListener(new ActionListener() {
  public void actionPerformed(ActionEvent e) {
  actionFindfile();
  }
  });
  addPanel.add(findButton);
  addPanel.add(addButton);
  JPanel buttonsPanel = new JPanel();
  getContentPane().setLayout(new BorderLayout());
  getContentPane().add(addPanel, BorderLayout.NORTH);
 
 }
 
 private void actionAdd() {
  File fileName = new File(addTextField.getText()); //changed here
  try {
   Class.forName("com.mysql.jdbc.Driver");
   Connection con=DriverManager.getConnection("jdbc:mysql://localhost/im","root","1234");
   PreparedStatement ps = con.prepareStatement("insert into assignment values('henry','"+fileName.getName() + "',?)");
   int fileLength = (int) fileName.length();
   InputStream streamedFile = new FileInputStream(fileName);
   ps.setBinaryStream(1, streamedFile, fileLength);
   ps.executeUpdate();
   ps.close();
   streamedFile.close();
  }
  catch(Exception err) {
   System.err.println("Exception: " + err.getMessage());
  }
 }
 public File actionFindfile() {
  JFileChooser fileChooser = new JFileChooser();
  fileChooser.setFileSelectionMode( JFileChooser.FILES_AND_DIRECTORIES);
  int result = fileChooser.showOpenDialog(this);
  if(result == JFileChooser.CANCEL_OPTION)
  System.exit(1);
  File fileName = fileChooser.getSelectedFile();
  if ((fileName == null) || (fileName.getName().equals(""))) {
   JOptionPane.showMessageDialog(this, "Invalid File Name", "Invalid File Name", JOptionPane.ERROR_MESSAGE);
      System.exit(1);
  }
  addTextField.setText(fileName.getName()); //added here
  return fileName;
    }
 // Run the Upload Manager.
 public static void main(String[] args) {
  JUploadManager manager = new JUploadManager();
  manager.setVisible(true);
 }
}
 
 

Thanks for helping. However now i facing problem for upload file to database.
The error code is:
Exception: BlobTest.java (The system cannot find the file specified)