package cn.edu.qvtu.test;
import cn.edu.qvtu.mapper.StudentMapper;
import cn.edu.qvtu.pojo.Students;
import org.junit.Test;
import org.junit.runner.RunWith;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;
import org.springframework.test.context.junit4.SpringRunner;
import java.util.List;
@RunWith(SpringRunner.class)
@SpringBootTest
public class StudentTest {
@Autowired
StudentMapper studentMapper;
@Test
public void test01() {
Students students = new Students();
students.setsID(31);
students.setsName("张三");
students.setsPass("123456");
students.setsRole(0);
students.setcID(5);
int result = studentMapper.addStudent(students);
if (result != 0) {
System.out.println("学生添加成功");
System.out.println("影响行数:" + result);
} else {
System.out.println("学生添加失败");
}
}
@Test
public void test02() {
Students students = new Students();
students.setsID(31);
students.setsName("xs31");
students.setsPass("123456");
students.setsRole(1);
students.setcID(3);
int result = studentMapper.updateStudent(students);
if (result != 0) {
System.out.println("学生修改成功");
System.out.println("影响行数:" + result);
} else {
System.out.println("学生修改失败");
}
}
@Test
public void test03() {
int result = studentMapper.deleteStudent(31);
if (result != 0) {
System.out.println("学生删除成功");
System.out.println("影响行数:" + result);
} else {
System.out.println("学生删除失败");
}
}
@Test
public void test04() {
List<Students> studentsList = studentMapper.selectStudentsByClassID(5);
if (studentsList != null && studentsList.size() != 0) {
System.out.println("查询成功,结果如下:");
studentsList.forEach(students -> System.out.println(students));
}else{
System.out.println("查询失败");
}
}
@Test
public void test05() {
List<Students> studentsList = studentMapper.selectFuzzyStudentsByStudentName("xs1");
if (studentsList != null && studentsList.size() != 0) {
System.out.println("查询成功,结果如下:");
studentsList.forEach(students -> System.out.println(students));
}else{
System.out.println("查询失败");
}
}
@Test
public void test06() {
List<Students> studentsList = studentMapper.selectFuzzyStudentsByStudentID(1);
if (studentsList != null && studentsList.size() != 0) {
System.out.println("查询成功,结果如下:");
studentsList.forEach(students -> System.out.println(students));
}else{
System.out.println("查询失败");
}
}
@Test
public void test07() {
List<Students> studentsList = studentMapper.selectStudentsByStudentRole(1);
if (studentsList != null && studentsList.size() != 0) {
System.out.println("查询成功,结果如下:");
studentsList.forEach(students -> System.out.println(students));
}else{
System.out.println("查询失败");
}
}
@Test
public void test08() {
Students student = studentMapper.selectByStudentID(10);
if(student!=null){
System.out.println("查询成功,结果如下:");
System.out.println(student);
}else{
System.out.println("查询失败");
}
}
}
没有合适的资源?快使用搜索试试~ 我知道了~
资源推荐
资源详情
资源评论
收起资源包目录
SBM_classmoney.zip (53个子文件)
SBM_classmoney
SBM_classmoney.iml 81B
pom.xml 3KB
src
test
java
cn
edu
qvtu
test
StudentTest.java 4KB
TypeTest.java 3KB
DetailTest.java 2KB
AdminTest.java 3KB
ClassTest.java 3KB
main
resources
application.yaml 280B
java
cn
edu
qvtu
SpringBootMain.java 318B
mapper
ClassMapper.xml 967B
StudentMapper.xml 1KB
DetailMapper.java 1KB
TypeMapper.xml 959B
ClassMapper.java 1KB
StudentMapper.java 2KB
AdminMapper.xml 1KB
TypeMapper.java 1KB
DetailMapper.xml 1KB
AdminMapper.java 1KB
controller
pojo
ClassMoneys.java 783B
Admins.java 801B
Classs.java 558B
Types.java 556B
Students.java 1KB
Details.java 1KB
service
util
.idea
uiDesigner.xml 9KB
workspace.xml 10KB
misc.xml 526B
compiler.xml 725B
encodings.xml 191B
target
classes
cn
edu
qvtu
mapper
ClassMapper.class 733B
ClassMapper.xml 967B
StudentMapper.xml 1KB
DetailMapper.class 1020B
TypeMapper.xml 959B
AdminMapper.class 701B
StudentMapper.class 899B
AdminMapper.xml 1KB
DetailMapper.xml 1KB
TypeMapper.class 709B
pojo
Students.class 2KB
Admins.class 1KB
Details.class 2KB
Classs.class 1KB
ClassMoneys.class 1KB
Types.class 1KB
SpringBootMain.class 720B
application.yaml 280B
test-classes
cn
edu
qvtu
test
AdminTest.class 4KB
TypeTest.class 4KB
DetailTest.class 3KB
StudentTest.class 5KB
ClassTest.class 4KB
generated-test-sources
test-annotations
generated-sources
annotations
共 53 条
- 1
资源评论
都来学
- 粉丝: 9
- 资源: 165
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功