Main.java Source code

Introduction

Here is the source code for Main.java

Source

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class Main {
    public static void main(String[] args) throws Exception {
        String url = "jdbc:mysql://localhost/testdb";
        String username = "root";
        String password = "";
        Class.forName("com.mysql.jdbc.Driver");
        Connection conn = null;
        try {
            conn = DriverManager.getConnection(url, username, password);
            conn.setAutoCommit(false);

            Statement st = conn.createStatement();
            st.execute("INSERT INTO orders (username, order_date) VALUES ('java', '2007-12-13')",
                    Statement.RETURN_GENERATED_KEYS);

            ResultSet keys = st.getGeneratedKeys();
            int id = 1;
            while (keys.next()) {
                id = keys.getInt(1);
            }
            PreparedStatement pst = conn.prepareStatement(
                    "INSERT INTO order_details (order_id, product_id, quantity, price) VALUES (?, ?, ?, ?)");
            pst.setInt(1, id);
            pst.setString(2, "1");
            pst.setInt(3, 10);
            pst.setDouble(4, 100);
            pst.execute();

            conn.commit();
            System.out.println("Transaction commit...");
        } catch (SQLException e) {
            if (conn != null) {
                conn.rollback();
                System.out.println("Connection rollback...");
            }
            e.printStackTrace();
        } finally {
            if (conn != null && !conn.isClosed()) {
                conn.close();
            }
        }
    }
}