-. 1.Oracle10g 的表结构语句,需要内容的自己添加一些。
2.用maven创建好项目就是对pom.xml的操作了(pom.xml文件如下,因为没有细挑,直接从已前的一个项目中拷过来的,不免有些jar包是多余的)
3. 对web.xml文件的基本配置(这里只配置了struts2的过滤器等必要的配置,如下:)
4. struts.xml配置,放在src目录下;(其实这里你可以先写代码,但为了统一先都把配置文件写出来算了.)
5. ibatis的配置文件sqlMap-Config.xml(放在WEB-INF目录)
6. applicationContext.xml spring配置文件(放在WEB-INF目录)
7.ibatis对数据表操作的文件(src下com/vo/User_SSI.xml):
------------part 1 End 配置文件完结-------------
create table TEST ( id NUMBER default 0 not null, nuser VARCHAR2(16) not null, password VARCHAR2(16) not null, dept VARCHAR2(16) default 1, tel VARCHAR2(16) ) ; comment on column TEST.id is '主键,与业务无关'; comment on column TEST.nuser is '用户名'; comment on column TEST.password is '密码'; comment on column TEST.dept is '部门名称'; comment on column TEST.tel is '联系电话'; alter table TEST add constraint ID primary key (ID) disable;
2.用maven创建好项目就是对pom.xml的操作了(pom.xml文件如下,因为没有细挑,直接从已前的一个项目中拷过来的,不免有些jar包是多余的)
<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.zjapl</groupId> <artifactId>APL-SMSAPP</artifactId> <version>1.0.1</version> <packaging>war</packaging> <name>APL-SMSAPP</name> <dependencies> <dependency> <groupId>javax.servlet</groupId> <artifactId>javax.servlet-api</artifactId> <version>3.0.1</version> </dependency> <dependency> <groupId>c3p0</groupId> <artifactId>c3p0</artifactId> <version>0.9.1.2</version> </dependency> <dependency> <groupId>log4j</groupId> <artifactId>log4j</artifactId> <version>1.2.12</version> </dependency> <dependency> <groupId>org.slf4j</groupId> <artifactId>slf4j-log4j12</artifactId> <version>1.6.2</version> </dependency> <dependency> <groupId>org.apache.struts</groupId> <artifactId>struts2-core</artifactId> <version>2.2.3</version> </dependency> <dependency> <groupId>org.apache.struts</groupId> <artifactId>struts2-spring-plugin</artifactId> <version>2.2.3</version> </dependency> <dependency> <groupId>org.apache.shiro</groupId> <artifactId>shiro-core</artifactId> <version>1.1.0</version> </dependency> <dependency> <groupId>org.apache.shiro</groupId> <artifactId>shiro-web</artifactId> <version>1.1.0</version> </dependency> <dependency> <groupId>org.apache.shiro</groupId> <artifactId>shiro-spring</artifactId> <version>1.1.0</version> </dependency> <dependency> <groupId>org.apache.shiro</groupId> <artifactId>shiro-ehcache</artifactId> <version>1.1.0</version> </dependency> <dependency> <groupId>javassist</groupId> <artifactId>javassist</artifactId> <version>3.9.0.GA</version> </dependency> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-context</artifactId> <version>3.1.1.RELEASE</version> </dependency> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-beans</artifactId> <version>3.1.1.RELEASE</version> </dependency> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-core</artifactId> <version>3.1.1.RELEASE</version> </dependency> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-aop</artifactId> <version>3.1.1.RELEASE</version> </dependency> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-web</artifactId> <version>3.1.1.RELEASE</version> </dependency> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-tx</artifactId> <version>3.1.1.RELEASE</version> </dependency> <dependency> <groupId>commons-dbcp</groupId> <artifactId>commons-dbcp</artifactId> <version>1.4</version> </dependency> <dependency> <groupId>commons-pool</groupId> <artifactId>commons-pool</artifactId> <version>1.5.6</version> </dependency> <dependency> <groupId>aspectj</groupId> <artifactId>aspectjweaver</artifactId> <version>1.5.3</version> </dependency> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-ibatis</artifactId> <version>2.0.8</version> </dependency> <dependency> <groupId>org.apache.ibatis</groupId> <artifactId>ibatis-core</artifactId> <version>3.0</version> </dependency> <dependency> <groupId>oracle.jdbc.driver</groupId> <artifactId>ojdbc14</artifactId> <version>10.1.0.5</version> </dependency> <dependency> <groupId>org.apache.struts</groupId> <artifactId>struts2-json-plugin</artifactId> <version>2.2.3</version> </dependency> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-context-support</artifactId> <version>3.1.1.RELEASE</version> </dependency> <dependency> <groupId>org.apache.poi</groupId> <artifactId>poi</artifactId> <version>3.8-beta5</version> </dependency> <dependency> <groupId>org.apache.poi</groupId> <artifactId>poi-ooxml</artifactId> <version>3.8-beta5</version> </dependency> <dependency> <groupId>org.apache.cxf</groupId> <artifactId>cxf-rt-frontend-jaxws</artifactId> <version>2.4.2</version> </dependency> <dependency> <groupId>org.apache.cxf</groupId> <artifactId>cxf-rt-transports-http</artifactId> <version>2.4.2</version> </dependency> <dependency> <groupId>org.apache.cxf</groupId> <artifactId>cxf-rt-ws-addr</artifactId> <version>2.4.2</version> </dependency> <dependency> <groupId>commons-dbcp</groupId> <artifactId>commons-dbcp</artifactId> <version>1.4</version> </dependency> <dependency> <groupId>commons-pool</groupId> <artifactId>commons-pool</artifactId> <version>1.5.6</version> </dependency> <dependency> <groupId>commons-beanutils</groupId> <artifactId>commons-beanutils</artifactId> <version>1.8.3</version> </dependency> <dependency> <groupId>org.quartz-scheduler</groupId> <artifactId>quartz</artifactId> <version>2.1.3</version> </dependency> <dependency> <groupId>com.zjapl</groupId> <artifactId>APL-SMSSC</artifactId> <version>0.0.3</version> </dependency> <dependency> <groupId>jstl</groupId> <artifactId>jstl</artifactId> <version>1.1.0</version> </dependency> <dependency> <groupId>taglibs</groupId> <artifactId>standard</artifactId> <version>1.1.0</version> </dependency> </dependencies> </project>
3. 对web.xml文件的基本配置(这里只配置了struts2的过滤器等必要的配置,如下:)
<?xml version="1.0" encoding="UTF-8"?> <web-app version="2.4" xmlns="http://java.sun.com/xml/ns/j2ee" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd"> <welcome-file-list> <welcome-file>index.jsp</welcome-file> </welcome-file-list> <context-param> <param-name>contextConfigLocation</param-name> <param-value>/WEB-INF/applicationContext.xml</param-value> </context-param> <listener> <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class> </listener> <filter> <filter-name>struts2</filter-name> <filter-class>org.apache.struts2.dispatcher.FilterDispatcher</filter-class> </filter> <filter-mapping> <filter-name>struts2</filter-name> <url-pattern>/*</url-pattern> </filter-mapping> </web-app>
4. struts.xml配置,放在src目录下;(其实这里你可以先写代码,但为了统一先都把配置文件写出来算了.)
<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE struts PUBLIC "-//Apache Software Foundation//DTD Struts Configuration 2.0//EN" "http://struts.apache.org/dtds/struts-2.0.dtd"> <struts> <!-- 中文防止乱码 --> <constant name="struts.i18n.encoding" value="utf-8"/> <package name="struts2-spring" extends="struts-default"> <!-- 1.Login的Action--> <!-- Login 是Spring注入的LoginAction实例(LoginAction里包含一个LoginService) --> <action name="login" class="com.action.LoginAction" method="login"> <result name="success">openSuccess.jsp</result> <result name="error">loginFail.jsp</result> </action> <action name="logOut" class="com.action.UserManagerAction" method="logOut"><!-- 同一个实例的不同方法 --> <result name="success">index.jsp</result> </action> <!-- 2.Manager的Action--> <action name="register" class="com.action.UserManagerAction" method="register"><!-- UserManager是Spring注入的UserManagerAction实例 --> <result name="success">insersuccess.jsp</result> <result name="error">register.jsp</result> </action> <action name="queryall" class="com.action.UserManagerAction" method="queryall"> <result name="success" type="freemarker">/WEB-INF/html/manager.html</result> </action> <!-- <action name="queryall" class="com.action.UserManagerAction" method="queryall"> <result name="success">manager.jsp</result> </action> --> <action name="update" class="com.action.UserManagerAction" method="update"> <result name="success">update.jsp</result> </action> <action name="delete" class="com.action.UserManagerAction" method="delete"> <result name="success">tdelsuccess.jsp</result> </action> <action name="tfreemarker" class="freemarker.test.TRequest" method="testRequest"> <result name="apl" type="freemarker">/WEB-INF/tfreemarker/scope.html</result> </action> </package> </struts>
5. ibatis的配置文件sqlMap-Config.xml(放在WEB-INF目录)
<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE sqlMapConfig PUBLIC "-//ibatis.apache.org//DTD SQL Map Config 2.0//EN" "http://ibatis.apache.org/dtd/sql-map-config-2.dtd"> <sqlMapConfig> <settings useStatementNamespaces="true"/> <!-- 各个表和类对应的配置,这个不变 --> <!-- 这个resource是指要去哪里找要执行的sql文件,这里是src下com/vo/User_SSI.xml --> <sqlMap resource="com/vo/User_SSI.xml" /> </sqlMapConfig>
6. applicationContext.xml spring配置文件(放在WEB-INF目录)
<?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:context="http://www.springframework.org/schema/context" xmlns:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springframework.org/schema/tx" xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.0.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-3.0.xsd http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-3.0.xsd" default-lazy-init="true"> <!-- 1:配置数据源(从ibatis配置改到spring配置) --> <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close"> <property name="driverClassName" value="oracle.jdbc.driver.OracleDriver" /> <property name="url" value="jdbc:oracle:thin:@192.168.1.196:1521:ORCL" /> <property name="username" value="pdms" /> <property name="password" value="pdms" /> </bean> <!-- 2:spring的ibatis配制,目的是要SqlMapClientTemplate --> <bean id="sqlMapClient" class="org.springframework.orm.ibatis.SqlMapClientFactoryBean"> <property name="configLocation" value="/WEB-INF/sqlMap-Config.xml" /> <property name="dataSource" ref="dataSource" /> </bean> <!-- 3.Spring 注入过程 --> <!-- <bean id="User_SSI" class="com.vo.User_SSI" /> --> <!-- DAOImpl的注入 --> <bean name="userDao" class="com.dao.UserDaoImpl"> <property name="sqlMapClient" ref="sqlMapClient"></property> </bean> <!-- Login的注入 --> <bean name="loginService" class="com.service.LoginService"> <!-- <property name="user" ref="User_SSI"></property> --> <property name="userDao" ref="userDao" /> </bean> <bean name="login" class="com.action.LoginAction"><!-- 产生一个叫Login的实例之前,调用set‘Service’方法,注入上一个实例‘LoginService’ --> <property name="loginService" ref="loginService" /> </bean> <!-- Manager的注入 --> <bean name="managerService" class="com.service.ManagerService"> <!-- <property name="user_SSI" ref="user_SSI"/> --> <property name="userDao" ref="userDao" /> </bean> <bean name="userManager" class="com.action.UserManagerAction"> <property name="managerService" ref="managerService" /> </bean> <!-- 4.事务处理,需要配套的xmlns和schemaLocation --> <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager"> <property name="dataSource" ref="dataSource" /> </bean> <tx:advice id="transactionManagerAdivice" transaction-manager="transactionManager"> <tx:attributes> <tx:method name="query*" propagation="REQUIRED" read-only="true" rollback-for="java.lang.RuntionException" /> <tx:method name="update*" propagation="REQUIRED" rollback-for="java.lang.RuntionException" /> </tx:attributes> </tx:advice> <aop:config> <aop:pointcut id="allManagerMethod" expression="execution( * service.*.*(..))" /> <!-- 执行的范围 --> <aop:advisor advice-ref="transactionManagerAdivice" pointcut-ref="allManagerMethod" /> </aop:config> </beans>
7.ibatis对数据表操作的文件(src下com/vo/User_SSI.xml):
<?xml version="1.0" encoding="UTF-8" ?> <!DOCTYPE sqlMap PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN" "http://ibatis.apache.org/dtd/sql-map-2.dtd"> <sqlMap namespace="User"> <typeAlias alias="User" type="com.vo.User_SSI"/><!-- 别名 --> <resultMap id="UserResult" class="User"> <result property="nuser" column="NUSER" /> <result property="password" column="PASSWORD" /> </resultMap> <select id="getAllUser" resultClass="User" parameterClass="string"> SELECT nuser,password FROM test </select> <select id="selectUserByUsername" parameterClass="string" resultClass="User"> select nuser,password from test where nuser = #nuser# </select> <insert id="insertUser" parameterClass="User"> insert into test (id,nuser,password) values ((select nvl(max(id),0)+1 from test),#nuser#,#password#) </insert> <update id="updateUser" parameterClass="User"> update test set password = #password# where nuser = #nuser# </update> <delete id="deleteUserById" parameterClass="string"> delete from test where nuser = #nuser# </delete> </sqlMap>
------------part 1 End 配置文件完结-------------
发表评论
-
Spring MVC Controller单例陷阱
2014-09-12 10:01 927Spring MVC Controller默认是单例的: 单 ... -
Spring MVC模型(Model)层和视图(View)层
2014-04-20 18:57 0Spring MCV中Model层是View层的数据容器,Js ... -
springMVC 返回类型选择 以及 SpringMVC中model,modelMap.request,session取值顺序
2014-04-20 18:52 3069spring mvc处理方法支持如下的返回方式:ModelAn ... -
spring mvc常用注解@Component @Controller @Service @Repository
2014-03-13 16:10 9182注解用了之后,会在*.xml文件中大大减少配置量。以前我们每个 ... -
applicationContext.xml 配置文件在web.xml中的写法
2014-03-11 16:28 2793applicationContext.xml 配置文件的一些认 ... -
SpringMVC和Struts2的比较
2014-02-27 19:12 748通俗说Spring的作用 Spring ... -
Struts-config.xml配置文件《action-mappings》元素的详解
2014-02-26 13:12 2448action-mappings 该元素用于将Action元素定 ... -
使用Hibernate向mysql数据库中插入中文,数据库中显示??乱码
2014-02-24 23:02 1015[size=medium]通过网上学习,要求修改Hiberna ... -
在web.xml中通过contextConfigLocation配置spring
2014-02-24 21:19 2318在web.xml中通过contextConfigLocatio ... -
Struts-config.xml配置action-mappings元素略计
2014-02-24 16:58 636action-mappings 该元素用于将Action元素 ... -
Spring的DataAccessException略记
2013-07-08 19:23 2458Spring的DAO框架没有抛出 ... -
Result Type(Struts.xml配置)
2013-06-25 08:35 624一个提交到服务器的处理通常可以分为两个阶段: 第一个阶段查询服 ... -
ibatis常用标记略记
2013-06-23 21:12 972isNull判断property字段是否是null,用isEm ... -
ibatis的iterate使用
2013-06-23 20:38 1088ibatis的iterate使用 Iterate:这属性遍历 ... -
Struts2 两个Action之间动态传参
2013-06-21 10:00 1049两个Action 动态传参数 研究了近两天的时间 ... -
spring入门之—第一步
2013-06-13 15:26 723注: 本文用的是spring-framework-3.1.1. ... -
Spring的ApplicationContext加载多个配置文件的三种方式
2013-06-13 15:09 18301.第一种,使用数组方式 ApplicationConte ... -
详解iBaits中SqlMapClientTemplate的使用
2013-06-05 16:07 0pache iBatis(现已迁至Google Code下发展 ... -
Struts2.0默认支持多种格式的result type
2013-06-05 16:00 859<action name="attachmen ... -
maven+ssi对oracle实现增删改查(二)
2013-06-05 12:06 12001.index.jsp访问项目默认页面 <%@ page ...
相关推荐
NULL 博文链接:https://ych0108.iteye.com/blog/1882590
SpringBoot整合MyBatis实现MySQL数据库表增删改查。需使用Maven项目,搭建本地仓库。
spring mvc + mybatis + maven + easyui + oracle 数据库实现增删改查
Maven + Spring +Mysql实现简单增删改查及用户登录,适合初学者。
spring mvc + mybatis + maven + easyui + oracle 数据库实现增删改查;有任何不懂的技术问题都可以联系我共同讨论
IntelliJ IDEA下SpringBoot+Maven+JPA+Thymeleaf整合实现增删改查及分页入门项目实例.zip
springMVC+MyBatis+Oracle+Web实现增删改查完整案例+数据库数据) springMVC+MyBatis+Oracle+Web实现增删改查完整案例+数据库数据)
Maven+spring+ struts2+ Ibatis+mysql整合增删改查
项目已实地运行,只需要修改本地数据库url和根据实体类创建对应的表就可以运行,另表数据不能有null值,否则会运行报错。
本项目使用Maven+SpringBoot+springDataJPA,实现单表的增删改查
使用springmvc+maven做简单的网页增删改查,适合小白借鉴。
Springmvc+maven+ajax+jquery+json+mybatis做的登录,注册,增删改查详细注释,大家可以来一下,看看对自己有没有帮助哈,这是我自己一点点的打的,采用MyEclipse 10运行出来.并且付有sql脚本.可直接导入运行.并且经本人...
使用Idea工具开发,Maven+SpringMVC+Mybatis的增删改查Demo,也是根据网上找的demo,自己亲自动手写的,在编写过程也是遇到了各种小问题,不过都一一处理,里面附带了一个简单文档和建表语句,希望对你有所帮助。...
maven+spring-mvc+spring+mybatis增删改查的小例子
Maven+Spring+SpringMVC+Hibernate实现增删改查的一个小例子。工具是:Eclipse
Spring Boot+MySQL+Mybatis+Maven+IDEA,一个简单的数据库增删改查项目
注意添加数据时候需要按数据库格式添加数据不然会报错
Maven+SpringMVC+Spring+Hibernate简单增删改查(jdk1.8),前端js,jq,ajax都用了, 水平有限,供初学者学习参考。使用增删改查用管理员账号登陆
Maven+Hibernate+mysql增删改查 ,希望对刚学习通许有所帮助