Project-ByteBank

Neste projeto ByteBank temos o controle das contas bancárias por diversos níveis administrativos do banco bem como pelo próprio cliente proprietário da conta.

Aplicativos utilizados

• Eclipse IDE for Enterprise Java Developers (includes Incubating components) - Version: 2020-12 (4.18.0) - Build id: 20201210-1552 ( https://www.eclipse.org/downloads/ )
• Java version "1.8.0_271" - Java(TM) SE Runtime Environment (build 1.8.0_271-b09) - /Java HotSpot(TM) 64-Bit Server VM (build 25.271-b09, mixed mode)
• MySQL 8.0
• Apache Tomcat Version 9.0.41 ( https://tomcat.apache.org/download-90.cgi#9.0.41 )

Configurações

• https://www.devmedia.com.br/instalacao-e-configuracao-do-apache-tomcat-no-eclipse/27360

• https://docs.openkm.com/kcenter/view/okm-6.4/configuring-tomcat-port.html

• https://ibytecode.com/blog/eclipse-dtp-configure-mysql-datasource-using-data-source-explorer/

• https://jar-download.com/

• https://www.devmedia.com.br/criando-uma-conexao-java-mysql-server/16753

• https://pplware.sapo.pt/tutoriais/mysql-workbench-aprenda-a-criar-bases-de-dados-e-tabelas/

• https://www.mballem.com/post/jdbc-com-banco-de-dados-standalone/

Carregar MySql via CMD windows

• CD\Program Files\MySQL\MySQL Server 8.0\bin
• mysql -u root -p
• serverTimezone=UTC (database connection / driver proprieties / optional

Desenho do banco de dados

• https://app.diagrams.net/

Estudos

• https://www.codejava.net/coding/jsp-servlet-jdbc-mysql-create-read-update-delete-crud-example
• https://www.javaguides.net/2019/03/jsp-servlet-jdbc-mysql-crud-example-tutorial.html
• http://www.feltex.com.br/felix/exemplo-completo-jsp-jstl-servlet-jdbc-postgresql/