Fórum java.lang.NullPointerException ESTOU DESESPERADO ALGUÉM ME AJUDA POR FAVOR #537113
13/11/2015
0
Olá amigos! sou iniciante e estou desenvolvendo um programa para a minha apresentação final que sera no dia 17 de 11 de 2015 mas não consigo ligar o meu apps com o banco de dado MySQL. tudo funciona perfeitamente mas quando coloco o usuário e a senha, mostra uma caixa "banco conectado" e quando clico em "OK" mostra essa mensagem " java.lang.NullPointerException "
Grato
Grato
Sammy Magbo
Curtir tópico
+ 0
Responder
Posts
13/11/2015
Usuario
Olá Sammy Magbo,
Você está usando qual IDE para o desenvolvimento? (Eclipse? Netbeans?)
Seria bom fazer um debug no código para verificar em qual linha ocorre o erro!
Coloque aqui o trecho do seu código para analisarmos....
Você está usando qual IDE para o desenvolvimento? (Eclipse? Netbeans?)
Seria bom fazer um debug no código para verificar em qual linha ocorre o erro!
Coloque aqui o trecho do seu código para analisarmos....
Responder
Gostei + 0
13/11/2015
Sammy Magbo
Olá amigo,
estou usando o NetBeans veja o codigo abaixo.
e
estou usando o NetBeans veja o codigo abaixo.
package infox.dal;
import java.sql.*;
import javax.swing.JOptionPane;
/**
*
* @author Admin SS
*/
public class ModuloConexao {
public static Connection conector() {
java.sql.Connection conexao = null;
String driver = "com.mysql.jdbc.Driver";
String url = "jdbc:mysql://localhost:3306/satisaude";
String user = "root";
String password = "1993";
try {
Class.forName(driver);
conexao = DriverManager.getConnection(url, user, password);
return conexao;
} catch (Exception e) {
return null;
}
}
}
e
package sammagbo1;
import java.awt.Color;
import javax.swing.JOptionPane;
import java.sql.*;
import java.util.logging.Level;
import java.util.logging.Logger;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.awt.Panel;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Statement;
import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JTextField;
/**
*
* @author Admin SS
*/
public class Senha extends javax.swing.JFrame {
Connection conexao = null;
PreparedStatement pst = null;
ResultSet rs = null;
public void logar() {
String sql = "select * from tbusuarios where login=? and senha =?";
try {
conexao = DriverManager.getConnection("jdbc:mysql://localhost:3306/satisaude", "root", "1993");
Class.forName("com.mysql.jdbc.Driver");
JOptionPane.showMessageDialog(null, "conectado com sucesso");
pst = conexao.prepareStatement(sql);
pst.setString(1, login.getText());
pst.setString(2, senha.getText());
rs = pst.executeQuery();
if (rs.next()) {
String perfil = rs.getString(6);
if (perfil.equals("admin")) {
Cliente Cliente = new Cliente();
Cliente.setVisible(true);
Cliente.mnu_cad_cli.setEnabled(true);
Cliente.mnu_cad_fnc.setEnabled(true);
Cliente.lblusuario.setText(rs.getString(2));
Cliente.lblusuario.setForeground(Color.red);
this.dispose();
} else {
Cliente Cliente = new Cliente();
Cliente.setVisible(true);
Cliente.lblusuario.setText(rs.getString(2));
this.dispose();
}
} else {
JOptionPane.showMessageDialog(null, "Usuário e/ou Senha invalido(s)");
}
} catch (Exception e) {
JOptionPane.showMessageDialog(null, e);
}
}
public Senha() {
initComponents();
conexao = ModuloConexao.conector();
System.out.println(conexao);
if (conexao != null) {
lblStatus.setText("DB Conectado");
} else {
lblStatus.setText("DB Não Conectado");
}
}
/**
* 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() {
jLabel1 = new javax.swing.JLabel();
jLabel2 = new javax.swing.JLabel();
jLabel3 = new javax.swing.JLabel();
jPanel1 = new javax.swing.JPanel();
txt_bnt = new javax.swing.JButton();
jButton2 = new javax.swing.JButton();
lblStatus = new javax.swing.JLabel();
jPanel2 = new javax.swing.JPanel();
usuario = new javax.swing.JLabel();
senha1 = new javax.swing.JLabel();
login = new javax.swing.JTextField();
senha = new javax.swing.JPasswordField();
setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
setTitle("Tela de Senha Padrão SATI system");
setResizable(false);
jLabel1.setIcon(new javax.swing.ImageIcon(getClass().getResource("/sammagbo1/CYMERA_20150922_141135.jpg"))); // NOI18N
jLabel2.setFont(new java.awt.Font("Tahoma", 1, 24)); // NOI18N
jLabel2.setForeground(new java.awt.Color(0, 102, 51));
jLabel2.setText("ACESSO AO USUARIO DO SATI - SAÚDE");
jLabel3.setFont(new java.awt.Font("Tahoma", 1, 24)); // NOI18N
jLabel3.setForeground(new java.awt.Color(0, 102, 51));
jLabel3.setText("Tela Login");
jPanel1.setBorder(javax.swing.BorderFactory.createLineBorder(new java.awt.Color(0, 0, 0)));
txt_bnt.setFont(new java.awt.Font("Tahoma", 1, 12)); // NOI18N
txt_bnt.setForeground(new java.awt.Color(0, 102, 51));
txt_bnt.setText("Confirmar");
txt_bnt.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
txt_bntActionPerformed(evt);
}
});
jButton2.setFont(new java.awt.Font("Tahoma", 1, 12)); // NOI18N
jButton2.setForeground(new java.awt.Color(0, 102, 51));
jButton2.setText("Cancelar");
jButton2.setPreferredSize(new java.awt.Dimension(93, 23));
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(jButton2, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(txt_bnt, javax.swing.GroupLayout.Alignment.TRAILING))
.addContainerGap())
);
jPanel1Layout.setVerticalGroup(
jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel1Layout.createSequentialGroup()
.addContainerGap(18, Short.MAX_VALUE)
.addComponent(txt_bnt, javax.swing.GroupLayout.PREFERRED_SIZE, 30, javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addComponent(jButton2, javax.swing.GroupLayout.PREFERRED_SIZE, 30, javax.swing.GroupLayout.PREFERRED_SIZE)
.addContainerGap())
);
lblStatus.setFont(new java.awt.Font("Tahoma", 1, 12)); // NOI18N
lblStatus.setForeground(new java.awt.Color(0, 102, 51));
lblStatus.setText("status");
jPanel2.setBorder(javax.swing.BorderFactory.createTitledBorder(null, "insira o seu usuário e a sua senha", javax.swing.border.TitledBorder.DEFAULT_JUSTIFICATION, javax.swing.border.TitledBorder.DEFAULT_POSITION, new java.awt.Font("Tahoma", 0, 11), new java.awt.Color(0, 102, 51))); // NOI18N
jPanel2.setForeground(new java.awt.Color(0, 102, 51));
usuario.setFont(new java.awt.Font("Tahoma", 1, 14)); // NOI18N
usuario.setForeground(new java.awt.Color(0, 102, 51));
usuario.setText("Usuario :");
senha1.setFont(new java.awt.Font("Tahoma", 1, 14)); // NOI18N
senha1.setForeground(new java.awt.Color(0, 102, 51));
senha1.setText("Senha :");
senha.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
senhaActionPerformed(evt);
}
});
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()
.addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(usuario)
.addComponent(senha1, javax.swing.GroupLayout.PREFERRED_SIZE, 61, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGap(18, 18, 18)
.addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(senha, javax.swing.GroupLayout.DEFAULT_SIZE, 144, Short.MAX_VALUE)
.addComponent(login))
.addContainerGap())
);
jPanel2Layout.setVerticalGroup(
jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel2Layout.createSequentialGroup()
.addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(usuario, javax.swing.GroupLayout.PREFERRED_SIZE, 27, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(login, javax.swing.GroupLayout.PREFERRED_SIZE, 27, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGap(18, 18, 18)
.addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(senha1, javax.swing.GroupLayout.PREFERRED_SIZE, 27, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(senha, javax.swing.GroupLayout.PREFERRED_SIZE, 27, 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()
.addGap(321, 321, 321)
.addComponent(jLabel2, javax.swing.GroupLayout.PREFERRED_SIZE, 517, javax.swing.GroupLayout.PREFERRED_SIZE)
.addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
.addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup()
.addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addComponent(jLabel1)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addGap(190, 190, 190)
.addComponent(jLabel3, javax.swing.GroupLayout.PREFERRED_SIZE, 132, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGroup(layout.createSequentialGroup()
.addGap(30, 30, 30)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(lblStatus)
.addGroup(layout.createSequentialGroup()
.addComponent(jPanel2, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(18, 18, 18)
.addComponent(jPanel1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)))))
.addGap(149, 149, 149))
);
layout.setVerticalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addContainerGap()
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addComponent(jLabel2, javax.swing.GroupLayout.PREFERRED_SIZE, 29, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(29, 29, 29)
.addComponent(jLabel3)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addGap(52, 52, 52)
.addComponent(jPanel2, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGroup(layout.createSequentialGroup()
.addGap(60, 60, 60)
.addComponent(jPanel1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)))
.addGap(18, 18, 18)
.addComponent(lblStatus))
.addComponent(jLabel1))
.addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
);
setSize(new java.awt.Dimension(864, 354));
setLocationRelativeTo(null);
}// </editor-fold>
private void senhaActionPerformed(java.awt.event.ActionEvent evt) {
}
private void txt_bntActionPerformed(java.awt.event.ActionEvent evt) {
logar();
}
/**
* @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(Senha.class
.getName()).log(java.util.logging.Level.SEVERE, null, ex);
} catch (InstantiationException ex) {
java.util.logging.Logger.getLogger(Senha.class
.getName()).log(java.util.logging.Level.SEVERE, null, ex);
} catch (IllegalAccessException ex) {
java.util.logging.Logger.getLogger(Senha.class
.getName()).log(java.util.logging.Level.SEVERE, null, ex);
} catch (javax.swing.UnsupportedLookAndFeelException ex) {
java.util.logging.Logger.getLogger(Senha.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 Senha().setVisible(true);
}
});
}
// Variables declaration - do not modify
private javax.swing.JButton jButton2;
private javax.swing.JLabel jLabel1;
private javax.swing.JLabel jLabel2;
private javax.swing.JLabel jLabel3;
private javax.swing.JPanel jPanel1;
private javax.swing.JPanel jPanel2;
private javax.swing.JLabel lblStatus;
private javax.swing.JTextField login;
private javax.swing.JPasswordField senha;
private javax.swing.JLabel senha1;
private javax.swing.JButton txt_bnt;
private javax.swing.JLabel usuario;
// End of variables declaration
}
Responder
Gostei + 0
13/11/2015
Usuario
Você sabe debugar (acho que no netbeans chama 'depurar') o código?
Se souber, adiciona um breakpoint na sua linha 32 da classe senha e coloque para depurar o código e veja em qual linha linha vai ocorrer o erro!
Se souber, adiciona um breakpoint na sua linha 32 da classe senha e coloque para depurar o código e veja em qual linha linha vai ocorrer o erro!
Responder
Gostei + 0
Clique aqui para fazer login e interagir na Comunidade :)