Advertisement
Guest User

Untitled

a guest
Sep 15th, 2016
61
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.15 KB | None | 0 0
  1. // FUNÇÃO - ENTRAR
  2. public void call_Entrar(View view) {
  3.  
  4. // Validar Internet
  5. // ...
  6.  
  7. // Informar Conexão
  8. // ...
  9.  
  10. // Variáveis
  11. String host = "localhost";
  12. String port = "5432";
  13. String db = "database";
  14. String user = "postgres";
  15. String pass = "postgres";
  16.  
  17. // ConexaoMD
  18. new ConexaoMD(host, port, db, user, pass);
  19.  
  20. // ConexaoDAO
  21. boolean conexao = new ConexaoDAO().conectarPostgreSQL(host, port, db, user, pass);
  22.  
  23. AlertDialog alertDialog1 = new AlertDialog.Builder(AcessarActivity.this).create();
  24. alertDialog1.setTitle("Aviso!");
  25. alertDialog1.setMessage("Banco de Dados: " + conexao);
  26. alertDialog1.setButton(AlertDialog.BUTTON_NEUTRAL, "OK", new DialogInterface.OnClickListener() {
  27. public void onClick(DialogInterface dialog, int which) {
  28. dialog.dismiss();
  29. }
  30. });
  31. alertDialog1.show();
  32.  
  33. }
  34.  
  35. package model;
  36.  
  37. // Variáveis
  38.  
  39. private String host;
  40. private String port;
  41. private String db;
  42. private String user;
  43. private String pass;
  44.  
  45. // Construtor
  46. public ConexaoMD(String host, String port, String db, String user, String pass) {
  47. this.host = host;
  48. this.port = port;
  49. this.db = db;
  50. this.user = user;
  51. this.pass = pass;
  52. }
  53.  
  54. // Getters & Setters
  55.  
  56. public String getHost() {
  57. return host;
  58. }
  59. public void setHost(String host) {
  60. this.host = host;
  61. }
  62. public String getPort() {
  63. return port;
  64. }
  65. public void setPort(String port) {
  66. this.port = port;
  67. }
  68. public String getDb() {
  69. return db;
  70. }
  71. public void setDb(String db) {
  72. this.db = db;
  73. }
  74. public String getUser() {
  75. return user;
  76. }
  77. public void setUser(String user) {
  78. this.user = user;
  79. }
  80. public String getPass() {
  81. return pass;
  82. }
  83. public void setPass(String pass) {
  84. this.pass = pass;
  85. }
  86.  
  87. package dao;
  88.  
  89. // Variáveis
  90. private Connection conn = null;
  91. private Statement st;
  92. private ResultSet rs;
  93. private String sql;
  94.  
  95. // Construtor
  96. public boolean conectarPostgreSQL(String host, String port, String db, String user, String pass){
  97.  
  98. try{
  99. Class.forName("com.postgresql.Driver").newInstance();
  100. conn=DriverManager.getConnection(
  101. "jdbc:postgresql://"+host+":"+port+"/"+db+"?connectTimeout=9000&socketTimeout=9000&autoReconnect=true&secondsBeforeRetryMaster=3",user,pass);
  102. return true;
  103. } catch(Exception erro){
  104. Log.e("PostgreSQL","Erro: "+erro);
  105. return false;
  106. }
  107.  
  108. }
  109.  
  110. public void desconectarPostgreSQL(){
  111. try{
  112. conn.close();
  113. Log.i("PostgreSQL","Desconectado.");
  114. } catch(Exception erro){
  115. Log.e("PostgreSQL","Erro: "+erro);
  116. }
  117. }
  118.  
  119. public ResultSet queryPostgreSQL(String qry){
  120. try{
  121. st = conn.createStatement();
  122. sql = qry;
  123. rs = st.executeQuery(sql);
  124. rs.first();
  125. return rs;
  126. } catch(Exception erro){
  127. Log.e("PostgreSQL","Erro: "+erro);
  128. return null;
  129. }
  130. }
  131.  
  132. public void comandoPostgreSQL(String comando){
  133. try{
  134. st = conn.createStatement();
  135. st.execute(comando);
  136. } catch(Exception erro){
  137. Log.e("PostgreSQL","Erro: "+erro);
  138. }
  139. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement