{"id":22,"date":"2018-06-08T09:51:48","date_gmt":"2018-06-08T01:51:48","guid":{"rendered":"http:\/\/www.maoyunwang.top\/?p=22"},"modified":"2018-06-08T09:51:48","modified_gmt":"2018-06-08T01:51:48","slug":"2018%e5%b9%b46%e6%9c%888%e6%97%a5mybatis%e5%ad%a6%e4%b9%a0%e5%85%a5%e9%97%a8%e8%bd%ac%e8%bd%bd","status":"publish","type":"post","link":"https:\/\/blog.tongyunli.top\/?p=22","title":{"rendered":"2018\u5e746\u67088\u65e5mybatis\u5b66\u4e60(\u5165\u95e8\u8f6c\u8f7d)"},"content":{"rendered":"

MyBatis\u5b66\u4e60\u7b14\u8bb0(\u4e00\uff09\u5165\u95e8<\/a><\/h1>\n
<\/div>\n
\n
\n

\u9996\u5148\u7ed9\u5927\u5bb6\u63a8\u8350\u51e0\u4e2a\u7f51\u9875\uff1a<\/p>\n

http:\/\/blog.csdn.net\/isea533\/article\/category\/2092001<\/a>\u00a0 \u00a0\u00a0\u6ca1\u4e8b\u770b\u770b – MyBatis\u5de5\u5177\uff1awww.mybatis.tk<\/p>\n

http:\/\/www.mybatis.org\/mybatis-3\/zh\/getting-started.html\u00a0<\/a>\u00a0\u5165\u95e8<\/p>\n

http:\/\/www.mybatis.tk\/<\/a><\/p>\n

http:\/\/mbg.cndocs.tk\/<\/a><\/p>\n

\u8fd9\u4e9b\u4e5f\u662f\u6211\u670b\u53cb\u4ecb\u7ecd\u7684\u3002\u521a\u521a\u63a5\u89e6MyBatis\u53ef\u4ee5\u770b\u770b\u3002\u63a5\u4e0b\u6765\u5c31\u5f00\u59cb\u5b66\u4e60mybatis\u4e86\u3002<\/p>\n

MyBatis \u672c\u662fapache\u7684\u4e00\u4e2a\u5f00\u6e90\u9879\u76eeiBatis, 2010\u5e74\u8fd9\u4e2a\u9879\u76ee\u7531apache software foundation \u8fc1\u79fb\u5230\u4e86google code\uff0c\u5e76\u4e14\u6539\u540d\u4e3aMyBatis \u30022013\u5e7411\u6708\u8fc1\u79fb\u5230Github\u3002<\/p>\n

\"\"<\/div><\/p>\n

 <\/p>\n

\u4e00\u3001\u7406\u89e3\u4ec0\u4e48\u662fMyBatis\uff1f<\/h1>\n

MyBatis \u662f\u652f\u6301\u666e\u901a SQL \u67e5\u8be2\uff0c\u5b58\u50a8\u8fc7\u7a0b\u548c\u9ad8\u7ea7\u6620\u5c04\u7684\u4f18\u79c0\u6301\u4e45\u5c42\u6846\u67b6\u3002 MyBatis \u6d88\u9664\u4e86\u51e0\u4e4e\u6240\u6709\u7684 JDBC \u4ee3\u7801\u548c\u53c2\u6570\u7684\u624b\u5de5\u8bbe\u7f6e\u4ee5\u53ca\u5bf9\u7ed3\u679c\u96c6\u7684\u68c0\u7d22\u3002\u00a0MyBatis \u53ef\u4ee5\u4f7f\u7528\u7b80\u5355\u7684XML \u6216\u6ce8\u89e3\u7528\u4e8e\u914d\u7f6e\u548c\u539f\u59cb\u6620\u5c04\uff0c\u5c06\u63a5\u53e3\u548c Java \u7684 POJO\uff08 Plain Old Java Objects\uff0c\u666e\u901a\u7684Java \u5bf9\u8c61\uff09\u6620\u5c04\u6210\u6570\u636e\u5e93\u4e2d\u7684\u8bb0\u5f55.<\/p>\n

1\uff09MyBATIS \u76ee\u524d\u63d0\u4f9b\u4e86\u4e09\u79cd\u8bed\u8a00\u5b9e\u73b0\u7684\u7248\u672c\uff0c\u5305\u62ec\uff1aJava\u3001.NET\u4ee5\u53caRuby\u3002\uff08\u6211\u4e3b\u8981\u5b66\u4e60java\uff0c\u5c31\u8bb2java\u7684\u4f7f\u7528\uff09
\n2\uff09\u5b83\u63d0\u4f9b\u7684\u6301\u4e45\u5c42\u6846\u67b6\u5305\u62ecSQL Maps\u548cData Access Objects\uff08DAO\uff09\u3002
\n3\uff09mybatis\u4e0ehibernate\u7684\u5bf9\u6bd4\uff1f<\/p>\n

mybatis\u63d0\u4f9b\u4e00\u79cd\u201c\u534a\u81ea\u52a8\u5316\u201d\u7684ORM\u5b9e\u73b0\u3002
\n\u8fd9\u91cc\u7684\u201c\u534a\u81ea\u52a8\u5316\u201d\uff0c\u662f\u76f8\u5bf9Hibernate\u7b49\u63d0\u4f9b\u4e86\u5168\u9762\u7684\u6570\u636e\u5e93\u5c01\u88c5\u673a\u5236\u7684\u201c\u5168\u81ea\u52a8\u5316\u201dORM\u5b9e\u73b0\u800c\u8a00\uff0c\u201c\u5168\u81ea\u52a8\u201dORM\u5b9e\u73b0\u4e86POJO\u548c\u6570\u636e\u5e93\u8868\u4e4b\u95f4\u7684\u6620\u5c04\uff0c\u4ee5\u53ca SQL \u7684\u81ea\u52a8\u751f\u6210\u548c\u6267\u884c\u3002<\/p>\n

\u800cmybatis\u7684\u7740\u529b\u70b9\uff0c\u5219\u5728\u4e8ePOJO\u4e0eSQL\u4e4b\u95f4\u7684\u6620\u5c04\u5173\u7cfb\u3002<\/p>\n

 <\/p>\n

\u4e8c\u3001\u7b80\u5355\u4f8b\u5b50\uff08\u5feb\u901f\u5165\u95e8\uff09<\/h1>\n

1\uff09\u9996\u5148\u5efa\u7acb\u9879\u76eejava web<\/strong><\/p>\n

\"\"<\/div><\/p>\n

2\uff09\u5bfc\u5165mybatis\u6240\u9700\u7684jar\u5305<\/strong><\/p>\n

\"\"<\/div><\/p>\n

mybatis\u9700\u8981jar\u5305\uff1amybatis-3.3.0.jar<\/p>\n

mysql\u9a71\u52a8jar\u5305\uff1amysql-connector-java-5.1.15.-bin.jar<\/p>\n

\u65e5\u5fd7\u8bb0\u5f55jar\u5305\uff1alog4j.jar<\/p>\n

3)\u521b\u5efa\u6570\u636e\u5e93\u6570\u636e\uff08mysql\uff09<\/strong><\/p>\n

\"\"<\/div><\/p>\n

 <\/p>\n

4\uff09mysql\u9a71\u52a8\u914d\u7f6e\u6587\u4ef6\uff08\u8fd9\u6837\u53ef\u4ee5\u4f18\u5316\u6027\u80fd\uff09\u00a0<\/strong><\/p>\n

\u6211\u4e2a\u4eba\u559c\u6b22\u628a\u6240\u9700\u8981\u4f7f\u7528\u5230\u7684\u5305\u5148\u5efa\u7acb\u597d\u3002\u914d\u7f6e\u6587\u4ef6\u5148\u521b\u5efa\u597d\u3002<\/p>\n

\"\"<\/div><\/p>\n

\"\"<\/div><\/p>\n

 <\/p>\n

 <\/p>\n

5\uff09\u6dfb\u52a0mybatis\u914d\u7f6e\u6587\u4ef6mybatis.cfg.xml<\/strong><\/p>\n

\"\"<\/div><\/p>\n
\n
\"\u590d\u5236\u4ee3\u7801\"<\/div><\/a><\/span><\/div>\n
 1 <?xml version=\"1.0\" encoding=\"UTF-8\"?>\n 2 <!DOCTYPE configuration PUBLIC \"-\/\/mybatis.org\/\/DTD Config 3.0\/\/EN\" \"http:\/\/mybatis.org\/dtd\/mybatis-3-config.dtd\">\n 3 <configuration>\n 4 \n 5   <!-- \u5f15\u5165\u5916\u90e8\u914d\u7f6e\u6587\u4ef6 -->\n 6   <properties resource=\"mysql.properties\"><\/properties>\n 7    \n 8    <!-- \u914d\u7f6emybatis\u8fd0\u884c\u73af\u5883 -->\n 9      <environments default=\"cybatis\">\n10         <environment id=\"cybatis\">\n11             <!-- type=\"JDBC\" \u4ee3\u8868\u4f7f\u7528JDBC\u7684\u63d0\u4ea4\u548c\u56de\u6eda\u6765\u7ba1\u7406\u4e8b\u52a1 -->\n12             <transactionManager type=\"JDBC\" \/>\n13             \n14             <!-- mybatis\u63d0\u4f9b\u4e863\u79cd\u6570\u636e\u6e90\u7c7b\u578b\uff0c\u5206\u522b\u662f\uff1aPOOLED,UNPOOLED,JNDI -->\n15             <!-- POOLED \u8868\u793a\u652f\u6301JDBC\u6570\u636e\u6e90\u8fde\u63a5\u6c60 -->\n16             <!-- UNPOOLED \u8868\u793a\u4e0d\u652f\u6301\u6570\u636e\u6e90\u8fde\u63a5\u6c60 -->\n17             <!-- JNDI \u8868\u793a\u652f\u6301\u5916\u90e8\u6570\u636e\u6e90\u8fde\u63a5\u6c60 -->\n18             <dataSource type=\"POOLED\">\n19                 <property name=\"driver\" value=\"${jdbc.driver}\" \/>\n20                 <property name=\"url\" value=\"${jdbc.url}\" \/>\n21                 <property name=\"username\" value=\"${jdbc.username}\" \/>\n22                 <property name=\"password\" value=\"${jdbc.password}\" \/>\n23             <\/dataSource>\n24         <\/environment>\n25     <\/environments> \n26     \n27 <\/configuration><\/pre>\n
\"\u590d\u5236\u4ee3\u7801\"<\/div><\/a><\/span><\/div>\n<\/div>\n
 <\/p>\n
 <\/p>\n
6)\u521b\u5efa\u5bf9\u5e94\u7684\u5b9e\u4f53\u5bf9\u8c61<\/strong><\/p>\n
\"\"<\/div><\/p>\n
 <\/p>\n
\u5bf9\u5e94\u7684java\u4ee3\u7801\uff1a<\/p>\n
\"\"<\/div>\u00a0View Code<\/span><\/div>\n
 <\/p>\n
 <\/p>\n
7\uff09\u521b\u5efa\u65b9\u6cd5\u63a5\u53e3UserMapper.java\u548c\u5b9a\u4e49\u64cd\u4f5ct_user\u8868\u7684sql\u6620\u5c04\u6587\u4ef6UserMapper.xml<\/strong><\/p>\n
\"\"<\/div><\/p>\n
\u63d0\u4f9b\u7b80\u5355\u7684\u589e\u5220\u6539\u67e5\u6570\u636e\u4fe1\u606f\u3002<\/p>\n
\n
\"\u590d\u5236\u4ee3\u7801\"<\/div><\/a><\/span><\/div>\n
 1 package com.cy.mybatis.mapper;\n 2 \n 3 import java.util.List;\n 4 \n 5 import com.cy.mybatis.beans.UserBean;\n 6 \n 7 public interface UserMapper {\n 8     \/**\n 9      * \u65b0\u589e\u7528\u6236\n10      * @param user\n11      * @return\n12      * @throws Exception\n13      *\/\n14     public int insertUser(UserBean user) throws Exception;\n15     \/**\n16      * \u4fee\u6539\u7528\u6236\n17      * @param user\n18      * @param id\n19      * @return\n20      * @throws Exception\n21      *\/\n22     public int updateUser (UserBean user,int id) throws Exception;\n23      \/**\n24       * \u522a\u9664\u7528\u6236\n25       * @param id\n26       * @return\n27       * @throws Exception\n28       *\/\n29     public int deleteUser(int id) throws Exception;\n30     \/**\n31      * \u6839\u636eid\u67e5\u8be2\u7528\u6237\u4fe1\u606f\n32      * @param id\n33      * @return\n34      * @throws Exception\n35      *\/\n36     public UserBean selectUserById(int id) throws Exception;\n37      \/**\n38       * \u67e5\u8be2\u6240\u6709\u7684\u7528\u6237\u4fe1\u606f\n39       * @return\n40       * @throws Exception\n41       *\/\n42     public List<UserBean> selectAllUser() throws Exception;\n43 }<\/pre>\n
\"\u590d\u5236\u4ee3\u7801\"<\/div><\/a><\/span><\/div>\n<\/div>\n
 <\/p>\n
\"\"<\/div><\/p>\n
UserMapper.xml<\/p>\n
\n
\"\u590d\u5236\u4ee3\u7801\"<\/div><\/a><\/span><\/div>\n
 1 <?xml version=\"1.0\" encoding=\"UTF-8\"?>\n 2 <!DOCTYPE mapper PUBLIC \"-\/\/mybatis.org\/DTD Mapper 3.0\" \"http:\/\/mybatis.org\/dtd\/mybatis-3-mapper.dtd\">\n 3 <mapper namespace=\"com.cy.mybatis.mapper.UserMapper\">\n 4 <!-- \u81ea\u5b9a\u4e49\u8fd4\u56de\u7ed3\u679c\u96c6 -->\n 5    <resultMap id=\"userMap\" type=\"UserBean\">\n 6         <id property=\"id\" column=\"id\" javaType=\"java.lang.Integer\"><\/id>\n 7         <result property=\"username\" column=\"username\" javaType=\"java.lang.String\"><\/result>\n 8         <result property=\"password\" column=\"password\" javaType=\"java.lang.String\"><\/result>\n 9         <result property=\"account\" column=\"account\" javaType=\"java.lang.Double\"><\/result>\n10     <\/resultMap>\n11 <!-- \u5728\u5404\u79cd\u6807\u7b7e\u4e2d\u7684id\u5c5e\u6027\u5fc5\u987b\u548c\u63a5\u53e3\u4e2d\u7684\u65b9\u6cd5\u540d\u76f8\u540c \uff0c id\u5c5e\u6027\u503c\u5fc5\u987b\u662f\u552f\u4e00\u7684\uff0c\u4e0d\u80fd\u591f\u91cd\u590d\u4f7f\u7528\u3002parameterType\u5c5e\u6027\u6307\u660e\u67e5\u8be2\u65f6\u4f7f\u7528\u7684\u53c2\u6570\u7c7b\u578b\uff0cresultType\u5c5e\u6027\u6307\u660e\u67e5\u8be2\u8fd4\u56de\u7684\u7ed3\u679c\u96c6\u7c7b\u578b-->    \n12 <!-- useGeneratedKeys\uff1a\uff08 \u4ec5 \u5bf9 insert \u6709 \u7528 \uff09 \u8fd9 \u4f1a \u544a \u8bc9 MyBatis \u4f7f \u7528 JDBC \u7684getGeneratedKeys \n13             \u65b9\u6cd5\u6765\u53d6\u51fa\u7531\u6570\u636e\uff08\u6bd4\u5982\uff1a\u50cf MySQL \u548c SQLServer \u8fd9\u6837\u7684\u6570\u636e\u5e93\u7ba1\u7406\u7cfb\u7edf\u7684\u81ea\u52a8\u9012\u589e\u5b57\u6bb5\uff09\u5185\u90e8\u751f\u6210\u7684\u4e3b\u952e\u3002\u9ed8\u8ba4\u503c\uff1a false\u3002 -->    \n14 <!--keyProperty\uff1a \uff08\u4ec5\u5bf9 insert\u6709\u7528\uff09\u6807\u8bb0\u4e00\u4e2a\u5c5e\u6027\uff0c MyBatis \u4f1a\u901a\u8fc7 getGeneratedKeys\u6216\u8005\u901a\u8fc7 insert \u8bed\u53e5\u7684 selectKey \u5b50\u5143\u7d20\u8bbe\u7f6e\u5b83\u7684\u503c\u3002\u9ed8\u8ba4\uff1a\u4e0d\u8bbe\u7f6e\u3002 -->\n15 <!--#{}\u4e2d\u7684\u5185\u5bb9\uff0c\u4e3a\u5360\u4f4d\u7b26\uff0c\u5f53\u53c2\u6570\u4e3a\u67d0\u4e2aJavaBean\u65f6\uff0c\u8868\u793a\u653e\u7f6e\u8be5Bean\u5bf9\u8c61\u7684\u5c5e\u6027\u503c  -->\n16 \n17 \n18     <insert id=\"insertUser\" useGeneratedKeys=\"true\" keyProperty=\"id\">\n19         insert into t_user (username,password,account) values (#{username},#{password},#{account})\n20     <\/insert>\n21     \n22     <update id=\"updateUser\" >\n23       update t_user set username=#{username},password=#{password},account=#{account} where id=#{id}\n24     <\/update>\n25     \n26     <delete id=\"deleteUser\" parameterType=\"int\">\n27      delete from t_user where id=#{id}  \n28     <\/delete>\n29     \n30     <select id=\"selectUserById\" parameterType=\"int\" resultMap=\"userMap\">\n31      select * from t_user where id=#{id}\n32     <\/select>\n33     \n34     <select id=\"selectAllUser\" resultMap=\"userMap\">\n35      select * from t_user\n36     <\/select>\n37     \n38     \n39 <\/mapper><\/pre>\n
\"\u590d\u5236\u4ee3\u7801\"<\/div><\/a><\/span><\/div>\n<\/div>\n
 <\/p>\n
\u8fd9\u65f6\u9700\u8981\u4e3amybatis.cfg.xml\u91cc\u6ce8\u518cUserMapper.xml\u6587\u4ef6\u3002<\/p>\n
\n
\"\u590d\u5236\u4ee3\u7801\"<\/div><\/a><\/span><\/div>\n
 1 <?xml version=\"1.0\" encoding=\"UTF-8\"?>\n 2 <!DOCTYPE configuration PUBLIC \"-\/\/mybatis.org\/\/DTD Config 3.0\/\/EN\" \"http:\/\/mybatis.org\/dtd\/mybatis-3-config.dtd\">\n 3 <configuration>\n 4 \n 5   <!-- \u5f15\u5165\u5916\u90e8\u914d\u7f6e\u6587\u4ef6 -->\n 6   <properties resource=\"mysql.properties\"><\/properties>\n 7   \n 8   \n 9    <!-- \u4e3aJAVA Bean\u8d77\u7c7b\u522b\u540d -->\n10    <typeAliases >\n11         <!-- \u522b\u540d\u65b9\u5f0f1\uff0c\u4e00\u4e2a\u4e00\u4e2a\u7684\u914d\u7f6e type\u4e2d\u653e\u7f6e\u7684\u662f\u7c7b\u7684\u5168\u8def\u5f84\uff0calias\u4e2d\u653e\u7f6e\u7684\u662f\u7c7b\u522b\u540d\n12         <typeAliase type=\"com.cy.mybatis.beans.UserBean\" alias=\"UserBean\"\/> -->\n13         <!-- \u522b\u540d\u65b9\u5f0f2\uff0c\u81ea\u52a8\u626b\u63cf\uff0c\u5c06JAVA\u7c7b\u7684\u7c7b\u540d\u4f5c\u4e3a\u7c7b\u7684\u7c7b\u522b\u540d -->\n14         <package name=\"com.cy.mybatis.beans\"\/>\n15    <\/typeAliases>\n16    \n17    \n18    <!-- \u914d\u7f6emybatis\u8fd0\u884c\u73af\u5883 -->\n19      <environments default=\"cybatis\">\n20         <environment id=\"cybatis\">\n21             <!-- type=\"JDBC\" \u4ee3\u8868\u4f7f\u7528JDBC\u7684\u63d0\u4ea4\u548c\u56de\u6eda\u6765\u7ba1\u7406\u4e8b\u52a1 -->\n22             <transactionManager type=\"JDBC\" \/>\n23             \n24             <!-- mybatis\u63d0\u4f9b\u4e863\u79cd\u6570\u636e\u6e90\u7c7b\u578b\uff0c\u5206\u522b\u662f\uff1aPOOLED,UNPOOLED,JNDI -->\n25             <!-- POOLED \u8868\u793a\u652f\u6301JDBC\u6570\u636e\u6e90\u8fde\u63a5\u6c60 -->\n26             <!-- UNPOOLED \u8868\u793a\u4e0d\u652f\u6301\u6570\u636e\u6e90\u8fde\u63a5\u6c60 -->\n27             <!-- JNDI \u8868\u793a\u652f\u6301\u5916\u90e8\u6570\u636e\u6e90\u8fde\u63a5\u6c60 -->\n28             <dataSource type=\"POOLED\">\n29                 <property name=\"driver\" value=\"${jdbc.driver}\" \/>\n30                 <property name=\"url\" value=\"${jdbc.url}\" \/>\n31                 <property name=\"username\" value=\"${jdbc.username}\" \/>\n32                 <property name=\"password\" value=\"${jdbc.password}\" \/>\n33             <\/dataSource>\n34         <\/environment>\n35     <\/environments> \n36     \n37     \n38     <mappers>\n39         <!-- \u544a\u77e5\u6620\u5c04\u6587\u4ef6\u65b9\u5f0f1\uff0c\u4e00\u4e2a\u4e00\u4e2a\u7684\u914d\u7f6e\n40         <mapper resource=\"com\/cy\/mybatis\/mapper\/UserMapper.xml\"\/>-->\n41         <!-- \u544a\u77e5\u6620\u5c04\u6587\u4ef6\u65b9\u5f0f2\uff0c\u81ea\u52a8\u626b\u63cf\u5305\u5185\u7684Mapper\u63a5\u53e3\u4e0e\u914d\u7f6e\u6587\u4ef6 -->\n42         <package name=\"com\/cy\/mybatis\/mapper\"\/>\n43     <\/mappers>\n44 <\/configuration><\/pre>\n
\"\u590d\u5236\u4ee3\u7801\"<\/div><\/a><\/span><\/div>\n<\/div>\n
 <\/p>\n
 <\/p>\n
8\uff09\u9700\u8981\u5efa\u7acb\u4e00\u4e2a\u5de5\u5177\u7c7b\u6587\u4ef6<\/strong><\/p>\n
\"\"<\/div><\/p>\n
 <\/p>\n
\n
\"\u590d\u5236\u4ee3\u7801\"<\/div><\/a><\/span><\/div>\n
 1 package com.cy.mybatis.tools;\n 2 \n 3 import java.io.Reader;\n 4 \n 5 import org.apache.ibatis.io.Resources;\n 6 import org.apache.ibatis.session.SqlSession;\n 7 import org.apache.ibatis.session.SqlSessionFactory;\n 8 import org.apache.ibatis.session.SqlSessionFactoryBuilder;\n 9 \n10 public class DBTools {\n11     public static SqlSessionFactory sessionFactory;\n12     \n13     static{\n14         try {\n15             \/\/\u4f7f\u7528MyBatis\u63d0\u4f9b\u7684Resources\u7c7b\u52a0\u8f7dmybatis\u7684\u914d\u7f6e\u6587\u4ef6\n16             Reader reader = Resources.getResourceAsReader(\"mybatis.cfg.xml\");\n17             \/\/\u6784\u5efasqlSession\u7684\u5de5\u5382\n18             sessionFactory = new SqlSessionFactoryBuilder().build(reader);\n19         } catch (Exception e) {\n20             e.printStackTrace();\n21         }\n22         \n23     }\n24     \/\/\u521b\u5efa\u80fd\u6267\u884c\u6620\u5c04\u6587\u4ef6\u4e2dsql\u7684sqlSession\n25     public static SqlSession getSession(){\n26         return sessionFactory.openSession();\n27     }\n28     \n29 }<\/pre>\n
\"\u590d\u5236\u4ee3\u7801\"<\/div><\/a><\/span><\/div>\n<\/div>\n
 <\/p>\n
 <\/p>\n
9\uff09\u5199\u4e2a\u6d4b\u8bd5<\/strong><\/p>\n
\"\"<\/div><\/p>\n
\n
\"\u590d\u5236\u4ee3\u7801\"<\/div><\/a><\/span><\/div>\n
 1 package com.cy.mybatis.service;\n 2 \n 3 import java.util.List;\n 4 \n 5 import org.apache.ibatis.session.SqlSession;\n 6 \n 7 import com.cy.mybatis.beans.UserBean;\n 8 import com.cy.mybatis.tools.DBTools;\n 9 import com.cy.mybatis.mapper.UserMapper;\n10 \n11 public class UserService {\n12 \n13    \n14 15      \n16     public static void main(String[] args) {\n17           insertUser();\n18 \/\/        deleteUser();\n19 \/\/        selectUserById();\n20 \/\/        selectAllUser();\n21     }\n22 \n23     \n24     \/**\n25      * \u65b0\u589e\u7528\u6237\n26      *\/\n27     private static void insertUser() {\n28         SqlSession session = DBTools.getSession();\n29         UserMapper mapper = session.getMapper(UserMapper.class);\n30         UserBean user = new UserBean(\"\u61ff\", \"1314520\", 7000.0);\n31         try {\n32             mapper.insertUser(user);\n33             System.out.println(user.toString());\n34              session.commit();\n35         } catch (Exception e) {\n36             e.printStackTrace();\n37             session.rollback();\n38         }\n39     }\n40     \n41     \n42     \/**\n43      * \u5220\u9664\u7528\u6237\n44      *\/\n45     private static void deleteUser(){\n46         SqlSession session=DBTools.getSession();\n47         UserMapper mapper=session.getMapper(UserMapper.class);\n48         try {\n49             mapper.deleteUser(1);\n50             session.commit();\n51         } catch (Exception e) {\n52             e.printStackTrace();\n53             session.rollback();\n54         }\n55     }\n56     \n57     \n58     \/**\n59      * \u6839\u636eid\u67e5\u8be2\u7528\u6237\n60      *\/\n61     private static void selectUserById(){\n62         SqlSession session=DBTools.getSession();\n63         UserMapper mapper=session.getMapper(UserMapper.class);\n64         try {\n65         UserBean user=    mapper.selectUserById(2);\n66         System.out.println(user.toString());\n67             \n68             session.commit();\n69         } catch (Exception e) {\n70             e.printStackTrace();\n71             session.rollback();\n72         }\n73     }\n74     \n75     \/**\n76      * \u67e5\u8be2\u6240\u6709\u7684\u7528\u6237\n77      *\/\n78     private static void selectAllUser(){\n79         SqlSession session=DBTools.getSession();\n80         UserMapper mapper=session.getMapper(UserMapper.class);\n81         try {\n82         List<UserBean> user=mapper.selectAllUser();\n83         System.out.println(user.toString());\n84         session.commit();\n85         } catch (Exception e) {\n86             e.printStackTrace();\n87             session.rollback();\n88         }\n89     }\n90     \n91 \n92 }<\/pre>\n
\"\u590d\u5236\u4ee3\u7801\"<\/div><\/a><\/span><\/div>\n<\/div>\n
 <\/p>\n
\u6d4b\u8bd5\u7ed3\u679c<\/p>\n
\"\"<\/div>insert\u3002<\/p>\n
 <\/p>\n<\/div>\n
\u6bcf\u4ef6\u4e8b\u90fd\u9700\u8981\u575a\u6301\uff01<\/div>\n<\/div>\n
<\/div>\n
<\/div>\n
\u539f\u6587\u5730\u5740:\u00a0http:\/\/www.cnblogs.com\/hellokitty1\/p\/5216025.html<\/div>\n","protected":false},"excerpt":{"rendered":"
MyBatis\u5b66\u4e60\u7b14\u8bb0(\u4e00\uff09\u5165\u95e8 \u9996\u5148\u7ed9\u5927\u5bb6\u63a8\u8350\u51e0\u4e2a\u7f51\u9875\uff1a http:\/\/blog.csdn.net\/isea […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[29,21],"class_list":["post-22","post","type-post","status-publish","format-standard","hentry","tag-mybatis","tag-21"],"_links":{"self":[{"href":"https:\/\/blog.tongyunli.top\/index.php?rest_route=\/wp\/v2\/posts\/22","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.tongyunli.top\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.tongyunli.top\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.tongyunli.top\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.tongyunli.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=22"}],"version-history":[{"count":0,"href":"https:\/\/blog.tongyunli.top\/index.php?rest_route=\/wp\/v2\/posts\/22\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.tongyunli.top\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=22"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.tongyunli.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=22"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.tongyunli.top\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=22"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}