JDBC

API genérica de acesso a Banco de Dados

• http://java.sun.com/javase/technologies/database/
• http://docs.oracle.com/javase/tutorial/jdbc/index.htmlhttp://docs.oracle.com/…./index.html
• http://java.sun.com/javase/6/docs/technotes/guides/jdbc/http://java.sun.com/…./jdbc
• javax.sql.DataSource / Connection Pool
• Connection
  • Transações
    • http://docs.oracle.com/javase/tutorial/jdbc/basics/transactions.htmlhttp://docs.oracle.com/…./transactions.html
• PreparedStatement
  • Recomendado SEMPRE em vez do Statement, oferece vantagens em performance, segurança e legibilidade do código pois não precisa gerar SQL dinamico concatenando com variaveis
  • SQL Injection
  • http://docs.oracle.com/javase/tutorial/jdbc/basics/prepared.htmlhttp://docs.oracle.com/…./prepared.html
  • http://javarevisited.blogspot.com/2012/03/why-use-preparedstatement-in-java-jdbc.htmlhttp://javarevisited.blogspot.com/….
  • http://developer.teradata.com/connectivity/articles/speed-up-your-jdbcodbc-applicationshttp://developer.teradata.com/….
• Statement.RETURN_GENERATED_KEYS
• ResultSet
• RowSet
  • http://java.sun.com/developer/Books/JDBCTutorial/chapter5.htmlhttp://java.sun.com/…./chapter5.html
• DAO x ORM
  • http://www.codefutures.com/weblog/andygrove/archives/2005/02/data_access_obj.htmlhttp://www.codefutures.com/…./data_access_obj.html
• DAO
  • http://www.javacodegeeks.com/2013/01/spring-data-jdbc-generic-dao-implementation-most-lightweight-orm-ever.htmlhttp://www.javacodegeeks.com/….
• ORM
  • JDO
    • http://java.sun.com/jdo/
    • http://db.apache.org/jdo/
  • JPA
  • http://cayenne.apache.org/
• Servidores de Banco de dados escritos em Java
  • hsqldb
  • Apache Derby
    • Java DB
  • http://www.h2database.com
• Google Cloud SQL
  • https://developers.google.com/cloud-sql/docs/externalhttps://developers.google.com/…./external
• Commons DbUtils
• Diversos
  • http://pdf.coreservlets.com/Accessing-Databases-JDBC.pdfhttp://pdf.coreservlets.com/….
  • http://courses.coreservlets.com/Course-Materials/msajsp.html#JDBChttp://courses.coreservlets.com/…./msajsp.html#JDBC
  • http://courses.coreservlets.com/Course-Materials/pdf/msajsp/10-JDBC.pdfhttp://courses.coreservlets.com/…./10-JDBC.pdf
  • http://www.ibm.com/developerworks/java/library/j-5things10.htmlhttp://www.ibm.com/…./j-5things10.html
  • http://www.caelum.com.br/curso/fj-21-java-web/
    • Apostila possui um tópico sobre JDBC
  • http://www.globalcode.com.br/gratuitos/minicursos/minicurso-java-e-banco-de-dados-jdbc-hibernate-jpa-e-ejb-3http://www.globalcode.com.br/….
  • http://prezi.com/fmafkfhapydi/do-jdbc-10-ao-jpa-20/http://prezi.com/…./do-jdbc-10-ao-jpa-20
• Driver para acessar multiplos bancos
  • http://www.unityjdbc.com/
  • https://github.com/tensult/multidb-jdbc-driver