📄 allquery.java
字号:
package xiangmu;
import java.awt.*;
import javax.swing.table.DefaultTableModel;
import javax.swing.*;
import java.awt.Rectangle;
import javax.swing.border.EtchedBorder;
import javax.swing.border.Border;
import java.awt.Font;
import javax.swing.BorderFactory;
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;
/**
* <p>Title: 第四学习小组-教学管理系统</p>
*
* <p>Description: </p>
*
* <p>Copyright: Copyright (c) 2008</p>
*
* <p>Company: </p>
*
* @author not attributable
* @version 1.0
*/
public class AllQuery extends JFrame {
String cols[]={"所属年级","所属班级","学员学号","姓名","性别","出生年月","家庭住址","联系电话","学历","已获证书","状态","考试科目","考试成绩","备注"};
DefaultTableModel bg=new DefaultTableModel(cols,0);
public AllQuery() {
try {
jbInit();
/* try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn = DriverManager.getConnection(
"jdbc:odbc:xiangmu");
PreparedStatement sql = conn.prepareStatement(
"select ClassInfo.ClassNo,StudentInfo.StudentNo from ClassInfo join StudentInfo on ClassInfo.ClassNo=StudentInfo.ClassNo");
ResultSet i = sql.executeQuery();
while (i.next()) {
//this.cmbClassNo.addItem(i.getString(1));
//this.cmbStudentNo.addItem(i.getString(2));
}
} catch (Exception ex) {
}*/
} catch (Exception exception) {
exception.printStackTrace();
}
}
private void jbInit() throws Exception {
this.setResizable(false);
getContentPane().setLayout(null);
jScrollPane1.setBorder(border1);
jScrollPane1.setBounds(new Rectangle(5, 5, 895, 215));
jLabel1.setFont(new java.awt.Font("楷体_GB2312", Font.BOLD, 15));
jLabel1.setText("所属年级：");
jLabel1.setBounds(new Rectangle(13, 250, 85, 19));
txtCourse.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
txtCourse.setBounds(new Rectangle(92, 404, 122, 30));
jLabel2.setFont(new java.awt.Font("楷体_GB2312", Font.BOLD, 15));
jLabel2.setText("所属班级：");
jLabel2.setBounds(new Rectangle(251, 242, 88, 29));
txtBirthday.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
txtBirthday.setBounds(new Rectangle(326, 294, 120, 30));
jLabel3.setFont(new java.awt.Font("楷体_GB2312", Font.BOLD, 15));
jLabel3.setText("学员学号：");
jLabel3.setBounds(new Rectangle(469, 245, 91, 21));
jLabel4.setFont(new java.awt.Font("楷体_GB2312", Font.BOLD, 15));
jLabel4.setText("姓 名：");
jLabel4.setBounds(new Rectangle(698, 243, 88, 25));
txtName.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
txtName.setBounds(new Rectangle(775, 240, 120, 30));
jLabel5.setFont(new java.awt.Font("楷体_GB2312", Font.BOLD, 15));
jLabel5.setText("性 别：");
jLabel5.setBounds(new Rectangle(13, 300, 84, 30));
cmbTerm.setBounds(new Rectangle(96, 240, 120, 30));
jLabel6.setFont(new java.awt.Font("楷体_GB2312", Font.BOLD, 15));
jLabel6.setText("出生年月：");
jLabel6.setBounds(new Rectangle(250, 298, 98, 28));
jLabel7.setFont(new java.awt.Font("楷体_GB2312", Font.BOLD, 15));
jLabel7.setText("家庭地址：");
jLabel7.setBounds(new Rectangle(469, 299, 86, 21));
txtAddress.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
txtAddress.setBounds(new Rectangle(545, 294, 350, 30));
jLabel8.setFont(new java.awt.Font("楷体_GB2312", Font.BOLD, 15));
jLabel8.setText("联系电话：");
jLabel8.setBounds(new Rectangle(13, 358, 80, 21));
txtDianhua.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
txtDianhua.setBounds(new Rectangle(92, 349, 122, 30));
jLabel9.setFont(new java.awt.Font("楷体_GB2312", Font.BOLD, 15));
jLabel9.setText("学 历：");
jLabel9.setBounds(new Rectangle(250, 348, 100, 33));
cmbXueli.setBounds(new Rectangle(326, 349, 120, 30));
cmbSex.setBounds(new Rectangle(92, 294, 120, 30));
jLabel10.setFont(new java.awt.Font("楷体_GB2312", Font.BOLD, 15));
jLabel10.setText("已获证书：");
jLabel10.setBounds(new Rectangle(469, 354, 81, 20));
cmbzhengshu.setBounds(new Rectangle(545, 349, 120, 30));
jLabel11.setFont(new java.awt.Font("楷体_GB2312", Font.BOLD, 15));
jLabel11.setText("状 态：");
jLabel11.setBounds(new Rectangle(698, 353, 86, 25));
cmbStart.setBounds(new Rectangle(776, 349, 119, 30));
jLabel12.setFont(new java.awt.Font("楷体_GB2312", Font.BOLD, 15));
jLabel12.setText("考试科目：");
jLabel12.setBounds(new Rectangle(14, 413, 88, 19));
jLabel13.setFont(new java.awt.Font("楷体_GB2312", Font.BOLD, 15));
jLabel13.setText("考试成绩：");
jLabel13.setBounds(new Rectangle(247, 409, 89, 27));
txtScore.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
txtScore.setBounds(new Rectangle(326, 402, 120, 30));
jLabel14.setFont(new java.awt.Font("楷体_GB2312", Font.BOLD, 15));
jLabel14.setText("备 注：");
jLabel14.setBounds(new Rectangle(469, 411, 85, 21));
txaRemark.setFont(new java.awt.Font("Dialog", Font.BOLD, 13));
txaRemark.setBorder(BorderFactory.createEtchedBorder());
txaRemark.setBounds(new Rectangle(545, 402, 350, 70));
btnExit.setBounds(new Rectangle(639, 497, 100, 35));
btnExit.setFont(new java.awt.Font("宋体", Font.BOLD, 15));
btnExit.setText("退 出");
btnExit.addActionListener(new AllQuery_btnExit_actionAdapter(this));
btnQuery.setBounds(new Rectangle(173, 497, 99, 35));
btnQuery.setFont(new java.awt.Font("宋体", Font.BOLD, 15));
btnQuery.setText("查 询");
btnQuery.addActionListener(new AllQuery_btnQuery_actionAdapter(this));
jTable1.addMouseListener(new AllQuery_jTable1_mouseAdapter(this));
txtStudentNo.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
txtStudentNo.setBounds(new Rectangle(545, 238, 120, 30));
txtClassNo.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
txtClassNo.setBounds(new Rectangle(326, 240, 120, 30));
btnshuaxin.setBounds(new Rectangle(404, 497, 100, 35));
btnshuaxin.setFont(new java.awt.Font("宋体", Font.BOLD, 15));
btnshuaxin.setText("刷 新");
btnshuaxin.addActionListener(new AllQuery_btnshuaxin_actionAdapter(this));
this.getContentPane().add(jScrollPane1);
this.getContentPane().add(jLabel1);
this.getContentPane().add(txtName);
this.getContentPane().add(jLabel4);
this.getContentPane().add(jLabel3);
this.getContentPane().add(jLabel2);
this.getContentPane().add(cmbTerm);
this.getContentPane().add(txtBirthday);
this.getContentPane().add(jLabel7);
this.getContentPane().add(txtAddress);
this.getContentPane().add(jLabel12);
this.getContentPane().add(txtCourse);
this.getContentPane().add(txtScore);
this.getContentPane().add(jLabel13);
this.getContentPane().add(jLabel14);
this.getContentPane().add(txaRemark);
this.getContentPane().add(jLabel5);
this.getContentPane().add(jLabel8);
this.getContentPane().add(txtDianhua);
this.getContentPane().add(cmbSex);
this.getContentPane().add(jLabel9);
this.getContentPane().add(cmbXueli);
this.getContentPane().add(jLabel6);
this.getContentPane().add(jLabel10);
this.getContentPane().add(cmbzhengshu);
this.getContentPane().add(jLabel11);
this.getContentPane().add(cmbStart);
this.getContentPane().add(txtStudentNo);
this.getContentPane().add(txtClassNo);
this.getContentPane().add(btnQuery);
this.getContentPane().add(btnExit);
this.getContentPane().add(btnshuaxin);
jScrollPane1.getViewport().add(jTable1);
jScrollPane1.setVerticalScrollBarPolicy(JScrollPane.
VERTICAL_SCROLLBAR_ALWAYS);
setTitle("教学管理系统-综合信息查询");
}
JScrollPane jScrollPane1 = new JScrollPane();
JTable jTable1 = new JTable(bg);
Border border1 = BorderFactory.createEtchedBorder(EtchedBorder.RAISED,
Color.white, new Color(170, 170, 170));
JLabel jLabel1 = new JLabel();
JTextField txtCourse = new JTextField();
JLabel jLabel2 = new JLabel();
JTextField txtBirthday = new JTextField();
JLabel jLabel3 = new JLabel();
JLabel jLabel4 = new JLabel();
JTextField txtName = new JTextField();
JLabel jLabel5 = new JLabel();
String term[]={"","S1","S2","Y2"};
JComboBox cmbTerm = new JComboBox(term);
JLabel jLabel6 = new JLabel();
JLabel jLabel7 = new JLabel();
JTextField txtAddress = new JTextField();
JLabel jLabel8 = new JLabel();
JTextField txtDianhua = new JTextField();
JLabel jLabel9 = new JLabel();
String xueli[]={"","高中","大专","本科","研究生"};
JComboBox cmbXueli = new JComboBox(xueli);
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -