学生信息管理系统+SQL数据库.docx

1、学生信息管理系统+SQL数据库本人亲自做的，不需要做任何修改即可顺利运行， sql 表也与程序无缝连接，没有未识别部 分。Sql 表如下： CREATE TABLE STU( 学号 varchar(14) PRIMARY KEY, 姓名 varchar(8) NOT NULL, 密码 varchar(8) NOT NULL, 班级 varchar(14) NOT NULL , 性别 varchar(2), 学校 varchar(14) NOT NULL);CREATE TABLE TCH( 用户名 varchar(8) NOT NULL, 密码 varchar(8) NOT NULL );CR

2、EATE TABLE成绩表( 学号 varchar(14) PRIMARY KEY, 计算机网络 varchar(8) NOT NULL, 汽车概论 varchar(8) NOT NULL, 初级日语 varchar(8) NOT NULL, 接口技术 varchar(8) NOT NULL, ava 程序设计 varchar(8) NOT NULL, 数据库 varchar(8) NOT NULL, 大学物理 varchar(8) NOT NULL);源程序代码： import java.awt.*; import javax.swing.*; import java.awt.event.*

3、; import java.sql.*;public class systems extends JFrame implements ActionListener static systems ss;JPanel panel = new JPanel();JLabel label1 = new JLabel( 输入姓名： ); JTextField name = new JTextField();JLabel label2 = new JLabel( 密 码： );JPasswordField pwd = new JPasswordField(); JButton Enter = new JB

4、utton( 登录 ); JButton Exit = new JButton( 退出 );String url = D:Systemstitle.jpg; ButtonGroup bgp = new ButtonGroup();JRadioButton stu = new JRadioButton( 学生 );JRadioButton tch = new JRadioButton(教师 );public systems()super( 登录系统 ); this.setResizable(false);JLabel img = new JLabel(new ImageIcon(url); im

5、g.setBounds(0,0,500,100); panel.add(img);stu.setBounds(165,210,70,20);tch.setBounds(265,210,70,20); bgp.add(stu);bgp.add(tch);panel.add(stu);panel.add(tch);Enter.setBounds(150,250,80,20);Exit.setBounds(270,250,80,20);Enter.addActionListener(this);Exit.addActionListener(this); panel.add(Enter); panel

6、.add(Exit);panel.setLayout(null);this.add(panel); label1.setBounds(135,130,100,25);panel.add(label1);name.setBounds(265,130,100,25);panel.add(name); label2.setBounds(135,165,100,25);panel.add(label2);pwd.setBounds(265,165,100,25);panel.add(pwd); this.setBounds(100,100,500,350); this.setVisible(true)

7、;this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); public void actionPerformed(ActionEvent e)if(e.getSource()=Enter)String username , password;username = name.getText();password = pwd.getText();tryClass.forName(oracle.jdbc.driver.OracleDriver);catch (ClassNotFoundException ce)JOptionPane.showMess

8、ageDialog(ss,ce.getMessage(); if(stu.isSelected()tryConnection conDriverManager.getConnection(jdbc:oracle:thin:user29:1521:XE,hr,oracle); Statement stmt = con.createStatement();ResultSet rs = stmt.executeQuery(select * from STU); while(rs.next()if(rs.getString( 学).equals(username)&(rs.getString( 密码

9、).equals(password)JOptionPane.showMessageDialog(ss, 登陆成功 ); Students stu = new Students();elseJOptionPane.showMessageDialog(ss, 登录失败 );rs.close(); stmt.close();catch (SQLException se)JOptionPane.showMessageDialog(ss,se.getMessage();else if(tch.isSelected()tryConnection conDriverManager.getConnection

10、(jdbc:oracle:thin:user29:1521:XE,hr,oracle);Statement stmt = con.createStatement();ResultSet rs = stmt.executeQuery(select * from TCH);while(rs.next() if(rs.getString( 用 户 ).equals(username)&(rs.getString( 密码 ).equals(password)JOptionPane.showMessageDialog(ss, 登陆成功 );else JOptionPane.showMessageDial

11、og(ss, 登录失败 );catch (SQLException se) JOptionPane.showMessageDialog(ss,se.getMessage();else System.exit(0);public static void main(String args)systems sys = new systems();import java.awt.*;import javax.swing.*;import java.awt.event.*;public class Students extends JFrame implements ActionListener JMe

12、nuBar jmb = new JMenuBar();JMenu Message = new JMenu( 信息 );JMenu Score = new JMenu( 成绩 );JMenuItem Item1 = new JMenuItem( 插入 );JMenuItem Item2 = new JMenuItem( 查询 );JMenuItem Item3 = new JMenuItem( 查询 );public Students() super( 学生界面 ); this.setSize(500,400); this.setVisible(true); this.setResizable(

13、false); this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); this.setJMenuBar(jmb);jmb.add(Message); jmb.add(Score);Message.add(Item1);Message.add(Item2); Score.add(Item3);Item1.addActionListener(this);Item2.addActionListener(this);Item3.addActionListener(this);public void actionPerformed(ActionEven

14、t e) if(e.getSource()=Item1)AddMsg ad = new AddMsg();else if(e.getSource()=Item2)Serch ser = new Serch(); elsepublic static void main(String args)Students stu = new Students();import java.awt.*;import javax.swing.*;import java.awt.event.*; public class Teachers extends JFrame implements ActionListen

15、er JMenuBar bar = new JMenuBar();JMenu menu1 = new JMenu( 信息 );JMenu menu2 = new JMenu( 成绩 );JMenuItem item1 = new JMenuItem( 录入信息 );JMenuItem item2 = new JMenuItem( 录入成绩 ); JPanel jpl = new JPanel();public Teachers() super( 教师界面 ); this.setSize(500,300); this.setResizable(false); this.setVisible(true); this.setDefaultCloseOperation(JFr