📄 student.java
字号:
import java.io.*;
import java.util.*;
import java.sql.*;
public class Student {
public static void main(String[] srg) throws NumberFormatException, IOException {
String driverName = "com.microsoft.sqlserver.jdbc.SQLServerDriver"; //加载JDBC驱动
String dbURL = "jdbc:sqlserver://localhost:1433;DatabaseName=Students"; //连接服务器和数据库sample
String userName = "sa"; //默认用户名
String userPwd = "guanzhx@sysu"; //密码
Connection dbConn;
System.out.println("连接数据库成功");
System.out.println(" 班级信息管理系统（Num.1_关真新_05373009）");
int l=0;
do{
System.out.println("本程序可提供您选择的功能：" +"\n"+
"0、查询数据库中所有信息；" +"\n"+
"1、录入新的学生信息；" +"\n"+
"2、编辑学生信息；" +"\n"+
"3、删除学生信息；" +"\n"+
"4、按成绩顺序列出课程的班级成绩表(成绩排列由低到高)。" +"\n"+
"5、退出本程序。"); // 程序提供的功能
System.out.println("您可以通过输入0、1、2、3、4、5来选择不同的功能。请选择您需要的功能：");
BufferedReader din = new BufferedReader(new InputStreamReader(System.in)); //为用户输入准备
int din0=Integer.parseInt(din.readLine()); //用户初步选择要使用的功能
String i="",n="",m="",eg="",c="",j="";
switch(din0)
{
case 0: //用户选择查询当前数据库中的所有信息
System.out.println("您选择了查询当前数据库中的所有信息");
System.out.println("您的查询结果是:"+"\n"+" Id "+"---"+"Name"+"---"+"Math"+"---"+"Eng"+"---"+" C "+"---"+"Java");
try {
Class.forName(driverName);
dbConn = DriverManager.getConnection(dbURL, userName, userPwd);
Statement stmt = dbConn.createStatement();
ResultSet rs = null;
String sql="select * from 信息";
rs=stmt.executeQuery(sql);
while(rs.next()){
i=rs.getString("Id");
n=rs.getString("Name");
m=rs.getString("Math");
eg=rs.getString("English");
c=rs.getString("C");
j=rs.getString("Java");
System.out.println(i+"---"+n+"---"+m+"---"+eg+"--" + "-"+c+"---"+j);
}
} catch (Exception e) {
e.printStackTrace();
}
l=1;
break;
case 1: //用户选择录入新的学生信息
System.out.println("您选择了录入新的学生信息"+"\n"+"请您输入新的学生Id：");
String din10=din.readLine();
System.out.println("请您输入新的学生Name：");
String din11=din.readLine();
System.out.println("请您输入新的学生Math成绩：");
String din12=din.readLine();
System.out.println("请您输入新的学生English成绩：");
String din13=din.readLine();
System.out.println("请您输入新的学生C成绩：");
String din14=din.readLine();
System.out.println("请您输入新的学生Java成绩：");
String din15=din.readLine();
try {
Class.forName(driverName);
dbConn = DriverManager.getConnection(dbURL, userName, userPwd);
Statement stmt = dbConn.createStatement();
boolean rs = true;
String sql="insert into 信息 values (' "+String.valueOf(din10)+"'"+","+"'"+String.valueOf(din11)+"'"+","+"'"+String.valueOf(din12)+"'"+","+"'"+String.valueOf(din13)+"'"+","+"'"+String.valueOf(din14)+"'"+","+"'"+String.valueOf(din15)+"')";
rs=stmt.execute(sql);
} catch (Exception e) {
e.printStackTrace();
}
l=1;
break;
case 2: //用户选择编辑已有学生的信息
System.out.println("您选择了编辑已有的学生学生信息"+"\n"+"请您输入您要编辑的学生学号：");
String din2=din.readLine();
System.out.println("请选择你要编辑的选项：1、Id；2、Name；3、Math；4、English；5、C；6、Java。");
int din20=Integer.parseInt(din.readLine());
switch(din20)
{
case 1:
System.out.println("请您输入学生新的Id：");
String din21=din.readLine();
try {
Class.forName(driverName);
dbConn = DriverManager.getConnection(dbURL, userName, userPwd);
Statement stmt = dbConn.createStatement();
boolean rs = true;
String sql="update 信息 set Id=' "+String.valueOf(din21)+"' where Id='"+String.valueOf(din2)+"'";
rs=stmt.execute(sql);
} catch (Exception e) {
e.printStackTrace();
}
break;
case 2:
System.out.println("请您输入学生新的Name：");
String din22=din.readLine();
try {
Class.forName(driverName);
dbConn = DriverManager.getConnection(dbURL, userName, userPwd);
Statement stmt = dbConn.createStatement();
boolean rs = true;
String sql="update 信息 set Name=' "+String.valueOf(din22)+"' where Id='"+String.valueOf(din2)+"'";
rs=stmt.execute(sql);
} catch (Exception e) {
e.printStackTrace();
}
break;
case 3:
System.out.println("请您输入学生新的Math成绩：");
String din23=din.readLine();
try {
Class.forName(driverName);
dbConn = DriverManager.getConnection(dbURL, userName, userPwd);
Statement stmt = dbConn.createStatement();
boolean rs = true;
String sql="update 信息 set Math=' "+String.valueOf(din23)+"' where Id='"+String.valueOf(din2)+"'";
rs=stmt.execute(sql);
} catch (Exception e) {
e.printStackTrace();
}
break;
case 4:
System.out.println("请您输入学生新的English成绩：");
String din24=din.readLine();
try {
Class.forName(driverName);
dbConn = DriverManager.getConnection(dbURL, userName, userPwd);
Statement stmt = dbConn.createStatement();
boolean rs = true;
String sql="update 信息 set English=' "+String.valueOf(din24)+"' where Id='"+String.valueOf(din2)+"'";
rs=stmt.execute(sql);
} catch (Exception e) {
e.printStackTrace();
}
break;
case 5:
System.out.println("请您输入学生新的C成绩：");
String din25=din.readLine();
try {
Class.forName(driverName);
dbConn = DriverManager.getConnection(dbURL, userName, userPwd);
Statement stmt = dbConn.createStatement();
boolean rs = true;
String sql="update 信息 set C=' "+String.valueOf(din25)+"' where Id='"+String.valueOf(din2)+"'";
rs=stmt.execute(sql);
} catch (Exception e) {
e.printStackTrace();
}
break;
case 6:
System.out.println("请您输入学生新的Java成绩：");
String din26=din.readLine();
try {
Class.forName(driverName);
dbConn = DriverManager.getConnection(dbURL, userName, userPwd);
Statement stmt = dbConn.createStatement();
boolean rs = true;
String sql="update 信息 set Java=' "+String.valueOf(din26)+"' where Id='"+String.valueOf(din2)+"'";
rs=stmt.execute(sql);
} catch (Exception e) {
e.printStackTrace();
}
break;
default:
System.out.println("您的输入出现错误！");
break;
}
System.out.println("您的修改已经成功！");
l=1;
break;
case 3: //用户选择删除学生信息
System.out.println("您选择了删除已有的学生学生信息"+"\n"+"请您输入您要删除的学生学号（如要全部删除请输入0）：");
String din3=din.readLine();
if(din3.equals("0")){
try {
Class.forName(driverName);
dbConn = DriverManager.getConnection(dbURL, userName, userPwd);
Statement stmt = dbConn.createStatement();
boolean rs = true;
String sql="delete from 信息 ";
rs=stmt.execute(sql);
System.out.println("删除完毕。");
} catch (Exception e) {
e.printStackTrace();
}
}else{
try {
Class.forName(driverName);
dbConn = DriverManager.getConnection(dbURL, userName, userPwd);
Statement stmt = dbConn.createStatement();
boolean rs = true;
String sql="delete 信息 where Id= "+String.valueOf(din3);
rs=stmt.execute(sql);
System.out.println("删除完毕。");
} catch (Exception e) {
e.printStackTrace();
}
}
l=1;
break;
case 4: //用户选择查询某一科目的班级成绩表
System.out.println("您选择了按成绩顺序列出课程的班级成绩表。"+"\n"+"请您输入您要输出的课程名称(如果想退出本功能请输入exit)：");
int g=0;
do{
String din4=din.readLine();
try {
Class.forName(driverName);
dbConn = DriverManager.getConnection(dbURL, userName, userPwd);
Statement stmt = dbConn.createStatement();
ResultSet rs = null;
if(din4.equals("math")){
String sql="select * from 信息 order by "+String.valueOf("Math");
rs=stmt.executeQuery(sql);
while(rs.next()){
i=rs.getString("Id");
n=rs.getString("Name");
m=rs.getString("Math");
System.out.println(i+"---"+n+"---"+m); }
l=1;
}else {
if(din4.equals("english")){
String sql="select * from 信息 order by English";
rs=stmt.executeQuery(sql);
while(rs.next()){
i=rs.getString("Id");
n=rs.getString("Name");
eg=rs.getString("English");
System.out.println(i+"---"+n+"---"+eg); }
l=1;
}else {
if(din4.equals("c")){
String sql="select * from 信息 order by c";
rs=stmt.executeQuery(sql);
while(rs.next()){
i=rs.getString("Id");
n=rs.getString("Name");
c=rs.getString("C");
System.out.println(i+"---"+n+"---"+c); }
l=1;
}else {
if(din4.equals("java")){
String sql="select * from 信息 order by Java";
rs=stmt.executeQuery(sql);
while(rs.next()){
i=rs.getString("Id");
n=rs.getString("Name");
j=rs.getString("Java");
System.out.println(i+"---"+n+"---"+j); }
l=1;
}else {
if(din4.equals("exit")){
g=0;
}else{
System.out.println("您的输入错误，不存在这门课程！请重新输入课程名称：");
g=1;
}
}
}
}
}
} catch (Exception e) {
e.printStackTrace();
}
}while(g!=0);
l=1;
break;
case 5:
System.out.println("您选择了退出本程序，谢谢使用！");
l=0;
break;
default:
System.out.println("您的输入出现错误！请重新输入您需要的功能：");
l=1;
break;
}
}while (l!=0);
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -