1.整合依赖
<!--sqlite -->
<dependency>
<groupId>org.xerial</groupId>
<artifactId>sqlite-jdbc</artifactId>
<version>3.36.0.3</version>
</dependency>
2.配置application.yml
spring:
datasource:
url: jdbc:sqlite:E:\SQLite\wcs-yd.db
driver-class-name: org.sqlite.JDBC
3.使用mybatis/mybatis-plus来对sqlite进行操作
实体类:
@Data
@TableName("wcs_plc_config")
public class WcsPlcConfig {
@TableId
private int id;
private String ip;
private int port;
private String plcName;
private int type;
private String remark;
private int onLine;
private int isUse;
}
持久层Mapper:
@Mapper
public interface WcsPlcConfigMapper extends BaseMapper<WcsPlcConfig> {
}
服务层Service:
public interface WcsPlcConfigService extends IService<WcsPlcConfig> {
}
@Service
public class WcsPlcConfigServiceImpl extends ServiceImpl<WcsPlcConfigMapper, WcsPlcConfig> implements WcsPlcConfigService {
}
视图层Controller:
@Controller
public class WcsPlcConfigController {
@Resource
private WcsPlcConfigService wcsPlcConfigService;
@PostMapping("/add")
@ResponseBody
public Object add(@RequestBody WcsPlcConfig wcsPlcConfig) {
wcsPlcConfigService.save(wcsPlcConfig);
return "添加成功!";
}
@DeleteMapping("/delete/{id}")
@ResponseBody
public Object delete(@PathVariable int id) {
wcsPlcConfigService.removeById(id);
return "删除成功!";
}
@PutMapping("/update")
@ResponseBody
public Object update(@RequestBody WcsPlcConfig wcsPlcConfig) {
wcsPlcConfigService.updateById(wcsPlcConfig);
return "修改成功!";
}
@GetMapping("/queryList")
@ResponseBody
public Object queryList() {
List<WcsPlcConfig> list = wcsPlcConfigService.list();
return list;
}
}