jdbc事务初探（JDBC transaction）.docVIP

jdbc事务初探（JDBC transaction） For a long time did not update Blog, a little ashamed ah, ha ha, I have been studying the transaction unsuspectingly. Spring put it all a very good package, so that I cant write a normal decent JDBC transaction processing procedures, if I write statements by JDBC, there are still a lot of ASP shadow. I bought a October programmer magazine, did not expect the transaction which was about SQL Server, I sat it out, so I want to put it into the actual Java code. Oh, well, we start todays journey. First of all, my platform is WindowsXP2+JDK1.5+myeclispe6.0+mysql5.037. This configuration may not be the same with you, please note. To build a database, I use the built-in MySQL test, in which to set up a form, the structure is as follows, you can easily set up, do not be too concerned about, because of, so start is not very complex, but things are as simple as possible, ha ha. SQL code DROP TABLE IF EXISTS `tbl_tran`; CREATE TABLE (`tbl_tran` `id` int (10) unsigned NOT NULL auto_increment, `name` varchar (45) NOT NULL, `age` int (10) unsigned NOT NULL, `gender` char (1) NOT NULL, `memo` text, PRIMARY KEY (`id`) ENGINE=InnoDB DEFAULT CHARSET=utf8); To establish a good table, can add a test data for example: SQL code INSERT INTO `tbl_tran` VALUES (1,leo, 0,M,Hello, leo); Everything is ready. Start to write the test code. Java code Package com.leo.tran; Import java.sql.Connection; Import java.sql.ResultSet; Import java.sql.SQLException; Import java.sql.Statement; Import com.leo.jdbc.DBConnection; Public class {TranJDBC1 Private static Connection conn; Private static Connection conn_two; / / a record to test Private static String testName = leo; A field / the record to update the test Private static int testAge = 23; / * * * initialize the two connection, do not use a single case * / {static (conn = DBConnection.getConnection); (conn_two = DBConnection.getConnection); {try Conn_two.setAutoCommit (false); Catch (SQLException E) {} (e.printStackTrace); }