[Java] IDEA 格式化SQL代码技巧分享

<?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.sly</groupid>
 <artifactid>hrm01</artifactid>
 <version>1.0-snapshot</version>
 <packaging>war</packaging>
 
 <name>hrm01 maven webapp</name>
 <!-- fixme change it to the project's website -->
 <url>http://www.example.com</url>
 
 <properties>
 <project.build.sourceencoding>utf-8</project.build.sourceencoding>
 <maven.compiler.source>1.7</maven.compiler.source>
 <maven.compiler.target>1.7</maven.compiler.target>
 </properties>
 
 <dependencies>
 <dependency>
  <groupid>junit</groupid>
  <artifactid>junit</artifactid>
  <version>4.11</version>
  <scope>test</scope>
 </dependency>
 <!-- 导入jar包
 1.spring的jar包：11个
 com.springsource.org.aopalliance-1.0.0.jar
 com.springsource.org.aspectj.weaver-1.6.8.release.jar
 spring-aop-5.0.1.release.jar
 spring-aspects-5.0.1.release.jar
 spring-beans-5.0.1.release.jar
 spring-context-5.0.1.release.jar
 spring-core-5.0.1.release.jar
 spring-expression-5.0.1.release.jar
 spring-jcl-5.0.1.release.jar
 spring-jdbc-5.0.1.release.jar
 spring-tx-5.0.1.release.jar
 -->
  <!-- https://mvnrepository.com/artifact/org.aopalliance/com.springsource.org.aopalliance -->
  <dependency>
  <groupid>org.aopalliance</groupid>
  <artifactid>com.springsource.org.aopalliance</artifactid>
  <version>1.0.0</version>
  </dependency>
  <!-- https://mvnrepository.com/artifact/org.aspectj/com.springsource.org.aspectj.weaver -->
  <dependency>
   <groupid>org.aspectj</groupid>
   <artifactid>com.springsource.org.aspectj.weaver</artifactid>
   <version>1.6.4.release</version>
  </dependency>
 <!-- https://mvnrepository.com/artifact/org.springframework/spring-aop -->
 <dependency>
  <groupid>org.springframework</groupid>
  <artifactid>spring-aop</artifactid>
  <version>5.0.10.release</version>
 </dependency>
 <dependency>
  <groupid>org.springframework</groupid>
  <artifactid>spring-aspects</artifactid>
  <version>5.1.0.release</version>
 </dependency>
 <dependency>
  <groupid>org.springframework</groupid>
  <artifactid>spring-beans</artifactid>
  <version>5.0.1.release</version>
 </dependency>
 <dependency>
  <groupid>org.springframework</groupid>
  <artifactid>spring-context</artifactid>
  <version>5.0.1.release</version>
 </dependency>
 <dependency>
  <groupid>org.springframework</groupid>
  <artifactid>spring-core</artifactid>
  <version>5.0.1.release</version>
 </dependency>
 <dependency>
  <groupid>org.springframework</groupid>
  <artifactid>spring-expression</artifactid>
  <version>5.0.1.release</version>
 </dependency>
 <dependency>
  <groupid>org.springframework</groupid>
  <artifactid>spring-jcl</artifactid>
  <version>5.0.1.release</version>
 </dependency>
 <dependency>
  <groupid>org.springframework</groupid>
  <artifactid>spring-jdbc</artifactid>
  <version>5.0.1.release</version>
 </dependency>
 <dependency>
  <groupid>org.springframework</groupid>
  <artifactid>spring-tx</artifactid>
  <version>5.0.1.release</version>
 </dependency>
 <!--导入jar包
 2.springmvc的jar包：2个
 spring-web-5.0.1.release.jar
 spring-webmvc-5.0.1.release.jar
 3.mybatis的jar包：13个
 mybatis-3.4.2.jar
 依赖jar包12个
 4.mybatis和spring整合的jar包：1个
 mybatis-spring-1.3.1.jar
 -->
 <dependency>
  <groupid>org.springframework</groupid>
  <artifactid>spring-web</artifactid>
  <version>5.0.1.release</version>
 </dependency>
 <dependency>
  <groupid>org.springframework</groupid>
  <artifactid>spring-webmvc</artifactid>
  <version>5.0.1.release</version>
 </dependency>
 <dependency>
  <groupid>org.mybatis</groupid>
  <artifactid>mybatis</artifactid>
  <version>3.4.2</version>
 </dependency>
 <dependency>
  <groupid>org.mybatis</groupid>
  <artifactid>mybatis-spring</artifactid>
  <version>1.3.1</version>
 </dependency>
 <!--导入jar包
5.数据库驱动jar包：1个
mysql-connector-java-5.1.7-bin.jar
6.数据源druid的jar包：1个
druid-1.1.5.jar
7.jstl的jar包：2个
jstl-1.1.2 .jar
standard-1.1.2.jar
-->
 <dependency>
  <groupid>mysql</groupid>
  <artifactid>mysql-connector-java</artifactid>
  <version>5.1.48</version>
 </dependency>
 <dependency>
  <groupid>com.alibaba</groupid>
  <artifactid>druid</artifactid>
  <version>1.1.5</version>
 </dependency>
 <dependency>
  <groupid>javax.servlet</groupid>
  <artifactid>jstl</artifactid>
  <version>1.1.2</version>
 </dependency>
 <dependency>
  <groupid>taglibs</groupid>
  <artifactid>standard</artifactid>
  <version>1.1.2</version>
 </dependency> 
<!--导入tomcat的jar包-->
 <!-- https://mvnrepository.com/artifact/org.apache.tomcat/tomcat-servlet-api -->
 <dependency>
  <groupid>org.apache.tomcat</groupid>
  <artifactid>tomcat-servlet-api</artifactid>
  <version>9.0.21</version>
 </dependency> 
 </dependencies> 
 <build>
 <finalname>hrm01</finalname>
 <pluginmanagement><!-- lock down plugins versions to avoid using maven defaults (may be moved to parent pom) -->
  <plugins>
  <plugin>
   <artifactid>maven-clean-plugin</artifactid>
   <version>3.1.0</version>
  </plugin>
  <!-- see http://maven.apache.org/ref/current/maven-core/default-bindings.html#plugin_bindings_for_war_packaging -->
  <plugin>
   <artifactid>maven-resources-plugin</artifactid>
   <version>3.0.2</version>
  </plugin>
  <plugin>
   <artifactid>maven-compiler-plugin</artifactid>
   <version>3.8.0</version>
  </plugin>
  <plugin>
   <artifactid>maven-surefire-plugin</artifactid>
   <version>2.22.1</version>
  </plugin>
  <plugin>
   <artifactid>maven-war-plugin</artifactid>
   <version>3.2.2</version>
  </plugin>
  <plugin>
   <artifactid>maven-install-plugin</artifactid>
   <version>2.5.2</version>
  </plugin>
  <plugin>
   <artifactid>maven-deploy-plugin</artifactid>
   <version>2.8.2</version>
  </plugin>
  </plugins>
 </pluginmanagement> 
 </build>
</project>

org.springframework.beans.factory.unsatisfieddependencyexception: error creating bean with name 'userhandler': unsatisfied dependency expressed through field 'userservice'; nested exception is org.springframework.beans.factory.unsatisfieddependencyexception: error creating bean with name 'userserviceimpl': unsatisfied dependency expressed through field 'userdao'; nested exception is org.springframework.beans.factory.beancreationexception: error creating bean with name 'iuserdao' defined in file [d:\tomcat\apache-tomcat-9.0.27\webapps\hrm01_war\web-inf\classes\com\hrm\user\dao\iuserdao.class]: invocation of init method failed; nested exception is java.lang.illegalargumentexception: org.apache.ibatis.builder.builderexception: error parsing mapper xml. cause: org.apache.ibatis.builder.builderexception: wrong namespace. expected 'com.hrm.user.dao.iuserdao' but found 'com.hrm.user.dao.userdao'.