SQL Server Database Programming with Java [electronic resource] : Concepts, Designs and Implementations /

Introduction -- Introduction to Database -- JDBC API and JDBC Drivers -- JDBC Application and Design Considerations -- Introduction to Apache NetBeans IDE -- Query Data from Databases -- Insert, Update and Delete Data from Databases -- Developing Java Web Applications to Access Databases -- Developing Java Web Services to Access Databases -- Appendix A - Install and Configure SQL Server 2019 Express Database And SQL Server Management Studio -- Appendix B - Download and Install JDK 14 and Apache NetBeans 12 -- Appendix C - Download and Install DevExpress .NET UI Controls -- Appendix D - How to Use Sample Database -- Appendix E - Data Type Mappings between SQL Statements and Java Applications -- Appendix G - Download and install JDBC 4.2 -- Appendix H - Download and install NetBeans IDE 8.2 and Glassfish Server -- Appendix I - Modify the HTTP Port Number for Tomcat Server -- Index.

This textbook covers both fundamental and advanced Java database programming techniques for beginning and experienced students as well as programmers (courses related to database programming in Java with Apache NetBeans IDE 12 environment). A sample SQL Server 2019 Express database, CSE_DEPT, is created and implemented in all example projects throughout this textbook. Over 40 real sample database programming projects are covered in this textbook with detailed illustrations and explanations to help students understand the key techniques and programming technologies. Chapters include homework and selected solutions to strengthen and improve students’ learning and understanding for topics they study in the classroom. Both Java desktop and Web applications with SQL Server database programming techniques are discussed and analyzed. Some updated Java techniques, such as Java Server Pages (JSP), Java Server Faces (JSF), Java Web Service (JWS), JavaServer Pages Standard Tag Library (JSTL), JavaBeans and Java API for XML Web Services (JAX-WS) are also discussed and implemented in the real projects developed in this textbook. This textbook targets mainly advanced-level students in computer science, but it also targets entry-level students in computer science and information system. Programmers, software engineers and researchers will also find this textbook useful as a reference for their projects.