Database Connectivity Example In JavaIn Java to work with database there is a need of active connection between the Java program and DBMS. Java provides an API named JDBC to establish a connection with the specified database and to do the required task..

Change Column Name in MySQLIn this example How to change column name in MySQL. First of all we have created MySQL database with many fields in table. We rename a column in MySQL using alter Table name and change. The current column is named old_col but if you want to change the column name to new_col it can be done using the syntax given below. .

Java Mysql Connection ExampleWe are going to discus how to connect MySQL in java. We have been provide some classes and API with which we will make use of the database connection. Database plays an important role in any application which requires to store the data and to fetch the data..

Jdbc Get Column NamesThe JDBC Get Column Names return you the property of the retrieved Column like its field name and data type using meta Data..

JDBC Example with MySQLData types of MySQL and Java programming language are not same, its need some mechanism for transferring data between an database using MySQL data types and a application using Java data types..

JDBC Nested ResultsetThe JDBC Nested Result Set is the simplest join algorithm. In this case for each tuple in the outer join relation, the entire inner join is scanned and the tuple matches the join condition are finally added to the result set..

JDBC-Odbc ConnectionJDBC-ODBC Connection is a JDBC driver that translates the operation in JDBC into ODBC. For ODBC,it is a normal java application program..