Kode Java

 
package org.kodejava.example.sql;
 
import java.sql.*;
 
public class TransactionRollbackExample {
    public static void main(String[] args) throws Exception {
        String url = "jdbc:mysql://localhost/testdb";
        String username = "root";
        String password = "";
 
        Connection conn = null;
        try {
            Class.forName("com.mysql.jdbc.Driver");
            conn = DriverManager.getConnection(url, username, password);
            conn.setAutoCommit(false);
 
            StringBuilder sb = new StringBuilder("INSERT INTO orders (username, order_date) " +
                    "VALUES ('javaduke', '2007-12-13')");
            Statement orderStmt = conn.createStatement();
            orderStmt.execute(sb.toString(), Statement.RETURN_GENERATED_KEYS);
 
            ResultSet keys = orderStmt.getGeneratedKeys();
            int id = 1;
            while (keys.next()) {
                id = keys.getInt(1);                
            }
 
            String insertDetail = "INSERT INTO order_details (order_id, product_id, quantity, price) " +
                    "VALUES (?, ?, ?, ?)";
            PreparedStatement detailStmt = conn.prepareStatement(insertDetail);
            detailStmt.setInt(1, id);
            detailStmt.setString(2, "P0000001");
            detailStmt.setInt(3, 10);
            detailStmt.setDouble(4, 100);
            detailStmt.execute();
 
            //
            // Commit transaction to mark it as a success database operation
            //
            conn.commit();
            System.out.println("Transaction commit...");
        } catch (SQLException e) {
            //
            // Rollback any database transaction due to exception occured
            //
            if (conn != null) {
                conn.rollback();
                System.out.println("Connection rollback...");
            }
            e.printStackTrace();
        } finally {
            if (conn != null && !conn.isClosed()) {
                conn.close();
            }
        }
    }
}
 
 

• How do I convert String to Date object?
• How do I convert array to collection?
• How do I get day, month, year value from the current date?
• How do I read a text file?
• How do I format a number?
• How do I get the current month name?
• How do I use StringTokenizer to split a string?
• How do I convert collection into array?
• How do I do a date add or substract?
• How do I write string data to file?

• How do I reverse a string?
• What need to be prepared for learning Java Programming?
• How do I implement a Singleton pattern?
• How do I split a string?
• How do I read text file content line by line using commons-io?
• How do I create a zip file?
• How do I calculate days difference between two dates?
• Hello World example in Java
• How do I create a connection to database?
• How do I create a beep sound?

• Java Programming Keywords Summary
• How do I read an XML document using JDOM?
• How do I sort items of an ArrayList?
• How do I sort array values in case insensitive order?
• How do I sort array values in descending order?
• How do I limit the Hibernate query result?
• How do I store properties as XML file?
• How do I load properties from XML file?
• How do I convert InputStream to String?
• How do I convert string into InputStream?

• How do I determine bean's property type?
• How do I read mapped bean's property value?
• How do I read indexed bean's property value?
• How do I read bean's nested property value?
• How do I read bean's property value?
• How do I find text between two strings?
• How do I check for an empty string?
• How do I get the nearest hour, minute, second of a date?
• How do I format date and time using DateFormatUtils class?
• How do I find items in an array?