詳解Springboot-MyBatis配置-配置端口號(hào)與服務(wù)路徑(idea社區(qū)版2023.1.4+apache-maven-3.9.3-bin)
承接上文:Springboot快速搭建跨域API接口(idea社區(qū)版2023.1.4+apache-maven-3.9.3-bin)
MyBatis的Maven包
<dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter</artifactId> </dependency> <!-- 熱部署 --> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-devtools</artifactId> </dependency> <!-- Web支持 --> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-web</artifactId> </dependency> <!-- JDBC --> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-jdbc</artifactId> </dependency> <!-- MySQL驅(qū)動(dòng) --> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> </dependency> <!-- 集成MyBatis --> <dependency> <groupId>org.mybatis.spring.boot</groupId> <artifactId>mybatis-spring-boot-starter</artifactId> <version>2.1.2</version> </dependency> <!-- junit --> <dependency> <groupId>junit</groupId> <artifactId>junit</artifactId> <scope>test</scope> </dependency> <!-- 測(cè)試 --> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-test</artifactId> <scope>test</scope> <exclusions> <exclusion> <groupId>org.junit.vintage</groupId> <artifactId>junit-vintage-engine</artifactId> </exclusion> </exclusions> </dependency>
引入后別忘記刷新Maven。
application.properties配置文件位置
添加以下內(nèi)容:
# 配置數(shù)據(jù)庫(kù)驅(qū)動(dòng) spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver # 配置數(shù)據(jù)庫(kù)url spring.datasource.url=jdbc:mysql://rm-bp1zq3879r28p726lco.mysql.rds.aliyuncs.com:3306/test?characterEncoding=utf8 # 配置數(shù)據(jù)庫(kù)用戶名 spring.datasource.username=qwe8403000 # 配置數(shù)據(jù)庫(kù)密碼 spring.datasource.password=Qwe8403000 # 指定MyBatis配置文件位置 mybatis.mapper-locations=classpath:mapper/*.xml # 指定模型位置 mybatis.typeAliasesPackage=com.item.model # 修改端口號(hào)避免沖突 server.port=8088 # 服務(wù)路徑 server.servlet.context-path=/MyAPI
項(xiàng)目結(jié)構(gòu)層次
編碼過(guò)程
按照上圖給的順序一次創(chuàng)建文件并寫入給與的示例代碼,數(shù)據(jù)庫(kù)里面有表,可以直接放心使用。
1、model/Users.java
package com.item.model; public class Users { public int getId() { return id; } public void setId(int id) { this.id = id; } public String getUserName() { return userName; } public void setUserName(String userName) { this.userName = userName; } public String getPwd() { return pwd; } public void setPwd(String pwd) { this.pwd = pwd; } public String getNickName() { return nickName; } public void setNickName(String nickName) { this.nickName = nickName; } @Override public String toString() { return "Users{" + "id=" + id + ", userName='" + userName + '\'' + ", pwd='" + pwd + '\'' + ", nickName='" + nickName + '\'' + '}'; } private int id; private String userName; private String pwd; private String nickName; }
2、dao/UsersMapper.java
package com.item.dao; import com.item.model.Users; import org.apache.ibatis.annotations.Param; import org.springframework.stereotype.Repository; import java.util.List; /** * 數(shù)據(jù)訪問(wèn)組件 */ @Repository public interface UsersMapper { List<Users> GetInfo(); List<Users> SelectName(@Param("nickName") String nickName); Users UsersSelectById(@Param("id") int id); int UsersAddInfo( @Param("userName") String userName, @Param("pwd") String pwd, @Param("nickName") String nickName ); int UsersUpdateInfo( @Param("pwd") String pwd, @Param("id") int id ); int UsersDeleteById(@Param("id") int id); }
3、resources/mapper/UsersMapper.xml
<?xml version="1.0" encoding="UTF-8" ?> <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> <mapper namespace="com.item.dao.UsersMapper"> <!-- 用作基礎(chǔ)查詢測(cè)試 --> <select id="GetInfo" resultType="Users"> select * from users </select> <!-- 用做傳遞參數(shù)測(cè)試·支持空查詢,返回所有信息 --> <select id="SelectName" resultType="Users"> select * from users where nickName like "%${nickName}%" </select> <!-- id精準(zhǔn)查詢 --> <select id="UsersSelectById" resultType="Users"> select * from users where id=#{id} </select> <!-- 增加 --> <insert id="UsersAddInfo"> insert into users values(0,"${userName}","${pwd}","${nickName}"); </insert> <!-- 修改 --> <update id="UsersUpdateInfo"> update users set pwd="${pwd}" where id=#{id} </update> <!-- 刪除 --> <delete id="UsersDeleteById"> delete from users where id=#{id} </delete> </mapper>
4、service/UsersService.java
package com.item.service; import com.item.model.Users; import java.util.List; public interface UsersService { /** * 獲取所有 * @return */ List<Users> GetInfo(); /** * 獲取nickName的模糊查詢結(jié)果集 * @param nickName * @return */ List<Users> SelectName(String nickName); /** * id精準(zhǔn)查詢 * @param id * @return */ Users UsersSelectById(int id); /** * 添加信息 * @param userName * @param pwd * @param nickName * @return */ int UsersAddInfo( String userName, String pwd, String nickName ); /** * 修改密碼 * @param pwd * @param id * @return */ int UsersUpdateInfo( String pwd, int id ); /** * 刪除信息 * @param id * @return */ int UsersDeleteById(int id); }
5、serviceimpl/UsersServiceImpl.java
package com.item.serviceimpl; import com.item.dao.UsersMapper; import com.item.model.Users; import com.item.service.UsersService; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import org.springframework.util.DigestUtils; import java.io.UnsupportedEncodingException; import java.security.MessageDigest; import java.security.NoSuchAlgorithmException; import java.util.List; @Service public class UsersServiceImpl implements UsersService { @Autowired private UsersMapper usersMapper; @Override public List<Users> GetInfo() { return usersMapper.GetInfo(); } @Override public List<Users> SelectName(String nickName) { return usersMapper.SelectName(nickName); } @Override public Users UsersSelectById(int id) { return usersMapper.UsersSelectById(id); } @Override public int UsersAddInfo(String userName, String pwd, String nickName) { pwd=encrypt(pwd); return usersMapper.UsersAddInfo(userName, pwd, nickName); } @Override public int UsersUpdateInfo(String pwd, int id) { pwd=encrypt(pwd); return usersMapper.UsersUpdateInfo(pwd, id); } /** * MD5加密 * @param password * @return */ private String encrypt(String password) { String passwordMd5 = null; try { MessageDigest md5 = MessageDigest.getInstance("MD5"); byte[] bytes = md5.digest(password.getBytes("utf-8")); passwordMd5 = toHex(bytes); } catch (NoSuchAlgorithmException | UnsupportedEncodingException e) { e.printStackTrace(); } return passwordMd5; } private static String toHex(byte[] bytes) { final char[] HEX_DIGITS = "0123456789ABCDEF".toCharArray(); StringBuilder ret = new StringBuilder(bytes.length * 2); for (int i = 0; i < bytes.length; i++) { ret.append(HEX_DIGITS[(bytes[i] >> 4) & 0x0f]); ret.append(HEX_DIGITS[bytes[i] & 0x0f]); } return ret.toString(); } @Override public int UsersDeleteById(int id) { return usersMapper.UsersDeleteById(id); } }
6、controller/UsersController.java
package com.item.controller; import com.item.model.Users; import com.item.service.UsersService; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.ui.Model; import org.springframework.web.bind.annotation.*; import javax.servlet.http.HttpServletRequest; import java.util.HashMap; import java.util.List; @RestController @CrossOrigin public class UsersController { @Autowired private UsersService usersService; @GetMapping("/GetInfoApi") public Object GetInfoApi(){ List<Users> list=usersService.GetInfo(); HashMap<String,Object> map=new HashMap<String,Object>(); map.put("state",true); map.put("msg","成功"); map.put("result",list); return map; } @GetMapping("/GetName") public Object GetName(HttpServletRequest request,Model model){ String nickName = request.getParameter("nickName"); List<Users> list=usersService.SelectName(nickName); HashMap<String,Object> map=new HashMap<String,Object>(); map.put("state",true); map.put("msg","成功"); map.put("result",list); return map; } /** * 添加接口,訪問(wèn)方式post * @param request * @param model * @return */ @PostMapping(value = "/UserAddInfoApi") public Object UserAddInfoApi(HttpServletRequest request,Model model){ String userName = request.getParameter("userName"); String pwd = request.getParameter("pwd"); String nickName = request.getParameter("nickName"); usersService.UsersAddInfo(userName, pwd, nickName); HashMap<String,Object> map=new HashMap<String,Object>(); map.put("state",true); map.put("msg","成功"); map.put("result",""); return map; } /** * 單個(gè)查詢 * @param request * @param model * @return */ @GetMapping("/UsersSelectById") public Object UsersSelectById(HttpServletRequest request,Model model){ String id = request.getParameter("id"); Users users = usersService.UsersSelectById(Integer.parseInt(id)); HashMap<String,Object> map=new HashMap<String,Object>(); map.put("state",true); map.put("msg","成功"); map.put("result",users); return map; } /** * 修改api * @param request * @param model * @return */ @PostMapping(value = "/UserUpdateInfoApi") public Object UserUpdateInfoApi(HttpServletRequest request,Model model){ String id = request.getParameter("id"); String pwd = request.getParameter("pwd"); usersService.UsersUpdateInfo(pwd,Integer.parseInt(id)); HashMap<String,Object> map=new HashMap<String,Object>(); map.put("state",true); map.put("msg","成功"); map.put("result",""); return map; } /** * 刪除api * @param request * @param model * @return */ @GetMapping(value = "/UsersDeleteById") public Object UsersDeleteById(HttpServletRequest request,Model model){ String id = request.getParameter("id"); usersService.UsersDeleteById(Integer.parseInt(id)); HashMap<String,Object> map=new HashMap<String,Object>(); map.put("state",true); map.put("msg","成功"); map.put("result",""); return map; } }
7、Action.java
package com.item; import org.mybatis.spring.annotation.MapperScan; import org.springframework.boot.SpringApplication; import org.springframework.boot.autoconfigure.SpringBootApplication; import org.springframework.boot.builder.SpringApplicationBuilder; import org.springframework.boot.web.servlet.support.SpringBootServletInitializer; @MapperScan("com.item.dao") @SpringBootApplication public class Action extends SpringBootServletInitializer { @Override protected SpringApplicationBuilder configure(SpringApplicationBuilder application) { return application.sources(Action.class); } public static void main(String[] args) { //一定是被@SpringBootApplication標(biāo)記的類 SpringApplication.run(Action.class, args); } }
啟動(dòng)校驗(yàn)
查看端口號(hào)以及路由設(shè)置
端口號(hào)以及路由的路徑已經(jīng)設(shè)置,根據(jù)路徑進(jìn)行訪問(wèn)。
http://localhost:8088/MyAPI/GetName
訪問(wèn)成功。
總結(jié)
現(xiàn)在我們已經(jīng)搭建了服務(wù)的基礎(chǔ)環(huán)境,可以創(chuàng)建跨域的接口,也可以操作數(shù)據(jù)庫(kù),那么也就代表著我們可以正常的寫接口項(xiàng)目了,不過(guò)我們寫好的接口暫時(shí)沒(méi)辦法直接提供給前端人員,所以我們還需要配置一個(gè)swagger或者是使用Eolink插件一鍵上傳接口來(lái)方便與前端人員交互。
源碼下載地址:https://dxz.jb51.net/202307/yuanma/Springboot_MyBatis_jb51.rar
下節(jié)我們來(lái)配置swagger。
到此這篇關(guān)于Springboot-MyBatis配置-配置端口號(hào)與服務(wù)路徑(idea社區(qū)版2023.1.4+apache-maven-3.9.3-bin)的文章就介紹到這了,更多相關(guān)Springboot MyBatis配置內(nèi)容請(qǐng)搜索腳本之家以前的文章或繼續(xù)瀏覽下面的相關(guān)文章希望大家以后多多支持腳本之家!
相關(guān)文章
sentinel整合ribbon與fallback流程分步講解
這篇文章主要介紹了sentinel整合ribbon與fallback分步流程,文中通過(guò)示例代碼介紹的非常詳細(xì),對(duì)大家的學(xué)習(xí)或者工作具有一定的參考學(xué)習(xí)價(jià)值,需要的朋友們下面隨著小編來(lái)一起學(xué)習(xí)學(xué)習(xí)吧2022-08-08Java Robot應(yīng)用示例之機(jī)器人功能
這篇文章主要為大家詳細(xì)介紹了Java Robot應(yīng)用示例之機(jī)器人功能,具有一定的參考價(jià)值,感興趣的小伙伴們可以參考一下2018-01-01java面向?qū)ο笤O(shè)計(jì)原則之開閉原則示例解析
這篇文章主要介紹了java面向?qū)ο笤O(shè)計(jì)原則之開閉原則的示例解析,有需要的朋友可以借鑒參考下,希望能夠有所幫助,祝大家多多進(jìn)步,早日升職加薪2021-10-10關(guān)于Spring MVC同名參數(shù)綁定問(wèn)題的解決方法
Spring MVC中的參數(shù)綁定還是蠻重要的,最近在使用中遇到了同名參數(shù)綁定的問(wèn)題,想著總結(jié)分享出來(lái),下面這篇文章主要給大家介紹了關(guān)于Spring MVC同名參數(shù)綁定問(wèn)題的解決方法,需要的朋友可以參考借鑒,下面來(lái)一起看看吧。2017-08-08Java動(dòng)態(tài)顯示文件上傳進(jìn)度實(shí)現(xiàn)代碼
這篇文章主要為大家詳細(xì)介紹了Java動(dòng)態(tài)顯示文件上傳進(jìn)度實(shí)現(xiàn)代碼,文中示例代碼介紹的非常詳細(xì),具有一定的參考價(jià)值,感興趣的小伙伴們可以參考一下2017-01-01