snipt

Ctrl+h for KB shortcuts

Java

testar conexão java mysql

/*fonte: http://www.vivaolinux.com.br/artigo/Escrevendo-aplicacoes-com-MySQL-e-Java/?pagina=4 */

import java.sql.*;
public class BancoTeste {

    public static void main(String args[]) {
        System.out.println("Testando acesso a banco de dado MySQL\n\n");
        Connection conn = null;
        String teste = "SELECT codigo,nome,sobrenome FROM testeJava;";

        try {
            Class.forName("com.mysql.jdbc.Driver");
            conn = DriverManager.getConnection("jdbc:mysql://localhost/test?" +"user=root&password=aluno");
            System.out.println("A conexão foi um sucesso\n");
            Statement stm = conn.createStatement();
            ResultSet rs = stm.executeQuery(teste);
            while (rs.next()) {
                String nome = rs.getString("nome");
                String codigo = rs.getString("codigo");
                String sobrenome = rs.getString("sobrenome");
                System.out.println("Codigo: " + codigo + "\nNome: " +nome+ "  Sobrenome: " + sobrenome);
                System.out.println("---------------------------------------");
            }
            System.out.println("\n\nConsulta realizada com sucesso!!!\n");
        } catch(ClassNotFoundException e) {
            System.out.println("excessão Classe não encontrada");
            e.printStackTrace();
        } catch(SQLException e) {
            System.out.println("SQL Exception... Erro na consulta:");
            e.printStackTrace();
        } finally {
            try {
                conn.close();
                System.out.println("\n\nFechando a conexão");
            } catch(SQLException erro) {
                System.out.println("Erro no fechamento");
                erro.printStackTrace();
            }
        }
    }
}
https://snipt.net/embed/86d3c3f49e2687b470f9388361dcd8dc/
/raw/86d3c3f49e2687b470f9388361dcd8dc/
86d3c3f49e2687b470f9388361dcd8dc
java
Java
41
2019-06-18T04:35:42
True
False
False
/api/public/snipt/13497/
testar-conexao-java-mysql
<table class="highlighttable"><tr><td class="linenos"><div class="linenodiv"><pre><a href="#L-1"> 1</a> <a href="#L-2"> 2</a> <a href="#L-3"> 3</a> <a href="#L-4"> 4</a> <a href="#L-5"> 5</a> <a href="#L-6"> 6</a> <a href="#L-7"> 7</a> <a href="#L-8"> 8</a> <a href="#L-9"> 9</a> <a href="#L-10">10</a> <a href="#L-11">11</a> <a href="#L-12">12</a> <a href="#L-13">13</a> <a href="#L-14">14</a> <a href="#L-15">15</a> <a href="#L-16">16</a> <a href="#L-17">17</a> <a href="#L-18">18</a> <a href="#L-19">19</a> <a href="#L-20">20</a> <a href="#L-21">21</a> <a href="#L-22">22</a> <a href="#L-23">23</a> <a href="#L-24">24</a> <a href="#L-25">25</a> <a href="#L-26">26</a> <a href="#L-27">27</a> <a href="#L-28">28</a> <a href="#L-29">29</a> <a href="#L-30">30</a> <a href="#L-31">31</a> <a href="#L-32">32</a> <a href="#L-33">33</a> <a href="#L-34">34</a> <a href="#L-35">35</a> <a href="#L-36">36</a> <a href="#L-37">37</a> <a href="#L-38">38</a> <a href="#L-39">39</a> <a href="#L-40">40</a> <a href="#L-41">41</a></pre></div></td><td class="code"><div class="highlight"><pre><span></span><span id="L-1"><a name="L-1"></a><span class="cm">/*fonte: http://www.vivaolinux.com.br/artigo/Escrevendo-aplicacoes-com-MySQL-e-Java/?pagina=4 */</span> </span><span id="L-2"><a name="L-2"></a> </span><span id="L-3"><a name="L-3"></a><span class="kn">import</span> <span class="nn">java.sql.*</span><span class="o">;</span> </span><span id="L-4"><a name="L-4"></a><span class="kd">public</span> <span class="kd">class</span> <span class="nc">BancoTeste</span> <span class="o">{</span> </span><span id="L-5"><a name="L-5"></a> </span><span id="L-6"><a name="L-6"></a> <span class="kd">public</span> <span class="kd">static</span> <span class="kt">void</span> <span class="nf">main</span><span class="o">(</span><span class="n">String</span> <span class="n">args</span><span class="o">[])</span> <span class="o">{</span> </span><span id="L-7"><a name="L-7"></a> <span class="n">System</span><span class="o">.</span><span class="na">out</span><span class="o">.</span><span class="na">println</span><span class="o">(</span><span class="s">&quot;Testando acesso a banco de dado MySQL\n\n&quot;</span><span class="o">);</span> </span><span id="L-8"><a name="L-8"></a> <span class="n">Connection</span> <span class="n">conn</span> <span class="o">=</span> <span class="kc">null</span><span class="o">;</span> </span><span id="L-9"><a name="L-9"></a> <span class="n">String</span> <span class="n">teste</span> <span class="o">=</span> <span class="s">&quot;SELECT codigo,nome,sobrenome FROM testeJava;&quot;</span><span class="o">;</span> </span><span id="L-10"><a name="L-10"></a> </span><span id="L-11"><a name="L-11"></a> <span class="k">try</span> <span class="o">{</span> </span><span id="L-12"><a name="L-12"></a> <span class="n">Class</span><span class="o">.</span><span class="na">forName</span><span class="o">(</span><span class="s">&quot;com.mysql.jdbc.Driver&quot;</span><span class="o">);</span> </span><span id="L-13"><a name="L-13"></a> <span class="n">conn</span> <span class="o">=</span> <span class="n">DriverManager</span><span class="o">.</span><span class="na">getConnection</span><span class="o">(</span><span class="s">&quot;jdbc:mysql://localhost/test?&quot;</span> <span class="o">+</span><span class="s">&quot;user=root&amp;password=aluno&quot;</span><span class="o">);</span> </span><span id="L-14"><a name="L-14"></a> <span class="n">System</span><span class="o">.</span><span class="na">out</span><span class="o">.</span><span class="na">println</span><span class="o">(</span><span class="s">&quot;A conexão foi um sucesso\n&quot;</span><span class="o">);</span> </span><span id="L-15"><a name="L-15"></a> <span class="n">Statement</span> <span class="n">stm</span> <span class="o">=</span> <span class="n">conn</span><span class="o">.</span><span class="na">createStatement</span><span class="o">();</span> </span><span id="L-16"><a name="L-16"></a> <span class="n">ResultSet</span> <span class="n">rs</span> <span class="o">=</span> <span class="n">stm</span><span class="o">.</span><span class="na">executeQuery</span><span class="o">(</span><span class="n">teste</span><span class="o">);</span> </span><span id="L-17"><a name="L-17"></a> <span class="k">while</span> <span class="o">(</span><span class="n">rs</span><span class="o">.</span><span class="na">next</span><span class="o">())</span> <span class="o">{</span> </span><span id="L-18"><a name="L-18"></a> <span class="n">String</span> <span class="n">nome</span> <span class="o">=</span> <span class="n">rs</span><span class="o">.</span><span class="na">getString</span><span class="o">(</span><span class="s">&quot;nome&quot;</span><span class="o">);</span> </span><span id="L-19"><a name="L-19"></a> <span class="n">String</span> <span class="n">codigo</span> <span class="o">=</span> <span class="n">rs</span><span class="o">.</span><span class="na">getString</span><span class="o">(</span><span class="s">&quot;codigo&quot;</span><span class="o">);</span> </span><span id="L-20"><a name="L-20"></a> <span class="n">String</span> <span class="n">sobrenome</span> <span class="o">=</span> <span class="n">rs</span><span class="o">.</span><span class="na">getString</span><span class="o">(</span><span class="s">&quot;sobrenome&quot;</span><span class="o">);</span> </span><span id="L-21"><a name="L-21"></a> <span class="n">System</span><span class="o">.</span><span class="na">out</span><span class="o">.</span><span class="na">println</span><span class="o">(</span><span class="s">&quot;Codigo: &quot;</span> <span class="o">+</span> <span class="n">codigo</span> <span class="o">+</span> <span class="s">&quot;\nNome: &quot;</span> <span class="o">+</span><span class="n">nome</span><span class="o">+</span> <span class="s">&quot; Sobrenome: &quot;</span> <span class="o">+</span> <span class="n">sobrenome</span><span class="o">);</span> </span><span id="L-22"><a name="L-22"></a> <span class="n">System</span><span class="o">.</span><span class="na">out</span><span class="o">.</span><span class="na">println</span><span class="o">(</span><span class="s">&quot;---------------------------------------&quot;</span><span class="o">);</span> </span><span id="L-23"><a name="L-23"></a> <span class="o">}</span> </span><span id="L-24"><a name="L-24"></a> <span class="n">System</span><span class="o">.</span><span class="na">out</span><span class="o">.</span><span class="na">println</span><span class="o">(</span><span class="s">&quot;\n\nConsulta realizada com sucesso!!!\n&quot;</span><span class="o">);</span> </span><span id="L-25"><a name="L-25"></a> <span class="o">}</span> <span class="k">catch</span><span class="o">(</span><span class="n">ClassNotFoundException</span> <span class="n">e</span><span class="o">)</span> <span class="o">{</span> </span><span id="L-26"><a name="L-26"></a> <span class="n">System</span><span class="o">.</span><span class="na">out</span><span class="o">.</span><span class="na">println</span><span class="o">(</span><span class="s">&quot;excessão Classe não encontrada&quot;</span><span class="o">);</span> </span><span id="L-27"><a name="L-27"></a> <span class="n">e</span><span class="o">.</span><span class="na">printStackTrace</span><span class="o">();</span> </span><span id="L-28"><a name="L-28"></a> <span class="o">}</span> <span class="k">catch</span><span class="o">(</span><span class="n">SQLException</span> <span class="n">e</span><span class="o">)</span> <span class="o">{</span> </span><span id="L-29"><a name="L-29"></a> <span class="n">System</span><span class="o">.</span><span class="na">out</span><span class="o">.</span><span class="na">println</span><span class="o">(</span><span class="s">&quot;SQL Exception... Erro na consulta:&quot;</span><span class="o">);</span> </span><span id="L-30"><a name="L-30"></a> <span class="n">e</span><span class="o">.</span><span class="na">printStackTrace</span><span class="o">();</span> </span><span id="L-31"><a name="L-31"></a> <span class="o">}</span> <span class="k">finally</span> <span class="o">{</span> </span><span id="L-32"><a name="L-32"></a> <span class="k">try</span> <span class="o">{</span> </span><span id="L-33"><a name="L-33"></a> <span class="n">conn</span><span class="o">.</span><span class="na">close</span><span class="o">();</span> </span><span id="L-34"><a name="L-34"></a> <span class="n">System</span><span class="o">.</span><span class="na">out</span><span class="o">.</span><span class="na">println</span><span class="o">(</span><span class="s">&quot;\n\nFechando a conexão&quot;</span><span class="o">);</span> </span><span id="L-35"><a name="L-35"></a> <span class="o">}</span> <span class="k">catch</span><span class="o">(</span><span class="n">SQLException</span> <span class="n">erro</span><span class="o">)</span> <span class="o">{</span> </span><span id="L-36"><a name="L-36"></a> <span class="n">System</span><span class="o">.</span><span class="na">out</span><span class="o">.</span><span class="na">println</span><span class="o">(</span><span class="s">&quot;Erro no fechamento&quot;</span><span class="o">);</span> </span><span id="L-37"><a name="L-37"></a> <span class="n">erro</span><span class="o">.</span><span class="na">printStackTrace</span><span class="o">();</span> </span><span id="L-38"><a name="L-38"></a> <span class="o">}</span> </span><span id="L-39"><a name="L-39"></a> <span class="o">}</span> </span><span id="L-40"><a name="L-40"></a> <span class="o">}</span> </span><span id="L-41"><a name="L-41"></a><span class="o">}</span> </span></pre></div> </td></tr></table>
conexão, java, mysql, netbeans