23-01-25
----------
Q)Develop a Java application to store 2 accounts' data(accno,name,balance)
into the database.
Note:- Before developing this Java application, we need to do the following things
in order.

Step 1:- Login to MySQL DBMS.

Step 2:- create a database
               mysql>CREATE DATABASE ashokitdb;

Step 3:- enter into the database.
               mysql>USE  ashokitdb;

STEP 4:- create the table

mysql>CREATE TABLE ACCOUNT(ACCNO INT(11),NAME VARCHAR(20),BALANCE DOUBLE(10,2));


//AccountsStoringApplication.java
import java.sql.DriverManager;
import java.sql.Connection;
import java.sql.Statement;
class AccountsStoringApplication{
    public static void main(String args[]) throws Exception{
        Connection connection=DriverManager.getConnection("jdbc:mysql://localhost:3306/ashokitdb","root","ashokit");
        Statement statement=connection.createStatement();
        int re=statement.executeUpdate("INSERT INTO ACCOUNT VALUES(10001,'Rama',50000)");
	System.out.println(re+" account stored into the database");
         re=statement.executeUpdate("INSERT INTO ACCOUNT VALUES(10002,'Rahim',50000)");
	System.out.println(re+" more account stored successfully");
	statement.close();
	connection.close();
    }
}