ZIPIDEA+MySql学生管理系统 2.63MB

qq_67241887需要积分:5(1积分=1元)

资源文件列表:

学生管理系统 .zip 大约有48个文件
  1. 06-学生选课系统/ManageStudent/
  2. 06-学生选课系统/ManageStudent/.idea/
  3. 06-学生选课系统/ManageStudent/.idea/.gitignore 50B
  4. 06-学生选课系统/ManageStudent/.idea/dbnavigator.xml 20.98KB
  5. 06-学生选课系统/ManageStudent/.idea/encodings.xml 205B
  6. 06-学生选课系统/ManageStudent/.idea/libraries/
  7. 06-学生选课系统/ManageStudent/.idea/libraries/lib.xml 379B
  8. 06-学生选课系统/ManageStudent/.idea/misc.xml 279B
  9. 06-学生选课系统/ManageStudent/.idea/modules.xml 273B
  10. 06-学生选课系统/ManageStudent/.idea/workspace.xml 18.59KB
  11. 06-学生选课系统/ManageStudent/lib/
  12. 06-学生选课系统/ManageStudent/ManageStudent.iml 494B
  13. 06-学生选课系统/ManageStudent/ManageStudent/
  14. 06-学生选课系统/ManageStudent/ManageStudent/dbFunction.java 7.78KB
  15. 06-学生选课系统/ManageStudent/ManageStudent/images/
  16. 06-学生选课系统/ManageStudent/ManageStudent/images/1.png 509.23KB
  17. 06-学生选课系统/ManageStudent/ManageStudent/images/2.png 791.5KB
  18. 06-学生选课系统/ManageStudent/ManageStudent/images/btn1.png 5.5KB
  19. 06-学生选课系统/ManageStudent/ManageStudent/images/btn2.png 3.64KB
  20. 06-学生选课系统/ManageStudent/ManageStudent/images/btn3.png 7.32KB
  21. 06-学生选课系统/ManageStudent/ManageStudent/images/btn4.png 7.26KB
  22. 06-学生选课系统/ManageStudent/ManageStudent/images/登录.png 6.36KB
  23. 06-学生选课系统/ManageStudent/ManageStudent/LoginJFrame.java 2.46KB
  24. 06-学生选课系统/ManageStudent/ManageStudent/mySystemJFrame.java 10.96KB
  25. 06-学生选课系统/ManageStudent/out/
  26. 06-学生选课系统/ManageStudent/out/production/
  27. 06-学生选课系统/ManageStudent/out/production/ManageStudent/
  28. 06-学生选课系统/ManageStudent/out/production/ManageStudent/.idea/
  29. 06-学生选课系统/ManageStudent/out/production/ManageStudent/.idea/.gitignore 50B
  30. 06-学生选课系统/ManageStudent/out/production/ManageStudent/.idea/dbnavigator.xml 20.98KB
  31. 06-学生选课系统/ManageStudent/out/production/ManageStudent/.idea/libraries/
  32. 06-学生选课系统/ManageStudent/out/production/ManageStudent/.idea/libraries/lib.xml 379B
  33. 06-学生选课系统/ManageStudent/out/production/ManageStudent/.idea/misc.xml 279B
  34. 06-学生选课系统/ManageStudent/out/production/ManageStudent/.idea/modules.xml 273B
  35. 06-学生选课系统/ManageStudent/out/production/ManageStudent/.idea/workspace.xml 18.28KB
  36. 06-学生选课系统/ManageStudent/out/production/ManageStudent/ManageStudent.iml 494B
  37. 06-学生选课系统/ManageStudent/out/production/ManageStudent/ManageStudent/
  38. 06-学生选课系统/ManageStudent/out/production/ManageStudent/ManageStudent/dbFunction.class 5.97KB
  39. 06-学生选课系统/ManageStudent/out/production/ManageStudent/ManageStudent/images/
  40. 06-学生选课系统/ManageStudent/out/production/ManageStudent/ManageStudent/images/1.png 509.23KB
  41. 06-学生选课系统/ManageStudent/out/production/ManageStudent/ManageStudent/images/2.png 791.5KB
  42. 06-学生选课系统/ManageStudent/out/production/ManageStudent/ManageStudent/images/btn1.png 5.5KB
  43. 06-学生选课系统/ManageStudent/out/production/ManageStudent/ManageStudent/images/btn2.png 3.64KB
  44. 06-学生选课系统/ManageStudent/out/production/ManageStudent/ManageStudent/images/btn3.png 7.32KB
  45. 06-学生选课系统/ManageStudent/out/production/ManageStudent/ManageStudent/images/btn4.png 7.26KB
  46. 06-学生选课系统/ManageStudent/out/production/ManageStudent/ManageStudent/images/登录.png 6.36KB
  47. 06-学生选课系统/ManageStudent/out/production/ManageStudent/ManageStudent/LoginJFrame.class 3.81KB
  48. 06-学生选课系统/ManageStudent/out/production/ManageStudent/ManageStudent/mySystemJFrame.class 7.57KB

资源介绍:

用户通过系统界面进入，选择相应功能：增加学生档案信息、增加课程信息、增加学生选课信息确认无误后将其信息保存到数据库中，此外对增加的信息可完成增删改查操作
package ManageStudent; import javax.swing.*; import java.awt.*; import java.awt.event.ActionEvent; import java.awt.event.ActionListener; import java.sql.SQLException; /** * 系统主页面的操作 */ public class mySystemJFrame extends JFrame implements ActionListener { //显示如下功能菜单：输入数据、删除信息、修改信息、查询信息； private JComboBox insert,delete,update,search; private int section; //用于功能标识 private JTable jtable;//用于做查询结果的表格 private Font x = new Font("宋体",Font.BOLD,20); //文本字体 public mySystemJFrame(){ super("学生管理系统"); Dimension dim = getToolkit().getScreenSize(); // 获得屏幕分辨率 this.setBounds(dim.width/10,dim.height/10,dim.width *3/ 5, dim.height *3/ 5); // 窗口居中 this.setDefaultCloseOperation(EXIT_ON_CLOSE); ImageIcon background = new ImageIcon("ManageStudent\\images\\2.png"); JLabel label = new JLabel(background); label.setBounds(0, 0, this.getWidth(), this.getHeight()); JPanel imagePanel = (JPanel) this.getContentPane(); imagePanel.setOpaque(false); this.getLayeredPane().add(label, new Integer(Integer.MIN_VALUE)); JMenuBar menubar=new JMenuBar(); //菜单栏 this.setJMenuBar(menubar); //框架上添加菜单栏 String menustr[]={"输入数据","删除信息","修改信息","查询信息"}; JMenu menu[]=new JMenu[menustr.length]; for (int i=0;i<menustr.length;i++){ menu[i]=new JMenu(menustr[i]); //菜单 menubar.add(menu[i]); //菜单栏中加入菜单 } //输入菜单的添加 ImageIcon icon1=new ImageIcon("ManageStudent\\images\\btn1.png"); JMenuItem menuItem_insert1 = new JMenuItem("输入学生档案信息",icon1); menu[0].add(menuItem_insert1); //生成菜单项并加入到菜单 menu[0].addSeparator(); //添加分隔线 menuItem_insert1.addActionListener(this); JMenuItem menuItem_insert2 = new JMenuItem("输入课程信息",icon1); menu[0].add(menuItem_insert2); menu[0].addSeparator(); menuItem_insert2.addActionListener(this); JMenuItem menuItem_insert3 = new JMenuItem("输入学生修课信息",icon1); menu[0].add(menuItem_insert3); menu[0].addSeparator(); menuItem_insert3.addActionListener(this); //删除菜单的添加 ImageIcon icon2=new ImageIcon("ManageStudent\\images\\btn2.png"); JMenuItem menuItem_delete1 = new JMenuItem("删除学生档案信息",icon2); menu[1].add(menuItem_delete1); //生成菜单项并加入到菜单 menu[1].addSeparator(); //添加分隔线 menuItem_delete1.addActionListener(this); JMenuItem menuItem_delete2 = new JMenuItem("删除课程信息",icon2); menu[1].add(menuItem_delete2); menu[1].addSeparator(); menuItem_delete2.addActionListener(this); JMenuItem menuItem_delete3 = new JMenuItem("删除学生修课信息",icon2); menu[1].add(menuItem_delete3); menu[1].addSeparator(); menuItem_delete3.addActionListener(this); //修改菜单的添加 ImageIcon icon3=new ImageIcon("ManageStudent\\images\\btn3.png"); JMenuItem menuItem_update1 = new JMenuItem("修改学生档案信息",icon3); menu[2].add(menuItem_update1); //生成菜单项并加入到菜单 menu[2].addSeparator(); //添加分隔线 menuItem_update1.addActionListener(this); JMenuItem menuItem_update2 = new JMenuItem("修改课程信息",icon3); menu[2].add(menuItem_update2); menu[2].addSeparator(); menuItem_update2.addActionListener(this); JMenuItem menuItem_update3 = new JMenuItem("修改学生修课信息",icon3); menu[2].add(menuItem_update3); menu[2].addSeparator(); menuItem_update3.addActionListener(this); //查询菜单的添加 ImageIcon icon4=new ImageIcon("ManageStudent\\images\\btn4.png"); JMenuItem menuItem_search1 = new JMenuItem("查询学生档案信息",icon4); menu[3].add(menuItem_search1); //生成菜单项并加入到菜单 menu[3].addSeparator(); //添加分隔线 menuItem_search1.addActionListener(this); JMenuItem menuItem_search2 = new JMenuItem("查询课程信息",icon4); menu[3].add(menuItem_search2); menu[3].addSeparator(); menuItem_search2.addActionListener(this); JMenuItem menuItem_search3 = new JMenuItem("查询学生修课信息",icon4); menu[3].add(menuItem_search3); menu[3].addSeparator(); menuItem_search3.addActionListener(this); JMenuItem menuItem_search4 = new JMenuItem("查询指定学号的学生的全部信息",icon4); menu[3].add(menuItem_search4); menu[3].addSeparator(); menuItem_search4.addActionListener(this); JMenuItem menuItem_search5 = new JMenuItem("查询指定课程所修学生的全部信息",icon4); menu[3].add(menuItem_search5); menu[3].addSeparator(); menuItem_search5.addActionListener(this); this.setVisible(true); } @Override public void actionPerformed(ActionEvent e) { //添加操作 if(e.getActionCommand() == "输入学生档案信息"||e.getActionCommand() == "输入课程信息"||e.getActionCommand() == "输入学生修课信息"){ if(e.getActionCommand() == "输入学生档案信息"){ section = 1; }else if(e.getActionCommand() == "输入课程信息"){ section = 2; }else { section = 3; } String datas = JOptionPane.showInputDialog(this, "学生档案信息：Sno 学号 ,Sname 姓名,Ssex 性别 ,Sage 年龄,Sdept 所在系\n" +"课程信息：Cno 课程号，Cname 课程名，Cpno 先修课程号，Ccredit 学分\n" +"学生修课信息：Sno 学号,Cno 课程号,Grade 成绩,id 编号\n" + "请按上述顺序输入，用空格间隔\nO(∩_∩)O哈哈~"); dbFunction db = new dbFunction(); boolean flag = db.zhw(datas,section); if(flag&&datas!=null){ JOptionPane.showMessageDialog(this,"添加数据成功！"); }else{ JOptionPane.showMessageDialog(this,"添加数据失败！"); } } //删除操作 if(e.getActionCommand() == "删除学生档案信息"||e.getActionCommand() == "删除课程信息"||e.getActionCommand() == "删除学生修课信息"){ String message=""; if(e.getActionCommand() == "删除学生档案信息"){ section = 4; message = "删除学生档案信息:主键为Sno\n"; }else if(e.getActionCommand() == "删除课程信息"){ section = 5; message = "删除课程信息:主键为Cno\n"; }else { section = 6; message = "删除学生选课信息:主键为id\n"; } String datas = JOptionPane.showInputDialog(this,"请输入想删除的信息\n" +message+"\n(*^__^*) 嘻嘻…"); dbFunction db = new dbFunction(); boolean flag = db.zhw(datas,section); if(flag&&datas!=null){ JOptionPane.showMessageDialog(
100+评论
captcha
    相关资源
    类型标题大小时间
    ZIP简单的屏幕保护程序5.02KB12年前
    ZIPImageCache567.37KB12年前
    ZIPssm学生成绩管理系统源码+开题报告+文献综述+任务书.zip6.43MB3年前
    ZIP任务管理器 可以看映像路径的190.29KB16年前
    ZIP实战struts2用户登录6.17KB18年前
    ZIP人大金仓8.6.0、达梦8.1.2.79 连接驱动1.81MB2年前
    ZIPC#Windows 服务90.85KB17年前
    ZIPnetsvc46.69KB17年前