Author: Vivian Siahaan
Publisher: SPARTA PUBLISHING
ISBN:
Category : Computers
Languages : en
Pages : 440

View

Book Description
This step-by-step guide to explore database programming using Java is ideal for people with little or no programming experience. The goal of this concise book is not just to teach you Java, but to help you think like a programmer. Each brief chapter covers the material for one week of a college course to help you practice what you've learned. As you would expect, this book shows how to build from scratch two different databases: MariaDB and SQLite using Java. In designing a GUI and as an IDE, you will make use of the NetBeans tool. In the first chapter, you will learn the basics of cryptography using Java. Here, you will learn how to write a Java program to count Hash, MAC (Message Authentication Code), store keys in a KeyStore, generate PrivateKey and PublicKey, encrypt / decrypt data, and generate and verify digital prints. In the second chapter, you will learn how to create and store salt passwords and verify them. You will create a Login table. In this case, you will see how to create a Java GUI using NetBeans to implement it. In addition to the Login table, in this chapter you will also create a Client table. In the case of the Client table, you will learn how to generate and save public and private keys into a database. You will also learn how to encrypt / decrypt data and save the results into a database. In the third chapter, you will create an Account table. This account table has the following ten fields: account_id (primary key), client_id (primarykey), account_number, account_date, account_type, plain_balance, cipher_balance, decipher_balance, digital_signature, and signature_verification. In this case, you will learn how to implement generating and verifying digital prints and storing the results into a database. In the fourth chapter, You create a table with the name of the Account, which has ten columns: account_id (primary key), client_id (primarykey), account_number, account_date, account_type, plain_balance, cipher_balance, decipher_balance, digital_signature, and signature_verification. In the fifth chapter, you will create a Client_Data table, which has the following seven fields: client_data_id (primary key), account_id (primary_key), birth_date, address, mother_name, telephone, and photo_path. In chapter six, you will be shown how to create SQLite database and tables with Java. In chapter seven, you will be taught how to extract image features, utilizing BufferedImage class, in Java GUI. Digital image techniques to extract image features used in this chapted are grascaling, sharpening, invertering, blurring, dilation, erosion, closing, opening, vertical prewitt, horizontal prewitt, Laplacian, horizontal sobel, and vertical sobel. For readers, you can develop it to store other advanced image features based on descriptors such as SIFT and others for developing descriptor based matching. In chapter eight, you will be taught to create Java GUI to view, edit, insert, and delete Suspect table data. This table has eleven columns: suspect_id (primary key), suspect_name, birth_date, case_date, report_date, suspect_ status, arrest_date, mother_name, address, telephone, and photo. In chapter nine, you will be taught to create Java GUI to view, edit, insert, and delete Feature_Extraction table data. This table has eight columns: feature_id (primary key), suspect_id (foreign key), feature1, feature2, feature3, feature4, feature5, and feature6. All six fields (except keys) will have a BLOB data type, so that the image of the feature will be directly saved into this table. In chapter ten, you will add two tables: Police_Station and Investigator. These two tables will later be joined to Suspect table through another table, File_Case, which will be built in the seventh chapter. The Police_Station has six columns: police_station_id (primary key), location, city, province, telephone, and photo. The Investigator has eight columns: investigator_id (primary key), investigator_name, rank, birth_date, gender, address, telephone, and photo. Here, you will design a Java GUI to display, edit, fill, and delete data in both tables. In chapter eleven, you will add two tables: Victim and Case_File. The File_Case table will connect four other tables: Suspect, Police_Station, Investigator and Victim. The Victim table has nine columns: victim_id (primary key), victim_name, crime_type, birth_date, crime_date, gender, address, telephone, and photo. The Case_File has seven columns: case_file_id (primary key), suspect_id (foreign key), police_station_id (foreign key), investigator_id (foreign key), victim_id (foreign key), status, and description. Here, you will also design a Java GUI to display, edit, fill, and delete data in both tables. Finally, this book is hopefully useful and can improve database programming skills for every Java/MariaDB/SQLite pogrammer.

Author: Matthew D. Siple
Publisher: McGraw-Hill Companies
ISBN:
Category : Computers
Languages : en
Pages : 356

View

Book Description
Presenting the complete, in-depth guide to JDBC (Java Database Connectivity)--the key to creating a new generation of data-rich Java applications, and the new standard that database vendors from Oracle to Sybase are lining up to support. North explains the how-to's of JDBC and covers its relationship with ODBC. The CD contains sample code written to the JDBC and ODBC APIs.

Author: Mark Matthews
Publisher: John Wiley & Sons
ISBN: 0471462225
Category : Computers
Languages : en
Pages : 434

View

Book Description
Hier erfahren Java Entwickler alles, was sie wissen müssen, um Java Datenbankanwendungen mit MySQL zu entwickeln. "MySQL and Java Developer's Guide" ist der erste umfassende Leitfaden zu MySQL für Java-Entwickler. Er basiert auf einem praxisorientierten und codeintensiven Ansatz. Hier lernen Java Entwickler, wie sie eine komplexe Managementanwendung für Webdatenbanken entwickeln. Zunächst gibt der Autor einen Überblick über die Grundlagen von MySQL. Dann erklärt er, wie man JDBC mit MySQL verwendet und wie man Servlets und JSP mit MySQL entwickelt. Mit einem codeintensiven Tutorial. Es demonstriert, wie man die Muster-Datenbankanwendung mit Hilfe von EJB entwickelt. Mit begleitender Website. Sie enthält die kompletten Quellcodebeispiele aus dem Buch sowie Links zu anderen nützlichen Seiten. Geschrieben von Mark Matthews, dem Erfinder des JDBC-Treibers für MySQL und unbestrittene Autorität auf dem Gebiet der Java Programmierung mit MySQL.

Author: Gregory D. Speegle
Publisher: Morgan Kaufmann
ISBN: 1558607366
Category : Computers
Languages : en
Pages : 130

View

Book Description
1 -- Introduction to JDBC -- 2 -- Presenting Information to Users -- 3 -- Querying the Database -- 4 -- Updating the Database -- 5 -- Advanced JDBC Topics -- 6 -- An eCommerce Example -- 7 -- How to Stay Current with JDBC -- 8 -- Appendix.

Author: Donald Bales
Publisher: "O'Reilly Media, Inc."
ISBN: 9780596000882
Category : Business & Economics
Languages : en
Pages : 500

View

Book Description
JDBC is the key Java technology for relational database access. Oracle is arguably the most widely used relational database platform in the world. In this book, Donald Bales brings these two technologies together, and shows you how to leverage the full power of Oracle's implementation of JDBC. You begin by learning the all-important mysteries of establishing database connections. This can be one of the most frustrating areas for programmers new to JDBC, and Donald covers it well with detailed information and examples showing how to make database connections from applications, applets, Servlets, and even from Java programs running within the database itself. Next comes thorough coverage of JDBC's relational SQL features. You'll learn how to issue SQL statements and get results back from the database, how to read and write data from large, streaming data types such as BLOBs, CLOBs, and BFILEs, and you'll learn how to interface with Oracle's other built-in programming language, PL/SQL. If you're taking advantage of the Oracle's relatively new ability to create object tables and column objects based on user-defined datatypes, you'll be pleased with Don's thorough treatment of this subject. Don shows you how to use JPublisher and JDBC to work seamlessly with Oracle database objects from within Java programs. You'll also learn how to access nested tables and arrays using JDBC. Donald concludes the book with a discussion of transaction management, locking, concurrency, and performance--topics that every professional JDBC programmer must be familiar with. If you write Java programs to run against an Oracle database, this book is a must-have.

Author: George Reese
Publisher: "O'Reilly Media, Inc."
ISBN: 9781565926165
Category : Computers
Languages : en
Pages : 356

View

Book Description
Java and databases make a powerful combination. Getting the two sides to work together, however, takes some effort--largely because Java deals in objects while most databases do not. This book describes the standard Java interfaces that make portable object-oriented access to relational databases possible and offers a robust model for writing applications that are easy to maintain. It introduces the JDBC and RMI packages and uses them to develop three-tier applications (applications divided into a user interface, an object-oriented logic component, and an information store). The book begins with a quick overview of SQL for developers who may be asked to handle a database for the first time. It then explains how to issue database queries and updates through SQL and JDBC. It also covers the use of stored procedures and other measures to improve efficiency, where these are available. But the book's key contribution is a set of patterns that let developers isolate critical tasks like object creation, information storage and retrieval, and the committing or aborting of transactions. The second edition includes more basics of JDBC and SQL, with more examples, and a deeper discussion about the architecture of a robust, maintainable database application. The second edition also explains the relationship between JDBC and Enterprise JavaBeans.

Author: Pratik Patel
Publisher:
ISBN: 9781576100561
Category : Computers
Languages : en
Pages : 500

View

Book Description
This text presents the JDBC standard, Java's database connectivity environment, and provides information for using Java with JDBC for accessing databases. The manual is designed for users who are learning database programming for the Internet or company In

Author: Maydene Fisher
Publisher: Addison-Wesley Professional
ISBN: 9780321173843
Category : Computers
Languages : en
Pages : 1288

View

Book Description
bull; A comprehensive tutorial AND useful rufescence in one volume bull; Includes multiple explanations and examples for the new features of the JDBC 3.0 specification bull; Written by the JDBC 3.0 architects, Maydene Fisher, Jon Ellis and Jonathan Bruce

Author: Brian Jepson
Publisher: Wiley
ISBN: 9780471165187
Category : Computers
Languages : en
Pages : 500

View

Book Description
A complete guide to mastering the next generation of database programming technologies Java Database Programming teaches you the critical new Java database technologies and tools, including Sun Microsystems' Java Database Connectivity (JDBC) standard. You'll learn practical, step-by-step techniques with which you can harness the Java programming language. You will also learn how to create dynamic database applications and applets in both Internet and Intranet environments. Java Database Programming explains: How Java programs access online databases Integrating Java with networked database technologies Programming with JDBC How to develop JDBC drivers Java database tools and code libraries Java Database Programming is the innovative and hands-on book that will enable you to apply Java to real-world Internet and Intranet development. On the Java Database Programming supporting Web site, you'll find: tinySQL, a generic and extendable SQL engine written in Java The tinySQL JDBC driver Customizable Java database code Visit our Web site at: http://www.wiley.com/compbooks/

Author: Paul J. Deitel
Publisher: Pearson Education
ISBN: 9780137018512
Category : Computers
Languages : en
Pages : 1200

View

Book Description
PRACTICAL, EXAMPLE-RICH COVERAGE OF: Classes, Objects, Encapsulation, Inheritance, Polymorphism, Interfaces, Nested Classes Integrated OOP Case Studies: Time, GradeBook, Employee Industrial-Strength, 95-Page OOD/UML® 2 ATM Case Study JavaServer™ Faces, Ajax-Enabled Web Applications, Web Services, Networking JDBC™, SQL, Java DB, MySQL® Threads and the Concurrency APIs I/O, Types, Control Statements, Methods Arrays, Generics, Collections Exception Handling, Files GUI, Graphics, GroupLayout, JDIC Using the Debugger and the API Docs And more… VISIT WWW.DEITEL.COM For information on Deitel’s Dive Into® Series corporate training courses offered at customer sites worldwide (or write to [email protected]) Download code examples Check out the growing list of programming, Web 2.0, and software-related Resource Centers To receive updates for this book, subscribe to the free DEITEL® BUZZ ONLINE e-mail newsletter at www.deitel.com/newsletter/subscribe.html Read archived issues of the DEITEL® BUZZ ONLINE The practicing programmer’s DEITEL® guide to Java™ development and the Powerful Java™ Platform Written for programmers with a background in high-level language programming, this book applies the Deitel signature live-code approach to teaching programming and explores the Java language and Java APIs in depth. The book presents the concepts in the context of fully tested programs, complete with syntax shading, code highlighting, line-by-line code descriptions and program outputs. The book features 220 Java applications with over 18,000 lines of proven Java code, and hundreds of tips that will help you build robust applications. Start with an introduction to Java using an early classes and objects approach, then rapidly move on to more advanced topics, including GUI, graphics, exception handling, generics, collections, JDBC™, web-application development with JavaServer™ Faces, web services and more. You’ll enjoy the Deitels’ classic treatment of object-oriented programming and the OOD/UML® ATM case study, including a complete Java implementation. When you’re finished, you’ll have everything you need to build object-oriented Java applications. The DEITEL® Developer Series is designed for practicing programmers. The series presents focused treatments of emerging technologies, including Java™, C++, .NET, web services, Internet and web development and more. PRE-PUBLICATION REVIEWER TESTIMONIALS “Presenting software engineering side by side with core Java concepts is highly refreshing; gives readers insight into how professional software is developed.”—Clark Richey (Java Champion), RABA Technologies, LLC. “The quality of the design and code examples is second to none!”—Terrell Hull, Enterprise Architect “The JDBC chapter is very hands on. I like the fact that Java DB/Apache Derby is used in the examples, which makes it really simple to learn and understand JDBC.”—Sandeep Konchady, Sun Microsystems “Equips you with the latest web application technologies. Examples are impressive and real! Want to develop a simple address locator with Ajax and JSF? Jump to Chapter 22.”—Vadiraj Deshpande, Sun Microsystems “Covers web services with Java SE 6 and Java EE 5 in a real-life, example-based, friendly approach. The Deitel Web Services Resource Center is really good, even for advanced developers.”—Sanjay Dhamankar, Sun Microsystems “Mandatory book for any serious Java EE developer looking for improved productivity: JSF development, visual web development and web services development have never been easier.”—Ludovic Chapenois, Sun Microsystems “I teach Java programming and object-oriented analysis and design. The OOD/UML 2 case study is the best presentation of the ATM example I have seen.”—Craig W. Slinkman, University of Texas–Arlington “Introduces OOP and UML 2 early. The conceptual level is perfect. No other book comes close to its quality of organization and presentation. The live-code approach to presenting exemplary code makes a big difference in the learning outcome.”—Walt Bunch, Chapman University/