学生成绩管理系统实验报告（内含JAVA程序，是连接数据库的，用的是JDBC技术）

import java.awt.*; import java.awt.event.*; import javax.swing.*; import java.sql.*; public class denglu extends JFrame { Container contentPane; JPanel paneTop = new JPanel(); JPanel paneMid = new JPanel(); JPanel paneBut = new JPanel(); JLabel Top = new JLabel(); JLabel Names = new JLabel(); JLabel Pwd = new JLabel(); JLabel Forget = new JLabel(); JLabel Model = new JLabel(); JLabel Null = new JLabel(); JTextField Namefield = new JTextField(15); JPasswordField Pwdfield = new JPasswordField(15); JComboBox cmb = new JComboBox(); JButton button2= new JButton("取消"); JButton button1 = new JButton("登录"); int ss; denglu(){ Names.setText("帐号:"); Pwd.setText("密码:"); Model.setText("用户选择:"); Null.setText(" "); String[] s1 = {"教师","学生"}; cmb.addItem(s1[0]); cmb.addItem(s1[1]); paneTop.add(Names); paneTop.add(Namefield); paneMid.add(Pwd); paneMid.add(Pwdfield); paneMid.add(Model); paneMid.add(cmb); paneBut.add(button1); paneBut.add(button2); contentPane = this.getContentPane(); contentPane.add(paneTop,BorderLayout.NORTH); contentPane.add(paneMid,BorderLayout.CENTER); contentPane.add(paneBut,BorderLayout.SOUTH); setTitle(""); setSize(260,170); //将窗口放置在中央 Dimension screen = Toolkit.getDefaultToolkit().getScreenSize(); setLocation((screen.width - getSize().width)/2,(screen.height - getSize().height)/2 ); setVisible(true); setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); button1.addActionListener(new ButtonHandle()); cmb.addActionListener(new GetSelected()); button2.addActionListener(new Exit()); } public class Exit implements ActionListener{ public void actionPerformed(ActionEvent e){ dispose(); } } public class GetSelected implements ActionListener{ public void actionPerformed(ActionEvent e){ ss=cmb.getSelectedIndex(); } } public class ButtonHandle implements ActionListener{ public void actionPerformed(ActionEvent e){ switch(ss){ case 0: teacher();break; case 1: student();break; } } public void teacher(){ String str1,str2; str1=Namefield.getText(); str2= new String(Pwdfield.getPassword()); try{ if(str1.equals("")||str2.equals("")){ JOptionPane.showMessageDialog(null,"请输入教师编号和密码"); return;} Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection conn = DriverManager.getConnection("jdbc:odbc:denglu"); PreparedStatement stmt = conn.prepareStatement("select * from user1 where username=? and passwords=?"); stmt.setString(1,str1); stmt.setString(2,str2); ResultSet rs =stmt.executeQuery(); if (rs.next()){ JOptionPane.showMessageDialog(null,"welcome to visit!!","welcome!!",JOptionPane.INFORMATION_MESSAGE); caidan o=new caidan(); o.go(); } else { JOptionPane.showMessageDialog(null,"not member,return!!","failture",JOptionPane.INFORMATION_MESSAGE); System.out.println("not member,return!!"); } }catch (ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } } public void student(){ String str1,str2; str1=Namefield.getText(); str2= new String(Pwdfield.getPassword()); try{ if(str1.equals("")||str2.equals("")){ JOptionPane.showMessageDialog(null,"请输入学生学号和密码"); return;} Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection conn = DriverManager.getConnection("jdbc:odbc:denglu"); PreparedStatement stmt = conn.prepareStatement("select * from user2 where username=? and passwords=?"); stmt.setString(1,str1); stmt.setString(2,str2); ResultSet rs =stmt.executeQuery(); if (rs.next()){ JOptionPane.showMessageDialog(null,"welcome to visit!!","welcome!!",JOptionPane.INFORMATION_MESSAGE); caidan1 o=new caidan1(); o.go(); } else { JOptionPane.showMessageDialog(null,"no nember,return!!","failture",JOptionPane.INFORMATION_MESSAGE); System.out.println("no member,return!!"); } }catch (ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } } } public static void main(String args[]){ new denglu(); } }