Notes

Connection connection = null;
// declare object of Statement interface that
uses for executing sql statements.
Statement statement = null;
// declare a resultset that uses as a table for
output data from the table.
ResultSet rs = null;
int updateQuery = 0;
// Load JBBC driver "com.mysql.jdbc.Driver".
Class.forName("com.mysql.jdbc.Driver").newInstance();
/* Create a connection by using getConnection()
method that takes parameters of string type
connection url, user name and password to
connect to database. */
connection = DriverManager.getConnection
(connectionURL, "root", "root");

/* createStatement() is used for create
statement object that is used for sending sql
statements to the specified database. */
statement = connection.createStatement();
// sql query of string type to create a data base.
String QueryString = "CREATE TABLE
user_master1(User_Id INTEGER NOT "+"NULL
AUTO_INCREMENT, User_Name VARCHAR(25),
UserId VARCHAR(20) "+ ", User_Pwd
VARCHAR(15), primary key(User_Id))";
updateQuery = statement.executeUpdate(QueryString);
// sql query to insert values in the specified table.
QueryString = "INSERT INTO user_master1
(User_Name,UserId,User_Pwd) VALUES "+"('Mahendra
','mahendra25','1213456')";
updateQuery = statement.executeUpdate(QueryString);