spring boot 中 mybatis 直接写 sql 增删改查一套

思路:

1.配置每一层内容

2.在yml中配置mysql信息

3.在mapper中配置内容sql 返回内容设置成 java.util.HashMap，输入内容设置成string

4.在配置dao接口

5.可直接执行查询和修改都ok

 

java控制层类

/**
*控制成类
*/
@RestController
public class DeptController {    
    
    @Autowired
	private UserServiceImpl userserver;
	
	@RequestMapping(value="/getStrnew/{str}")
	public String getStrnew(@PathVariable("str") String str){
		String sql = "select * from dept";//查询sql
		String sql2 = "insert into dept value('9','5','2')";//写入sql
		userserver.selectBysql(sql2);//执行写入sql
		List<Map<String,Object>> list = userserver.selectBysql(sql);//执行查询sql
		for (int i = 0; i < list.size(); i++) {
			String c = "";
			for (Entry<String, Object> entry : list.get(i).entrySet()) {
				c += entry.getKey()+"======"+String.valueOf(entry.getValue());
			}
			System.out.println(c);
		}
		return "8001ready" + str;
	}
}

service

public interface UserService {

    public List<Map<String,Object>> selectBysql(String sql);
	
}

@Service
public class UserServiceImpl implements UserService {

    @Autowired
	private UserDao dao;

    public List<Map<String,Object>> selectBysql(String sql){
		return dao.selectBysql(sql);
		
	}

}

dao

@Mapper
public interface UserDao {

    	public List<Map<String,Object>> selectBysql(String sql);

}

mapper.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.supermap.provider.dao.UserDao">
	
	<select id="selectBysql" parameterType="java.lang.String"   resultType="java.util.HashMap">
	    ${value}
	</select>
	

</mapper>

 

.yml

mybatis: 
  config-location: classpath:mybatis/mybatis.cfg.xml 
  type-aliases-package: com.supermap.vo 
  mapper-locations: classpath:mybatis/mapper/**/*.xml 

spring: 
  application: 
    name: supermap-dept
  datasource: 
    type: com.alibaba.druid.pool.DruidDataSource
    driver-class-name: org.gjt.mm.mysql.Driver
    url: jdbc:mysql://localhost:3306/zkdb
    username: zkjdkd
    password: zkdkjdk
    dbcp2:
      min-idle: 5
      initial-size: 5
      max-total: 5
      max-wait-millis: 200