New Scripts | Java | Tutorials & Tips | Database-Related

This tutorial will explain how you can create a SQLite instance for your android application, and how you can perform basic CRUD operations. You can then modify it to work with your own applications

ZIPCodeWorld.com provides this function to calculate the latitude and longitude coordinates from Vertical and Horizontal (V&H) coordinates in Java. V&H's are used to identify locations and hence relative distances between network elements and between rate centers listed in AreaCodeWorld(TM) North American Area Code Database Subscription which includes NPA (area code), NXX (exchange), country, state, county, latitude, longitude, etc.

This Tutorial provides tutorial notes on executing DML statements with Java DB (Derby) JDBC Driver. Topics include inserting, updating and deleting data rows in existing tables; creating IDENTITY columns; handling date and timestamp values.

This article provides tutorial notes on using DataSource objects and JNDI to connect Java DB (Derby) Database. Topics include creating connections with ClientDataSource objects directly without JNDI; downloading and installing JNDI File System Service Provider; Binding ClientDataSource objects to JNDI names; Looking up ClientDataSource objects through JNDI.

This article provides tutorial notes on the JDBC driver for Java DB (Derby) produced by Apache. Topics include loading JDBC driver classes; connecting Derby Network Server; getting JDBC driver information; creating tables and running queries through the Derby JDBC driver.

Tutorials on using the JDBC-ODBC Bridge driver with MS Access database. Topics include creating MS Access database file; creating DSN for MS Access database files; inserting rows to and retrieving rows from Access database.

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 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.

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.

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.

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.

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.

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.

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. This article summarizes the key new features as outlined in Sun Microsystems' recently released Proposed Final Draft 3.0 of the JDBC specification.