📄 selectedlessoninfocheck.java~42~
字号:
package sos;
import java.awt.*;
import javax.swing.*;
import java.sql.*;
import java.awt.Rectangle;
import java.awt.Font;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
public class SelectedLessonInfoCheck extends JDialog {
int haveSelectedCount = 0;
boolean haveFound = false;
String strNumber = "", strName = "", strStatus = "";
String[] haveSelected = new String[15];
public SelectedLessonInfoCheck(Frame frame, boolean modal) {
super(frame, modal);
setTitle("选课信息查询");
setSize(410, 260);
setResizable(false);
try {
jbInit();
} catch (Exception ex) {
ex.printStackTrace();
}
Dimension screenSize = Toolkit.getDefaultToolkit().getScreenSize();
Dimension frameSize = getSize();
if (frameSize.height > screenSize.height) {
frameSize.height = screenSize.height;
}
if (frameSize.width > screenSize.width) {
frameSize.width = screenSize.width;
}
setLocation((screenSize.width - frameSize.width) / 2,
(screenSize.height - frameSize.height) / 2);
setVisible(true);
}
private void jbInit() throws Exception {
this.getContentPane().setLayout(null);
jLabel_Prompt.setFont(new java.awt.Font("隶书", Font.BOLD | Font.ITALIC,
25));
jLabel_Prompt.setForeground(Color.blue);
jLabel_Prompt.setHorizontalAlignment(SwingConstants.CENTER);
jLabel_Prompt.setText("正在进行选课信息查询");
jLabel_Prompt.setBounds(new Rectangle(5, 3, 390, 33));
jLabel_SN.setFont(new java.awt.Font("华文新魏", Font.BOLD, 15));
jLabel_SN.setHorizontalAlignment(SwingConstants.CENTER);
jLabel_SN.setText("学号:");
jLabel_SN.setBounds(new Rectangle(3, 38, 39, 25));
// jTextField_SN.setText("jTextField1");////////////////////////////////////////
jTextField_SN.setHorizontalAlignment(SwingConstants.CENTER);
jTextField_SN.setBounds(new Rectangle(44, 38, 88, 24));
jTextField_SN.addActionListener(new
SelectedLessonInfoCheck_jTextField_SN_actionAdapter(this));
jLabel_Name.setFont(new java.awt.Font("华文新魏", Font.BOLD, 15));
jLabel_Name.setHorizontalAlignment(SwingConstants.CENTER);
jLabel_Name.setText("姓名:");
jLabel_Name.setBounds(new Rectangle(132, 38, 39, 25));
jTextField_Name.setEditable(false);
// jTextField_Name.setText("jTextField1");////////////////////////////////////////
jTextField_Name.setHorizontalAlignment(SwingConstants.CENTER);
jTextField_Name.setBounds(new Rectangle(171, 38, 61, 24));
jLabel_Status.setFont(new java.awt.Font("华文新魏", Font.BOLD, 15));
jLabel_Status.setHorizontalAlignment(SwingConstants.CENTER);
jLabel_Status.setText("在读:");
jLabel_Status.setBounds(new Rectangle(233, 38, 39, 25));
jTextField_Status.setEditable(false);
// jTextField_Status.setText("jTextField1");////////////////////////////////////////
jTextField_Status.setHorizontalAlignment(SwingConstants.CENTER);
jTextField_Status.setBounds(new Rectangle(272, 38, 125, 23));
jLabel_HaveSelected.setFont(new java.awt.Font("华文新魏", Font.BOLD, 15));
jLabel_HaveSelected.setText("本学期已选课程:");
jLabel_HaveSelected.setBounds(new Rectangle(2, 68, 127, 33));
jComboBox_HaveSelected.setEnabled(false);
jComboBox_HaveSelected.setBounds(new Rectangle(131, 68, 251, 30));
jButton_LookMore.setBounds(new Rectangle(44, 104, 155, 28));
jButton_LookMore.setEnabled(false);
jButton_LookMore.setFont(new java.awt.Font("楷体_GB2312", Font.BOLD, 15));
jButton_LookMore.setText("查看选定课程");
jLabel_All.setFont(new java.awt.Font("华文新魏", Font.BOLD, 15));
jLabel_All.setText("本学期已选课程共计:");
jLabel_All.setBounds(new Rectangle(0, 137, 173, 33));
jTextField_All.setEditable(false);
jTextField_All.setText("15");
jTextField_All.setHorizontalAlignment(SwingConstants.CENTER);
jTextField_All.setBounds(new Rectangle(155, 141, 44, 23));
jLabel_Men.setFont(new java.awt.Font("华文新魏", Font.BOLD, 15));
jLabel_Men.setText("门");
jLabel_Men.setBounds(new Rectangle(206, 141, 24, 22));
jLabel_Score.setFont(new java.awt.Font("华文新魏", Font.BOLD, 15));
jLabel_Score.setHorizontalAlignment(SwingConstants.CENTER);
jLabel_Score.setText("学分：");
jLabel_Score.setBounds(new Rectangle(232, 141, 50, 22));
jButton_GoOn.setBounds(new Rectangle(44, 177, 154, 28));
jButton_GoOn.setEnabled(false);
jButton_GoOn.setFont(new java.awt.Font("楷体_GB2312", Font.BOLD, 15));
jButton_GoOn.setText("继续查询信息");
jButton_GoOn.addActionListener(new
SelectedLessonInfoCheck_jButton1_actionAdapter(this));
jButton_Cancel.setBounds(new Rectangle(207, 177, 155, 28));
jButton_Cancel.setFont(new java.awt.Font("楷体_GB2312", Font.BOLD, 15));
jButton_Cancel.setText("退出信息查询");
jButton_Cancel.addActionListener(new
SelectedLessonInfoCheck_jButton_Cancel_actionAdapter(this));
jComboBox_Score.setEnabled(false);
jComboBox_Score.setBounds(new Rectangle(279, 139, 118, 28));
jButton_Delete.setBounds(new Rectangle(207, 104, 155, 28));
jButton_Delete.setEnabled(false);
jButton_Delete.setFont(new java.awt.Font("楷体_GB2312", Font.BOLD, 15));
jButton_Delete.setText("删除选定课程");
jButton_Delete.addActionListener(new
SelectedLessonInfoCheck_jButton_Delete_actionAdapter(this));
this.getContentPane().add(jLabel_Prompt);
this.getContentPane().add(jLabel_SN);
this.getContentPane().add(jTextField_SN);
this.getContentPane().add(jLabel_Name);
this.getContentPane().add(jTextField_Name);
this.getContentPane().add(jLabel_Status);
this.getContentPane().add(jTextField_Status);
this.getContentPane().add(jLabel_HaveSelected);
this.getContentPane().add(jComboBox_HaveSelected);
this.getContentPane().add(jLabel_All);
this.getContentPane().add(jTextField_All);
this.getContentPane().add(jLabel_Men);
this.getContentPane().add(jLabel_Score);
this.getContentPane().add(jComboBox_Score);
this.getContentPane().add(jButton_Cancel);
this.getContentPane().add(jButton_GoOn);
this.getContentPane().add(jButton_LookMore);
this.getContentPane().add(jButton_Delete);
}
JLabel jLabel_Prompt = new JLabel();
JLabel jLabel_SN = new JLabel();
JTextField jTextField_SN = new JTextField();
JLabel jLabel_Name = new JLabel();
JTextField jTextField_Name = new JTextField();
JLabel jLabel_Status = new JLabel();
JTextField jTextField_Status = new JTextField();
JLabel jLabel_HaveSelected = new JLabel();
JComboBox jComboBox_HaveSelected = new JComboBox();
JButton jButton_LookMore = new JButton();
JLabel jLabel_All = new JLabel();
JTextField jTextField_All = new JTextField();
JLabel jLabel_Men = new JLabel();
JLabel jLabel_Score = new JLabel();
JButton jButton_GoOn = new JButton();
JButton jButton_Cancel = new JButton();
JComboBox jComboBox_Score = new JComboBox();
JButton jButton_Delete = new JButton();
public void getLessonInfo() { //显示课程详细信息的方法其中0为已选课程1为建议选的课程,响应
String temp1, temp2, temp3, temp4, temp5, temp6, temp7, temp8,
temp9, tempLessonName, tempLesson = "";
try {
if (jComboBox_HaveSelected.getItemCount() == 0) {
JOptionPane.showMessageDialog(this, "尚未选定任何课程！", "注意！", 2);
throw new Exception();
}
tempLesson = jComboBox_HaveSelected.getSelectedItem().
toString().trim();
Statement stmt;
ResultSet rs;
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection("jdbc:odbc:db_STU",
"",
"");
stmt = con.createStatement();
rs = stmt.executeQuery("select * from LessonInfo");
while (rs.next()) {
temp1 = rs.getString(2);
tempLessonName = temp2 = rs.getString(3);
temp3 = rs.getString(4);
temp4 = rs.getString(5);
temp5 = rs.getString(6);
temp6 = rs.getString(7);
temp7 = rs.getString(8);
temp8 = rs.getString(9);
temp9 = rs.getString(10);
//在getString的时候要按顺序并且get走了后就没有了且不能进行下一个getSting！！
if (tempLessonName.equals(tempLesson)) {
JOptionPane.showMessageDialog(this,
"课程编号：" + temp1 +
"；课程名称：" + temp2 +
"；课程性质：" + temp3 +
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -