SSM整合实现增删改查

来源：互联网发布：weka的朴素贝叶斯算法编辑：程序博客网时间：2024/05/17 05:51

第一步：数据库文件

-------------------------创建数据库--创建用户（以管理员身份登录数据库,创建新用户）create user handson identified by 274039;--为用户分配权限grant create session,resource,dba to handson;--创建表空间create tablespace handson_datadatafile   'D:\oracleWorkSpace\handson_data.dbf' size 10mautoextend on next 1m maxsize 50mextent management local;--给用户指定表空间alter user handson  default tablespace handson_data;--用新创建的用户登陆数据库（conn handson/274039）------------------------创建表EMPLOYEEcreate table EMPLOYEE(  EMP_ID number(4) primary key,  EMP_NAME varchar2(100) not null,  EMP_SEX number(4) not null,  EMP_AGE number(4) not null,  EMP_DEPART varchar(50) not null)--添加自增create sequence seq_EMPLOYEEstart with 1increment by 1;--创建触发器create or replace trigger tr_EMPLOYEEbefore insert on EMPLOYEEfor each row begin   select seq_EMPLOYEE.nextval into :new.EMP_ID from dual;end;--插入数据insert into EMPLOYEE values(1,'李晓明',1,25,'行政部');insert into EMPLOYEE values(1,'杨伟林',1,29,'行政部');insert into  EMPLOYEE(EMP_NAME,EMP_SEX,EMP_AGE,EMP_DEPART) values('1',1,29,'行政部');update EMPLOYEE set EMP_NAME=#{name},EMP_SEX=#{pwd},EMP_AGE=#{name},EMP_DEPART=#{pwd} where EMP_ID = #{id}--查询select * from EMPLOYEE--dropdrop table EMPLOYEEdrop sequence seq_EMPLOYEE1
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
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

第二步骤：导入相关jar包

aopalliance.jar
asm-3.3.1.jar
aspectjweaver.jar
cglib-2.2.2.jar
commons-dbcp.jar
commons-fileupload-1.3.2.jar
commons-io-2.2.jar
commons-logging-1.1.3.jar
commons-pool.jar
fastjson-1.2.3.jar
jackson-annotations-2.5.3.jar
jackson-core-2.5.3.jar
jackson-databind-2.5.3.jar
javassist-3.17.1-GA.jar
jsp-api.jar
jstl.jar
log4j-1.2.17.jar
log4j-api-2.0-rc1.jar
log4j-core-2.0-rc1.jar
mybatis-3.2.7.jar
mybatis-spring-1.2.3.jar
ojdbc14.jar
servlet-api.jar
slf4j-api-1.7.5.jar
slf4j-log4j12-1.7.5.jar
spring-aop-4.3.2.RELEASE.jar
spring-aspects-4.3.2.RELEASE.jar
spring-beans-4.3.2.RELEASE.jar
spring-context-4.3.2.RELEASE.jar
spring-context-support-4.3.2.RELEASE.jar
spring-core-4.3.2.RELEASE.jar
spring-expression-4.3.2.RELEASE.jar
spring-jdbc-4.3.2.RELEASE.jar
spring-orm-4.3.2.RELEASE.jar
spring-tx-4.3.2.RELEASE.jar
spring-web-4.3.2.RELEASE.jar
spring-webmvc-4.3.2.RELEASE.jar
standard.jar
tomcat-api.jar

编写配置文件

web工程: web.xml
springmvc: mvc.xml
spring: application.xml
mybatis: mybatis.cfg.xml(可有可无,看怎样配置)

a：web.xml配置

配置spring和配置springmvc

<?xml version="1.0" encoding="UTF-8"?><web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://xmlns.jcp.org/xml/ns/javaee" xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_3_1.xsd" id="WebApp_ID" version="3.1">  <display-name>handson</display-name>    <welcome-file-list>        <welcome-file>index.jsp</welcome-file>    </welcome-file-list>    <!-- 配置spring:读取spring -->    <context-param>        <param-name>contextConfigLocation</param-name>        <param-value>classpath:applicationContext.xml</param-value>    </context-param>    <listener>        <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>    </listener>    <!-- spring mvc配置文件 -->    <!-- 分发器,核心控制器的配置 -->    <servlet>        <servlet-name>springmvc</servlet-name>        <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>        <!--DispathcherServlet初始化参数 src下 -->        <init-param>            <param-name>contextConfigLocation</param-name>            <param-value>classpath:mvc.xml</param-value>        </init-param>        <!-- 容器启动servlet就启动 -->        <load-on-startup>1</load-on-startup>    </servlet>    <servlet-mapping>        <servlet-name>springmvc</servlet-name>        <!-- <url-pattern>*.do</url-pattern> -->        <url-pattern>*.do</url-pattern>    </servlet-mapping></web-app>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
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

b：mvc.xml 使用注解

如果需要json或其他处理,需要填写相关配置

<?xml version="1.0" encoding="UTF-8"?><beans xmlns="http://www.springframework.org/schema/beans"    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"    xmlns:jee="http://www.springframework.org/schema/jee"    xmlns:context="http://www.springframework.org/schema/context"    xsi:schemaLocation="        http://www.springframework.org/schema/beans        http://www.springframework.org/schema/beans/spring-beans.xsd        http://www.springframework.org/schema/jee        http://www.springframework.org/schema/jee/spring-jee.xsd        http://www.springframework.org/schema/context        http://www.springframework.org/schema/context/spring-context.xsd">    <!-- 用于将对象转换为JSON -->    <bean id="stringConverter" class="org.springframework.http.converter.StringHttpMessageConverter">        <property name="supportedMediaTypes">            <list>                <value>text/plain;charset=UTF-8</value>            </list>        </property>    </bean>    <bean id="jsonConverter" class="org.springframework.http.converter.json.MappingJackson2HttpMessageConverter">           </bean>        <!-- 适配器 -->    <bean class="org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter">        <property name="messageConverters">            <list>                <ref bean="stringConverter"/>                <ref bean="jsonConverter"/>            </list>        </property>    </bean>    <!-- 配置注解的扫描:扫描cn.sxt.controller下文件 -->    <context:component-scan base-package="cn.sxt.controller"/></beans>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
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

c：spring:applicationContext.xml

<?xml version="1.0" encoding="UTF-8"?><beans xmlns="http://www.springframework.org/schema/beans"    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"    xmlns:aop="http://www.springframework.org/schema/aop"    xmlns:tx="http://www.springframework.org/schema/tx"    xmlns:context="http://www.springframework.org/schema/context"    xsi:schemaLocation="        http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd        http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop.xsd         http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx.xsd        http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd">    <!-- 配置datasource数据源 -->    <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">        <property name="driverClassName" value="oracle.jdbc.driver.OracleDriver"/>        <property name="url" value="jdbc:oracle:thin:@127.0.0.1:1521:ORCL"/>        <property name="username" value="handson"/>        <property name="password" value="274039"/>    </bean>     <!-- 配置sqlSessionFactory 工厂-->    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">        <property name="dataSource" ref="dataSource"/>        <property name="configLocation" value="classpath:mybatis.cfg.xml"></property>    </bean>    <!-- 配置声明式事务配置 开始 -->    <!-- 配置事务管理器 -->    <bean id="txManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">        <property name="dataSource" ref="dataSource"/>    </bean>    <!-- 配置事务通知 -->    <tx:advice id="txAdvice" transaction-manager="txManager">        <tx:attributes>            <!-- 配置哪些方法使用什么样的事务,配置事务的传播特性 -->            <tx:method name="save" propagation="REQUIRED"/>            <tx:method name="get" read-only="true"/>            <tx:method name="*" propagation="REQUIRED"/>        </tx:attributes>    </tx:advice>    <aop:config>        <aop:pointcut expression="execution(* cn.sxt.service.impl.*.*(..))" id="pointcut"/>        <aop:advisor advice-ref="txAdvice" pointcut-ref="pointcut"/>    </aop:config>    <!-- 声明式事务配置 结束 -->    <context:component-scan base-package="cn.sxt"/></beans>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
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

d：mybatis.cfg.xml

<?xml version="1.0" encoding="UTF-8" ?><!DOCTYPE configurationPUBLIC "-//mybatis.org//DTD Config 3.0//EN""http://mybatis.org/dtd/mybatis-3-config.dtd"><configuration>    <typeAliases>        <package name="cn.sxt.vo"/>    </typeAliases>    <mappers>        <!-- 所有mapper.xml文件填写位置 -->        <mapper resource="cn/sxt/vo/employee.mapper.xml"/>    </mappers> </configuration>1
2
3
4
5
6
7
8
9
10
11
12
13
1
2
3
4
5
6
7
8
9
10
11
12
13

编码

这一过程就不贴出具体代码了，感兴趣的可以去下载ssm整合源代码
编码结构图
这里写图片描述

效果图

这里写图片描述

阅读全文

0 0