（2）创建用户
设置用户名和密码ssm和itzheng
设置权限
也可以点击右下角，观看SQL语句
重新打开PL/SQL以ssm用户的方式登录
1.1.2创建表
产品表信息形貌
创建表sql
CREATE TABLE product(
id varchar2(32) default SYS_GUID() PRIMARY KEY,
productNum VARCHAR2(50) NOT NULL,
productName VARCHAR2(50),
cityName VARCHAR2(50),
DepartureTime timestamp,
productPrice Number,
productDesc VARCHAR2(580),
productStatus INT,
CONSTRAINT product UNIQUE (id,productNum)
)
insert into product (id,productNum,productName,cityName,DepartureTime,productprice,productDesc,productstatus)
values
(‘676C5BD1035E429A8C2E114939C5685A’,‘itzheng-002’,‘北京三日游’,‘北京’,
to_timestamp
(‘10-10-2018 10:10:00.000000’,‘dd-mm-yyyy hh24:mi:ss.ff’),1200,‘不错的旅行’,1);
insert into product (id,productNum,productName,cityName,DepartureTime,productprice,productDesc,productstatus)
values
(‘9F71F01CB448476DAFB309AA6DF9497F’, ‘itzheng-801’,‘北京三日游’,‘北京’,
to_timestamp
( ‘10-10-2018 14:30:00.000000’ , ‘dd-mm-yyyy hh24:mi:ss.ff’),1800,‘不错的旅行’,0);
insert into PRoDuCT (id,productnum,productname,cityname,depanrturetime，productprice,productdesc, productstatus)
values
( ‘9F71F01CB448476DAFB309AA6DF9497F’, ‘itzheng-801’,‘北京三日游’,‘北京’,to_timestamp( ‘10-10-2018 10:10:00.0oooo0’ , ‘dd-mm-yyyy hh24:mi:ss.fF’),1200,‘不错的旅行’,1);
二、环境搭建
<hr> 1、创建maven工程
（1）创建父工程
创建乐成
（2）创建子工程
（3）创建其他子模块
（4）创建末了的web模块
所有的都创建乐成
（5）修改pom.xml
复制以下内容
<?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”>
4.0.0
com.itzheng.zheng_ssm
zheng_ssm
pom
1.0-SNAPSHOT
<spring.version>5.0.15.RELEASE</spring.version>
<slf4j.version>1.7.12</slf4j.version>
<log4j.version>1.2.17</log4j.version>
<shiro.version>1.2.3</shiro.version>
<mybatis.version>3.5.2</mybatis.version>
<mysql.version>8.0.17</mysql.version>
<oracle.version>10.2.0.1.0</oracle.version>
<spring.security.version>5.0.10.RELEASE</spring.security.version>
org.springframework
spring-context
${spring.version}
org.springframework
spring-web
${spring.version}
org.springframework
spring-webmvc
${spring.version}
org.springframework
spring-tx
${spring.version}
org.springframework
spring-test
${spring.version}
org.mybatis
mybatis
${mybatis.version}
org.aspectj
aspectjweaver
1.9.2
org.springframework
spring-aop
${spring.version}
org.springframework
spring-context
${spring.version}
org.springframework
spring-context-support
${spring.version}
org.springframework
spring-web
${spring.version}
org.springframework
spring-orm
${spring.version}
org.springframework
spring-beans
${spring.version}
org.springframework
spring-core
${spring.version}
org.springframework
spring-test
${spring.version}
org.springframework
spring-webmvc
${spring.version}
org.springframework
spring-tx
${spring.version}
junit
junit
4.12
test
javax.servlet
javax.servlet-api
4.0.1
provided
javax.servlet.jsp
jsp-api
2.2
provided
jstl
jstl
1.2
log4j
log4j
${log4j.version}
org.slf4j
slf4j-api
${slf4j.version}
org.slf4j
slf4j-log4j12
${slf4j.version}
org.mybatis
mybatis
${mybatis.version}
org.mybatis
mybatis-spring
2.0.2
c3p0
c3p0
0.9.1.2
jar
compile
com.github.pagehelper
pagehelper
5.1.10
org.springframework.security
spring-security-web
${spring.security.version}
org.springframework.security
spring-security-config
${spring.security.version}
org.springframework.security
spring-security-core
${spring.security.version}
org.springframework.security
spring-security-taglibs
${spring.security.version}
com.alibaba
druid
1.1.9
mysql
mysql-connector-java
${mysql.version}
com.oracle
ojdbc14
${oracle.version}
javax.annotation
jsr250-api
1.0
org.apache.maven.plugins
maven-compiler-plugin
3.6.1
1.8 1.8
UTF-8
true
zheng_ssm_dao
zheng_ssm_service
zheng_ssm_domain
zheng_ssm_utils
zheng_ssm_web
zheng_ssm_web
2、编写实体类Product
创建包
免责声明：如果侵犯了您的权益，请联系站长，我们会及时删除侵权内容，谢谢合作！更多信息从访问主页：qidao123.com:ToB企服之家，中国第一个企服评测及商务社交产业平台。 |
