Idear调用数据库
在hs软件中新建一个restaurant表
在库中创建一个表
在表中添加信息
在idea中连接mysql
首先在mpom文档中输入
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.16</version>
</dependency>
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>2.1.3</version>
</dependency>
创建一个接口 输入mysql语句
import com.sdcet.entity.User;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
@Mapper
public interface UserMapper {
@Select("SELECT `name`FROM user WHERE id = #{id}")
public String selectNameByid(long id);
创建一个类,写mysql里表的私有方法,
public class User {
private long id;
private String name;
private String password;
private String sex;
private String phoneNum;
private Date createTime;
private Date updateTime;
get,set语句
public long getId() {
return id;
}
public void setId(long id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
public String getSex() {
return sex;
}
public void setSex(String sex) {
this.sex = sex;
}
public String getPhoneNum() {
return phoneNum;
}
public void setPhoneNum(String phoneNum) {
this.phoneNum = phoneNum;
}
public Date getCreateTime() {
return createTime;
}
public void setCreateTime(Date createTime) {
this.createTime = createTime;
}
public Date getUpdateTime() {
return updateTime;
}
public void setUpdateTime(Date updateTime) {
this.updateTime = updateTime;
}
在UserController 中添加
import com.sdcet.entity.User;
import com.sdcet.mapper.UserMapper;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody;
@Controller
@ResponseBody
public class UserContreller {
@Autowired
private UserMapper userMapper;
@RequestMapping("/getName")
public String getName(Long id){
return userMapper.selectNameByid(id);
}
@RequestMapping("/user")
public User user(Long id){
return userMapper.selectUserById(id);
}
在rescourcs下新建一个file的yml文件
spring:
datasource:
url: jdbc:mysql://127.0.0.1:3306/restaurant?serverTimezone=Asia/Shanghai
username: root
password: 123456
driver-class-name: com.mysql.cj.jdbc.Driver
mybatis:
configuration:
map-underscore-to-camel-case: true
.运行Maven,
输入http://127.0.0.1:8080/getName?id=1这样就可以查询数据库