Java 学习笔记基础总结——学生管理系统

学生管理系统


定义学生管理类_

	// 定义学生管理系统类
	public class StudentMeng {
		//定义类成员
	    private String id;
	    private String name;
	    private String age;
	    private String address;
		
		// 定义空参构造方法
	    public StudentMeng() {
	    }
		// 定义满参构造方法
	    public StudentMeng(String id, String name, String age, String address) {
	        this.id = id;
	        this.name = name;
	        this.age = age;
	        this.address = address;
	    }
	    
		// 定义 get/ set 方法
	    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 String getAge() {
	        return age;
	    }
	
	    public void setAge(String age) {
	        this.age = age;
	    }
	
	    public String getAddress() {
	        return address;
	    }
	
	    public void setAddress(String address) {
	        this.address = address;
	    }
}

功能实现_


	import java.util.ArrayList;
	import java.util.Scanner;

	public class MengSystem {
    public static void main(String[] args) {
    	// 定义一个集合 里面存放StudentMeng类对对象
        ArrayList<StudentMeng> array = new ArrayList<>();
        Scanner sc = 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.println("+++++++++++++++++++++++++++++++++++++++");
            System.out.println("请输入你的选择:");
            // 输入对应序列跳转到对应功能
            switch (sc.nextInt()) {
                case 1:
                    addStudent(array);
                    //System.out.println(array.size());
                    break;
                case 2:
                    delStudent(array);
                    break;
                case 3:
                    changeStudent(array);
                    break;
                case 4:
                    findStudent(array);
                    break;
                case 5:
                    System.out.println("欢迎下次使用");
                    return;

                default:
                    System.out.println("您的输入有误,请重新输入!");


            }
        }


    }
	// 定义添加学生信息的方法
    public static void addStudent(ArrayList<StudentMeng> array) {

        Scanner sc = new Scanner(System.in);
        System.out.println("请输入学号");
        String id = sc.next();
        // 输入后判断是否已有该学号的学生 如果有则重新输入,没有则录入信息
        for (int i = 0; i < array.size(); i++) {
            if (array.get(i).getId().equals(id)) {
                System.out.println("已经有这个账号了,请重新输入");
                return;
            }
        }
		// 分别用变量接收
        System.out.println("请输入姓名");
        String name = sc.next();

        System.out.println("请输入年龄");
        String age = sc.next();

        System.out.println("请输入住址");
        String address = sc.next();
		// 创建StudentMeng对象 并把值赋给对应的成员变量
        StudentMeng stu = new StudentMeng();
        stu.setId(id);
        stu.setName(name);
        stu.setAge(age);
        stu.setAddress(address);
		// 用集合来接收
        array.add(stu);
        
        System.out.println("数据录入成功");
    }
	
	// 定义删除学生信息的方法
    public static void delStudent(ArrayList<StudentMeng> array) {
        Scanner sc = new Scanner(System.in);
		
        System.out.println("请输入您要删除的学生学号");
        String dels = sc.next();
        // 录入要删除的学生学号 判断是否有该学生的学号如果有则删除,没有返回提示 (判断方法定义在judegStudent)
        if (judgeStudent(array)) {
            for (int i = 0; i < array.size(); i++) {

                if (array.get(i).getId().equals(dels)) {
                    array.remove(i);
                    System.out.println("删除成功!");
                    break;
                } else {
                    System.out.println("没有这个学号哦");
                }
            }
        }


    }
	
	// 定义一个用来判断系统中是否有该学生信息的方法
    public static boolean judgeStudent(ArrayList<StudentMeng> array) {
        // 判断集合中的元素个数 为0则没有信息
        if (array.size() == 0) {
            System.out.println("还没有数据哦,请先录入信息");
            return false;
        }
        return true;
    }

	// 定义用来查看学生信息的方法
    public static void findStudent(ArrayList<StudentMeng> array) {
        Scanner sc = new Scanner(System.in);
        if (judgeStudent(array)){
            System.out.println("+++++++++++++学生信息查看系统+++++++++++++");
            System.out.println("学号\t\t\t" + "姓名\t\t\t" + "年龄\t\t\t" + "住址");
            // 用集合遍历
            for (int i = 0; i < array.size(); i++) {
                String id = array.get(i).getId();
                String name = array.get(i).getName();
                String age = array.get(i).getAge();
                String address = array.get(i).getAddress();

                System.out.println(id + "\t\t\t" + name + "\t\t\t" + age + "\t\t\t" + address);

            }
            sc.nextLine();
        }



    }

    public static void changeStudent(ArrayList<StudentMeng> array) {
        if (judgeStudent(array)) {
            Scanner sc = new Scanner(System.in);
            StudentMeng s = new StudentMeng();

            System.out.println("请输入要修改的学号");
            String sid = sc.next();
            for (int i1 = 0; i1 < array.size(); i1++) {
                if (array.get(i1).getId().equals(sid)) {
                    // System.out.println("arr");
                    System.out.println("请输入学号");
                    s.setId(sc.next());
                    System.out.println("请输入姓名");
                    s.setName(sc.next());
                    System.out.println("请输入年龄");
                    s.setAge(sc.next());
                    System.out.println("请输入地址");
                    s.setAddress(sc.next());

                    array.set(i1, s);
                    System.out.println("修改成功!");

                }


            }
            System.out.println("系统里没有这个学号哦,请确认后再输入");
        }

    }
}

  • 0
    点赞
  • 2
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
package cn.com.dao.chivementdao; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import cn.com.util.DBConnection; import cn.com.util.DBSql; import cn.com.vo.chivementvo.ChivementVo; public class ExamDao { private Connection conn = DBConnection.getConnectionOracle(); private ChivementVo examVo; public ExamDao() { } public ExamDao(ChivementVo examVo) { super(); this.examVo = examVo; } /** * 全部查询 */ public Object[][] selectAll() { Object date[][] = null; int max = 0; int i = 0; PreparedStatement ps = null; ResultSet rs = null; try { ps = conn.prepareStatement(DBSql.SELECT_ALL); rs = ps.executeQuery(); // 得到列数 max = rs.getMetaData().getColumnCount(); date = new Object[getnumberAll(DBSql.SELECT_ALL_COUNT)][max]; while (rs.next()) { for (int j = 0; j < max; j++) { date[i][j] = rs.getObject(j + 1); } i++; } // rs.close(); // ps.close(); // conn.close(); } catch (SQLException e) { e.printStackTrace(); } return date; } /** * 根据学号查询 */ public Object[][] selectBySid() { Object date[][] = null; int max = 0; int i = 0; PreparedStatement ps = null; ResultSet rs = null; try { ps = conn.prepareStatement(DBSql.SELECT_BY_S_ID); ps.setInt(1, examVo.getS_id()); rs = ps.executeQuery(); // 得到列数 max = rs.getMetaData().getColumnCount(); date = new Object[getnumber(DBSql.SELECT_BY_S_ID_COUNT, examVo .getS_id())][max]; while (rs.next()) { for (int j = 0; j < max; j++) { date[i][j] = rs.getObject(j + 1); } i++; } // rs.close(); // ps.close(); // conn.close(); } catch (SQLException e) { e.printStackTrace(); } return date; } /** * 根据组号查询 */ public Object[][] selectByGid() { Object date[][] = null; int max = 0; int i = 0; PreparedStatement ps = null; ResultSet rs = null; try { ps = conn.prepareStatement(DBSql.SELECT_BY_G_ID); ps.setInt(1, examVo.getG_id()); rs = ps.executeQuery(); // 得到列数 max = rs.getMetaData().getColumnCount(); date = new Object[getnumber(DBSql.SELECT_BY_G_ID_COUNT, examVo .getG_id())][max]; while (rs.next()) { for (int j = 0; j < max; j++) { date[i][j] = rs.getObject(j + 1); } i++; } // rs.close(); // ps.close(); // conn.close(); } catch (SQLException e) { e.printStackTrace(); } return date; } /** * 根据课程号查询 */ public Object[][] selectByCid() { Object date[][] = null; int max = 0; int i = 0; PreparedStatement ps = null; ResultSet rs = null; try { ps = conn.prepareStatement(DBSql.SELECT_BY_C_ID); ps.setInt(1, examVo.getC_id()); rs = ps.executeQuery(); // 得到列数 max = rs.getMetaData().getColumnCount(); date = new Object[getnumber(DBSql.SELECT_BY_C_ID_COUNT, examVo .getC_id())][max]; while (rs.next()) { for (int j = 0; j < max; j++) { // System.out.println( examVo.getG_id()); date[i][j] = rs.getObject(j+1); } i++; } // rs.close(); // ps.close(); // conn.close(); } catch (SQLException e) { e.printStackTrace(); } return date; } /** * 根据姓名模糊查询 * * @return */ public Object[][] selectByName() { Object date[][] = null; int max = 0; int i = 0; PreparedStatement ps = null; ResultSet rs = null; try { ps = conn.prepareStatement(DBSql.SELECT_BY_S_NAME); ps.setString(1, examVo.getS_name()); ps.setString(2, "%" + examVo.getS_name() + "%"); ps.setString(3, "%" + examVo.getS_name()); ps.setString(4, examVo.getS_name() + "%"); rs = ps.executeQuery(); // 得到列数 max = rs.getMetaData().getColumnCount(); date = new Object[getnumberByName(DBSql.SELECT_BY_S_NAME_COUNT, examVo.getS_name())][max]; while (rs.next()) { for (int j = 0; j < max; j++) { date[i][j] = rs.getObject(j + 1); } i++; } } catch (SQLException e) { e.printStackTrace(); } return date; } /** * 根据课程名称模糊查询 * * @return */ public Object[][] selectByClassName() { Object date[][] = null; int max = 0; int i = 0; PreparedStatement ps = null; ResultSet rs = null; try { ps = conn.prepareStatement(DBSql.SELECT_BY_CLASS_NAME); ps.setString(1, examVo.getClass_name()); ps.setString(2, "%" + examVo.getClass_name() + "%"); ps.setString(3, "%" + examVo.getClass_name()); ps.setString(4, examVo.getClass_name() + "%"); rs = ps.executeQuery(); // 得到列数 max = rs.getMetaData().getColumnCount(); date = new Object[getnumberByName(DBSql.SELECT_BY_CLASS_COUNT, examVo.getClass_name())][max]; while (rs.next()) { for (int j = 0; j < max; j++) { date[i][j] = rs.getObject(j + 1); } i++; } } catch (SQLException e) { e.printStackTrace(); } return date; } /** * 修改选中学生的成绩 * */ public void updatSelectClass() { PreparedStatement ps = null; ResultSet rs = null; try { ps = conn.prepareStatement(DBSql.UPDATE_EXAM_BY_STUID); ps.setInt(1, examVo.getClassExamChivement()); ps.setInt(2, examVo.getS_id()); ps.setInt(3, examVo.getC_id()); ps.executeUpdate(); } catch (SQLException e) { e.printStackTrace(); } } /** * 得到所有课程号和课程名 * * @return */ public String[] getClassNoName() { String[] classNoName = null; PreparedStatement ps = null; ResultSet rs = null; int j = 0; try { int i = getnumberAll(DBSql.SELECT_CLASS_NAME_COUNT); classNoName = new String[i + i]; ps = conn.prepareStatement(DBSql.SELECT_CLASS_NAME); rs = ps.executeQuery(); while (rs.next()) { classNoName[j] = rs.getString(1); classNoName[j + i] = rs.getString(2); j++; } } catch (SQLException e) { e.printStackTrace(); } return classNoName; } /** * 根据科目修改成绩 查询学号 姓名 成绩 * */ public void SelectClassStuName() { int i = 0; PreparedStatement ps = null; ResultSet rs = null; int j = getnumberBySelectClassName( DBSql.SELECT_CLASS_STU_SNO_SNAME_EXAM_COUNT, examVo.getC_id()); int[] sNum = new int[j]; String[] sName = new String[j]; int[] classExam = new int[j]; try { ps = conn.prepareStatement(DBSql.SELECT_CLASS_STU_SNO_SNAME_EXAM); ps.setInt(1, examVo.getC_id()); rs = ps.executeQuery(); while (rs.next()) { sNum[i] = rs.getInt(1); sName[i] = rs.getString(2); classExam[i] = rs.getInt(3); i++; } } catch (SQLException e) { e.printStackTrace(); } examVo.setSid(sNum); examVo.setSname(sName); examVo.setClassExam(classExam); } /** * 根据科目修改成绩 查询学号 姓名 成绩 后修改成绩 * */ public void UpdateClassStuName() { // int i = 0; PreparedStatement ps = null; ResultSet rs = null; int j = getnumberBySelectClassName( DBSql.SELECT_CLASS_STU_SNO_SNAME_EXAM_COUNT, examVo.getC_id()); try { ps = conn.prepareStatement(DBSql.UPDATE_CHIVEMENT_BY_CLASS); for(int i =0;i<j;i++){ ps.setInt(1, examVo.getClassExam()[i]); ps.setInt(2, examVo.getSid()[i]); ps.setInt(3, examVo.getC_id()); ps.executeUpdate(); } } catch (SQLException e) { e.printStackTrace(); } } /** * 全部查询获得行数 * * @return */ public int getnumberAll(String str) { int number = 0; PreparedStatement ps = null; ResultSet rs = null; try { ps = conn.prepareStatement(str); rs = ps.executeQuery(); rs.next(); number = rs.getInt(1); // rs.close(); // ps.close(); // conn.close(); } catch (SQLException e) { e.printStackTrace(); } return number; } /** * 根据学号 根据组号 根据课程号查询 获得行数 * * @return */ public int getnumber(String str, int i) { int number = 0; PreparedStatement ps = null; ResultSet rs = null; try { ps = conn.prepareStatement(str); ps.setInt(1, i); rs = ps.executeQuery(); rs.next(); number = rs.getInt(1); // rs.close(); // ps.close(); // conn.close(); } catch (SQLException e) { e.printStackTrace(); } return number; } /** * 根据姓名 课程名 查询 获得行数 * */ public int getnumberByName(String str, String i) { int number = 0; PreparedStatement ps = null; ResultSet rs = null; try { ps = conn.prepareStatement(str); ps.setString(1, i); ps.setString(2, "%" + i + "%"); ps.setString(3, "%" + i); ps.setString(4, i + "%"); rs = ps.executeQuery(); rs.next(); number = rs.getInt(1); } catch (SQLException e) { e.printStackTrace(); } return number; } // /** // * 根据课程名查询 获得行数 // * // */ // // public int getnumberByClassName(String str, String i) { // int number = 0; // PreparedStatement ps = null; // ResultSet rs = null; // try { // ps = conn.prepareStatement(str); // ps.setString(1, i); // ps.setString(2, "%" + i + "%"); // ps.setString(3, "%" + i); // ps.setString(4, i + "%"); // rs = ps.executeQuery(); // rs.next(); // number = rs.getInt(1); // } catch (SQLException e) { // e.printStackTrace(); // } // return number; // } /** * * 根据课程名修改成绩获得行数 * * @param str * @param i * @return */ public int getnumberBySelectClassName(String str, int i) { int number = 0; PreparedStatement ps = null; ResultSet rs = null; try { ps = conn.prepareStatement(str); ps.setInt(1, i); rs = ps.executeQuery(); rs.next(); number = rs.getInt(1); } catch (SQLException e) { e.printStackTrace(); } return number; } }

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

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

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值