📄 studel.java~53~
字号:
package java_教务管理系统;
import java.awt.*;
import javax.swing.*;
import java.awt.Rectangle;
import javax.swing.table.JTableHeader;
import java.sql.*;
import javax.swing.tree.DefaultTreeModel;
import javax.swing.JOptionPane;
import javax.swing.table.DefaultTableModel;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.event.MouseEvent;
import java.awt.event.MouseAdapter;
import java.awt.Font;
/**
* <p>Title: </p>
*
* <p>Description: </p>
*
* <p>Copyright: Copyright (c) 2008</p>
*
* <p>Company: </p>
*
* @author not attributable
* @version 1.0
*/
public class studel extends JPanel {
public studel() {
try {
jbInit();
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn = DriverManager.getConnection(
"jdbc:odbc:studer");
PreparedStatement sql = conn.prepareStatement(
"select classno from class");
ResultSet i = sql.executeQuery();
this.cboclassno.addItem("");
while (i.next()) {
this.cboclassno.addItem(i.getString(1));
}
} catch (Exception ex) {
}
} catch (Exception exception) {
exception.printStackTrace();
}
}
private void jbInit() throws Exception {
this.setLayout(null);
jLabel1.setFont(new java.awt.Font("宋体", Font.PLAIN, 15));
jLabel1.setText("月");
jLabel1.setBounds(new Rectangle(492, 381, 25, 23));
jLabel2.setFont(new java.awt.Font("宋体", Font.PLAIN, 15));
jLabel2.setText("班级编号：");
jLabel2.setBounds(new Rectangle(49, 342, 84, 28));
jLabel3.setFont(new java.awt.Font("宋体", Font.PLAIN, 15));
jLabel3.setText("毕业学校：");
jLabel3.setBounds(new Rectangle(368, 451, 88, 29));
cbostubirthdaymonth.setFont(new java.awt.Font("宋体", Font.PLAIN, 15));
cbostubirthdaymonth.setBounds(new Rectangle(411, 379, 72, 28));
jLabel4.setFont(new java.awt.Font("宋体", Font.PLAIN, 15));
jLabel4.setText("学号：");
jLabel4.setBounds(new Rectangle(62, 305, 47, 32));
jLabel5.setFont(new java.awt.Font("宋体", Font.PLAIN, 15));
jLabel5.setText("最高学历：");
jLabel5.setBounds(new Rectangle(52, 488, 89, 25));
cbostubirthdaydate.setFont(new java.awt.Font("宋体", Font.PLAIN, 15));
cbostubirthdaydate.setBounds(new Rectangle(516, 381, 84, 28));
jLabel6.setFont(new java.awt.Font("宋体", Font.PLAIN, 15));
jLabel6.setText("性别：");
jLabel6.setBounds(new Rectangle(614, 304, 50, 29));
txtstuno.setFont(new java.awt.Font("宋体", Font.PLAIN, 15));
txtstuno.setBounds(new Rectangle(136, 307, 138, 27));
txtstuname.setFont(new java.awt.Font("宋体", Font.PLAIN, 15));
txtstuname.setBounds(new Rectangle(413, 307, 155, 27));
jLabel7.setFont(new java.awt.Font("宋体", Font.PLAIN, 15));
jLabel7.setText("姓名：");
jLabel7.setBounds(new Rectangle(331, 307, 49, 25));
txtstuphoto.setFont(new java.awt.Font("宋体", Font.PLAIN, 15));
txtstuphoto.setBounds(new Rectangle(137, 452, 169, 28));
jLabel8.setFont(new java.awt.Font("宋体", Font.PLAIN, 15));
jLabel8.setText("状态：");
jLabel8.setBounds(new Rectangle(399, 482, 60, 31));
txtstuidcard.setFont(new java.awt.Font("宋体", Font.PLAIN, 15));
txtstuidcard.setBounds(new Rectangle(413, 342, 296, 28));
jLabel9.setFont(new java.awt.Font("宋体", Font.PLAIN, 15));
jLabel9.setText("日");
jLabel9.setBounds(new Rectangle(616, 379, 27, 28));
cbostubirthdayyear.setFont(new java.awt.Font("宋体", Font.PLAIN, 15));
cbostubirthdayyear.setBounds(new Rectangle(294, 379, 86, 28));
jLabel10.setFont(new java.awt.Font("宋体", Font.PLAIN, 15));
jLabel10.setText("联系电话：");
jLabel10.setBounds(new Rectangle(53, 448, 78, 34));
txasturemarks.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
txasturemarks.setBounds(new Rectangle(137, 520, 622, 65));
jLabel11.setFont(new java.awt.Font("宋体", Font.PLAIN, 15));
jLabel11.setText("年");
jLabel11.setBounds(new Rectangle(386, 381, 24, 26));
txtstuschool.setFont(new java.awt.Font("宋体", Font.PLAIN, 15));
txtstuschool.setBounds(new Rectangle(455, 449, 306, 29));
cbostusex.setFont(new java.awt.Font("宋体", Font.PLAIN, 15));
cbostusex.setBounds(new Rectangle(698, 306, 61, 27));
txtstuaddress.setFont(new java.awt.Font("宋体", Font.PLAIN, 15));
txtstuaddress.setBounds(new Rectangle(137, 416, 621, 28));
jLabel12.setFont(new java.awt.Font("宋体", Font.PLAIN, 15));
jLabel12.setText("出生日期：");
jLabel12.setBounds(new Rectangle(190, 381, 98, 29));
jLabel13.setFont(new java.awt.Font("宋体", Font.PLAIN, 15));
jLabel13.setText("备注：");
jLabel13.setBounds(new Rectangle(82, 517, 62, 33));
cbostuappearance.setFont(new java.awt.Font("宋体", Font.PLAIN, 15));
cbostuappearance.setBounds(new Rectangle(455, 485, 100, 28));
jLabel14.setFont(new java.awt.Font("宋体", Font.PLAIN, 15));
jLabel14.setText("家庭地址：");
jLabel14.setBounds(new Rectangle(53, 414, 86, 30));
jLabel15.setFont(new java.awt.Font("宋体", Font.PLAIN, 15));
jLabel15.setText("身份证号码：");
jLabel15.setBounds(new Rectangle(320, 343, 96, 26));
btnstuselect.setBounds(new Rectangle(147, 593, 130, 36));
btnstuselect.setFont(new java.awt.Font("宋体", Font.PLAIN, 15));
btnstuselect.setText("查询学生");
btnstuselect.addActionListener(new studel_btnstuselect_actionAdapter(this));
btnstudel.setBounds(new Rectangle(353, 593, 129, 36));
btnstudel.setFont(new java.awt.Font("宋体", Font.PLAIN, 15));
btnstudel.setText("删除学生");
btnstudel.addActionListener(new studel_btnstudel_actionAdapter(this));
btnexit.setBounds(new Rectangle(567, 593, 127, 36));
btnexit.setFont(new java.awt.Font("宋体", Font.PLAIN, 15));
btnexit.setText("退出删除");
tbstu.setFont(new java.awt.Font("宋体", Font.PLAIN, 15));
tbstu.setBounds(new Rectangle(2, 109, 854, 191));
tbstu.addMouseListener(new studel_tbstu_mouseAdapter(this));
jTableHeader1.setFont(new java.awt.Font("宋体", Font.PLAIN, 13));
jTableHeader1.setBounds(new Rectangle(1, 78, 855, 30));
cbostubackground.setFont(new java.awt.Font("宋体", Font.PLAIN, 15));
cbostubackground.setBounds(new Rectangle(138, 486, 129, 28));
jLabel16.setFont(new java.awt.Font("华文彩云", Font.PLAIN, 50));
jLabel16.setHorizontalAlignment(SwingConstants.CENTER);
jLabel16.setText("删除学生信息");
jLabel16.setBounds(new Rectangle(38, 0, 841, 79));
cboclassno.setBounds(new Rectangle(136, 342, 137, 27));
this.add(tbstu);
this.add(jTableHeader1);
this.add(jLabel4);
this.add(txtstuno);
this.add(jLabel7);
this.add(jLabel6);
this.add(cbostusex);
this.add(jLabel15);
this.add(jLabel2);
this.add(cbostubirthdaymonth);
this.add(cbostubirthdaydate);
this.add(jLabel1);
this.add(cbostubirthdayyear);
this.add(jLabel12);
this.add(jLabel11);
this.add(jLabel9);
this.add(txtstuname);
this.add(txtstuaddress);
this.add(jLabel14);
this.add(txtstuphoto);
this.add(jLabel3);
this.add(txtstuidcard);
this.add(txtstuschool);
this.add(cbostubackground);
this.add(jLabel5);
this.add(jLabel10);
this.add(cbostuappearance);
this.add(jLabel8);
this.add(jLabel13);
this.add(txasturemarks);
this.add(btnstudel);
this.add(btnexit);
this.add(btnstuselect);
this.add(jLabel16);
this.add(cboclassno);
}
//性别
String stusex[] = {"", "男", "女"};
//出生时间（年）
String stubirthdayyear[] = {"", "1981", "1982", "1983", "1984", "1985",
"1986", "1987", "1988", "1989", "1990", "1991",
"1992", "1993"};
//出生时间（月）
String stubirthdaymonth[] = {"", "01", "02", "03", "04", "05", "06", "07",
"08",
"09",
"10", "11", "12"};
//出生时间（日）
String stubirthdaydate[] = {"", "01", "02", "03", "04", "05", "06", "07",
"08",
"09",
"10", "11", "12", "13", "14", "15", "16", "17",
"18", "19", "20", "21", "22", "23", "24", "25",
"26", "27", "28", "29", "30", "31"};
//状态
String stuappearance[] = {"", "在读", "休学", "退学", "转班"};
//学历
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -