Ir para conteúdo
Fórum Script Brasil

nicol store

Membros
  • Total de itens

    14
  • Registro em

  • Última visita

Sobre nicol store

nicol store's Achievements

0

Reputação

  1. Essa foi a solução encontrada. Agora traz os dias NULL do dia atual até o final do mês. SELECT date_part('year', data)as ano , SUM(CASE WHEN date_part('day',data) = '1' THEN 1 ELSE (CASE WHEN ('1' <= date_part('day', now()) OR date_part('year', now()) <> date_part('year', data)) THEN 0 ELSE null END) END) AS "01", SUM(CASE WHEN date_part('day',data) = '2' THEN 1 ELSE (CASE WHEN ('2' <= date_part('day', now()) OR date_part('year', now()) <> date_part('year', data)) THEN 0 ELSE null END) END) AS "02", SUM(CASE WHEN date_part('day',data) = '3' THEN 1 ELSE (CASE WHEN ('3' <= date_part('day', now()) OR date_part('year', now()) <> date_part('year', data)) THEN 0 ELSE null END) END) AS "03", SUM(CASE WHEN date_part('day',data) = '4' THEN 1 ELSE (CASE WHEN ('4' <= date_part('day', now()) OR date_part('year', now()) <> date_part('year', data)) THEN 0 ELSE null END) END) AS "04", SUM(CASE WHEN date_part('day',data) = '5' THEN 1 ELSE (CASE WHEN ('5' <= date_part('day', now()) OR date_part('year', now()) <> date_part('year', data)) THEN 0 ELSE null END) END) AS "05", SUM(CASE WHEN date_part('day',data) = '6' THEN 1 ELSE (CASE WHEN ('6' <= date_part('day', now()) OR date_part('year', now()) <> date_part('year', data)) THEN 0 ELSE null END) END) AS "06", SUM(CASE WHEN date_part('day',data) = '7' THEN 1 ELSE (CASE WHEN ('7' <= date_part('day', now()) OR date_part('year', now()) <> date_part('year', data)) THEN 0 ELSE null END) END) AS "07", SUM(CASE WHEN date_part('day',data) = '8' THEN 1 ELSE (CASE WHEN ('8' <= date_part('day', now()) OR date_part('year', now()) <> date_part('year', data)) THEN 0 ELSE null END) END) AS "08", SUM(CASE WHEN date_part('day',data) = '9' THEN 1 ELSE (CASE WHEN ('9' <= date_part('day', now()) OR date_part('year', now()) <> date_part('year', data)) THEN 0 ELSE null END) END) AS "09", SUM(CASE WHEN date_part('day',data) = '10' THEN 1 ELSE (CASE WHEN ('10' <= date_part('day', now()) OR date_part('year', now()) <> date_part('year', data)) THEN 0 ELSE null END) END) AS "10", SUM(CASE WHEN date_part('day',data) = '11' THEN 1 ELSE (CASE WHEN ('11' <= date_part('day', now()) OR date_part('year', now()) <> date_part('year', data))THEN 0 ELSE null END) END) AS "11", SUM(CASE WHEN date_part('day',data) = '12' THEN 1 ELSE (CASE WHEN ('12' <= date_part('day', now()) OR date_part('year', now()) <> date_part('year', data)) THEN 0 ELSE null END) END) AS "12", SUM(CASE WHEN date_part('day',data) = '13' THEN 1 ELSE (CASE WHEN ('13' <= date_part('day', now()) OR date_part('year', now()) <> date_part('year', data)) THEN 0 ELSE null END) END) AS "13", SUM(CASE WHEN date_part('day',data) = '14' THEN 1 ELSE (CASE WHEN ('14' <= date_part('day', now()) OR date_part('year', now()) <> date_part('year', data)) THEN 0 ELSE null END) END) AS "14", SUM(CASE WHEN date_part('day',data) = '15' THEN 1 ELSE (CASE WHEN ('15' <= date_part('day', now()) OR date_part('year', now()) <> date_part('year', data)) THEN 0 ELSE null END) END) AS "15", SUM(CASE WHEN date_part('day',data) = '16' THEN 1 ELSE (CASE WHEN ('16' <= date_part('day', now()) OR date_part('year', now()) <> date_part('year', data)) THEN 0 ELSE null END) END) AS "16", SUM(CASE WHEN date_part('day',data) = '17' THEN 1 ELSE (CASE WHEN ('17' <= date_part('day', now()) OR date_part('year', now()) <> date_part('year', data)) THEN 0 ELSE null END) END) AS "17", SUM(CASE WHEN date_part('day',data) = '18' THEN 1 ELSE (CASE WHEN ('18' <= date_part('day', now()) OR date_part('year', now()) <> date_part('year', data)) THEN 0 ELSE null END) END) AS "18", SUM(CASE WHEN date_part('day',data) = '19' THEN 1 ELSE (CASE WHEN ('19' <= date_part('day', now()) OR date_part('year', now()) <> date_part('year', data)) THEN 0 ELSE null END) END) AS "19", SUM(CASE WHEN date_part('day',data) = '20' THEN 1 ELSE (CASE WHEN ('20' <= date_part('day', now()) OR date_part('year', now()) <> date_part('year', data)) THEN 0 ELSE null END) END) AS "20", SUM(CASE WHEN date_part('day',data) = '21' THEN 1 ELSE (CASE WHEN ('21' <= date_part('day', now()) OR date_part('year', now()) <> date_part('year', data))THEN 0 ELSE null END) END) AS "21", SUM(CASE WHEN date_part('day',data) = '22' THEN 1 ELSE (CASE WHEN ('22' <= date_part('day', now()) OR date_part('year', now()) <> date_part('year', data)) THEN 0 ELSE null END) END) AS "22", SUM(CASE WHEN date_part('day',data) = '23' THEN 1 ELSE (CASE WHEN ('23' <= date_part('day', now()) OR date_part('year', now()) <> date_part('year', data))THEN 0 ELSE null END) END) AS "23", SUM(CASE WHEN date_part('day',data) = '24' THEN 1 ELSE (CASE WHEN ('24' <= date_part('day', now()) OR date_part('year', now()) <> date_part('year', data)) THEN 0 ELSE null END) END) AS "24", SUM(CASE WHEN date_part('day',data) = '25' THEN 1 ELSE (CASE WHEN ('25' <= date_part('day', now()) OR date_part('year', now()) <> date_part('year', data)) THEN 0 ELSE null END) END) AS "25", SUM(CASE WHEN date_part('day',data) = '26' THEN 1 ELSE (CASE WHEN ('26' <= date_part('day', now()) OR date_part('year', now()) <> date_part('year', data)) THEN 0 ELSE null END) END) AS "26", SUM(CASE WHEN date_part('day',data) = '27' THEN 1 ELSE (CASE WHEN ('27' <= date_part('day', now()) OR date_part('year', now()) <> date_part('year', data)) THEN 0 ELSE null END) END) AS "27", SUM(CASE WHEN date_part('day',data) = '28' THEN 1 ELSE (CASE WHEN ('28' <= date_part('day', now()) OR date_part('year', now()) <> date_part('year', data)) THEN 0 ELSE null END) END) AS "28", SUM(CASE WHEN date_part('day',data) = '29' THEN 1 ELSE (CASE WHEN ('29' <= date_part('day', now()) OR date_part('year', now()) <> date_part('year', data)) THEN 0 ELSE null END) END) AS "29", SUM(CASE WHEN date_part('day',data) = '30' THEN 1 ELSE (CASE WHEN ('30' <= date_part('day', now()) OR date_part('year', now()) <> date_part('year', data)) THEN 0 ELSE null END) END) AS "30", SUM(CASE WHEN date_part('day',data) = '31' THEN 1 ELSE (CASE WHEN ('31' <= date_part('day', now()) OR date_part('year', now()) <> date_part('year', data)) THEN 0 ELSE null END) END) AS "31", COUNT(*) as Total from controle_mortes WHERE subjetividade = 'CVLI' AND date_part('MONTH', data) = 01 AND UPPER(cidade) = 'ARAPIRACA' GROUP BY ano ORDER BY ano;
  2. Eu fiz algumas alterações e talvez agora fique mais fácil para me ajudar. O que eu preciso agora é que os dias após a data de hoje apareçam como NULL para o ano somente de 2015, por exemplo hoje é dia 19, dessa forma do dia 20 ao 31, no ano de 2015, os valores devem ser NULL. Abaixo está o código e o resultado. SELECT date_part('year', data) as ano, SUM(CASE WHEN date_part('day',data) = 1 THEN 1 ELSE 0 END)AS "01", SUM(CASE WHEN date_part('day',data) = 2 THEN 1 ELSE 0 END)AS "02", SUM(CASE WHEN date_part('day',data) = 3 THEN 1 ELSE 0 END)AS "03", SUM(CASE WHEN date_part('day',data) = 4 THEN 1 ELSE 0 END)AS "04", SUM(CASE WHEN date_part('day',data) = 5 THEN 1 ELSE 0 END)AS "05", SUM(CASE WHEN date_part('day',data) = 6 THEN 1 ELSE 0 END)AS "06", SUM(CASE WHEN date_part('day',data) = 7 THEN 1 ELSE 0 END)AS "07", SUM(CASE WHEN date_part('day',data) = 8 THEN 1 ELSE 0 END)AS "08", SUM(CASE WHEN date_part('day',data) = 9 THEN 1 ELSE 0 END)AS "09", SUM(CASE WHEN date_part('day',data) = 10 THEN 1 ELSE 0 END)AS "10", SUM(CASE WHEN date_part('day',data) = 11 THEN 1 ELSE 0 END)AS "11", SUM(CASE WHEN date_part('day',data) = 12 THEN 1 ELSE 0 END)AS "12", SUM(CASE WHEN date_part('day',data) = 13 THEN 1 ELSE 0 END)AS "13", SUM(CASE WHEN date_part('day',data) = 14 THEN 1 ELSE 0 END)AS "14", SUM(CASE WHEN date_part('day',data) = 15 THEN 1 ELSE 0 END)AS "15", SUM(CASE WHEN date_part('day',data) = 16 THEN 1 ELSE 0 END)AS "16", SUM(CASE WHEN date_part('day',data) = 17 THEN 1 ELSE 0 END)AS "17", SUM(CASE WHEN date_part('day',data) = 18 THEN 1 ELSE 0 END)AS "18", SUM(CASE WHEN date_part('day',data) = 19 THEN 1 ELSE 0 END)AS "19", SUM(CASE WHEN date_part('day',data) = 20 THEN 1 ELSE 0 END)AS "20", SUM(CASE WHEN date_part('day',data) = 21 THEN 1 ELSE 0 END)AS "21", SUM(CASE WHEN date_part('day',data) = 22 THEN 1 ELSE 0 END)AS "22", SUM(CASE WHEN date_part('day',data) = 23 THEN 1 ELSE 0 END)AS "23", SUM(CASE WHEN date_part('day',data) = 24 THEN 1 ELSE 0 END)AS "24", SUM(CASE WHEN date_part('day',data) = 25 THEN 1 ELSE 0 END)AS "25", SUM(CASE WHEN date_part('day',data) = 26 THEN 1 ELSE 0 END)AS "26", SUM(CASE WHEN date_part('day',data) = 27 THEN 1 ELSE 0 END)AS "27", SUM(CASE WHEN date_part('day',data) = 28 THEN 1 ELSE 0 END)AS "28", SUM(CASE WHEN date_part('day',data) = 29 THEN 1 ELSE 0 END)AS "29", SUM(CASE WHEN date_part('day',data) = 30 THEN 1 ELSE 0 END)AS "30", SUM(CASE WHEN date_part('day',data) = 31 THEN 1 ELSE 0 END)AS "31", COUNT(*) as Total from admgis.controle_mortes WHERE subjetividade = 'CVLI' AND date_part('MONTH',data) = 01 AND UPPER(cidade) = 'ARAPIRACA' GROUP BY ano ORDER BY ano;
  3. <script type='text/javascript'>window.mod_pagespeed_start = Number(new Date());</script> Kakao o resultado foi semelhante ao que consegui, entretanto os dias que não tiveram registros não foram listados, tais como dia 10, 12. Além disto essa sql colocou null nos dias anteriores ao dia de hoje no ano de 2015. Inclusive isso eu já até resolvi, o que estou precisando agora seria listar os dias que estão zerados nos 4 anos.
  4. <script type='text/javascript'>window.mod_pagespeed_start = Number(new Date());</script> 8.3.8
  5. <script type='text/javascript'>window.mod_pagespeed_start = Number(new Date());</script> Muito obrigado pela atenção Dr. House. Não funcionou, os dias 4, 10, 12, 15 continuam sem vir.
  6. <script type='text/javascript'>window.mod_pagespeed_start = Number(new Date());</script> Kakao muito obrigado pela atenção. Agora deu esse erro: [Err] ERROR: function generate_series(timestamp without time zone, unknown, unknown) does not exist LINE 11: generate_series ( ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.
  7. Tenho uma SQL que estou tentando rodar no Postgres, para que me retorne os valores diariamente por ano. Com uma ressalva, preciso que os dias restantes do mês de janeiro estejam sem os zeros para o ano de 2015. Consegui resolver esta questão dos dias seguintes virem nulos ao invés dos zeros. Mas os dias do mês que estão zerados nos quatro anos ele simplesmente não lista. Tais como os dias 4, 10, 12. Abaixo está o código e uma imagem do resultado. Como poderia fazer para que no resultado os anos que estão zerados traga o zero? SELECT CASE DATE_PART('DAY', DATA) when 01 then '01' when 02 then '02' when 03 then '03' when 04 then '04' when 05 then '05' when 06 then '06' when 07 then '07' when 08 then '08' when 09 then '09' when 10 then '10' when 11 then '11' when 12 then '12' when 13 then '13' when 14 then '14' when 15 then '15' when 16 then '16' when 17 then '17' when 18 then '18' when 19 then '19' when 20 then '20' when 21 then '21' when 22 then '22' when 23 then '23' when 24 then '24' when 25 then '25' when 26 then '26' when 27 then '27' when 28 then '28' when 29 then '29' when 30 then '30' when 31 then '31' end AS DIA_SEM, SUM(CASE WHEN date_part('year',data) = 2012 THEN 1 ELSE 0 END) AS "2012", SUM(CASE WHEN date_part('year',data) = 2013 THEN 1 ELSE 0 END) AS "2013", SUM(CASE WHEN date_part('year',data) = 2014 THEN 1 ELSE 0 END) AS "2014", SUM(CASE WHEN date_part('day', "data") > date_part('day',CURRENT_DATE) THEN NULL ELSE (CASE WHEN date_part('year',data) = 2015 THEN 1 ELSE 0 END) END) AS "2015", "count"(*) AS TOTAL from admgis.controle_mortes WHERE subjetividade = 'CVLI' AND cidade = 'Arapiraca' AND date_part('MONTH',data) = 01 GROUP BY DIA_SEM ORDER BY DIA_SEM
  8. <script type='text/javascript'>window.mod_pagespeed_start = Number(new Date());</script> Olá hutuh muito obrigado pela sua valorosa sugestão. Utilizei sua dica que removia o Utf-8 e em relação aos caracteres agora aparecem corretamente. Agora o problema de quando clicar no botão: "atualizar meus dados" continua, não encaminha para página correspondente. Clico e nada acontece, vale salientar que isto ocorre apenas com emails do hotmail. Você tem alguma sugestão?
  9. Eu tenho um sistema para recuperação de senha perdida, configurei um smtp do gmail, o email é enviado para o email informado no form. Só que estou tendo um problema: quando o email do usuário é do gmail o email chega certinho e quando o usuário clica no botão "Atualizar Meus Dados" é redirecionado para a página correta. Mas quando o email do usuário é do hotmail, o botão não faz nada, além das palavras que possuem acentuação não aparecem corretamente. No gmail tudo funciona conforme o planejado. O que pode ser? Abaixo está o código: <!DOCTYPE HTML> <html lang="br" class="no-js"> <head> <meta charset="utf-8"> <title>Sistema de Login e Senha Criptografados</title> <link href="../style.css" rel="stylesheet" /> </head> <body> <div id="conteudo"> <h1>Sistema de login e senha criptografados - Verificando Informações</h1> <div class="borda"></div> <?php include "conexao.php"; //Praticamente faço as mesmas validações que fizemos para o cadastrado do usuário no banco de dados. //Recebendo os dados e tratando os mesmos para inserção no banco $recebeEmail = filter_input(INPUT_POST, 'email', FILTER_VALIDATE_EMAIL); $confereEmail = filter_input(INPUT_POST, 'email', FILTER_SANITIZE_MAGIC_QUOTES); //Nesse if, faço uma conferência em relação ao e-mail informado. Se não for informado nenhum, retorno a mensagem para que o usuário informe corretamente if ($recebeEmail == NULL ) { echo "<p>O endereço de e-mail precisa ser informado!"; echo "<p><a href='javascript:history.back();'>Voltar</a></p>"; return false; } //Aqui faço a segunda parte da verificação: vejo se no endereço de e-mail foi utilizado algum caractere especial //Isso serve para evitar uma possível invasão sql no banco de dados, possibilitando assim a proteção e integridade dos dados //Nesse caso, eu comparo os nomes. Se forem iguais, após passarem pelos filtros, eu inicio a criptografia. Se não forem, peço que volte à página anterior else if ($recebeEmail != $confereEmail) { echo "<p>Você informou o seguinte endereço de e-mail: <strong>$confereEmail</strong> .</p>"; echo "<p>Por favor, não utilize caracteres especiais (tais como aspas simples ou duplas e/ou barras!) no campo <strong>Informe o E-mail</strong>.</p>"; echo "<p><a href='javascript:history.back();'>Volte</a> para a página anterior e tente novamente! Obrigado!</p>"; return false; } /* Agora vamos consultar no banco de dados para ver se existe realmente esse cadastro Vamos verificar ambos os dados: E-mail e ainda se o campo "ATIVO" está setado como SIM */ else{ $consultaInformacoes = pg_query($dbconn, "SELECT * FROM usuarios.usuario WHERE email = '$recebeEmail' AND ativo = 'SIM'") or die (pg_last_error()); $verificaInformacoes = pg_num_rows($consultaInformacoes); if ($verificaInformacoes == 1){ echo "<p>O e-mail informado (<strong><em>$confereEmail</em></strong>) consta de nossa base de dados.</p> <p>Acesse sua caixa de entrada. Se a mensagem não for encontrada, verifique se não está na caixa de spam!</p>"; include('PHPMailer/PHPMailerAutoload.php'); $mail = new PHPMailer(); /* ######################### * # CONFIGURAÇÕES BÁSICAS # * ######################### */ $assunto = "..:: Recuperação de dados ArcGIS::.."; $mensagem = utf8_decode(' <hr /> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Recuperação de Dados</title> <style type="text/css"> <!-- .style1 { font-family: "Trebuchet MS", Arial; font-size: 16px; color: #FFFFFF; } .style4 { font-family: "Trebuchet MS", Arial; font-size: 12px; color: #333333; font-weight: bold; } --> </style></head> <body> <form method="post" action="http://seudominio.com.br/novo/senha/exclusivo/atualizaInformacoes.php"> <fieldset> <legend>Recuperação de Dados de Acesso</legend> <label for="informacao">Para recuperar seus dados, clique no botão "Atualizar Meus Dados"!</label> <input type="hidden" name="confereEmail" value="'.$confereEmail.'" /><br /> <input type="submit" value="Atualizar Meus Dados" /> </fieldset> </form> </body> </html> <hr />'); $seu_email = 'seuemail@gmail.com'; $seu_nome = 'seunome'; $sua_senha = 'suasenha'; /* Se for do Gmail o servidor é: smtp.gmail.com */ $host_do_email = 'smtp.gmail.com'; /* Configura os destinatários (pra quem vai o email) */ $mail->AddAddress($recebeEmail); // $mail->AddAddress('email@email.com'); // $mail->AddCC('email@email.com', 'Nome da pessoa'); // Copia // $mail->AddBCC('email@email.com', 'Nome da pessoa'); // Cópia Oculta /* ########################### * # CONFIGURAÇÕES AVANÇADAS # * ########################### */ /* Mostra o erros*/ $email->SMTPDebug = 2; /* Define que é uma conexão SMTP */ $mail->IsSMTP(); /* Define o endereço do servidor de envio */ $mail->Host = $host_do_email; /* Utilizar autenticação SMTP */ $mail->SMTPAuth = true; /* Protocolo da conexão */ $mail->SMTPSecure = "tls"; /* Porta da conexão */ $mail->Port = "587"; /* Email ou usuário para autenticação */ $mail->Username = $seu_email; /* Senha do usuário */ $mail->Password = $sua_senha; /* Configura os dados do remetente do email */ $mail->From = $seu_email; // Seu e-mail $mail->FromName = $seu_nome; // Seu nome /* Configura a mensagem */ $mail->IsHTML(true); // Configura um e-mail em HTML /* * Se tiver problemas com acentos, modifique o charset * para ISO-8859-1 */ $mail->CharSet = 'UTF-8'; // Charset da mensagem (opcional) /* Configura o texto e assunto */ $mail->Subject = $assunto; // Assunto da mensagem $mail->Body = $mensagem; // A mensagem em HTML $mail->AltBody = trim(strip_tags($mensagem)); // A mesma mensagem em texto puro /* Configura o anexo a ser enviado (se tiver um) */ //$mail->AddAttachment("foto.jpg", "foto.jpg"); // Insere um anexo /* Envia o email */ $email_enviado = $mail->Send(); /* Limpa tudo */ $mail->ClearAllRecipients(); $mail->ClearAttachments(); /* Mostra se o email foi enviado ou não */ if ($email_enviado) { echo "Email enviado!"; } else { echo "<p>Endereço de e-mail informado não consta em nossa base de dados. Por favor, <a href='javascript:history.back();'>volte</a> e tente novamente!</p>"; } } else { //Se nenhuma das confirmações acima foram efetuadas, mais uma vez, retorno uma mensagem de erro ao usuário. echo "<p>Endereço de e-mail informado não consta em nossa base de dados. Por favor, <a href='javascript:history.back();'>volte</a> e tente novamente!</p>"; } } ?> </div>
  10. Galera criei duas tabelas uma produto e outra movimentacao, sendo que depois dai travei, preciso formulario para cadastrar novos produtos e outro para atualizar o estoque. na tabela movimentacao tem o campo tipomovi, que devera indicar se entrada ou saida, onde apos concluir o registro automaticamente atualizar o estoque. Detalhe iniciei no access há uma semana, pouco conhecimento tecnico. Segue o link até onde cheguei: banco teste
  11. Muito obrigado segui suas dicas. Desde já agradeço a atenção!
  12. Consegui resolver, descobri que coloquei sem querer uma mastertable por cima de uma já existente. Desde já agradeço a atenção!
  13. private void initComponents() { bindingGroup = new org.jdesktop.beansbinding.BindingGroup(); entityManager = java.beans.Beans.isDesignTime() ? null : javax.persistence.Persistence.createEntityManagerFactory("siscomjavaPU").createEntityManager(); query = java.beans.Beans.isDesignTime() ? null : entityManager.createQuery("SELECT C FROM Cliente C"); list = java.beans.Beans.isDesignTime() ? java.util.Collections.emptyList() : org.jdesktop.observablecollections.ObservableCollections.observableList(query.getResultList()); jPanel1 = new javax.swing.JPanel(); masterScrollPane = new javax.swing.JScrollPane(); masterTable = new javax.swing.JTable(); masterScrollPane1 = new javax.swing.JScrollPane(); masterTable1 = new javax.swing.JTable(); newButton = new javax.swing.JButton(); deleteButton = new javax.swing.JButton(); jButton1 = new javax.swing.JButton(); jPanel2 = new javax.swing.JPanel(); detailScrollPane = new javax.swing.JScrollPane(); detailTable = new javax.swing.JTable(); detailScrollPane1 = new javax.swing.JScrollPane(); detailTable1 = new javax.swing.JTable(); saveButton = new javax.swing.JButton(); refreshButton = new javax.swing.JButton(); deleteDetailButton = new javax.swing.JButton(); newDetailButton = new javax.swing.JButton(); FormListener formListener = new FormListener(); jPanel1.setBorder(javax.swing.BorderFactory.createTitledBorder(null, "Dados do Cliente", javax.swing.border.TitledBorder.DEFAULT_JUSTIFICATION, javax.swing.border.TitledBorder.DEFAULT_POSITION, new java.awt.Font("Tahoma", 0, 11), new java.awt.Color(0, 70, 213))); // NOI18N masterTable.setAutoResizeMode(javax.swing.JTable.AUTO_RESIZE_OFF); org.jdesktop.swingbinding.JTableBinding jTableBinding = org.jdesktop.swingbinding.SwingBindings.createJTableBinding(org.jdesktop.beansbinding.AutoBinding.UpdateStrategy.READ_WRITE, list, masterTable); org.jdesktop.swingbinding.JTableBinding.ColumnBinding columnBinding = jTableBinding.addColumnBinding(org.jdesktop.beansbinding.ELProperty.create("${nomeCliente}")); columnBinding.setColumnName("Nome"); columnBinding.setColumnClass(String.class); columnBinding = jTableBinding.addColumnBinding(org.jdesktop.beansbinding.ELProperty.create("${cpfCliente}")); columnBinding.setColumnName("CPF"); columnBinding.setColumnClass(String.class); columnBinding = jTableBinding.addColumnBinding(org.jdesktop.beansbinding.ELProperty.create("${rgCliente}")); columnBinding.setColumnName("RG"); columnBinding.setColumnClass(String.class); columnBinding = jTableBinding.addColumnBinding(org.jdesktop.beansbinding.ELProperty.create("${orgaoRgCliente}")); columnBinding.setColumnName("Órgão RG"); columnBinding.setColumnClass(String.class); columnBinding = jTableBinding.addColumnBinding(org.jdesktop.beansbinding.ELProperty.create("${dataNascimentoCliente}")); columnBinding.setColumnName("Data Nascimento"); columnBinding.setColumnClass(java.util.Date.class); columnBinding = jTableBinding.addColumnBinding(org.jdesktop.beansbinding.ELProperty.create("${foneCliente}")); columnBinding.setColumnName("Fone Cliente"); columnBinding.setColumnClass(String.class); columnBinding = jTableBinding.addColumnBinding(org.jdesktop.beansbinding.ELProperty.create("${emailCliente}")); columnBinding.setColumnName("Email"); columnBinding.setColumnClass(String.class); columnBinding = jTableBinding.addColumnBinding(org.jdesktop.beansbinding.ELProperty.create("${profissaoCliente}")); columnBinding.setColumnName("Profissão"); columnBinding.setColumnClass(String.class); columnBinding = jTableBinding.addColumnBinding(org.jdesktop.beansbinding.ELProperty.create("${empresaCliente}")); columnBinding.setColumnName("Empresa"); columnBinding.setColumnClass(String.class); columnBinding = jTableBinding.addColumnBinding(org.jdesktop.beansbinding.ELProperty.create("${foneEmpresa}")); columnBinding.setColumnName("Fone Empresa"); columnBinding.setColumnClass(String.class); columnBinding = jTableBinding.addColumnBinding(org.jdesktop.beansbinding.ELProperty.create("${rendaCliente}")); columnBinding.setColumnName("Renda"); columnBinding.setColumnClass(Double.class); columnBinding = jTableBinding.addColumnBinding(org.jdesktop.beansbinding.ELProperty.create("${tipoCliente}")); columnBinding.setColumnName("Tipo Cliente"); columnBinding.setColumnClass(Character.class); columnBinding = jTableBinding.addColumnBinding(org.jdesktop.beansbinding.ELProperty.create("${cnpjCliente}")); columnBinding.setColumnName("CNPJ"); columnBinding.setColumnClass(String.class); columnBinding = jTableBinding.addColumnBinding(org.jdesktop.beansbinding.ELProperty.create("${referenciaCliente}")); columnBinding.setColumnName("Referência"); columnBinding.setColumnClass(String.class); columnBinding = jTableBinding.addColumnBinding(org.jdesktop.beansbinding.ELProperty.create("${foneReferencia}")); columnBinding.setColumnName("Fone Referência"); columnBinding.setColumnClass(String.class); bindingGroup.addBinding(jTableBinding); jTableBinding.bind(); masterScrollPane.setViewportView(masterTable); jTableBinding = org.jdesktop.swingbinding.SwingBindings.createJTableBinding(org.jdesktop.beansbinding.AutoBinding.UpdateStrategy.READ_WRITE, list, masterTable); columnBinding = jTableBinding.addColumnBinding(org.jdesktop.beansbinding.ELProperty.create("${nomeCliente}")); columnBinding.setColumnName("Nome"); columnBinding.setColumnClass(String.class); columnBinding = jTableBinding.addColumnBinding(org.jdesktop.beansbinding.ELProperty.create("${cpfCliente}")); columnBinding.setColumnName("CPF"); columnBinding.setColumnClass(String.class); columnBinding = jTableBinding.addColumnBinding(org.jdesktop.beansbinding.ELProperty.create("${rgCliente}")); columnBinding.setColumnName("RG"); columnBinding.setColumnClass(String.class); columnBinding = jTableBinding.addColumnBinding(org.jdesktop.beansbinding.ELProperty.create("${orgaoRgCliente}")); columnBinding.setColumnName("Órgão RG"); columnBinding.setColumnClass(String.class); columnBinding = jTableBinding.addColumnBinding(org.jdesktop.beansbinding.ELProperty.create("${dataNascimentoCliente}")); columnBinding.setColumnName("Data Nascimento"); columnBinding.setColumnClass(java.util.Date.class); columnBinding = jTableBinding.addColumnBinding(org.jdesktop.beansbinding.ELProperty.create("${foneCliente}")); columnBinding.setColumnName("Fone Cliente"); columnBinding.setColumnClass(String.class); columnBinding = jTableBinding.addColumnBinding(org.jdesktop.beansbinding.ELProperty.create("${emailCliente}")); columnBinding.setColumnName("Email"); columnBinding.setColumnClass(String.class); columnBinding = jTableBinding.addColumnBinding(org.jdesktop.beansbinding.ELProperty.create("${profissaoCliente}")); columnBinding.setColumnName("Profissão"); columnBinding.setColumnClass(String.class); columnBinding = jTableBinding.addColumnBinding(org.jdesktop.beansbinding.ELProperty.create("${empresaCliente}")); columnBinding.setColumnName("Empresa"); columnBinding.setColumnClass(String.class); columnBinding = jTableBinding.addColumnBinding(org.jdesktop.beansbinding.ELProperty.create("${foneEmpresa}")); columnBinding.setColumnName("Fone Empresa"); columnBinding.setColumnClass(String.class); columnBinding = jTableBinding.addColumnBinding(org.jdesktop.beansbinding.ELProperty.create("${rendaCliente}")); columnBinding.setColumnName("Renda"); columnBinding.setColumnClass(Double.class); columnBinding = jTableBinding.addColumnBinding(org.jdesktop.beansbinding.ELProperty.create("${tipoCliente}")); columnBinding.setColumnName("Tipo Cliente"); columnBinding.setColumnClass(Character.class); columnBinding = jTableBinding.addColumnBinding(org.jdesktop.beansbinding.ELProperty.create("${cnpjCliente}")); columnBinding.setColumnName("CNPJ"); columnBinding.setColumnClass(String.class); columnBinding = jTableBinding.addColumnBinding(org.jdesktop.beansbinding.ELProperty.create("${referenciaCliente}")); columnBinding.setColumnName("Referência"); columnBinding.setColumnClass(String.class); columnBinding = jTableBinding.addColumnBinding(org.jdesktop.beansbinding.ELProperty.create("${foneReferencia}")); columnBinding.setColumnName("Fone Referência"); columnBinding.setColumnClass(String.class); bindingGroup.addBinding(jTableBinding); jTableBinding.bind(); masterScrollPane1.setViewportView(masterTable1); masterTable1.getColumnModel().getColumn(4).setPreferredWidth(110); masterTable1.getColumnModel().getColumn(9).setPreferredWidth(100); masterTable1.getColumnModel().getColumn(14).setPreferredWidth(110); newButton.setText("Inserir Cliente"); newButton.addActionListener(formListener); deleteButton.setText("Excluir Cliente"); org.jdesktop.beansbinding.Binding binding = org.jdesktop.beansbinding.Bindings.createAutoBinding(org.jdesktop.beansbinding.AutoBinding.UpdateStrategy.READ_WRITE, masterTable, org.jdesktop.beansbinding.ELProperty.create("${selectedElement != null}"), deleteButton, org.jdesktop.beansbinding.BeanProperty.create("enabled")); bindingGroup.addBinding(binding); deleteButton.addActionListener(formListener); jButton1.setText("Editar Cliente"); binding = org.jdesktop.beansbinding.Bindings.createAutoBinding(org.jdesktop.beansbinding.AutoBinding.UpdateStrategy.READ_WRITE, masterTable, org.jdesktop.beansbinding.ELProperty.create("${selectedElement != null}"), jButton1, org.jdesktop.beansbinding.BeanProperty.create("enabled")); bindingGroup.addBinding(binding); jButton1.addActionListener(formListener); 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.TRAILING) .addGroup(jPanel1Layout.createSequentialGroup() .addComponent(newButton) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addComponent(jButton1) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addComponent(deleteButton)) .addComponent(masterScrollPane, javax.swing.GroupLayout.PREFERRED_SIZE, 1126, javax.swing.GroupLayout.PREFERRED_SIZE)) .addContainerGap(20, Short.MAX_VALUE)) ); jPanel1Layout.linkSize(javax.swing.SwingConstants.HORIZONTAL, new java.awt.Component[] {deleteButton, newButton}); jPanel1Layout.setVerticalGroup( jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel1Layout.createSequentialGroup() .addContainerGap() .addComponent(masterScrollPane, javax.swing.GroupLayout.DEFAULT_SIZE, 130, Short.MAX_VALUE) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(deleteButton) .addComponent(newButton) .addComponent(jButton1)) .addContainerGap()) ); jPanel2.setBorder(javax.swing.BorderFactory.createTitledBorder(null, "Endereços do Cliente", javax.swing.border.TitledBorder.DEFAULT_JUSTIFICATION, javax.swing.border.TitledBorder.DEFAULT_POSITION, new java.awt.Font("Tahoma", 0, 11), new java.awt.Color(0, 70, 213))); // NOI18N detailTable.setAutoResizeMode(javax.swing.JTable.AUTO_RESIZE_OFF); org.jdesktop.beansbinding.ELProperty eLProperty = org.jdesktop.beansbinding.ELProperty.create("${selectedElement.clienteEnderecoCollection}"); jTableBinding = org.jdesktop.swingbinding.SwingBindings.createJTableBinding(org.jdesktop.beansbinding.AutoBinding.UpdateStrategy.READ_WRITE, masterTable, eLProperty, detailTable); columnBinding = jTableBinding.addColumnBinding(org.jdesktop.beansbinding.ELProperty.create("${cepEndereco}")); columnBinding.setColumnName("CEP"); columnBinding.setColumnClass(String.class); columnBinding = jTableBinding.addColumnBinding(org.jdesktop.beansbinding.ELProperty.create("${logradouroEndereco}")); columnBinding.setColumnName("Logradouro"); columnBinding.setColumnClass(String.class); columnBinding = jTableBinding.addColumnBinding(org.jdesktop.beansbinding.ELProperty.create("${complementoEndereco}")); columnBinding.setColumnName("Complemento "); columnBinding.setColumnClass(String.class); columnBinding = jTableBinding.addColumnBinding(org.jdesktop.beansbinding.ELProperty.create("${cidadeEndereco}")); columnBinding.setColumnName("Cidade"); columnBinding.setColumnClass(String.class); columnBinding = jTableBinding.addColumnBinding(org.jdesktop.beansbinding.ELProperty.create("${ufEndereco}")); columnBinding.setColumnName("UF"); columnBinding.setColumnClass(String.class); jTableBinding.setSourceUnreadableValue(null); bindingGroup.addBinding(jTableBinding); jTableBinding.bind(); detailScrollPane.setViewportView(detailTable); eLProperty = org.jdesktop.beansbinding.ELProperty.create("${selectedElement.clienteEnderecoCollection}"); jTableBinding = org.jdesktop.swingbinding.SwingBindings.createJTableBinding(org.jdesktop.beansbinding.AutoBinding.UpdateStrategy.READ_WRITE, masterTable, eLProperty, detailTable); columnBinding = jTableBinding.addColumnBinding(org.jdesktop.beansbinding.ELProperty.create("${cepEndereco}")); columnBinding.setColumnName("CEP"); columnBinding.setColumnClass(String.class); columnBinding = jTableBinding.addColumnBinding(org.jdesktop.beansbinding.ELProperty.create("${logradouroEndereco}")); columnBinding.setColumnName("Logradouro"); columnBinding.setColumnClass(String.class); columnBinding = jTableBinding.addColumnBinding(org.jdesktop.beansbinding.ELProperty.create("${complementoEndereco}")); columnBinding.setColumnName("Complemento "); columnBinding.setColumnClass(String.class); columnBinding = jTableBinding.addColumnBinding(org.jdesktop.beansbinding.ELProperty.create("${cidadeEndereco}")); columnBinding.setColumnName("Cidade"); columnBinding.setColumnClass(String.class); columnBinding = jTableBinding.addColumnBinding(org.jdesktop.beansbinding.ELProperty.create("${ufEndereco}")); columnBinding.setColumnName("UF"); columnBinding.setColumnClass(String.class); jTableBinding.setSourceUnreadableValue(null); bindingGroup.addBinding(jTableBinding); jTableBinding.bind(); detailScrollPane1.setViewportView(detailTable1); saveButton.setText("Salvar"); saveButton.addActionListener(formListener); refreshButton.setText("Cancelar Alterações"); refreshButton.addActionListener(formListener); deleteDetailButton.setText("Excluir Endereço"); binding = org.jdesktop.beansbinding.Bindings.createAutoBinding(org.jdesktop.beansbinding.AutoBinding.UpdateStrategy.READ, detailTable, org.jdesktop.beansbinding.ELProperty.create("${selectedElement != null}"), deleteDetailButton, org.jdesktop.beansbinding.BeanProperty.create("enabled")); bindingGroup.addBinding(binding); deleteDetailButton.addActionListener(formListener); newDetailButton.setText("Inserir Endereço"); binding = org.jdesktop.beansbinding.Bindings.createAutoBinding(org.jdesktop.beansbinding.AutoBinding.UpdateStrategy.READ, masterTable, org.jdesktop.beansbinding.ELProperty.create("${selectedElement != null}"), newDetailButton, org.jdesktop.beansbinding.BeanProperty.create("enabled")); bindingGroup.addBinding(binding); newDetailButton.addActionListener(formListener); javax.swing.GroupLayout jPanel2Layout = new javax.swing.GroupLayout(jPanel2); jPanel2.setLayout(jPanel2Layout); jPanel2Layout.setHorizontalGroup( jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(jPanel2Layout.createSequentialGroup() .addContainerGap() .addComponent(detailScrollPane, javax.swing.GroupLayout.PREFERRED_SIZE, 1126, javax.swing.GroupLayout.PREFERRED_SIZE) .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)) .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel2Layout.createSequentialGroup() .addContainerGap(602, Short.MAX_VALUE) .addComponent(newDetailButton) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addComponent(deleteDetailButton) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addComponent(refreshButton) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addComponent(saveButton) .addContainerGap()) ); jPanel2Layout.linkSize(javax.swing.SwingConstants.HORIZONTAL, new java.awt.Component[] {deleteDetailButton, newDetailButton, refreshButton, saveButton}); jPanel2Layout.setVerticalGroup( jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel2Layout.createSequentialGroup() .addContainerGap() .addComponent(detailScrollPane, javax.swing.GroupLayout.DEFAULT_SIZE, 107, Short.MAX_VALUE) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(newDetailButton) .addComponent(saveButton) .addComponent(refreshButton) .addComponent(deleteDetailButton)) .addContainerGap()) ); javax.swing.GroupLayout layout = new javax.swing.GroupLayout(this); this.setLayout(layout); layout.setHorizontalGroup( layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(layout.createSequentialGroup() .addContainerGap() .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addComponent(jPanel1, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE) .addGroup(layout.createSequentialGroup() .addComponent(jPanel2, 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.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addComponent(jPanel2, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE) .addGap(13, 13, 13)) ); bindingGroup.bind(); } // Code for dispatching events from components to event handlers. private class FormListener implements java.awt.event.ActionListener { FormListener() {} public void actionPerformed(java.awt.event.ActionEvent evt) { if (evt.getSource() == newButton) { ClienteView.this.newButtonActionPerformed(evt); } else if (evt.getSource() == deleteButton) { ClienteView.this.deleteButtonActionPerformed(evt); } else if (evt.getSource() == jButton1) { ClienteView.this.jButton1ActionPerformed(evt); } else if (evt.getSource() == saveButton) { ClienteView.this.saveButtonActionPerformed(evt); } else if (evt.getSource() == refreshButton) { ClienteView.this.refreshButtonActionPerformed(evt); } else if (evt.getSource() == deleteDetailButton) { ClienteView.this.deleteDetailButtonActionPerformed(evt); } else if (evt.getSource() == newDetailButton) { ClienteView.this.newDetailButtonActionPerformed(evt); } } }// </editor-fold> private void deleteDetailButtonActionPerformed(java.awt.event.ActionEvent evt) { int index = masterTable.getSelectedRow(); br.com.siscom.bean.Cliente C = list.get(masterTable.convertRowIndexToModel(index)); Collection<br.com.siscom.bean.ClienteEndereco> cs = C.getClienteEnderecoCollection(); int[] selected = detailTable.getSelectedRows(); List<br.com.siscom.bean.ClienteEndereco> toRemove = new ArrayList<br.com.siscom.bean.ClienteEndereco>(selected.length); for (int idx =0; idx < selected.length; idx++) { selected[idx] = detailTable.convertRowIndexToModel(selected[idx]); int count = 0; Iterator<br.com.siscom.bean.ClienteEndereco> iter = cs.iterator(); while (count++ < selected[idx]) { iter.next(); } br.com.siscom.bean.ClienteEndereco c = iter.next(); toRemove.add(c); entityManager.remove(c); } cs.removeAll(toRemove); masterTable.clearSelection(); masterTable.setRowSelectionInterval(index, index); } private void newDetailButtonActionPerformed(java.awt.event.ActionEvent evt) { int index = masterTable.getSelectedRow(); br.com.siscom.bean.Cliente C = list.get(masterTable.convertRowIndexToModel(index)); Collection<br.com.siscom.bean.ClienteEndereco> cs = C.getClienteEnderecoCollection(); if (cs == null) { cs = new LinkedList<br.com.siscom.bean.ClienteEndereco>(); C.setClienteEnderecoCollection(cs); } br.com.siscom.bean.ClienteEndereco c = new br.com.siscom.bean.ClienteEndereco(); entityManager.persist(c); c.setCodCliente(C); cs.add(c); masterTable.clearSelection(); masterTable.setRowSelectionInterval(index, index); int row = cs.size() -1; detailTable.setRowSelectionInterval(row, row); detailTable.scrollRectToVisible(detailTable.getCellRect(row, 0, true)); } @SuppressWarnings("unchecked") private void refreshButtonActionPerformed(java.awt.event.ActionEvent evt) { entityManager.getTransaction().rollback(); entityManager.getTransaction().begin(); java.util.Collection data = query.getResultList(); for (Object entity : data) { entityManager.refresh(entity); } list.clear(); list.addAll(data); } private void deleteButtonActionPerformed(java.awt.event.ActionEvent evt) { int[] selected = masterTable.getSelectedRows(); List<br.com.siscom.bean.Cliente> toRemove = new ArrayList<br.com.siscom.bean.Cliente>(selected.length); for (int idx = 0; idx < selected.length; idx++) { br.com.siscom.bean.Cliente C = list.get(masterTable.convertRowIndexToModel(selected[idx])); toRemove.add(C); entityManager.remove(C); } list.removeAll(toRemove); } private void newButtonActionPerformed(java.awt.event.ActionEvent evt) { br.com.siscom.bean.Cliente C = new br.com.siscom.bean.Cliente(); entityManager.persist(C); list.add(C); int row = list.size() -1; masterTable.setRowSelectionInterval(row, row); masterTable.scrollRectToVisible(masterTable.getCellRect(row, 0, true)); //JFrame frame = new JFrame(); ClienteEditView ce = new ClienteEditView(null, true); ce.setRegistroAtual(C); ce.setVisible(true); if (ce.isConfirmaCliente()) { saveButton.doClick(); } else { refreshButton.doClick(); } } private void saveButtonActionPerformed(java.awt.event.ActionEvent evt) { try { entityManager.getTransaction().commit(); entityManager.getTransaction().begin(); } catch (RollbackException rex) { rex.printStackTrace(); entityManager.getTransaction().begin(); List<br.com.siscom.bean.Cliente> merged = new ArrayList<br.com.siscom.bean.Cliente>(list.size()); for (br.com.siscom.bean.Cliente C : list) { merged.add(entityManager.merge(C)); } list.clear(); list.addAll(merged); } } private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) { //JFrame frame = new JFrame(); ClienteEditView ce = new ClienteEditView(null, true); ce.setRegistroAtual(list.get(masterTable.getSelectedRow())); ce.setVisible(true); if (ce.isConfirmaCliente()) { saveButton.doClick(); } else { refreshButton.doClick(); } } // Variables declaration - do not modify private javax.swing.JButton deleteButton; private javax.swing.JButton deleteDetailButton; private javax.swing.JScrollPane detailScrollPane; private javax.swing.JScrollPane detailScrollPane1; private javax.swing.JTable detailTable; private javax.swing.JTable detailTable1; private javax.persistence.EntityManager entityManager; private javax.swing.JButton jButton1; private javax.swing.JPanel jPanel1; private javax.swing.JPanel jPanel2; private java.util.List<br.com.siscom.bean.Cliente> list; private javax.swing.JScrollPane masterScrollPane; private javax.swing.JScrollPane masterScrollPane1; private javax.swing.JTable masterTable; private javax.swing.JTable masterTable1; private javax.swing.JButton newButton; private javax.swing.JButton newDetailButton; private javax.persistence.Query query; private javax.swing.JButton refreshButton; private javax.swing.JButton saveButton; private org.jdesktop.beansbinding.BindingGroup bindingGroup; // End of variables declaration public static void main(final String[] args) { EventQueue.invokeLater(new Runnable() { public void run() { JFrame frame = new JFrame(); frame.setContentPane(new ClienteView()); //frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); frame.pack(); frame.setVisible(true); frame.setTitle(args[0]); } }); } }
  14. use SISCOMNIC; drop table if exists UNIDADE; /*==============================================================*/ /* Table: UNIDADE */ /*==============================================================*/ create table UNIDADE ( CODIGO_UNIDADE integer not null auto_increment, DESCRICAO_UNIDADE char(5), primary key (CODIGO_UNIDADE) ) type = MYISAM type = InnoDB type = InnoDB type = InnoDB; alter table UNIDADE comment 'Aramazena as unidades dos produtos.'; Apresenta este erro: (0 row(s)affected) (0 ms taken) (0 row(s)affected,1 warning(s)) (0 ms taken) Error Code : 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'type = MYISAM type = InnoDB type = InnoDB type = InnoDB' at line 10 (0 ms taken) Error Code : 1146 Table 'siscomnic.unidade' doesn't exist (0 ms taken)
×
×
  • Criar Novo...