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.

In this tutorial following topics will be covered: 1) What are JDBC SQL Statements? 2) What are different types of JDBC SQL Statements? 3) How to create and execute JDBC SQL Statements? 4) Basics of creating databases and tables in MySQL. 5) How to display records from a table in MySQL?

In this tutorial following topics will be covered: 1) What are Database URLs in JDBC? 2) Why and how to specify a JDBC Driver name? 3) How to create a connection to a Database? 4) An example on how to connect to a MySQL Database?

The Java Database Connectivity (JDBC) API has emerged as a key part of the Java 2 Standard Edition (J2SE) and Java 2 Enterprise Edition (J2EE) platforms. It is the primary standards-based mechanism for the Java language to programmatically access relational databases, so when a new version of the specification is released by the Java Community Process, developers are bound to be interested. Here we summarize the key new features as outlined in Sun Microsystems' recently released Proposed Final Draft 3.0 of the JDBC specification.

Following topics will be covered in this tutorial: 1) How to obtain, install and configure MySQL Database? 2) How to configure MySQL to use InnoDB tables? (for transaction support) How to configure MySQL to use TCP/IP as well as named pipes on NT based Windows systems? 3) How to start MySQL Database server? How to setup root password and remove ghost account? 4) How to install MySQL as a Windows service on NT based Windows systems? 5) How to obtain and install Connector/J MySQL JDBC Driver? 6) How to test if Connector/J has been installed and configured correctly? 7) How to configure Connector/J to use named pipes to connect to MySQL Database server? 8) Why and when to use named pipes in place of TCP/IP with MySQL/Connector/J?

In this article, we'll examine a simple abstraction layer which takes the bite out of using JDBC. For simple applications, it will let you save and load structured data in just a few lines of code. It won't handle sophisticated use of an RDBMS, but then, that's what we'd like to avoid, isn't it? 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.

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. JDBC stands for "Java DataBase Connectivity". It is an API (Application Programming Interface) which consists of a set of Java classes, interfaces and exceptions and a specification to which both JDBC driver vendors and JDBC developers (like you) adhere when developing applications.