📄 studentinfo.java~50~
字号:
package xiangmu;
import java.awt.*;
import javax.swing.table.DefaultTableModel;
import javax.swing.*;
import java.awt.Rectangle;
import javax.swing.BorderFactory;
import java.awt.Font;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.PreparedStatement;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Connection;
import java.awt.event.MouseEvent;
import java.awt.event.MouseAdapter;
import java.text.SimpleDateFormat;
import java.awt.event.WindowEvent;
import java.awt.event.WindowAdapter;
/**
* <p>Title: 第四学习小组-教学管理系统</p>
*
* <p>Description: </p>
*
* <p>Copyright: Copyright (c) 2008</p>
*
* <p>Company: </p>
*
* @author not attributable
* @version 1.0
*/
public class StudentInfo extends JFrame {
public static String userType="";
String cols[]={"班级编号"," 学 号"," 姓 名"," 性 别"," 身份证","出生日期","家庭住址","联系方式","毕业学校"," 学 历","入学学期","入学日期"," 证 书"," 状 态"," 备 注"};
DefaultTableModel bg=new DefaultTableModel(cols,0);
public StudentInfo() {
try {
jbInit();
} catch (Exception exception) {
exception.printStackTrace();
}
}
private void jbInit() throws Exception {
this.setResizable(false);
this.addWindowListener(new StudentInfo_this_windowAdapter(this));
getContentPane().setLayout(null);
btnExit.setBounds(new Rectangle(783, 14, 90, 29));
btnExit.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
btnExit.setText("退 出");
btnExit.addActionListener(new StudentInfo_btnExit_actionAdapter(this));
btnDel.setBounds(new Rectangle(680, 14, 90, 29));
btnDel.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
btnDel.setText("删 除");
btnDel.addActionListener(new StudentInfo_btnDel_actionAdapter(this));
btnEdit.setBounds(new Rectangle(574, 14, 90, 29));
btnEdit.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
btnEdit.setText("修 改");
btnEdit.addActionListener(new StudentInfo_btnEdit_actionAdapter(this));
btnAdd.setBounds(new Rectangle(471, 14, 90, 29));
btnAdd.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
btnAdd.setText("添 加");
btnAdd.addActionListener(new StudentInfo_btnAdd_actionAdapter(this));
jScrollPane1.setBorder(BorderFactory.createEtchedBorder());
jScrollPane1.setBounds(new Rectangle(5, 55, 868, 182));
jPanel1.setBorder(BorderFactory.createEtchedBorder());
jPanel1.setBounds(new Rectangle(5, 244, 868, 350));
jPanel1.setLayout(null);
jLabel3.setFont(new java.awt.Font("楷体_GB2312", Font.BOLD, 15));
jLabel3.setText("班级编号：");
jLabel3.setBounds(new Rectangle(26, 34, 83, 30));
jLabel4.setFont(new java.awt.Font("楷体_GB2312", Font.BOLD, 15));
jLabel4.setText("学 历：");
jLabel4.setBounds(new Rectangle(23, 200, 90, 30));
jLabel6.setFont(new java.awt.Font("楷体_GB2312", Font.BOLD, 15));
jLabel6.setText("备 注：");
jLabel6.setBounds(new Rectangle(623, 249, 88, 30));
jLabel7.setFont(new java.awt.Font("楷体_GB2312", Font.BOLD, 15));
jLabel7.setText("身份证号：");
jLabel7.setBounds(new Rectangle(324, 91, 83, 30));
jLabel8.setFont(new java.awt.Font("楷体_GB2312", Font.BOLD, 15));
jLabel8.setText("毕业学校：");
jLabel8.setBounds(new Rectangle(623, 145, 83, 30));
jLabel9.setFont(new java.awt.Font("楷体_GB2312", Font.BOLD, 15));
jLabel9.setText("联系方式：");
jLabel9.setBounds(new Rectangle(324, 146, 81, 30));
jLabel10.setFont(new java.awt.Font("楷体_GB2312", Font.BOLD, 15));
jLabel10.setText("出生日期：");
jLabel10.setBounds(new Rectangle(623, 90, 83, 30));
jLabel11.setFont(new java.awt.Font("楷体_GB2312", Font.BOLD, 15));
jLabel11.setText("学 号：");
jLabel11.setBounds(new Rectangle(324, 35, 90, 30));
jLabel13.setFont(new java.awt.Font("楷体_GB2312", Font.BOLD, 15));
jLabel13.setText("性 别：");
jLabel13.setBounds(new Rectangle(23, 91, 84, 30));
jLabel14.setFont(new java.awt.Font("楷体_GB2312", Font.BOLD, 15));
jLabel14.setText("状 态：");
jLabel14.setBounds(new Rectangle(326, 256, 95, 30));
jLabel15.setFont(new java.awt.Font("楷体_GB2312", Font.BOLD, 15));
jLabel15.setText("证 书：");
jLabel15.setBounds(new Rectangle(23, 255, 97, 30));
jLabel16.setFont(new java.awt.Font("楷体_GB2312", Font.BOLD, 15));
jLabel16.setText("入学日期：");
jLabel16.setBounds(new Rectangle(623, 201, 81, 30));
jLabel17.setFont(new java.awt.Font("楷体_GB2312", Font.BOLD, 15));
jLabel17.setText("入学学期：");
jLabel17.setBounds(new Rectangle(324, 201, 83, 30));
txaRemark.setBorder(BorderFactory.createEtchedBorder());
txaRemark.setBounds(new Rectangle(711, 257, 130, 81));
cmbStatus.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
cmbStatus.setBorder(null);
cmbStatus.setBounds(new Rectangle(413, 256, 130, 27));
cmbZhengshu.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
cmbZhengshu.setBorder(null);
cmbZhengshu.setBounds(new Rectangle(114, 257, 130, 28));
cmbXueli.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
cmbXueli.setBorder(null);
cmbXueli.setBounds(new Rectangle(114, 199, 130, 28));
cmbSex.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
cmbSex.setBorder(null);
cmbSex.setBounds(new Rectangle(114, 89, 130, 29));
jLabel5.setFont(new java.awt.Font("楷体_GB2312", Font.BOLD, 15));
jLabel5.setText("家庭住址：");
jLabel5.setBounds(new Rectangle(23, 149, 91, 22));
jLabel12.setFont(new java.awt.Font("楷体_GB2312", Font.BOLD, 15));
jLabel12.setText("姓 名：");
jLabel12.setBounds(new Rectangle(623, 42, 85, 15));
txtSchool.setBounds(new Rectangle(711, 142, 129, 28));
txtInDate.setBounds(new Rectangle(711, 199, 130, 28));
txtBirthday.setBounds(new Rectangle(711, 89, 130, 28));
txtshenfenzheng.setBounds(new Rectangle(413, 89, 130, 28));
txtshenfenzheng.addActionListener(new
StudentInfo_txtshenfenzheng_actionAdapter(this));
txtAddress.setBounds(new Rectangle(114, 142, 130, 28));
txtDianhua.setBounds(new Rectangle(413, 142, 130, 28));
txtName.setBounds(new Rectangle(711, 31, 130, 28));
txtStudentNo.setBounds(new Rectangle(413, 31, 130, 28));
txtClassNo.setBounds(new Rectangle(114, 31, 130, 28));
cmbInTerm.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
cmbInTerm.setBounds(new Rectangle(413, 199, 130, 29));
btnshuaxin.setBounds(new Rectangle(366, 14, 88, 29));
btnshuaxin.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
btnshuaxin.setText("刷 新");
btnshuaxin.addActionListener(new StudentInfo_btnshuaxin_actionAdapter(this));
btnjiansuo.setBounds(new Rectangle(262, 14, 88, 29));
btnjiansuo.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
btnjiansuo.setText("检 索");
btnjiansuo.addMouseListener(new StudentInfo_btnjiansuo_mouseAdapter(this));
btnjiansuo.addActionListener(new StudentInfo_btnjiansuo_actionAdapter(this));
jTable1.addMouseListener(new StudentInfo_jTable1_mouseAdapter(this));
this.getContentPane().add(jPanel1);
this.getContentPane().add(jScrollPane1);
this.getContentPane().add(btnDel);
this.getContentPane().add(btnEdit);
this.getContentPane().add(btnAdd);
this.getContentPane().add(btnshuaxin);
this.getContentPane().add(btnjiansuo);
this.getContentPane().add(btnExit);
jScrollPane1.getViewport().add(jTable1);
jPanel1.add(txtSchool, null);
jPanel1.add(txtBirthday, null);
jPanel1.add(jLabel10, null);
jPanel1.add(jLabel8, null);
jPanel1.add(txtInDate, null);
jPanel1.add(jLabel16, null);
jPanel1.add(txaRemark, null);
jPanel1.add(jLabel6, null);
jPanel1.add(txtName, null);
jPanel1.add(jLabel12, null);
jPanel1.add(txtStudentNo, null);
jPanel1.add(jLabel11, null);
jPanel1.add(txtshenfenzheng, null);
jPanel1.add(jLabel7, null);
jPanel1.add(txtDianhua, null);
jPanel1.add(jLabel9, null);
jPanel1.add(cmbInTerm);
jPanel1.add(cmbStatus, null);
jPanel1.add(jLabel14, null);
jPanel1.add(jLabel17, null);
jPanel1.add(txtClassNo, null);
jPanel1.add(jLabel3, null);
jPanel1.add(cmbSex, null);
jPanel1.add(jLabel13, null);
jPanel1.add(txtAddress, null);
jPanel1.add(jLabel5, null);
jPanel1.add(jLabel4, null);
jPanel1.add(cmbXueli, null);
jPanel1.add(cmbZhengshu, null);
jPanel1.add(jLabel15, null);
jScrollPane1.setVerticalScrollBarPolicy(JScrollPane.
VERTICAL_SCROLLBAR_ALWAYS);
setTitle("教学管理系统-学生信息");
}
String term[]={"","S1","S2","Y2"};
String classno[]={"T58","T64","T65"};
JButton btnAdd = new JButton();
JButton btnEdit = new JButton();
JButton btnDel = new JButton();
JButton btnExit = new JButton();
JScrollPane jScrollPane1 = new JScrollPane();
JTable jTable1 = new JTable(bg);
JPanel jPanel1 = new JPanel();
JLabel jLabel3 = new JLabel();
JTextField txtClassNo = new JTextField();
JLabel jLabel4 = new JLabel();
JTextField txtInDate = new JTextField();
JLabel jLabel6 = new JLabel();
JTextField txtSchool = new JTextField();
JLabel jLabel7 = new JLabel();
String xueli[]={"","高中","大专","本科","研究生"};
JComboBox cmbXueli = new JComboBox(xueli);
JLabel jLabel8 = new JLabel();
String values[]={"","男","女"};
JComboBox cmbSex = new JComboBox(values);
JLabel jLabel9 = new JLabel();
JTextField txtBirthday = new JTextField();
JLabel jLabel10 = new JLabel();
JTextField txtshenfenzheng = new JTextField();
JLabel jLabel11 = new JLabel();
String zhengshu[]={"","S1","S2","Y2"};
JComboBox cmbZhengshu = new JComboBox(zhengshu);
JTextField txtStudentNo = new JTextField();
JLabel jLabel13 = new JLabel();
JLabel jLabel14 = new JLabel();
JLabel jLabel15 = new JLabel();
JTextField txtDianhua = new JTextField();
JLabel jLabel16 = new JLabel();
JLabel jLabel17 = new JLabel();
JTextArea txaRemark = new JTextArea();
String status[]={"","在读","休学","退学","转学","结业","毕业"};
JComboBox cmbStatus = new JComboBox(status);
JLabel jLabel5 = new JLabel();
JTextField txtAddress = new JTextField();
JLabel jLabel12 = new JLabel();
JTextField txtName = new JTextField();
String interm[]={"","S1","S2","Y2"};
JComboBox cmbInTerm = new JComboBox(interm);
JButton btnshuaxin = new JButton();
JButton btnjiansuo = new JButton();
public void btnExit_actionPerformed(ActionEvent e) {
if (JOptionPane.showConfirmDialog(this, "是否确定退出学生信息", "温馨提示",
JOptionPane.OK_CANCEL_OPTION) ==
JOptionPane.OK_OPTION) {
Dimension screenSize = Toolkit.getDefaultToolkit().
getScreenSize();
this.dispose();
}
}
public void btnjiansuo_actionPerformed(ActionEvent e) {
try {
String sql="select * from StudentInfo where 1=1 ";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn = DriverManager.getConnection("jdbc:odbc:xiangmu");
PreparedStatement ps = conn.prepareStatement(sql);
ResultSet rs= ps.executeQuery();
bg.setRowCount(0);
while(rs.next()){
Object val[]={rs.getString(1),rs.getString(2),
rs.getString(3),rs.getString(4),rs.getString(5),rs.getString(6),
rs.getString(7),rs.getString(8),rs.getString(9),rs.getString(10),rs.getString(11),
rs.getString(12),rs.getString(13),rs.getString(14),rs.getString(15)};
bg.addRow(val);
}
jTable1.updateUI();
rs.close();
ps.close();
conn.close();
}
catch (Exception ex) {
JOptionPane.showMessageDialog(this, "检索失败！");
}
}
public void jTable1_mouseClicked(MouseEvent e) {
int row = this.jTable1.getSelectedRow();
if (row > -1) {
this.txtClassNo.setText(this.jTable1.getValueAt(row, 0).toString());
this.txtStudentNo.setText(this.jTable1.getValueAt(row, 1).toString());
this.txtName.setText(this.jTable1.getValueAt(row, 2).toString());
this.cmbSex.setSelectedItem(this.jTable1.getValueAt(row, 3).
toString());
this.txtshenfenzheng.setText(this.jTable1.getValueAt(row, 4).toString());
this.txtBirthday.setText(this.jTable1.getValueAt(row, 5).toString());
this.txtAddress.setText(this.jTable1.getValueAt(row, 6).toString());
this.txtDianhua.setText(this.jTable1.getValueAt(row, 7).toString());
this.txtSchool.setText(this.jTable1.getValueAt(row, 8).toString());
this.cmbXueli.setSelectedItem(this.jTable1.getValueAt(row, 9).
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -