<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns="http://java.sun.com/xml/ns/javaee"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" version="2.5"
xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd">
<context-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath:com/gcg/spring/config/*.xml</param-value>
</context-param>
<filter>
<filter-name>character</filter-name>
<filter-class>
org.springframework.web.filter.CharacterEncodingFilter
</filter-class>
<init-param>
<param-name>encoding</param-name>
<param-value>UTF-8</param-value>
</init-param>
<init-param>
<param-name>forceEncoding</param-name>
<param-value>true</param-value>
</init-param>
</filter>
<filter>
<filter-name>OpenSessionInViewFilter</filter-name>
<filter-class>
org.springframework.orm.hibernate3.support.OpenSessionInViewFilter
</filter-class>
<init-param>
<param-name>sessionFactoryBeanName</param-name>
<param-value>sessionFactoory</param-value>
</init-param>
<init-param>
<param-name>singleSession</param-name>
<param-value>true</param-value>
</init-param>
</filter>
<!-- <filter>
<filter-name>encodeFilter</filter-name>
<filter-class>
com.gcg.utils.SetCharacterEncodingFilter
</filter-class>
<init-param>
<param-name>encoding</param-name>
<param-value>UTF-8</param-value>
</init-param>
<init-param>
<param-name>ignore</param-name>
<param-value>true</param-value>
</init-param>
</filter>
<filter-mapping>
<filter-name>encodeFilter</filter-name>
<url-pattern>*.jsp</url-pattern>
</filter-mapping>
<filter-mapping>
<filter-name>encodeFilter</filter-name>
<url-pattern>*.do</url-pattern>
</filter-mapping>
<filter-mapping>
<filter-name>encodeFilter</filter-name>
<url-pattern>/*</url-pattern>
</filter-mapping>
-->
<servlet>
<servlet-name>action</servlet-name>
<servlet-class>
org.apache.struts.action.ActionServlet
</servlet-class>
<init-param>
<param-name>config</param-name>
<param-value>/WEB-INF/struts-config.xml</param-value>
</init-param>
<init-param>
<param-name>config/class</param-name>
<param-value>/WEB-INF/class/class-config.xml</param-value>
</init-param>
<init-param>
<param-name>config/student</param-name>
<param-value>
/WEB-INF/student/student-config.xml
</param-value>
</init-param>
<init-param>
<param-name>config/teacher</param-name>
<param-value>
/WEB-INF/teacher/teacher-config.xml
</param-value>
</init-param>
<init-param>
<param-name>config/course</param-name>
<param-value>/WEB-INF/course/course-config.xml</param-value>
</init-param>
<init-param>
<param-name>config/stucourse</param-name>
<param-value>
/WEB-INF/stucourse/stucourse-config.xml
</param-value>
</init-param>
<init-param>
<param-name>debug</param-name>
<param-value>3</param-value>
</init-param>
<init-param>
<param-name>detail</param-name>
<param-value>3</param-value>
</init-param>
<load-on-startup>0</load-on-startup>
</servlet>
<servlet>
<servlet-name>SpringContextServlet</servlet-name>
<servlet-class>
org.springframework.web.context.ContextLoaderServlet
</servlet-class>
<load-on-startup>1</load-on-startup>
</servlet>
<servlet-mapping>
<servlet-name>action</servlet-name>
<url-pattern>*.do</url-pattern>
</servlet-mapping>
<filter-mapping>
<filter-name>character</filter-name>
<url-pattern>/*</url-pattern>
</filter-mapping>
<filter-mapping>
<filter-name>OpenSessionInViewFilter</filter-name>
<url-pattern>/*</url-pattern>
</filter-mapping>
<welcome-file-list>
<welcome-file>index.jsp</welcome-file>
</welcome-file-list>
</web-app>
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE struts-config PUBLIC "-//Apache Software Foundation//DTD Struts Configuration 1.2//EN" "http://struts.apache.org/dtds/struts-config_1_2.dtd">
<struts-config>
<data-sources />
<form-beans>
<form-bean name="studentForm"
type="com.gcg.struts.form.StudentForm" />
</form-beans>
<action-mappings>
<action attribute="studentForm" input="/student/addstudentForward.do"
name="studentForm" path="/addstudent" scope="request"
type="org.springframework.web.struts.DelegatingActionProxy"
parameter="add">
<forward name="studentlist" path="/studentlist.do"
redirect="true" />
</action>
<action path="/delstudent"
type="org.springframework.web.struts.DelegatingActionProxy"
parameter="delete">
<forward name="studentlist" path="/studentlist.do"
redirect="true" />
</action>
<action path="/studentlist"
type="org.springframework.web.struts.DelegatingActionProxy"
parameter="list">
<forward name="studentlist" path="/studentList.jsp" />
</action>
<action path="/modifystudent"
type="org.springframework.web.struts.DelegatingActionProxy"
parameter="modify">
<forward name="student" path="/modifystudent.jsp" />
</action>
<action attribute="studentForm"
input="/modifystudent.jsp" name="studentForm"
path="/modifystudentsubmit" scope="request"
type="org.springframework.web.struts.DelegatingActionProxy"
parameter="modifysubmit">
<forward name="studentlist" path="/studentlist.do"
redirect="true" />
</action>
<action path="/addstudentForward"
type="org.springframework.web.struts.DelegatingActionProxy"
parameter="addstudentForwad">
<forward name="addstudentforward"
path="/addstudent.jsp" />
</action>
</action-mappings>
<!-- <controller
processorClass="org.springframework.web.struts.DelegatingRequestProcessor" />
<message-resources parameter="com.gcg.struts.ApplicationResources" />-->
<!--<plug-in
className="org.springframework.web.struts.ContextLoaderPlugIn">
<set-property property="contextConfigLocation"
value="/WEB-INF/classes/applicationContext.xml" />
</plug-in>
-->
</struts-config>
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE struts-config PUBLIC "-//Apache Software Foundation//DTD Struts Configuration 1.2//EN" "http://struts.apache.org/dtds/struts-config_1_2.dtd">
<struts-config>
<data-sources />
<form-beans>
<form-bean name="courseForm"
type="com.gcg.struts.form.CourseForm" />
</form-beans>
<action-mappings>
<action attribute="courseForm" input="/course/addCourseForward.do"
name="courseForm" path="/addcourse" scope="request"
type="org.springframework.web.struts.DelegatingActionProxy"
parameter="add">
<forward name="courselist" path="/courselist.do"
redirect="true" />
</action>
<action path="/delcourse"
type="org.springframework.web.struts.DelegatingActionProxy"
parameter="delete">
<forward name="courselist" path="/courselist.do"
redirect="true" />
</action>
<action path="/courselist"
type="org.springframework.web.struts.DelegatingActionProxy"
parameter="list">
<forward name="courselist" path="/courseList.jsp" />
</action>
<action path="/modifycourse"
type="org.springframework.web.struts.DelegatingActionProxy"
parameter="modify">
<forward name="course" path="/modifycourse.jsp" />
</action>
<action attribute="courseForm"
input="/modifycourse.jsp" name="courseForm"
path="/modifycoursesubmit" scope="request"
type="org.springframework.web.struts.DelegatingActionProxy"
parameter="modifysubmit">
<forward name="courselist" path="/courselist.do"
redirect="true" />
</action>
<action path="/addCourseForward"
type="org.springframework.web.struts.DelegatingActionProxy"
parameter="addCourseForwad">
<forward name="addcourseforward"
path="/addcourse.jsp" />
</action>
</action-mappings>
<!-- <controller
processorClass="org.springframework.web.struts.DelegatingRequestProcessor" />
<message-resources parameter="com.gcg.struts.ApplicationResources" />-->
<!--<plug-in
className="org.springframework.web.struts.ContextLoaderPlugIn">
<set-property property="contextConfigLocation"
value="/WEB-INF/classes/applicationContext.xml" />
</plug-in>
-->
</struts-config>
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE struts-config PUBLIC "-//Apache Software Foundation//DTD Struts Configuration 1.2//EN" "http://struts.apache.org/dtds/struts-config_1_2.dtd">
<struts-config>
<data-sources />
<form-beans>
<form-bean name="courseForm"
type="com.gcg.struts.form.CourseForm" />
</form-beans>
<action-mappings>
<action attribute="courseForm" input="/course/addCourseForward.do"
name="courseForm" path="/addcourse" scope="request"
type="org.springframework.web.struts.DelegatingActionProxy"
parameter="add">
<forward name="courselist" path="/courselist.do"
redirect="true" />
</action>
<action path="/delcourse"
type="org.springframework.web.struts.DelegatingActionProxy"
parameter="delete">
<forward name="courselist" path="/courselist.do"
redirect="true" />
</action>
<action path="/courselist"
type="org.springframework.web.struts.DelegatingActionProxy"
parameter="list">
<forward name="courselist" path="/courseList.jsp" />
</action>
<action path="/modifycourse"
type="org.springframework.web.struts.DelegatingActionProxy"
parameter="modify">
<forward name="course" path="/modifycourse.jsp" />
</action>
<action attribute="courseForm"
input="/modifycourse.jsp" name="courseForm"
path="/modifycoursesubmit" scope="request"
type="org.springframework.web.struts.DelegatingActionProxy"
parameter="modifysubmit">
<forward name="courselist" path="/courselist.do"
redirect="true" />
</action>
<action path="/addCourseForward"
type="org.springframework.web.struts.DelegatingActionProxy"
parameter="addCourseForwad">
<forward name="addcourseforward"
path="/addcourse.jsp" />
</action>
</action-mappings>
<!-- <controller
processorClass="org.springframework.web.struts.DelegatingRequestProcessor" />
<message-resources parameter="com.gcg.struts.ApplicationResources" />-->
<!--<plug-in
className="org.springframework.web.struts.ContextLoaderPlugIn">
<set-property property="contextConfigLocation"
value="/WEB-INF/classes/applicationContext.xml" />
</plug-in>
-->
</struts-config>
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE struts-config PUBLIC "-//Apache Software Foundation//DTD Struts Configuration 1.2//EN" "http://struts.apache.org/dtds/struts-config_1_2.dtd">
<struts-config>
<form-beans>
<form-bean name="classForm"
type="com.gcg.struts.form.ClassForm" />
</form-beans>
<action-mappings>
<action input="/addclass.jsp" name="classForm"
attribute="classForm" path="/class/add" scope="request"
type="org.springframework.web.struts.DelegatingActionProxy"
parameter="add">
<forward name="list" path="/class/list.do" redirect="true" />
</action>
<action path="/list"
type="org.springframework.web.struts.DelegatingActionProxy"
parameter="list">
<forward name="classList" path="/classList.jsp" />
</action>
<action path="/delete"
type="org.springframework.web.struts.DelegatingActionProxy"
parameter="delete">
<forward name="classList" path="/classList.jsp" />
</action>
<action attribute="classForm" path="/modify"
input="/modifyclass.jsp"
type="org.springframework.web.struts.DelegatingActionProxy"
parameter="modify">
<forward name="modify" path="/modifyclass.jsp" />
</action>
<action path="/modifySubmit"
input="/modifyclass.jsp" name="classForm"
type="org.springframework.web.struts.DelegatingActionProxy"
parameter="modifySubmit">
<forward name="classList" path="/classList.jsp" />
</action>
</action-mappings>
<!--<controller
processorClass="org.springframework.web.struts.DelegatingRequestProcessor" />
<message-resources parameter="com.gcg.struts.ApplicationResources" />
<plug-in
className="org.springframework.web.struts.ContextLoaderPlugIn">
<set-property property="contextConfigLocation"
value="/WEB-INF/classes/applicationContext.xml" />
</plug-in>-->
</struts-config>
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.5.xsd">
<bean name="datesource"
class="org.apache.commons.dbcp.BasicDataSource">
<property name="driverClassName"
value="oracle.jdbc.driver.OracleDriver">
</property>
<property name="url"
value="jdbc:oracle:thin:@127.0.0.1:1521:gcg">
</property>
<property name="username" value="system"></property>
<property name="password" value="gcg1234"></property>
</bean>
<bean id="sessionFactoory"
class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
<property name="dataSource">
<ref bean="datesource" />
</property>
<property name="hibernateProperties">
<props>
<prop key="hibernate.dialect">
org.hibernate.dialect.Oracle9Dialect
</prop>
<prop key="hibernate.show_sql">true</prop>
<prop key="connection.characterEncoding">UTF-8</prop>
</props>
</property>
<property name="mappingResources">
<list>
<value>com/gcg/entity/Classinfo.hbm.xml</value>
<value>com/gcg/entity/Student.hbm.xml</value>
<value>com/gcg/entity/Course.hbm.xml</value>
<value>com/gcg/entity/StuCourse.hbm.xml</value>
<value>com/gcg/entity/Teacher.hbm.xml</value></list>
</property>
</bean>
<bean name="transactionManager"
class="org.springframework.orm.hibernate3.HibernateTransactionManager">
<property name="sessionFactory">
<ref local="sessionFactoory" />
</property>
</bean>
<bean name="hibernateTemplate"
class="org.springframework.orm.hibernate3.HibernateTemplate">
<property name="sessionFactory" ref="sessionFactoory" />
</bean>
<bean name="txProxyTemplate" abstract="true"
class="org.springframework.transaction.interceptor.TransactionProxyFactoryBean">
<property name="transactionManager">
<ref bean="transactionManager" />
</property>
<property name="transactionAttributes">
<props>
<prop key="get*">PROPAGATION_REQUIRED,readOnly,-Exception</prop>
<prop key="query*">PROPAGATION_REQUIRED,readOnly,-Exception</prop>
<prop key="add*">PROPAGATION_REQUIRED,-Exception</prop>
<prop key="mdodify*">PROPAGATION_REQUIRED,-Exception</prop>
<prop key="del*">PROPAGATION_REQUIRED,-Exception</prop>
<prop key="update*">PROPAGATION_REQUIRED,-Exception</prop>
</props>
</property>
</bean>
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.5.xsd">
<bean name="ClassinfoDAO" class="com.gcg.dao.ClassinfoDAO">
<property name="sessionFactory">
<ref bean="sessionFactoory" />
</property>
</bean>
<bean name="classinfoService"
class="com.gcg.service.impl.ClassinfoService">
<property name="claDao">
<ref bean="ClassinfoDAO" />
</property>
</bean>
<bean id="classinfoServiceproxy" parent="txProxyTemplate">
<property name="target">
<ref bean="classinfoService" />
</property>
</bean>
<!-- class action path -->
<bean name="/class/add"
class="com.gcg.struts.action.course.ClasslistAction">
<property name="cl">
<ref bean="classinfoServiceproxy" />
</property>
</bean>
<bean name="/class/list"
class="com.gcg.struts.action.course.ClasslistAction">
<property name="cl">
<ref bean="classinfoServiceproxy" />
</property>
</bean>
<bean name="/class/delete"
class="com.gcg.struts.action.course.ClasslistAction">
<property name="cl">
<ref bean="classinfoServiceproxy" />
</property>
</bean>
<bean name="/class/modify"
class="com.gcg.struts.action.course.ClasslistAction">
<property name="cl">
<ref bean="classinfoServiceproxy" />
</property>
</bean>
<bean name="/class/modifySubmit"
class="com.gcg.struts.action.course.ClasslistAction">
<property name="cl">
<ref bean="classinfoServiceproxy" />
</property>
</bean>
</beans>
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.5.xsd">
<bean id="courseDao" class="com.gcg.dao.CourseDAO">
<property name="sessionFactory">
<ref bean="sessionFactoory" />
</property>
</bean>
<bean id="courseService" class="com.gcg.service.impl.CourseService">
<property name="courseDAO" ref="courseDao"></property>
</bean>
<bean id="courseServiceProxy" parent="txProxyTemplate">
<property name="target">
<ref bean="courseService" />
</property>
</bean>
<!-- course operate action -->
<bean name="/course/addcourse" class="com.gcg.struts.action.course.CourseAction">
<property name="courseService">
<ref bean="courseServiceProxy"/>
</property>
<property name="teacherService" ref="teacherServiceProxy" />
</bean>
<bean name="/course/modifycoursesubmit" class="com.gcg.struts.action.course.CourseAction">
<property name="courseService">
<ref bean="courseServiceProxy"/>
</property>
<property name="teacherService" ref="teacherServiceProxy" />
</bean>
<bean name="/course/courselist" class="com.gcg.struts.action.course.CourseAction">
<property name="courseService">
<ref bean="courseServiceProxy"/>
</property>
<property name="teacherService" ref="teacherServiceProxy" />
</bean>
<bean name="/course/delcourse" class="com.gcg.struts.action.course.CourseAction">
<property name="courseService">
<ref bean="courseServiceProxy"/>
</property>
<property name="teacherService" ref="teacherServiceProxy" />
</bean>
<bean name="/course/modifycourse" class="com.gcg.struts.action.course.CourseAction">
<property name="courseService">
<ref bean="courseServiceProxy"/>
</property>
<property name="teacherService" ref="teacherServiceProxy" />
</bean>
<bean name="/course/addCourseForward" class="com.gcg.struts.action.course.CourseAction">
<property name="courseService">
<ref bean="courseServiceProxy"/>
</property>
<property name="teacherService" ref="teacherServiceProxy" />
</bean>
</beans>
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.5.xsd">
<bean id="stucourseDao" class="com.gcg.dao.StuCourseDAO">
<property name="sessionFactory">
<ref bean="sessionFactoory" />
</property>
</bean>
<bean id="stucourseService"
class="com.gcg.service.impl.StuCourseService">
<property name="stuCourseDAO" ref="stucourseDao"></property>
</bean>
<bean id="stucourseServiceProxy" parent="txProxyTemplate">
<property name="target">
<ref bean="stucourseService" />
</property>
</bean>
<!-- stucourse operate action -->
<bean name="/stucourse/addstucourse"
class="com.gcg.struts.action.stucourse.StuCourseAction">
<property name="stucourseService" ref="stucourseServiceProxy" />
<property name="courseService" ref="courseServiceProxy" />
<property name="studentService"
ref="studentServiceServiceproxy" />
</bean>
<bean name="/stucourse/modifystucoursesubmit"
class="com.gcg.struts.action.stucourse.StuCourseAction">
<property name="stucourseService" ref="stucourseServiceProxy" />
<property name="courseService" ref="courseServiceProxy" />
<property name="studentService"
ref="studentServiceServiceproxy" />
</bean>
<bean name="/stucourse/stucourselist"
class="com.gcg.struts.action.stucourse.StuCourseAction">
<property name="stucourseService" ref="stucourseServiceProxy" />
<property name="courseService" ref="courseServiceProxy" />
<property name="studentService"
ref="studentServiceServiceproxy" />
</bean>
<bean name="/stucourse/delstucourse"
class="com.gcg.struts.action.stucourse.StuCourseAction">
<property name="stucourseService" ref="stucourseServiceProxy" />
<property name="courseService" ref="courseServiceProxy" />
<property name="studentService"
ref="studentServiceServiceproxy" />
</bean>
<bean name="/stucourse/modifystucourse"
class="com.gcg.struts.action.stucourse.StuCourseAction">
<property name="stucourseService" ref="stucourseServiceProxy" />
<property name="courseService" ref="courseServiceProxy" />
<property name="studentService"
ref="studentServiceServiceproxy" />
</bean>
<bean name="/stucourse/addstucourseForward"
class="com.gcg.struts.action.stucourse.StuCourseAction">
<property name="stucourseService" ref="stucourseServiceProxy" />
<property name="courseService" ref="courseServiceProxy" />
<property name="studentService"
ref="studentServiceServiceproxy" />
</bean>
</beans>
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.5.xsd">
<bean name="StudentDAO" class="com.gcg.dao.StudentDAO">
<property name="sessionFactory">
<ref bean="sessionFactoory" />
</property>
</bean>
<bean name="studentService" class="com.gcg.service.impl.StudentService">
<property name="studentDAO">
<ref bean="StudentDAO"/>
</property>
</bean>
<bean id="studentServiceServiceproxy" parent="txProxyTemplate">
<property name="target">
<ref bean="studentService" />
</property>
</bean>
<!-- student operate action -->
<bean name="/student/addstudent" class="com.gcg.struts.action.student.StudentAction">
<property name="classService">
<ref bean="classinfoServiceproxy"/>
</property>
<property name="studentService">
<ref bean="studentServiceServiceproxy"/>
</property>
</bean>
<bean name="/student/modifytudentsubmit" class="com.gcg.struts.action.student.StudentAction">
<property name="classService">
<ref bean="classinfoServiceproxy"/>
</property>
<property name="studentService">
<ref bean="studentServiceServiceproxy"/>
</property>
</bean>
<bean name="/student/studentlist" class="com.gcg.struts.action.student.StudentAction">
<property name="classService">
<ref bean="classinfoServiceproxy"/>
</property>
<property name="studentService">
<ref bean="studentServiceServiceproxy"/>
</property>
</bean>
<bean name="/student/delstudent" class="com.gcg.struts.action.student.StudentAction">
<property name="classService">
<ref bean="classinfoServiceproxy"/>
</property>
<property name="studentService">
<ref bean="studentServiceServiceproxy"/>
</property>
</bean>
<bean name="/student/modifystudent" class="com.gcg.struts.action.student.StudentAction">
<property name="classService">
<ref bean="classinfoServiceproxy"/>
</property>
<property name="studentService">
<ref bean="studentServiceServiceproxy"/>
</property>
</bean>
<bean name="/student/addStudenForward" class="com.gcg.struts.action.student.AddStudenForwardAction">
<property name="classInfo">
<ref bean="classinfoServiceproxy"/>
</property>
</bean>
</beans>
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.5.xsd">
<bean id="teacherDao" class="com.gcg.dao.TeacherDAO">
<property name="sessionFactory">
<ref bean="sessionFactoory" />
</property>
</bean>
<bean id="teacherService" class="com.gcg.service.impl.TeacherService">
<property name="teaDao" ref="teacherDao"></property>
</bean>
<bean id="teacherServiceProxy" parent="txProxyTemplate">
<property name="target">
<ref bean="teacherService" />
</property>
</bean>
<!-- teacher operate action -->
<bean name="/teacher/addteacher" class="com.gcg.struts.action.teacher.TeacherAction">
<property name="teacherService">
<ref bean="teacherServiceProxy"/>
</property>
</bean>
<bean name="/teacher/modifyteachersubmit" class="com.gcg.struts.action.teacher.TeacherAction">
<property name="teacherService">
<ref bean="teacherServiceProxy"/>
</property>
</bean>
<bean name="/teacher/teacherlist" class="com.gcg.struts.action.teacher.TeacherAction">
<property name="teacherService">
<ref bean="teacherServiceProxy"/>
</property>
</bean>
<bean name="/teacher/delteacher" class="com.gcg.struts.action.teacher.TeacherAction">
<property name="teacherService">
<ref bean="teacherServiceProxy"/>
</property>
</bean>
<bean name="/teacher/modifyteacher" class="com.gcg.struts.action.teacher.TeacherAction">
<property name="teacherService">
<ref bean="teacherServiceProxy"/>
</property>
</bean>
CREATE SEQUENCE SEQ_COURSE INCREMENT BY 1 NOMINVALUE NOMAXVALUE CACHE 20 NOCYCLE NOORDER;
CREATE SEQUENCE SEQ_STUDENT INCREMENT BY 1 NOMINVALUE NOMAXVALUE CACHE 20 NOCYCLE NOORDER;
CREATE SEQUENCE SEQ_CLASSINFO INCREMENT BY 1 NOMINVALUE NOMAXVALUE CACHE 20 NOCYCLE NOORDER;
CREATE SEQUENCE SEQ_STU_CORSE INCREMENT BY 1 NOMINVALUE NOMAXVALUE CACHE 20 NOCYCLE NOORDER;
CREATE SEQUENCE SEQ_TEACHER INCREMENT BY 1 NOMINVALUE NOMAXVALUE CACHE 20 NOCYCLE NOORDER;
SELECT SEQ_COURSE.NEXTVAL , SEQ_COURSE.CURRVAL FROM DUAL;
--DROP SEQUENCE SEQ_COURSE
CREATE TABLE COURSE
(
CU_ID NUMBER(10,0) ,
CU_NAME VARCHAR2(50) NOT NULL ,
CU_IS_USED NUMBER(1) DEFAULT 1
);
CREATE TABLE TEACHER
(
TEA_ID NUMBER(10) ,
TEA_NAME VARCHAR2(50) NOT NULL,
TEA_IS_RETIRED NUMBER(1) DEFAULT 1
);
/**
ALTER TABLE TEACHER ADD TEA_JOINTIME DATE DEFAULT SYSDATE
ALTER TABLE COURSE ADD TEA_ID NUMBER(10);
ALTER TABLE TEACHER ADD CONSTRAINTS PK_TEACHER PRIMARY KEY (TEA_ID)
ALTER TABLE COURSE ADD CONSTRAINTS FK_REF_PK_TEACHER FOREIGN KEY (TEA_ID) REFERENCES TEACHER(TEA_ID)
--ALTER TABLE COURSE ADD CONSTRAINTS PK_COURSE PRIMARY KEY (CU_ID);*/
--ALTER TABLE COURSE MODIFY CU_ID NUMBER(10)
/**
ALTER TABLE COURSE RENAME COLUMN CU_IS_USED TO IS_USED*/
CREATE TABLE STUDENT
(
ST_ID NUMBER(10) ,
SU_NAME VARCHAR2(50) NOT NULL ,
IS_GRAD NUMBER(1) DEFAULT 0
);
/**
ALTER TABLE STUDENT ADD CLAS_ID NUMBER(10);
ALTER TABLE STUDENT ADD CONSTRAINTS RF_CLAS_ID FOREIGN KEY (CLAS_ID) REFERENCES CLASSINFO(CLA_ID)
*/
--ALTER TABLE STUDENT ADD CONSTRAINTS PK_STUDENT PRIMARY KEY (ST_ID);
CREATE TABLE CLASSINFO
(
CLA_ID NUMBER(10),
CLA_NAME VARCHAR2(50) NOT NULL ,
IS_GRAD NUMBER(1) DEFAULT 0
);
--ALTER TABLE CLASSINFO ADD CONSTRAINTS PK_CLASSINFO PRIMARY KEY (CLA_ID);
CREATE TABLE STU_CORSE
(
ST_ID NUMBER(10) ,
CU_ID NUMBER(10),
REMARK VARCHAR2(500)
) ;
/**
ALTER TABLE STU_COURSE ADD ST_CU_ID NUMBER(10)
ALTER TABLE STU_COURSE ADD CONSTRAINTS PK_STU_COU PRIMARY KEY (ST_CU_ID)
*/
--ALTER TABLE STU_COURSE ADD CONSTRAINTS NOT NULL ON REMARK
--ALTER TABLE STU_COURSE MODIFY REMARK NOT NULL
/**
ALTER TABLE STU_CORSE RENAME TO STU_COURSE
ALTER TABLE STU_COURSE ADD CONSTRAINTS RF_STU FOREIGN KEY (ST_ID) REFERENCES STUDENT(ST_ID) ;
ALTER TABLE STU_COURSE ADD CONSTRAINTS RF_CU FOREIGN KEY (CU_ID) REFERENCES COURSE(CU_ID)
*/
</beans> </beans>
分享到:
相关推荐
Go-sshconfig是一个专门用于解析`ssh_config`文件的Go语言库。`ssh_config`文件是OpenSSH客户端的配置文件,用于定义连接到远程主机时的参数和行为。这个库的目的是使开发者能够方便地在Go应用程序中读取、理解和...
SSH Config Editor是一款方便的SSH客户端配置文件管理工具,您可以添加或编辑身份文件,端口转发(使用图形预览)和任何其他ssh配置选项。 特性: 通过在文件对话框中选择身份文件添加/更改身份文件。 使用图形...
sshconfig的: ssc 在$ HOME / .ssh / config中添加/删除/列出ssh别名的最小命令要做出贡献,请分叉添加您的代码并提出拉取请求。 随时添加新的有用的东西安装SSC在Linux,BSD和OSX上可用curl -L ...
快速上手Linux 玩转典型应用,第一张导学内容,主要介绍linux的主要应用范围,linux整个课程安排及详细讲解,第三、四章 前期准备工作,虚拟机是什么?虚拟机中安装linux系统,云服务器介绍。第五章 SSH使用
SSH-配置:一个工具,用于管理的ssh配置文件 概述 每次主机更改时更新您的 .ssh/config 文件并没有那么麻烦,但是当它开始频繁发生时,即使是这种麻烦也开始增加。 这是我写来帮助处理这些问题的快速工具。 非常小心...
用于golang的OpenSSH配置解析器 解析...用法用法示例package mainimport ( "fmt" "github.com/mikkeloscar/sshconfig")func main () { hosts , err := ParseSSHConfig ( "/path/to/ssh_config" ) if err != nil { fmt
ssh_config 希望对你有用!
使用Go编写的用于管理〜/ .ssh / config的命令行工具。 受项目启发。 指数 安装 随着去 go get -u github.com/nicolascb/nssh 手动的 指令 USAGE: nssh [global options] command [command options] [arguments....
SSH Config Editor Mac版是一款macOS平台的ssh配置文件管理工具,SSH Config Editor Mac版可以帮助我们在 mac电脑上管理ssh配置文件,我们可以通过这款软件添加或是修改SSH配置文件、添加或是修改端口转发规则、RSA...
基本 VIM 命令 / Bash 配置文件 / SSH 配置我整理这份指南是为了让事情变得更容易,因为让我们面对现实,没有人愿意在每次登录服务器时都输入“ssh root@yoursuperlongurl”。 本自述文件将涵盖一些简单的 vim 命令...
`.sshconfig`文件的结构通常如下: ```ini Host webserver HostName 192.168.1.100 User root Port 22 IdentityFile ~/.ssh/id_rsa ``` 书签管理器通过解析这样的配置格式,实现了对书签的管理。在elementary...
debug: SshConfig/sshconfig.c:3130/ssh_config_read_file_ext: Read 17 params from config file. debug: Ssh2/ssh2.c:1707/main: User config file not found, using defaults. (Looked for /home/jsmith/.ssh2/...
标题中的“ssh继承”指的是在IT领域中一种常见的企业级应用开发框架组合,即Struts2、Spring和Hibernate的集成。这个集成通常被称为SSH框架,它允许开发者利用这些组件的协同工作来构建高效、可维护的Java Web应用...
2. **配置SSH测试元素**:在JMeter测试计划中,添加一个"SSH Test Element",如"SSH Sampler"或"SSH Config Element"。配置包括服务器的IP地址、端口号、用户名、密码或私钥路径等连接信息。 3. **执行远程命令**:...
SSH Config Editor Pro 是一款用于管理OpenSSH ssh客户端配置文件的工具。使用SSH Config Editor Pro您可以管理您的SSH配置文件和known_hosts中文件。您可以添加或编辑身份,端口转发和任何其他ssh配置选项。以一种...
simple_ssh_config 为用户列表创建一个简单的〜/ .ssh / config 要求 没有。 角色变量 - role: 'simple_ssh_config' list_of_users: - name: "{{ ansible_user }}" home: "/home/{{ ansible_user }}" list_of_...
grunt-ssh, SSH,Grunt的SFTP任务 新主人 启动 12 -23-2015,我正站在两个巨人( @chuckmo和 @andrewrjones) 作为这个项目维护者的肩膀上) 。 欢迎捐赠,如往常。 ( 这里消息也将在下一次发布时删除) 。静音 ssh
aws-ssh-config, 从 AWS EC2清单生成SSH配置文件 aws-ssh-config描述使用boto查询 AWS API并生成一个准备使用的SSH配置文件的非常简单的脚本。 有几个类似的脚本,但我找不到一个能够满足我所有的愿望列表:立即连接...
Their offer: ssh-rsa.... 解决方法: 1、出现该问题可下载本配置文件,解压后放在C:\Users\xxxx\.ssh目录下。(xxxx是用户名) 2、若是报错类型是ssh-dss,则将配置文件中的rsa更换为dss即可。
public class SSHConfig { @Value("${ssh.host}") private String host; @Value("${ssh.port}") private int port; @Value("${ssh.username}") private String username; @Value("${ssh.password}") ...