Data 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 Example with MySQL
Mapping
MySQL Data Types in Java Data 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.
Connecting to a MySQL Database in Java
In this section, you will learn how to connect the
MySQL database with Java file. We need to establish a connection between
MySQL and Java files so that we can use MySQL driver for MySQL.
Creating a
Database in MySQL
After establishing the connection with MySQL database by using the JDBC
driver, you will learn how we can create our database.
Creating a Database Table
Here, providing you an example with code and it's
description that helps you to create a database table in a database through the
java file.
Creating a MySQL Database Table to store Java Types
Dear user, consider a case where we need to store a java types in our
database table. This section describes how to create a MySQL database
table that stores all java types.
Description of
Database Table This section introduces you how to get the detailed information about
the database table. As we all know that, table has some specific information
like: field, type, null etc.
Deleting a Table from Database
This section describes how to delete a table from database.
Java provide the facility for deleting a specific table from a given database
with the help of some specified methods.
Retrieving Tables from a Database
This section provides you a facility for retrieving
tables from a specific database through an example. You have to know about a
database that is a collection of data or information.
Inserting values
in MySQL database table Here we are going to see, how we can insert values in the MySQL
database table. We know that tables store data in rows and column format.
After creating a database table, you insert the values in it.
Retrieving All Rows from a Database Table
Here, you will learn how to retrieve all rows from a
database table. You know that table contains or stores the data in rows and
columns format. If you want to access the data from a table then you need to use
some APIs and methods.
Count Rows from a
Database Table After creating a database table, if we want to know number of rows in a
table then we can get it very easily by using the simple database query.
Getting Column Names
from a database table in Java Here, providing you an example with code that retrieves all columns name
in a specific database table. Sometimes, you need to know the number of
columns and the names of the columns of the table then you can retrieve it
with the help of this example.
Adding a New Column in
Database Table In this jdbc tutorial program we are going to learn about adding
a new column in database table. Sometimes it happens that we have created a
table and forgets to add some important column name into it.
Rename Column
Name of a Database Table This section provides you an example with code for renaming a column
name in a database table. As we know that each table keeps contents in rows
and column format.
Make Unique key
in a Column In this section you will learn, how to define a unique key in a column
of a database table. While declaring unique key in a column we should check
whether this column is eligible to store a unique values or not because if
the column has been declared as unique then it can't store a duplicate
values.
Remove Unique
Key in Database Table In this section, we will see how to remove unique field of the
particular column in a database table. We know that, any table stores
data in the form of rows and columns.
Arranging Records
of Database Table in Ascending Order This section will provide you the facility for arranging the data of
database table in ascending order. Firstly we should know what is the
meaning of ascending order. The ascending order means an arrangement of data
from smallest to largest number in sequence like: 3,6,8,19,21,.........
Arranging Records
of Database Table in Descending Order This section provides an example with code that arrange the records of
database table in descending order. The descending order provides a way for
arranging records from largest to smallest in a sequence like:
100,85,45,12,.........
Sum of Specific Column
Data in a Database Table This section describes how we can calculate the sum of specific column
data in the database table. Consider an example of any university where we
need to calculate the sum of numbers achieved by the student.
Deleting All
Rows from a Database Table Consider a case where we have been given one database table, now we have
to delete all the rows from the table. This section describes for deleting
all rows from a specific database table.
Delete a
Specific Row from a Database Table Consider a case where we are creating a table and we have add some data
in it. It may happen that we might add a wrong data in a row, now we need to
delete that particular data. This can be done very easily , and in this
section we are going to do the same that is, how to delete a specific row
from a specific database table.
Delete a Column from
a Database Table In this section, we are going to learn how to delete a column from a
database table. We are not going to create a new table into, and we are
expecting that you can make a table yourself.
Join tables in
the specific database In this section, we are going to consider how to join two or more tables
in a specific database. For this you need to have two or more table in the
database. If two or more tables are available in the database then Join
operation is performed otherwise not.
Join tables
with the NATURAL LEFT JOIN operation This section describes the NATURAL LEFT JOIN operation and
how to retrieve data through it. In this operation we are going to retrieve
data according to match the field name of another tables.
Join tables
with the NATURAL RIGHT JOIN operation This section describes the NATURAL RIGHT JOIN operation of
table in a specific database. This operation join tables on the basis of
matching fields but priority will be given to the right table field values.
Cross Join
Tables in a Specific Database This section introduces you to the cross join between two
tables. The cross join operation retrieves data between two tables as a Cartesian
product of set theory in mathematics. All data show to multiply by each
rows.
Prepared
Statement Set Object
In JDBC tutorial we are going to learn about the PreparedStatement
and how to use with setObject method.
Statement
Batch Update In this section we are going to learn about the batch update and how to
use it. Here, we are providing an example with code to execute the statement
in a batch. Batch updates means more than one statements are executed or
updates simultaneously in the database.
Prepared
Statement Batch Update This section helps to use the prepared statement with batch
update and we are going to provide an example that performs batch update
facility.
Select Records
Using Prepared Statement In this section we will learn how to select the some specific records by
using the PreparedStatement. We know that the PreparedStatement
object represents a precompiled SQL statement.
Update Records
using Prepared Statement The JDBC provides you the facility for updating the records. In
this JDBC tutorial we are going to learn about the process of
updating the records by using the PreparedStatement.
Inserting Records
using the Prepared Statement In this section we are going to learn how will insert the records in the
database table by using the PreparedStatement interface of java.sql
package.
Count Records using
the Prepared Statement In this section we will learn how to count all records of the database
table by using the PreparedStatement interface of java.sql
package.
Deleting Records
using the Prepared Statement This section helps us for deleting the records from the database
table by using the PreparedStatement interface of the java.sql
package.
Using the
Prepared Statement Twice Time This JDBC tutorial helps us for using the PreparedStatement
interface of java.sql package twice times in a program. According to
our requirement we can use the PreparedStatement object one or more
times in a program for different purposes.
Set Data Types by
using Prepared Statement In this section we are going to learn the method for setting data types
(String, int, float and double) in the PreparedStatement
interface of java.sql package.
Prepared Statement
Set Big Decimal In this JDBC section we are going to learn about the big decimal
and how can be set it in the database table by using the PreparedStatement
interface of java.sql package.
Set Date by using the
Prepared Statement This JDBC tutorial helps us for setting date in the database
table by using the PreparedStatement interface of
java.sql package.
Set Time by using the
Prepared Statement In this section you will learn about setting the time in database table
by using the PreparedStatement interface of java.sql package.
Suppose you want to insert the actual time in a table, here you will provide
a setTime method for setting the time.
Set Timestamp by
using the Prepared Statement In this JDBC tutorial we will teach how to set the Timestamp
in database table by using the PreparedStatement interface of java.sql
package. If you want to insert the Timestamp in a table,here you will
provide the setTimestamp method that added date and time in the
database table by using the java.util.Date package.
Write Text File to Table In this section, you will learn how to read the records
of a simple text file and write (insert) into a simple table in MySQL
database. All records are written in the simple text file and again, if you need
to insert these records in tabular format the following example will provide the
facility for writing this content.
Copy
One Database Table to Another In this section, you will learn to copy one database table to another
database table. That means we copy one table to a different table but it
contains a similar type of field or column.
Thats really really gr8 & Useful for a beginner like me, thank's a lot for this, wish you all the best for for your future and i hope that we all beginners may get this type of useful tutorials in the future...
thru this tutorial i think you saved me out of my days frustation and to be get an useless worker in my clients view...
thakns a lot
Posted by sarvesh on Tuesday, 03.4.08 @ 22:00pm | #51329
How can i express my gratitude and appreciation to you, mere words alone can not convey the joy i felt as i read and reread your tutorial. Believe me, you are the best in making individuals like me understand complicated terminologies and tactics.
In short, please accept my heart-felt genuine thanks.....
I am indebted to yu forever.
Posted by faisal on Monday, 07.9.07 @ 19:07pm | #20978
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
