Ol\u00e1 amigos!
\nHoje iremos aprender como realizar uma conex\u00e3o com o Banco de Dados SQLServer.<\/p>\n
<\/p>\n
\r\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 ConexaoSQLServer {\r\n\r\n\tpublic static void main(String[] args) {\r\n\t\tSystem.out.println(\"Inicio ConexaoSQLServer\");\r\n\t\ttry {\r\n\t\t\tString usuario = \"sa\";\r\n\t\t\tString senha = \"teco01\";\r\n\t\t\tClass.forName(\"com.microsoft.sqlserver.jdbc.SQLServerDriver\");\r\n\t\t\tConnection conexao = DriverManager\r\n\t\t\t\t\t.getConnection(\r\n\t\t\t\t\t\t\t\"jdbc:sqlserver:\/\/localhost:1433;databaseName=bdacademicnet\",\r\n\t\t\t\t\t\t\tusuario, senha);\r\n\t\t\tPreparedStatement pstm = conexao\r\n\t\t\t\t\t.prepareStatement(\"Select name from sysobjects where type='u'\");\r\n\r\n\t\t\tResultSet rs = pstm.executeQuery();\r\n\r\n\t\t\twhile (rs.next()) {\r\n\t\t\t\tSystem.out.println(\"Nome tabela: \" + rs.getString(\"name\"));\r\n\t\t\t}\r\n\t\t\trs.close();\r\n\t\t\tpstm.close();\r\n\t\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 ConexaoSQLServer\");\r\n\t}\r\n}\r\n<\/pre>\nAbra\u00e7os e bons estudos! E vida que segue!
\n
Links relacionados <\/H2><\/p>\n
Driver JDBC SQLServer<\/a><\/p>\nExemplo completo com JSF Primefaces + Hibernate + MySQL<\/a><\/p>\nJDBC: Conectar com Banco de Dados SQLServer<\/a><\/p>\nJDBC: Conectar com Banco de Dados via ODBC<\/a><\/p>\nJDBC: Conectar com Banco de Dados PostgreSQL<\/a><\/p>\n JDBC: Conectar com Banco de Dados Microsoft Access<\/a>
\nJDBC: Aprenda a conectar com Banco de Dados MySQL<\/a><\/p>\nN\u00e3o se esque\u00e7a de curtir este post nas redes sociais. D\u00ea a sua contribui\u00e7\u00e3o social e ajude o autor:<\/H2><\/p>\n","protected":false},"excerpt":{"rendered":"
JDBC: Conectar com Banco de Dados SQLServer Ol\u00e1 amigos! Hoje iremos aprender como realizar uma conex\u00e3o com o Banco de Dados SQLServer.<\/p>\n","protected":false},"author":1,"featured_media":1835,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"ngg_post_thumbnail":0},"categories":[5,1],"tags":[],"yoast_head":"\n
JDBC: Conectar com Banco de Dados SQLServer<\/title>\n<meta name=\"description\" content=\"JDBC: Conectar com Banco de Dados SQLServer\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.feltex.com.br\/felix\/jdbc-conectar-banco-dados-sqlserver\/\" \/>\n<meta property=\"og:locale\" content=\"pt_BR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"JDBC: Conectar com Banco de Dados SQLServer\" \/>\n<meta property=\"og:description\" content=\"JDBC: Conectar com Banco de Dados SQLServer\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.feltex.com.br\/felix\/jdbc-conectar-banco-dados-sqlserver\/\" \/>\n<meta property=\"og:site_name\" content=\"Aprenda Java\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/feltex.br\" \/>\n<meta property=\"article:published_time\" content=\"2014-03-24T00:38:13+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2015-01-26T01:59:55+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.feltex.com.br\/felix\/wp-content\/uploads\/2014\/03\/MSSQL.png\" \/>\n\t<meta property=\"og:image:width\" content=\"512\" \/>\n\t<meta property=\"og:image:height\" content=\"512\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"Andr\u00e9 F\u00e9lix\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. tempo de leitura\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minuto\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.feltex.com.br\/felix\/#website\",\"url\":\"https:\/\/www.feltex.com.br\/felix\/\",\"name\":\"Aprenda Java\",\"description\":\"Cursos de java, SQL e Engenharia de Software\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.feltex.com.br\/felix\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"pt-BR\"},{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/www.feltex.com.br\/felix\/jdbc-conectar-banco-dados-sqlserver\/#primaryimage\",\"inLanguage\":\"pt-BR\",\"url\":\"https:\/\/www.feltex.com.br\/felix\/wp-content\/uploads\/2014\/03\/MSSQL.png\",\"contentUrl\":\"https:\/\/www.feltex.com.br\/felix\/wp-content\/uploads\/2014\/03\/MSSQL.png\",\"width\":512,\"height\":512},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.feltex.com.br\/felix\/jdbc-conectar-banco-dados-sqlserver\/#webpage\",\"url\":\"https:\/\/www.feltex.com.br\/felix\/jdbc-conectar-banco-dados-sqlserver\/\",\"name\":\"JDBC: Conectar com Banco de Dados SQLServer\",\"isPartOf\":{\"@id\":\"https:\/\/www.feltex.com.br\/felix\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.feltex.com.br\/felix\/jdbc-conectar-banco-dados-sqlserver\/#primaryimage\"},\"datePublished\":\"2014-03-24T00:38:13+00:00\",\"dateModified\":\"2015-01-26T01:59:55+00:00\",\"author\":{\"@id\":\"https:\/\/www.feltex.com.br\/felix\/#\/schema\/person\/1e49f842c6254b4561b66ccf573c2069\"},\"description\":\"JDBC: Conectar com Banco de Dados SQLServer\",\"breadcrumb\":{\"@id\":\"https:\/\/www.feltex.com.br\/felix\/jdbc-conectar-banco-dados-sqlserver\/#breadcrumb\"},\"inLanguage\":\"pt-BR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.feltex.com.br\/felix\/jdbc-conectar-banco-dados-sqlserver\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.feltex.com.br\/felix\/jdbc-conectar-banco-dados-sqlserver\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"JDBC: Conectar com Banco de Dados SQLServer\"}]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.feltex.com.br\/felix\/#\/schema\/person\/1e49f842c6254b4561b66ccf573c2069\",\"name\":\"Andr\\u00e9 F\\u00e9lix\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/www.feltex.com.br\/felix\/#personlogo\",\"inLanguage\":\"pt-BR\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/d2d9cc82cab40245e6f803982b1448e6?s=96&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/d2d9cc82cab40245e6f803982b1448e6?s=96&r=g\",\"caption\":\"Andr\\u00e9 F\\u00e9lix\"},\"sameAs\":[\"http:\/\/www.feltex.com.br\"],\"url\":\"https:\/\/www.feltex.com.br\/felix\/author\/andre.felix\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"JDBC: Conectar com Banco de Dados SQLServer","description":"JDBC: Conectar com Banco de Dados SQLServer","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.feltex.com.br\/felix\/jdbc-conectar-banco-dados-sqlserver\/","og_locale":"pt_BR","og_type":"article","og_title":"JDBC: Conectar com Banco de Dados SQLServer","og_description":"JDBC: Conectar com Banco de Dados SQLServer","og_url":"https:\/\/www.feltex.com.br\/felix\/jdbc-conectar-banco-dados-sqlserver\/","og_site_name":"Aprenda Java","article_publisher":"https:\/\/www.facebook.com\/feltex.br","article_published_time":"2014-03-24T00:38:13+00:00","article_modified_time":"2015-01-26T01:59:55+00:00","og_image":[{"width":512,"height":512,"url":"https:\/\/www.feltex.com.br\/felix\/wp-content\/uploads\/2014\/03\/MSSQL.png","type":"image\/png"}],"twitter_misc":{"Escrito por":"Andr\u00e9 F\u00e9lix","Est. tempo de leitura":"1 minuto"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebSite","@id":"https:\/\/www.feltex.com.br\/felix\/#website","url":"https:\/\/www.feltex.com.br\/felix\/","name":"Aprenda Java","description":"Cursos de java, SQL e Engenharia de Software","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.feltex.com.br\/felix\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"pt-BR"},{"@type":"ImageObject","@id":"https:\/\/www.feltex.com.br\/felix\/jdbc-conectar-banco-dados-sqlserver\/#primaryimage","inLanguage":"pt-BR","url":"https:\/\/www.feltex.com.br\/felix\/wp-content\/uploads\/2014\/03\/MSSQL.png","contentUrl":"https:\/\/www.feltex.com.br\/felix\/wp-content\/uploads\/2014\/03\/MSSQL.png","width":512,"height":512},{"@type":"WebPage","@id":"https:\/\/www.feltex.com.br\/felix\/jdbc-conectar-banco-dados-sqlserver\/#webpage","url":"https:\/\/www.feltex.com.br\/felix\/jdbc-conectar-banco-dados-sqlserver\/","name":"JDBC: Conectar com Banco de Dados SQLServer","isPartOf":{"@id":"https:\/\/www.feltex.com.br\/felix\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.feltex.com.br\/felix\/jdbc-conectar-banco-dados-sqlserver\/#primaryimage"},"datePublished":"2014-03-24T00:38:13+00:00","dateModified":"2015-01-26T01:59:55+00:00","author":{"@id":"https:\/\/www.feltex.com.br\/felix\/#\/schema\/person\/1e49f842c6254b4561b66ccf573c2069"},"description":"JDBC: Conectar com Banco de Dados SQLServer","breadcrumb":{"@id":"https:\/\/www.feltex.com.br\/felix\/jdbc-conectar-banco-dados-sqlserver\/#breadcrumb"},"inLanguage":"pt-BR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.feltex.com.br\/felix\/jdbc-conectar-banco-dados-sqlserver\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.feltex.com.br\/felix\/jdbc-conectar-banco-dados-sqlserver\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"JDBC: Conectar com Banco de Dados SQLServer"}]},{"@type":"Person","@id":"https:\/\/www.feltex.com.br\/felix\/#\/schema\/person\/1e49f842c6254b4561b66ccf573c2069","name":"Andr\u00e9 F\u00e9lix","image":{"@type":"ImageObject","@id":"https:\/\/www.feltex.com.br\/felix\/#personlogo","inLanguage":"pt-BR","url":"https:\/\/secure.gravatar.com\/avatar\/d2d9cc82cab40245e6f803982b1448e6?s=96&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/d2d9cc82cab40245e6f803982b1448e6?s=96&r=g","caption":"Andr\u00e9 F\u00e9lix"},"sameAs":["http:\/\/www.feltex.com.br"],"url":"https:\/\/www.feltex.com.br\/felix\/author\/andre.felix\/"}]}},"_links":{"self":[{"href":"https:\/\/www.feltex.com.br\/felix\/wp-json\/wp\/v2\/posts\/511"}],"collection":[{"href":"https:\/\/www.feltex.com.br\/felix\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.feltex.com.br\/felix\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.feltex.com.br\/felix\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.feltex.com.br\/felix\/wp-json\/wp\/v2\/comments?post=511"}],"version-history":[{"count":5,"href":"https:\/\/www.feltex.com.br\/felix\/wp-json\/wp\/v2\/posts\/511\/revisions"}],"predecessor-version":[{"id":1770,"href":"https:\/\/www.feltex.com.br\/felix\/wp-json\/wp\/v2\/posts\/511\/revisions\/1770"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.feltex.com.br\/felix\/wp-json\/wp\/v2\/media\/1835"}],"wp:attachment":[{"href":"https:\/\/www.feltex.com.br\/felix\/wp-json\/wp\/v2\/media?parent=511"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.feltex.com.br\/felix\/wp-json\/wp\/v2\/categories?post=511"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.feltex.com.br\/felix\/wp-json\/wp\/v2\/tags?post=511"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}