Java implements transaction, bank transfer and goods in and out of the warehouse based on JDBC

This paper describes the implementation of transaction, bank transfer and goods in and out of the warehouse in Java based on JDBC. Share with you for your reference, as follows:

1. Transfer business

The transaction must be committed when two SQL statements (update update) are successful. If one fails, both will roll back the transaction

2. A transaction should have four attributes: atomicity, consistency, isolation, and persistence. These four attributes are commonly referred to as acid properties.

① Atomicity. A transaction is an inseparable work unit, and all operations included in the transaction are either done or not done. ② consistency. A transaction must change the database from one consistency state to another. Consistency is closely related to atomicity. ③ isolation (isolation). The execution of a transaction cannot be disturbed by other transactions. That is, the operations and data used within a transaction are isolated from other concurrent transactions, and the concurrent transactions cannot interfere with each other. ④ persistence. Persistence is also called permanence (permanence) means that once a transaction is committed, its changes to the data in the database should be permanent. Other subsequent operations or failures should not have any impact on it.

3. Here, the transfer operation is taken as an example for demonstration. The points needing attention are as follows:

(1) An SQL statement operation does not require manual transaction submission

(2) The query operation does not require manual transaction submission,

(3) However, updates, inserts, and deletions require manual transaction commit

(4) If the balance is negative, you can query the result first, then judge, and then operate

(5)con. setAutoCommit(false); Manually start the transaction; con. commit(); Manually commit transactions; con. rollback(); Transaction rollback operation

4. First create a data table or two data tables. Here, to demonstrate clearly, create two data tables

5. Create the database and data table, and then write the tool class BaseDao java

6. The test is conducted directly in the main method, so write userdao to test and see the effect.

The demonstration effect is as follows:

Readers interested in more Java related content can view the special topics of this site: summary of database operation skills of Java using JDBC, summary of java + MySQL database programming, tutorial on Java data structure and algorithm, summary of java file and directory operation skills, summary of Java DOM node operation skills and summary of Java cache operation skills