本文演示Jboot整合MySQL。
一、项目搭建
新建一个Maven项目,引入依赖:
<properties>
<jBoot.version>3.10.0</jBoot.version>
<lombok.version>1.16.10</lombok.version>
</properties>
<dependencies>
<dependency>
<groupId>io.jboot</groupId>
<artifactId>jboot</artifactId>
<version>${jBoot.version}</version>
</dependency>
<dependency>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
<version>${lombok.version}</version>
</dependency>
</dependencies>
二、添加属性配置文件jboot.properties:
jboot.datasource.type = mysql
jboot.datasource.url = jdbc:mysql://127.0.0.1:3306/mytest
jboot.datasource.user = root
jboot.datasource.password = root
三、库表、实体类、测试类
①建好测试库mytesst及测试表student
②编写实体类
@Data
public class Student {
private int id;
private String name;
private int age;
}
@RequestMapping("/")
public class IndexController extends JbootController {
public void index() {
renderText("Jboot:Hello World ");
}
public void list(){
List<Record> records = Db.find("select * from student");
renderText(Arrays.toString(records.toArray()));
System.out.println("-------------->>>>>>"+records);
}
public static void main(String[] args) {
JbootApplication.run(args);
}
}
四、启动及效果:
启动main函数并访问http://localhost:8080/list
测试验证OK。