SLF4J: This version of SLF4J requires log4j version 1.2.12 or later. See also http://www.slf4j.org/codes.html#log4j_version
0 DEBUG [main] org.apache.ibatis.logging.LogFactory - Logging initialized using 'class org.apache.ibatis.logging.slf4j.Slf4jImpl' adapter.
31 DEBUG [main] org.apache.ibatis.datasource.pooled.PooledDataSource - PooledDataSource forcefully closed/removed all connections.
31 DEBUG [main] org.apache.ibatis.datasource.pooled.PooledDataSource - PooledDataSource forcefully closed/removed all connections.
31 DEBUG [main] org.apache.ibatis.datasource.pooled.PooledDataSource - PooledDataSource forcefully closed/removed all connections.
31 DEBUG [main] org.apache.ibatis.datasource.pooled.PooledDataSource - PooledDataSource forcefully closed/removed all connections.
140 DEBUG [main] org.apache.ibatis.transaction.jdbc.JdbcTransaction - Opening JDBC Connection
483 DEBUG [main] org.apache.ibatis.datasource.pooled.PooledDataSource - Created connection 6259058.
483 DEBUG [main] com.te.mybatis.persitence.ifance.PersonDao.insertperson - ooo Using Connection [com.mysql.jdbc.JDBC4Connection@5f8172]
483 DEBUG [main] com.te.mybatis.persitence.ifance.PersonDao.insertperson - ==> Preparing: insert into person(username) values('tomcat23')
530 DEBUG [main] com.te.mybatis.persitence.ifance.PersonDao.insertperson - ==> Parameters:
530 DEBUG [main] org.apache.ibatis.transaction.jdbc.JdbcTransaction - Rolling back JDBC Connection [com.mysql.jdbc.JDBC4Connection@5f8172]561 DEBUG [main] org.apache.ibatis.transaction.jdbc.JdbcTransaction - Resetting autocommit to true on JDBC Connection [com.mysql.jdbc.JDBC4Connection@5f8172]
561 DEBUG [main] org.apache.ibatis.transaction.jdbc.JdbcTransaction - Closing JDBC Connection [com.mysql.jdbc.JDBC4Connection@5f8172]
561 DEBUG [main] org.apache.ibatis.datasource.pooled.PooledDataSource - Returned connection 6259058 to pool.
运行插入语句始终不能成功,但是一直没有注意这个语句
530 DEBUG [main] org.apache.ibatis.transaction.jdbc.JdbcTransaction - Rolling back JDBC Connection [com.mysql.jdbc.JDBC4Connection@5f8172]
想一想在insert里面也没有用到事务啊,不知道是什么原因?
在执行语句出添加事务提交 就可以插入成功 ,
SqlSession sqlsesstion = sc.openSession();
sqlsesstion.insert("insertperson", person);
sqlsesstion.commit(); //还不知道是什么原因要提交事务才可以插入数据成功,但是每一次似乎都对数据库产生了影响
sqlsesstion.close();
![](data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAVoAAADjCAIAAABLgUsoAAAP2ElEQVR4nO2dS5bjOA5FvZAa9v7X4A3VHnqQbrdSAEEQ4Fe+99RAFogPHyFERoQd9XoBAAAALON9YXUt/2doVQs3+/6bJTUAFLG7c1XXPnIcvAXzawCoY3Tn8q+lp4TdNi8cz7VvZBuV7thf5P+Y1DV2p4b72FlVYBKFI78FTXtxlueMcLtvFGbfv1201hNQMlNza2Tndh7LTQhDstv66qmUJK7qHjiY1qr8STORPXntHdm1GY6l1LbVrrnq21qVvcCft29kz3aezFWFkpp+a+ml6uIpqan+vlXZvp7ImQ57X4h5yQh2TM8G1Qt/VZmXRs2lO5m8Roonox65YS1JY/vaNz3R7JUjqvKo4anNXlPykrRGMCI7vdT9yotAPbaS0mrXnNyRsb5087E0CfQWlFaqd0o3A2vkeqMqY0G11JLviI2Ussd8W+uxT/B7LS8C9cjIYZ1Ljv4dGet/jrBA1WNTfZ2n6yrdXZXRMdVSS76eOsN7aU3kzGuHsk/wey0vAvX4z6hp+1Vfv/VHUQ/GeBnzVV3sYgL1V6tqymv7evYba698nNJ6j/jV05cXznrsyLbOduTSHeeOnLl+gpsEbw3DKkPFfGUlrVvwVzXHKhcEthajlK5ahrGj70t54awnpmSm5tbIai7/Np+AoaBtVTUyfD3HltxFtarSYTsXtOb1LBiBXa3H1zggeeGvJ6BkpubWyGqEyWe3NRkt0BH+cHonHF18TxgHkOfoTji38g68BclQ3SqDY6ETTqXXLHjRBPA/6AQAAAAAAAAAAAAAGAQ/gu4FSvYCJZeB9L1AyV6g5DKQvhco2YsfUlK+3ch+V+IgqzTtUNWJVmmqLlhe855WaZLuT8Ojgrp+svRLqjrRKk3VBctr3tMqTdIdxoLivUDJXqDkMpC+FyjZC5RcBtL3AiV7gZIAAAAAAAAAAAAAAAAAAAAAAAAAAFPgbZsA8ME5DgJTg0HTC5RUoSeXgfQLQUkVenIZSL8QlFShJ3vyvmAveM2SXrqU7pSCl6y3jdzWSKsR1o780v43wVWpbTJKBnbkqbmqRvVOVUljzXtiT/4K/vM2llXjJ11ud+ySDKu6nfff42BE5GrNMVmcLrEdZaylxX7f1gUBWZpcfgtVoJvW06S3m8ljrb5US2rdr1qVvAhErqZrcknuaJC1+lKtc5WSv4UqkH2omcitLv4OGOf7+rtT1b5ULzyRPXRX8uXYka1VVcmAGs7Ixp0qAZffQhXooCY2THYj+vM6I8uLqq+TLi5NVdkFVx3VC2dVsR05Cbj8FqpAq6RvynvrRdmjvVrNaZUX1aqcdFcyo7NtbT0F2+rfkZOAy2+hClQ643xkj0spr6eZ7K71lxpoYnlRrcrJEiUzVkmsKv+OnOTP4rGUzqxknSO9nbe1ZmcxpVBGSW/fOKjW7CHgZRRc3VG1Zo+j+tLjG96UX5Yml1+hquz1/kzp7bx2K5SsdjHV9UYjylJba66SEb+U19iRp2bDKuM4fT3bvDpmZIHZIH0v6PteIAv8IvQ9AHxgHADAB8YBAAAAAAAAAAAAABwHP9zuBUr2AiWXgfS9QMleoOQykL4XKNmLH1JSfizkLVDX97VK0w5VnWiVpuqC5TXvaZUm6f40PCqo6ydLv6SqE63SVF2wvOY9rdIk3WEsKN4LlOwFSi4D6XuBkr1AyWUgfS9QshcoCQAAAAAAAAAAAAAAAAAAAAAAAAAAALAPmfd4h333fGP5wqoGnYL9Ud9HfhD4YduZR74bGAdrU/ufdrnGtp7Lk/YyFcbBjSeNg9v9ppdH85iNrGH+OKh+XSqZvneuF05fmbe1qqFMOAV72WOeosdsZA27jQPDKk3VBV3yTmD0Kdibmr/fcTxpLwsY3YhNjreuVV+qF1VfTw0LO2noKRhSLJl9Q3nYdmaz4Tgo3fGMg2rSG56qJjDuFOwHviTFuTxpLwv4kXGgzoLHjwPno/6kifCYjazhp8ZB651pjDiFpof8MU/RYzayhg3Hwe0JbxoHVV+jhieNA3sW2FodzWM2soaF40DtwrdAplPHgcfXWGBXNZrup1Ddry3FuTxpLwvo3ohNvtVWVtPJi9awralH0/0U1M36tTqXh23nJJC+FyjZC5QEAAAAAAAAAAAAAADowL///Mfz3+oyAWAwnuf8zy9pw6Mh8Dve0pthYtZkMfuAkr04uvghOB9s9S1rTf92CDfx1YsmfqFkP44uvj/Or/C3ZpK99Y1mBKSJe4GSvTi6+P6EfxZQ0tGYCJkmVluTJm51QckbRxffn9g4uDWWjKmGpYl7gZK9OLr4/gTGgT0LjLDhJlYv1IA0cdUFJa8cXXx/Yr8d8CgoI9PEvUDJXhxdfGfGzQI1eKaJr9lpYpTsxdHFd6ZpHDTNAjU4TdwLlOzF0cV3xj8OWmeBGj/ZxLIMz0tn5LNAyV4cXXxnAuPgRlOK7k2sFuasObyjHUDJXhxU6lhi3ym0Hvn1l475Jjbu2PdpYpRUOajUsUz7MFJmHIAKSvYCJV+vibNgSToAaGD+88lEANgUxgEAfFgyDpgIADuy5MlkHADsCOMAAD4wDgDgQ/LPHMR+VfvvP/+JOa765XB1v2sL6+jleSuRoUbGt2odCu87eL1yf+YgfHJnjYNMf8+pLeN1i6A+z/YCGbmXb+u+Mqw6wb1Qx0H1zxzemqlVx4PGQXW/q9r3mj3jpW7HdvSfvrG46eUEGAevV/s4kEwbB2+BsUCt8HrR6mvcKd2cQCyvfPCcAZvSVSMbZbTmysM4eL3S4yAm4ohxYFilqbrgZpKJ1Npad5Qnltd4Dj0ihwvz5FVfTmDVCe5FeBxkDqz7Nwt2M32v5UXSt1rYaAJ51efw9vKGXGyfftVkaFhKPZpVJ7gX+XEQEHHQOCjduTVxyWpnVH2rhY0mkFd96kpBblano33f8L3enyzpqhPciy7fLLTqeOI4sGtY1UyBvOoj7VTgtth+qkt5bV87yDhWneBeHPSjRCOX/dB+r+WFEdMTuVrYaPJ5qxFsrVrHgT8142ABz/hFo12VZxzEXlYLG00+7y3CODW6RB7HqhPci8C/Dt6C1oxh6Y28RlXfl/LCsyPPflc1Uz5v634zauQjj2PVCe5F7JuFzJllxoGd2u4z9cITtmpVA84hn7dJSY/VrioZeRyrTnAv5F8fGP35ouQ4gCso2QuU/HCbCBPGwdD4AJCCcQAAHxgHAPDh+v0C4wDg12EcAMAdxgEAfGAcAMCH6v9JMfkb2vy7EsOpwzzyzTMj3izkjFmKcKiST+b7uHrGQUDE48aBv4PnlxfL6Dnf2H6N3pCO1QWt+8owP+MZMA5kxtt+nS+nlRfzUn2T+zV6wy71UCWfT9M3CwERw+PgLTAWqAVfL1p9jTt+a3cy6Zy+Tfs1emMr3TYsYFMOHQeGVZqqC24mmciusHVrYTLpPL72jmxx/CI7ixnK8gI2xR4H1afFEz8sfcnx1mHqS/Ui6WvUMIdMxqqvsSPVZPfGW0MuXiKjrBY+eMaBca6e+GHp7e4s3bm1WslqZ1R9b8vOamLPxksL1KNv6o2b1e84iCXHdwCMA3/k650lzZTJ639W7Qhv85F2alsK5d9OklUnuDvVnx1cCYj4sHEwv3GNYrr4Nu3IWFkNYp8C42A917cMHjcO3uaXGvXC6et8OZ9MdtXX3lHT9m+mzYVde46bcsQ4UHvlLZBFyouqryey7T6UTDrVt7oj/2ablGyKPIL5GQ9g83Hw+rtpnKbvHXnhCVuNvLCP80qqN+0dOXfadEZNkUewJOnuTPh8EX8rsSMo2QuUvDPns4Z8ohHgABgHAPCBcQAAH+b84GB0CgDIIv//K4OyjE4BAFn4TgEAPjAOAOCDfFCN38SG3y7yJ0v4d7yrfjn8yDfPhM/XsDpjliJUIxu+SVa11qbI9yN6uqFVxBPHgb+D55cXy5g5X49VrU06VhfYeftKPf/stsY5Dm73Ww/muHFg7zepRq/yYl6B863uV1qdpbYq2V3n+a21L+qvFYx2ySQKB3kLjAXy/u2i1de447d2J5PO6du0X/lIx+JkSoox+eC2Rv0Jn/HIJRPFgrwFTqs0VRfcTDKRUWHrvjJkMnp8VamNCNc7fpGdxbSubGL+2e1LYBzYjWInCktfcrwVo75UL5K+pQKmkUla9TU2pZpud9SXN+RiW8lxIi85vk1pHQelQ3UmCktvd2fpzq3VSlY7o+p7Wza/pTIZPRu3H8vbArU3qhEM39aaM8w/u30JjAP1pTNLWHp/l8gi1YtqMXZkdfHMrsqky2+k1Aw3PAU4+2qcvJMPbmsyPzvw6/j4cVC1dieTzhbTGdZYWQ1inwLjYBnP+NdBqarvtbxw+sZeTiCTznO+ttWz2OnrjDxO3skHtzX+cfC6HFVr9/caB2peo6rvS3nh2VHGOppMRtVXbqdJKzt+XslxCs8/u33xv+/gampVMD8O7NR2n6kXnrBJ61DySqo3JaU1mfglFyPyOJGXHN++zPx0M9L3AiV7gZJ/wR87AIAPjAMA+MA4AIAPf36aOPRPpDEOAM5jxHPLLAA4lb7/TGAWABzP9TuI8IBgFgA8k8CzzTgAeCyt/0xoer8jNIGSvUDJFP5vIhgH40DJXqBkT9ShUBoWSN8LlOzFDykpPxbyFqjrW63yR4920jlVPc8qTdUFy2ve0ypN0v1peFRQ10+WfklVJ1qlqbpgec17WqVJusNYULwXKNkLlFwG0vcCJXuBkstA+l6gZC9QEgAAAAAAAAAAAAAAAAAAAAAAAADgh3nkm0kfualWEGEST/rY5oYbSZZkuGc+cmv77vlh3t3qeSYbHvyTyGjrnAWtKWzfTOTR7FYPQBvJcWDE/FqbnlvbNxN5DlsV8+t8m8P55UX1rd4JtKDhKGtuilytqpo6tiljvUdJf9jrnUzk6/qAVlVrrB5oI3zY6uFVTTKax7epME/NscilLcSsnrxOkz+47ZuJ/JqiVauM0Eb4vA2r8bKUOtmIhotdVWvA6gbzu6g6fk3ywh9W9e0SWb1ja+U/o7Ce4MKQvnWxpyHUi9Yy7PKaqvIEjO23NVc1uDSpSjrDGqeQiRzTKlA/jKLXYTiPvNRqb0HDHsrl2VU5Y6pVSVMyl9Mxk8V5RoHIr4RWmfqhM70Ow9NqRsdIx9aDV12SLW5U5dlRMpfTlDlBuaNYZDWRU6tM/dATtYntxc5QyYYIHLzqkols+3qkC7ev4Wjr7AlbPaNw5NIdO5Q/b1hPcNGkr7P7r0iT+tL2dRZm5G3ahTOyp+bkjmJV2RGSO6rWHIvszNtaErTRsUeva9SVsgP8vv6kN/dS58WCt1o9C4y84ape5jaTOwpXlc8bKAngCcQeyAeDIPDT8AB8QQoAHoPXCxEAAAAAAAAAAAAAAAAAAAAAAAAAAM7iv51k78SRFuecAAAAAElFTkSuQmCC)
有一点乱 !!!