{"id":1947,"date":"2021-01-14T11:35:58","date_gmt":"2021-01-14T03:35:58","guid":{"rendered":"https:\/\/www.yusian.com\/blog\/?p=1947"},"modified":"2021-01-15T17:19:53","modified_gmt":"2021-01-15T09:19:53","slug":"mybatis%e7%9a%84%e7%ae%80%e5%8d%95%e5%85%a5%e9%97%a8","status":"publish","type":"post","link":"https:\/\/www.yusian.com\/blog\/java\/2021\/01\/14\/1135581947.html","title":{"rendered":"MyBatis\u7684\u7b80\u5355\u5165\u95e8"},"content":{"rendered":"

1\u3001\u4ec0\u4e48\u662fMyBatis\uff0c\u89e3\u51b3\u4ec0\u4e48\u95ee\u9898\uff1f<\/h3>\n
    \n
  1. \u5982\u96f7\u8d2f\u8033\u7684SSM<\/strong>\u6846\u67b6\u96c6\u6700\u540e\u7684M<\/code>\u6307\u7684\u5c31\u662fMyBatis<\/code>\uff1b<\/li>\n
  2. \u7b80\u5355\u4e00\u70b9\u8bf4\uff0cMyBatis\u5c31\u662f\u80fd\u8ba9\u4f60\u7528\u6700\u7b80\u5355\u7684\u65b9\u6cd5\u64cd\u4f5c\u6570\u636e\u5e93\uff1b<\/li>\n
  3. \u518d\u6df1\u5165\u4e00\u70b9\u8bb2\uff0cMyBatis\u5c06\u4ee5\u524d\u7684jdbc\u64cd\u4f5c\u8fdb\u884c\u4e86\u518d\u6b21\u5c01\u88c5\uff1b<\/li>\n
  4. \u7b80\u5355\u5230\u4ec0\u4e48\u7a0b\u5ea6\u4e86\u5462\uff1f\u7b80\u5355\u5230\u4e86sql\u8bed\u53e5\u4ece\u4ee3\u7801\u4e2d\u5206\u79bb\u5199\u5230\u914d\u7f6e\u6587\u4ef6\u4e2d\u5c31\u884c\u4e86\uff1b<\/li>\n<\/ol>\n

    2\u3001\u5982\u4f55\u4f7f\u7528MyBatis<\/h3>\n
      \n
    1. \u64cd\u4f5c\u6570\u636e\u5e93\u662f\u5728Dao\u5c42\uff0c\u5373\u5404\u79cdXxxDao\u7684\u63a5\u53e3+\u5b9e\u73b0\u7c7b\uff0cMyBatis\u53ea\u9700\u8981\u6211\u4eec\u5b9a\u4e49\u63a5\u53e3\uff0c\u4ed6\u80fd\u5e2e\u6211\u4eec\u5b9e\u73b0\uff1b<\/li>\n
    2. \u9996\u5148\u8981\u7406\u89e3MyBatis\u7684\u601d\u8def\uff0cSqlSessionFactoryBuilder<\/code>–>SqlSessionFactory<\/code>–>SqlSession<\/code><\/li>\n
    3. \u6709\u4e86SqlSession\uff0c\u901a\u8fc7SqlSession\u7684getMapper\u65b9\u6cd5\u5f97\u5230\u63a5\u53e3\u7684\u4ee3\u7406\u5b9e\u73b0\u7c7b\uff1b<\/li>\n
    4. \u63a5\u53e3\u5b9a\u4e49\u7684\u5404\u79cd\u65b9\u6cd5\u5c31\u90fd\u53ef\u4ee5\u76f4\u63a5\u8c03\u7528\u4e86\uff0c\u5f97\u5230\u6211\u4eec\u60f3\u8981\u7684\u6570\u636e\uff1b<\/li>\n<\/ol>\n

      3\u3001\u4ee3\u7801\u5b9e\u73b0<\/h3>\n

      3.1\u3001xml\u65b9\u5f0f<\/h4>\n
        \n
      1. \u521b\u5efa\u4e00\u4e2aMaven\u9879\u76ee,\u53c2\u8003\u5b98\u65b9\u6587\u6863:https:\/\/mybatis.org\/mybatis-3\/zh\/getting-started.html<\/a>\n
        <?xml version=\"1.0\" encoding=\"UTF-8\"?>\n<project xmlns=\"http:\/\/maven.apache.org\/POM\/4.0.0\"\n        xmlns:xsi=\"http:\/\/www.w3.org\/2001\/XMLSchema-instance\"\n        xsi:schemaLocation=\"http:\/\/maven.apache.org\/POM\/4.0.0 http:\/\/maven.apache.org\/xsd\/maven-4.0.0.xsd\">\n   <modelVersion>4.0.0<\/modelVersion>\n\n   <groupId>com.yusian<\/groupId>\n   <artifactId>sian-batis<\/artifactId>\n   <version>1.0-SNAPSHOT<\/version>\n   <packaging>jar<\/packaging>\n\n   <dependencies>\n       <dependency>\n           <groupId>org.mybatis<\/groupId>\n           <artifactId>mybatis<\/artifactId>\n           <version>3.5.6<\/version>\n       <\/dependency>\n       <dependency>\n           <groupId>mysql<\/groupId>\n           <artifactId>mysql-connector-java<\/artifactId>\n           <version>5.1.49<\/version>\n       <\/dependency>\n\n       <dependency>\n           <groupId>junit<\/groupId>\n           <artifactId>junit<\/artifactId>\n           <version>4.12<\/version>\n           <scope>test<\/scope>\n       <\/dependency>\n   <\/dependencies>\n   <properties>\n       <maven.compiler.source>8<\/maven.compiler.source>\n       <maven.compiler.target>8<\/maven.compiler.target>\n   <\/properties>\n\n<\/project>\n<\/code><\/pre>\n<\/li>\n
      2. \u51c6\u5907\u6570\u636e\u5e93\u53ca\u76f8\u5173\u8868, \u5982:mybatis\u5e93\u4e2d\u6709\u4e00\u4e2atab_user\u8868,\u8be5\u8868\u53ea\u6709id,username,password\u4e09\u4e2a\u5b57\u6bb5<\/p>\n<\/li>\n
      3. \n
        \u51c6\u5907\u5b9e\u4f53\u7c7bUser<\/p>\n
        package com.yusian.domain;\n\nimport java.io.Serializable;\n\npublic class User implements Serializable {\n   private Integer id;\n   private String username;\n   private String password;\n\n   public Integer getId() {\n       return id;\n   }\n\n   public void setId(Integer id) {\n       this.id = id;\n   }\n\n   public String getUsername() {\n       return username;\n   }\n\n   public void setUsername(String username) {\n       this.username = username;\n   }\n\n   public String getPassword() {\n       return password;\n   }\n\n   public void setPassword(String password) {\n       this.password = password;\n   }\n\n   @Override\n   public String toString() {\n       return \"User{\" +\n               \"id='\" + id + '\\'' +\n               \", username='\" + username + '\\'' +\n               \", password='\" + password + '\\'' +\n               '}';\n   }\n}\n\n<\/code><\/pre>\n<\/li>\n
      4. \u51c6\u5907\u63a5\u53e3UserDao,\u63a5\u53e3\u4e2d\u6709\u4e00\u4e2afindAll\u7684\u65b9\u6cd5\u67e5\u8be2\u6240\u6709\u7528\u6237\u6570\u636e\n
        package com.yusian.dao;\n\nimport com.yusian.domain.User;\nimport org.apache.ibatis.annotations.Select;\n\nimport java.util.List;\n\npublic interface UserDao {\n   \/**\n    * \u83b7\u53d6\u6240\u6709\u7528\u6237\u5217\u8868\n    * @return\n    *\/\n   List<User> findAll();\n}\n\n<\/code><\/pre>\n<\/li>\n
      5. \u5728Resources\u7684\u6839\u76ee\u5f55\u4e0b\u521b\u5efaSqlMapConfig.xml\u6587\u4ef6\n
        <?xml version=\"1.0\" encoding=\"UTF-8\" ?>\n<!DOCTYPE configuration\n       PUBLIC \"-\/\/mybatis.org\/\/DTD Config 3.0\/\/EN\"\n       \"http:\/\/mybatis.org\/dtd\/mybatis-3-config.dtd\">\n<configuration>\n   <environments default=\"development\">\n       <environment id=\"development\">\n           <transactionManager type=\"JDBC\"\/>\n           <dataSource type=\"POOLED\">\n               <property name=\"driver\" value=\"com.mysql.jdbc.Driver\"\/>\n               <property name=\"url\" value=\"jdbc:mysql:\/\/\u6570\u636e\u5e93\u5730\u5740:3306\/mybatis?useSSL=false\"\/>\n               <property name=\"username\" value=\"root\"\/>\n               <property name=\"password\" value=\"******\"\/>\n           <\/dataSource>\n       <\/environment>\n   <\/environments>\n   <!--\u6307\u5b9a\u6620\u5c04\u914d\u7f6e\u6587\u4ef6\u7684\u4f4d\u7f6e-->\n   <mappers>\n       <mapper resource=\"com\/yusian\/dao\/UserDao.xml\"\/>\n   <\/mappers>\n<\/configuration>\n<\/code><\/pre>\n<\/li>\n
      6. \u5728Resources\u76ee\u5f55\u4e0b\u521b\u5efacom\/yusian\/dao\u4e09\u5c42\u76ee\u5f55,\u518d\u521b\u5efaUserDao.xml\u6587\u4ef6\n
        <?xml version=\"1.0\" encoding=\"UTF-8\" ?>\n<!DOCTYPE mapper\n       PUBLIC \"-\/\/mybatis.org\/\/DTD Mapper 3.0\/\/EN\"\n       \"http:\/\/mybatis.org\/dtd\/mybatis-3-mapper.dtd\">\n<mapper namespace=\"com.yusian.dao.UserDao\">\n   <select id=\"findAll\" resultType=\"com.yusian.domain.User\">\n       select * from tab_user\n   <\/select>\n<\/mapper>\n<\/code><\/pre>\n<\/li>\n
      7. \u6d4b\u8bd5\n
        public class MyBatisTest {\n   public static void main(String[] args) throws Exception{\n       \/\/ 1\u3001\u521b\u5efaSqlSessionFactoryBuilder\n       SqlSessionFactoryBuilder builder = new SqlSessionFactoryBuilder();\n       \/\/ 2\u3001\u52a0\u8f7d\u914d\u7f6e\u6587\u4ef6\u751f\u6210SqlSessionFactory\u5bf9\u8c61\n       InputStream is = Resources.getResourceAsStream(\"SqlMapConfig.xml\");\n       SqlSessionFactory factory = builder.build(is);\n       \/\/ 3\u3001factory\u751f\u6210SqlSession\u5bf9\u8c61\n       SqlSession sqlSession = factory.openSession();\n       \/\/ 4\u3001SqlSession\u751f\u6210\u4ee3\u7406\u5b9e\u73b0\u7c7b\n       UserDao userDao = sqlSession.getMapper(UserDao.class);\n       \/\/ 5\u3001\u64cd\u4f5c\u6570\u636e\u5e93\u83b7\u53d6\u6570\u636e\n       List<User> users = userDao.findAll();\n       for (User user : users) {\n           System.out.println(user);\n       }\n       \/\/ 6\u3001\u91ca\u653e\u8d44\u6e90\n       is.close();\n       sqlSession.close();\n   }\n}\n<\/code><\/pre>\n<\/li>\n<\/ol>\n
        3.2\u3001\u6ce8\u89e3\u65b9\u5f0f<\/h4>\n
        \u6ce8\u89e3\u7684\u65b9\u5f0f\u4e0exml\u7684\u533a\u522b\u5728\u4e8e:<\/p>\n
          \n
        1. \u5220\u9664xml\u6587\u4ef6,\u5426\u5219\u4f1a\u6709\u5e72\u6270,MyBais\u4f1a\u4f18\u5148\u52a0\u8f7dxml\u6587\u4ef6;<\/p>\n<\/li>\n
        2. \n
          SqlMapConfig.xml\u6587\u4ef6\u4e2d\u6700\u540e\u9762\u7684<mapper><\/code>\u6807\u7b7e\u4e2dresource\u5c5e\u6027\u6539\u6210class\u5c5e\u6027<\/p>\n
          <?xml version=\"1.0\" encoding=\"UTF-8\" ?>\n<!DOCTYPE configuration\n       PUBLIC \"-\/\/mybatis.org\/\/DTD Config 3.0\/\/EN\"\n       \"http:\/\/mybatis.org\/dtd\/mybatis-3-config.dtd\">\n<configuration>\n   <environments default=\"development\">\n       <environment id=\"development\">\n           <transactionManager type=\"JDBC\"\/>\n           <dataSource type=\"POOLED\">\n               <property name=\"driver\" value=\"com.mysql.jdbc.Driver\"\/>\n               <property name=\"url\" value=\"jdbc:mysql:\/\/\u6570\u636e\u5e93\u5730\u5740:3306\/mybatis?useSSL=false\"\/>\n               <property name=\"username\" value=\"root\"\/>\n               <property name=\"password\" value=\"******\"\/>\n           <\/dataSource>\n       <\/environment>\n   <\/environments>\n   <!--\u6307\u5b9a\u6620\u5c04\u914d\u7f6e\u6587\u4ef6\u7684\u4f4d\u7f6e-->\n   <mappers>\n       <mapper class=\"com.yusian.dao.UserDao\"\/>\n   <\/mappers>\n<\/configuration>\n<\/code><\/pre>\n<\/li>\n
        3. \u63a5\u53e3\u7c7b\u4e2d\u65b9\u6cd5\u4e0a\u6dfb\u52a0Select\u6ce8\u91ca,\u6ce8\u91ca\u5c5e\u6027\u4e3asql\u8bed\u53e5\n
          package com.yusian.dao;\n\nimport com.yusian.domain.User;\nimport org.apache.ibatis.annotations.Select;\n\nimport java.util.List;\n\npublic interface UserDao {\n   \/**\n    * \u83b7\u53d6\u6240\u6709\u7528\u6237\u5217\u8868\n    * @return\n    *\/\n   @Select(\"select * from tab_user\")\n   List<User> findAll();\n}\n\n<\/code><\/pre>\n<\/li>\n
        4. \n
          \u5176\u4ed6\u90fd\u4e00\u6837,\u6ca1\u6709\u533a\u522b<\/p>\n<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"
          1\u3001\u4ec0\u4e48\u662fMyBatis\uff0c\u89e3\u51b3\u4ec0\u4e48\u95ee\u9898\uff1f \u5982\u96f7\u8d2f\u8033\u7684SSM\u6846\u67b6\u96c6\u6700\u540e\u7684M\u6307\u7684\u5c31\u662fMyBatis\uff1b \u7b80\u5355\u4e00\u70b9\u8bf4\uff0cMyBatis\u5c31\u662f\u80fd\u8ba9\u4f60\u7528\u6700\u7b80\u5355\u7684\u65b9\u6cd5\u64cd\u4f5c\u6570\u636e\u5e93\uff1b \u518d\u6df1\u5165\u4e00\u70b9\u8bb2\uff0cMyBatis\u5c06\u4ee5\u524d\u7684jdbc\u64cd\u4f5c\u8fdb\u884c\u4e86\u518d\u6b21\u5c01\u88c5\uff1b \u7b80\u5355\u5230\u4ec0\u4e48\u7a0b\u5ea6\u4e86\u5462\uff1f\u7b80\u5355\u5230\u4e86sql\u8bed\u53e5\u4ece\u4ee3\u7801\u4e2d\u5206\u79bb\u5199\u5230\u914d\u7f6e\u6587\u4ef6\u4e2d\u5c31\u884c\u4e86\uff1b 2\u3001\u5982\u4f55\u4f7f\u7528MyBatis \u64cd\u4f5c\u6570\u636e\u5e93\u662f\u5728Dao\u5c42\uff0c\u5373\u5404\u79cdXxxDao\u7684\u63a5\u53e3+\u5b9e\u73b0\u7c7b\uff0cMyBatis\u53ea\u9700\u8981\u6211\u4eec\u5b9a\u4e49\u63a5\u53e3\uff0c\u4ed6\u80fd\u5e2e\u6211\u4eec\u5b9e\u73b0\uff1b \u9996\u5148\u8981\u7406\u89e3MyBatis\u7684\u601d\u8def\uff0cSqlSessionFactoryBuilder–>SqlSessionFactory–>SqlSession \u6709\u4e86SqlSession\uff0c\u901a\u8fc7SqlSession\u7684getMapper\u65b9\u6cd5\u5f97\u5230\u63a5\u53e3\u7684\u4ee3\u7406\u5b9e\u73b0\u7c7b\uff1b \u63a5\u53e3\u5b9a\u4e49\u7684\u5404\u79cd\u65b9\u6cd5\u5c31\u90fd\u53ef\u4ee5\u76f4\u63a5\u8c03\u7528\u4e86\uff0c\u5f97\u5230\u6211\u4eec\u60f3\u8981\u7684\u6570\u636e\uff1b 3\u3001\u4ee3\u7801\u5b9e\u73b0 3.1\u3001xml\u65b9\u5f0f \u521b\u5efa\u4e00\u4e2aMaven\u9879\u76ee,\u53c2\u8003\u5b98\u65b9\u6587\u6863:https:\/\/mybatis.org\/mybatis-3\/zh\/getting-started.html <?xml version=”1.0″ encoding=”UTF-8″?> <project xmlns=”http:\/\/maven.apache.org\/POM\/4.0.0″ xmlns:xsi=”http:\/\/www.w3.org\/2001\/XMLSchema-instance” xsi:schemaLocation=”http:\/\/maven.apache.org\/POM\/4.0.0 http:\/\/maven.apache.org\/xsd\/maven-4.0.0.xsd”> <modelVersion>4.0.0<\/modelVersion> <groupId>com.yusian<\/groupId> <artifactId>sian-batis<\/artifactId> <version>1.0-SNAPSHOT<\/version> <packaging>jar<\/packaging> <dependencies> <dependency> <groupId>org.mybatis<\/groupId> <artifactId>mybatis<\/artifactId> <version>3.5.6<\/version> <\/dependency> <dependency> <groupId>mysql<\/groupId> <artifactId>mysql-connector-java<\/artifactId> <version>5.1.49<\/version> <\/dependency> <dependency> <groupId>junit<\/groupId> <artifactId>junit<\/artifactId> <version>4.12<\/version> <scope>test<\/scope> <\/dependency> <\/dependencies> <properties> <maven.compiler.source>8<\/maven.compiler.source> <maven.compiler.target>8<\/maven.compiler.target> <\/properties> <\/project> \u51c6\u5907\u6570\u636e\u5e93\u53ca\u76f8\u5173\u8868, \u5982:mybatis\u5e93\u4e2d\u6709\u4e00\u4e2atab_user\u8868,\u8be5\u8868\u53ea\u6709id,username,password\u4e09\u4e2a\u5b57\u6bb5 \u51c6\u5907\u5b9e\u4f53\u7c7bUser package com.yusian.domain; import […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[35],"tags":[344],"class_list":["post-1947","post","type-post","status-publish","format-standard","hentry","category-java","tag-mybatis"],"_links":{"self":[{"href":"https:\/\/www.yusian.com\/blog\/wp-json\/wp\/v2\/posts\/1947","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.yusian.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.yusian.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.yusian.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.yusian.com\/blog\/wp-json\/wp\/v2\/comments?post=1947"}],"version-history":[{"count":0,"href":"https:\/\/www.yusian.com\/blog\/wp-json\/wp\/v2\/posts\/1947\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.yusian.com\/blog\/wp-json\/wp\/v2\/media?parent=1947"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.yusian.com\/blog\/wp-json\/wp\/v2\/categories?post=1947"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.yusian.com\/blog\/wp-json\/wp\/v2\/tags?post=1947"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}