JDBC: Conectar com Banco de Dados MySQL<\/H1><\/p>\n

Ol\u00e1 amigos! Hoje iremos aprender como realizar uma conex\u00e3o com o Banco de Dados MySQL.<\/p>\n

\n<\/p>\n

\r\npackage br.com.feltex.bancodados;\r\n\r\nimport java.sql.Connection;\r\nimport java.sql.DriverManager;\r\nimport java.sql.PreparedStatement;\r\nimport java.sql.ResultSet;\r\n\r\npublic class ConexaoMySQL {\r\n\r\n\/\/**\r\n\r\npublic static void main(String[] args) {\r\n\tSystem.out.println(\"Inicio ConexaoMySQL\");\r\n\ttry {\r\n\r\n                Class.forName(\"com.mysql.jdbc.Driver\");\r\n\t\tConnection conexao = DriverManager.getConnection(\r\n\t\t\t\t\"jdbc:mysql:\/\/localhost:3306\/bdacademicnet\", \"root\",\r\n\t\t\t\t\"teco01\");\r\n\t\tPreparedStatement pstm = conexao\r\n\t\t\t\t.prepareStatement(\"select * from information_schema.tables\");\r\n\r\n\t\tResultSet rs = pstm.executeQuery();\r\n\r\n\t\twhile (rs.next()) {\r\n\t\t  System.out.println(\"Nome tabela: \" + rs.getString(\"table_name\"));\r\n\t\t}\r\n\t\trs.close();\r\n\t\tpstm.close();\r\n\t\tconexao.close();\r\n\r\n\t\t} catch (Exception e) {\r\n\t\t\te.printStackTrace();\r\n\t\t}\r\n\t\tSystem.out.println(\"Fim ConexaoMySQL\");\r\n\t}\r\n}\r\n<\/pre>\n
Links relacionados <\/H2>
\nTutorial de JDBC<\/a><\/p>\n
Driver do MySQL<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
JDBC: Conectar com Banco de Dados MySQL Ol\u00e1 amigos! Hoje iremos aprender como realizar uma conex\u00e3o com o Banco de Dados MySQL.<\/p>\n","protected":false},"author":1,"featured_media":1736,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"ngg_post_thumbnail":0},"categories":[5,1,6],"tags":[33],"yoast_head":"\n