var _gaq = _gaq || []; _gaq.push(['_setAccount', 'UA-20738293-1']); _gaq.push(['_trackPageview']); (function() { var ga = document.createElement('script')"/>

          jutleo
          歡迎走進有風的地方~~
          posts - 63,  comments - 279,  trackbacks - 0
          package JDBC;

          import java.sql.BatchUpdateException;
          import java.sql.Connection;
          import java.sql.Date;
          import java.sql.PreparedStatement;
          import java.sql.ResultSet;
          import java.sql.SQLException;
          import java.sql.DriverManager;
          import java.sql.Statement;
          import java.sql.Time;
          import java.sql.Timestamp;
          import java.text.SimpleDateFormat;
          import java.util.Calendar;
          /**
           * 
           * 
          @author oakertree
           *
           
          */

          public class TestTransaction {
              
          public static void main(String[] args) {
                  Connection con 
          = null;
                  Statement stmt 
          = null;
          //        PreparedStatement stmt = null;
                  
                  
          try {
                      Class.forName(
          "com.mysql.jdbc.Driver");
          //            new com.mysql.jdbc.Driver();
                      con = DriverManager.getConnection("jdbc:mysql://localhost:3307/test""root""admini");
                      
                      con.setAutoCommit(
          false);
                      
                      stmt 
          = con.createStatement();
                      stmt.addBatch(
          "INSERT INTO time VALUES ( NOW(), NOW(), NOW())");
                      stmt.addBatch(
          "INSERT INTO time VALUES ( NOW(), NOW(), NOW())");
                      stmt.addBatch(
          "INSERT INTO time VALUES ( NOW(), NOW(), NOW())");
                      stmt.addBatch(
          "INSERT INTO time VALUES ( NOW(), NOW(), NOW())");
                      stmt.addBatch(
          "INSERT INTO time VALUES ( NOW(), NOW(), NOW())");
                      stmt.addBatch(
          "INSERT INTO time VALUES ( NOW(), NOW(), NOW())");
                      stmt.executeBatch();
                      
                      con.commit();
                      con.setAutoCommit(
          true);
                      
                      stmt.close();
                      
          /*
                      System.out.println(Date.valueOf("2004-02-19"));
                      System.out.println(Time.valueOf("14:29:32"));
                      System.out.println(Timestamp.valueOf("2008-12-01 12:25:32"));
                      
                      
                      stmt = con.prepareStatement("INSERT INTO time VALUES (?, ?, ?)");
                      stmt.setDate(1, Date.valueOf("2004-12-02"));
                      stmt.setTime(2, Time.valueOf("14:02:32"));
                      stmt.setTimestamp(3, Timestamp.valueOf("2004-12-01 12:25:32"));
                      stmt.addBatch();
                      
                      stmt.setDate(1, Date.valueOf("2005-12-02"));
                      stmt.setTime(2, Time.valueOf("15:02:32"));
                      stmt.setTimestamp(3, Timestamp.valueOf("2005-12-01 12:25:32"));
                      stmt.addBatch();
                      
                      stmt.setDate(1, Date.valueOf("2006-12-02"));
                      stmt.setTime(2, Time.valueOf("16:02:32"));
                      stmt.setTimestamp(3, Timestamp.valueOf("2006-12-01 12:25:32"));
                      stmt.addBatch();
                      
                      stmt.setDate(1, Date.valueOf("2007-12-02"));
                      stmt.setTime(2, Time.valueOf("17:02:32"));
                      stmt.setTimestamp(3, Timestamp.valueOf("2007-12-01 12:25:32"));
                      stmt.addBatch();
                      
                      stmt.executeBatch();
                      stmt.close();
                      
          */

                      
                      }
           catch (ClassNotFoundException e) {
                          e.printStackTrace();
                      }
           catch (BatchUpdateException e) {
                          e.printStackTrace();
                      }
           catch (SQLException e) {
                          e.printStackTrace();
                          
          try {
                              
          if(con != null{
                                  con.rollback();
                                  con.setAutoCommit(
          true);
                              }

                          }
           catch(SQLException ie) {
                              ie.printStackTrace();
                          }

                      }
           finally {
                          
          try {
                              
          if(stmt != null{
                                  stmt.close();
                                  stmt 
          = null;
                              }

                              
          if(con != null{
                                  con.close();
                                  con 
          = null;
                              }

                          }
           catch (SQLException e) {
                              e.printStackTrace();
                          }

                      }

              }

          }

          /*
          +------------+----------+---------------------+
          | date       | time     | datetime            |
          +------------+----------+---------------------+
          | 2007-10-16 | 01:01:17 | 2007-10-16 01:01:17 |
          | 2007-10-17 | 01:02:22 | 2006-05-12 00:00:00 |
          | 2007-12-19 | 00:13:04 | 2007-12-19 00:13:04 |
          | 2007-12-22 | 14:13:48 | 2007-12-22 14:13:48 |
          | 2007-12-22 | 14:14:52 | 2007-12-22 14:14:52 |
          | 2007-12-22 | 14:14:52 | 2007-12-22 14:14:52 |
          | 2007-12-22 | 14:14:52 | 2007-12-22 14:14:52 |
          | 2007-12-22 | 14:14:52 | 2007-12-22 14:14:52 |
          | 2007-12-22 | 14:14:52 | 2007-12-22 14:14:52 |
          | 2007-12-22 | 14:14:52 | 2007-12-22 14:14:52 |
          | 2004-12-02 | 14:02:32 | 2004-12-01 12:25:32 |
          | 2005-12-02 | 15:02:32 | 2005-12-01 12:25:32 |
          | 2006-12-02 | 16:02:32 | 2006-12-01 12:25:32 |
          | 2007-12-02 | 17:02:32 | 2007-12-01 12:25:32 |
          +------------+----------+---------------------+
          */

          posted on 2007-12-22 16:13 凌晨風 閱讀(816) 評論(0)  編輯  收藏 所屬分類: Java學習筆記

          <2007年12月>
          2526272829301
          2345678
          9101112131415
          16171819202122
          23242526272829
          303112345

          常用鏈接

          留言簿(11)

          我參與的團隊

          隨筆分類

          隨筆檔案

          文章分類

          文章檔案

          新聞分類

          新聞檔案

          收藏夾

          圍脖

          最新隨筆

          搜索

          •  

          最新評論

          閱讀排行榜

          評論排行榜

          主站蜘蛛池模板: 务川| 芮城县| 云和县| 来凤县| 闸北区| 德惠市| 那曲县| 延寿县| 郯城县| 西峡县| 永寿县| 灌南县| 旌德县| 上蔡县| 丹棱县| 中牟县| 昌乐县| 黎城县| 平潭县| 金寨县| 闵行区| 新竹市| 柳江县| 江山市| 革吉县| 萍乡市| 昌都县| 开封市| 华亭县| 翁牛特旗| 云南省| 浦江县| 惠东县| 丰原市| 缙云县| 高青县| 涟源市| 黄梅县| 株洲市| 泸州市| 成都市|