Develop a Java program to demonstrate the execution of create and insertqueries using JDBC

Sure, here is a simple Java program that demonstrates the execution of create and insert queries using JDBC.

import java.sql.*;

public class Main {
    public static void main(String[] args) {
        try {
            // Step 1: Load the JDBC driver
            Class.forName("com.mysql.jdbc.Driver");

            // Step 2: Establish a connection to the database
            Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/myDatabase", "username", "password");

            // Step 3: Create a statement
            Statement stmt = conn.createStatement();

            // Step 4: Execute a create query
            String createQuery = "CREATE TABLE Students (ID INT, Name VARCHAR(20), Age INT, Gender CHAR(1))";
            stmt.executeUpdate(createQuery);

            // Step 5: Execute an insert query
            String insertQuery = "INSERT INTO Students VALUES (1, 'John Doe', 20, 'M')";
            stmt.executeUpdate(insertQuery);

            // Step 6: Close the connection
            conn.close();
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}

Please replace "com.mysql.jdbc.Driver", "jdbc:mysql://localhost:3306/myDatabase", "username", and "password" with your actual JDBC driver, database URL, username, and password.

This program does the following:

1. Loads the JDBC driver.
2. Establishes a connection to the database.
3. Creates a Statement object.
4. Executes a CREATE TABLE query to create a new table named Students.
5. Executes an INSERT INTO query to insert a new row into the Students table.
6. Closes the connection to the database.

Please note that this is a very basic example and doesn't include any error handling or transaction management code that a real-world application should have.