软件开发培训班 >> 编程开发 >> MySQL


SpringBoot连接MySQL获取数据写后端接口的操作方法

1.鏂板缓椤圭洰

鍦ㄨ繖閲屾彃鍏ュ浘鐗囨弿杩? src=
鍦ㄨ繖閲屾彃鍏ュ浘鐗囨弿杩? src=
鍦ㄨ繖閲屾彃鍏ュ浘鐗囨弿杩? src=

2.娣诲姞渚濊禆

鍦ㄨ繖閲屾彃鍏ュ浘鐗囨弿杩? src=

<dependency>
      <groupId>mysql</groupId>
      <artifactId>mysql-connector-java</artifactId>
      <version>8.0.20</version>
    </dependency>
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-jdbc</artifactId>
      <version>5.3.8</version>
    </dependency>
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-tx</artifactId>
      <version>5.3.8</version>
    </dependency>

    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-aop</artifactId>
      <version>5.3.8</version>
    </dependency>

3.spring瀹瑰櫒涓垱寤篋riverManagerDataSource鍜孞dbcTemplate瀵硅薄

 3.1鍦╯pringboot涓姞杞絪pring瀹瑰櫒鐨勬柟娉?/h3>

1銆佸湪resource涓嬪垱寤簊pring瀹瑰櫒鏂囦欢

resource ---->new---->Directory---->new Directory(application)
鍦ㄨ繖閲屾彃鍏ュ浘鐗囨弿杩? src=
鍦ㄨ繖閲屾彃鍏ュ浘鐗囨弿杩? src=

    <bean class="org.springframework.jdbc.datasource.DriverManagerDataSource" id="dataSource">
        <!-- 1.1.鏁版嵁搴撻┍鍔?-->
        <property name="driverClassName" value="com.mysql.cj.jdbc.Driver"/>
        <!-- 1.2.杩炴帴鏁版嵁搴撶殑url -->
        <property name="url" value="jdbc:mysql://localhost:3306/spring?characterEncoding=utf8&amp;serverTimezone=UTC"/>
        <!-- 1.3.杩炴帴鏁版嵁搴撶殑鐢ㄦ埛鍚?-->
        <property name="username" value="root"></property>
        <!-- 1.4.杩炴帴鏁版嵁搴撶殑瀵嗙爜 -->
        <property name="password" value="root"></property>

    </bean>

    <bean class="org.springframework.jdbc.core.JdbcTemplate" id="jdbcTemplate">
        <property name="dataSource" ref="dataSource"/>
    </bean>

2.瀹氫箟涓�涓櫘閫氱被 鍦ㄨ绫讳笂鍔犱笂涓婅堪娉ㄨВ鍗冲彲鍦╯pringboot鍚姩鍚庤嚜鍔ㄥ姞杞絪pring瀹瑰櫒

鍦ㄨ繖閲屾彃鍏ュ浘鐗囨弿杩? src=

4.鍒涘缓瀵硅薄绫伙紝鎺у埗绫?Book

娉ㄦ剰姝ゅ鐨凘Data娉ㄨВ锛屽畠鏄痩ombok鐨勪竴浠藉瓙锛屼富瑕佷綔鐢ㄦ槸鍦ㄧ紪璇戞椂鑷姩鐢熸垚get锛宻et鏂规硶锛屾墍浠ユ绫讳腑涓嶉渶瑕佹垜浠墜鍔ㄥ啓get set鏂规硶锛屽噺灏戞垜浠殑宸ヤ綔閲忥紝闈炲父鏂逛究锛屽己鐑堟帹鑽?/p>

鍦ㄨ繖閲屾彃鍏ュ浘鐗囨弿杩? src=

BookDao

鍦ㄨ繖閲屾彃鍏ュ浘鐗囨弿杩? src=

TestController

鍦ㄨ繖閲屾彃鍏ュ浘鐗囨弿杩? src=

application.properties

鍦ㄨ繖閲屾彃鍏ュ浘鐗囨弿杩? src=

5.鍚姩MySQL鏁版嵁搴?/h2>

鍙互鍙傝�冧箣鍓嶆枃绔?br /> 瀹夎MySQL8.0骞跺湪Navicat鍙鍖栨搷浣?/a>

鍦ㄨ繖閲屾彃鍏ュ浘鐗囨弿杩? src=

6.杩愯娴嬭瘯

濡備笅鍥撅紝杩愯鎴愬姛

鍦ㄨ繖閲屾彃鍏ュ浘鐗囨弿杩? src=

鍦ㄦ祻瑙堝櫒涓緭鍏ユ煡鐪嬫槸鍚﹁幏鍙栨垚鍔?/p>

鍦ㄨ繖閲屾彃鍏ュ浘鐗囨弿杩? src=

璇存槑锛?br /> 8080鍜宻pringboot鍙傝�僡pplication.properties
getbookList鏄疶estController涓璕equestMapping涓嚜瀹氫箟鐨?/p>

鑷虫锛孲pringBoot鍚庣鎺ュ彛灏卞啓濂戒簡

鍒版杩欑瘒鍏充簬SpringBoot杩炴帴MySQL鑾峰彇鏁版嵁鍐欏悗绔帴鍙ｇ殑鏂囩珷灏变粙缁嶅埌杩欎簡,鏇村鐩稿叧SpringBoot杩炴帴MySQL鍐呭璇锋悳绱㈣剼鏈箣瀹朵互鍓嶇殑鏂囩珷鎴栫户缁祻瑙堜笅闈㈢殑鐩稿叧鏂囩珷甯屾湜澶у浠ュ悗澶氬鏀寔鑴氭湰涔嬪锛?/p>