2.web.xml
1 <?xml version="1.0" encoding="UTF-8"?>
2 <web-app version="2.5" xmlns="http://java.sun.com/xml/ns/javaee"
3 xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
4 xsi:schemaLocation="http://java.sun.com/xml/ns/javaee
5 http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd">
6
7
8 <!-- spring鐩戝惉鍣紝鐩戝惉springMvc鐜 -->
9 <listener>
10 <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
11 </listener>
12 <!-- 鍔犺澆spring鐨勯厤緗枃浠?nbsp;-->
13 <context-param>
14 <param-name>contextConfigLocation</param-name>
15 <param-value>/WEB-INF/springmvc-servlet.xml</param-value>
16 </context-param>
17 <!-- 閰嶇疆Spring MVC DispatcherServlet -->
18 <servlet>
19 <servlet-name>springmvc</servlet-name>
20 <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
21 <load-on-startup>2</load-on-startup>
22 </servlet>
23 <servlet-mapping>
24 <servlet-name>springmvc</servlet-name>
25 <url-pattern>*.do</url-pattern>
26 </servlet-mapping>
27 </web-app>
2 <web-app version="2.5" xmlns="http://java.sun.com/xml/ns/javaee"
3 xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
4 xsi:schemaLocation="http://java.sun.com/xml/ns/javaee
5 http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd">
6
7
8 <!-- spring鐩戝惉鍣紝鐩戝惉springMvc鐜 -->
9 <listener>
10 <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
11 </listener>
12 <!-- 鍔犺澆spring鐨勯厤緗枃浠?nbsp;-->
13 <context-param>
14 <param-name>contextConfigLocation</param-name>
15 <param-value>/WEB-INF/springmvc-servlet.xml</param-value>
16 </context-param>
17 <!-- 閰嶇疆Spring MVC DispatcherServlet -->
18 <servlet>
19 <servlet-name>springmvc</servlet-name>
20 <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
21 <load-on-startup>2</load-on-startup>
22 </servlet>
23 <servlet-mapping>
24 <servlet-name>springmvc</servlet-name>
25 <url-pattern>*.do</url-pattern>
26 </servlet-mapping>
27 </web-app>
3
]]>
<insert id="addStudent" parameterType="Student" keyProperty="id">
insert into student(id,name,birth,score)
values(#{id},#{name},#{birth},#{score});
<selectKey resultType="int" keyProperty="id">
SELECT
LAST_INSERT_ID() AS VALUE
</selectKey>
</insert>
2.SQLServer:
2.SQLServer:
<insert id="addStudent" parameterType="Student" keyProperty="id">
insert into student(name,birth,score)
values(#{#{name},#{birth},#{score});
<selectKey resultType="int" keyProperty="id">
SELECT STOCKIDSEQUENCE.NEXTVAL AS VALUE FROM DUAL
</selectKey>
</insert>
3.Oracle:
3.Oracle:
<insert id="addStudent" parameterType="Student" keyProperty="id">
insert into student(name,birth,score)
values(#{#{name},#{birth},#{score});
<selectKey resultType="int" keyProperty="id">
select @@identity as inserted
</selectKey>
</insert>
]]>
Messsage: HTTP method GET is not supported by this URL
Description: The specified HTTP method is not allowed for the requested resource.
閿欒鍘熷洜錛?br /> 1.緇ф壙鑷狧ttpServlet鐨凷ervlet娌℃湁閲嶅啓瀵逛簬璇鋒眰鍜屽搷搴旂殑澶勭悊鏂規硶錛歞oGet鎴杁oPost絳夋柟娉曪紱榛樿璋冪敤鐖剁被鐨刣oGet鎴杁oPost絳夋柟娉曪紱
2.鐖剁被HttpServlet鐨刣oGet鎴杁oPost絳夋柟娉曡鐩栦簡浣犻噸鍐欑殑doGet鎴杁oPost絳夋柟娉曪紱
鐖剁被HttpServlet鐨刣oGet鎴杁oPost絳夋柟娉曠殑榛樿瀹炵幇鏄繑鍥炵姸鎬佷唬鐮佷負405鐨凥TTP閿欒琛ㄧず瀵逛簬鎸囧畾璧勬簮鐨勮姹傛柟娉曚笉琚厑璁搞?br />瑙ｅ喅鏂規硶錛?br /> 1.瀛愮被閲嶅啓doGet鎴杁oPost絳夋柟娉曪紱
2.鍦ㄤ綘鎵╁睍鐨凷ervlert涓噸鍐檇oGet鎴杁oPost絳夋柟娉曟潵澶勭悊璇鋒眰鍜屽搷搴旀椂 涓嶈璋冪敤鐖剁被HttpServlet鐨刣oGet鎴杁oPost絳夋柟娉曪紝鍗沖幓鎺塻uper.doGet(request, response)鍜? super.doPost(request, response)銆?br /> 濡傛灉瀛愮被浠呬粎閲嶅啓鐨勬槸doGet鎴杁oPost鍏朵腑涓涓柟娉曪紝鑰屾病鏈夊彟涓涓柟娉曪紝涔熶細鎶?05閿欒
]]>