Guest User

Untitled

a guest
May 29th, 2018
86
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.39 KB | None | 0 0
  1. package dao;
  2.  
  3. import classes.Login;
  4. import java.sql.Connection;
  5. import java.sql.DriverManager;
  6. import java.sql.ResultSet;
  7. import java.sql.SQLException;
  8. import java.sql.Statement;
  9. import javax.swing.JOptionPane;
  10.  
  11. public class Acesso {
  12.  
  13. public boolean acesso;
  14.  
  15. public void Acesso(String login, String senha) {
  16.  
  17. Login lg = new Login();
  18.  
  19. try {
  20.  
  21. Connection con = Conecta.getconexao();
  22. Statement stmt = con.createStatement();
  23. String query = "select login, senha from tbl_login where login='" + login + "'and senha='" + senha + "'";
  24.  
  25. ResultSet rs = stmt.executeQuery(query);
  26.  
  27. if (rs.next()) {
  28. lg.setUsuario(rs.getString("login"));
  29. lg.setSenha(rs.getString("senha"));
  30. JOptionPane.showMessageDialog(null, "Usuário Logado com Sucesso!!!");
  31. acesso = true;
  32. } else {
  33. System.out.println(rs.next());
  34. System.out.println(query);
  35. JOptionPane.showMessageDialog(null, "Usuário Inválido!!!");
  36. acesso = false;
  37.  
  38. }
  39. } catch (Exception e) {
  40. JOptionPane.showMessageDialog(null, "ENTROU NO CATCH DO ACESSO()");
  41. }
  42. }
  43. }
  44.  
  45. package dao;
  46. import java.sql.Connection;
  47. import java.sql.DriverManager;
  48. import java.sql.SQLException;
  49.  
  50. public class Conecta{
  51. public static Connection getconexao(){
  52. Connection con = null;
  53.  
  54. try{
  55. String serverName = "localhost";
  56. String mydatabase = "db";
  57. String username = "system";
  58. String password = "123456";
  59. String driverName = "oracle.jdbc.driver.OracleDriver";
  60. Class.forName(driverName);
  61.  
  62. String url = "jdbc:oracle:thin:@localhost:1521:XE";
  63. con = DriverManager.getConnection(url, username, password);
  64.  
  65. }
  66. catch (ClassNotFoundException e){
  67. System.out.println("Driver não encontrado " + e.toString());
  68. }
  69. catch(SQLException e){
  70. System.out.println("Erro ao conectar o Banco de Dados " + e.toString());
  71. }
  72.  
  73. return con;
  74. }
  75.  
  76. }
  77.  
  78. private void btnAcessarActionPerformed(java.awt.event.ActionEvent evt) {
  79.  
  80. Acesso cl = new Acesso();
  81. cl.Acesso(txtLogin.getText(), txtSenha.getText());
  82.  
  83. if (cl.acesso = true) {
  84. TelaInicial tl = new TelaInicial();
  85. tl.setExtendedState(new TelaInicial().MAXIMIZED_BOTH);
  86. tl.setVisible(true);
  87.  
  88. } else {
  89. txtLogin.setText("");
  90. txtSenha.setText("");
  91. txtLogin.requestFocus();
  92. }
  93. }
Add Comment
Please, Sign In to add comment