After establishing the connection with MySQL database by using the JDBC driver, you will learn how we can create our database. A database is a large collection of data or information stored in our computer in an arranged way. It helps us for accessing, managing and updating the data easily. In this example we are going to create a database by MySQL and with the help of some java methods and SQL statement. A RDBMS (Relational Database Management System) is a type of DBMS (Database Management System) which stores the data in the form of tables. So, we can view and use the same database in many different ways.
Description of program:
Firstly this program establishes the connection with MySQL database and takes a database name as its input in the database query and only after that it will create a new database and show a message "1 row(s) affected" otherwise, it displays "SQL statement is not executed!".
Description of code:
Above code is used for creating a new database. It takes a database name and then a new database is created by that name.
Here is the code of program:
Output of program:
Database creation example!
Enter Database name:
1 row(s) affacted
We have 1000s of tutorials on our website. Search Tutorials tutorials on our website.
Posted on: April 13, 2007 If you enjoyed this post then why not add us on Google+? Add us to your Circles