基于Java和Oracle的学生信息管理系统

}

sex=\;

JOptionPane.showMessageDialog(this,\性别不可为空，无法完

成添加!\);

else {

if(man.isSelected()) {

sex=\男\; } else {

sex=\女\; } try { }

catch (ClassNotFoundException ce) { } try {

Connection con =

JOptionPane.showMessageDialog(s,ce.getMessage()); Class.forName(\);

DriverManager.getConnection(\,\\,\);

Statement stmt1 = con.createStatement(); ResultSet rs1 = stmt1.executeQuery(\

STU\);

rs1=stmt1.executeQuery(\ID='\+id+\);

13

if(rs1.next())//如果账号存在则进行添加信息操作 {

if(rs1.getString(\).equals(c)) {

String sql1=\

id=\+id+\;

stmt1.executeUpdate(sql1);

int a = stmt1.executeUpdate(\

message(ID , Name , Sex , Class ,

College)values('\+num.getText()+\+nam.getText()+\+sex+\+clas.getText()+\+scl.getText()+\);

if(a==1) {

JOptionPane.showMessageDialog(s,\信息已

setVisible(false);

成功添加！\);

} else {

JOptionPane.showMessageDialog(s,\信息添 setVisible(true);

加失败！\);

}

}

else {

JOptionPane.showMessageDialog(s,\对不起，添

加失败,密码不正确！\);

}

} else {

14

}

JOptionPane.showMessageDialog(this,\对不起,添 }

rs1.close(); { } }

public static void main(String[] args) { }

@SuppressWarnings(\) AddMessage amg = new AddMessage(); num.setText(\); oldpassword.setText(\); nam.setText(\); clas.setText(\); scl.setText(\); num.requestFocus(); }

}

stmt1.close(); }

catch (SQLException se) { }

JOptionPane.showMessageDialog(s,se.getMessage());

加失败，您输入的学号不存在！\);

else

2.3.学生查询个人信息模块 //函数库

import javax.swing.*; import java.awt.event.*;

15

import java.sql.*;

public class Search extends JFrame implements ActionListener {

private static final long serialVersionUID = 1L; /*查询学生信息控件*/ static Search s;

JPanel jpl = new JPanel();

JLabel label1 = new JLabel(\学 号\JButton search = new JButton(\查 询\

JLabel label2 = new JLabel(\姓 名\JLabel label3 = new JLabel(\班 级\JLabel label4 = new JLabel(\学 院\JLabel label5 = new JLabel(\性 别\JLabel label6 = new JLabel(\密 码\ButtonGroup bgp = new ButtonGroup(); JRadioButton man = new JRadioButton(\男\JRadioButton women = new JRadioButton(\女\JTextField num = new JTextField(); JTextField password = new JTextField(); JTextField nam = new JTextField(); JTextField clas = new JTextField(); JTextField scl = new JTextField(); JButton reset = new JButton(\重 置\public Search() {

super(\查询信息\this.setSize(500,400); this.setVisible(true); //将当前窗口防止在屏幕中央 setLocationRelativeTo(null); this.setResizable(false);

this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

16