学步园

导入所有的包

在struts-config.xml中配置
修改action中type为：org.springframework.web.struts.DelegatingActionProxy

<action name="officeForm"<br /> path="/office"<br /> scope="request"<br /> parameter="method"<br /> type="org.springframework.web.struts.DelegatingActionProxy"><br /> <forward name="showAll" path="/showgw.jsp"></forward><br /> <forward name="addtest" path="/office.do?method=showAll"></forward><br /> <forward name="edit" path="/editgw.jsp"></forward><br /> </action>

在最后配置

<plug-in className="org.springframework.web.struts.ContextLoaderPlugIn"><br /> <set-property property="contextConfigLocation" value="classpath:applicationContext.xml" /><br /> </plug-in>

applicationContext.xml配置
applicationContext.xml要放在src目录下，放在别的路径下要修改相应的路径

<!-- 配置一个数据源，根据location去找数据库连接的配置信息 --><br /> <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource"><br /> <property name="driverClassName" value="oracle.jdbc.driver.OracleDriver"></property><br /> <property name="url" value="jdbc:oracle:thin:@192.168.0.45:1521:orcl"/><br /> <property name="username" value="shiqi"/><br /> <property name="password" value="shiqi"/><br /> </bean><br /> <!-- 根据dataSource和configLocations创建一个SqlMapClient --><br /> <bean id="sqlMapClient" class="org.springframework.orm.ibatis.SqlMapClientFactoryBean"><br /> <property name="configLocations" value="classpath:com/zc/struts/ibatis/SqlMapConfig.xml"><br /> <!--“classpath:com/zc/struts/ibatis/SqlMapConfig.xml”为SqlMapConfig.xm的路径--><br /> </property><br /> <property name="dataSource"><br /> <ref bean="dataSource"/><br /> </property><br /> </bean><br /> <!-- DAO层注入 --><br /> <bean id="gwzfDao" class="com.zc.struts.dao.impl.GwzfDAOImpl"><br /> <property name="sqlMapClient"><br /> <ref bean="sqlMapClient"/><br /> </property><br /> <property name="dataSource"><br /> <ref bean="dataSource"/><br /> </property><br /> </bean><br /> <!-- Service层注入 --><br /> <bean id="gwzfService" class="com.zc.struts.service.impl.GwzfServiceImpl"><br /> <property name="gwzfDao" ref="gwzfDao"></property><br /> </bean><br /> <!-- 配置Action 控制bean --><br /> <bean name="/office" class="com.zc.struts.action.OfficeAction"><br /> <property name="gwzfService" ref="gwzfService"></property><br /> </bean>

SqlMapConfig.xml
中的内容为：

<?xml version="1.0" encoding="UTF-8" ?></p> <p><!DOCTYPE sqlMapConfig<br /> PUBLIC "-//ibatis.apache.org//DTD SQL Map Config 2.0//EN"<br /> "http://ibatis.apache.org/dtd/sql-map-config-2.dtd"></p> <p><sqlMapConfig></p> <p><sqlMap resource="com/zc/struts/ibatis/Gwzf.xml"/><br /> </sqlMapConfig>

另一个 ibatis  xml 中的内容为：主要写的是 sql语句

<?xml version="1.0" encoding="UTF-8" ?></p> <p><!DOCTYPE sqlMap<br /> PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN"<br /> "http://ibatis.apache.org/dtd/sql-map-2.dtd"></p> <p><sqlMap namespace="GongWen"></p> <p> <typeAlias alias="Gwzf" type="com.zc.struts.pojo.Gwzf"/><br /> <resultMap id="GwzfRs" class="Gwzf"><br /> <result property="file_id" column="FILE_ID"/><br /> <result property="file_title" column="FILE_TITLE"/><br /> <result property="file_date" column="FILE_DATE"/><br /> <result property="file_wh" column="FILE_WH"/><br /> <result property="file_wh_dw" column="FILE_WH_DW"/><br /> <result property="file_wh_year" column="FILE_WH_YEAR"/><br /> <result property="file_wh_number" column="FILE_WH_NUMBER"/><br /> <result property="file_people_name" column="FILE_PEOPLE_NAME"/><br /> </resultMap></p> <p> <resultMap id="Gwzfid" class="Gwzf"><br /> <result property="file_id" column="FILE_ID"/><br /> </resultMap></p> <p> <select id="selectAllGw" resultMap="GwzfRs">select * from FILEMANAGER_HZC</select></p> <p> <select id="selectById" parameterClass="String" resultMap="GwzfRs"><br /> select * from FILEMANAGER_HZC where FILE_ID = #file_id#<br /> </select></p> <p> <insert id="insertGw" parameterClass="Gwzf"><br /> insert into FILEMANAGER_HZC(FILE_ID,FILE_TITLE,FILE_DATE,FILE_WH,FILE_WH_DW,FILE_WH_YEAR,FILE_WH_NUMBER,FILE_PEOPLE_NAME)<br /> values(<br /> HZC_FILEMANAGER.NEXTVAL,#file_title#,#file_date#,#file_wh#,#file_wh_dw#,#file_wh_year#,#file_wh_number#,#file_people_name#)<br /> </insert></p> <p> <update id="updateGwzf" parameterClass="Gwzf"><br /> update FILEMANAGER_HZC set<br /> FILE_TITLE = #file_title#,<br /> FILE_DATE = #file_date#,<br /> FILE_WH = #file_wh#,<br /> FILE_WH_DW = #file_wh_dw#,<br /> FILE_WH_YEAR = #file_wh_year#,<br /> FILE_WH_NUMBER = #file_wh_number#,<br /> FILE_PEOPLE_NAME = #file_people_name#<br /> where<br /> FILE_ID = #file_id#<br /> </update><br /> <delete id="deleteGwById" parameterClass="String"><br /> delete from FILEMANAGER_HZC where FILE_ID = #id#<br /> </delete><br /> <!-- 检测文号 --><br /> <select id="checkwh" parameterClass="String" resultMap="Gwzfid"><br /> select FILE_ID from FILEMANAGER_HZC where FILE_WH=#filewh#<br /> </select><br /> </sqlMap>