package java4.exer;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.util.Scanner;
import org.junit.Test;
import java3.util.JDBCUtils;
public class Exer1Test {
@Test
public void testInsert(){
Scanner scanner = new Scanner(System.in);
System.out.println("请输入用户名：");
String name=scanner.next();
System.out.println("请输入邮箱");
String email = scanner.next();
System.out.println("请输入生日：");
String birthday = scanner.next();
String sql="insert into customers(name,email,birth)values(?,?,?)";
int insertCount = update(sql, name,email,birthday);
if(insertCount>0){
System.out.println("添加成功");
}else{
System.out.println("添加失败");
}
}
public int update(String sql,Object ...args) {
Connection conn=null;
PreparedStatement ps=null;
try {
conn = JDBCUtils.getConnedtion();
ps = conn.prepareStatement(sql);
for(int i=0;i
package java4.exer;
import java.lang.reflect.Field;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.util.Scanner;
import org.junit.Test;
import java3.util.JDBCUtils;
public class Exer2Test {
/*
* 向examstudent表中添加一条记录
*/
@Test
public void testInsert(){
Scanner scanner = new Scanner(System.in);
System.out.println("四级/六级: ");
int type = scanner.nextInt();
System.out.println("身份证号");
String IDCard = scanner.next();
System.out.println("准考证号");
String examCard = scanner.next();
System.out.println("学生姓名");
String studentName = scanner.next();
System.out.println("所在城市");
String location = scanner.next();
System.out.println("考试成绩：");
int grade = scanner.nextInt();
String sql="insert into examstudent(type,IDCard,examCard,studentName,location,grade)values(?,?,?,?,?,?)";
int insertCount = update(sql, type,IDCard,examCard,studentName,location,grade);
if(insertCount>0){
System.out.println("添加成功");
}else{
System.out.println("添加失败");
}
}
public int update(String sql,Object...args) {
Connection conn=null;
PreparedStatement ps=null;
try {
conn = JDBCUtils.getConnedtion();
ps = conn.prepareStatement(sql);
for(int i=0;i T getInstance(Class clazz,String sql,Object ...args) {
Connection conn=null;
PreparedStatement ps=null;
ResultSet rs=null;
try {
conn = JDBCUtils.getConnedtion();
ps = conn.prepareStatement(sql);
for(int i=0;i0){
System.out.println("删除成功");
}else{
System.out.println("查无此人！");
}
}
}
package java4.exer;
public class Student {
private int flowID;
private int type;
private String IDCard;
private String examCard;
private String name;
private String location;
private int grade;
public Student() {
super();
}
public Student(int flowID, int type, String iDCard, String examCard, String name, String location, int grade) {
super();
this.flowID = flowID;
this.type = type;
IDCard = iDCard;
this.examCard = examCard;
this.name = name;
this.location = location;
this.grade = grade;
}
public int getFlowID() {
return flowID;
}
public void setFlowID(int flowID) {
this.flowID = flowID;
}
public int getType() {
return type;
}
public void setType(int type) {
this.type = type;
}
public String getIDCard() {
return IDCard;
}
public void setIDCard(String iDCard) {
IDCard = iDCard;
}
public String getExamCard() {
return examCard;
}
public void setExamCard(String examCard) {
this.examCard = examCard;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getLocation() {
return location;
}
public void setLocation(String location) {
this.location = location;
}
public int getGrade() {
return grade;
}
public void setGrade(int grade) {
this.grade = grade;
}
@Override
public String toString() {
System.out.println("==============查询结果===========");
return info();
}
private String info() {
return "流水号: "+flowID+"\n四级/六级: "+type+"\n身份证号："+IDCard+"\n准考证号："+examCard+
"\n学生姓名："+name+"\n区域："+location+"\n成绩："+grade;
}
}