Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- package ufrpe.bcc.carepet;
- import java.awt.BorderLayout;
- import java.awt.EventQueue;
- import java.awt.event.ActionEvent;
- import java.sql.Connection;
- import java.sql.DriverManager;
- import java.sql.PreparedStatement;
- import java.sql.ResultSet;
- import java.sql.SQLException;
- import java.sql.Statement;
- import javax.swing.JFrame;
- import javax.swing.JPanel;
- import javax.swing.border.EmptyBorder;
- import javax.swing.GroupLayout;
- import javax.swing.GroupLayout.Alignment;
- import javax.swing.JLabel;
- import javax.swing.JOptionPane;
- import javax.swing.JTextField;
- import javax.swing.LayoutStyle.ComponentPlacement;
- import javax.swing.JButton;
- public class TelaLogin extends JFrame {
- private JPanel contentPane;
- private JTextField fieldLogin;
- private JTextField fieldSenha;
- private JButton btnEntrar;
- /**
- * Launch the application.
- */
- /*public static void main(String[] args) {
- EventQueue.invokeLater(new Runnable() {
- public void run() {
- try {
- TelaLogin frame = new TelaLogin();
- frame.setVisible(true);
- } catch (Exception e) {
- e.printStackTrace();
- }
- }
- });
- }*/
- /**
- * Create the frame.
- */
- static {
- try {
- Class.forName("com.mysql.jdbc.Driver");
- } catch (Exception e) {
- System.out.println("Problemas carregando o Driver do MySQL");
- }
- }
- public static Connection getConexao() throws SQLException {
- Connection retorno = null;
- /*
- * Formato:
- * - Parâmetro 1: URLConexão:@endereço:porta
- * - Parâmetro 2: usuário
- * - Parâmetro 3: senha
- */
- retorno = DriverManager.getConnection(
- "jdbc:mysql://localhost:3306/carepet", "root", "kbrito"); // nome do esquema, usuário e senha
- return retorno;
- }
- public TelaLogin() {
- setTitle("CarePet");
- setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
- setBounds(100, 100, 450, 300);
- contentPane = new JPanel();
- contentPane.setBorder(new EmptyBorder(5, 5, 5, 5));
- setContentPane(contentPane);
- JLabel lblLogin = new JLabel("Login(CPF):");
- JLabel lblSenha = new JLabel("Senha:");
- fieldLogin = new JTextField();
- fieldLogin.setColumns(10);
- fieldSenha = new JTextField();
- fieldSenha.setColumns(10);
- btnEntrar = new JButton("Entrar");
- GroupLayout gl_contentPane = new GroupLayout(contentPane);
- gl_contentPane.setHorizontalGroup(
- gl_contentPane.createParallelGroup(Alignment.LEADING)
- .addGroup(gl_contentPane.createSequentialGroup()
- .addGap(139)
- .addGroup(gl_contentPane.createParallelGroup(Alignment.LEADING)
- .addComponent(lblLogin)
- .addComponent(lblSenha))
- .addPreferredGap(ComponentPlacement.UNRELATED)
- .addGroup(gl_contentPane.createParallelGroup(Alignment.LEADING)
- .addGroup(gl_contentPane.createSequentialGroup()
- .addGap(10)
- .addComponent(btnEntrar))
- .addComponent(fieldSenha, GroupLayout.PREFERRED_SIZE, GroupLayout.DEFAULT_SIZE, GroupLayout.PREFERRED_SIZE)
- .addComponent(fieldLogin, GroupLayout.PREFERRED_SIZE, GroupLayout.DEFAULT_SIZE, GroupLayout.PREFERRED_SIZE))
- .addContainerGap(133, Short.MAX_VALUE))
- );
- gl_contentPane.setVerticalGroup(
- gl_contentPane.createParallelGroup(Alignment.LEADING)
- .addGroup(gl_contentPane.createSequentialGroup()
- .addGap(93)
- .addGroup(gl_contentPane.createParallelGroup(Alignment.BASELINE)
- .addComponent(lblLogin)
- .addComponent(fieldLogin, GroupLayout.PREFERRED_SIZE, GroupLayout.DEFAULT_SIZE, GroupLayout.PREFERRED_SIZE))
- .addGap(27)
- .addGroup(gl_contentPane.createParallelGroup(Alignment.BASELINE)
- .addComponent(lblSenha)
- .addComponent(fieldSenha, GroupLayout.PREFERRED_SIZE, GroupLayout.DEFAULT_SIZE, GroupLayout.PREFERRED_SIZE))
- .addPreferredGap(ComponentPlacement.UNRELATED)
- .addComponent(btnEntrar)
- .addContainerGap(57, Short.MAX_VALUE))
- );
- contentPane.setLayout(gl_contentPane);
- }
- public void actionPerformed(ActionEvent evento){
- if(evento.getSource().equals(btnEntrar)){
- JOptionPane.showMessageDialog(null, "FUNCIONA N");
- try{
- String cpf = fieldLogin.getText();
- String senha = fieldLogin.getText();
- Connection conex = getConexao();
- String query = "SELECT * FROM CLIENTE WHERE CPF ='"+ cpf +"' LIMIT 1";
- PreparedStatement psCPF = conex.prepareStatement(query);
- ResultSet rsCPF = psCPF.executeQuery();
- if(!rsCPF.next()){
- query = "SELECT * FROM FUNCIONARIO WHERE CPF ='"+ cpf +"' LIMIT 1";
- psCPF = conex.prepareStatement(query);
- rsCPF = psCPF.executeQuery();
- }
- if(rsCPF.next()){
- JOptionPane.showMessageDialog(null, "Usuario nao encontrado");
- }
- else{
- System.out.println(rsCPF.getString("nome"));
- }
- } catch (SQLException e) {
- System.out.println("Houve erro");
- e.printStackTrace();
- }
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement