📄 stumodify.java
字号:
import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
import java.sql.*;
import java.text.DateFormat;
import java.text.SimpleDateFormat;
public class StuModify extends JFrame implements ActionListener {
DataBaseManager db = new DataBaseManager();
ResultSet rs;
JLabel jLabel1;
JLabel jLabel2;
JLabel jLabel4;
JButton jButton3;
JLabel jLabel8;
JTextField jTextField13;
JTextField jTextField12;
JLabel jLabel11, jLabel12, jLabel13;
JMenu jMenu1;
JMenuBar jMenuBar1;
JButton jButton5;
JButton jButton4;
JButton jButton2;
JButton jButton1;
JTextField jTextField10,jTextField11;
JLabel jLabel10;
JTextField jTextField9;
JLabel jLabel9;
JTextField jTextField8;
JTextField jTextField7;
JTextField jTextField6;
JTextField jTextField14;
JLabel jLabel14;
JLabel jLabel7;
JLabel jLabel6;
JTextField jTextField5;
JLabel jLabel5;
JTextField jTextField4;
JTextField jTextField3;
JLabel jLabel3;
JTextField jTextField2;
JTextField jTextField1;
public StuModify(){
this.setLayout(null);
this.setTitle("修改学生信息");
this.setBounds(431, 223, 556, 473);
this.setResizable(false);
this.setVisible(true);
{
jMenuBar1 = new JMenuBar();
setJMenuBar(jMenuBar1);
{
jMenu1 = new JMenu();
jMenu1.setBounds(26, 43, 41, 55);
jMenuBar1.add(jMenu1);
jMenu1.setText("");
}
{
jLabel11 = new JLabel();
jMenuBar1.add(jLabel11);
jLabel11.setText("输入学号点确定，将调出此学生的相关信息!");
jLabel11.setPreferredSize(new java.awt.Dimension(251, 15));
}
}
{
jLabel1 = new JLabel();
getContentPane().add(jLabel1);
jLabel1.setText("学号:");
jLabel1.setBounds(26, 23, 41, 15);
}
{
jTextField1 = new JTextField();
getContentPane().add(jTextField1);
jTextField1.setText("");
jTextField1.setBounds(79, 18, 130, 25);
}
{
jLabel2 = new JLabel();
getContentPane().add(jLabel2);
jLabel2.setText("班级:");
jLabel2.setBounds(37, 323, 62, 15);
}
{
jLabel3 = new JLabel();
getContentPane().add(jLabel3);
jLabel3.setText("身份证号码:");
jLabel3.setBounds(12, 76, 68, 15);
}
{
jTextField3 = new JTextField();
getContentPane().add(jTextField3);
jTextField3.setText("");
jTextField3.setBounds(86, 72, 166, 22);
}
{
jLabel4 = new JLabel();
getContentPane().add(jLabel4);
jLabel4.setText("姓名:");
jLabel4.setBounds(27, 122, 41, 15);
}
{
jTextField4 = new JTextField();
getContentPane().add(jTextField4);
jTextField4.setText("");
jTextField4.setBounds(86, 118, 130, 22);
}
{
jLabel5 = new JLabel();
getContentPane().add(jLabel5);
jLabel5.setText("性别:");
jLabel5.setBounds(27, 162, 47, 15);
}
{
jLabel6 = new JLabel();
getContentPane().add(jLabel6);
jLabel6.setText("族别:");
jLabel6.setBounds(291, 24, 80, 15);
}
{
jTextField6 = new JTextField();
getContentPane().add(jTextField6);
jTextField6.setBounds(361, 19, 139, 24);
}
{
jLabel7 = new JLabel();
getContentPane().add(jLabel7);
jLabel7.setText("政治面貌:");
jLabel7.setBounds(282, 67, 68, 15);
}
{
jTextField7 = new JTextField();
getContentPane().add(jTextField7);
jTextField7.setBounds(362, 63, 135, 22);
}
{
jLabel8 = new JLabel();
getContentPane().add(jLabel8);
jLabel8.setText("出生日期:");
jLabel8.setBounds(282, 103, 74, 15);
}
{
jTextField8 = new JTextField();
getContentPane().add(jTextField8);
jTextField8.setBounds(362, 99, 163, 22);
}
{
jLabel9 = new JLabel();
getContentPane().add(jLabel9);
jLabel9.setText("家庭住址:");
jLabel9.setBounds(252, 147, 80, 15);
}
{
jTextField9 = new JTextField();
getContentPane().add(jTextField9);
jTextField9.setBounds(324, 143, 201, 22);
}
{
jLabel10 = new JLabel();
getContentPane().add(jLabel10);
jLabel10.setText("联系电话:");
jLabel10.setBounds(276, 191, 74, 15);
}
{
jTextField10 = new JTextField();
getContentPane().add(jTextField10);
jTextField10.setBounds(362, 185, 163, 26);
}
{
jLabel11 = new JLabel();
getContentPane().add(jLabel11);
jLabel11.setText("所在院系:");
jLabel11.setBounds(19, 196, 56, 15);
}
{
jTextField5 = new JTextField();
getContentPane().add(jTextField5);
jTextField5.setText("");
jTextField5.setBounds(87, 191, 144, 25);
}
{
jLabel12 = new JLabel();
getContentPane().add(jLabel12);
jLabel12.setText("所在专业:");
jLabel12.setBounds(18, 240, 71, 15);
}
{
jTextField11 = new JTextField();
getContentPane().add(jTextField11);
jTextField11.setText("");
jTextField11.setBounds(85, 235, 146, 24);
}
{
jLabel13 = new JLabel();
getContentPane().add(jLabel13);
jLabel13.setText("备注:");
jLabel13.setBounds(282, 245, 48, 15);
}
{
jTextField2 = new JTextField();
getContentPane().add(jTextField2);
jTextField2.setText("");
jTextField2.setBounds(329, 264, 189, 60);
}
{
jButton1 = new JButton();
jButton1.addActionListener(this);
getContentPane().add(jButton1);
jButton1.setText("清空");
jButton1.setBounds(41, 348, 78, 22);
}
{
jButton2 = new JButton();
jButton2.addActionListener(this);
getContentPane().add(jButton2);
jButton2.setText("退出");
jButton2.setBounds(430, 348, 82, 22);
}
{
jButton3 = new JButton();
jButton3.addActionListener(this);
getContentPane().add(jButton3);
jButton3.setText("确定");
jButton3.setBounds(142, 348, 80, 22);
}
{
jButton4 = new JButton();
jButton4.addActionListener(this);
getContentPane().add(jButton4);
jButton4.setEnabled(false);
jButton4.setText("修改");
jButton4.setBounds(252, 348, 72, 22);
}
{
jButton5 = new JButton();
jButton5.addActionListener(this);
getContentPane().add(jButton5);
jButton5.setEnabled(false);
jButton5.setText("取消");
jButton5.setBounds(336, 348, 74, 22);
}
{
jTextField12 = new JTextField();
getContentPane().add(jTextField12);
jTextField12.setBounds(82, 317, 141, 26);
}
{
jTextField13 = new JTextField();
getContentPane().add(jTextField13);
jTextField13.setBounds(86, 152, 78, 22);
}
{
jLabel14 = new JLabel();
getContentPane().add(jLabel14);
jLabel14.setText("年级:");
jLabel14.setBounds(37, 286, 48, 15);
}
{
jTextField14 = new JTextField();
getContentPane().add(jTextField14);
jTextField14.setText("");
jTextField14.setBounds(85, 280, 113, 26);
}
}
public void actionPerformed(ActionEvent e){
if (e.getSource() == jButton2) {
this.dispose();
} else if (e.getSource() == jButton1) {
jTextField1.setText("");
jTextField3.setText("");
jTextField4.setText("");
jTextField14.setText("");
jTextField5.setText("");
jTextField11.setText("");
jTextField12.setText("");
jTextField13.setText("");
jTextField6.setText("");
jTextField7.setText("");
jTextField8.setText("");
jTextField9.setText("");
jTextField10.setText("");
jTextField2.setText("");
} else if (e.getSource() == jButton5) {
jTextField1.setText("");
jTextField3.setText("");
jTextField4.setText("");
jTextField14.setText("");
jTextField5.setText("");
jTextField11.setText("");
jTextField12.setText("");
jTextField13.setText("");
jTextField6.setText("");
jTextField7.setText("");
jTextField8.setText("");
jTextField9.setText("");
jTextField10.setText("");
jTextField2.setText("");
jButton3.setEnabled(true);
jButton4.setEnabled(false);
jButton5.setEnabled(false);
jButton1.setEnabled(true);
jTextField1.setEnabled(true);
} else if (e.getSource() ==jButton3) {
try {
String strSQL = "select * from xs where 学号 like '%"
+ jTextField1.getText().trim() + "%'";
if ( jTextField1.getText().trim().equals("")) {
JOptionPane.showMessageDialog(null, "请输入学号：");
} else if (!db.getResult(strSQL).first()) {
JOptionPane.showMessageDialog(null, "此学生没有在学生库中...");
} else {
rs = db.getResult(strSQL);
rs.first();
jTextField1.setText(rs.getString(1));
jTextField3.setText(rs.getString(3));
jTextField4.setText(rs.getString(4));
jTextField14.setText(rs.getString(14));
jTextField5.setText(rs.getString(5));
jTextField11.setText(rs.getString(11));
jTextField12.setText(rs.getString(12));
jTextField13.setText(rs.getString(13));
jTextField6.setText(rs.getString(6));
jTextField7.setText(rs.getString(7));
jTextField8.setText(rs.getString(8));
jTextField9.setText(rs.getString(9));
jTextField10.setText(rs.getString(10));
jTextField2.setText(rs.getString(2));
jTextField1.setEnabled(false);
jButton4.setEnabled(true);
jButton5.setEnabled(true);
jButton3.setEnabled(false);
jButton1.setEnabled(false);
}
} catch (NullPointerException upe) {
System.out.println(upe.toString());
} catch (SQLException sqle) {
System.out.println(sqle.toString());
} catch (Exception ex) {
System.out.println(ex.toString());
}
} else if (e.getSource() == jButton4) {
try {
String strSQL = "update xs set 身份证号码='"
+ jTextField3.getText().trim()
+ "',姓名='"
+ jTextField4.getText().trim()
+ "',性别='"
+ jTextField14.getText().trim()
+ "',所在院系='"
+ jTextField5.getText().trim()
+ "',所在专业='"
+ jTextField11.getText().trim()
+"',年级='"
+ jTextField12.getText().trim()
+ "',班级='"
+ jTextField13.getText().trim()
+ "',族别='"
+ jTextField6.getText().trim()
+ "',政治面貌='"
+ jTextField7.getText().trim()
+ "',出生日期='"
+ jTextField8.getText().trim()
+ "',家庭住址='"
+ jTextField9.getText().trim()
+ "',联系电话='"
+ jTextField10.getText().trim()
+ "',备注='"
+ jTextField2.getText().trim()
+ "' where 学号='"
+ jTextField1.getText().trim() + "'";
if (db.updateSql(strSQL)) {
JOptionPane.showMessageDialog(null, "修改学生信息成功！");
db.closeConnection();
this.dispose();
} else {
JOptionPane.showMessageDialog(null, "修改学生信息失败！");
db.closeConnection();
this.dispose();
}
} catch (Exception ex) {
JOptionPane.showMessageDialog(null, "修改学生信息失败！");
}
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -