Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Equivalents of PHP PDO in Java [closed]

Is there something like PHP PDO for Java? So I can develop for SQLite in the beginning and later on switch to MySQL or PostgreSQL.

UPDATE: No I didn't search for Java database abstraction because I didn't know what to search for

like image 743
Marlinc Avatar asked Dec 07 '12 20:12

Marlinc


People also ask

Which is better MySQLi or PDO?

Both MySQLi and PDO have their advantages: PDO will work on 12 different database systems, whereas MySQLi will only work with MySQL databases. So, if you have to switch your project to use another database, PDO makes the process easy. You only have to change the connection string and a few queries.

Which is more secure PDO or MySQLi?

There is no difference in security. The main difference between PDO and Mysqli is that PDO supports various databases and mysqli supports only MySQL. MySQLi is also a bit faster. PDO supports 12 different drivers, opposed to MySQLi, which supports MySQL only.

What is PDO in PHP example?

PDO—PHP Data Objects—are a database access layer providing a uniform method of access to multiple databases. It doesn't account for database-specific syntax, but can allow for the process of switching databases and platforms to be fairly painless, simply by switching the connection string in many instances.

What is PDO method in PHP?

The PHP Data Objects (PDO) defines a lightweight interface for accessing databases in PHP. It provides a data-access abstraction layer for working with databases in PHP. It defines consistent API for working with various database systems.


1 Answers

Java Database Connectivity

JDBC is a Java-based data access technology (Java Standard Edition platform) from Sun Microsystems. It is an acronym as it is unofficially referred to as Java Database Connectivity, with DB being universally recognized as the abbreviation for database. This technology is an API for the Java programming language that defines how a client may access a database. It provides methods for querying and updating data in a database. JDBC is oriented towards relational databases. A JDBC-to-ODBC bridge enables connections to any ODBC-accessible data source in the JVM host environment.

like image 137
T.W.R. Cole Avatar answered Oct 04 '22 16:10

T.W.R. Cole