You can divide database results into pages with this script. This source code is for available to use with MySQL. But you can modify the code to use with PostgreSql and Oracle. You can not use this code with MS-SQL. Becuase MS-SQL does not support using 'LIMIT' in your sql queries.
This code source displays count of records in MySQL. We are using a SQL statement. You can easily modify the code to use in different languages. But this code can be used for JSP with MySQL. We will use Connector/J driver to connect database.
A tutorial on how to connect to a MySQL Database using Connector/J JDBC Driver. Explains what are database URLs? Why and how to specify JDBC driver names? Then moves on to write a simple Java program to connect to a MySQL database server. Explains all the code in detail.
RDF is increasingly recognized as an excellent choice for representing and processing semi-structured data. In this article, Web developer Philip McCarthy shows you how to use the Jena Semantic Web Toolkit to exploit RDF data models in your Java applications.
This article provides a brief introduction to JDBC. Explains what is JDBC and how it can be used to access RDBMS. Provides a brief overview of JDBC architecture.
This tutorial shows you how to build a database application using Java 2 Micro Edition (J2ME) Record Management System (RMS). It also demonstrates how to craft a MIDlet that performs the necessary logic of creating and accessing a sample database application and deploys it to a J2ME environment.
A tutorial on obtaining, installing and configuring MySQL Database and Connector/J JDBC Driver for use on Microsoft Windows. Advanced topics covered include installing MySQL as a Windows service and configuring MySQL and Connector/J JDBC Driver to use named pipes.
A tutorial on how to create and execute JDBC SQL Statements and display records from a table in a MySQL Database. Also covers topics like creating databases and tables in MySQL. All code is explained in detail.
JDBC provides a powerful, comprehensive interface for accessing databases from Java programs. For smaller projects, JDBC can seem overwhelming, driving some programmers to avoid using a database altogether. This article describes a simple wrapper library that makes basic database usage a snap. You'll find yourself wanting to use JDBC for every program you write.