📄 stuinput.java
字号:
import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
import java.sql.*;
public class StuInput extends JFrame implements ActionListener {
DataBaseManager db = new DataBaseManager();
ResultSet rs;
JLabel jLabel1;
JLabel jLabel2;
JLabel jLabel4;
JButton jButton3;
JLabel jLabel8;
private JTextField jTextField12;
private JLabel jLabel14;
private JTextField jTextField2;
private JLabel jLabel13;
private JTextField jTextField11;
private JLabel jLabel12;
private JTextField jTextField5;
private JLabel jLabel11;
JButton jButton2;
JButton jButton1;
JTextField jTextField10;
JLabel jLabel10;
JTextField jTextField9;
JLabel jLabel9;
JTextField jTextField8;
JTextField jTextField7;
JTextField jTextField6;
private JTextField jTextField14;
private JTextField jTextField13;
JLabel jLabel7;
JLabel jLabel6;
JLabel jLabel5;
JTextField jTextField4;
JTextField jTextField3;
JLabel jLabel3;
JTextField jTextField1;
public StuInput(){
this.setLayout(null);
this.setTitle("录入学生信息");
this.setBounds(431, 223, 557, 432);
this.setResizable(false);
this.setVisible(true);
{
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(28, 317, 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, 116, 130, 24);
}
{
jLabel5 = new JLabel();
getContentPane().add(jLabel5);
jLabel5.setText("性别:");
jLabel5.setBounds(27, 158, 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(231, 147, 80, 15);
}
{
jTextField9 = new JTextField();
getContentPane().add(jTextField9);
jTextField9.setBounds(299, 140, 226, 25);
}
{
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);
}
{
jButton1 = new JButton();
jButton1.addActionListener(this);
getContentPane().add(jButton1);
jButton1.setText("保存");
jButton1.setBounds(138, 352, 72, 26);
}
{
jButton2 = new JButton();
jButton2.addActionListener(this);
getContentPane().add(jButton2);
jButton2.setText("取消");
jButton2.setBounds(330, 352, 70, 26);
}
{
jButton3 = new JButton();
jButton3.addActionListener(this);
getContentPane().add(jButton3);
jButton3.setText("清空");
jButton3.setBounds(238, 352, 71, 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(336, 229, 201, 84);
}
{
jLabel14 = new JLabel();
getContentPane().add(jLabel14);
jLabel14.setText("年级:");
jLabel14.setBounds(27, 278, 48, 15);
}
{
jTextField12 = new JTextField();
getContentPane().add(jTextField12);
jTextField12.setText("");
jTextField12.setBounds(87, 271, 123, 28);
}
{
jTextField13 = new JTextField();
getContentPane().add(jTextField13);
jTextField13.setText("");
jTextField13.setBounds(86, 313, 124, 27);
}
{
jTextField14 = new JTextField();
getContentPane().add(jTextField14);
jTextField14.setText("");
jTextField14.setBounds(86, 152, 86, 27);
}
}
public void actionPerformed(ActionEvent e){
if(e.getSource()==jButton2){
this.dispose();
}
else if(e.getSource()==jButton3){
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() ==jButton1 ) {
try{
String strSQL="select * from xs where 学号='"+
jTextField1.getText().trim()+"'";
if (jTextField1.getText().trim().equals("")) {
JOptionPane.showMessageDialog(null, "学号不能为空!");
}
else if(jTextField3.getText().trim().equals("")){
JOptionPane.showMessageDialog(null, "身份证号码不能为空!");
}
else if(jTextField4.getText().trim().equals("")){
JOptionPane.showMessageDialog(null, "姓名不能为空!");
}
else if(jTextField14.getText().trim().equals("")){
JOptionPane.showMessageDialog(null, "性别不能为空!");
}
else if(jTextField5.getText().trim().equals("")){
JOptionPane.showMessageDialog(null, "所在院系不能为空!");
}
else if(jTextField11.getText().trim().equals("")){
JOptionPane.showMessageDialog(null, "所在专业不能为空!");
}
else if(jTextField12.getText().trim().equals("")){
JOptionPane.showMessageDialog(null, "年级不能为空!");
}
else if(jTextField13.getText().trim().equals("")){
JOptionPane.showMessageDialog(null, "班级不能为空!");
}
else if(jTextField6.getText().trim().equals("")){
JOptionPane.showMessageDialog(null, "族别不能为空!");
}
else if(jTextField7.getText().trim().equals("")){
JOptionPane.showMessageDialog(null, "政治面貌不能为空!");
}
else if(jTextField8.getText().trim().equals("")){
JOptionPane.showMessageDialog(null, "出生日期不能为空!");
}
else if(jTextField9.getText().trim().equals("")){
JOptionPane.showMessageDialog(null, "家庭住址不能为空!");
}
else if(jTextField10.getText().trim().equals("")){
JOptionPane.showMessageDialog(null, "联系电话不能为空!");
}
else if(jTextField2.getText().trim().equals("")){
JOptionPane.showMessageDialog(null, "备注不能为空!");
}
else {
if(db.getResult(strSQL).first())
{
int result=JOptionPane.showOptionDialog(null, "当前学号录入完毕是否要继续输入其他学生的信息?", "系统提示", JOptionPane.YES_NO_OPTION, JOptionPane.QUESTION_MESSAGE, null, new String[] {"是","否"}, "否");
if(result==JOptionPane.YES_OPTION){
new StuInput();
}
else{
this.dispose();
}
}
else
{
strSQL="insert into xs (学号,身份证号码,姓名,性别,所在院系,所在专业,年级,班级,族别,政治面貌,出生日期,家庭住址,联系电话,备注) values('"+jTextField1.getText().trim()+"','"+
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()+"')";
if (db.updateSql(strSQL)) {
JOptionPane.showMessageDialog(null, "保存学生信息成功！");
this.dispose();
} else {
JOptionPane.showMessageDialog(null, "保存学生信息失败!");
}
}
}
}
catch(SQLException sqle)
{
System.out.println(sqle.toString());
}
catch (Exception ex) {
System.out.println(ex.toString());
}
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -