To usando o netbeans e tem um erro que nao consigo solucionar
NESTA BENDITA LINHA listeteleatlantic t = new listeteleatlantic (mes, ano);
package utilitarios;
import javax.swing.text.MaskFormatter;
import utilitarios.listeteleatlantic;
import utilitarios.listeteleatlantic;
import java.awt.event.ActionEvent;
public class listas extends javax.swing.JFrame {
public listas() {
initComponents();
}
// <editor-fold defaultstate="collapsed" desc=" Código Gerado ">
private void initComponents() {
jPanel1 = new javax.swing.JPanel();
jLabel1 = new javax.swing.JLabel();
jLabel2 = new javax.swing.JLabel();
jLabel3 = new javax.swing.JLabel();
jLabel4 = new javax.swing.JLabel();
cadteleatlantic = new javax.swing.JButton();
jLabel5 = new javax.swing.JLabel();
jButton2 = new javax.swing.JButton();
jLabel6 = new javax.swing.JLabel();
jButton3 = new javax.swing.JButton();
jLabel7 = new javax.swing.JLabel();
jButton4 = new javax.swing.JButton();
limpar = new javax.swing.JButton();
jLabel8 = new javax.swing.JLabel();
ano1 = new javax.swing.JTextField();
mes1 = new javax.swing.JTextField();
mes2 = new javax.swing.JTextField();
jLabel9 = new javax.swing.JLabel();
ano2 = new javax.swing.JTextField();
mes3 = new javax.swing.JTextField();
jLabel10 = new javax.swing.JLabel();
ano3 = new javax.swing.JTextField();
mes4 = new javax.swing.JTextField();
jLabel11 = new javax.swing.JLabel();
ano4 = new javax.swing.JTextField();
setDefaultCloseOperation(javax.swing.WindowConstants.DISPOSE_ON_CLOSE);
setTitle("LISTAGEM REFER\u00caNTE M\u00caS REQUISITADO!");
jPanel1.setBorder(javax.swing.BorderFactory.createTitledBorder(null, "LISTA", javax.swing.border.TitledBorder.LEFT, javax.swing.border.TitledBorder.TOP, new java.awt.Font("Tahoma", 1, 11)));
jLabel1.setFont(new java.awt.Font("Tahoma", 1, 14));
jLabel1.setText("LISTAGEM DAS FICHAS CADASTRADAS ");
jLabel2.setFont(new java.awt.Font("Tahoma", 1, 11));
jLabel2.setText("DIGITE DIA/M\u00caS/ANO REFERENTE:");
jLabel3.setText("exemplo: 01/01/2007.");
jLabel4.setFont(new java.awt.Font("Tahoma", 1, 12));
jLabel4.setText("TELEATLANTIC:");
cadteleatlantic.setFont(new java.awt.Font("Tahoma", 1, 11));
cadteleatlantic.setText("teleatlantic");
cadteleatlantic.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
cadteleatlanticActionPerformed(evt);
}
});
jLabel5.setFont(new java.awt.Font("Tahoma", 1, 12));
jLabel5.setText("RETORNO:");
jButton2.setFont(new java.awt.Font("Tahoma", 1, 11));
jButton2.setText("retorno");
jLabel6.setFont(new java.awt.Font("Tahoma", 1, 12));
jLabel6.setText("LISTAGEM:");
jButton3.setFont(new java.awt.Font("Tahoma", 1, 11));
jButton3.setText("listagem");
jLabel7.setFont(new java.awt.Font("Tahoma", 1, 12));
jLabel7.setText("TERCEIROS:");
jButton4.setFont(new java.awt.Font("Tahoma", 1, 11));
jButton4.setText("terceiros");
limpar.setFont(new java.awt.Font("Tahoma", 1, 12));
limpar.setText("LIMPAR");
limpar.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
limparActionPerformed(evt);
}
});
jLabel8.setText("/");
jLabel9.setText("/");
jLabel10.setText("/");
jLabel11.setText("/");
javax.swing.GroupLayout jPanel1Layout = new javax.swing.GroupLayout(jPanel1);
jPanel1.setLayout(jPanel1Layout);
jPanel1Layout.setHorizontalGroup(
jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel1Layout.createSequentialGroup()
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
.addGroup(jPanel1Layout.createSequentialGroup()
.addContainerGap()
.addComponent(limpar, javax.swing.GroupLayout.PREFERRED_SIZE, 281, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGroup(javax.swing.GroupLayout.Alignment.LEADING, jPanel1Layout.createSequentialGroup()
.addContainerGap()
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jLabel2)
.addComponent(jLabel3)
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING, false)
.addComponent(jLabel1, javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel1Layout.createSequentialGroup()
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jLabel5)
.addComponent(jLabel6)
.addComponent(jLabel4)
.addComponent(jLabel7))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
.addComponent(mes4)
.addComponent(mes3)
.addComponent(mes2)
.addComponent(mes1, javax.swing.GroupLayout.DEFAULT_SIZE, 23, Short.MAX_VALUE))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
.addGroup(jPanel1Layout.createSequentialGroup()
.addComponent(jLabel10)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(ano3))
.addGroup(jPanel1Layout.createSequentialGroup()
.addComponent(jLabel8)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(ano1, javax.swing.GroupLayout.PREFERRED_SIZE, 39, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGroup(jPanel1Layout.createSequentialGroup()
.addComponent(jLabel9)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(ano2))
.addGroup(jPanel1Layout.createSequentialGroup()
.addComponent(jLabel11)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(ano4)))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
.addComponent(jButton4, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addComponent(jButton3, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addComponent(jButton2, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addComponent(cadteleatlantic, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)))))))
.addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
);
jPanel1Layout.setVerticalGroup(
jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel1Layout.createSequentialGroup()
.addComponent(jLabel1)
.addGap(14, 14, 14)
.addComponent(jLabel2)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(jLabel3)
.addGap(25, 25, 25)
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel4)
.addComponent(cadteleatlantic)
.addComponent(mes1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel8)
.addComponent(ano1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGap(22, 22, 22)
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel5)
.addComponent(jButton2)
.addComponent(mes2, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel9)
.addComponent(ano2, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGap(24, 24, 24)
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel6)
.addComponent(jButton3)
.addComponent(mes3, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel10)
.addComponent(ano3, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGap(28, 28, 28)
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jButton4)
.addComponent(ano4, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel7)
.addComponent(mes4, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel11)))
.addGap(27, 27, 27)
.addComponent(limpar)
.addContainerGap(28, Short.MAX_VALUE))
);
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()
.addComponent(jPanel1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
);
layout.setVerticalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addContainerGap()
.addComponent(jPanel1, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addContainerGap())
);
pack();
}// </editor-fold>
private void cadteleatlanticActionPerformed(java.awt.event.ActionEvent evt) {
String mes = null;
String ano = null;
if( evt.getSource() == teleatlantic ) {
try {
mes = mes1.getText().toString();
ano = ano1.getText().toString();
} catch( NumberFormatException e ) {
mes1.setText("Erro de Formato"); return;
}
listeteleatlantic t = new listeteleatlantic (mes, ano);
t.setVisible(true);
}
}
private void limparActionPerformed(java.awt.event.ActionEvent evt) {
this.mes1.setText("");
this.ano1.setText("");
this.mes2.setText("");
this.ano2.setText("");
this.mes3.setText("");
this.ano3.setText("");
this.mes4.setText("");
this.ano4.setText("");
}
// Declaração de variáveis - não modifique
private javax.swing.JTextField ano1;
private javax.swing.JTextField ano2;
private javax.swing.JTextField ano3;
private javax.swing.JTextField ano4;
private javax.swing.JButton cadteleatlantic;
private javax.swing.JButton jButton2;
private javax.swing.JButton jButton3;
private javax.swing.JButton jButton4;
private javax.swing.JLabel jLabel1;
private javax.swing.JLabel jLabel10;
private javax.swing.JLabel jLabel11;
private javax.swing.JLabel jLabel2;
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.JButton limpar;
private javax.swing.JTextField mes1;
private javax.swing.JTextField mes2;
private javax.swing.JTextField mes3;
private javax.swing.JTextField mes4;
// Fim da declaração de variáveis
private Object teleatlantic;
private String f;
}
////////////////////////////////////////////////////////////////////////////////////////////////////////
public class listeteleatlantic extends javax.swing.JFrame {
public listeteleatlantic() {
initComponents();
formInternalFrameOpened(mes,ano);
}
// <editor-fold defaultstate="collapsed" desc=" Código Gerado ">
private void initComponents() {
jPanel1 = new javax.swing.JPanel();
jScrollPane1 = new javax.swing.JScrollPane();
jTable1 = new javax.swing.JTable();
setDefaultCloseOperation(javax.swing.WindowConstants.DISPOSE_ON_CLOSE);
setTitle("CADASTRADOS REFER\u00caNTE M\u00caS REQUISITADO");
jPanel1.setBorder(javax.swing.BorderFactory.createTitledBorder(null, "TELEATLANTIC", javax.swing.border.TitledBorder.CENTER, javax.swing.border.TitledBorder.TOP, new java.awt.Font("Tahoma", 1, 11)));
jTable1.setForeground(new java.awt.Color(0, 51, 255));
jTable1.setModel(new javax.swing.table.DefaultTableModel(
new Object [][] {
{null, null, null, null},
{null, null, null, null},
{null, null, null, null},
{null, null, null, null}
},
new String [] {
"unidade:", "data:", "cod_serviço:", "obs:"
}
));
jScrollPane1.setViewportView(jTable1);
javax.swing.GroupLayout jPanel1Layout = new javax.swing.GroupLayout(jPanel1);
jPanel1.setLayout(jPanel1Layout);
jPanel1Layout.setHorizontalGroup(
jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jScrollPane1, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.DEFAULT_SIZE, 482, Short.MAX_VALUE)
);
jPanel1Layout.setVerticalGroup(
jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel1Layout.createSequentialGroup()
.addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 286, javax.swing.GroupLayout.PREFERRED_SIZE))
);
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()
.addComponent(jPanel1, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addContainerGap())
);
layout.setVerticalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addContainerGap()
.addComponent(jPanel1, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addContainerGap())
);
pack();
}// </editor-fold>
private void formInternalFrameOpened(String mes, String ano){
String mesi = "06";
String mesf = "06";
SimpleDateFormat sdg = new SimpleDateFormat("dd/MM/yyyy");
String dataFormatada = null;
String x="2";
String SQL="select * from ord_servico where cod_servico="+x+" and (data > '"+ano+"-"+mes+"-00' and data < '"+ano+"-"+mes+"-32') " ;
try{
Connection con = ConnectionFactory.getConnection();
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery (SQL);
while(rs.next()){
String uni = rs.getString("unidade");
try {
dataFormatada = sdg.format(rs.getDate("data"));
} catch (Exception ex) {
System.out.println("Erro formatando a data");
}
//Date dat = rs.getDate("data");
String val = rs.getString("valor");
String ob = rs.getString("obs");
((DefaultTableModel)jTable1.getModel()).addRow(new Vector());
jTable1.getModel().setValueAt(uni, jTable1.getRowCount()-1,0);
jTable1.getModel().setValueAt(dataFormatada, jTable1.getRowCount()-1,1);
jTable1.getModel().setValueAt(val, jTable1.getRowCount()-1,2);
jTable1.getModel().setValueAt(ob , jTable1.getRowCount()-1,3);
// pela query. Vamos imprimí-los
System.out.println("unidade: " + uni+ " data: "+ dataFormatada +" valor: " + val + "obs: "+ ob);
System.out.println(""+uni+""+dataFormatada+""+val+""+ob);
System.out.println(dataFormatada);
}
}
catch (SQLException ex) {
// handle any errors
System.out.println("Outro:"+ex);
System.out.println("SQLException: " + ex.getMessage());
System.out.println("SQLState: " + ex.getSQLState());
System.out.println("VendorError: " + ex.getErrorCode());
} catch (Exception ex) {
System.out.println("Erro: "+ex);
// handle the error
}
}
private Date setDate(String x) {
return null;
}
private void formInternalFrameOpened() {
throw new UnsupportedOperationException("Not yet implemented");
}
// Declaração de variáveis - não modifique
private javax.swing.JPanel jPanel1;
private javax.swing.JScrollPane jScrollPane1;
private javax.swing.JTable jTable1;
// Fim da declaração de variáveis
private String d;
private String mes;
private String ano;
}