哈哈哈哈哈哈哈👌话嘿嘿👌h
springBoot开发
<resultMap id="Areas" type="com.imooc.demo.entyti.Area"> <id column="area_id" jdbcType="INTEGER" property="areaId" /> <result column="area_name" jdbcType="VARCHAR" property="areaName" /> <result column="priority" jdbcType="INTEGER" property="priority" /> <result column="create_time" jdbcType="DATE" property="createTime" /> <result column="last_edit_time" jdbcType="DATE" property="lastEditTime" /> </resultMap> <select id="queryArea" resultMap="Areas"> SELECT area_id, area_name, priority, create_time, last_edit_time FROM td_area ORDER BY priority DESC </select>
绑定代码,忽略下划线改成大写
server层为了复查dao层中的操作,与事务有关
将增删改查整合到一起
gitignore配置需要git管理的文件
test失败????????
java.lang.IllegalStateException: Failed to load ApplicationContext
我的
1111
配置类
dataSource.return = return dataSource;
springboot项目,除了mybatis的配置,其他配置一般都不用xml。mybatis的配置也可用java类,但是xml的方式是主流。
@controllerAdvice统一异常处理
Junit单元测试
springboot集成mybatise,mapper.xml的编写
MenuDao层:
package com.example.demo.dao; import com.example.demo.bean.MainMenu; import org.springframework.stereotype.Repository; import java.util.List; @Repository public interface MenuDao { public List<MainMenu> getMenus(); }
MenuController层:
package com.example.demo.logincontroller; import com.alibaba.fastjson.JSON; import com.example.demo.bean.MainMenu; import com.example.demo.dao.MenuDao; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RestController; import java.util.HashMap; import java.util.List; @RestController public class MenuController { @Autowired MenuDao menuDao; @RequestMapping(value="/menus") public String getAllMenus(){ System.out.println("访问成功!!!"); HashMap<String, Object> data = new HashMap<>(); List<MainMenu> menus = menuDao.getMenus(); if (menus != null){ data.put("menus", menus); data.put("flag", 200); }else{ data.put("flag", 404); } String s = JSON.toJSONString(data); return s; } }
MenuMainMapper。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.example.demo.dao.MenuDao"> <!-- 关系映射--> <resultMap id="menuMap" type="com.example.demo.bean.MainMenu"> <id column="id" property="id"></id> <result column="title" property="title"></result> <result column="path" property="path"></result> <collection property="sList" ofType="com.example.demo.bean.SubMenu"> <id column="sid" property="id"></id> <result column="stitle" property="title"></result> <result column="spath" property="path"></result> </collection> </resultMap> <select id="getMenus" resultMap="menuMap"> select mm.*,sm.id as sid ,sm.title as stitle ,sm.path as spath from vue_mainmenu mm ,vue_submenu sm where mm.id = mid; </select> </mapper>
Controller层:
package com.example.demo.logincontroller; import com.alibaba.fastjson.JSON; import com.example.demo.bean.UserName; import com.example.demo.dao.UserNameDao; //import jdk.nashorn.internal.parser.JSONParser; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.web.bind.annotation.RequestBody; import org.springframework.web.bind.annotation.RequestMapping; //import org.springframework.web.bind.annotation.ResponseBody; import org.springframework.web.bind.annotation.RestController; import java.util.HashMap; @RestController public class LoginController { @Autowired UserNameDao userNameDao; @RequestMapping(value="/Login") public String login(@RequestBody UserName username){ String flag = "error"; UserName userName = userNameDao.getUserNameByMassage(username.getUsername(), username.getPassword()); HashMap<String, Object> res = new HashMap<>(); if(userName != null){ flag = "hello world!!!"; } res.put("flag", flag); res.put("username", username); String res_json = JSON.toJSONString(res); // System.out.println(userName); return res_json; } }
UserNameDao层:
package com.example.demo.dao; import com.example.demo.bean.UserName; import org.apache.ibatis.annotations.Param; import org.springframework.stereotype.Repository; @Repository public interface UserNameDao { public UserName getUserNameByMassage(@Param("username") String username, @Param("password") String password); }
解决跨域:
package com.example.demo.config; import org.springframework.context.annotation.Configuration; import org.springframework.web.servlet.config.annotation.CorsRegistry; import org.springframework.web.servlet.config.annotation.WebMvcConfigurerAdapter; /** * 解决跨域问题 */ @Configuration public class Config extends WebMvcConfigurerAdapter { @Override public void addCorsMappings(CorsRegistry registry) { registry.addMapping("/**") .allowedOrigins("*") .allowedMethods("*") .allowCredentials(true) .maxAge(3600); } }
实体层bean:
package com.example.demo.bean; public class UserName { private int id; private String username; private String password; public UserName(){ } public UserName(String username, String password){ this.username = username; this.password = password; } 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 getPassword() { return password; } public void setPassword(String password) { this.password = password; } @Override public String toString() { return "UserName{" + "id=" + id + ", username='" + username + '\'' + ", password='" + password + '\'' + '}'; } }
草他个妈耶,真鸡儿难
formSubmit:function(e){
var that = this;
var formData = e.detail.value;
var url = that.data.addUrl;
if(that.data.areaId != undefined){
formData.areaId = that.data.areaId;
url = that.data.modifyUrl;
}
wx.request({
url: url,
data: JSON.stringify(formData),
method:"GET",
header: {'Content-Type':'application/json'},
success: function(res){
var result = res.data.success;
var toastText = "操作成功!";
if(result != true){
toastText = "操作失败"+res.data.errMsg;
}
wx.showToast({
title: toastText,
})
}
})
}
operation.wxml
onShow
目录结构……
创建小程序项目
小程序介绍
jsonView 插件
IDEA:自动导包
实战项目页面