简单的部门管理系统

表结构
emp表
EMPNO | ENAME | JOB | MGR | HIREDATE | SAL | | DEPTNO |
dept表
DEPTNO | DNAME | LOC

public class JDBC_XITONG {
    public static void main(String[] args)throws Exception {
        Connection conn =null;
        PreparedStatement ps =null;
        ResultSet rs =null;
        Scanner request = new Scanner(System.in);
        int flag=0;
        //sql命令
        String sql1 ="insert into dept(deptno,dname,loc) values(?,?,?)";
        String sql2 ="select * from dept";
        String sql3 ="delete from dept where deptno =?";
        String sql4 ="update dept set dname=?,loc=? where deptno=?" ;
        String sql5 ="select count(*) from emp where ename=? and empno=?" ;
        //基础变量
        String deptNo,dname,loc,ename,empno;
        //注册驱动
        Class.forName("com.mysql.jdbc.Driver");
        //获取连接
        conn = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/world","root","123456");

        //登录验证
        System.out.println("请输入用户名字");
        ename = request.next();
        System.out.println("请输入用户编号");
        empno = request.next();
        ps = conn.prepareStatement(sql5);
        ps.setString(1,ename);
        ps.setInt(2,Integer.valueOf(empno));
        rs = ps.executeQuery();

        while (rs.next()){
          flag =  rs.getInt("count(*)");
        }
        if (rs!=null){
            rs.close();
        }
        if (ps!=null){
            ps.close();
        }
        if (flag!=1){
            System.out.println("登录信息不存在，请重新输入");
            return;
        }
        while (true){
            System.out.println("*欢迎使用本系统*");
            System.out.println("*1.添加部门*");
            System.out.println("2.查询部门");
            System.out.println("3.删除部门");
            System.out.println("4.更新部门");
            System.out.println("输入数字");

            //分支选择
            flag = request.nextInt();

            if (flag==1){
                System.out.println("输入部门编号");
                deptNo = request.next();
                System.out.println("输入部门名称");
                dname = request.next();
                System.out.println("输入部门位置");
                loc = request.next();
                ps = conn.prepareStatement(sql1);
                ps.setInt(1,Integer.valueOf(deptNo));
                ps.setString(2,dname);
                ps.setString(3,loc);
                flag = ps.executeUpdate();
                if (ps!=null){
                    ps.close();
                }
                if (flag==1){
                    System.out.println("部门添加成功");
                }else {
                    System.out.println("部门添加失败");
                }
            }else if (flag==2){
                ps = conn.prepareStatement(sql2);
                rs =  ps.executeQuery();
                while (rs.next()){
                    deptNo =  rs.getString("deptNo");
                    dname = rs.getString("dname");
                    loc = rs.getString("loc");
                    System.out.println("部门编号"+deptNo+"部门名称"+dname+"部门位置"+loc);

                }
                if (rs!=null){
                    rs.close();

                }
                if (ps!=null){
                    ps.close();
                }
            }else if (flag==3){
                System.out.println("输入部门编号");
                deptNo = request.next();
                ps = conn.prepareStatement(sql3);
                ps.setInt(1,Integer.valueOf(deptNo));
                flag = ps.executeUpdate();
                if (ps!=null){
                    ps.close();
                }
                if (flag==1){
                    System.out.println("部门删除成功");
                }else {
                    System.out.println("部门删除失败");
                }

            }else {
                System.out.println("输入部门编号");
                deptNo = request.next();
                System.out.println("输入部门名称");
                dname = request.next();
                System.out.println("输入部门位置");
                loc = request.next();
                ps = conn.prepareStatement(sql4);
                ps.setString(1,dname);
                ps.setString(2,loc);
                ps.setInt(3,Integer.valueOf(deptNo));
                flag = ps.executeUpdate();
                if (ps!=null){
                    ps.close();
                }
                if (flag==1){
                    System.out.println("部门信息更新成功");
                }else {
                    System.out.println("部门信息更新失败");
                }

            }
            System.out.println("退出请按0，回到上一级按任意健");
            flag = request.nextInt();
            if (flag==0){
                System.out.println("系统正在关闭中---");
                //关闭
                if (conn!=null){
                    conn.close();
                }
                System.out.println("已退出系统，欢迎下次使用");
                break;
            }

        }


    }

}