Fórum Problemas com Datas em Java #505381

25/12/2014

0

Boa tarde.
Alguém consegue me ajudar com o erro abaixo

(''')

/*
* To change this license header, choose License Headers in Project Properties.
* To change this template file, choose Tools | Templates
* and open the template in the editor.
*/
package Telas;

import Padrao.OcorrenciaDAO;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.Date;

/**
*
* @author VictorHugo
*/
public class Recuperação extends javax.swing.JFrame {
OcorrenciaDAO o = new OcorrenciaDAO ();
/**
* Creates new form Recuperação
*/
public Recuperação() {
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() {

buttonGroup1 = new javax.swing.ButtonGroup();
jPanel1 = new javax.swing.JPanel();
jCbCliente = new javax.swing.JComboBox();
jLabel1 = new javax.swing.JLabel();
textNomeAgente = new javax.swing.JTextField();
jLabel2 = new javax.swing.JLabel();
textDataOcorrencia = new javax.swing.JFormattedTextField();
jLabel3 = new javax.swing.JLabel();
textHoraAcionamento = new javax.swing.JTextField();
jLabel4 = new javax.swing.JLabel();
textHoraChegada = new javax.swing.JTextField();
jLabel5 = new javax.swing.JLabel();
textHoraEncerramento = new javax.swing.JTextField();
jLabel6 = new javax.swing.JLabel();
jLabel7 = new javax.swing.JLabel();
textRua = new javax.swing.JTextField();
jLabel8 = new javax.swing.JLabel();
textBairro = new javax.swing.JTextField();
jLabel9 = new javax.swing.JLabel();
textCidade = new javax.swing.JTextField();
jLabel10 = new javax.swing.JLabel();
jLabel11 = new javax.swing.JLabel();
textLat = new javax.swing.JTextField();
jLabel12 = new javax.swing.JLabel();
textLong = new javax.swing.JTextField();
jLabel13 = new javax.swing.JLabel();
jLabel14 = new javax.swing.JLabel();
textMarca = new javax.swing.JTextField();
jLabel15 = new javax.swing.JLabel();
textModelo = new javax.swing.JTextField();
jLabel16 = new javax.swing.JLabel();
textCor = new javax.swing.JTextField();
jLabel17 = new javax.swing.JLabel();
textAno = new javax.swing.JTextField();
jLabel18 = new javax.swing.JLabel();
textPlaca = new javax.swing.JTextField();
jLabel19 = new javax.swing.JLabel();
textCarga = new javax.swing.JTextField();
jLabel20 = new javax.swing.JLabel();
textNomeMotorista = new javax.swing.JTextField();
jLabel21 = new javax.swing.JLabel();
textNumeroRG = new javax.swing.JTextField();
jLabel22 = new javax.swing.JLabel();
jScrollPane1 = new javax.swing.JScrollPane();
jTextHistorico = new javax.swing.JTextArea();
jComboBox2 = new javax.swing.JComboBox();
jLabel23 = new javax.swing.JLabel();
jTextField1 = new javax.swing.JTextField();
btSalvar = new javax.swing.JButton();
jCbStatus = new javax.swing.JComboBox();

setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);

jCbCliente.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "Cliente:", "SASCAR", "TESB", "" }));

jLabel1.setText("Nome do Agente:");

textNomeAgente.setText("Nome e Sobre Nome");

jLabel2.setText("Data da Ocorrência:");

jLabel3.setText("Hora do Acionamento:");

textHoraAcionamento.setText("00:00");

jLabel4.setText("Hora de Chegada:");

textHoraChegada.setText("00:00");

jLabel5.setText("Hora de Encerramento:");

textHoraEncerramento.setText("00:00");

jLabel6.setText("Local:");

jLabel7.setText("Via:");

textRua.setText("Nome da Rua");

jLabel8.setText("Bairro:");

jLabel9.setText("Cidade:");

textCidade.setText(" ");

jLabel10.setText("Coordenadas:");

jLabel11.setText("LAT:");

textLat.setText(" ");

jLabel12.setText("LONG:");

textLong.setText(" ");

jLabel13.setText("Veículo:");

jLabel14.setText("Marca:");

jLabel15.setText("Modelo:");

textModelo.setText(" ");

jLabel16.setText("Cor:");

textCor.setText(" ");

jLabel17.setText("Ano:");

textAno.setText(" ");

jLabel18.setText("Placa:");

textPlaca.setText(" ");

jLabel19.setText("Carga:");

textCarga.setText(" ");

jLabel20.setText("Proprietário/Motorista:");

textNomeMotorista.setText(" ");

jLabel21.setText("Nº Doc:");

textNumeroRG.setText(" ");

jLabel22.setText("Historio da ocorrência:");

jTextHistorico.setColumns(20);
jTextHistorico.setRows(5);
jScrollPane1.setViewportView(jTextHistorico);

jComboBox2.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "Zona", "ZL", "ZS", "ZO", "ZN" }));

jLabel23.setText("Km Rodados:");

btSalvar.setText("Salvar");
btSalvar.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
btSalvarActionPerformed(evt);
}
});

jCbStatus.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "Status", "Recuperado", "Não Recuperado" }));

javax.swing.GroupLayout jPanel1Layout = new javax.swing.GroupLayout(jPanel1);
jPanel1.setLayout(jPanel1Layout);
jPanel1Layout.setHorizontalGroup(
jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel1Layout.createSequentialGroup()
.addContainerGap()
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jScrollPane1, javax.swing.GroupLayout.Alignment.TRAILING)
.addGroup(jPanel1Layout.createSequentialGroup()
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel1Layout.createSequentialGroup()
.addComponent(jLabel10)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(jLabel11)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(textLat, javax.swing.GroupLayout.PREFERRED_SIZE, 81, javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addComponent(jLabel12)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(textLong, javax.swing.GroupLayout.PREFERRED_SIZE, 81, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(18, 18, 18)
.addComponent(jLabel23)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(jTextField1, javax.swing.GroupLayout.PREFERRED_SIZE, 43, javax.swing.GroupLayout.PREFERRED_SIZE))
.addComponent(jLabel13)
.addGroup(jPanel1Layout.createSequentialGroup()
.addComponent(jLabel14)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(textMarca, javax.swing.GroupLayout.PREFERRED_SIZE, 132, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(18, 18, 18)
.addComponent(jLabel15)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(textModelo, javax.swing.GroupLayout.PREFERRED_SIZE, 170, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGroup(jPanel1Layout.createSequentialGroup()
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING, false)
.addGroup(javax.swing.GroupLayout.Alignment.LEADING, jPanel1Layout.createSequentialGroup()
.addComponent(jLabel19)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(textCarga))
.addGroup(javax.swing.GroupLayout.Alignment.LEADING, jPanel1Layout.createSequentialGroup()
.addComponent(jLabel16)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(textCor, javax.swing.GroupLayout.PREFERRED_SIZE, 99, javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addComponent(jLabel17)
.addGap(18, 18, 18)
.addComponent(textAno, javax.swing.GroupLayout.PREFERRED_SIZE, 41, javax.swing.GroupLayout.PREFERRED_SIZE)))
.addGap(18, 18, 18)
.addComponent(jLabel18)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(textPlaca, javax.swing.GroupLayout.PREFERRED_SIZE, 69, javax.swing.GroupLayout.PREFERRED_SIZE))
.addComponent(jLabel22)
.addGroup(jPanel1Layout.createSequentialGroup()
.addComponent(jLabel20)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(textNomeMotorista, javax.swing.GroupLayout.PREFERRED_SIZE, 200, javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addComponent(jLabel21)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(textNumeroRG, javax.swing.GroupLayout.PREFERRED_SIZE, 108, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGroup(jPanel1Layout.createSequentialGroup()
.addComponent(jLabel3)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(textHoraAcionamento, javax.swing.GroupLayout.PREFERRED_SIZE, 45, javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(jLabel4)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(textHoraChegada, javax.swing.GroupLayout.PREFERRED_SIZE, 45, javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(jLabel5)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(textHoraEncerramento, javax.swing.GroupLayout.PREFERRED_SIZE, 45, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGroup(jPanel1Layout.createSequentialGroup()
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel1Layout.createSequentialGroup()
.addComponent(jLabel7)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(textRua, javax.swing.GroupLayout.PREFERRED_SIZE, 245, javax.swing.GroupLayout.PREFERRED_SIZE))
.addComponent(jLabel6))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(textBairro, javax.swing.GroupLayout.PREFERRED_SIZE, 103, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel8))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jLabel9)
.addGroup(jPanel1Layout.createSequentialGroup()
.addComponent(textCidade, javax.swing.GroupLayout.PREFERRED_SIZE, 104, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(18, 18, 18)
.addComponent(jComboBox2, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))))
.addComponent(btSalvar)
.addGroup(jPanel1Layout.createSequentialGroup()
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jLabel1)
.addComponent(jCbCliente, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jCbStatus, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGroup(jPanel1Layout.createSequentialGroup()
.addComponent(textNomeAgente, javax.swing.GroupLayout.PREFERRED_SIZE, 192, javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(jLabel2)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(textDataOcorrencia, javax.swing.GroupLayout.PREFERRED_SIZE, 76, javax.swing.GroupLayout.PREFERRED_SIZE)))))
.addGap(0, 8, Short.MAX_VALUE)))
.addContainerGap())
);
jPanel1Layout.setVerticalGroup(
jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel1Layout.createSequentialGroup()
.addGap(18, 18, 18)
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jCbCliente, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jCbStatus, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel1)
.addComponent(textNomeAgente, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel2)
.addComponent(textDataOcorrencia, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel3)
.addComponent(textHoraAcionamento, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel4)
.addComponent(textHoraChegada, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel5)
.addComponent(textHoraEncerramento, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel6)
.addComponent(jLabel8)
.addComponent(jLabel9))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel7)
.addComponent(textRua, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(textBairro, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(textCidade, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jComboBox2, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel10)
.addComponent(jLabel11)
.addComponent(textLat, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel12)
.addComponent(textLong, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel23)
.addComponent(jTextField1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(jLabel13)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel14)
.addComponent(textMarca, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel15)
.addComponent(textModelo, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel16)
.addComponent(textCor, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel17)
.addComponent(textAno, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel18)
.addComponent(textPlaca, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel19)
.addComponent(textCarga, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel20)
.addComponent(textNomeMotorista, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel21)
.addComponent(textNumeroRG, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(jLabel22)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(jScrollPane1, javax.swing.GroupLayout.DEFAULT_SIZE, 98, Short.MAX_VALUE)
.addGap(18, 18, 18)
.addComponent(btSalvar)
.addGap(17, 17, 17))
);

javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
getContentPane().setLayout(layout);
layout.setHorizontalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jPanel1, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
);
layout.setVerticalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jPanel1, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
);

pack();
}// </editor-fold>

private void btSalvarActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
String cliente = jCbCliente.getSelectedItem().toString();;
String Status = jCbStatus.getSelectedItem().toString();
String agente = textNomeAgente.getText();

String via = textRua.getText();
String bairro = textBairro.getText();
String cidade = textCidade.getText();
String zona;
String lat;
String long2;
String kmRodado;
String marca;
String modelo;
String cor;
String ano;
String placa;
String carga;
String motorista;
String documento;
String historico = jTextHistorico.getText();
/**Converte string para formato data
**/
String pattern = textDataOcorrencia.getText();
SimpleDateFormat formatter = new SimpleDateFormat(pattern);
Date today = new Date();
String output = formatter.format(today);

/**Converte string para formato time
* variavel textHoraAcionamento
**/
String time = textHoraAcionamento.getText();
Date date = null;
try {
date = new SimpleDateFormat("HH:mm").parse(time);

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

/**Converte string para formato time
* variavel textHoraChegada
**/
String time2 = textHoraChegada.getText();
Date date2 = null;
try {
date2 = new SimpleDateFormat("HH:mm").parse(time2);

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

/**Converte string para formato time
* variavel textHoraChegada
**/
String time3 = textHoraEncerramento.getText();
Date date3 = null;
try {
date3 = new SimpleDateFormat("HH:mm").parse(time3);

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

o.adiciona(cliente, Status, agente, output, time, time2, time3, historico);
//CLIENTE,STATUS_DA_RECUPERACAO,AGENTE, DATA_OCORRENCIA,HR_ACIONAMENTO, HR_CHEGADA, HR_ENCERRAMENTO, HIST_OCORRENCIA

}

/**
* @param args the command line arguments
*/
public static void main(String args[]) {
/* Set the Nimbus look and feel */
//<editor-fold defaultstate="collapsed" desc=" Look and feel setting code (optional) ">
/* If Nimbus (introduced in Java SE 6) is not available, stay with the default look and feel.
* For details see http://download.oracle.com/javase/tutorial/uiswing/lookandfeel/plaf.html
*/
try {
for (javax.swing.UIManager.LookAndFeelInfo info : javax.swing.UIManager.getInstalledLookAndFeels()) {
if ("Nimbus".equals(info.getName())) {
javax.swing.UIManager.setLookAndFeel(info.getClassName());
break;
}
}
} catch (ClassNotFoundException ex) {
java.util.logging.Logger.getLogger(Recuperação.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
} catch (InstantiationException ex) {
java.util.logging.Logger.getLogger(Recuperação.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
} catch (IllegalAccessException ex) {
java.util.logging.Logger.getLogger(Recuperação.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
} catch (javax.swing.UnsupportedLookAndFeelException ex) {
java.util.logging.Logger.getLogger(Recuperação.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
}
//</editor-fold>

/* Create and display the form */
java.awt.EventQueue.invokeLater(new Runnable() {
public void run() {
new Recuperação().setVisible(true);
}
});
}

// Variables declaration - do not modify
private javax.swing.JButton btSalvar;
private javax.swing.ButtonGroup buttonGroup1;
private javax.swing.JComboBox jCbCliente;
private javax.swing.JComboBox jCbStatus;
private javax.swing.JComboBox jComboBox2;
private javax.swing.JLabel jLabel1;
private javax.swing.JLabel jLabel10;
private javax.swing.JLabel jLabel11;
private javax.swing.JLabel jLabel12;
private javax.swing.JLabel jLabel13;
private javax.swing.JLabel jLabel14;
private javax.swing.JLabel jLabel15;
private javax.swing.JLabel jLabel16;
private javax.swing.JLabel jLabel17;
private javax.swing.JLabel jLabel18;
private javax.swing.JLabel jLabel19;
private javax.swing.JLabel jLabel2;
private javax.swing.JLabel jLabel20;
private javax.swing.JLabel jLabel21;
private javax.swing.JLabel jLabel22;
private javax.swing.JLabel jLabel23;
private javax.swing.JLabel jLabel3;
private javax.swing.JLabel jLabel4;
private javax.swing.JLabel jLabel5;
private javax.swing.JLabel jLabel6;
private javax.swing.JLabel jLabel7;
private javax.swing.JLabel jLabel8;
private javax.swing.JLabel jLabel9;
private javax.swing.JPanel jPanel1;
private javax.swing.JScrollPane jScrollPane1;
private javax.swing.JTextField jTextField1;
private javax.swing.JTextArea jTextHistorico;
private javax.swing.JTextField textAno;
private javax.swing.JTextField textBairro;
private javax.swing.JTextField textCarga;
private javax.swing.JTextField textCidade;
private javax.swing.JTextField textCor;
private javax.swing.JFormattedTextField textDataOcorrencia;
private javax.swing.JTextField textHoraAcionamento;
private javax.swing.JTextField textHoraChegada;
private javax.swing.JTextField textHoraEncerramento;
private javax.swing.JTextField textLat;
private javax.swing.JTextField textLong;
private javax.swing.JTextField textMarca;
private javax.swing.JTextField textModelo;
private javax.swing.JTextField textNomeAgente;
private javax.swing.JTextField textNomeMotorista;
private javax.swing.JTextField textNumeroRG;
private javax.swing.JTextField textPlaca;
private javax.swing.JTextField textRua;
// End of variables declaration
}

(''')

(''')

/*
* To change this license header, choose License Headers in Project Properties.
* To change this template file, choose Tools | Templates
* and open the template in the editor.
*/
package Padrao;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

/**
*
* @author VictorHugo
*/
public class ConnectionFactory {

public Connection getConnection() {

try {
return DriverManager.getConnection("jdbc:mysql://localhost/BLACKLIONS", "root", "@@VictorHugo@@"); /*fj21 = nome do banco de dados, root = usuário do bando e "" a senha do bando de dados */

} catch (SQLException e) {
throw new RuntimeException(e);
}
}
}


(''')



(''')
/*
* To change this license header, choose License Headers in Project Properties.
* To change this template file, choose Tools | Templates
* and open the template in the editor.
*/
package Padrao;


import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;

/**
*
* @author VictorHugo
*/
public class OcorrenciaDAO {
// a conexão com o banco de dados
private Connection connection;

public OcorrenciaDAO() {
this.connection = new ConnectionFactory().getConnection();
}

public void adiciona(String a, String b, String c, String d, String e, String f, String g, String h) {
String sql = "insert into RECUPERACAO " +
"(CLIENTE,STATUS_DA_RECUPERACAO,AGENTE,DATA_OCORRENCIA,HR_ACIONAMENTO, \n" +
"HR_CHEGADA, HR_ENCERRAMENTO, HIST_OCORRENCIA)" +
" values (?,?,?,?,?,?,?,?)";

try {
// prepared statement para inserção
PreparedStatement stmt = connection.prepareStatement(sql);

// seta os valores
stmt.setString(1,a);
stmt.setString(2,b);
stmt.setString(3,c);
stmt.setString(4,d);
stmt.setString(5,e);
stmt.setString(6,f);
stmt.setString(7,g);
stmt.setString(8,h);


// executa
stmt.execute();
stmt.close();
} catch (SQLException z) {
throw new RuntimeException(e);
}
}

}

(''')


(''')

run:
Exception in thread "AWT-EventQueue-0" java.lang.RuntimeException: 13:31
at Padrao.OcorrenciaDAO.adiciona(OcorrenciaDAO.java:51)
at Telas.Recuperação.btSalvarActionPerformed(Recuperação.java:444)
at Telas.Recuperação.access$000(Recuperação.java:17)
at Telas.Recuperação$1.actionPerformed(Recuperação.java:175)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2018)
at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2341)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:402)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:259)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:252)
at java.awt.Component.processMouseEvent(Component.java:6516)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3320)
at java.awt.Component.processEvent(Component.java:6281)
at java.awt.Container.processEvent(Container.java:2229)
at java.awt.Component.dispatchEventImpl(Component.java:4872)
at java.awt.Container.dispatchEventImpl(Container.java:2287)
at java.awt.Component.dispatchEvent(Component.java:4698)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4832)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4492)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4422)
at java.awt.Container.dispatchEventImpl(Container.java:2273)
at java.awt.Window.dispatchEventImpl(Window.java:2719)
at java.awt.Component.dispatchEvent(Component.java:4698)
at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:735)
at java.awt.EventQueue.access$200(EventQueue.java:103)
at java.awt.EventQueue$3.run(EventQueue.java:694)
at java.awt.EventQueue$3.run(EventQueue.java:692)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:76)
at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:87)
at java.awt.EventQueue$4.run(EventQueue.java:708)
at java.awt.EventQueue$4.run(EventQueue.java:706)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:76)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:705)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:242)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:161)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:150)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:146)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:138)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:91)

(''')
Victor Possidonio

Victor Possidonio

Responder

Posts

25/12/2014

Eduardo Pessoa

Que erro? o que está tentando fazer?
Responder

Gostei + 0

25/12/2014

Victor Possidonio

Eu preciso inserir a data de um textfield no formato da data do MySQL.

Tentei converter de string para date mas dá erro na horá de inserir.
Responder

Gostei + 0

25/12/2014

William

Olá Victor, por gentileza utilize a tag "code" para portar seu código fonte, senão fica quase impossível de entender seu problema apenas lendo o código.

Quanto a sua dúvida, estou postando 2 funções que utilizo, passando uma data do formato brasileiro para americano e outra função que passa do formato americano para o brasileiro.

public java.sql.Date DataBrtoEng(String dataStr){
        DateFormat format = new SimpleDateFormat("dd/MM/yyyy");
        
        if (dataStr.equals("")){
            return null;
        }

        try {
            java.sql.Date data = new java.sql.Date(((java.util.Date)format.parse(dataStr)).getTime());  
            return data;
        } catch (ParseException e) {
            JOptionPane.showMessageDialog(null, "Erro: " + e.getMessage(), "Erro Helpler", JOptionPane.ERROR_MESSAGE);
            return null;
        }  
 }
    
 public String DataEngtoBr(java.sql.Date data){
        SimpleDateFormat format = new SimpleDateFormat("dd/MM/yyyy");
        
        if (data == null){
            return null;
        }
        
        try{ 
            return format.format(data);
        } catch (Exception e) {
            JOptionPane.showMessageDialog(null, "Erro: " + e.getMessage(), "Erro Helpler", JOptionPane.ERROR_MESSAGE);
            return null;
        } 
 }
Responder

Gostei + 0

25/12/2014

Eduardo Pessoa

Essas tags ficam um pouco acima aonde escreve suas duvidas.

[img]http://arquivo.devmedia.com.br/forum/imagem/310862-20141225-192955.jpg[/img]
Responder

Gostei + 0

30/12/2014

Eduardo Pessoa

Vitor, resolvido?
Responder

Gostei + 0

Utilizamos cookies para fornecer uma melhor experiência para nossos usuários, consulte nossa política de privacidade.

Aceitar