java学生信息管理系统25372

《java学生信息管理系统25372》由会员分享，可在线阅读，更多相关《java学生信息管理系统25372（12页珍藏版）》请在装配图网上搜索。

1、1.登录界面和主界面import javax.swing.*;import javax.swing.table.DefaultTableModel;import java.awt.*;import java.awt.event.*;import java.sql.*;class myConnectionResultSet re;public myConnection() class stuMainFrame extends JFrame implements ActionListenerJMenuBar jmb = new JMenuBar();JMenu Message = new JMen

2、u(信息);JMenu Score = new JMenu(查询);JMenuItem Item1 = new JMenuItem(添加学生信息);JMenuItem mName=new JMenuItem(学生成绩查询);JMenuItem mScore=new JMenuItem(按成绩查询);JMenuItem mNam1=new JMenuItem(查询学生信息);JLabel label = new JLabel();public stuMainFrame()ImageIcon icon = new ImageIcon(src/images/1.jpg); label.setIcon

3、(icon); label.setBounds(0, 0, icon.getIconWidth(), icon.getIconHeight(); add(label); setSize(label.getWidth(),label.getHeight();this.setJMenuBar(jmb);jmb.add(Message);jmb.add(Score);Message.add(Item1);Score.add(mNam1);Score.add(mName);Score.add(mScore);Item1.addActionListener(this);mName.addActionLi

4、stener(this);mScore.addActionListener(this);mNam1.addActionListener(this); public void actionPerformed(ActionEvent e)if(e.getSource()=Item1) new addForm().setVisible(true);else if(e.getSource()=mName) dispose();new Score1().setVisible(true);else if(e.getSource()=mScore)new scoreQueryForm().setVisibl

5、e(true);else if(e.getSource()=mNam1)dispose(); new Serch1().setVisible(true); class mainFrame extends JFrame implements ActionListener JLabel label = new JLabel(); JMenuBar mBar= new JMenuBar(); JPanel p=new JPanel(); private JMenu mSystem,mOperate,mQuery,mHelp,myMenuUser; private JMenuItem mFile,mN

6、ew,mOpen,mExit,mAdd,mDel,mModify,mName,miShow,mScore,mAbout,miUser,mAddSc; public mainFrame() this.setJMenuBar(mBar); ImageIcon icon = new ImageIcon(src/images/1.jpg); label.setIcon(icon); label.setBounds(0, 0, icon.getIconWidth(), icon.getIconHeight(); add(label); setSize(label.getWidth(),label.get

7、Height(); myMenuUser=new JMenu(用户);miUser=new JMenuItem(编辑用户);myMenuUser.add(miUser); mSystem=new JMenu(系统); mOperate=new JMenu(数据操作); mQuery=new JMenu(查询); mHelp=new JMenu(帮助); mBar.add(mSystem); mBar.add(mOperate); mBar.add(mQuery); mBar.add(mHelp); mBar.add(myMenuUser); mFile=new JMenuItem(文件); m

8、New=new JMenuItem(新建); mOpen=new JMenuItem(打开); mExit=new JMenuItem(退出); mSystem.add(mFile); mSystem.add(mNew); mSystem.add(mOpen); mSystem.addSeparator(); mSystem.add(mExit); mAdd=new JMenuItem(添加基本信息); mAddSc=new JMenuItem(添加成绩信息); mName=new JMenuItem(查询学生信息); mScore=new JMenuItem(查询学生成绩); miShow=

9、new JMenuItem(全部显示); mQuery.add(mName); mQuery.add(mScore); mQuery.addSeparator(); mQuery.add(miShow); public void actionPerformed(ActionEvent e) if (e.getSource()=jB2)System.exit(0);else if (e.getSource()=jB1)String username , password;username = t2.getText(); password = t4.getText();if(b1.isSelect

10、ed() if (username.toString().equals()JOptionPane.showMessageDialog(null, 请输入用户名, 温馨提示, JOptionPane.INFORMATION_MESSAGE); else if (password.toString().equals()JOptionPane.showMessageDialog(null, 请输入密码, 温馨提示, JOptionPane.INFORMATION_MESSAGE);elsemyConnection conn=new myConnection();ResultSet rs;String

11、 sql=select * from 学生信息表 where 学号=+t2.getText().toString()+ and 登录密码 = +t4.getText().toString()+; try rs=conn.getResult(sql); rs.last(); if(rs.getRow()=1) setVisible(false); rs.beforeFirst(); while(rs.next() this.dispose(); sql=select * from 学籍信息表; stuMainFrame smf =new stuMainFrame(); smf.setSize(5

12、00,400); smf.setVisible(true); smf.setResizable(false); smf.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); smf.addWindowListener(new WindowAdapter() public void windowClosing(WindowEvent e) System.exit(0); ); JOptionPane.showMessageDialog( null ,rs.getString(学生姓名)+同学！您好！欢迎登录学生成绩管理系统！ ) ; elseJOptio

13、nPane.showMessageDialog(null, 用户名或密码错误, 登录失败, JOptionPane.INFORMATION_MESSAGE); catch(Exception er)System.out.println(er.toString(); 2.添加学生基本信息import javax.swing.*;import javax.swing.table.DefaultTableModel;import java.awt.*;import java.awt.event.*;import java.sql.*;public class addForm extends JFra

14、me implements ActionListener JLabel label1 = new JLabel(添加基本信息,JLabel.CENTER);JLabel labxuehao=new JLabel(学号：,JLabel.CENTER);JLabel labName=new JLabel(姓名：,JLabel.CENTER); JLabel labclass=new JLabel(班级：,JLabel.CENTER);JLabel labzy=new JLabel(专业：,JLabel.CENTER);JLabel labsex = new JLabel(性别：,JLabel.CE

15、NTER); JLabel labsex = new JLabel(联系方式：,JLabel.CENTER);JTextField txtName=new JTextField(20); JTextField txtXueHao=new JTextField(20); JTextField txtClass=new JTextField(20); JTextField txtZY=new JTextField(20); JTextField txtMZ=new JTextField(20); ButtonGroup bgp = new ButtonGroup();JRadioButton ma

16、n = new JRadioButton(男);JRadioButton women = new JRadioButton(女); JButton btnAdd=new JButton(添加); JButton btnCancel=new JButton(返回); JButton btnReset = new JButton(重置);JPanel jpl=new JPanel(); Connection con; Statement sql; ResultSet rs; addForm() super(添加学生信息);this.setResizable(false);this.setSize(

17、550,450);this.setVisible(true);this.setLocation(300,300);this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);jpl.add(label1);labxuehao.setBounds(100,50,70,20);jpl.add(labxuehao);txtXueHao.setBounds(190,50,140,20);jpl.add(txtXueHao);labName.setBounds(100,90,70,20);jpl.add(labName);txtName.setBounds(1

18、90,90,140,20);jpl.add(txtName);labsex.setBounds(110,130,60,20);jpl.add(labsex);man.setBounds(190,130,60,20);women.setBounds(270,130,60,20);jpl.add(labclass);txtClass.setBounds(190,270,140,20);jpl.add(txtClass);labzy.setBounds(100,300,70,20);jpl.add(btnReset);jpl.add(btnAdd);jpl.add(btnCancel); publi

19、c void actionPerformed(ActionEvent e) if(e.getSource()=btnCancel) dispose(); new mainFrame().setVisible(true);if(e.getSource()=btnAdd)if (txtXueHao.getText().toString().equals()JOptionPane.showMessageDialog(null, 请输入学号);else if (txtName.getText().toString().equals()JOptionPane.showMessageDialog(null

20、, 请输入姓名);else if (txtlxfs.getText().toString().equals()JOptionPane.showMessageDialog(null, 请输入联系方式);else if (txtClass.getText().toString().equals()JOptionPane.showMessageDialog(null, 请输入班级);elseString sex;if(man.isSelected() sex=男;else sex=女; public static void main(String args)addForm amg = new add

21、Form();3.添加学生成绩import java.awt.*;import javax.swing.*;import java.awt.event.*;import java.sql.*;public class addScore extends JFrame implements ActionListenerstatic addScore ss;JLabel label = new JLabel(学号：) , new JLabel(大学英语：) , new JLabel(计算机信息技术基础：) , new JLabel(Java程序设计：) , new JLabel(高等数学：) ; J

22、TextField txt = new JTextField() , new JTextField() , new JTextField() , new JTextField() , new JTextField();JButton add = new JButton(添加);JButton reset = new JButton(重置);JButton Cancel=new JButton(返回);JPanel jpl = new JPanel();JLabel title = new JLabel(添加学生成绩);public addScore()super(添加学生信息);this.se

23、tResizable(false);this.setSize(500,600);this.setDefaultCloseOperation(EXIT_ON_CLOSE);this.setVisible(true);this.add(jpl);Cancel.addActionListener(this);add.addActionListener(this);reset.addActionListener(this);jpl.setLayout(null);title.setBounds(150,40,200,20);title.setFont(f);title.setForeground(Co

24、lor.red);jpl.setBackground(Color.LIGHT_GRAY);jpl.add(title);for(int i = 0 ; i label.length ; i+)labeli.setBounds(100,s,140,20);jpl.add(labeli);txti.setBounds(260,s,140,20);jpl.add(txti);s=s+40;add.setBounds(100,s,80,20);reset.setBounds(200,s,80,20);Cancel.setBounds(300,s,80,20);jpl.add(add);jpl.add(

25、reset);jpl.add(Cancel);public void actionPerformed(ActionEvent e)if(e.getSource()=Cancel) dispose(); new mainFrame().setVisible(true); else if(e.getSource()=add)tryConnection con = DriverManager.getConnection(jdbc:odbc:学生成绩管理系统,ww,123);Statement stmt = con.createStatement();int a = stmt.executeUpdat

26、e(insert into 成绩信息表(学号 , 大学英语 , 计算机信息技术基础 , Java程序设计 , 高等数学 , Xml)values(+txt0.getText()+,+txt1.getText()+,+txt2.getText()+,+txt3.getText()+,+txt4.getText()+);if(a=1)JOptionPane.showMessageDialog(ss,添加成功);elseJOptionPane.showMessageDialog(ss,添加失败);catch (SQLException se)JOptionPane.showMessageDialog

27、(ss,se.getMessage();elsefor(int i = 0 ; itxt.length ; i+)txti.setText();txt0.requestFocus();public static void main(String args)addScore as = new addScore();4.学生信息查询与成绩查询import java.awt.*;import javax.swing.*;import java.awt.event.*;import java.awt.font.*;import java.sql.*;public class Score extends

28、 JFrame implements ActionListener static Score s;JLabel title = new JLabel(查询成绩);JPanel jpl = new JPanel();JLabel label1 = new JLabel(请输入学号：);JTextField num = new JTextField();JButton serch = new JButton(查询成绩);JButton reset = new JButton(重置);JLabel label2 = new JLabel(计算机应用基础：);JLabel label3 = new J

29、Label(大学英语：);JLabel label4 = new JLabel(Java程序设计：);JLabel label5 = new JLabel(高等数学：);JTextField txt = new JTextField() , new JTextField() , new JTextField() , new JTextField() ;static int p = 140;public Score() super(查询分数);this.setResizable(false);this.setSize(500,550);this.setVisible(true);this.add

30、(jpl);jpl.add(num);serch.setBounds(100,100,90,20);reset.setBounds(200,100,90,20);Cancel.setBounds(300,100,90,20);jpl.add(serch);jpl.add(reset);jpl.add(Cancel);serch.addActionListener(this);reset.addActionListener(this);Cancel.addActionListener(this);label2.setBounds(100,140,140,20);label3.setBounds(

31、100,180,140,20);label4.setBounds(100,220,140,20);label5.setBounds(100,260,140,20);jpl.add(label2);jpl.add(label3);jpl.add(label4);jpl.add(label5);for(int i = 0 ;itxt.length ; i+)txti.setBounds(260,p,140,20);jpl.add(txti);p=p+40;public void actionPerformed(ActionEvent e)if(e.getSource()=Cancel) dispo

32、se(); new mainFrame().setVisible(true); if(e.getSource()=serch)String id = num.getText();tryClass.forName(sun.jdbc.odbc.JdbcOdbcDriver); catch (ClassNotFoundException ce) JOptionPane.showMessageDialog(s,ce.getMessage();tryConnection con = DriverManager.getConnection(jdbc:odbc:学生成绩管理系统,ww,123);Statem

33、ent stmt = con.createStatement();ResultSet rs = stmt.executeQuery(select * from 成绩信息表 where 学号 = + id + );while(rs.next()for(int i = 0 ; itxt.length ; i+)txti.setText(rs.getString(i+2);catch (SQLException se)JOptionPane.showMessageDialog(s,se.getMessage();elsefor(int i = 0;itxt.length ; i+)txti.setT

34、ext();num.setText();public static void main(String args)Score s = new Score();import java.awt.*;import javax.swing.*;import java.awt.event.*;import java.sql.*;public class Serch extends JFrame implements ActionListenerstatic Serch s;JPanel jpl = new JPanel();JLabel SCH = new JLabel(查询学生信息,JLabel.CEN

35、TER);JLabel label1 = new JLabel(请输入学号：,JLabel.CENTER);JButton serch = new JButton(查询);JLabel label2 = new JLabel(姓名：,JLabel.CENTER);JLabel labyear=new JLabel(年龄：,JLabel.CENTER);JLabel labDate=new JLabel(出生日期：,JLabel.CENTER);JLabel label5 = new JLabel(性别：,JLabel.CENTER);JLabel label3 = new JLabel(班级：

36、,JLabel.CENTER);JLabel label4 = new JLabel(专业：,JLabel.CENTER); JLabel labmz=new JLabel(民族：,JLabel.CENTER);ButtonGroup bgp = new ButtonGroup();JRadioButton man = new JRadioButton(男);JRadioButton women = new JRadioButton(女);JTextField tyear = new JTextField();JTextField tDate = new JTextField();JTextF

37、ield tmz = new JTextField();JTextField num = new JTextField();JTextField nam = new JTextField();JTextField clas = new JTextField();JTextField scl = new JTextField();JButton reset = new JButton(重置);JButton caln = new JButton(取消);public Serch() this.setSize(560,460);this.setVisible(true);this.setResiz

38、able(false);this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);this.add(jpl);jpl.setBackground(Color.cyan);man.setBackground(Color.cyan);women.setBackground(Color.cyan);jpl.setLayout(null);serch.addActionListener(this);reset.addActionListener(this);caln.addActionListener(this);SCH.setBounds(100,20,

39、300,20);jpl.add(SCH);label1.setBounds(100,60,100,20);jpl.add(label1);num.setBounds(220,60,140,20);jpl.add(num);serch.setBounds(120,100,90,20);reset.setBounds(230,100,90,20);caln.setBounds(340,100,90,20);jpl.add(serch);jpl.add(reset);jpl.add(caln);label2.setBounds(100,150,70,20);jpl.add(label2);nam.s

40、etBounds(190,150,140,20);jpl.add(nam);labyear.setBounds(100,180,70,20);jpl.add(labyear);tyear.setBounds(190,180,140,20);jpl.add(tyear);labDate.setBounds(100,210,70,20);jpl.add(labDate);tDate.setBounds(190,210,140,20);jpl.add(tDate);label5.setBounds(100,250,70,20);jpl.add(label5);man.setBounds(205,25

41、0,60,20);women.setBounds(285,250,60,20);bgp.add(man);bgp.add(women);jpl.add(man);jpl.add(women);label3.setBounds(100,290,70,20);jpl.add(label3);clas.setBounds(190,290,140,20);jpl.add(clas);label4.setBounds(100,320,70,20);jpl.add(label4);scl.setBounds(190,320,140,20);jpl.add(scl);labmz.setBounds(100,

42、350,70,20);jpl.add(labmz);tmz.setBounds(190,350,140,20);jpl.add(tmz);public void actionPerformed(ActionEvent e)if(e.getSource()=caln)dispose(); new mainFrame().setVisible(true);else if(e.getSource()= serch) tryClass.forName(sun.jdbc.odbc.JdbcOdbcDriver); catch(ClassNotFoundException se) tryConnectio

43、n con=DriverManager.getConnection(jdbc:odbc:学生成绩管理系统,ww,123); Statement stmt=con.createStatement(); ResultSet rs = stmt.executeQuery(select * from 学籍信息表 where 学号=+num.getText()+); if(rs.next()num.setText(rs.getString(学号);nam.setText(rs.getString(姓名);tyear.setText(rs.getString(年龄).toString();if(rs.ge

44、tString(性别).equals(男)man.setSelected(true);elsewomen.setSelected(true);clas.setText(rs.getString(班级);scl.setText(rs.getString(专业); tmz.setText(rs.getString(民族); elseJOptionPane.showMessageDialog(null, 不存在该记录！, 温馨提示, JOptionPane.INFORMATION_MESSAGE); tyear.setText(); tDate.setText(); tmz.setText(); num.setText(); nam.setText(); clas.setText(); scl.setText(); num.requestFocus(); catch(SQLException se)public static void main(String args)Serch sch = new Serch();