Personal Technology Blog

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE generatorConfiguration
  PUBLIC "-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN"
  "http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd">
<!--
详细说明请看：http://blog.csdn.net/tiantangpw/article/details/51690534
-->
<generatorConfiguration>

  <context id="mysqlgenerator" targetRuntime="MyBatis3">
    <!--数据库配置-->
    <jdbcConnection connectionURL="jdbc:mysql://127.0.0.1:3306/booksystem"
      driverClass="com.mysql.jdbc.Driver"
      password="hisen"
      userId="root"/>
      
    <!--生成Model(实体类，与数据库字段对应的bean)类存放位置-->
    <javaModelGenerator targetPackage="com.hisen.entity" targetProject="src/main/java">
      <property name="enableSubPackages" value="true"/>
      <property name="trimStrings" value="true"/>
    </javaModelGenerator>
    <!--生成映射(xxxmapper.xml)文件存放位置-->
    <sqlMapGenerator targetPackage="mapper" targetProject="src/main/resources">
      <property name="enableSubPackages" value="true"/>
    </sqlMapGenerator>
    <!--生成Dao类存放位置-->
    <javaClientGenerator type="XMLMAPPER" targetPackage="com.hisen.dao"
      targetProject="src/main/java">
      <property name="enableSubPackages" value="true"/>
    </javaClientGenerator>
    
    <!--要生成的表-->
    <table tableName="appointment"/>
    <table tableName="user"/>
  </context>

</generatorConfiguration>

org.apache.ibatis.binding.BindingException: Invalid bound statement (not found): com.hisen.dao.UserMapper.insert

No MyBatis mapper was found in '[com.hisen.dao]' package

├── java
│   └── com
│       └── hisen
│           ├── dao
│           │   └── BookDao.java
│           │   └── BookMapper.xml
│           ├── entity
│           │   └── Book.java
│           ├── service
│           │   ├── BookService.java
│           │   └── impl
│           │       └── BookServiceImpl.java
│           └── web
│               └── BookController.java
├── resources
│   ├── jdbc.properties
│   ├── logback.xml
│   ├── mybatis-config.xml
│   └── spring
│       ├── spring-dao.xml
│       ├── spring-service.xml
│       └── spring-web.xml
└── webapp
    ├── index.jsp
    └── WEB-INF
        ├── jsp
        │   ├── detail.jsp
        │   └── list.jsp
        └── web.xml

update 表名 set 字段名=字段值 where 条件
如 update A set name='xiaoming' where id='';
如果是多表查询
update 表1 a inner join 表2 b on  ab表的关联 set a.字段=b.字段
如 update A a inner join B b on a.id=b.id set a.name=b.name
就是在table1表和table2表id相同时 把table2的name值赋给table1的name

hisen@ubuntu:~$ mongo
MongoDB shell version: 3.2.13
connecting to: test
2017-07-11T23:11:23.827+0800 I STORAGE  [main] In File::open(), ::open for '/home/hisen/.mongorc.js' failed with errno:13 Permission denied
The ".mongorc.js" file located in your home folder could not be executed

hisen@ubuntu:~$ sudo chown -R hisen /home/hisen/.mongorc.js
hisen@ubuntu:~$ mongo
MongoDB shell version: 3.2.13
connecting to: test
Server has startup warnings: 
2017-07-11T23:11:15.845+0800 I CONTROL  [initandlisten] 
2017-07-11T23:11:15.845+0800 I CONTROL  [initandlisten] ** WARNING: /sys/kernel/mm/transparent_hugepage/enabled is 'always'.
2017-07-11T23:11:15.845+0800 I CONTROL  [initandlisten] **        We suggest setting it to 'never'
2017-07-11T23:11:15.845+0800 I CONTROL  [initandlisten] 
2017-07-11T23:11:15.845+0800 I CONTROL  [initandlisten] ** WARNING: /sys/kernel/mm/transparent_hugepage/defrag is 'always'.
2017-07-11T23:11:15.845+0800 I CONTROL  [initandlisten] **        We suggest setting it to 'never'
2017-07-11T23:11:15.845+0800 I CONTROL  [initandlisten]