Java程序设计数据库综合应用学生教师信息管理系统041440516董迎顺

综合性设计性实验报告实验项目名称：＿数据库综合应用所属课程名称：＿＿Java程序设计学生姓名/学号：＿董迎顺学生所在班级：＿网络五班＿＿依托实验室：＿＿综C601＿实验学期：＿＿大二下学期＿计算机科学技术学院个人中心左侧显示个人信息,右侧显示成绩左下角点击修改个人简历右上角菜单可以注销登陆和修改登陆密码教师端登陆界面录入学生相关科目成绩五、总结：本次课程设计的题目是学生信息管理系统,经过几天的学习,巩固了之前学到的知识,并且体验了数据库系统开发的基本流程:从可行性分析开始,分析一个系统开发的技术可行性,经济可行性和操作可行性分析,接着分析系统需要具备怎样的功能,了解用户的具体需求，其次是概念结构设计，反应事物和实物之间的联系，满足用户对数据的处理要求，首先是逻辑结构设计,然后要确定数据库的物理结构。

通过一个或几个表建立相关的视图从而透过视图查看相应的数据。

通过做课设的整个流程，我的逻辑思维更加清晰了，在设计过程中，有很多地方做的不够好，比如界面设计的不够清晰整洁美观,使系统对数据的控制能力不够精细和强大，存在安全隐患，在以后的课程设计中，我会努力完善设计上的不足。

六、教师评语：实验成绩：教师：年月日源代码:admin包package admin;public class adminview extends JFrame implements ActionListener,MenuListener, TableModelListener, MouseListener{private static final long serialVersionUID = -46L;JPanel panel,panel1,panel2,panel3,panel4,panel5,panel6;JMenuBar menu;JMenu m1,m2,m3,m4,m5;JMenuItem item1, item2, item3, item4, item5, item6;JTextField text1,text2,text3,text4,text5,text6,text7;JButton button1,button2,button3,button4,button5,button6,button7;JTextField file1,file2,file3,file4,file5,file6,file7;JButton but1,but2,but3,but4,but5,but6,but7;JComboBox box;JScrollPane scoro;JTable table;ResultSet rs;JPopupMenu jmenu;DefaultTableModel model1,model2,model3;JTableHeader header;public adminview(String str){double width = Toolkit.getDefaultToolkit().getScreenSize().getWidth();double height= Toolkit.getDefaultToolkit().getScreenSize().getHeight();this.setBounds((int)(width*0.1),(int)(height*0.1), (int)(1366*0.8),(int)(800*0.8) );this.setVisible(true);this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);this.setResizable(false);this.setForeground(Color.black);this.setLayout(new BorderLayout());this.setIconImage(new ImageIcon("image\\denglu-image\\zhang.jpg") .getImage());// PopupMenu popupMenu1 = new PopupMenu();menu= new JMenuBar();m1=new JMenu ("菜单");m3=new JMenu ("帮助");menu.add(m1);//menu.add(m2);menu.add(m3);item1=new JMenuItem("查看所有课程");item1.setIcon(new ImageIcon("image\\admin-image\\m.png"));item2=new JMenuItem("查看所有教师");item2.setIcon(new ImageIcon("image\\admin-image\\m.png"));item3=new JMenuItem("查看所有学生");item3.setIcon(new ImageIcon("image\\admin-image\\m.png"));item4=new JMenuItem("修改密码");item4.setIcon(new ImageIcon("image\\admin-image\\key.png")); item5=new JMenuItem("退出");item5.setIcon(new ImageIcon("image\\admin-image\\delete.png"));item6 = new JMenuItem("打印");item6.setIcon(new ImageIcon("image\\admin-image\\print.png"));m1.add(item1);m1.add(item2);m1.add(item3);m1.add(item4);m1.add(item6);m1.add(item5);item1.addActionListener(this);item2.addActionListener(this);item3.addActionListener(this);item4.addActionListener(this);item5.addActionListener(this);item6.addActionListener(this);this.setJMenuBar(menu);//ImageIcon icon1 = new ImageIcon("image\\admin-image\\a-4.jpg"); panel=new BackgroundPanel(icon1.getImage());panel.setLayout(null);this.add(panel,BorderLayout.CENTER);panel1=new JPanel();panel1.setBounds(0, 0,500,282);panel1.setBorder(BorderFactory.createLineBorder(Color.white, 4));panel1.setBorder(BorderFactory.createTitledBorder("教师课程"));panel1.setOpaque(false);panel.add(panel1);//panel2=new JPanel();panel2.setOpaque(false);panel2.setBounds(0, 282,500,310);panel2.setBorder(BorderFactory.createLineBorder(Color.white, 4));panel2.setBorder(BorderFactory.createTitledBorder("学生模块"));panel.add(panel2);panel2.setOpaque(false);//panel1.add(new JLabel("课程号："));text1=new JTextField(20);text1.setOpaque(false);panel1.add(text1);panel1.add(new JLabel("课程名："));text2=new JTextField(20);text2.setOpaque(false);panel1.add(text2);button1=new JButton("增加课程");panel1.add(button1);panel1.add(new JLabel("课程号："));text3=new JTextField(20);text3.setOpaque(false);panel1.add(text3);panel1.add(new JLabel(" "));button2=new JButton("删除课程");panel1.add(button2);panel1.add(new JLabel("----------------------------------------------------------------------------------")); panel1.add(new JLabel("----------------------------------------------------------------------------------")); panel1.add(new JLabel("教师号："));text5=new JTextField(20);text5.setOpaque(false);panel1.add(text5);panel1.add(new JLabel("姓名："));text6=new JTextField(20);text6.setOpaque(false);panel1.add(text6);//panel1.add(new JLabel("课程号："));//text7=new JTextField(11);//panel1.add(text7);button3=new JButton("新增教师");panel1.add(button3);panel1.add(new JLabel("教师号："));text4=new JTextField(20);text4.setOpaque(false);panel1.add(text4);//panel1.add(new JLabel("----------------------------------------------------------------------------------")); panel1.add(new JLabel(" "));button4=new JButton("删除教师");panel1.add(button4);panel1.add(new JLabel("----------------------------------------------------------------------------------")); panel1.add(new JLabel("----------------------------------------------------------------------------------")); button5=new JButton("查看教师");panel1.add(button5);button6=new JButton("查看课程");panel1.add(button6);button7=new JButton("课程安排");panel1.add(button7);panel1.add(new JLabel("----------------------------------------------------------------------------------")); panel3=new JPanel();panel3.setOpaque(false);panel3.setPreferredSize(new Dimension(500,140));panel3.setBorder(BorderFactory.createLineBorder(Color.white, 2));panel3.setBorder(BorderFactory.createTitledBorder("录入模块"));panel2.add(panel3);panel3.add(new JLabel("学号："));file1=new JTextField(15);file1.setOpaque(false);panel3.add(file1);panel3.add(new JLabel("姓名："));file2=new JTextField(15);file2.setOpaque(false);panel3.add(file2);panel3.add(new JLabel("性别："));box=new JComboBox();box.addItem("男");box.addItem("女");// box.setOpaque(false);panel3.add(box);panel3.add(new JLabel("班级："));file3=new JTextField(10);file3.setOpaque(false);panel3.add(file3);panel3.add(new JLabel("籍贯："));file4=new JTextField(72);file4.setOpaque(false);panel3.add(file4);but1=new JButton("确认录入");panel3.add(but1);panel3.add(new JLabel("----------------------------------------------------------------------------------")); panel3.add(new JLabel("----------------------------------------------------------------------------------"));//panel4=new JPanel();panel4.setOpaque(false);panel2.add(panel4);panel4.setPreferredSize(new Dimension(500,210));panel4.setBorder(BorderFactory.createLineBorder(Color.white, 2));panel4.setBorder(BorderFactory.createTitledBorder("删除模块"));panel4.add(new JLabel("学号："));file5=new JTextField(15);file5.setOpaque(false);panel4.add(file5);panel4.add(new JLabel("==========================================")); but2=new JButton("确认删除");panel4.add(but2);panel4.add(new JLabel("----------------------------------------------------------------------------------")); panel4.add(new JLabel("----------------------------------------------------------------------------------")); but3=new JButton("查看所有学生信息");but4=new JButton("查看所有学生住宿");panel4.add(but3);panel4.add(but4);panel4.add(new JLabel("----------------------------------------------------------------------------------"));panel5 = new JPanel();panel5.setOpaque(false);// ((JXPanel) panel5).setAlpha(0.1F);panel5.setBounds(505, 9, 575, 581);panel5.setBorder(BorderFactory.createLineBorder(Color.white, 2));panel.add(panel5);//button1.addActionListener(this);//增加课程button1.setContentAreaFilled(false);button1.addMouseListener(this);button2.addActionListener(this);//删除课程button2.setContentAreaFilled(false);button2.addMouseListener(this);button3.addActionListener(this);//新增教师button3.setContentAreaFilled(false);button3.addMouseListener(this);button4.addActionListener(this);//删除教师button4.setContentAreaFilled(false);button4.addMouseListener(this);button5.addActionListener(this);//查看教师button5.setContentAreaFilled(false);button5.addMouseListener(this);button6.addActionListener(this);//查看课程button6.setContentAreaFilled(false);button6.addMouseListener(this);button7.addActionListener(this);//课程安排button7.setContentAreaFilled(false);button7.addMouseListener(this);but1.addActionListener(this);//确认录入but1.setContentAreaFilled(false);but1.addMouseListener(this);but2.addActionListener(this);//确认删除but2.setContentAreaFilled(false);but2.addMouseListener(this);but3.addActionListener(this);//查看所有学生信息but3.setContentAreaFilled(false);but3.addMouseListener(this);but4.addActionListener(this);//查看所有学生住宿but4.setContentAreaFilled(false);but4.addMouseListener(this);}@Overridepublic void actionPerformed(ActionEvent e){if(e.getSource()==button1) {int i=0; try{i=Integer.parseInt(text1.getText().trim());try{rs = dengluview.sql.executeQuery("select * from course where 课程号=" + i);if(rs.next()){JOptionPane.showMessageDialog( null ,"课程号已存在！！");}else{dengluview.sql.executeUpdate("insert into course(课程号,课程名) values( '"+ i+ "','"+ text2.getText().trim()+ "')");dengluview.sql.executeUpdate("alter table sc add "+ text2.getText().trim() + " int(3) "); JOptionPane.showMessageDialog( null ,"课程增加成功！"); button6.doClick();}}catch (SQLException e1) {JOptionPane.showMessageDialog( null ,"添加失败！");} }catch(NumberFormatException e1) {JOptionPane.showMessageDialog( null ,"教师号输入有误！");}}if(e.getSource()==button2) {int i=0;String str;try{ i=Integer.parseInt(text3.getText());try {rs = dengluview.sql.executeQuery("select * from course where 课程号=" + i);if(rs.next()){ str=rs.getString(2);dengluview.sql.executeUpdate("delete from course where 课程号="+ i);dengluview.sql.executeUpdate("ALTER TABLE sc DROP " + str);JOptionPane.showMessageDialog( null ,"删除成功！");button6.doClick();}else{JOptionPane.showMessageDialog( null ,"课程号不存在！");} } catch (SQLException e1) {JOptionPane.showMessageDialog( null ,"删除失败！");}}catch(NumberFormatException ea) {JOptionPane.showMessageDialog( null ,"课程号输入有误！");}}if(e.getSource()==button3) {int j=0;try{j=Integer.parseInt(text5.getText().trim());try {rs = dengluview.sql.executeQuery("select * from teacher where 教师号="+ j);if(rs.next()){JOptionPane.showMessageDialog( null ,"教师号已存在！！");}else{ dengluview.sql.executeUpdate("insert into teacher(教师号,姓名) values( '"+ j+ "','"+ text6.getText().trim()+ "')"); JOptionPane.showMessageDialog( null ,"教师增加成功！"); button5.doClick();} }catch(SQLException e1) {JOptionPane.showMessageDialog( null ,"异常！！");} }catch(NumberFormatException e1){JOptionPane.showMessageDialog( null ,"教师号输入有误！");} } if(e.getSource()==button4){int i=0;try{ i=Integer.parseInt(text4.getText());try { rs = dengluview.sql.executeQuery("select * from teacher where 教师号="+ i);if(rs.next()){dengluview.sql.executeUpdate("delete from teacher where 教师号="+ i);JOptionPane.showMessageDialog( null ,"删除成功！");button5.doClick();}else{JOptionPane.showMessageDialog( null ,"教师号不存在！");} } catch (SQLException e1) {JOptionPane.showMessageDialog( null ,"删除失败！"); }}catch(NumberFormatException ea) {JOptionPane.showMessageDialog( null ,"教师号输入有误！"); }} if(e.getSource()==button5){panel5.removeAll();String str="select 教师号,姓名from teacher";Object a[]={"教师号","姓名"};table = new JTable(functionview.getrecord(str), a);table.setRowHeight(25);table.setOpaque(false);scoro = new JScrollPane(table);scoro.setPreferredSize(new Dimension(555, 580));scoro.setColumnHeaderView(table.getTableHeader());scoro.setOpaque(false);scoro.getViewport().setOpaque(false);scoro.getColumnHeader().setOpaque(false);DefaultTableCellRenderer render = new DefaultTableCellRenderer();render.setOpaque(false);table.setDefaultRenderer(Object.class, render);table.setGridColor(Color.white);JTableHeader header = table.getTableHeader();header.setPreferredSize(new Dimension(30, 26));header.setOpaque(false);header.getTable().setOpaque(false);header.setDefaultRenderer(new HeaderCellRenderer());TableCellRenderer headerRenderer = header.getDefaultRenderer();if (headerRenderer instanceof JLabel) {((JLabel) headerRenderer).setHorizontalAlignment(SwingConstants.CENTER);((JLabel) headerRenderer).setOpaque(false);}//panel5.add(scoro);panel5.validate();}if(e.getSource()==button6){panel5.removeAll();String str="select * from course";model3=newMyModel(functionview.getrecord(str),functionview.gengxing("course"));model3.addTableModelListener(this);table = new JTable(model3);table.setCellSelectionEnabled(true);table.setSurrendersFocusOnKeystroke(true);table.setRowHeight(25);table.setOpaque(false);scoro = new JScrollPane(table);scoro.setPreferredSize(new Dimension(555, 580));scoro.setColumnHeaderView(table.getTableHeader());scoro.setOpaque(false);scoro.getViewport().setOpaque(false);scoro.getColumnHeader().setOpaque(false);DefaultTableCellRenderer render = new DefaultTableCellRenderer();render.setOpaque(false);table.setDefaultRenderer(Object.class, render);table.setGridColor(Color.white);JTableHeader header = table.getTableHeader();header.setPreferredSize(new Dimension(30, 26));header.setOpaque(false);header.getTable().setOpaque(false);header.setDefaultRenderer(new HeaderCellRenderer());TableCellRenderer headerRenderer = header.getDefaultRenderer();if (headerRenderer instanceof JLabel) {((JLabel) headerRenderer).setHorizontalAlignment(SwingConstants.CENTER);((JLabel) headerRenderer).setOpaque(false);}panel5.add(scoro);panel5.validate();}if(e.getSource()==button7) {panel5.removeAll();String str="select course.教师号,姓名,课程名from course,teacher where course.教师号=teacher.教师号";Object a[]={"教师号","姓名","课程名"};table = new JTable(functionview.getrecord(str), a);table.setRowHeight(25);table.setOpaque(false);scoro = new JScrollPane(table);scoro.setPreferredSize(new Dimension(555, 580));scoro.setColumnHeaderView(table.getTableHeader());scoro.setOpaque(false);scoro.getViewport().setOpaque(false);scoro.getColumnHeader().setOpaque(false);DefaultTableCellRenderer render = new DefaultTableCellRenderer();render.setOpaque(false);table.setDefaultRenderer(Object.class, render);table.setGridColor(Color.white);JTableHeader header = table.getTableHeader();header.setPreferredSize(new Dimension(30, 26));header.setOpaque(false);header.getTable().setOpaque(false);header.setDefaultRenderer(new HeaderCellRenderer());TableCellRenderer headerRenderer = header.getDefaultRenderer();if (headerRenderer instanceof JLabel) {((JLabel) headerRenderer).setHorizontalAlignment(SwingConstants.CENTER);((JLabel) headerRenderer).setOpaque(false);}panel5.add(scoro);panel5.validate();}if(e.getSource()==but1){String str=file1.getText().trim();try{double a=Double.valueOf(str);if(str.length()==12){try {rs = dengluview.sql.executeQuery("select 学号from student where 学号="+ a);if(rs.next()){JOptionPane.showMessageDialog( null ,"该学号已存在！！");}else{String st1=file2.getText();String st2=(String) box.getSelectedItem();String st3=file3.getText();String st4=file4.getText();System.out.print("insert into student (学号, 姓名, 性别, 班级, 籍贯) values ('"+str+"','"+st1+"','"+st2+"','"+st3+"','"+st4+"');");dengluview.sql.executeUpdate("insert into student (学号, 姓名, 性别, 班级, 籍贯) values ('"+ str+ "','"+ st1+ "','"+ st2+ "','" + st3 + "','" + st4 + "')");JOptionPane.showMessageDialog( null ,"增加成功！！");but3.doClick();}}catch (SQLException e1){JOptionPane.showMessageDialog( null ,"插入异常！！");}}else{JOptionPane.showMessageDialog( null ,"学号为12位长数字");}}catch(NumberFormatException es){JOptionPane.showMessageDialog( null ,"学号输入有误！");} }if(e.getSource()==but2) {String str=file5.getText().trim();try{double a=Double.valueOf(str);if(str.length()==12){try{rs = dengluview.sql.executeQuery("select 学号from student where 学号="+ a);if(rs.next()){ dengluview.sql.executeUpdate("delete from student where 学号="+ str);JOptionPane.showMessageDialog( null ,"删除成功！！");but3.doClick();}else{JOptionPane.showMessageDialog( null ,"该学号不存在！！");}}catch(SQLException e1){} }else{JOptionPane.showMessageDialog( null ,"学号位数不够！");}}catch(NumberFormatException es){ JOptionPane.showMessageDialog( null ,"学号输入有误！");}}if(e.getSource()==but3) {panel5.removeAll();String str="select * from student";model1=newMyModel(functionview.getrecord(str),functionview.gengxing("student"));model1.addTableModelListener(this);table = new JTable(model1);table.setCellSelectionEnabled(true);table.setSurrendersFocusOnKeystroke(true);table.setRowHeight(25);table.setAutoResizeMode(javax.swing.JTable.AUTO_RESIZE_OFF);table.setOpaque(false);scoro = new JScrollPane(table,ScrollPaneConstants.VERTICAL_SCROLLBAR_ALWAYS,ScrollPaneConstants.HORIZONTAL_SCROLLBAR_ALWAYS);scoro.setPreferredSize(new Dimension(555, 572));scoro.setColumnHeaderView(table.getTableHeader());scoro.setOpaque(false);scoro.getViewport().setOpaque(false);scoro.getColumnHeader().setOpaque(false);scoro.getHorizontalScrollBar().addMouseListener(this);DefaultTableCellRenderer render = new DefaultTableCellRenderer();render.setOpaque(false);table.setDefaultRenderer(Object.class, render);table.setGridColor(Color.white);JTableHeader header = table.getTableHeader();header.setPreferredSize(new Dimension(30, 26));header.setOpaque(false);header.getTable().setOpaque(false);header.setDefaultRenderer(new HeaderCellRenderer());TableCellRenderer headerRenderer = header.getDefaultRenderer();if (headerRenderer instanceof JLabel) {((JLabel) headerRenderer).setHorizontalAlignment(SwingConstants.CENTER);((JLabel) headerRenderer).setOpaque(false);}panel5.add(scoro);panel5.validate();}if(e.getSource()==but4) {panel5.removeAll();String str="select * from zhusu";model2=newMyModel(functionview.getrecord(str),functionview.gengxing("zhusu"));model2.addTableModelListener(this);table = new JTable(model2);table.setCellSelectionEnabled(true);table.setSurrendersFocusOnKeystroke(true);table.setRowHeight(25);table.setOpaque(false);scoro = new JScrollPane(table);scoro.setPreferredSize(new Dimension(555, 572));scoro.setColumnHeaderView(table.getTableHeader());scoro.setOpaque(false);scoro.getViewport().setOpaque(false);scoro.getColumnHeader().setOpaque(false);DefaultTableCellRenderer render = new DefaultTableCellRenderer();render.setOpaque(false);table.setDefaultRenderer(Object.class, render);table.setGridColor(Color.white);header = table.getTableHeader();header.setPreferredSize(new Dimension(30, 26));header.setOpaque(false);header.getTable().setOpaque(false);header.setDefaultRenderer(new HeaderCellRenderer());TableCellRenderer headerRenderer = header.getDefaultRenderer();if (headerRenderer instanceof JLabel) {((JLabel) headerRenderer).setHorizontalAlignment(SwingConstants.CENTER);((JLabel) headerRenderer).setOpaque(false);}panel5.add(scoro);panel5.validate();}if(e.getSource()==item1){ button6.doClick();}if(e.getSource()==item2){button5.doClick();}if(e.getSource()==item3){but3.doClick();}if(e.getSource()==item4){}if(e.getSource()==item5){System.exit(0); }if (e.getSource() == item6) {try {table.print();} catch (PrinterException e1) {// TODO Auto-generated catch blockJOptionPane.showMessageDialog(null, "初始化失败！");}} }@Overridepublic void menuCanceled(MenuEvent e){ }@Overridepublic void menuDeselected(MenuEvent arg0) {}@Overridepublic void menuSelected(MenuEvent arg0) {}@Overridepublic void tableChanged(TableModelEvent e){int rr,cc;String vv ,v1,v2;if(e.getSource()==model1) {rr = table.getSelectedRow(); // 取表格tab中的当前行号cc = table.getSelectedColumn(); // 取表格tab中的当前列号vv = ((String) table.getValueAt(rr, cc)).trim(); // 取表格tab中的第rr行、cc列的单元格的数据值System.out.println("当前行是"+rr+"当前列是"+cc+"数据值是"+vv);try{ rs = dengluview.sql.executeQuery("select * from student ");rs.absolute(rr+1);v1=rs.getString(1);v2=(String)functionview.gengxing("student")[cc];dengluview.sql.execute("update student set " + v2 + "='" + vv+ "' where 学号=" + v1);}catch (SQLException e1){JOptionPane.showMessageDialog( null ,"更新异常！");}}if(e.getSource()==model2) {rr = table.getSelectedRow(); // 取表格tab中的当前行号cc = table.getSelectedColumn(); // 取表格tab中的当前列号vv = ((String) table.getValueAt(rr, cc)).trim();// 取表格tab中的第rr行、cc列的单元格的数据值//System.out.println("当前行是"+rr+"当前列是"+cc+"数据值是"+vv);try{ rs = dengluview.sql.executeQuery("select * from zhusu ");rs.absolute(rr+1);v1=rs.getString(1);v2=(String)functionview.gengxing("zhusu")[cc];dengluview.sql.execute("update zhusu set " + v2 + "='" + vv+ "' where 学号=" + v1);}catch (SQLException e1) {JOptionPane.showMessageDialog( null ,"更新异常！"); }}if(e.getSource()==model3){rr = table.getSelectedRow(); // 取表格tab中的当前行号cc = table.getSelectedColumn(); // 取表格tab中的当前列号vv = ((String) table.getValueAt(rr, cc)).trim(); // 取表格tab中的第rr行、cc列的单元格的数据值try {rs = dengluview.sql.executeQuery("select * from course ");rs.absolute(rr+1);v1=rs.getString(1);//v2=(String)function.gengxing("course")[cc];dengluview.sql.execute("update course set 教师号=" + vv+ " where 课程号=" + v1);}catch (SQLException e1){JOptionPane.showMessageDialog( null ,"更新异常！");}}table.repaint();}@Overridepublic void mouseClicked(MouseEvent e) {}@Overridepublic void mouseEntered(MouseEvent e){if (e.getSource() == button1) {button1.setContentAreaFilled(true);}if (e.getSource() == button2) {button2.setContentAreaFilled(true);}if (e.getSource() == button3) {wbutton3.setContentAreaFilled(true);}if (e.getSource() == button4) {button4.setContentAreaFilled(true);}if (e.getSource() == button5) {button5.setContentAreaFilled(true);}if (e.getSource() == button6) {button6.setContentAreaFilled(true);}if (e.getSource() == button7) {button7.setContentAreaFilled(true);}if (e.getSource() == but1) {but1.setContentAreaFilled(true);}if (e.getSource() == but2) {but2.setContentAreaFilled(true);}if (e.getSource() == but3) {but3.setContentAreaFilled(true);}if (e.getSource() == but4) {but4.setContentAreaFilled(true);}}@Overridepublic void mouseExited(MouseEvent e) {if (e.getSource() == button1) {button1.setContentAreaFilled(false);}if (e.getSource() == button2) {button2.setContentAreaFilled(false);}if (e.getSource() == button3) {button3.setContentAreaFilled(false);}if (e.getSource() == button4) {button4.setContentAreaFilled(false);}if (e.getSource() == button5) {button5.setContentAreaFilled(false);}if (e.getSource() == button6) {button6.setContentAreaFilled(false);}if (e.getSource() == button7) {button7.setContentAreaFilled(false);}if (e.getSource() == but1) {but1.setContentAreaFilled(false);}if (e.getSource() == but2) {but2.setContentAreaFilled(false);}if (e.getSource() == but3) {but3.setContentAreaFilled(false);}if (e.getSource() == but4) {but4.setContentAreaFilled(false);}}@Overridepublic void mousePressed(MouseEvent e) {// TODO Auto-generated method stubif (e.getSource() == scoro.getHorizontalScrollBar()) { this.validate();}}w@Overridepublic void mouseReleased(MouseEvent e) {// TODO Auto-generated method stubif (e.getSource() == scoro.getHorizontalScrollBar()) {this.validate();}}}class MyModel extends DefaultTableModel {private static final long serialVersionUID = 67L;public MyModel(Object[][] rowData, Object[] columns){ super(rowData, columns); }@Overridepublic boolean isCellEditable(int row, int col){if (col == 0||col==1) {return false;}else{return true;} }}denglu包public class dengluview {static JFrame frame;static Connection con;// ..........................public static Statement sql;// 连接数据库static ResultSet rs1;static String str;static JPanel beijing;static JPanel jpanel1, jpanel2, jpanel3, jpanel4;static JLabel label1, guanbi, zuixiaohua;;static JLabel label2;static JButton button1;static JButton button2;static JTextField field1;static JPasswordField passwordText;static JComboBox box;public static void main(String[] args) {try {javax.swing.UIManager.setLookAndFeel(".sun.java.swing.plaf.windows.WindowsLookAndFeel");} catch (Exception e) {e.printStackTrace();}shijian listener = new shijian();wframe = new JFrame();// 登陆窗体frame.setUndecorated(true);// 去掉默认边框frame.setLayout(new BorderLayout());frame.setSize(600, 300);frame.setVisible(true);frame.setResizable(false);// 禁止最大化frame.addMouseListener(listener);frame.addMouseMotionListener(listener);frame.setIconImage(newImageIcon("image\\denglu-image\\zhang.jpg").getImage());double width = Toolkit.getDefaultToolkit().getScreenSize().getWidth();double height = Toolkit.getDefaultToolkit().getScreenSize().getHeight();frame.setLocation((int) (width - frame.getWidth()) / 2,(int) (height - frame.getHeight()) / 2);// 屏幕剧中beijing = new BackgroundPanel(new ImageIcon("image\\denglu-image\\c.gif").getImage());beijing.setOpaque(false);beijing.setLayout(null);beijing.setBorder(BorderFactory.createLineBorder(Color.white, 2));beijing.setBorder(BorderFactory.createTitledBorder("计算机科学技术学院"));guanbi = new JLabel(" X");zuixiaohua = new JLabel("一");zuixiaohua.setBounds(600 - 40, 0, 20, 20);zuixiaohua.setForeground(Color.white);zuixiaohua.addMouseListener(listener);guanbi.setBounds(600 - 20, 0, 20, 20);guanbi.setForeground(Color.white);guanbi.addMouseListener(listener);beijing.add(zuixiaohua);beijing.add(guanbi);w。