ssh config

<?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>