创建项目<Spring-boot>
Spring-Initializr
image.png
image.png
image.png
设置maven
image.png
设置包
image.png
需要加入的注解(sql操作层)
@Component
@Select("SELECT id, username, password FROM wxapp WHERE USERNAME = #{username} ")
全部代码
package com.xinhao.conterller.testapp.mapper
import com.xinhao.conterller.testapp.bean.UserDataBean
import org.apache.ibatis.annotations.Param
import org.apache.ibatis.annotations.Select
import org.springframework.stereotype.Component
@Component
interface LoginMapper {
/**
*
* 登陆
*
*/
@Select("SELECT id, username, password FROM wxapp WHERE USERNAME = #{username} ")
fun login(@Param("usernam") username: String): UserDataBean
数据bean[需要加入的注解]
@Data
全部代码
package com.xinhao.conterller.testapp.bean
import lombok.Data
@Data
data class UserDataBean(val id: Int, val username: String, val password: String)
Dao层需要加入的注解
@Component
@Autowired
全部代码
package com.xinhao.conterller.testapp.dao.impl
import com.xinhao.conterller.testapp.bean.UserDataBean
import com.xinhao.conterller.testapp.dao.inter.ILoginDao
import com.xinhao.conterller.testapp.mapper.LoginMapper
import org.springframework.beans.factory.annotation.Autowired
import org.springframework.stereotype.Component
@Component
class LoginDao : ILoginDao {
@Autowired
lateinit var mLoginMapper: LoginMapper
override fun loginUser(username: String): UserDataBean {
return mLoginMapper.login(username)
}
}
service层全部注解
@Service
@Autowired
全部代码
package com.xinhao.conterller.testapp.service.impl
import com.xinhao.conterller.testapp.bean.UserDataBean
import com.xinhao.conterller.testapp.dao.inter.ILoginDao
import com.xinhao.conterller.testapp.service.inter.ILoginService
import org.springframework.beans.factory.annotation.Autowired
import org.springframework.stereotype.Service
@Service
class LoginServiceImpl : ILoginService {
@Autowired
lateinit var mILoginDao: ILoginDao
override fun loginUser(username: String, password: String): UserDataBean {
return mILoginDao.loginUser(username)
}
}
连接层全部注解
@RestController
@RequestMapping("xinhao")
@GetMapping("login")
@Autowired
@PostMapping("login")
全部代码
package com.xinhao.conterller.testapp.conterller
import com.xinhao.conterller.testapp.service.inter.ILoginService
import org.springframework.beans.factory.annotation.Autowired
import org.springframework.web.bind.annotation.GetMapping
import org.springframework.web.bind.annotation.RequestMapping
import org.springframework.web.bind.annotation.RequestParam
import org.springframework.web.bind.annotation.RestController
@RestController
@RequestMapping("xinhao")
class LoginConterller {
@Autowired
lateinit var mIoginService: ILoginService
@GetMapping("login")
fun login(@RequestParam("username") username: String, @RequestParam("password") password: String): String? {
return mIoginService.loginUser(username, password).password
}
}
默认自带配置
@SpringBootApplication(scanBasePackages = {"你的包名.**"})
@MapperScan(basePackages = {"你的mapper包【全称路径包名】.**"})
//示例
@SpringBootApplication(scanBasePackages = {"com.xinhao.**"})
@MapperScan(basePackages = {"com.xinhao.conterller.testapp.mapper.**"})
配置sql链接信息[application.yml]
server:
port: 8080
spring:
datasource:
username: root
password: 123
driver-class-name: com.mysql.cj.jdbc.Driver
url: jdbc:mysql://192.168.1.197:3306/xinhaotest?useUnicode=true&characterEncoding=utf-8&useSSL=true&serverTimezone=UTC
图片
image.png
完成!
-----------------------------------------------------------创建最基本的【无需sql语句】
在Application.yml中再加入
mybatis:
configuration:
map-underscore-to-camel-case: true
mapper:
mappers:
- tk.mybatis.mapper.common.Mapper
- tk.mybatis.mapper.common.BaseMapper
- tk.mybatis.mapper.common.IdsMapper
- tk.mybatis.mapper.common.ConditionMapper
- tk.mybatis.mapper.common.ExampleMapper
notEmpty: true
创建一个核心Mapper具体这样写
import tk.mybatis.mapper.common.BaseMapper
import tk.mybatis.mapper.common.ConditionMapper
import tk.mybatis.mapper.common.IdsMapper
import tk.mybatis.mapper.common.special.InsertListMapper
/**
*
* 核心Mapper
*
*/
@Mapper
interface CoreMapper<T> : BaseMapper<T>, ConditionMapper<T>, IdsMapper<T>, InsertListMapper<T>
创建一个集成于核心类的子类，并写上你javaBean的泛型
package com.xinhao.testweb.web.mapper.login
import com.xinhao.testweb.web.bean.XinhaoBean
import com.xinhao.testweb.web.mapper.CoreMapper
@Mapper
interface LoginMapper : CoreMapper<XinhaoBean>
然后在service层
package com.xinhao.testweb.web.service.impl
import com.xinhao.testweb.web.mapper.login.LoginMapper
import com.xinhao.testweb.web.service.inter.ILoginService
import org.springframework.beans.factory.annotation.Autowired
import org.springframework.stereotype.Service
@Service
class LoginServiceImpl : ILoginService {
@Autowired
lateinit var mLoginMapper:LoginMapper
override fun loginUser(username: String, password: String): String {
return null!!
}
}
