使用JdbcTemplate+spring注解简单实现数据库的查询

使用JdbcTemplate+spring注解简单实现数据库的查询

2-创建一个spring模块

2.1 创建lib文件夹 导入需要的jar包

2.2 创建对应的目录文件

2.2.1pojo

student.java

package com.zelin.pojo;

import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;

/**
 * @author wf
 * @date 2020-10-16 17:30
 */
@Data
@AllArgsConstructor
@NoArgsConstructor
public class Student {
   
    private int sid;
    private String sname;
    private String sex;
    private int age;
    private String addr;
    private int cid;
    private String cname;
}

classes.java

package com.zelin.pojo;

import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;

/**
 * @author wf
 * @date 2020-10-16 20:40
 */
@Data
@AllArgsConstructor
@NoArgsConstructor
public class Classes {
   
    private int cid;
    private String cname;
}

2.2.2test目录

TestJdbcTemplate.java

package com.zelin.test;

import com.zelin.pojo.Student;
import com.zelin.service.StudentService;
import org.junit.Test;
import org.junit.runner.RunWith;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.test.context.ContextConfiguration;
import org.springframework.test.context