/*
* To change this template, choose Tools | Templates
* and open the template in the editor.
*/
/*
* JF_Meliante.java
*
* Created on 04/08/2010, 07:53:57
*/
package riapi;
/**
*
* @author Adriano
*/
import javax.swing.ImageIcon;
import javax.swing.JFileChooser;
import javax.swing.JOptionPane;
public class JF_Meliante extends javax.swing.JFrame {
/** Creates new form JF_Meliante */
public JF_Meliante() {
initComponents();
}
/** This method is called from within the constructor to
* initialize the form.
* WARNING: Do NOT modify this code. The content of this method is
* always regenerated by the Form Editor.
*/
@SuppressWarnings("unchecked")
// <editor-fold defaultstate="collapsed" desc="Generated Code">
private void initComponents() {
jLabel_Nome = new javax.swing.JLabel();
jLabel_Tel = new javax.swing.JLabel();
jLabel_RG = new javax.swing.JLabel();
jLabel_CPF = new javax.swing.JLabel();
jLabel_Imagem = new javax.swing.JLabel();
jButton_Gravar = new javax.swing.JButton();
jButton_Carregar = new javax.swing.JButton();
jTextField_Nome = new javax.swing.JTextField();
jTextField_Tel = new javax.swing.JTextField();
jTextField_RG = new javax.swing.JTextField();
jTextField_CPF = new javax.swing.JTextField();
setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
jLabel_Nome.setText("Nome:");
jLabel_Tel.setText("Telefone:");
jLabel_RG.setText("RG:");
jLabel_CPF.setText("CPF:");
jLabel_Imagem.setText("Foto");
jButton_Gravar.setText("Gravar");
jButton_Gravar.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jButton_GravarActionPerformed(evt);
}
});
jButton_Carregar.setText("Carregar");
jButton_Carregar.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jButton_CarregarActionPerformed(evt);
}
});
javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
getContentPane().setLayout(layout);
layout.setHorizontalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addContainerGap(346, Short.MAX_VALUE)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING, false)
.addComponent(jButton_Gravar, javax.swing.GroupLayout.Alignment.LEADING, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addComponent(jButton_Carregar, javax.swing.GroupLayout.Alignment.LEADING, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
.addGap(102, 102, 102))
.addGroup(layout.createSequentialGroup()
.addGap(33, 33, 33)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jLabel_Tel)
.addComponent(jLabel_Nome)
.addComponent(jLabel_CPF)
.addComponent(jLabel_RG))
.addGap(18, 18, 18)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jTextField_Nome, javax.swing.GroupLayout.PREFERRED_SIZE, 179, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING, false)
.addComponent(jTextField_CPF, javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jTextField_RG, javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jTextField_Tel, javax.swing.GroupLayout.Alignment.LEADING, javax.swing.GroupLayout.PREFERRED_SIZE, 130, javax.swing.GroupLayout.PREFERRED_SIZE)))
.addGap(37, 37, 37)
.addComponent(jLabel_Imagem, javax.swing.GroupLayout.PREFERRED_SIZE, 166, javax.swing.GroupLayout.PREFERRED_SIZE)
.addContainerGap(44, Short.MAX_VALUE))
);
layout.setVerticalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addGap(23, 23, 23)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
.addGroup(layout.createSequentialGroup()
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel_Nome)
.addComponent(jTextField_Nome, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGap(28, 28, 28)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel_Tel)
.addComponent(jTextField_Tel, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGap(32, 32, 32)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel_RG)
.addComponent(jTextField_RG, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGap(28, 28, 28)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel_CPF)
.addComponent(jTextField_CPF, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGap(29, 29, 29))
.addGroup(javax.swing.GroupLayout.Alignment.LEADING, layout.createSequentialGroup()
.addComponent(jLabel_Imagem, javax.swing.GroupLayout.PREFERRED_SIZE, 175, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(29, 29, 29)))
.addComponent(jButton_Carregar)
.addGap(30, 30, 30)
.addComponent(jButton_Gravar)
.addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
);
pack();
}// </editor-fold>
private void jButton_CarregarActionPerformed(java.awt.event.ActionEvent evt) {
JFileChooser fileChooser = new JFileChooser();
fileChooser.setDialogTitle("Escolha a Imagem");
fileChooser.setFileSelectionMode(JFileChooser.FILES_ONLY);
if (fileChooser.showOpenDialog(this) == JFileChooser.APPROVE_OPTION)
{
jLabel_Imagem.setIcon(new ImageIcon(fileChooser.getSelectedFile().getPath()));
}
}
private void jButton_GravarActionPerformed(java.awt.event.ActionEvent evt) {
java.sql.Connection conn; //fazer a conexao com o mysql
try
{
Class.forName("org.gjt.mm.mysql.Driver");
//Link para a tabela do banco de dados
conn = java.sql.DriverManager.getConnection("jdbc:mysql://localhost:3306/db_aulas", "root","123");
}
catch (Exception e)
{
e.printStackTrace();
throw new java.lang.RuntimeException("Erro ao conectar");
}
//Inserindo dados digitados no JTextField para que seja usado no comando SQL
String nome = this.jTextField_Nome.getText();
String telefone = this.jTextField_Tel.getText();
String rg = this.jTextField_RG.getText();
String cpf = this.jTextField_CPF.getText();
//Criando instrução de inserção no sql
String comando = "insert into cliente (nome, telefone, rg, cpf) VALUES(?, ?, ?, ?)";
try
{
java.sql.PreparedStatement stmt = conn.prepareStatement(comando);
stmt.setString(1, nome);
stmt.setString(2, telefone);
stmt.setString(3, rg);
stmt.setString(4, cpf);
stmt.executeUpdate();
stmt.close();
conn.close();
}
catch (java.sql.SQLException e)
{
throw new java.lang.RuntimeException (e.getMessage());
}
//Fechando a Conexão
try
{
conn.close();
}
catch (Exception e)
{
e.printStackTrace();
throw new java.lang.RuntimeException("Erro Fechar");
}
JOptionPane.showMessageDialog(null, "Registro gravado com sucesso");
}
/**
* @param args the command line arguments
*/
public static void main(String args[]) {
java.awt.EventQueue.invokeLater(new Runnable() {
public void run() {
new JF_Meliante().setVisible(true);
}
});
}
// Variables declaration - do not modify
private javax.swing.JButton jButton_Carregar;
private javax.swing.JButton jButton_Gravar;
private javax.swing.JLabel jLabel_CPF;
private javax.swing.JLabel jLabel_Imagem;
private javax.swing.JLabel jLabel_Nome;
private javax.swing.JLabel jLabel_RG;
private javax.swing.JLabel jLabel_Tel;
private javax.swing.JTextField jTextField_CPF;
private javax.swing.JTextField jTextField_Nome;
private javax.swing.JTextField jTextField_RG;
private javax.swing.JTextField jTextField_Tel;
// End of variables declaration
}
E quero gravar o que esta sendo carregado no JLabel_Imagem no meu banco de dados, mas não consigo...
obs:
- Meu banco já possui o campo imagem do tipo BLOB
- No comando SQL do codigo do botão Gravar, não coloquei o campo Imagem nem seu valor pois senão a aplicação não roda, más necessito armazenar imagens nesse campo...
Obrigado e ótimo fim de semana a todos...
Bons estudos!!!
