practice.class
package 练习;
import org.junit.jupiter.api.Test;
import 通用操作.JDBCUtils;
import 通用操作.PreparedStatementQuery;
import java.util.Scanner;
import static 通用操作.JDBCUtils.update;
/**
* @author coffee
* @date 2021-02-22 19:20
*/
public class practice {
public static void main(String[] args) {
Scanner s = new Scanner(System.in);
// System.out.print("请输入用户名:");
// String name = s.next();
// System.out.print("请输入邮箱:");
// String email = s.next();
// System.out.print("请输入生日:");
// String birth = s.next();
//
// int i = update("insert into customers(name,email,birth) values(?,?,?)", name, email, birth);
// if(i > 0)
// System.out.println("添加成功");
// else
// System.out.println("添加失败");
/**
* 插入一个新的 student 信息
*/
// System.out.print("请输入四/六级:");
// String type = s.next();
// System.out.print("请输入身份证号码:");
// String idCard = s.next();
// System.out.print("请输入准考证号码:");
// String examCard = s.next();
// System.out.print("请输入学生姓名:");
// String studentName = s.next();
// System.out.print("请输入区域:");
// String location = s.next();
// System.out.print("请输入成绩:");
// String grade = s.next();
//
// int update = update("insert into examstudent(type,idCard,examCard,studentName,location,grade) values(?,?,?,?,?,?)", type, idCard, examCard, studentName, location, grade);
// if (update > 0)
// System.out.println("信息录入成功");
// else
// System.out.println("失败");
/**
*输入准考证号或身份证号查询学生信息
*/
// System.out.println("请选择您要输入的类型:");
// System.out.println("a:准考证号");
// System.out.println("b:身份证号");
// String menu = s.next();
// if (menu.equals("a")){
// System.out.print("请输入准考证号:");
// String examCard = s.next();
// examstudent instance = PreparedStatementQuery.getInstance(examstudent.class,"select * from examstudent where examCard = ?", examCard);
// if (instance == null)
// System.out.println("查无此人,请重新进入程序");
// else {
// System.out.println("========查询结果========");
// System.out.println("流水号:" + instance.getFlowID());
// System.out.println("四/六级:" + instance.getType());
// System.out.println("身份证号:" + instance.getIDCard());
// System.out.println("准考证号:" + instance.getExamCard());
// System.out.println("学生姓名:" + instance.getStudentName());
// System.out.println("区域:" + instance.getLocation());
// System.out.println("成绩:" + instance.getGrade());
// }
// }else if (menu.equals("b")){
// System.out.print("请输入身份证号:");
// String IDCard = s.next();
// examstudent instance = PreparedStatementQuery.getInstance(examstudent.class, "select * from examstudent where IDCard = ?", IDCard);
// if (instance == null)
// System.out.println("查无此人,请重新进入程序");
// else {
// System.out.println("========查询结果========");
// System.out.println("流水号:" + instance.getFlowID());
// System.out.println("四/六级:" + instance.getType());
// System.out.println("身份证号:" + instance.getIDCard());
// System.out.println("准考证号:" + instance.getExamCard());
// System.out.println("学生姓名:" + instance.getStudentName());
// System.out.println("区域:" + instance.getLocation());
// System.out.println("成绩:" + instance.getGrade());
// }
// }
// else
// System.out.println("输入有误");
/**
* 删除学生信息
*/
System.out.print("请输入学生的考号:");
String ExamCard = s.next();
int update = update("delete from examstudent where ExamCard= ?", ExamCard);
if (update > 0)
System.out.println("删除成功!");
else
System.out.println("查无此人,请重新输入!");
}
}
examstudent .class
package 练习;
/**
* @author coffee
* @date 2021-02-22 20:28
*/
public class examstudent {
private int FlowID;
private int Type;
private String IDCard;
private String ExamCard;
private String StudentName;
private String Location;
private int Grade;
public int getFlowID() {
return FlowID;
}
public void setFlowID(int flowID) {
FlowID = flowID;
}
public int getType() {
return Type;
}
public void setType(int type) {
Type = type;
}
public String getIDCard() {
return IDCard;
}
public void setIDCard(String IDCard) {
this.IDCard = IDCard;
}
public String getExamCard() {
return ExamCard;
}
public void setExamCard(String examCard) {
ExamCard = examCard;
}
public String getStudentName() {
return StudentName;
}
public void setStudentName(String studentName) {
StudentName = studentName;
}
public String getLocation() {
return Location;
}
public void setLocation(String location) {
Location = location;
}
public int getGrade() {
return Grade;
}
public void setGrade(int grade) {
Grade = grade;
}
@Override
public String toString() {
return "examstudent{" +
"FlowID=" + FlowID +
", Type=" + Type +
", IDCard='" + IDCard + '\'' +
", ExamCard='" + ExamCard + '\'' +
", StudentName='" + StudentName + '\'' +
", Location='" + Location + '\'' +
", Grade=" + Grade +
'}';
}
}