Advertisement
Guest User

not works

a guest
Dec 8th, 2016
94
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.80 KB | None | 0 0
  1. package ufrpe.bcc.carepet;
  2.  
  3. import java.awt.BorderLayout;
  4. import java.awt.EventQueue;
  5. import java.awt.event.ActionEvent;
  6. import java.sql.Connection;
  7. import java.sql.DriverManager;
  8. import java.sql.PreparedStatement;
  9. import java.sql.ResultSet;
  10. import java.sql.SQLException;
  11. import java.sql.Statement;
  12.  
  13. import javax.swing.JFrame;
  14. import javax.swing.JPanel;
  15. import javax.swing.border.EmptyBorder;
  16.  
  17. import javax.swing.GroupLayout;
  18. import javax.swing.GroupLayout.Alignment;
  19. import javax.swing.JLabel;
  20. import javax.swing.JOptionPane;
  21. import javax.swing.JTextField;
  22. import javax.swing.LayoutStyle.ComponentPlacement;
  23. import javax.swing.JButton;
  24.  
  25. public class TelaLogin extends JFrame {
  26.  
  27. private JPanel contentPane;
  28. private JTextField fieldLogin;
  29. private JTextField fieldSenha;
  30. private JButton btnEntrar;
  31.  
  32. /**
  33. * Launch the application.
  34. */
  35. /*public static void main(String[] args) {
  36. EventQueue.invokeLater(new Runnable() {
  37. public void run() {
  38. try {
  39. TelaLogin frame = new TelaLogin();
  40. frame.setVisible(true);
  41. } catch (Exception e) {
  42. e.printStackTrace();
  43. }
  44. }
  45. });
  46. }*/
  47.  
  48. /**
  49. * Create the frame.
  50. */
  51.  
  52. static {
  53.  
  54. try {
  55. Class.forName("com.mysql.jdbc.Driver");
  56. } catch (Exception e) {
  57. System.out.println("Problemas carregando o Driver do MySQL");
  58. }
  59. }
  60.  
  61. public static Connection getConexao() throws SQLException {
  62.  
  63. Connection retorno = null;
  64. /*
  65. * Formato:
  66. * - Parâmetro 1: URLConexão:@endereço:porta
  67. * - Parâmetro 2: usuário
  68. * - Parâmetro 3: senha
  69. */
  70. retorno = DriverManager.getConnection(
  71. "jdbc:mysql://localhost:3306/carepet", "root", "kbrito"); // nome do esquema, usuário e senha
  72. return retorno;
  73. }
  74.  
  75. public TelaLogin() {
  76. setTitle("CarePet");
  77. setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
  78. setBounds(100, 100, 450, 300);
  79. contentPane = new JPanel();
  80. contentPane.setBorder(new EmptyBorder(5, 5, 5, 5));
  81. setContentPane(contentPane);
  82.  
  83. JLabel lblLogin = new JLabel("Login(CPF):");
  84.  
  85. JLabel lblSenha = new JLabel("Senha:");
  86.  
  87. fieldLogin = new JTextField();
  88. fieldLogin.setColumns(10);
  89.  
  90. fieldSenha = new JTextField();
  91. fieldSenha.setColumns(10);
  92.  
  93. btnEntrar = new JButton("Entrar");
  94. GroupLayout gl_contentPane = new GroupLayout(contentPane);
  95. gl_contentPane.setHorizontalGroup(
  96. gl_contentPane.createParallelGroup(Alignment.LEADING)
  97. .addGroup(gl_contentPane.createSequentialGroup()
  98. .addGap(139)
  99. .addGroup(gl_contentPane.createParallelGroup(Alignment.LEADING)
  100. .addComponent(lblLogin)
  101. .addComponent(lblSenha))
  102. .addPreferredGap(ComponentPlacement.UNRELATED)
  103. .addGroup(gl_contentPane.createParallelGroup(Alignment.LEADING)
  104. .addGroup(gl_contentPane.createSequentialGroup()
  105. .addGap(10)
  106. .addComponent(btnEntrar))
  107. .addComponent(fieldSenha, GroupLayout.PREFERRED_SIZE, GroupLayout.DEFAULT_SIZE, GroupLayout.PREFERRED_SIZE)
  108. .addComponent(fieldLogin, GroupLayout.PREFERRED_SIZE, GroupLayout.DEFAULT_SIZE, GroupLayout.PREFERRED_SIZE))
  109. .addContainerGap(133, Short.MAX_VALUE))
  110. );
  111. gl_contentPane.setVerticalGroup(
  112. gl_contentPane.createParallelGroup(Alignment.LEADING)
  113. .addGroup(gl_contentPane.createSequentialGroup()
  114. .addGap(93)
  115. .addGroup(gl_contentPane.createParallelGroup(Alignment.BASELINE)
  116. .addComponent(lblLogin)
  117. .addComponent(fieldLogin, GroupLayout.PREFERRED_SIZE, GroupLayout.DEFAULT_SIZE, GroupLayout.PREFERRED_SIZE))
  118. .addGap(27)
  119. .addGroup(gl_contentPane.createParallelGroup(Alignment.BASELINE)
  120. .addComponent(lblSenha)
  121. .addComponent(fieldSenha, GroupLayout.PREFERRED_SIZE, GroupLayout.DEFAULT_SIZE, GroupLayout.PREFERRED_SIZE))
  122. .addPreferredGap(ComponentPlacement.UNRELATED)
  123. .addComponent(btnEntrar)
  124. .addContainerGap(57, Short.MAX_VALUE))
  125. );
  126. contentPane.setLayout(gl_contentPane);
  127.  
  128.  
  129.  
  130. }
  131. public void actionPerformed(ActionEvent evento){
  132. if(evento.getSource().equals(btnEntrar)){
  133. JOptionPane.showMessageDialog(null, "FUNCIONA N");
  134. try{
  135. String cpf = fieldLogin.getText();
  136. String senha = fieldLogin.getText();
  137. Connection conex = getConexao();
  138. String query = "SELECT * FROM CLIENTE WHERE CPF ='"+ cpf +"' LIMIT 1";
  139. PreparedStatement psCPF = conex.prepareStatement(query);
  140. ResultSet rsCPF = psCPF.executeQuery();
  141. if(!rsCPF.next()){
  142. query = "SELECT * FROM FUNCIONARIO WHERE CPF ='"+ cpf +"' LIMIT 1";
  143. psCPF = conex.prepareStatement(query);
  144. rsCPF = psCPF.executeQuery();
  145. }
  146. if(rsCPF.next()){
  147. JOptionPane.showMessageDialog(null, "Usuario nao encontrado");
  148. }
  149. else{
  150. System.out.println(rsCPF.getString("nome"));
  151. }
  152. } catch (SQLException e) {
  153. System.out.println("Houve erro");
  154. e.printStackTrace();
  155. }
  156. }
  157. }
  158.  
  159. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement