寫(xiě)在前面
intellij idea集成了很多我們開(kāi)發(fā)中常用的工具，linux連接，git,數(shù)據(jù)庫(kù)操作…
這里我們介紹，idea集成數(shù)據(jù)庫(kù)操作，并對(duì)sql可格式化…
通過(guò)命令,但是在合適的執(zhí)行文件中…
ctrl alt l
1.1、建立連接，數(shù)據(jù)庫(kù)服務(wù)器地址，賬號(hào)，密碼等…
1.2、基本操作，很多，增刪改查，控制臺(tái)sql編寫(xiě)等等
sql執(zhí)行控制臺(tái)，這里是格式化之后的，我們平時(shí)手寫(xiě)的sql都是沒(méi)有格式化的，注意這里提供了輸入框，操作占位符的參數(shù)也很方便…
那么這里的格式化的sql是怎么實(shí)現(xiàn)的呢？？
這里的哈，idea的快捷鍵 ctrl + alt + l，就可以格式化sql
補(bǔ)充：解決idea的src目錄下不能編譯sql語(yǔ)句的xml配置文件的問(wèn)題
一：正常配置下的情況
1.編譯的目錄下不會(huì)編譯映射配置文件.xml，但是resources目錄中的文件都被編譯出來(lái)。
2.pom.xml文件的配置
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
|
<?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> <!-- 導(dǎo)入jar包 1.spring的jar包：11個(gè) 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> <!--導(dǎo)入jar包 2.springmvc的jar包：2個(gè) spring-web-5.0.1.release.jar spring-webmvc-5.0.1.release.jar 3.mybatis的jar包：13個(gè) mybatis-3.4.2.jar 依賴jar包12個(gè) 4.mybatis和spring整合的jar包：1個(gè) 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> <!--導(dǎo)入jar包5.數(shù)據(jù)庫(kù)驅(qū)動(dòng)jar包：1個(gè)mysql-connector-java-5.1.7-bin.jar6.數(shù)據(jù)源druid的jar包：1個(gè)druid-1.1.5.jar7.jstl的jar包：2個(gè)jstl-1.1.2 .jarstandard-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> <!--導(dǎo)入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> |
3.控制臺(tái)無(wú)報(bào)錯(cuò)且網(wǎng)頁(yè)報(bào)錯(cuò)404 找不到，或者500如下錯(cuò)誤。
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'.
二、解決方案
1.在pom文件中的build標(biāo)簽下配置該屬性即可解決這個(gè)問(wèn)題，但是要注意src前面不要加 / 。
一定不要寫(xiě)為：（/src/main/java）。
這樣在編譯目錄下xml文件也被編譯。
2.加入該配置后編譯目錄下有了映射配置文件，見(jiàn)上圖iuserdao.xml。
控制臺(tái)可以正常顯示數(shù)據(jù)。
以上為個(gè)人經(jīng)驗(yàn)，希望能給大家一個(gè)參考，也希望大家多多支持服務(wù)器之家。如有錯(cuò)誤或未考慮完全的地方，望不吝賜教。
原文鏈接：https://blog.csdn.net/qq_42105629/article/details/104004538
