{"id":5345,"date":"2024-09-19T07:01:01","date_gmt":"2024-09-18T23:01:01","guid":{"rendered":""},"modified":"2024-09-19T07:01:01","modified_gmt":"2024-09-18T23:01:01","slug":"\u57fa\u4e8ejava\u7684\u65c5\u6e38\u7ba1\u7406\u7cfb\u7edf_\u9879\u76ee\u7ba1\u7406\u7cfb\u7edf\u6e90\u7801JAVA","status":"publish","type":"post","link":"https:\/\/mushiming.com\/5345.html","title":{"rendered":"\u57fa\u4e8ejava\u7684\u65c5\u6e38\u7ba1\u7406\u7cfb\u7edf_\u9879\u76ee\u7ba1\u7406\u7cfb\u7edf\u6e90\u7801JAVA"},"content":{"rendered":"<p><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"display: none;\"> \n <path stroke-linecap=\"round\" d=\"M5,0 0,2.5 5,5z\" id=\"raphael-marker-block\" style=\"-webkit-tap-highlight-color: rgba(0, 0, 0, 0);\"><\/path> \n<\/svg> <\/p>\n<div class=\"toc\">\n<h4>\u4ea7\u54c1\u7ba1\u7406\u9875\u9762<\/h4>\n<ul>\n<li>\u9875\u9762\u4ecb\u7ecd<\/li>\n<li>\u540e\u53f0\u4ee3\u7801<\/li>\n<li>\n<ul>\n<li>\u4f9d\u8d56\u5b89\u88c5\uff08pom.xml\uff09<\/li>\n<li>\u9879\u76ee\u8d44\u6e90\u914d\u7f6e\uff08resource\uff09<\/li>\n<li>\n<ul>\n<li>applicationContext.xml<\/li>\n<li>db.properties<\/li>\n<li>log4j.properties<\/li>\n<li>springmvc.xml<\/li>\n<li>spy.properties<\/li>\n<\/ul>\n<\/li>\n<li>SSM\u67b6\u6784\uff08Model\u3001Controller\u3001View\uff09<\/li>\n<li>\n<ul>\n<li>\u6570\u636e\u5e93\u5c01\u88c5\u7c7b\uff08entity\uff09<\/li>\n<li>\u6570\u636e\u5e93\u64cd\u4f5c\u7c7b\uff08Dao\uff09<\/li>\n<li>Service\u5c42\u63a5\u53e3\u5b9e\u73b0\u7c7b\uff08ServiceImpl\uff09<\/li>\n<li>Service\u5c42\u63a5\u53e3\uff08Service\uff09<\/li>\n<li>\u63a7\u5236\u5668\u5c42\uff08Controller\uff09<\/li>\n<\/ul>\n<\/li>\n<li>\u6570\u636e\u5e93\uff08Mysql\uff09<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/div>\n<h2>\u9875\u9762\u4ecb\u7ecd<\/h2>\n<p>\u65c5\u6e38\u7ba1\u7406\u7cfb\u7edf\u57fa\u4e8eJavaSSM\u6846\u67b6\uff0cMaven\uff0cMysql\u6570\u636e\u5e93\uff0cBootstrap\u52a8\u6001\u9875\u9762\uff0cspringMVC\uff0cmybatis\u7b49\uff0c\u5176\u4e2d\u4ea7\u54c1\u7ba1\u7406\u9875\u9762\u6709\u589e\u5220\u6539\u67e5\uff0c\u52a8\u6001\u663e\u793a\uff0c\u5206\u9875\u663e\u793a\uff0c\u591a\u884c\u5220\u9664\u7684\u529f\u80fd\u3002<\/p>\n<h2>\u540e\u53f0\u4ee3\u7801<\/h2>\n<h3>\u4f9d\u8d56\u5b89\u88c5\uff08pom.xml\uff09<\/h3>\n<p><img decoding=\"async\" src=\"https:\/\/img-blog.csdnimg.cn\/20201030190900304.png\" =\"\" =\"pom.xml\u6587\u4ef6\" alt=\"\u57fa\u4e8ejava\u7684\u65c5\u6e38\u7ba1\u7406\u7cfb\u7edf_\u9879\u76ee\u7ba1\u7406\u7cfb\u7edf\u6e90\u7801JAVA (https:\/\/mushiming.com\/)  \u7b2c1\u5f20\" title=\"\u57fa\u4e8ejava\u7684\u65c5\u6e38\u7ba1\u7406\u7cfb\u7edf_\u9879\u76ee\u7ba1\u7406\u7cfb\u7edf\u6e90\u7801JAVA  \u7b2c1\u5f20-\u7a46\u4e16\u660e\u535a\u5ba2\" >pom.xml\u4f5c\u4e3aMaven\u67b6\u6784\u4e2d\u7528\u4e8e\u7ba1\u7406\uff1a\u6e90\u4ee3\u7801\u3001\u914d\u7f6e\u6587\u4ef6\u3001\u5f00\u53d1\u8005\u7684\u4fe1\u606f\u548c\u89d2\u8272\u3001\u95ee\u9898\u8ffd\u8e2a\u7cfb\u7edf\u3001\u7ec4\u7ec7\u4fe1\u606f\u3001\u9879\u76ee\u6388\u6743\u3001\u9879\u76ee\u7684url\u3001\u9879\u76ee\u7684\u4f9d\u8d56\u5173\u7cfb\u7684\u6587\u4ef6\u3002\u5341\u5206\u91cd\u8981\uff0c\u9996\u5148\u8981\u5728pom\u6587\u4ef6\u4e2d\u628a\u9879\u76ee\u6240\u8981\u7528\u5230\u7684\u76f8\u5173\u4f9d\u8d56\u63d2\u4ef6\u5b89\u88c5\u3002<\/p>\n<h3>\u9879\u76ee\u8d44\u6e90\u914d\u7f6e\uff08resource\uff09<\/h3>\n<p><img decoding=\"async\" src=\"https:\/\/img-blog.csdnimg.cn\/20201030191723988.png#pic_center\" =\"\" =\"java\u9879\u76ee\u8d44\u6e90\u914d\u7f6e\u6587\u4ef6\u5939\" alt=\"\u57fa\u4e8ejava\u7684\u65c5\u6e38\u7ba1\u7406\u7cfb\u7edf_\u9879\u76ee\u7ba1\u7406\u7cfb\u7edf\u6e90\u7801JAVA (https:\/\/mushiming.com\/)  \u7b2c2\u5f20\" title=\"\u57fa\u4e8ejava\u7684\u65c5\u6e38\u7ba1\u7406\u7cfb\u7edf_\u9879\u76ee\u7ba1\u7406\u7cfb\u7edf\u6e90\u7801JAVA  \u7b2c2\u5f20-\u7a46\u4e16\u660e\u535a\u5ba2\" ><\/p>\n<h4>applicationContext.xml<\/h4>\n<pre class=\"language-java prettyprint linenums\"><code class=\"prism language-java\"><span class=\"token operator\">&lt;<\/span><span class=\"token operator\">?<\/span>xml version<span class=\"token operator\">=<\/span><span class=\"token string\">\"1.0\"<\/span> encoding<span class=\"token operator\">=<\/span><span class=\"token string\">\"UTF-8\"<\/span><span class=\"token operator\">?<\/span><span class=\"token operator\">&gt;<\/span> <span class=\"token operator\">&lt;<\/span>beans xmlns<span class=\"token operator\">=<\/span><span class=\"token string\">\"http:\/\/www.springframework.org\/schema\/beans\"<\/span> xmlns<span class=\"token operator\">:<\/span>xsi<span class=\"token operator\">=<\/span><span class=\"token string\">\"http:\/\/www.w3.org\/2001\/XMLSchema-instance\"<\/span> xmlns<span class=\"token operator\">:<\/span>context<span class=\"token operator\">=<\/span><span class=\"token string\">\"http:\/\/www.springframework.org\/schema\/context\"<\/span> xmlns<span class=\"token operator\">:<\/span>aop<span class=\"token operator\">=<\/span><span class=\"token string\">\"http:\/\/www.springframework.org\/schema\/aop\"<\/span> xmlns<span class=\"token operator\">:<\/span>tx<span class=\"token operator\">=<\/span><span class=\"token string\">\"http:\/\/www.springframework.org\/schema\/tx\"<\/span> xsi<span class=\"token operator\">:<\/span>schemaLocation<span class=\"token operator\">=<\/span>\" http<span class=\"token operator\">:<\/span><span class=\"token operator\">\/<\/span><span class=\"token operator\">\/<\/span>www<span class=\"token punctuation\">.<\/span>springframework<span class=\"token punctuation\">.<\/span>org<span class=\"token operator\">\/<\/span>schema<span class=\"token operator\">\/<\/span>beans http<span class=\"token operator\">:<\/span><span class=\"token operator\">\/<\/span><span class=\"token operator\">\/<\/span>www<span class=\"token punctuation\">.<\/span>springframework<span class=\"token punctuation\">.<\/span>org<span class=\"token operator\">\/<\/span>schema<span class=\"token operator\">\/<\/span>beans<span class=\"token operator\">\/<\/span>spring<span class=\"token operator\">-<\/span>beans<span class=\"token punctuation\">.<\/span>xsd http<span class=\"token operator\">:<\/span><span class=\"token operator\">\/<\/span><span class=\"token operator\">\/<\/span>www<span class=\"token punctuation\">.<\/span>springframework<span class=\"token punctuation\">.<\/span>org<span class=\"token operator\">\/<\/span>schema<span class=\"token operator\">\/<\/span>mvc http<span class=\"token operator\">:<\/span><span class=\"token operator\">\/<\/span><span class=\"token operator\">\/<\/span>www<span class=\"token punctuation\">.<\/span>springframework<span class=\"token punctuation\">.<\/span>org<span class=\"token operator\">\/<\/span>schema<span class=\"token operator\">\/<\/span>mvc<span class=\"token operator\">\/<\/span>spring<span class=\"token operator\">-<\/span>mvc<span class=\"token punctuation\">.<\/span>xsd http<span class=\"token operator\">:<\/span><span class=\"token operator\">\/<\/span><span class=\"token operator\">\/<\/span>www<span class=\"token punctuation\">.<\/span>springframework<span class=\"token punctuation\">.<\/span>org<span class=\"token operator\">\/<\/span>schema<span class=\"token operator\">\/<\/span>context http<span class=\"token operator\">:<\/span><span class=\"token operator\">\/<\/span><span class=\"token operator\">\/<\/span>www<span class=\"token punctuation\">.<\/span>springframework<span class=\"token punctuation\">.<\/span>org<span class=\"token operator\">\/<\/span>schema<span class=\"token operator\">\/<\/span>context<span class=\"token operator\">\/<\/span>spring<span class=\"token operator\">-<\/span>context<span class=\"token punctuation\">.<\/span>xsd http<span class=\"token operator\">:<\/span><span class=\"token operator\">\/<\/span><span class=\"token operator\">\/<\/span>www<span class=\"token punctuation\">.<\/span>springframework<span class=\"token punctuation\">.<\/span>org<span class=\"token operator\">\/<\/span>schema<span class=\"token operator\">\/<\/span>aop http<span class=\"token operator\">:<\/span><span class=\"token operator\">\/<\/span><span class=\"token operator\">\/<\/span>www<span class=\"token punctuation\">.<\/span>springframework<span class=\"token punctuation\">.<\/span>org<span class=\"token operator\">\/<\/span>schema<span class=\"token operator\">\/<\/span>aop<span class=\"token operator\">\/<\/span>spring<span class=\"token operator\">-<\/span>aop<span class=\"token punctuation\">.<\/span>xsd\"<span class=\"token operator\">&gt;<\/span> <span class=\"token operator\">&lt;<\/span><span class=\"token operator\">!<\/span><span class=\"token operator\">--<\/span> \u5f00\u542f\u6ce8\u89e3\u626b\u63cf\uff0c\u7ba1\u7406service\u548cdao <span class=\"token operator\">--<\/span><span class=\"token operator\">&gt;<\/span> <span class=\"token operator\">&lt;<\/span>context<span class=\"token operator\">:<\/span>component<span class=\"token operator\">-<\/span>scan base<span class=\"token operator\">-<\/span><span class=\"token keyword\">package<\/span><span class=\"token operator\">=<\/span><span class=\"token string\">\"com.yzw.service\"<\/span><span class=\"token operator\">&gt;<\/span> <span class=\"token operator\">&lt;<\/span><span class=\"token operator\">\/<\/span>context<span class=\"token operator\">:<\/span>component<span class=\"token operator\">-<\/span>scan<span class=\"token operator\">&gt;<\/span> <span class=\"token operator\">&lt;<\/span>context<span class=\"token operator\">:<\/span>component<span class=\"token operator\">-<\/span>scan base<span class=\"token operator\">-<\/span><span class=\"token keyword\">package<\/span><span class=\"token operator\">=<\/span><span class=\"token string\">\"com.yzw.dao\"<\/span><span class=\"token operator\">&gt;<\/span> <span class=\"token operator\">&lt;<\/span><span class=\"token operator\">\/<\/span>context<span class=\"token operator\">:<\/span>component<span class=\"token operator\">-<\/span>scan<span class=\"token operator\">&gt;<\/span> <span class=\"token operator\">&lt;<\/span>context<span class=\"token operator\">:<\/span>property<span class=\"token operator\">-<\/span>placeholder location<span class=\"token operator\">=<\/span><span class=\"token string\">\"classpath:db.properties\"<\/span> <span class=\"token operator\">\/<\/span><span class=\"token operator\">&gt;<\/span> <span class=\"token operator\">&lt;<\/span><span class=\"token operator\">!<\/span><span class=\"token operator\">--<\/span> \u914d\u7f6e\u6570\u636e\u5e93\u6570\u636e\u6e90 <span class=\"token operator\">--<\/span><span class=\"token operator\">&gt;<\/span> <span class=\"token operator\">&lt;<\/span>bean id<span class=\"token operator\">=<\/span><span class=\"token string\">\"dataSource\"<\/span> <span class=\"token keyword\">class<\/span><span class=\"token operator\">=<\/span><span class=\"token string\">\"com.mchange.v2.c3p0.ComboPooledDataSource\"<\/span><span class=\"token operator\">&gt;<\/span> <span class=\"token operator\">&lt;<\/span>property name<span class=\"token operator\">=<\/span><span class=\"token string\">\"driverClass\"<\/span> value<span class=\"token operator\">=<\/span><span class=\"token string\">\"${jdbc.driver}\"<\/span> <span class=\"token operator\">\/<\/span><span class=\"token operator\">&gt;<\/span> <span class=\"token operator\">&lt;<\/span>property name<span class=\"token operator\">=<\/span><span class=\"token string\">\"jdbcUrl\"<\/span> value<span class=\"token operator\">=<\/span><span class=\"token string\">\"${jdbc.url}\"<\/span> <span class=\"token operator\">\/<\/span><span class=\"token operator\">&gt;<\/span> <span class=\"token operator\">&lt;<\/span>property name<span class=\"token operator\">=<\/span><span class=\"token string\">\"user\"<\/span> value<span class=\"token operator\">=<\/span><span class=\"token string\">\"${jdbc.username}\"<\/span> <span class=\"token operator\">\/<\/span><span class=\"token operator\">&gt;<\/span> <span class=\"token operator\">&lt;<\/span>property name<span class=\"token operator\">=<\/span><span class=\"token string\">\"password\"<\/span> value<span class=\"token operator\">=<\/span><span class=\"token string\">\"${jdbc.password}\"<\/span> <span class=\"token operator\">\/<\/span><span class=\"token operator\">&gt;<\/span> <span class=\"token operator\">&lt;<\/span><span class=\"token operator\">\/<\/span>bean<span class=\"token operator\">&gt;<\/span> <span class=\"token operator\">&lt;<\/span><span class=\"token operator\">!<\/span><span class=\"token operator\">--<\/span> \u521b\u5efaspring\u5de5\u5382 <span class=\"token operator\">--<\/span><span class=\"token operator\">&gt;<\/span> <span class=\"token operator\">&lt;<\/span>bean id<span class=\"token operator\">=<\/span><span class=\"token string\">\"sqlSessionFactory\"<\/span> <span class=\"token keyword\">class<\/span><span class=\"token operator\">=<\/span><span class=\"token string\">\"org.mybatis.spring.SqlSessionFactoryBean\"<\/span><span class=\"token operator\">&gt;<\/span> <span class=\"token operator\">&lt;<\/span>property name<span class=\"token operator\">=<\/span><span class=\"token string\">\"dataSource\"<\/span> ref<span class=\"token operator\">=<\/span><span class=\"token string\">\"dataSource\"<\/span> <span class=\"token operator\">\/<\/span><span class=\"token operator\">&gt;<\/span> <span class=\"token operator\">&lt;<\/span><span class=\"token operator\">!<\/span><span class=\"token operator\">--<\/span> \u4f20\u5165PageHelper\u7684\u63d2\u4ef6 <span class=\"token operator\">--<\/span><span class=\"token operator\">&gt;<\/span> <span class=\"token operator\">&lt;<\/span>property name<span class=\"token operator\">=<\/span><span class=\"token string\">\"plugins\"<\/span><span class=\"token operator\">&gt;<\/span> <span class=\"token generics function\"><span class=\"token punctuation\">&lt;<\/span>array<span class=\"token punctuation\">&gt;<\/span><\/span> <span class=\"token operator\">&lt;<\/span><span class=\"token operator\">!<\/span><span class=\"token operator\">--<\/span> \u4f20\u5165\u63d2\u4ef6\u7684\u5bf9\u8c61 <span class=\"token operator\">--<\/span><span class=\"token operator\">&gt;<\/span> <span class=\"token operator\">&lt;<\/span>bean <span class=\"token keyword\">class<\/span><span class=\"token operator\">=<\/span><span class=\"token string\">\"com.github.pagehelper.PageInterceptor\"<\/span><span class=\"token operator\">&gt;<\/span> <span class=\"token operator\">&lt;<\/span>property name<span class=\"token operator\">=<\/span><span class=\"token string\">\"properties\"<\/span><span class=\"token operator\">&gt;<\/span> <span class=\"token generics function\"><span class=\"token punctuation\">&lt;<\/span>props<span class=\"token punctuation\">&gt;<\/span><\/span> <span class=\"token operator\">&lt;<\/span>prop key<span class=\"token operator\">=<\/span><span class=\"token string\">\"helperDialect\"<\/span><span class=\"token operator\">&gt;<\/span>mysql<span class=\"token operator\">&lt;<\/span><span class=\"token operator\">\/<\/span>prop<span class=\"token operator\">&gt;<\/span> <span class=\"token operator\">&lt;<\/span>prop key<span class=\"token operator\">=<\/span><span class=\"token string\">\"reasonable\"<\/span><span class=\"token operator\">&gt;<\/span><span class=\"token boolean\">true<\/span><span class=\"token operator\">&lt;<\/span><span class=\"token operator\">\/<\/span>prop<span class=\"token operator\">&gt;<\/span> <span class=\"token operator\">&lt;<\/span><span class=\"token operator\">\/<\/span>props<span class=\"token operator\">&gt;<\/span> <span class=\"token operator\">&lt;<\/span><span class=\"token operator\">\/<\/span>property<span class=\"token operator\">&gt;<\/span> <span class=\"token operator\">&lt;<\/span><span class=\"token operator\">\/<\/span>bean<span class=\"token operator\">&gt;<\/span> <span class=\"token operator\">&lt;<\/span><span class=\"token operator\">\/<\/span>array<span class=\"token operator\">&gt;<\/span> <span class=\"token operator\">&lt;<\/span><span class=\"token operator\">\/<\/span>property<span class=\"token operator\">&gt;<\/span> <span class=\"token operator\">&lt;<\/span><span class=\"token operator\">\/<\/span>bean<span class=\"token operator\">&gt;<\/span> <span class=\"token operator\">&lt;<\/span><span class=\"token operator\">!<\/span><span class=\"token operator\">--<\/span> \u626b\u63cfdao<span class=\"token operator\">\/<\/span>mapper\u63a5\u53e3\u6587\u4ef6 <span class=\"token operator\">--<\/span><span class=\"token operator\">&gt;<\/span> <span class=\"token operator\">&lt;<\/span>bean id<span class=\"token operator\">=<\/span><span class=\"token string\">\"mapperScanner\"<\/span> <span class=\"token keyword\">class<\/span><span class=\"token operator\">=<\/span><span class=\"token string\">\"org.mybatis.spring.mapper.MapperScannerConfigurer\"<\/span><span class=\"token operator\">&gt;<\/span> <span class=\"token operator\">&lt;<\/span>property name<span class=\"token operator\">=<\/span><span class=\"token string\">\"basePackage\"<\/span> value<span class=\"token operator\">=<\/span><span class=\"token string\">\"com.yzw.dao\"<\/span> <span class=\"token operator\">\/<\/span><span class=\"token operator\">&gt;<\/span> <span class=\"token operator\">&lt;<\/span><span class=\"token operator\">!<\/span><span class=\"token operator\">--<\/span> \u5982\u679c\u8fd8\u6709\u6709\u4e9b\u4e13\u95e8\u9488\u5bf9\u4e8emybatis\u7684\u914d\u7f6e\uff0c\u9700\u8981\u5f15\u5165 <span class=\"token operator\">--<\/span><span class=\"token operator\">&gt;<\/span> <span class=\"token operator\">&lt;<\/span><span class=\"token operator\">\/<\/span>bean<span class=\"token operator\">&gt;<\/span> <span class=\"token operator\">&lt;<\/span><span class=\"token operator\">\/<\/span>beans<span class=\"token operator\">&gt;<\/span> <\/code><\/pre>\n<blockquote>\n<p>\u8be5\u6587\u4ef6\u7528\u4e8e\u914d\u7f6e\u6570\u636e\u6e90\u548c\u8fc7\u6ee4\u626b\u63cf\u5668<\/p>\n<\/blockquote>\n<h4>db.properties<\/h4>\n<pre class=\"language-java prettyprint linenums\"><code class=\"prism language-java\">jdbc<span class=\"token punctuation\">.<\/span>driver<span class=\"token operator\">=<\/span>com<span class=\"token punctuation\">.<\/span>mysql<span class=\"token punctuation\">.<\/span>cj<span class=\"token punctuation\">.<\/span>jdbc<span class=\"token punctuation\">.<\/span>Driver jdbc<span class=\"token punctuation\">.<\/span>url<span class=\"token operator\">=<\/span>jdbc<span class=\"token operator\">:<\/span>mysql<span class=\"token operator\">:<\/span><span class=\"token operator\">\/<\/span><span class=\"token operator\">\/<\/span>localhost<span class=\"token operator\">:<\/span><span class=\"token number\">3306<\/span><span class=\"token operator\">\/<\/span>pms<span class=\"token operator\">?<\/span>useUnicode<span class=\"token operator\">=<\/span><span class=\"token boolean\">true<\/span><span class=\"token operator\">&amp;<\/span>characterEncoding<span class=\"token operator\">=<\/span>utf8<span class=\"token operator\">&amp;<\/span>serverTimezone<span class=\"token operator\">=<\/span>UTC<span class=\"token operator\">&amp;<\/span>rewriteBatchedStatements<span class=\"token operator\">=<\/span><span class=\"token boolean\">true<\/span> jdbc<span class=\"token punctuation\">.<\/span>username<span class=\"token operator\">=<\/span>root jdbc<span class=\"token punctuation\">.<\/span>password<span class=\"token operator\">=<\/span><span class=\"token number\"><\/span> ## P6SpyDriver jdbc<span class=\"token punctuation\">.<\/span>driver<span class=\"token operator\">=<\/span>com<span class=\"token punctuation\">.<\/span>p6spy<span class=\"token punctuation\">.<\/span>engine<span class=\"token punctuation\">.<\/span>spy<span class=\"token punctuation\">.<\/span>P6SpyDriver jdbc<span class=\"token punctuation\">.<\/span>url<span class=\"token operator\">=<\/span>jdbc<span class=\"token operator\">:<\/span>p6spy<span class=\"token operator\">:<\/span>mysql<span class=\"token operator\">:<\/span><span class=\"token operator\">\/<\/span><span class=\"token operator\">\/<\/span>localhost<span class=\"token operator\">:<\/span><span class=\"token number\">3306<\/span><span class=\"token operator\">\/<\/span>pms<span class=\"token operator\">?<\/span>useUnicode<span class=\"token operator\">=<\/span><span class=\"token boolean\">true<\/span><span class=\"token operator\">&amp;<\/span>characterEncoding<span class=\"token operator\">=<\/span>utf8<span class=\"token operator\">&amp;<\/span>serverTimezone<span class=\"token operator\">=<\/span>UTC<span class=\"token operator\">&amp;<\/span>rewriteBatchedStatements<span class=\"token operator\">=<\/span><span class=\"token boolean\">true<\/span> jdbc<span class=\"token punctuation\">.<\/span>username<span class=\"token operator\">=<\/span>root jdbc<span class=\"token punctuation\">.<\/span>password<span class=\"token operator\">=<\/span><span class=\"token number\"><\/span> <\/code><\/pre>\n<blockquote>\n<p>\u8be5\u6587\u4ef6\u7528\u4e8e\u8fde\u63a5mysql\u6570\u636e\u5e93<\/p>\n<\/blockquote>\n<h4>log4j.properties<\/h4>\n<pre><code class=\"prism language-java\">### \u8bbe\u7f6e### log4j<span class=\"token punctuation\">.<\/span>rootLogger <span class=\"token operator\">=<\/span> debug<span class=\"token punctuation\">,<\/span>stdout<span class=\"token punctuation\">,<\/span>D<span class=\"token punctuation\">,<\/span>E ### \u8f93\u51fa\u4fe1\u606f\u5230\u63a7\u5236\u53f0 ### log4j<span class=\"token punctuation\">.<\/span>appender<span class=\"token punctuation\">.<\/span>stdout <span class=\"token operator\">=<\/span> org<span class=\"token punctuation\">.<\/span>apache<span class=\"token punctuation\">.<\/span>log4j<span class=\"token punctuation\">.<\/span>ConsoleAppender log4j<span class=\"token punctuation\">.<\/span>appender<span class=\"token punctuation\">.<\/span>stdout<span class=\"token punctuation\">.<\/span>Target <span class=\"token operator\">=<\/span> System<span class=\"token punctuation\">.<\/span>out log4j<span class=\"token punctuation\">.<\/span>appender<span class=\"token punctuation\">.<\/span>stdout<span class=\"token punctuation\">.<\/span>layout <span class=\"token operator\">=<\/span> org<span class=\"token punctuation\">.<\/span>apache<span class=\"token punctuation\">.<\/span>log4j<span class=\"token punctuation\">.<\/span>PatternLayout log4j<span class=\"token punctuation\">.<\/span>appender<span class=\"token punctuation\">.<\/span>stdout<span class=\"token punctuation\">.<\/span>layout<span class=\"token punctuation\">.<\/span>ConversionPattern <span class=\"token operator\">=<\/span> <span class=\"token punctuation\">[<\/span><span class=\"token operator\">%<\/span><span class=\"token operator\">-<\/span><span class=\"token number\">5<\/span>p<span class=\"token punctuation\">]<\/span> <span class=\"token operator\">%<\/span>d<span class=\"token punctuation\">{ \n   <!-- --><\/span>yyyy<span class=\"token operator\">-<\/span>MM<span class=\"token operator\">-<\/span>dd HH<span class=\"token operator\">:<\/span>mm<span class=\"token operator\">:<\/span>ss<span class=\"token punctuation\">,<\/span>SSS<span class=\"token punctuation\">}<\/span> method<span class=\"token operator\">:<\/span><span class=\"token operator\">%<\/span>l<span class=\"token operator\">%<\/span>n<span class=\"token operator\">%<\/span>m<span class=\"token operator\">%<\/span>n ### \u8f93\u51faDEBUG \u7ea7\u522b\u4ee5\u4e0a\u7684\u65e5\u5fd7\u5230<span class=\"token operator\">=<\/span>D<span class=\"token operator\">:<\/span><span class=\"token operator\">\/<\/span><span class=\"token operator\">\/<\/span>logs<span class=\"token operator\">\/<\/span>error<span class=\"token punctuation\">.<\/span>log ### log4j<span class=\"token punctuation\">.<\/span>appender<span class=\"token punctuation\">.<\/span>D <span class=\"token operator\">=<\/span> org<span class=\"token punctuation\">.<\/span>apache<span class=\"token punctuation\">.<\/span>log4j<span class=\"token punctuation\">.<\/span>DailyRollingFileAppender log4j<span class=\"token punctuation\">.<\/span>appender<span class=\"token punctuation\">.<\/span>D<span class=\"token punctuation\">.<\/span>File <span class=\"token operator\">=<\/span> D<span class=\"token operator\">:<\/span><span class=\"token operator\">\/<\/span><span class=\"token operator\">\/<\/span>logs<span class=\"token operator\">\/<\/span>log<span class=\"token punctuation\">.<\/span>log log4j<span class=\"token punctuation\">.<\/span>appender<span class=\"token punctuation\">.<\/span>D<span class=\"token punctuation\">.<\/span>Append <span class=\"token operator\">=<\/span> <span class=\"token boolean\">true<\/span> log4j<span class=\"token punctuation\">.<\/span>appender<span class=\"token punctuation\">.<\/span>D<span class=\"token punctuation\">.<\/span>Threshold <span class=\"token operator\">=<\/span> DEBUG log4j<span class=\"token punctuation\">.<\/span>appender<span class=\"token punctuation\">.<\/span>D<span class=\"token punctuation\">.<\/span>layout <span class=\"token operator\">=<\/span> org<span class=\"token punctuation\">.<\/span>apache<span class=\"token punctuation\">.<\/span>log4j<span class=\"token punctuation\">.<\/span>PatternLayout log4j<span class=\"token punctuation\">.<\/span>appender<span class=\"token punctuation\">.<\/span>D<span class=\"token punctuation\">.<\/span>layout<span class=\"token punctuation\">.<\/span>ConversionPattern <span class=\"token operator\">=<\/span> <span class=\"token operator\">%<\/span><span class=\"token operator\">-<\/span>d<span class=\"token punctuation\">{ \n   <!-- --><\/span>yyyy<span class=\"token operator\">-<\/span>MM<span class=\"token operator\">-<\/span>dd HH<span class=\"token operator\">:<\/span>mm<span class=\"token operator\">:<\/span>ss<span class=\"token punctuation\">}<\/span> <span class=\"token punctuation\">[<\/span> <span class=\"token operator\">%<\/span>t<span class=\"token operator\">:<\/span><span class=\"token operator\">%<\/span>r <span class=\"token punctuation\">]<\/span><span class=\"token operator\">-<\/span><span class=\"token punctuation\">[<\/span> <span class=\"token operator\">%<\/span>p <span class=\"token punctuation\">]<\/span> <span class=\"token operator\">%<\/span>m<span class=\"token operator\">%<\/span>n ### \u8f93\u51faERROR \u7ea7\u522b\u4ee5\u4e0a\u7684\u65e5\u5fd7\u5230<span class=\"token operator\">=<\/span>D<span class=\"token operator\">:<\/span><span class=\"token operator\">\/<\/span><span class=\"token operator\">\/<\/span>logs<span class=\"token operator\">\/<\/span>error<span class=\"token punctuation\">.<\/span>log ### log4j<span class=\"token punctuation\">.<\/span>appender<span class=\"token punctuation\">.<\/span>E <span class=\"token operator\">=<\/span> org<span class=\"token punctuation\">.<\/span>apache<span class=\"token punctuation\">.<\/span>log4j<span class=\"token punctuation\">.<\/span>DailyRollingFileAppender log4j<span class=\"token punctuation\">.<\/span>appender<span class=\"token punctuation\">.<\/span>E<span class=\"token punctuation\">.<\/span>File <span class=\"token operator\">=<\/span>D<span class=\"token operator\">:<\/span><span class=\"token operator\">\/<\/span><span class=\"token operator\">\/<\/span>logs<span class=\"token operator\">\/<\/span>error<span class=\"token punctuation\">.<\/span>log log4j<span class=\"token punctuation\">.<\/span>appender<span class=\"token punctuation\">.<\/span>E<span class=\"token punctuation\">.<\/span>Append <span class=\"token operator\">=<\/span> <span class=\"token boolean\">true<\/span> log4j<span class=\"token punctuation\">.<\/span>appender<span class=\"token punctuation\">.<\/span>E<span class=\"token punctuation\">.<\/span>Threshold <span class=\"token operator\">=<\/span> ERROR log4j<span class=\"token punctuation\">.<\/span>appender<span class=\"token punctuation\">.<\/span>E<span class=\"token punctuation\">.<\/span>layout <span class=\"token operator\">=<\/span> org<span class=\"token punctuation\">.<\/span>apache<span class=\"token punctuation\">.<\/span>log4j<span class=\"token punctuation\">.<\/span>PatternLayout <\/code><\/pre>\n<blockquote>\n<p>\u8be5\u6587\u4ef6\u7528\u4e8e\u8f93\u51fa\u9519\u8bef\u53caDEBUG\u65e5\u5fd7<\/p>\n<\/blockquote>\n<h4>springmvc.xml<\/h4>\n<pre class=\"language-java prettyprint linenums\"><code class=\"prism language-java\"><span class=\"token operator\">&lt;<\/span><span class=\"token operator\">?<\/span>xml version<span class=\"token operator\">=<\/span><span class=\"token string\">\"1.0\"<\/span> encoding<span class=\"token operator\">=<\/span><span class=\"token string\">\"UTF-8\"<\/span><span class=\"token operator\">?<\/span><span class=\"token operator\">&gt;<\/span> <span class=\"token operator\">&lt;<\/span>beans xmlns<span class=\"token operator\">=<\/span><span class=\"token string\">\"http:\/\/www.springframework.org\/schema\/beans\"<\/span> xmlns<span class=\"token operator\">:<\/span>mvc<span class=\"token operator\">=<\/span><span class=\"token string\">\"http:\/\/www.springframework.org\/schema\/mvc\"<\/span> xmlns<span class=\"token operator\">:<\/span>context<span class=\"token operator\">=<\/span><span class=\"token string\">\"http:\/\/www.springframework.org\/schema\/context\"<\/span> xmlns<span class=\"token operator\">:<\/span>xsi<span class=\"token operator\">=<\/span><span class=\"token string\">\"http:\/\/www.w3.org\/2001\/XMLSchema-instance\"<\/span> xmlns<span class=\"token operator\">:<\/span>aop<span class=\"token operator\">=<\/span><span class=\"token string\">\"http:\/\/www.springframework.org\/schema\/aop\"<\/span> xsi<span class=\"token operator\">:<\/span>schemaLocation<span class=\"token operator\">=<\/span>\" http<span class=\"token operator\">:<\/span><span class=\"token operator\">\/<\/span><span class=\"token operator\">\/<\/span>www<span class=\"token punctuation\">.<\/span>springframework<span class=\"token punctuation\">.<\/span>org<span class=\"token operator\">\/<\/span>schema<span class=\"token operator\">\/<\/span>beans http<span class=\"token operator\">:<\/span><span class=\"token operator\">\/<\/span><span class=\"token operator\">\/<\/span>www<span class=\"token punctuation\">.<\/span>springframework<span class=\"token punctuation\">.<\/span>org<span class=\"token operator\">\/<\/span>schema<span class=\"token operator\">\/<\/span>beans<span class=\"token operator\">\/<\/span>spring<span class=\"token operator\">-<\/span>beans<span class=\"token punctuation\">.<\/span>xsd http<span class=\"token operator\">:<\/span><span class=\"token operator\">\/<\/span><span class=\"token operator\">\/<\/span>www<span class=\"token punctuation\">.<\/span>springframework<span class=\"token punctuation\">.<\/span>org<span class=\"token operator\">\/<\/span>schema<span class=\"token operator\">\/<\/span>mvc http<span class=\"token operator\">:<\/span><span class=\"token operator\">\/<\/span><span class=\"token operator\">\/<\/span>www<span class=\"token punctuation\">.<\/span>springframework<span class=\"token punctuation\">.<\/span>org<span class=\"token operator\">\/<\/span>schema<span class=\"token operator\">\/<\/span>mvc<span class=\"token operator\">\/<\/span>spring<span class=\"token operator\">-<\/span>mvc<span class=\"token punctuation\">.<\/span>xsd http<span class=\"token operator\">:<\/span><span class=\"token operator\">\/<\/span><span class=\"token operator\">\/<\/span>www<span class=\"token punctuation\">.<\/span>springframework<span class=\"token punctuation\">.<\/span>org<span class=\"token operator\">\/<\/span>schema<span class=\"token operator\">\/<\/span>context http<span class=\"token operator\">:<\/span><span class=\"token operator\">\/<\/span><span class=\"token operator\">\/<\/span>www<span class=\"token punctuation\">.<\/span>springframework<span class=\"token punctuation\">.<\/span>org<span class=\"token operator\">\/<\/span>schema<span class=\"token operator\">\/<\/span>context<span class=\"token operator\">\/<\/span>spring<span class=\"token operator\">-<\/span>context<span class=\"token punctuation\">.<\/span>xsd http<span class=\"token operator\">:<\/span><span class=\"token operator\">\/<\/span><span class=\"token operator\">\/<\/span>www<span class=\"token punctuation\">.<\/span>springframework<span class=\"token punctuation\">.<\/span>org<span class=\"token operator\">\/<\/span>schema<span class=\"token operator\">\/<\/span>aop http<span class=\"token operator\">:<\/span><span class=\"token operator\">\/<\/span><span class=\"token operator\">\/<\/span>www<span class=\"token punctuation\">.<\/span>springframework<span class=\"token punctuation\">.<\/span>org<span class=\"token operator\">\/<\/span>schema<span class=\"token operator\">\/<\/span>aop<span class=\"token operator\">\/<\/span>spring<span class=\"token operator\">-<\/span>aop<span class=\"token punctuation\">.<\/span>xsd\"<span class=\"token operator\">&gt;<\/span> <span class=\"token operator\">&lt;<\/span><span class=\"token operator\">!<\/span><span class=\"token operator\">--<\/span> \u914d\u7f6e\u5305\u626b\u63cf <span class=\"token operator\">--<\/span><span class=\"token operator\">&gt;<\/span> <span class=\"token operator\">&lt;<\/span>context<span class=\"token operator\">:<\/span>component<span class=\"token operator\">-<\/span>scan base<span class=\"token operator\">-<\/span><span class=\"token keyword\">package<\/span><span class=\"token operator\">=<\/span><span class=\"token string\">\"com.yzw.controller\"<\/span><span class=\"token operator\">&gt;<\/span> <span class=\"token operator\">&lt;<\/span><span class=\"token operator\">\/<\/span>context<span class=\"token operator\">:<\/span>component<span class=\"token operator\">-<\/span>scan<span class=\"token operator\">&gt;<\/span> <span class=\"token operator\">&lt;<\/span><span class=\"token operator\">!<\/span><span class=\"token operator\">--<\/span> \u6dfb\u52a0springmvc\u6ce8\u89e3\u9a71\u52a8 <span class=\"token operator\">--<\/span><span class=\"token operator\">&gt;<\/span> <span class=\"token operator\">&lt;<\/span>mvc<span class=\"token operator\">:<\/span>annotation<span class=\"token operator\">-<\/span>driven <span class=\"token operator\">\/<\/span><span class=\"token operator\">&gt;<\/span> <span class=\"token operator\">&lt;<\/span><span class=\"token operator\">!<\/span><span class=\"token operator\">--<\/span> \u914d\u7f6e\u89c6\u56fe\u89e3\u6790\u5668 <span class=\"token operator\">--<\/span><span class=\"token operator\">&gt;<\/span> <span class=\"token operator\">&lt;<\/span>bean id<span class=\"token operator\">=<\/span><span class=\"token string\">\"viewResolver\"<\/span> <span class=\"token keyword\">class<\/span><span class=\"token operator\">=<\/span><span class=\"token string\">\"org.springframework.web.servlet.view.InternalResourceViewResolver\"<\/span><span class=\"token operator\">&gt;<\/span> <span class=\"token operator\">&lt;<\/span><span class=\"token operator\">!<\/span><span class=\"token operator\">--<\/span> JSP\u6587\u4ef6\u6240\u5728\u7684\u76ee\u5f55 <span class=\"token operator\">--<\/span><span class=\"token operator\">&gt;<\/span> <span class=\"token operator\">&lt;<\/span>property name<span class=\"token operator\">=<\/span><span class=\"token string\">\"prefix\"<\/span> value<span class=\"token operator\">=<\/span><span class=\"token string\">\"\/pages\/\"<\/span> <span class=\"token operator\">\/<\/span><span class=\"token operator\">&gt;<\/span> <span class=\"token operator\">&lt;<\/span><span class=\"token operator\">!<\/span><span class=\"token operator\">--<\/span> \u6587\u4ef6\u7684\u540e\u7f00\u540d <span class=\"token operator\">--<\/span><span class=\"token operator\">&gt;<\/span> <span class=\"token operator\">&lt;<\/span>property name<span class=\"token operator\">=<\/span><span class=\"token string\">\"suffix\"<\/span> value<span class=\"token operator\">=<\/span><span class=\"token string\">\".jsp\"<\/span> <span class=\"token operator\">\/<\/span><span class=\"token operator\">&gt;<\/span> <span class=\"token operator\">&lt;<\/span><span class=\"token operator\">\/<\/span>bean<span class=\"token operator\">&gt;<\/span> <span class=\"token operator\">&lt;<\/span><span class=\"token operator\">!<\/span><span class=\"token operator\">--<\/span>\u914d\u7f6e\u9759\u6001\u8d44\u6e90\u4e0d\u8fc7\u6ee4<span class=\"token operator\">--<\/span><span class=\"token operator\">&gt;<\/span> <span class=\"token operator\">&lt;<\/span>mvc<span class=\"token operator\">:<\/span><span class=\"token keyword\">default<\/span><span class=\"token operator\">-<\/span>servlet<span class=\"token operator\">-<\/span>handler<span class=\"token operator\">\/<\/span><span class=\"token operator\">&gt;<\/span> <span class=\"token operator\">&lt;<\/span><span class=\"token operator\">!<\/span><span class=\"token operator\">--<\/span> \u652f\u6301AOP\u7684\u6ce8\u89e3\u652f\u6301\uff0cAOP\u5e95\u5c42\u4f7f\u7528\u4ee3\u7406\u6280\u672f JDK\u52a8\u6001\u4ee3\u7406\uff0c\u8981\u6c42\u5fc5\u987b\u6709\u63a5\u53e3 cglib\u4ee3\u7406\uff0c\u751f\u6210\u5b50\u7c7b\u5bf9\u8c61\uff0cproxy<span class=\"token operator\">-<\/span>target<span class=\"token operator\">-<\/span><span class=\"token keyword\">class<\/span><span class=\"token operator\">=<\/span><span class=\"token string\">\"true\"<\/span> \u9ed8\u8ba4\u4f7f\u7528cglib\u7684\u65b9\u5f0f <span class=\"token operator\">--<\/span><span class=\"token operator\">&gt;<\/span> <span class=\"token operator\">&lt;<\/span>aop<span class=\"token operator\">:<\/span>aspectj<span class=\"token operator\">-<\/span>autoproxy proxy<span class=\"token operator\">-<\/span>target<span class=\"token operator\">-<\/span><span class=\"token keyword\">class<\/span><span class=\"token operator\">=<\/span><span class=\"token string\">\"true\"<\/span><span class=\"token operator\">\/<\/span><span class=\"token operator\">&gt;<\/span> <span class=\"token operator\">&lt;<\/span><span class=\"token operator\">\/<\/span>beans<span class=\"token operator\">&gt;<\/span> <\/code><\/pre>\n<blockquote>\n<p>\u8be5\u6587\u4ef6\u7528\u4e8e\u914d\u7f6e\u89c6\u56fe\u89e3\u6790\u5668\uff0c\u4ece\u800c\u627e\u5230\u9875\u9762\u8fdb\u884c\u663e\u793a<\/p>\n<\/blockquote>\n<h4>spy.properties<\/h4>\n<pre class=\"language-java prettyprint linenums\"><code class=\"prism language-java\">driverlist<span class=\"token operator\">=<\/span>com<span class=\"token punctuation\">.<\/span>mysql<span class=\"token punctuation\">.<\/span>jdbc<span class=\"token punctuation\">.<\/span>Driver autoflush <span class=\"token operator\">=<\/span> <span class=\"token boolean\">true<\/span> appender<span class=\"token operator\">=<\/span>com<span class=\"token punctuation\">.<\/span>p6spy<span class=\"token punctuation\">.<\/span>engine<span class=\"token punctuation\">.<\/span>spy<span class=\"token punctuation\">.<\/span>appender<span class=\"token punctuation\">.<\/span>StdoutLogger <\/code><\/pre>\n<blockquote>\n<p>\u8be5\u6587\u4ef6\u7528\u4e8e\u76d1\u89c6SQL\u8bed\u53e5\u64cd\u4f5c<\/p>\n<\/blockquote>\n<h3>SSM\u67b6\u6784\uff08Model\u3001Controller\u3001View\uff09<\/h3>\n<p><img decoding=\"async\" src=\"https:\/\/img-blog.csdnimg.cn\/20201030232904151.png#pic_center\" =\"\" =\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\" alt=\"\u57fa\u4e8ejava\u7684\u65c5\u6e38\u7ba1\u7406\u7cfb\u7edf_\u9879\u76ee\u7ba1\u7406\u7cfb\u7edf\u6e90\u7801JAVA (https:\/\/mushiming.com\/)  \u7b2c3\u5f20\" title=\"\u57fa\u4e8ejava\u7684\u65c5\u6e38\u7ba1\u7406\u7cfb\u7edf_\u9879\u76ee\u7ba1\u7406\u7cfb\u7edf\u6e90\u7801JAVA  \u7b2c3\u5f20-\u7a46\u4e16\u660e\u535a\u5ba2\" ><\/p>\n<h4>\u6570\u636e\u5e93\u5c01\u88c5\u7c7b\uff08entity\uff09<\/h4>\n<pre><code class=\"prism language-java\"><span class=\"token keyword\">package<\/span> com<span class=\"token punctuation\">.<\/span>yzw<span class=\"token punctuation\">.<\/span>entity<span class=\"token punctuation\">;<\/span> <span class=\"token keyword\">public<\/span> <span class=\"token keyword\">class<\/span> <span class=\"token class-name\">Product<\/span> <span class=\"token punctuation\">{ \n   <!-- --><\/span> <span class=\"token keyword\">private<\/span> Integer id<span class=\"token punctuation\">;<\/span> <span class=\"token keyword\">private<\/span> String productNum<span class=\"token punctuation\">;<\/span> <span class=\"token keyword\">private<\/span> String productName<span class=\"token punctuation\">;<\/span> <span class=\"token keyword\">private<\/span> String cityName<span class=\"token punctuation\">;<\/span> <span class=\"token keyword\">private<\/span> String departureTime<span class=\"token punctuation\">;<\/span> <span class=\"token keyword\">private<\/span> Double productPrice<span class=\"token punctuation\">;<\/span> <span class=\"token keyword\">private<\/span> String productDesc<span class=\"token punctuation\">;<\/span> <span class=\"token keyword\">private<\/span> Integer productStatus<span class=\"token punctuation\">;<\/span> <span class=\"token comment\">\/\/ 1.\u65e0\u53c2\u548c\u6709\u53c2\u7684\u6784\u9020\u65b9\u6cd5<\/span> <span class=\"token comment\">\/\/ 2.set\/get<\/span> <span class=\"token comment\">\/\/ 3.tostring\u65b9\u6cd5<\/span> <span class=\"token comment\">\/\/\u6709\u53c2\u6784\u9020\u65b9\u6cd5<\/span> <span class=\"token keyword\">public<\/span> <span class=\"token function\">Product<\/span><span class=\"token punctuation\">(<\/span>Integer id<span class=\"token punctuation\">,<\/span> String productNum<span class=\"token punctuation\">,<\/span> String productName<span class=\"token punctuation\">,<\/span> String cityName<span class=\"token punctuation\">,<\/span> String departureTime<span class=\"token punctuation\">,<\/span> Double productPrice<span class=\"token punctuation\">,<\/span> String productDesc<span class=\"token punctuation\">,<\/span> Integer productStatus<span class=\"token punctuation\">)<\/span> <span class=\"token punctuation\">{ \n   <!-- --><\/span> <span class=\"token keyword\">super<\/span><span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span> <span class=\"token keyword\">this<\/span><span class=\"token punctuation\">.<\/span>id <span class=\"token operator\">=<\/span> id<span class=\"token punctuation\">;<\/span> <span class=\"token keyword\">this<\/span><span class=\"token punctuation\">.<\/span>productNum <span class=\"token operator\">=<\/span> productNum<span class=\"token punctuation\">;<\/span> <span class=\"token keyword\">this<\/span><span class=\"token punctuation\">.<\/span>productName <span class=\"token operator\">=<\/span> productName<span class=\"token punctuation\">;<\/span> <span class=\"token keyword\">this<\/span><span class=\"token punctuation\">.<\/span>cityName <span class=\"token operator\">=<\/span> cityName<span class=\"token punctuation\">;<\/span> <span class=\"token keyword\">this<\/span><span class=\"token punctuation\">.<\/span>departureTime <span class=\"token operator\">=<\/span> departureTime<span class=\"token punctuation\">;<\/span> <span class=\"token keyword\">this<\/span><span class=\"token punctuation\">.<\/span>productPrice <span class=\"token operator\">=<\/span> productPrice<span class=\"token punctuation\">;<\/span> <span class=\"token keyword\">this<\/span><span class=\"token punctuation\">.<\/span>productDesc <span class=\"token operator\">=<\/span> productDesc<span class=\"token punctuation\">;<\/span> <span class=\"token keyword\">this<\/span><span class=\"token punctuation\">.<\/span>productStatus <span class=\"token operator\">=<\/span> productStatus<span class=\"token punctuation\">;<\/span> <span class=\"token punctuation\">}<\/span> <span class=\"token comment\">\/\/\u65e0\u53c2\u6784\u9020\u65b9\u6cd5<\/span> <span class=\"token keyword\">public<\/span> <span class=\"token function\">Product<\/span><span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token punctuation\">{ \n   <!-- --><\/span> <span class=\"token keyword\">super<\/span><span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span> <span class=\"token punctuation\">}<\/span> <span class=\"token comment\">\/\/\u4ea7\u54c1ID<\/span> <span class=\"token keyword\">public<\/span> Integer <span class=\"token function\">getId<\/span><span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token punctuation\">{ \n   <!-- --><\/span> <span class=\"token keyword\">return<\/span> id<span class=\"token punctuation\">;<\/span> <span class=\"token punctuation\">}<\/span> <span class=\"token keyword\">public<\/span> <span class=\"token keyword\">void<\/span> <span class=\"token function\">setId<\/span><span class=\"token punctuation\">(<\/span>Integer id<span class=\"token punctuation\">)<\/span> <span class=\"token punctuation\">{ \n   <!-- --><\/span> <span class=\"token keyword\">this<\/span><span class=\"token punctuation\">.<\/span>id <span class=\"token operator\">=<\/span> id<span class=\"token punctuation\">;<\/span> <span class=\"token punctuation\">}<\/span> <span class=\"token comment\">\/\/\u4ea7\u54c1\u7f16\u53f7<\/span> <span class=\"token keyword\">public<\/span> String <span class=\"token function\">getProductNum<\/span><span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token punctuation\">{ \n   <!-- --><\/span> <span class=\"token keyword\">return<\/span> productNum<span class=\"token punctuation\">;<\/span> <span class=\"token punctuation\">}<\/span> <span class=\"token keyword\">public<\/span> <span class=\"token keyword\">void<\/span> <span class=\"token function\">setProductNum<\/span><span class=\"token punctuation\">(<\/span>String productNum<span class=\"token punctuation\">)<\/span> <span class=\"token punctuation\">{ \n   <!-- --><\/span> <span class=\"token keyword\">this<\/span><span class=\"token punctuation\">.<\/span>productNum <span class=\"token operator\">=<\/span> productNum<span class=\"token punctuation\">;<\/span> <span class=\"token punctuation\">}<\/span> <span class=\"token comment\">\/\/\u4ea7\u54c1\u540d\u79f0<\/span> <span class=\"token keyword\">public<\/span> String <span class=\"token function\">getProductName<\/span><span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token punctuation\">{ \n   <!-- --><\/span> <span class=\"token keyword\">return<\/span> productName<span class=\"token punctuation\">;<\/span> <span class=\"token punctuation\">}<\/span> <span class=\"token keyword\">public<\/span> <span class=\"token keyword\">void<\/span> <span class=\"token function\">setProductName<\/span><span class=\"token punctuation\">(<\/span>String productName<span class=\"token punctuation\">)<\/span> <span class=\"token punctuation\">{ \n   <!-- --><\/span> <span class=\"token keyword\">this<\/span><span class=\"token punctuation\">.<\/span>productName <span class=\"token operator\">=<\/span> productName<span class=\"token punctuation\">;<\/span> <span class=\"token punctuation\">}<\/span> <span class=\"token comment\">\/\/\u57ce\u5e02\u540d\u79f0<\/span> <span class=\"token keyword\">public<\/span> String <span class=\"token function\">getCityName<\/span><span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token punctuation\">{ \n   <!-- --><\/span> <span class=\"token keyword\">return<\/span> cityName<span class=\"token punctuation\">;<\/span> <span class=\"token punctuation\">}<\/span> <span class=\"token keyword\">public<\/span> <span class=\"token keyword\">void<\/span> <span class=\"token function\">setCityName<\/span><span class=\"token punctuation\">(<\/span>String cityName<span class=\"token punctuation\">)<\/span> <span class=\"token punctuation\">{ \n   <!-- --><\/span> <span class=\"token keyword\">this<\/span><span class=\"token punctuation\">.<\/span>cityName <span class=\"token operator\">=<\/span> cityName<span class=\"token punctuation\">;<\/span> <span class=\"token punctuation\">}<\/span> <span class=\"token comment\">\/\/\u51fa\u53d1\u65f6\u95f4<\/span> <span class=\"token keyword\">public<\/span> String <span class=\"token function\">getDepartureTime<\/span><span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token punctuation\">{ \n   <!-- --><\/span> <span class=\"token keyword\">return<\/span> departureTime<span class=\"token punctuation\">;<\/span> <span class=\"token punctuation\">}<\/span> <span class=\"token keyword\">public<\/span> <span class=\"token keyword\">void<\/span> <span class=\"token function\">setDepartureTime<\/span><span class=\"token punctuation\">(<\/span>String departureTime<span class=\"token punctuation\">)<\/span> <span class=\"token punctuation\">{ \n   <!-- --><\/span> <span class=\"token keyword\">this<\/span><span class=\"token punctuation\">.<\/span>departureTime <span class=\"token operator\">=<\/span> departureTime<span class=\"token punctuation\">;<\/span> <span class=\"token punctuation\">}<\/span> <span class=\"token comment\">\/\/\u4ea7\u54c1\u4ef7\u683c<\/span> <span class=\"token keyword\">public<\/span> Double <span class=\"token function\">getProductPrice<\/span><span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token punctuation\">{ \n   <!-- --><\/span> <span class=\"token keyword\">return<\/span> productPrice<span class=\"token punctuation\">;<\/span> <span class=\"token punctuation\">}<\/span> <span class=\"token keyword\">public<\/span> <span class=\"token keyword\">void<\/span> <span class=\"token function\">setProductPrice<\/span><span class=\"token punctuation\">(<\/span>Double productPrice<span class=\"token punctuation\">)<\/span> <span class=\"token punctuation\">{ \n   <!-- --><\/span> <span class=\"token keyword\">this<\/span><span class=\"token punctuation\">.<\/span>productPrice <span class=\"token operator\">=<\/span> productPrice<span class=\"token punctuation\">;<\/span> <span class=\"token punctuation\">}<\/span> <span class=\"token comment\">\/\/\u4ea7\u54c1\u63cf\u8ff0<\/span> <span class=\"token keyword\">public<\/span> String <span class=\"token function\">getProductDesc<\/span><span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token punctuation\">{ \n   <!-- --><\/span> <span class=\"token keyword\">return<\/span> productDesc<span class=\"token punctuation\">;<\/span> <span class=\"token punctuation\">}<\/span> <span class=\"token keyword\">public<\/span> <span class=\"token keyword\">void<\/span> <span class=\"token function\">setProductDesc<\/span><span class=\"token punctuation\">(<\/span>String productDesc<span class=\"token punctuation\">)<\/span> <span class=\"token punctuation\">{ \n   <!-- --><\/span> <span class=\"token keyword\">this<\/span><span class=\"token punctuation\">.<\/span>productDesc <span class=\"token operator\">=<\/span> productDesc<span class=\"token punctuation\">;<\/span> <span class=\"token punctuation\">}<\/span> <span class=\"token comment\">\/\/\u4ea7\u54c1\u72b6\u6001<\/span> <span class=\"token keyword\">public<\/span> Integer <span class=\"token function\">getProductStatus<\/span><span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token punctuation\">{ \n   <!-- --><\/span> <span class=\"token keyword\">return<\/span> productStatus<span class=\"token punctuation\">;<\/span> <span class=\"token punctuation\">}<\/span> <span class=\"token keyword\">public<\/span> <span class=\"token keyword\">void<\/span> <span class=\"token function\">setProductStatus<\/span><span class=\"token punctuation\">(<\/span>Integer productStatus<span class=\"token punctuation\">)<\/span> <span class=\"token punctuation\">{ \n   <!-- --><\/span> <span class=\"token keyword\">this<\/span><span class=\"token punctuation\">.<\/span>productStatus <span class=\"token operator\">=<\/span> productStatus<span class=\"token punctuation\">;<\/span> <span class=\"token punctuation\">}<\/span> <span class=\"token comment\">\/\/tostring\u65b9\u6cd5<\/span> <span class=\"token annotation punctuation\">@Override<\/span> <span class=\"token keyword\">public<\/span> String <span class=\"token function\">toString<\/span><span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token punctuation\">{ \n   <!-- --><\/span> <span class=\"token keyword\">return<\/span> <span class=\"token string\">\"Product [id=\"<\/span> <span class=\"token operator\">+<\/span> id <span class=\"token operator\">+<\/span> <span class=\"token string\">\", productNum=\"<\/span> <span class=\"token operator\">+<\/span> productNum <span class=\"token operator\">+<\/span> <span class=\"token string\">\", productName=\"<\/span> <span class=\"token operator\">+<\/span> productName <span class=\"token operator\">+<\/span> <span class=\"token string\">\", cityName=\"<\/span> <span class=\"token operator\">+<\/span> cityName <span class=\"token operator\">+<\/span> <span class=\"token string\">\", departureTime=\"<\/span> <span class=\"token operator\">+<\/span> departureTime <span class=\"token operator\">+<\/span> <span class=\"token string\">\", productPrice=\"<\/span> <span class=\"token operator\">+<\/span> productPrice <span class=\"token operator\">+<\/span> <span class=\"token string\">\", productDesc=\"<\/span> <span class=\"token operator\">+<\/span> productDesc <span class=\"token operator\">+<\/span> <span class=\"token string\">\", productStatus=\"<\/span> <span class=\"token operator\">+<\/span> productStatus <span class=\"token operator\">+<\/span> <span class=\"token string\">\"]\"<\/span><span class=\"token punctuation\">;<\/span> <span class=\"token punctuation\">}<\/span> <span class=\"token punctuation\">}<\/span> <\/code><\/pre>\n<blockquote>\n<p>\u5c06\u6570\u636e\u5e93\u4e2d\u7684\u6570\u636e\u8fdb\u884c\u5c01\u88c5\uff0c\u540c\u65f6\u6784\u5efa\u6709\u53c2\u548c\u65e0\u53c2\u7684\u6784\u9020\u65b9\u6cd5\u3002<br \/> \u521b\u5efa\u6bcf\u4e2a\u5b57\u6bb5\u7684get\/set\u65b9\u6cd5\u4ee5\u6b64\u6765\u8fdb\u884c\u6570\u636e\u7684\u5f15\u7528\u548c\u6dfb\u52a0\u3002<br \/> \u6784\u5efatoString()\u65b9\u6cd5\u5c06\u5c01\u88c5\u7c7b\u8f93\u51fa\u8f6c\u6362\u4e3aString\u7c7b\u578b<\/p>\n<\/blockquote>\n<p><strong>\u5728Eclipse\u4e2d\uff0c\u901a\u8fc7\u5728Prodect\u7c7b\u4e2d\u53f3\u952e\u2013&gt;Source\u53ef\u4ee5\u5b9e\u73b0\u5feb\u901f\u6784\u5efa\u6709\u53c2\/\u65e0\u53c2\u3001get\/set\u3001toString\u65b9\u6cd5\uff0c\u6b65\u9aa4\u5982\u4e0b\uff1a<\/strong><br \/> <img decoding=\"async\" src=\"https:\/\/img-blog.csdnimg.cn\/20201030234118546.png#pic_center\" =\"\" =\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\" alt=\"\u57fa\u4e8ejava\u7684\u65c5\u6e38\u7ba1\u7406\u7cfb\u7edf_\u9879\u76ee\u7ba1\u7406\u7cfb\u7edf\u6e90\u7801JAVA (https:\/\/mushiming.com\/)  \u7b2c4\u5f20\" title=\"\u57fa\u4e8ejava\u7684\u65c5\u6e38\u7ba1\u7406\u7cfb\u7edf_\u9879\u76ee\u7ba1\u7406\u7cfb\u7edf\u6e90\u7801JAVA  \u7b2c4\u5f20-\u7a46\u4e16\u660e\u535a\u5ba2\" ><br \/> <img decoding=\"async\" src=\"https:\/\/img-blog.csdnimg.cn\/20201030234426224.png\" =\"\" =\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\" alt=\"\u57fa\u4e8ejava\u7684\u65c5\u6e38\u7ba1\u7406\u7cfb\u7edf_\u9879\u76ee\u7ba1\u7406\u7cfb\u7edf\u6e90\u7801JAVA (https:\/\/mushiming.com\/)  \u7b2c5\u5f20\" title=\"\u57fa\u4e8ejava\u7684\u65c5\u6e38\u7ba1\u7406\u7cfb\u7edf_\u9879\u76ee\u7ba1\u7406\u7cfb\u7edf\u6e90\u7801JAVA  \u7b2c5\u5f20-\u7a46\u4e16\u660e\u535a\u5ba2\" ><br \/> <strong>1.\u6784\u5efa\u6709\u53c2\/\u65e0\u53c2\uff1a<\/strong><br \/> <img decoding=\"async\" src=\"https:\/\/img-blog.csdnimg.cn\/20201030234701162.png\" =\"\" =\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\" alt=\"\u57fa\u4e8ejava\u7684\u65c5\u6e38\u7ba1\u7406\u7cfb\u7edf_\u9879\u76ee\u7ba1\u7406\u7cfb\u7edf\u6e90\u7801JAVA (https:\/\/mushiming.com\/)  \u7b2c6\u5f20\" title=\"\u57fa\u4e8ejava\u7684\u65c5\u6e38\u7ba1\u7406\u7cfb\u7edf_\u9879\u76ee\u7ba1\u7406\u7cfb\u7edf\u6e90\u7801JAVA  \u7b2c6\u5f20-\u7a46\u4e16\u660e\u535a\u5ba2\" ><\/p>\n<blockquote>\n<p>\u6709\u53c2\u4e3a\u5168\u9009\uff08selectAll\uff09\uff0c\u65e0\u53c2\u4e3a\u5168\u4e0d\u9009\uff08deselectAll\uff09<\/p>\n<\/blockquote>\n<p><strong>2.Get\/Set\u65b9\u6cd5<\/strong><br \/> <img decoding=\"async\" src=\"https:\/\/img-blog.csdnimg.cn\/20201030235005106.png\" =\"\" =\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\" alt=\"\u57fa\u4e8ejava\u7684\u65c5\u6e38\u7ba1\u7406\u7cfb\u7edf_\u9879\u76ee\u7ba1\u7406\u7cfb\u7edf\u6e90\u7801JAVA (https:\/\/mushiming.com\/)  \u7b2c7\u5f20\" title=\"\u57fa\u4e8ejava\u7684\u65c5\u6e38\u7ba1\u7406\u7cfb\u7edf_\u9879\u76ee\u7ba1\u7406\u7cfb\u7edf\u6e90\u7801JAVA  \u7b2c7\u5f20-\u7a46\u4e16\u660e\u535a\u5ba2\" ><br \/> 3.toString\u65b9\u6cd5<br \/> <img decoding=\"async\" src=\"https:\/\/img-blog.csdnimg.cn\/20201030235102734.png\" =\"\" =\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\" alt=\"\u57fa\u4e8ejava\u7684\u65c5\u6e38\u7ba1\u7406\u7cfb\u7edf_\u9879\u76ee\u7ba1\u7406\u7cfb\u7edf\u6e90\u7801JAVA (https:\/\/mushiming.com\/)  \u7b2c8\u5f20\" title=\"\u57fa\u4e8ejava\u7684\u65c5\u6e38\u7ba1\u7406\u7cfb\u7edf_\u9879\u76ee\u7ba1\u7406\u7cfb\u7edf\u6e90\u7801JAVA  \u7b2c8\u5f20-\u7a46\u4e16\u660e\u535a\u5ba2\" ><\/p>\n<h4>\u6570\u636e\u5e93\u64cd\u4f5c\u7c7b\uff08Dao\uff09<\/h4>\n<pre><code class=\"prism language-java\"><span class=\"token keyword\">package<\/span> com<span class=\"token punctuation\">.<\/span>yzw<span class=\"token punctuation\">.<\/span>dao<span class=\"token punctuation\">;<\/span> <span class=\"token keyword\">import<\/span> java<span class=\"token punctuation\">.<\/span>util<span class=\"token punctuation\">.<\/span>List<span class=\"token punctuation\">;<\/span> <span class=\"token keyword\">import<\/span> org<span class=\"token punctuation\">.<\/span>apache<span class=\"token punctuation\">.<\/span>ibatis<span class=\"token punctuation\">.<\/span>annotations<span class=\"token punctuation\">.<\/span>Delete<span class=\"token punctuation\">;<\/span> <span class=\"token keyword\">import<\/span> org<span class=\"token punctuation\">.<\/span>apache<span class=\"token punctuation\">.<\/span>ibatis<span class=\"token punctuation\">.<\/span>annotations<span class=\"token punctuation\">.<\/span>Insert<span class=\"token punctuation\">;<\/span> <span class=\"token keyword\">import<\/span> org<span class=\"token punctuation\">.<\/span>apache<span class=\"token punctuation\">.<\/span>ibatis<span class=\"token punctuation\">.<\/span>annotations<span class=\"token punctuation\">.<\/span>Select<span class=\"token punctuation\">;<\/span> <span class=\"token keyword\">import<\/span> org<span class=\"token punctuation\">.<\/span>apache<span class=\"token punctuation\">.<\/span>ibatis<span class=\"token punctuation\">.<\/span>annotations<span class=\"token punctuation\">.<\/span>Update<span class=\"token punctuation\">;<\/span> <span class=\"token keyword\">import<\/span> com<span class=\"token punctuation\">.<\/span>yzw<span class=\"token punctuation\">.<\/span>entity<span class=\"token punctuation\">.<\/span>Product<span class=\"token punctuation\">;<\/span> <span class=\"token keyword\">public<\/span> <span class=\"token keyword\">interface<\/span> <span class=\"token class-name\">ProductDao<\/span> <span class=\"token punctuation\">{ \n   <!-- --><\/span> <span class=\"token comment\">\/\/ \u67e5\u8be2\u8bed\u53e5<\/span> <span class=\"token annotation punctuation\">@Select<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string\">\"select * from product\"<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token keyword\">public<\/span> List<span class=\"token generics function\"><span class=\"token punctuation\">&lt;<\/span>Product<span class=\"token punctuation\">&gt;<\/span><\/span> <span class=\"token function\">selectAll<\/span><span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span> <span class=\"token comment\">\/\/ \u6dfb\u52a0\u8bed\u53e5<\/span> <span class=\"token annotation punctuation\">@Insert<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string\">\"insert product values(#{id},#{productNum},#{productName},#{cityName},#{departureTime},#{productPrice},#{productDesc},#{productStatus})\"<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token keyword\">public<\/span> <span class=\"token keyword\">int<\/span> <span class=\"token function\">insertProduct<\/span><span class=\"token punctuation\">(<\/span>Product product<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span> <span class=\"token comment\">\/\/ \u5220\u9664\u8bed\u53e5<\/span> <span class=\"token annotation punctuation\">@Delete<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string\">\"delete from product where id=#{id}\"<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token keyword\">public<\/span> <span class=\"token keyword\">int<\/span> <span class=\"token function\">deleteProduct<\/span><span class=\"token punctuation\">(<\/span><span class=\"token keyword\">int<\/span> id<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span> <span class=\"token comment\">\/\/ \u4fee\u6539\u8bed\u53e5<\/span> <span class=\"token annotation punctuation\">@Update<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string\">\"update product set productNum=#{productNum},productName=#{productName},cityName=#{cityName},departureTime=#{departureTime},productPrice=#{productPrice},productDesc=#{productDesc},productStatus=#{productStatus} where id=#{id}\"<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token keyword\">public<\/span> <span class=\"token keyword\">int<\/span> <span class=\"token function\">updateProduct<\/span><span class=\"token punctuation\">(<\/span>Product product<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span> <span class=\"token comment\">\/\/ \u6839\u636eid\u67e5\u8be2\u8bed\u53e5(\u901a\u8fc7id\u5411\u4fee\u6539\u9875\u9762\u4f20\u503c)<\/span> <span class=\"token annotation punctuation\">@Select<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string\">\"select * from product where id = #{id}\"<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token keyword\">public<\/span> Product <span class=\"token function\">selectProductById<\/span><span class=\"token punctuation\">(<\/span>Integer id<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span> <span class=\"token comment\">\/\/ \u5355\u884c\u5220\u9664\u8bed\u53e5<\/span> <span class=\"token annotation punctuation\">@Delete<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string\">\"delete from product where id=#{id}\"<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token keyword\">public<\/span> <span class=\"token keyword\">int<\/span> <span class=\"token function\">deleteProductOne<\/span><span class=\"token punctuation\">(<\/span>Integer id<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span> <span class=\"token punctuation\">}<\/span> <\/code><\/pre>\n<h4>Service\u5c42\u63a5\u53e3\u5b9e\u73b0\u7c7b\uff08ServiceImpl\uff09<\/h4>\n<pre><code class=\"prism language-java\"><span class=\"token keyword\">package<\/span> com<span class=\"token punctuation\">.<\/span>yzw<span class=\"token punctuation\">.<\/span>service<span class=\"token punctuation\">.<\/span>impl<span class=\"token punctuation\">;<\/span> <span class=\"token keyword\">import<\/span> java<span class=\"token punctuation\">.<\/span>util<span class=\"token punctuation\">.<\/span>List<span class=\"token punctuation\">;<\/span> <span class=\"token keyword\">import<\/span> org<span class=\"token punctuation\">.<\/span>springframework<span class=\"token punctuation\">.<\/span>beans<span class=\"token punctuation\">.<\/span>factory<span class=\"token punctuation\">.<\/span>annotation<span class=\"token punctuation\">.<\/span>Autowired<span class=\"token punctuation\">;<\/span> <span class=\"token keyword\">import<\/span> org<span class=\"token punctuation\">.<\/span>springframework<span class=\"token punctuation\">.<\/span>stereotype<span class=\"token punctuation\">.<\/span>Service<span class=\"token punctuation\">;<\/span> <span class=\"token keyword\">import<\/span> com<span class=\"token punctuation\">.<\/span>yzw<span class=\"token punctuation\">.<\/span>dao<span class=\"token punctuation\">.<\/span>ProductDao<span class=\"token punctuation\">;<\/span> <span class=\"token keyword\">import<\/span> com<span class=\"token punctuation\">.<\/span>yzw<span class=\"token punctuation\">.<\/span>entity<span class=\"token punctuation\">.<\/span>Product<span class=\"token punctuation\">;<\/span> <span class=\"token keyword\">import<\/span> com<span class=\"token punctuation\">.<\/span>yzw<span class=\"token punctuation\">.<\/span>service<span class=\"token punctuation\">.<\/span>ProductService<span class=\"token punctuation\">;<\/span> <span class=\"token annotation punctuation\">@Service<\/span> <span class=\"token keyword\">public<\/span> <span class=\"token keyword\">class<\/span> <span class=\"token class-name\">ProductServiceImpl<\/span> <span class=\"token keyword\">implements<\/span> <span class=\"token class-name\">ProductService<\/span> <span class=\"token punctuation\">{ \n   <!-- --><\/span> <span class=\"token comment\">\/\/ \u58f0\u660e\u53d8\u91cf<\/span> <span class=\"token annotation punctuation\">@Autowired<\/span> <span class=\"token comment\">\/\/ \u53d8\u91cf\u6ce8\u89e3:\u4e0d\u4e3a\u7a7a<\/span> <span class=\"token keyword\">private<\/span> ProductDao productDao<span class=\"token punctuation\">;<\/span> <span class=\"token comment\">\/\/ \u5b9e\u4f53\u7c7b\u8fd4\u56deDAO\u5c42\u7684\u67e5\u8be2\u6570\u636e<\/span> <span class=\"token annotation punctuation\">@Override<\/span> <span class=\"token keyword\">public<\/span> List<span class=\"token generics function\"><span class=\"token punctuation\">&lt;<\/span>Product<span class=\"token punctuation\">&gt;<\/span><\/span> <span class=\"token function\">selectAll<\/span><span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token punctuation\">{ \n   <!-- --><\/span> <span class=\"token comment\">\/\/ TODO Auto-generated method stub<\/span> <span class=\"token keyword\">return<\/span> productDao<span class=\"token punctuation\">.<\/span><span class=\"token function\">selectAll<\/span><span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span> <span class=\"token punctuation\">}<\/span> <span class=\"token annotation punctuation\">@Override<\/span> <span class=\"token keyword\">public<\/span> <span class=\"token keyword\">int<\/span> <span class=\"token function\">insertProduct<\/span><span class=\"token punctuation\">(<\/span>Product product<span class=\"token punctuation\">)<\/span> <span class=\"token punctuation\">{ \n   <!-- --><\/span> <span class=\"token comment\">\/\/ TODO Auto-generated method stub<\/span> <span class=\"token keyword\">return<\/span> productDao<span class=\"token punctuation\">.<\/span><span class=\"token function\">insertProduct<\/span><span class=\"token punctuation\">(<\/span>product<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span> <span class=\"token punctuation\">}<\/span> <span class=\"token annotation punctuation\">@Override<\/span> <span class=\"token keyword\">public<\/span> <span class=\"token keyword\">boolean<\/span> <span class=\"token function\">deleteProduct<\/span><span class=\"token punctuation\">(<\/span>Integer<span class=\"token punctuation\">[<\/span><span class=\"token punctuation\">]<\/span> ids<span class=\"token punctuation\">)<\/span> <span class=\"token punctuation\">{ \n   <!-- --><\/span> <span class=\"token comment\">\/\/ TODO Auto-generated method stub<\/span> <span class=\"token keyword\">for<\/span> <span class=\"token punctuation\">(<\/span><span class=\"token keyword\">int<\/span> i <span class=\"token operator\">=<\/span> <span class=\"token number\">0<\/span><span class=\"token punctuation\">;<\/span> i <span class=\"token operator\">&lt;<\/span> ids<span class=\"token punctuation\">.<\/span>length<span class=\"token punctuation\">;<\/span> i<span class=\"token operator\">++<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token punctuation\">{ \n   <!-- --><\/span> productDao<span class=\"token punctuation\">.<\/span><span class=\"token function\">deleteProduct<\/span><span class=\"token punctuation\">(<\/span>ids<span class=\"token punctuation\">[<\/span>i<span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span> <span class=\"token punctuation\">}<\/span> <span class=\"token keyword\">return<\/span> <span class=\"token boolean\">true<\/span><span class=\"token punctuation\">;<\/span> <span class=\"token punctuation\">}<\/span> <span class=\"token annotation punctuation\">@Override<\/span> <span class=\"token keyword\">public<\/span> <span class=\"token keyword\">int<\/span> <span class=\"token function\">updateProduct<\/span><span class=\"token punctuation\">(<\/span>Product product<span class=\"token punctuation\">)<\/span> <span class=\"token punctuation\">{ \n   <!-- --><\/span> <span class=\"token comment\">\/\/ TODO Auto-generated method stub<\/span> <span class=\"token keyword\">return<\/span> productDao<span class=\"token punctuation\">.<\/span><span class=\"token function\">updateProduct<\/span><span class=\"token punctuation\">(<\/span>product<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span> <span class=\"token punctuation\">}<\/span> <span class=\"token annotation punctuation\">@Override<\/span> <span class=\"token keyword\">public<\/span> Product <span class=\"token function\">selectProductById<\/span><span class=\"token punctuation\">(<\/span>Integer id<span class=\"token punctuation\">)<\/span> <span class=\"token punctuation\">{ \n   <!-- --><\/span> <span class=\"token comment\">\/\/ TODO Auto-generated method stub<\/span> <span class=\"token keyword\">return<\/span> productDao<span class=\"token punctuation\">.<\/span><span class=\"token function\">selectProductById<\/span><span class=\"token punctuation\">(<\/span>id<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span> <span class=\"token punctuation\">}<\/span> <span class=\"token annotation punctuation\">@Override<\/span> <span class=\"token keyword\">public<\/span> <span class=\"token keyword\">int<\/span> <span class=\"token function\">deleteProductOne<\/span><span class=\"token punctuation\">(<\/span>Integer id<span class=\"token punctuation\">)<\/span> <span class=\"token punctuation\">{ \n   <!-- --><\/span> <span class=\"token comment\">\/\/ TODO Auto-generated method stub<\/span> <span class=\"token keyword\">return<\/span> productDao<span class=\"token punctuation\">.<\/span><span class=\"token function\">deleteProductOne<\/span><span class=\"token punctuation\">(<\/span>id<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span> <span class=\"token punctuation\">}<\/span> <span class=\"token punctuation\">}<\/span> <\/code><\/pre>\n<h4>Service\u5c42\u63a5\u53e3\uff08Service\uff09<\/h4>\n<pre><code class=\"prism language-java\"><span class=\"token keyword\">package<\/span> com<span class=\"token punctuation\">.<\/span>yzw<span class=\"token punctuation\">.<\/span>service<span class=\"token punctuation\">;<\/span> <span class=\"token keyword\">import<\/span> java<span class=\"token punctuation\">.<\/span>util<span class=\"token punctuation\">.<\/span>List<span class=\"token punctuation\">;<\/span> <span class=\"token keyword\">import<\/span> com<span class=\"token punctuation\">.<\/span>yzw<span class=\"token punctuation\">.<\/span>entity<span class=\"token punctuation\">.<\/span>Product<span class=\"token punctuation\">;<\/span> <span class=\"token keyword\">public<\/span> <span class=\"token keyword\">interface<\/span> <span class=\"token class-name\">ProductService<\/span> <span class=\"token punctuation\">{ \n   <!-- --><\/span> <span class=\"token comment\">\/\/ \u8fd4\u56de\u5b9e\u4f53\u7c7b\u7684\u67e5\u8be2\u7ed3\u679c<\/span> List<span class=\"token generics function\"><span class=\"token punctuation\">&lt;<\/span>Product<span class=\"token punctuation\">&gt;<\/span><\/span> <span class=\"token function\">selectAll<\/span><span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span> <span class=\"token keyword\">int<\/span> <span class=\"token function\">insertProduct<\/span><span class=\"token punctuation\">(<\/span>Product product<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span> <span class=\"token keyword\">boolean<\/span> <span class=\"token function\">deleteProduct<\/span><span class=\"token punctuation\">(<\/span>Integer<span class=\"token punctuation\">[<\/span><span class=\"token punctuation\">]<\/span> ids<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span> <span class=\"token keyword\">int<\/span> <span class=\"token function\">updateProduct<\/span><span class=\"token punctuation\">(<\/span>Product product<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span> Product <span class=\"token function\">selectProductById<\/span><span class=\"token punctuation\">(<\/span>Integer id<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span> <span class=\"token keyword\">int<\/span> <span class=\"token function\">deleteProductOne<\/span><span class=\"token punctuation\">(<\/span>Integer id<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span> <span class=\"token punctuation\">}<\/span> <\/code><\/pre>\n<h4>\u63a7\u5236\u5668\u5c42\uff08Controller\uff09<\/h4>\n<pre><code class=\"prism language-java\"><span class=\"token keyword\">package<\/span> com<span class=\"token punctuation\">.<\/span>yzw<span class=\"token punctuation\">.<\/span>controller<span class=\"token punctuation\">;<\/span> <span class=\"token keyword\">import<\/span> java<span class=\"token punctuation\">.<\/span>util<span class=\"token punctuation\">.<\/span>List<span class=\"token punctuation\">;<\/span> <span class=\"token keyword\">import<\/span> org<span class=\"token punctuation\">.<\/span>springframework<span class=\"token punctuation\">.<\/span>beans<span class=\"token punctuation\">.<\/span>factory<span class=\"token punctuation\">.<\/span>annotation<span class=\"token punctuation\">.<\/span>Autowired<span class=\"token punctuation\">;<\/span> <span class=\"token keyword\">import<\/span> org<span class=\"token punctuation\">.<\/span>springframework<span class=\"token punctuation\">.<\/span>stereotype<span class=\"token punctuation\">.<\/span>Controller<span class=\"token punctuation\">;<\/span> <span class=\"token keyword\">import<\/span> org<span class=\"token punctuation\">.<\/span>springframework<span class=\"token punctuation\">.<\/span>web<span class=\"token punctuation\">.<\/span>bind<span class=\"token punctuation\">.<\/span>annotation<span class=\"token punctuation\">.<\/span>RequestMapping<span class=\"token punctuation\">;<\/span> <span class=\"token keyword\">import<\/span> org<span class=\"token punctuation\">.<\/span>springframework<span class=\"token punctuation\">.<\/span>web<span class=\"token punctuation\">.<\/span>bind<span class=\"token punctuation\">.<\/span>annotation<span class=\"token punctuation\">.<\/span>RequestParam<span class=\"token punctuation\">;<\/span> <span class=\"token keyword\">import<\/span> org<span class=\"token punctuation\">.<\/span>springframework<span class=\"token punctuation\">.<\/span>web<span class=\"token punctuation\">.<\/span>bind<span class=\"token punctuation\">.<\/span>annotation<span class=\"token punctuation\">.<\/span>ResponseBody<span class=\"token punctuation\">;<\/span> <span class=\"token keyword\">import<\/span> org<span class=\"token punctuation\">.<\/span>springframework<span class=\"token punctuation\">.<\/span>web<span class=\"token punctuation\">.<\/span>servlet<span class=\"token punctuation\">.<\/span>ModelAndView<span class=\"token punctuation\">;<\/span> <span class=\"token keyword\">import<\/span> com<span class=\"token punctuation\">.<\/span>github<span class=\"token punctuation\">.<\/span>pagehelper<span class=\"token punctuation\">.<\/span>PageHelper<span class=\"token punctuation\">;<\/span> <span class=\"token keyword\">import<\/span> com<span class=\"token punctuation\">.<\/span>github<span class=\"token punctuation\">.<\/span>pagehelper<span class=\"token punctuation\">.<\/span>PageInfo<span class=\"token punctuation\">;<\/span> <span class=\"token keyword\">import<\/span> com<span class=\"token punctuation\">.<\/span>yzw<span class=\"token punctuation\">.<\/span>entity<span class=\"token punctuation\">.<\/span>Product<span class=\"token punctuation\">;<\/span> <span class=\"token keyword\">import<\/span> com<span class=\"token punctuation\">.<\/span>yzw<span class=\"token punctuation\">.<\/span>service<span class=\"token punctuation\">.<\/span>ProductService<span class=\"token punctuation\">;<\/span> <span class=\"token annotation punctuation\">@Controller<\/span> <span class=\"token annotation punctuation\">@RequestMapping<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string\">\"\/product\"<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token keyword\">public<\/span> <span class=\"token keyword\">class<\/span> <span class=\"token class-name\">ProductController<\/span> <span class=\"token punctuation\">{ \n   <!-- --><\/span> <span class=\"token comment\">\/\/ \u58f0\u660e\u53d8\u91cf<\/span> <span class=\"token annotation punctuation\">@Autowired<\/span> <span class=\"token comment\">\/\/ \u53d8\u91cf\u6ce8\u89e3:\u4e0d\u4e3a\u7a7a<\/span> <span class=\"token keyword\">private<\/span> ProductService productService<span class=\"token punctuation\">;<\/span> <span class=\"token comment\">\/\/ \u53ea\u8fd4\u56de\u6570\u636e\u7684\u65b9\u6cd5<\/span> <span class=\"token annotation punctuation\">@RequestMapping<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string\">\"selectAllData\"<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token annotation punctuation\">@ResponseBody<\/span> <span class=\"token keyword\">public<\/span> PageInfo<span class=\"token generics function\"><span class=\"token punctuation\">&lt;<\/span>Product<span class=\"token punctuation\">&gt;<\/span><\/span> <span class=\"token function\">selectAllData<\/span><span class=\"token punctuation\">(<\/span> <span class=\"token annotation punctuation\">@RequestParam<\/span><span class=\"token punctuation\">(<\/span>name <span class=\"token operator\">=<\/span> <span class=\"token string\">\"pageNum\"<\/span><span class=\"token punctuation\">,<\/span> defaultValue <span class=\"token operator\">=<\/span> <span class=\"token string\">\"1\"<\/span><span class=\"token punctuation\">,<\/span> required <span class=\"token operator\">=<\/span> <span class=\"token boolean\">false<\/span><span class=\"token punctuation\">)<\/span> Integer pageNum<span class=\"token punctuation\">,<\/span> <span class=\"token annotation punctuation\">@RequestParam<\/span><span class=\"token punctuation\">(<\/span>name <span class=\"token operator\">=<\/span> <span class=\"token string\">\"pageSize\"<\/span><span class=\"token punctuation\">,<\/span> defaultValue <span class=\"token operator\">=<\/span> <span class=\"token string\">\"20\"<\/span><span class=\"token punctuation\">,<\/span> required <span class=\"token operator\">=<\/span> <span class=\"token boolean\">false<\/span><span class=\"token punctuation\">)<\/span> Integer pageSize<span class=\"token punctuation\">)<\/span> <span class=\"token punctuation\">{ \n   <!-- --><\/span> <span class=\"token comment\">\/\/ 1.\u5f00\u542f\u5206\u9875<\/span> PageHelper<span class=\"token punctuation\">.<\/span><span class=\"token function\">startPage<\/span><span class=\"token punctuation\">(<\/span>pageNum<span class=\"token punctuation\">,<\/span> pageSize<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span> <span class=\"token comment\">\/\/ 2.\u6267\u884c\u67e5\u8be2\u8bed\u53e5<\/span> List<span class=\"token generics function\"><span class=\"token punctuation\">&lt;<\/span>Product<span class=\"token punctuation\">&gt;<\/span><\/span> list <span class=\"token operator\">=<\/span> productService<span class=\"token punctuation\">.<\/span><span class=\"token function\">selectAll<\/span><span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span> <span class=\"token comment\">\/\/ 3.\u5c01\u88c5pageinfo\u7c7b<\/span> PageInfo<span class=\"token generics function\"><span class=\"token punctuation\">&lt;<\/span>Product<span class=\"token punctuation\">&gt;<\/span><\/span> pageInfo <span class=\"token operator\">=<\/span> <span class=\"token keyword\">new<\/span> <span class=\"token class-name\">PageInfo<\/span><span class=\"token generics function\"><span class=\"token punctuation\">&lt;<\/span>Product<span class=\"token punctuation\">&gt;<\/span><\/span><span class=\"token punctuation\">(<\/span>list<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span> <span class=\"token keyword\">return<\/span> pageInfo<span class=\"token punctuation\">;<\/span> <span class=\"token punctuation\">}<\/span> <span class=\"token comment\">\/\/ \u53ea\u8fd4\u56de\u9875\u9762\u7684\u65b9\u6cd5<\/span> <span class=\"token annotation punctuation\">@RequestMapping<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string\">\"selectAllView\"<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token keyword\">public<\/span> ModelAndView <span class=\"token function\">selectAllView<\/span><span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token punctuation\">{ \n   <!-- --><\/span> ModelAndView mav <span class=\"token operator\">=<\/span> <span class=\"token keyword\">new<\/span> <span class=\"token class-name\">ModelAndView<\/span><span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span> mav<span class=\"token punctuation\">.<\/span><span class=\"token function\">setViewName<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string\">\"product-list\"<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span> <span class=\"token keyword\">return<\/span> mav<span class=\"token punctuation\">;<\/span> <span class=\"token punctuation\">}<\/span> <span class=\"token comment\">\/* 2.\u6dfb\u52a0\u4ea7\u54c1 *\/<\/span> <span class=\"token annotation punctuation\">@RequestMapping<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string\">\"\/insertProduct\"<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token annotation punctuation\">@ResponseBody<\/span> <span class=\"token keyword\">public<\/span> ModelAndView <span class=\"token function\">insertProduct<\/span><span class=\"token punctuation\">(<\/span>Product product<span class=\"token punctuation\">)<\/span> <span class=\"token punctuation\">{ \n   <!-- --><\/span> ModelAndView mav <span class=\"token operator\">=<\/span> <span class=\"token keyword\">new<\/span> <span class=\"token class-name\">ModelAndView<\/span><span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span> <span class=\"token keyword\">int<\/span> flag <span class=\"token operator\">=<\/span> productService<span class=\"token punctuation\">.<\/span><span class=\"token function\">insertProduct<\/span><span class=\"token punctuation\">(<\/span>product<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span> <span class=\"token keyword\">if<\/span> <span class=\"token punctuation\">(<\/span>flag <span class=\"token operator\">==<\/span> <span class=\"token number\">0<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token punctuation\">{ \n   <!-- --><\/span><span class=\"token comment\">\/\/ \u6dfb\u52a0\u5931\u8d25\u8fd4\u56de\u672c\u9875\u9762<\/span> mav<span class=\"token punctuation\">.<\/span><span class=\"token function\">setViewName<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string\">\"product-add\"<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span> <span class=\"token punctuation\">}<\/span> <span class=\"token keyword\">else<\/span> <span class=\"token punctuation\">{ \n   <!-- --><\/span><span class=\"token comment\">\/\/ \u8fd4\u56de\u4ea7\u54c1\u5217\u8868\u9875\u9762\uff0c\u5e76\u67e5\u8be2\u6570\u636e<\/span> <span class=\"token comment\">\/\/ \u6267\u884c\u67e5\u8be2\u5168\u90e8\u4ea7\u54c1<\/span> mav <span class=\"token operator\">=<\/span> <span class=\"token function\">selectAllView<\/span><span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span> <span class=\"token punctuation\">}<\/span> <span class=\"token keyword\">return<\/span> mav<span class=\"token punctuation\">;<\/span> <span class=\"token punctuation\">}<\/span> <span class=\"token comment\">\/* 3.\u6279\u91cf\u5220\u9664\u4ea7\u54c1 *\/<\/span> <span class=\"token annotation punctuation\">@RequestMapping<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string\">\"\/deleteProducts\"<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token annotation punctuation\">@ResponseBody<\/span> <span class=\"token keyword\">public<\/span> <span class=\"token keyword\">boolean<\/span> <span class=\"token function\">deleteProduct<\/span><span class=\"token punctuation\">(<\/span>Integer<span class=\"token punctuation\">[<\/span><span class=\"token punctuation\">]<\/span> ids<span class=\"token punctuation\">)<\/span> <span class=\"token punctuation\">{ \n   <!-- --><\/span> <span class=\"token keyword\">return<\/span> productService<span class=\"token punctuation\">.<\/span><span class=\"token function\">deleteProduct<\/span><span class=\"token punctuation\">(<\/span>ids<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span> <span class=\"token punctuation\">}<\/span> <span class=\"token comment\">\/* 4.\u5355\u884c\u5220\u9664\u4ea7\u54c1 *\/<\/span> <span class=\"token annotation punctuation\">@RequestMapping<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string\">\"\/deleteProductOne\"<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token annotation punctuation\">@ResponseBody<\/span> <span class=\"token keyword\">public<\/span> <span class=\"token keyword\">int<\/span> <span class=\"token function\">deleteProductOne<\/span><span class=\"token punctuation\">(<\/span>Integer id<span class=\"token punctuation\">)<\/span> <span class=\"token punctuation\">{ \n   <!-- --><\/span> <span class=\"token keyword\">return<\/span> productService<span class=\"token punctuation\">.<\/span><span class=\"token function\">deleteProductOne<\/span><span class=\"token punctuation\">(<\/span>id<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span> <span class=\"token punctuation\">}<\/span> <span class=\"token comment\">\/* 5.\u4fee\u6539\u4ea7\u54c1 *\/<\/span> <span class=\"token annotation punctuation\">@RequestMapping<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string\">\"\/updateProduct\"<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token annotation punctuation\">@ResponseBody<\/span> <span class=\"token keyword\">public<\/span> ModelAndView <span class=\"token function\">updateProduct<\/span><span class=\"token punctuation\">(<\/span>Integer id<span class=\"token punctuation\">)<\/span> <span class=\"token punctuation\">{ \n   <!-- --><\/span> <span class=\"token comment\">\/\/ 1.\u83b7\u53d6\u8981\u4fee\u6539\u7684\u4fe1\u606f<\/span> Product product <span class=\"token operator\">=<\/span> productService<span class=\"token punctuation\">.<\/span><span class=\"token function\">selectProductById<\/span><span class=\"token punctuation\">(<\/span>id<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span> <span class=\"token comment\">\/\/ 2.\u8df3\u8f6c\u5230\u4fee\u6539\u9875\u9762<\/span> ModelAndView mav <span class=\"token operator\">=<\/span> <span class=\"token keyword\">new<\/span> <span class=\"token class-name\">ModelAndView<\/span><span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span> mav<span class=\"token punctuation\">.<\/span><span class=\"token function\">setViewName<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string\">\"product-update\"<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span> mav<span class=\"token punctuation\">.<\/span><span class=\"token function\">addObject<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string\">\"product\"<\/span><span class=\"token punctuation\">,<\/span> product<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span> <span class=\"token keyword\">return<\/span> mav<span class=\"token punctuation\">;<\/span> <span class=\"token punctuation\">}<\/span> <span class=\"token comment\">\/\/ 6.\u4fee\u6539\u4ea7\u54c1,\u8fd4\u56de\u9875\u9762<\/span> <span class=\"token annotation punctuation\">@RequestMapping<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string\">\"\/updateProductData\"<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token keyword\">public<\/span> ModelAndView <span class=\"token function\">updateProductData<\/span><span class=\"token punctuation\">(<\/span>Product product<span class=\"token punctuation\">)<\/span> <span class=\"token punctuation\">{ \n   <!-- --><\/span> <span class=\"token comment\">\/\/ 1.\u83b7\u53d6\u8981\u4fee\u6539\u7684\u4fe1\u606f<\/span> <span class=\"token keyword\">int<\/span> flag <span class=\"token operator\">=<\/span> productService<span class=\"token punctuation\">.<\/span><span class=\"token function\">updateProduct<\/span><span class=\"token punctuation\">(<\/span>product<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span> <span class=\"token comment\">\/\/ 2.\u8df3\u8f6c\u5230\u5bf9\u5e94\u9875\u9762<\/span> ModelAndView mav <span class=\"token operator\">=<\/span> <span class=\"token keyword\">new<\/span> <span class=\"token class-name\">ModelAndView<\/span><span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span> <span class=\"token keyword\">if<\/span> <span class=\"token punctuation\">(<\/span>flag <span class=\"token operator\">&gt;<\/span> <span class=\"token number\">0<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token punctuation\">{ \n   <!-- --><\/span><span class=\"token comment\">\/\/ \u4fee\u6539\u6210\u529f\uff0c\u8df3\u8f6c\u5230\u4ea7\u54c1\u5217\u8868\u9875\u9762<\/span> mav<span class=\"token punctuation\">.<\/span><span class=\"token function\">setViewName<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string\">\"product-list\"<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span> <span class=\"token punctuation\">}<\/span> <span class=\"token keyword\">else<\/span> <span class=\"token punctuation\">{ \n   <!-- --><\/span><span class=\"token comment\">\/\/ \u4fee\u6539\u5931\u8d25\uff0c\u7ee7\u7eed\u56de\u5230\u4fee\u6539\u9875\u9762<\/span> mav<span class=\"token punctuation\">.<\/span><span class=\"token function\">setViewName<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string\">\"product-update\"<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span> <span class=\"token punctuation\">}<\/span> <span class=\"token keyword\">return<\/span> mav<span class=\"token punctuation\">;<\/span> <span class=\"token punctuation\">}<\/span> <span class=\"token punctuation\">}<\/span> <\/code><\/pre>\n<h3>\u6570\u636e\u5e93\uff08Mysql\uff09<\/h3>\n<pre class=\"language-java prettyprint linenums\"><code class=\"prism language-sql\"><span class=\"token comment\">-- \u521b\u5e93<\/span> <span class=\"token keyword\">drop<\/span> <span class=\"token keyword\">database<\/span> <span class=\"token keyword\">if<\/span> <span class=\"token keyword\">exists<\/span> pms<span class=\"token punctuation\">;<\/span> <span class=\"token keyword\">create<\/span> <span class=\"token keyword\">database<\/span> pms <span class=\"token keyword\">character<\/span> <span class=\"token keyword\">set<\/span> utf8<span class=\"token punctuation\">;<\/span> <span class=\"token keyword\">use<\/span> pms<span class=\"token punctuation\">;<\/span> <span class=\"token comment\">#\u4ea7\u54c1\u8868 product<\/span> <span class=\"token keyword\">drop<\/span> <span class=\"token keyword\">table<\/span> <span class=\"token keyword\">if<\/span> <span class=\"token keyword\">exists<\/span> product<span class=\"token punctuation\">;<\/span> <span class=\"token keyword\">create<\/span> <span class=\"token keyword\">table<\/span> product<span class=\"token punctuation\">(<\/span> id <span class=\"token keyword\">int<\/span><span class=\"token punctuation\">(<\/span><span class=\"token number\">11<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token operator\">not<\/span> <span class=\"token boolean\">null<\/span> <span class=\"token keyword\">primary<\/span> <span class=\"token keyword\">key<\/span> <span class=\"token keyword\">auto_increment<\/span> <span class=\"token keyword\">comment<\/span> <span class=\"token string\">'\u4e3b\u952e'<\/span><span class=\"token punctuation\">,<\/span> productNum <span class=\"token keyword\">varchar<\/span><span class=\"token punctuation\">(<\/span><span class=\"token number\">60<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token operator\">not<\/span> <span class=\"token boolean\">null<\/span> <span class=\"token keyword\">unique<\/span> <span class=\"token keyword\">comment<\/span> <span class=\"token string\">'\u4ea7\u54c1\u7f16\u53f7'<\/span><span class=\"token punctuation\">,<\/span> productName <span class=\"token keyword\">varchar<\/span><span class=\"token punctuation\">(<\/span><span class=\"token number\">60<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token keyword\">comment<\/span> <span class=\"token string\">'\u4ea7\u54c1\u540d\u79f0'<\/span><span class=\"token punctuation\">,<\/span> cityName <span class=\"token keyword\">varchar<\/span><span class=\"token punctuation\">(<\/span><span class=\"token number\">20<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token keyword\">comment<\/span> <span class=\"token string\">'\u51fa\u53d1\u57ce\u5e02'<\/span><span class=\"token punctuation\">,<\/span> departureTime <span class=\"token keyword\">datetime<\/span> <span class=\"token keyword\">comment<\/span> <span class=\"token string\">'\u51fa\u53d1\u65f6\u95f4'<\/span><span class=\"token punctuation\">,<\/span> productPrice <span class=\"token keyword\">double<\/span><span class=\"token punctuation\">(<\/span><span class=\"token number\">10<\/span><span class=\"token punctuation\">,<\/span><span class=\"token number\">2<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token keyword\">comment<\/span> <span class=\"token string\">'\u4ea7\u54c1\u4ef7\u683c'<\/span><span class=\"token punctuation\">,<\/span> productDesc <span class=\"token keyword\">varchar<\/span><span class=\"token punctuation\">(<\/span><span class=\"token number\">500<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token keyword\">comment<\/span> <span class=\"token string\">'\u4ea7\u54c1\u63cf\u8ff0'<\/span><span class=\"token punctuation\">,<\/span> productStatus <span class=\"token keyword\">int<\/span><span class=\"token punctuation\">(<\/span><span class=\"token number\">1<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token keyword\">comment<\/span> <span class=\"token string\">'\u4ea7\u54c1\u72b6\u6001(0 \u5173\u95ed 1 \u5f00\u542f)'<\/span> <span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span> <span class=\"token comment\">-- \u521b\u5efa\u5b58\u50a8\u8fc7\u7a0bpro_insertMany\uff0c\u5faa\u73af\u63d2\u5165\u6570\u636e <\/span> <span class=\"token keyword\">drop<\/span> <span class=\"token keyword\">PROCEDURE<\/span> <span class=\"token keyword\">if<\/span> <span class=\"token keyword\">exists<\/span> pro_insertMany<span class=\"token punctuation\">;<\/span> <span class=\"token keyword\">DELIMITER<\/span> <span class=\"token comment\">\/\/<\/span> <span class=\"token keyword\">CREATE<\/span> <span class=\"token keyword\">PROCEDURE<\/span> pro_insertMany<span class=\"token punctuation\">(<\/span><span class=\"token operator\">IN<\/span> nums <span class=\"token keyword\">INT<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token keyword\">BEGIN<\/span> <span class=\"token keyword\">DECLARE<\/span> i <span class=\"token keyword\">INT<\/span> <span class=\"token keyword\">DEFAULT<\/span> <span class=\"token number\">1<\/span><span class=\"token punctuation\">;<\/span> <span class=\"token keyword\">WHILE<\/span> i<span class=\"token operator\">&lt;=<\/span>nums <span class=\"token keyword\">DO<\/span> <span class=\"token keyword\">insert<\/span> <span class=\"token keyword\">into<\/span> product <span class=\"token keyword\">values<\/span><span class=\"token punctuation\">(<\/span><span class=\"token boolean\">null<\/span><span class=\"token punctuation\">,<\/span>i<span class=\"token punctuation\">,<\/span><span class=\"token string\">'\u6c5f\u897f\u6b66\u529f\u5c713\u65e5\u6e38'<\/span><span class=\"token punctuation\">,<\/span><span class=\"token string\">'\u6b66\u6c49'<\/span><span class=\"token punctuation\">,<\/span><span class=\"token string\">'2020-10-24 10:00:00'<\/span><span class=\"token punctuation\">,<\/span><span class=\"token number\">1888.00<\/span><span class=\"token punctuation\">,<\/span><span class=\"token string\">'\u6765\u54af\u8868\u54e5'<\/span><span class=\"token punctuation\">,<\/span><span class=\"token number\">1<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span> <span class=\"token keyword\">SET<\/span> i<span class=\"token operator\">=<\/span>i<span class=\"token operator\">+<\/span><span class=\"token number\">1<\/span><span class=\"token punctuation\">;<\/span> <span class=\"token keyword\">END<\/span> <span class=\"token keyword\">WHILE<\/span><span class=\"token punctuation\">;<\/span> <span class=\"token keyword\">END<\/span><span class=\"token comment\">\/\/<\/span> <span class=\"token keyword\">DELIMITER<\/span> <span class=\"token punctuation\">;<\/span> <span class=\"token comment\">-- \u8c03\u7528\u5b58\u50a8\u8fc7\u7a0bpro_insertMany\uff0c\u63d2\u5165120\u6761\u968f\u673a\u6570\u636e<\/span> <span class=\"token keyword\">CALL<\/span> pro_insertMany<span class=\"token punctuation\">(<\/span><span class=\"token number\">120<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span> <span class=\"token keyword\">select<\/span> <span class=\"token operator\">*<\/span> <span class=\"token keyword\">from<\/span> product<span class=\"token punctuation\">;<\/span> <\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"\u57fa\u4e8ejava\u7684\u65c5\u6e38\u7ba1\u7406\u7cfb\u7edf_\u9879\u76ee\u7ba1\u7406\u7cfb\u7edf\u6e90\u7801JAVA\u4ea7\u54c1\u7ba1\u7406\u9875\u9762\u9875\u9762\u4ecb\u7ecd\u540e\u53f0\u4ee3\u7801\u4f9d\u8d56\u5b89\u88c5\uff08pom.xml\uff09\u9879\u76ee\u8d44\u6e90\u914d\u7f6e\uff08resource\uff09app...","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[],"_links":{"self":[{"href":"https:\/\/mushiming.com\/wp-json\/wp\/v2\/posts\/5345"}],"collection":[{"href":"https:\/\/mushiming.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mushiming.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mushiming.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/mushiming.com\/wp-json\/wp\/v2\/comments?post=5345"}],"version-history":[{"count":0,"href":"https:\/\/mushiming.com\/wp-json\/wp\/v2\/posts\/5345\/revisions"}],"wp:attachment":[{"href":"https:\/\/mushiming.com\/wp-json\/wp\/v2\/media?parent=5345"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mushiming.com\/wp-json\/wp\/v2\/categories?post=5345"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mushiming.com\/wp-json\/wp\/v2\/tags?post=5345"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}