8000 将项目改造为Oracle的项目 · coderhxt/Mybatis-Spring@a5ddd02 · GitHub
[go: up one dir, main page]
Skip to content

Commit a5ddd02

Browse files
abel533abel533
committed
将项目改造为Oracle的项目
1 parent 50b91bf commit a5ddd02

File tree

14 files changed

+304
-507
lines changed

14 files changed

+304
-507
lines changed

‎README.md

Lines changed: 62 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -4,11 +4,71 @@
44

55
#Spring[MVC]4.1.2.RELEASE
66

7-
项目使用Spring4.1.2.RELEASE + SpringMVC4.1.2.RELEASE + Mybatis3.3.0
7+
#Oracle
8+
9+
项目使用Spring4.1.2.RELEASE + SpringMVC4.1.2.RELEASE + Mybatis3.3.0 + Oracle
810

911
项目集成了Mybatis分页插件和通用Mapper插件
1012

11-
项目使用的mysql数据库，根据需要可以切换为其他数据库
13+
项目使用的Oracle数据库，根据需要可以切换为其他数据库
14+
15+
##注意主键
16+
17+
```java
18+
public class Country {
19+
/**
20+
* 主键
21+
*/
22+
@Id
23+
@GeneratedValue(strategy = GenerationType.IDENTITY, generator = "select SEQ_COUNTRY.nextval from dual")
24+
private Integer id;
25+
26+
//省略其他
27+
```
28+
29+
##注意通用Mapper配置
30+
```xml
31+
<bean class="tk.mybatis.spring.mapper.MapperScannerConfigurer">
32+
<property name="basePackage" value="com.isea533.mybatis.mapper"/>
33+
<!-- 3.2.2版本新特性，markerInterface可以起到mappers配置的作用，详细情况需要看Marker接口类 -->
34+
<property name="markerInterface" value="com.isea533.mybatis.util.MyMapper"/>
35+
<!-- 通用Mapper通过属性注入进行配置，默认不配置时会注册Mapper<T>接口 -->
36+
<property name="properties">
37+
<value>
38+
ORDER=BEFORE
39+
</value>
40+
</property>
41+
</bean>
42+
```
43+
主要是`ORDER=BEFORE`，这个可以保证序列先执行
44+
45+
##新增国家输出的日志
46+
47+
```
48+
DEBUG [http-apr-8091-exec-4] - JDBC Connection [com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl@43daa112] will be managed by Spring
49+
DEBUG [http-apr-8091-exec-4] - ==> Executing: select SEQ_COUNTRY.nextval from dual
50+
DEBUG [http-apr-8091-exec-4] - <== Total: 1
51+
DEBUG [http-apr-8091-exec-4] - ==> Preparing: INSERT INTO country ( id,countryname,countrycode ) VALUES( ?,?,? )
52+
DEBUG [http-apr-8091-exec-4] - ==> Parameters: 200(Integer), 测试(String), CS(String)
53+
DEBUG [http-apr-8091-exec-4] - <== Updates: 1
54+
```
55+
56+
##如何运行本项目
57+
58+
先通过项目sql文件下的sql创建数据库的基本环境，如果没有表空间，就先执行**创建表空间和用户.sql**
59+
60+
之后使用新建的用户登录，然后执行 **创建表-序列-数据.sql**
61+
62+
准备好数据库之后，修改`src/main/resources/config.properties`配置：
63+
```
64+
# 数据库配置
65+
jdbc.driverClass = oracle.jdbc.driver.OracleDriver
66+
jdbc.url = jdbc:oracle:thin:@//192.168.16.137:1521/orcl
67+
jdbc.user = mybatis
68+
jdbc.password = mybatis
69+
```
70+
71+
保持上面的配置和自己的数据库一致即可。
1272
1373
##Spring Boot集成MyBatis的基础项目
1474

‎pom.xml

Lines changed: 9 additions & 8 deletions
Original file line numberDiff line numberDiff line change
@@ -25,7 +25,6 @@
2525
<mybatis.version>3.3.1</mybatis.version>
2626
<mapper.version>3.3.6</mapper.version>
2727
<pagehelper.version>4.1.4</pagehelper.version>
28-
<mysql.version>5.1.29</mysql.version>
2928
<spring.version>4.1.2.RELEASE</spring.version>
3029
<mybatis.spring.version>1.2.4</mybatis.spring.version>
3130
</properties>
@@ -151,11 +150,13 @@
151150
<version>1.3.1</version>
152151
</dependency>
153152

154-
<!--mysql-->
153+
<!-- http://mvnrepository.com/artifact/com.oracle/ojdbc14 -->
155154
<dependency>
156-
<groupId>mysql</groupId>
157-
<artifactId>mysql-connector-java</artifactId>
158-
<version>${mysql.version}</version>
155+
<groupId>com.oracle</groupId>
156+
<artifactId>ojdbc14</artifactId>
157+
<version>10.2.0.4.0</version>
158+
<scope>system</scope>
159+
<systemPath>${basedir}/src/main/webapp/WEB-INF/lib/ojdbc14-10.2.0.4.0.jar</systemPath>
159160
</dependency>
160161
<!--druid-->
161162
<dependency>
@@ -273,9 +274,9 @@
273274
</configuration>
274275
<dependencies>
275276
<dependency>
276-
<groupId>mysql</groupId>
277-
<artifactId>mysql-connector-java</artifactId>
278-
<version>${mysql.version}</version>
277+
<groupId>com.oracle</groupId>
278+
<artifactId>ojdbc14</artifactId>
279+
<version>10.2.0.4.0</version>
279280
</dependency>
280281
<dependency>
281282
<groupId>tk.mybatis</groupId>

‎sql/创建表-序列-数据.sql

Lines changed: 206 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,206 @@
1+
-- 创建表
2+
create table country
3+
(
4+
id number(12),
5+
countryname varchar2(50),
6+
countrycode varchar2(50)
7+
)
8+
;
9+
comment on table COUNTRY
10+
is '国家';
11+
-- Add comments to the columns
12+
comment on column country.id
13+
is '主键';
14+
comment on column country.countryname
15+
is '名称';
16+
comment on column country.countrycode
17+
is '代码';
18+
19+
INSERT INTO country VALUES (1,'Angola','AO');
20+
INSERT INTO country VALUES (2,'Afghanistan','AF');
21+
INSERT INTO country VALUES (3,'Albania','AL');
22+
INSERT INTO country VALUES (4,'Algeria','DZ');
23+
INSERT INTO country VALUES (5,'Andorra','AD');
24+
INSERT INTO country VALUES (6,'Anguilla','AI');
25+
INSERT INTO country VALUES (7,'Antigua and Barbuda','AG');
26+
INSERT INTO country VALUES (8,'Argentina','AR');
27+
INSERT INTO country VALUES (9,'Armenia','AM');
28+
INSERT INTO country VALUES (10,'Australia','AU');
29+
INSERT INTO country VALUES (11,'Austria','AT');
30+
INSERT INTO country VALUES (12,'Azerbaijan','AZ');
31+
INSERT INTO country VALUES (13,'Bahamas','BS');
32+
INSERT INTO country VALUES (14,'Bahrain','BH');
33+
INSERT INTO country VALUES (15,'Bangladesh','BD');
34+
INSERT INTO country VALUES (16,'Barbados','BB');
35+
INSERT INTO country VALUES (17,'Belarus','BY');
36+
INSERT INTO country VALUES (18,'Belgium','BE');
37+
INSERT INTO country VALUES (19,'Belize','BZ');
38+
INSERT INTO country VALUES (20,'Benin','BJ');
39+
INSERT INTO country VALUES (21,'Bermuda Is.','BM');
40+
INSERT INTO country VALUES (22,'Bolivia','BO');
41+
INSERT INTO country VALUES (23,'Botswana','BW');
42+
INSERT INTO country VALUES (24,'Brazil','BR');
43+
INSERT INTO country VALUES (25,'Brunei','BN');
44+
INSERT INTO country VALUES (26,'Bulgaria','BG');
45+
INSERT INTO country VALUES (27,'Burkina-faso','BF');
46+
INSERT INTO country VALUES (28,'Burma','MM');
47+
INSERT INTO country VALUES (29,'Burundi','BI');
48+
INSERT INTO country VALUES (30,'Cameroon','CM');
49+
INSERT INTO country VALUES (31,'Canada','CA');
50+
INSERT INTO country VALUES (32,'Central African Republic','CF');
51+
INSERT INTO country VALUES (33,'Chad','TD');
52+
INSERT INTO country VALUES (34,'Chile','CL');
53+
INSERT INTO country VALUES (35,'China','CN');
54+
INSERT INTO country VALUES (36,'Colombia','CO');
55+
INSERT INTO country VALUES (37,'Congo','CG');
56+
INSERT INTO country VALUES (38,'Cook Is.','CK');
57+
INSERT INTO country VALUES (39,'Costa Rica','CR');
58+
INSERT INTO country VALUES (40,'Cuba','CU');
59+
INSERT INTO country VALUES (41,'Cyprus','CY');
60+
INSERT INTO country VALUES (42,'Czech Republic','CZ');
61+
INSERT INTO country VALUES (43,'Denmark','DK');
62+
INSERT INTO country VALUES (44,'Djibouti','DJ');
63+
INSERT INTO country VALUES (45,'Dominica Rep.','DO');
64+
INSERT INTO country VALUES (46,'Ecuador','EC');
65+
INSERT INTO country VALUES (47,'Egypt','EG');
66+
INSERT INTO country VALUES (48,'EI Salvador','SV');
67+
INSERT INTO country VALUES (49,'Estonia','EE');
68+
INSERT INTO country VALUES (50,'Ethiopia','ET');
69+
INSERT INTO country VALUES (51,'Fiji','FJ');
70+
INSERT INTO country VALUES (52,'Finland','FI');
71+
INSERT INTO country VALUES (53,'France','FR');
72+
INSERT INTO country VALUES (54,'French Guiana','GF');
73+
INSERT INTO country VALUES (55,'Gabon','GA');
74+
INSERT INTO country VALUES (56,'Gambia','GM');
75+
INSERT INTO country VALUES (57,'Georgia','GE');
76+
INSERT INTO country VALUES (58,'Germany','DE');
77+
INSERT INTO 10000 country VALUES (59,'Ghana','GH');
78+
INSERT INTO country VALUES (60,'Gibraltar','GI');
79+
INSERT INTO country VALUES (61,'Greece','GR');
80+
INSERT INTO country VALUES (62,'Grenada','GD');
81+
INSERT INTO country VALUES (63,'Guam','GU');
82+
INSERT INTO country VALUES (64,'Guatemala','GT');
83+
INSERT INTO country VALUES (65,'Guinea','GN');
84+
INSERT INTO country VALUES (66,'Guyana','GY');
85+
INSERT INTO country VALUES (67,'Haiti','HT');
86+
INSERT INTO country VALUES (68,'Honduras','HN');
87+
INSERT INTO country VALUES (69,'Hongkong','HK');
88+
INSERT INTO country VALUES (70,'Hungary','HU');
89+
INSERT INTO country VALUES (71,'Iceland','IS');
90+
INSERT INTO country VALUES (72,'India','IN');
91+
INSERT INTO country VALUES (73,'Indonesia','ID');
92+
INSERT INTO country VALUES (74,'Iran','IR');
93+
INSERT INTO country VALUES (75,'Iraq','IQ');
94+
INSERT INTO country VALUES (76,'Ireland','IE');
95+
INSERT INTO country VALUES (77,'Israel','IL');
96+
INSERT INTO country VALUES (78,'Italy','IT');
97+
INSERT INTO country VALUES (79,'Jamaica','JM');
98+
INSERT INTO country VALUES (80,'Japan','JP');
99+
INSERT INTO country VALUES (81,'Jordan','JO');
100+
INSERT INTO country VALUES (82,'Kampuchea (Cambodia )','KH');
101+
INSERT INTO country VALUES (83,'Kazakstan','KZ');
102+
INSERT INTO country VALUES (84,'Kenya','KE');
103+
INSERT INTO country VALUES (85,'Korea','KR');
104+
INSERT INTO country VALUES (86,'Kuwait','KW');
105+
INSERT INTO country VALUES (87,'Kyrgyzstan','KG');
106+
INSERT INTO country VALUES (88,'Laos','LA');
107+
INSERT INTO country VALUES (89,'Latvia','LV');
108+
INSERT INTO country VALUES (90,'Lebanon','LB');
109+
INSERT INTO country VALUES (91,'Lesotho','LS');
110+
INSERT INTO country VALUES (92,'Liberia','LR');
111+
INSERT INTO country VALUES (93,'Libya','LY');
112+
INSERT INTO country VALUES (94,'Liechtenstein','LI');
113+
INSERT INTO country VALUES (95,'Lithuania','LT');
114+
INSERT INTO country VALUES (96,'Luxembourg','LU');
115+
INSERT INTO country VALUES (97,'Macao','MO');
116+
INSERT INTO country VALUES (98,'Madagascar','MG');
117+
INSERT INTO country VALUES (99,'Malawi','MW');
118+
INSERT INTO country VALUES (100,'Malaysia','MY');
119+
INSERT INTO country VALUES (101,'Maldives','MV');
120+
INSERT INTO country VALUES (102,'Mali','ML');
121+
INSERT INTO country VALUES (103,'Malta','MT');
122+
INSERT INTO country VALUES (104,'Mauritius','MU');
123+
INSERT INTO country VALUES (105,'Mexico','MX');
124+
INSERT INTO country VALUES (106,'Moldova, Republic of','MD');
125+
INSERT INTO country VALUES (107,'Monaco','MC');
126+
INSERT INTO country VALUES (108,'Mongolia','MN');
127+
INSERT INTO country VALUES (109,'Montserrat Is','MS');
128+
INSERT INTO country VALUES (110,'Morocco','MA');
129+
INSERT INTO country VALUES (111,'Mozambique','MZ');
130+
INSERT INTO country VALUES (112,'Namibia','NA');
131+
INSERT INTO country VALUES (113,'Nauru','NR');
132+
INSERT INTO country VALUES (114,'Nepal','NP');
133+
INSERT INTO country VALUES (115,'Netherlands','NL');
134+
INSERT INTO country VALUES (116,'New Zealand','NZ');
135+
INSERT INTO country VALUES (117,'Nicaragua','NI');
136+
INSERT INTO country VALUES (118,'Niger','NE');
137+
INSERT INTO country VALUES (119,'Nigeria','NG');
138+
INSERT INTO country VALUES (120,'North Korea','KP');
139+
INSERT INTO country VALUES (121,'Norway','NO');
140+
INSERT INTO country VALUES (122,'Oman','OM');
141+
INSERT INTO country VALUES (123,'Pakistan','PK');
142+
INSERT INTO country VALUES (124,'Panama','PA');
143+
INSERT INTO country VALUES (125,'Papua New Cuinea','PG');
144+
INSERT INTO country VALUES (126,'Paraguay','PY');
145+
INSERT INTO country VALUES (127,'Peru','PE');
146+
INSERT INTO country VALUES (128,'Philippines','PH');
147+
INSERT INTO country VALUES (129,'Poland','PL');
148+
INSERT INTO country VALUES (130,'French Polynesia','PF');
149+
INSERT INTO country VALUES (131,'Portugal','PT');
150+
INSERT INTO country VALUES (132,'Puerto Rico','PR');
151+
INSERT INTO country VALUES (133,'Qatar','QA');
152+
INSERT INTO country VALUES (134,'Romania','RO');
153+
INSERT INTO country VALUES (135,'Russia','RU');
154+
INSERT INTO country VALUES (136,'Saint Lueia','LC');
155+
INSERT INTO country VALUES (137,'Saint Vincent','VC');
156+
INSERT INTO country VALUES (138,'San Marino','SM');
157+
INSERT INTO country VALUES (139,'Sao Tome and Principe','ST');
158+
INSERT INTO country VALUES (140,'Saudi Arabia','SA');
159+
INSERT INTO country VALUES (141,'Senegal','SN');
160+
INSERT INTO country VALUES (142,'Seychelles','SC');
161+
INSERT INTO country VALUES (143,'Sierra Leone','SL');
162+
INSERT INTO country VALUES (144,'Singapore','SG');
163+
INSERT INTO country VALUES (145,'Slovakia','SK');
164+
INSERT INTO country VALUES (146,'Slovenia','SI');
165+
INSERT INTO country VALUES (147,'Solomon Is','SB');
166+
INSERT INTO country VALUES (148,'Somali','SO');
167+
INSERT INTO country VALUES (149,'South Africa','ZA');
168+
INSERT INTO country VALUES (150,'Spain','ES');
169+
INSERT INTO country VALUES (151,'Sri Lanka','LK');
170+
INSERT INTO country VALUES (152,'St.Lucia','LC');
171+
INSERT INTO country VALUES (153,'St.Vincent','VC');
172+
INSERT INTO country VALUES (154,'Sudan','SD');
173+
INSERT INTO country VALUES (155,'Suriname','SR');
174+
INSERT INTO country VALUES (156,'Swaziland','SZ');
175+
INSERT INTO country VALUES (157,'Sweden','SE');
176+
INSERT INTO country VALUES (158,'Switzerland','CH');
177+
INSERT INTO country VALUES (159,'Syria','SY');
178+
INSERT INTO country VALUES (160,'Taiwan','TW');
179+
INSERT INTO country VALUES (161,'Tajikstan','TJ');
180+
INSERT INTO country VALUES (162,'Tanzania','TZ');
181+
INSERT INTO country VALUES (163,'Thailand','TH');
182+
INSERT INTO country VALUES (164,'Togo','TG');
183+
INSERT INTO country VALUES (165,'Tonga','TO');
184+
INSERT INTO country VALUES (166,'Trinidad and Tobago','TT');
185+
INSERT INTO country VALUES (167,'Tunisia','TN');
186+
INSERT INTO country VALUES (168,'Turkey','TR');
187+
INSERT INTO country VALUES (169,'Turkmenistan','TM');
188+
INSERT INTO country VALUES (170,'Uganda','UG');
189+
INSERT INTO country VALUES (171,'Ukraine','UA');
190+
INSERT INTO country VALUES (172,'United Arab Emirates','AE');
191+
INSERT INTO country VALUES (173,'United Kiongdom','GB');
192+
INSERT INTO country VALUES (174,'United States of America','US');
193+
INSERT INTO country VALUES (175,'Uruguay','UY');
194+
INSERT INTO country VALUES (176,'Uzbekistan','UZ');
195+
INSERT INTO country VALUES (177,'Venezuela','VE');
196+
INSERT INTO country VALUES (178,'Vietnam','VN');
197+
INSERT INTO country VALUES (179,'Yemen','YE');
198+
INSERT INTO country VALUES (180,'Yugoslavia','YU');
199+
INSERT INTO country VALUES (181,'Zimbabwe','ZW');
200+
INSERT INTO country VALUES (182,'Zaire','ZR');
201+
INSERT INTO country VALUES (183,'Zambia','ZM');
202+
203+
-- Create sequence
204+
create sequence SEQ_COUNTRY
205+
start with 200
206+
increment by 1;

‎sql/创建表空间和用户.sql

Lines changed: 20 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,20 @@
1+
--创建临时表空间
2+
create temporary tablespace mybatis_temp
3+
tempfile 'C:\oracle\product\10.2.0\oradata\mybatis\mybatis_temp.dbf'
4+
size 32m
5+
autoextend on
6+
next 32m maxsize 2048m
7+
extent management local;
8+
--创建数据表空间
9+
create tablespace mybatis
10+
logging
11+
datafile 'C:\oracle\product\10.2.0\oradata\mybatis\mybatis.dbf'
12+
size 32m
13+
autoextend on
14+
next 32m maxsize 2048m
15+
extent management local;
16+
17+
--
18+
create user mybatis identified by mybatis
19+
default tablespace mybatis
20+
temporary tablespace mybatis_temp;

‎src/main/java/com/isea533/mybatis/mapper/UserInfoMapper.java

Lines changed: 0 additions & 31 deletions
This file was deleted.

0 commit comments

Comments
 (0)
0