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.
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:
CREATE DATABASE
db_name;
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:
import java.io.*;
import java.sql.*;
public class CreateDatabase{
public static void main(String[] args) {
System.out.println("Database creation example!");
Connection con = null;
try{
Class.forName("com.mysql.jdbc.Driver");
con = DriverManager.getConnection
("jdbc:mysql://localhost:3306/jdbctutorial","root","root");
try{
Statement st = con.createStatement();
BufferedReader bf = new BufferedReader
(new InputStreamReader(System.in));
System.out.println("Enter Database name:");
String database = bf.readLine();
st.executeUpdate("CREATE DATABASE "+database);
System.out.println("1 row(s) affacted");
}
catch (SQLException s){
System.out.println("SQL statement is not executed!");
}
}
catch (Exception e){
e.printStackTrace();
}
}
}
|
Download this example.
Output of program:
C:\vinod\jdbc\jdbc\jdbc-mysql>javac CreateDatabase.java
C:\vinod\jdbc\jdbc\jdbc-mysql>java CreateDatabase
Database creation example!
Enter Database name:
RoseIndia
1 row(s) affacted |
| 
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Current Comments
2 comments so far (post your own) View All Comments Latest 10 Comments:jdbc programs are very will but small exampls r requierd
Posted by srilatha on Friday, 03.7.08 @ 11:52am | #51812
Refering this site we can improve basic knowledge of DataBases.
Posted by Gayan on Friday, 06.15.07 @ 16:34pm | #19311