Java用户名登录学生信息管理系统并对其进行增删改查操作

package zzzzzzzz;
import java.io.*;
//作者:凯鲁嘎吉 - 博客园
//http://www.cnblogs.com/kailugaji/ public class Text { public static void main(String[] args) throws MyException, IOException { Login l=new Login(); l.login(); } } class Student{ private String stunumber; private String name; private String age; private String sex; private String score; public void set_stunumber(String stu){ stunumber=stu; } public String get_stunumber(){ return stunumber; } void set_name(String na){ name=na; } String get_name(){ return name; } void set_age(String agee){ age=agee; } String get_age(){ return age; } void set_sex(String sexx){ sex=sexx; } String get_sex(){ return sex; } void set_score(String scoree){ score=scoree; } String get_score(){ return score; } } class StudentManager{ int n=0; Student ss[]=new Student[50]; //遍历学生信息 void showStudent(){ for(int i=0;i<=n;i++){ System.out.println("学号:"+ss[i].get_stunumber()+"姓名:"+ss[i].get_name()+"年龄:"+ss[i].get_age()+"性别:"+ss[i].get_sex()+"分数:"+ss[i].get_score()+"\t\n"); } } //判断学号是否已经存在 boolean panduan(String st) { boolean flag=true; for(int i=0;i<n;i++) { if(ss[i].get_stunumber().equals(st)) flag= false; else flag= true; } return flag; } //添加学生信息 void addStudent(String stunumber,String name,String age,String b,String score){ ss[n]=new Student(); ss[n].set_stunumber(stunumber); ss[n].set_name(name); ss[n].set_age(age); ss[n].set_sex(b); ss[n].set_score(score); n++; } //删除学生信息 void deleteStudent(String stunumber) throws MyException{ for(int i=0;i<=n;i++){ if(ss[i].get_stunumber().equals(stunumber)){ System.out.println("学号为:"+stunumber+"的学生已被删除!"); if(n==1){ System.out.println("数组为空"); ss[0]=new Student(); } else { for(int j=i;j<=n;j++){ ss[j]=ss[j+1]; } n--; } } else{ throw new MyException("该学生不存在!"); } } } //修改学生信息 void updateStudent(String stu1,String name,String age,String sex,String score) throws MyException{ for(int i=0;i<=n;i++){ if(ss[i].get_stunumber().equals(stu1)){ ss[i]=new Student(); ss[i].set_stunumber(stu1); ss[i].set_name(name); ss[i].set_age(age); ss[i].set_sex(sex); ss[i].set_score(score); } else throw new MyException("没有找到该学生!"); } } //查询学生信息 void selectStudent(String number) throws MyException{ for(int i=0;i<=n;i++){ if(ss[i].get_stunumber().equals(number)){ System.out.println("学号:"+ss[i].get_stunumber()+"姓名:"+ss[i].get_name()+"年龄:"+ss[i].get_age()+"性别:"+ss[i].get_sex()+"分数:"+ss[i].get_score()+"\t\n"); } else throw new MyException("没有找到该学生!"); } } //统计不及格的人数 void tongji(){ int s=0; for(int i=0;i<=n;i++){ int a=Integer.parseInt(ss[i].get_score()); if(a<=60){ s=s+1; System.out.println("学号:"+ss[i].get_stunumber()+"姓名:"+ss[i].get_name()+"年龄:"+ss[i].get_age()+"性别:"+ss[i].get_sex()+"分数:"+ss[i].get_score()+"\t\n"); } } System.out.println("不及格的人数为:"+s+"人"); } //输入界面 void showface(){ System.out.println("*****************************"); System.out.println("石家庄铁道大学学生信息管理系统"); System.out.println("*****************************"); System.out.println("1.遍历输出学生信息"); System.out.println("2.新学生信息录入"); System.out.println("3.删除学生信息"); System.out.println("4.修改学生信息"); System.out.println("5.查询学生信息"); System.out.println("6.学生信息统计"); System.out.println("7退出."); } } class Login{ User users=new User("001","123456");//用户名,密码 //登录 void login() throws MyException, IOException{ BufferedReader in=new BufferedReader(new InputStreamReader(System.in)); DataOutputStream out=new DataOutputStream(new BufferedOutputStream(new FileOutputStream("Student.txt",true))); for(int i=1;i<=3;i++){ System.out.println("请输入用户ID:"); String id=in.readLine(); System.out.println("请输入密码:"); String pass=in.readLine(); if((users.uername.equals(id))&&(users.passage.equals(pass))){ StudentManager sm=new StudentManager(); while(true){ sm.showface(); System.out.println("请选择:"); String choose=in.readLine(); if(choose.startsWith("1")){ sm.showStudent(); } else if(choose.startsWith("2")){ System.out.print("请输入学号:"); String stu=in.readLine(); System.out.print("请输入姓名:"); String name=in.readLine(); System.out.print("请输入年龄:"); String age=in.readLine(); System.out.println("请输入性别(true男,false女):"); String sex=in.readLine(); System.out.print("请输入分数:"); String score=in.readLine(); if(sm.panduan(stu)){ sm.addStudent(stu, name, age, sex, score); System.out.println("创建成功!"); out.writeUTF("|学号:"+stu+"|姓名:"+name+"|年龄:"+age+"|性别:"+sex+"|分数:"+score+"|\t\t\n\n"); } else throw new MyException("该学生已存在,请勿重复添加"); } else if(choose.startsWith("3")){ System.out.println("请输入学号:"); String stu=in.readLine(); if(!(sm.panduan(stu))){ sm.deleteStudent(stu); } else throw new MyException("该学号不存在!"); } else if(choose.startsWith("4")){ System.out.println("请输入学号:"); String stu=in.readLine(); System.out.println("请输入姓名:"); String name=in.readLine(); System.out.println("请输入年龄:"); String age=in.readLine(); System.out.print("请输入性别(true男,false女):"); String sex=in.readLine(); System.out.print("请输入分数:"); String score=in.readLine(); if(!(sm.panduan(stu))){ sm.updateStudent(stu, name, age, sex, score); out.writeUTF("|学号:"+stu+"|姓名:"+name+"|年龄:"+age+"|性别:"+sex+"|分数:"+score+"|\t\n"); } else throw new MyException("该学号不存在!"); } else if(choose.startsWith("5")){ System.out.println("请输入学号:"); String stu=in.readLine(); if(!(sm.panduan(stu))){ sm.selectStudent(stu); } else throw new MyException("该学号不存在!"); } else if(choose.startsWith("6")){ sm.tongji(); } else if(choose.startsWith("7")){ in.close(); out.close(); System.exit(0); } else { throw new MyException("选择错误,请重新选择"); } } } else System.out.println("用户ID或密码错误,请重新输入"); } throw new MyException("该卡已锁定!"); } } class User{ String uername; String passage; User(String user,String pass){ this.uername=user; this.passage=pass; } void set_uername(String use){ uername=use; } String get_uername(){ return uername; } void set_passage(String pass){ passage=pass; } String get_passage(){ return passage; } } class MyException extends Exception{ public MyException(String e) { super(e); } }

  

转载于:https://www.cnblogs.com/kailugaji/p/6842440.html

  • 0
    点赞
  • 11
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
以下是一个基于Java的简单宿舍管理系统示例,演示如何使用面向对象的思想实现对学生信息进行增删的功能。本系统使用MySQL数据库存储学生信息,需要使用JDBC连接数据库。 1. 创建学生类 ```java public class Student { private String id; // 学号 private String name; // 姓名 private int age; // 年龄 private String gender; // 性别 private String dorm; // 宿舍号 public Student() {} public Student(String id, String name, int age, String gender, String dorm) { this.id = id; this.name = name; this.age = age; this.gender = gender; this.dorm = dorm; } // getter和setter方法省略 public String toString() { return "学号:" + id + ",姓名:" + name + ",年龄:" + age + ",性别:" + gender + ",宿舍号:" + dorm; } } ``` 2. 创建学生DAO类,实现对学生信息增删操作 ```java import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.util.ArrayList; import java.util.List; public class StudentDAO { private String url = "jdbc:mysql://localhost:3306/dbname"; // 数据库连接地址 private String username = "root"; // 数据库用户名 private String password = "123456"; // 数据库密码 // 添加学生信息 public void addStudent(Student student) { Connection conn = null; PreparedStatement ps = null; try { // 获取数据库连接 conn = DriverManager.getConnection(url, username, password); // 插入学生信息 String sql = "INSERT INTO student(id, name, age, gender, dorm) VALUES(?, ?, ?, ?, ?)"; ps = conn.prepareStatement(sql); ps.setString(1, student.getId()); ps.setString(2, student.getName()); ps.setInt(3, student.getAge()); ps.setString(4, student.getGender()); ps.setString(5, student.getDorm()); ps.executeUpdate(); } catch (SQLException e) { e.printStackTrace(); } finally { // 关闭数据库连接 try { if (ps != null) { ps.close(); } if (conn != null) { conn.close(); } } catch (SQLException e) { e.printStackTrace(); } } } // 删除学生信息 public void deleteStudent(String id) { Connection conn = null; PreparedStatement ps = null; try { // 获取数据库连接 conn = DriverManager.getConnection(url, username, password); // 删除学生信息 String sql = "DELETE FROM student WHERE id=?"; ps = conn.prepareStatement(sql); ps.setString(1, id); ps.executeUpdate(); } catch (SQLException e) { e.printStackTrace(); } finally { // 关闭数据库连接 try { if (ps != null) { ps.close(); } if (conn != null) { conn.close(); } } catch (SQLException e) { e.printStackTrace(); } } } // 修学生信息 public void updateStudent(Student student) { Connection conn = null; PreparedStatement ps = null; try { // 获取数据库连接 conn = DriverManager.getConnection(url, username, password); // 更新学生信息 String sql = "UPDATE student SET name=?, age=?, gender=?, dorm=? WHERE id=?"; ps = conn.prepareStatement(sql); ps.setString(1, student.getName()); ps.setInt(2, student.getAge()); ps.setString(3, student.getGender()); ps.setString(4, student.getDorm()); ps.setString(5, student.getId()); ps.executeUpdate(); } catch (SQLException e) { e.printStackTrace(); } finally { // 关闭数据库连接 try { if (ps != null) { ps.close(); } if (conn != null) { conn.close(); } } catch (SQLException e) { e.printStackTrace(); } } } // 学生信息 public List<Student> findStudentById(String id) { Connection conn = null; PreparedStatement ps = null; ResultSet rs = null; List<Student> students = new ArrayList<Student>(); try { // 获取数据库连接 conn = DriverManager.getConnection(url, username, password); // 学生信息 String sql = "SELECT * FROM student WHERE id=?"; ps = conn.prepareStatement(sql); ps.setString(1, id); rs = ps.executeQuery(); while (rs.next()) { Student student = new Student(); student.setId(rs.getString("id")); student.setName(rs.getString("name")); student.setAge(rs.getInt("age")); student.setGender(rs.getString("gender")); student.setDorm(rs.getString("dorm")); students.add(student); } } catch (SQLException e) { e.printStackTrace(); } finally { // 关闭数据库连接 try { if (rs != null) { rs.close(); } if (ps != null) { ps.close(); } if (conn != null) { conn.close(); } } catch (SQLException e) { e.printStackTrace(); } } return students; } // 询所有学生信息 public List<Student> findAllStudents() { Connection conn = null; PreparedStatement ps = null; ResultSet rs = null; List<Student> students = new ArrayList<Student>(); try { // 获取数据库连接 conn = DriverManager.getConnection(url, username, password); // 学生信息 String sql = "SELECT * FROM student"; ps = conn.prepareStatement(sql); rs = ps.executeQuery(); while (rs.next()) { Student student = new Student(); student.setId(rs.getString("id")); student.setName(rs.getString("name")); student.setAge(rs.getInt("age")); student.setGender(rs.getString("gender")); student.setDorm(rs.getString("dorm")); students.add(student); } } catch (SQLException e) { e.printStackTrace(); } finally { // 关闭数据库连接 try { if (rs != null) { rs.close(); } if (ps != null) { ps.close(); } if (conn != null) { conn.close(); } } catch (SQLException e) { e.printStackTrace(); } } return students; } } ``` 3. 创建宿舍管理员界面,使用控制台进行交互 ```java import java.util.List; import java.util.Scanner; public class DormManager { private StudentDAO studentDAO = new StudentDAO(); public static void main(String[] args) { DormManager dormManager = new DormManager(); dormManager.showMenu(); } // 显示主菜单 public void showMenu() { Scanner scanner = new Scanner(System.in); while (true) { System.out.println("********** 欢迎使用宿舍管理系统 **********"); System.out.println("1. 添加学生信息"); System.out.println("2. 删除学生信息"); System.out.println("3. 修学生信息"); System.out.println("4. 学生信息"); System.out.println("5. 退出系统"); System.out.print("请选择操作(输入数字):"); String choice = scanner.nextLine(); switch (choice) { case "1": addStudent(); break; case "2": deleteStudent(); break; case "3": updateStudent(); break; case "4": findStudent(); break; case "5": System.out.println("谢谢使用,再见!"); System.exit(0); default: System.out.println("输入有误,请重新输入!"); } } } // 添加学生信息 public void addStudent() { Scanner scanner = new Scanner(System.in); System.out.println("请输入学生信息(学号 姓名 年龄 性别 宿舍号):"); String[] infos = scanner.nextLine().split(" "); Student student = new Student(infos[0], infos[1], Integer.parseInt(infos[2]), infos[3], infos[4]); studentDAO.addStudent(student); System.out.println("学生信息添加成功!"); } // 删除学生信息 public void deleteStudent() { Scanner scanner = new Scanner(System.in); System.out.print("请输入要删除的学生学号:"); String id = scanner.nextLine(); List<Student> students = studentDAO.findStudentById(id); if (students.size() == 0) { System.out.println("没有找到该学生信息!"); } else { studentDAO.deleteStudent(id); System.out.println("学生信息删除成功!"); } } // 修学生信息 public void updateStudent() { Scanner scanner = new Scanner(System.in); System.out.print("请输入要修学生学号:"); String id = scanner.nextLine(); List<Student> students = studentDAO.findStudentById(id); if (students.size() == 0) { System.out.println("没有找到该学生信息!"); } else { System.out.println("请输入要修学生信息(姓名 年龄 性别 宿舍号):"); String[] infos = scanner.nextLine().split(" "); Student student = new Student(id, infos[0], Integer.parseInt(infos[1]), infos[2], infos[3]); studentDAO.updateStudent(student); System.out.println("学生信息成功!"); } } // 学生信息 public void findStudent() { Scanner scanner = new Scanner(System.in); System.out.print("请输入要询的学生学号(输入0询所有):"); String id = scanner.nextLine(); List<Student> students; if (id.equals("0")) { students = studentDAO.findAllStudents(); } else { students = studentDAO.findStudentById(id); } if (students.size() == 0) { System.out.println("没有找到该学生信息!"); } else { for (Student student : students) { System.out.println(student); } } } } ``` 运行宿舍管理系统,即可进行学生信息增删操作

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值