java+sql学生信息的增删改查
实现类:
package work0428JDBC2;
import work0428JDBC2.Test;
import work0428JDBC2.StudentBeen;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.util.Scanner;
import java.sql.Statement;
import java.lang.System;
public class DB {
public static void main(String[] args) throws Exception {
int i;
while(true) {
System.out.println("请输入你的选择,1为添加信息,2为查看信息,3为修改信息,4为删除信息,5为退出系统\n");
Scanner sc = new Scanner(System.in);
i=sc.nextInt();
switch(i) {
case 1:addStudent();break;
case 2:show();break;
case 3:modify();break;
case 4:del();break;
case 5:System.exit(0);break;
default:System.out.println("输入错误,请重新输入:");break;
}
}
}
//添加信息
public static void addStudent()throws ClassNotFoundException, SQLException {
int i = 0;
String sql = "insert into t_student (id,name,age) values(?,?,?)";
PreparedStatement pstmt;
Scanner sc = new Scanner(System.in);
System.out.println("请输入学生名字:\n");
String name = sc.nextLine();
System.out.println("请输入学生学号:\n");
int id = sc.