第1页 / 共8页
第2页 / 共8页
第3页 / 共8页
第4页 / 共8页
第5页 / 共8页
第6页 / 共8页
第7页 / 共8页
第8页 / 共8页
java学生信息管理系统源代码.doc
//student
import java.sql.*;
import java.util.Scanner;
import java.io.*;
public class student
{
private String id;
private String name;
private int math;
private int english;
private int java;
private int computer;
private static String input="";
private static int choice;
String cid;
Statement stmt;
ResultSet rs;
private static Connection conn = null;
private static String username = "root"; //数据库用户名
private static String password = ""; //密码
private static String server = "localhost:3306";
private static String dbname = "test";
//数据库名
public static void main(String[] args) throws Exception
{
student start = new student();
start.getDataConnect();
while(true){
start.inputSelect();
if(choice==0) break;
String s = "\n\n\t\t\t 学 生 信 息 系 统\n\n\t\t 1 新 增\n\t\t 2 更 改\n\t\t 3 删 除
\n\t\t 4 查 找\n\t\t 5 显 示\n\t\t 0 退 出\n\n";
System.out.print(s);
String t =("请输入相应的序号：");
System.out.print(t);
}
conn.close();
}
public String getId()
{
return id;
}
public void setId(String id)
{
this.id = id;
}
public String getName()
{
return name;
}
public void setName(String name)
{
this.name = name;
}
public int getMath()
{
return math;
}
public void setMath(int math)
{
this.math = math;
}
public int getEnglish()
{
return english;
}
public void setEnglish(int english)
{
this.english = english;
}
public int getJava()
{
return java;
}
public void setJava(int java)
{
this.java = java;
}
public int getComputer()
{
return computer;
}
public void setComputer(int computer)
{
this.computer = computer;
}
public void getDataConnect()
{
// TODO Auto-generated method stub
try{
//注册 JDBC 连接驱动
Class.forName("org.gjt.mm.mysql.Driver");
}
catch(Exception e)
{
System.out.println(e.toString());
System.out.println("无法加载数据库驱动");
}
try{
conn
=
DriverManager.getConnection("jdbc:mysql://"+server+"/"+dbname,username,password);
}catch(Exception e){
System.out.println(e.toString());
}
String s = "\n\n\t\t\t 学 生 信 息 系 统\n\n\t\t 1 新 增\n\t\t 2 更 改\n\t\t 3 删 除
\n\t\t 4 查 找\n\t\t 5 显 示\n\t\t 0 退 出\n\n";
System.out.print(s);
String t =("请输入相应的序号：");
System.out.print(t);
}
{
public void
inputSelect()
while(true)
{
try
{
BufferedReader
buffer
=
new
BufferedReader(new
InputStreamReader(System.in));
input = buffer.readLine() ;
choice = Integer.parseInt(input) ;
if(choice<0 || choice>5)
{
throw new Exception();
}
else break;
}
catch(Exception e)
{
System.out.println("输入有误，请重新输入！");
}
}
switch (choice)
{
// 添加学生
case 1:
aa();
try{
stmt = conn.createStatement();
System.out.println(id);
math + "','" + english + "','" + java+ "','" + computer + "')");
System.out.println("insert into sss values('" + id + "','"+ name + "','" +
stmt.executeUpdate("insert into sss values('" + id + "','"+ name + "','" +
math + "','" + english + "','" + java+ "','" + computer + "')");
}catch(Exception e){}
System.out.println("\n 添加完成。");
break;
// 更改成绩
case 2:
aa();
try{
stmt = conn.createStatement();
stmt.executeUpdate("update sss set math='" + math + "',english='"+
english + "',java='" + java + "',computer='" + computer+ "' where sno=" + cid + "");
}catch(Exception e){}
System.out.println("\n 修改完成");
break;
// 删除指定学生
case 3:
System.out.println("请输入要改的学生学号：");
Scanner reader_cid = new Scanner(System.in);
String cid = reader_cid.next();
try{
stmt = conn.createStatement();
System.out.println("delete from sss where id='" + cid + "'");
stmt.executeUpdate("delete from sss where id='" + cid + "'");
}catch(Exception e){}
System.out.println("\n 删除完成");
break;
// 显示指定学生
case 4:
System.out.println("请输入查找的学生学号：");
Scanner reader_ad = new Scanner(System.in);
String ad = reader_ad.next();
System.out.println("\n" + ad+ "号学 生信息\n\n 学号\t 姓名\t 数学\t 英语
\tJAVA\t 计算机\t");
try{
stmt = conn.createStatement();
System.out.println("select * from sss where id='" + ad+ "'");
rs = stmt.executeQuery("select * from sss where id='" + ad+ "'");
while (rs.next())
{
rs.getInt(3)+ "\t" + rs.getInt(4) + "\t"+ rs.getInt(5) + "\t"+ rs.getInt(6) + "\t");
System.out.println(rs.getString(1) + "\t"+ rs.getString(2) + "\t" +
}
}catch(Exception e){}
break;
case 5:
// 输出全部信息
System.out.println("\n 全部学生信息\n\n 学号\t 姓名\t 数学\t 英语\tJAVA\t
计算机\t 平均成绩");
try{
stmt = conn.createStatement();
rs = stmt.executeQuery("select * from sss order by math desc");
while (rs.next())
{
int a = rs.getInt(3);
int b = rs.getInt(4);
int c = rs.getInt(5);
int d = rs.getInt(6);
System.out.println(rs.getString(1) + "\t"+ rs.getString(2) + "\t" + a +
"\t" + b + "\t"+ c + "\t" + d + "\t" + ((a + b + c + d) / 4));
}
}catch(Exception e){
System.out.println("Query error!");
}
break;
case 0:
break;
default:
System.out.println("感谢您的使用,再见!");
}
}
public void aa()
{
System.out.print("请输入学生信息\n");
System.out.println("请输入学号");
Scanner reader_id = new Scanner(System.in);
id = reader_id.next();
System.out.println("请输入姓名");
Scanner reader_name = new Scanner(System.in);
name = reader_id.next();
System.out.println("请输入数学成绩");
Scanner reader_math = new Scanner(System.in);
String str_math=reader_math.next();
math=Integer.parseInt(str_math);
System.out.println("请输入英语成绩");
Scanner reader_english = new Scanner(System.in);
String str_english=reader_english.next();
english=Integer.parseInt(str_english);
System.out.println("请输入 java 成绩");
Scanner reader_java = new Scanner(System.in);
String str_java=reader_java.next();
java=Integer.parseInt(str_java);
System.out.println("请输入计算机成绩");
Scanner reader_computer = new Scanner(System.in);
String str_computer=reader_computer.next();
computer=Integer.parseInt(str_computer);
}
}
相关推荐
2023年江西萍乡中考道德与法治真题及答案.doc
2012年重庆南川中考生物真题及答案.doc
2013年江西师范大学地理学综合及文艺理论基础考研真题.doc
2020年四川甘孜小升初语文真题及答案I卷.doc
2020年注册岩土工程师专业基础考试真题及答案.doc
2023-2024学年福建省厦门市九年级上学期数学月考试题及答案.doc
2021-2022学年辽宁省沈阳市大东区九年级上学期语文期末试题及答案.doc
2022-2023学年北京东城区初三第一学期物理期末试卷及答案.doc
2018上半年江西教师资格初中地理学科知识与教学能力真题及答案.doc
2012年河北国家公务员申论考试真题及答案-省级.doc
2020-2021学年江苏省扬州市江都区邵樊片九年级上学期数学第一次质量检测试题及答案.doc
2022下半年黑龙江教师资格证中学综合素质真题及答案.doc
