Java 的可扩展开发平台

package administer; import java.awt.BorderLayout; import java.awt.Dimension; import javax.swing.JPanel; import java.awt.*; import javax.swing.*; import javax.swing.JTextField; import javax.swing.JComboBox; import javax.swing.JRadioButton; import javax.swing.JMenuBar; import javax.swing.JMenu; import javax.swing.JMenuItem; import javax.swing.ButtonGroup; import java.awt.event.ActionEvent; import java.awt.event.ActionListener; import java.sql.*; import javax.swing.border.TitledBorder; import java.awt.event.FocusEvent; import java.awt.event.InputMethodListener; import java.awt.event.InputMethodEvent; import java.awt.event.FocusListener; /** * * <p>Title: </p> * * <p>Description: </p> * * <p>Copyright: Copyright (c) 2008</p> * * <p>Company: </p> * * @author not attributable * @version 1.0 */ public class xuefenchaxunFrame extends JDialog { JPanel contentPane; BorderLayout borderLayout1 = new BorderLayout(); JPanel topPanel = new JPanel(); JLabel lblNum = new JLabel(); JTextField txtId = new JTextField(); JLabel lblDate = new JLabel(); JComboBox cbbNian, cbbYue, cbbRi; JRadioButton rbnKoufenchaxun = new JRadioButton(); JRadioButton rbnJifenchaxun = new JRadioButton(); JMenuBar jMenuBar1 = new JMenuBar(); JMenu jMenu1 = new JMenu(); JMenuItem jMenuItem1 = new JMenuItem(); JMenuItem jMenuItem2 = new JMenuItem(); JMenuItem jMenuItem3 = new JMenuItem(); JMenuItem jMenuItem4 = new JMenuItem(); JMenuItem jMenuItem5 = new JMenuItem(); ButtonGroup bgpchaxun = new ButtonGroup(); Connection conn = null; Statement stat = null; ResultSet rs = null; ResultSet rs1 = null; ResultSet rs2 = null; ResultSet rs3 = null; String sql1 = null; String sql2 = null; String sql3 = null; int i = 0; static int quanxian = 1; JLabel lblId1 = new JLabel(); JLabel lblCausation1 = new JLabel(); JLabel lblNumeric1 = new JLabel(); JLabel lblDate1 = new JLabel(); JLabel lblName = new JLabel(); JTable table = new JTable(10, 5); public xuefenchaxunFrame() { try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); } catch (ClassNotFoundException ex) { System.out.println(ex); } try { setDefaultCloseOperation(EXIT_ON_CLOSE); jbInit(); } catch (Exception exception) { exception.printStackTrace(); } } /** * Component initialization. * * @throws java.lang.Exception */ private void jbInit() throws Exception { this.display(); } void display() { contentPane = (JPanel) getContentPane(); contentPane.setLayout(borderLayout1); this.setJMenuBar(jMenuBar1); setSize(new Dimension(450, 400)); setTitle("学分查询"); topPanel.setLayout(null); lblNum.setFont(new java.awt.Font("Dialog", Font.PLAIN, 14)); lblNum.setText("学号："); lblNum.setBounds(new Rectangle(14, 26, 44, 25)); txtId.setText(""); txtId.setBounds(new Rectangle(56, 27, 88, 21)); lblDate.setFont(new java.awt.Font("Dialog", Font.PLAIN, 14)); lblDate.setText("查询日期:"); lblDate.setBounds(new Rectangle(156, 29, 67, 21)); rbnKoufenchaxun.setFont(new java.awt.Font("Dialog", Font.PLAIN, 14)); rbnKoufenchaxun.setSelected(true); rbnKoufenchaxun.setText("扣分查询"); rbnKoufenchaxun.setBounds(new Rectangle(112, 61, 91, 25)); rbnJifenchaxun.setFont(new java.awt.Font("Dialog", Font.PLAIN, 14)); rbnJifenchaxun.setText("积分查询"); rbnJifenchaxun.setBounds(new Rectangle(244, 61, 91, 25)); jMenu1.setText("功能"); jMenuItem1.setText("查询"); jMenuItem1.addActionListener(new xuefenchaxunFrame_jMenuItem1_actionAdapter(this)); txtId.addFocusListener(new FocusListener() { public void focusLost(FocusEvent e) { txtId_focusLost(e); } public void focusGained(FocusEvent e) { } }); jMenuItem2.setText("删除"); jMenuItem2.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent e) { jMenuItem2_actionPerformed(e); } }); jMenuItem3.setText("统计"); jMenuItem3.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent e) { jMenuItem3_actionPerformed(e); } }); jMenuItem4.setText("查询清除"); jMenuItem4.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent e) { jMenuItem4_actionPerformed(e); } }); jMenuItem5.setText("关闭"); jMenuItem5.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent e) { jMenuItem5_actionPerformed(e); } }); lblId1.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12)); lblId1.setHorizontalAlignment(SwingConstants.CENTER); lblId1.setText("学号"); lblId1.setBounds(new Rectangle(88, 113, 65, 30)); lblCausation1.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12)); lblCausation1.setHorizontalAlignment(SwingConstants.CENTER); lblCausation1.setText("原因"); lblCausation1.setBounds(new Rectangle(152, 113, 128, 30)); lblNumeric1.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12)); lblNumeric1.setHorizontalAlignment(SwingConstants.CENTER); lblNumeric1.setText("分数"); lblNumeric1.setBounds(new Rectangle(279, 113, 40, 30)); lblDate1.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12)); lblDate1.setHorizontalAlignment(SwingConstants.CENTER); lblDate1.setText("日期"); lblDate1.setBounds(new Rectangle(357, 113, 80, 30)); topPanel.add(lblDate); topPanel.add(rbnKoufenchaxun); topPanel.add(rbnJifenchaxun); topPanel.add(lblNum); topPanel.add(txtId); contentPane.add(topPanel, java.awt.BorderLayout.CENTER); jMenuBar1.add(jMenu1); jMenu1.add(jMenuItem1); jMenu1.add(jMenuItem2); jMenu1.add(jMenuItem3); jMenu1.add(jMenuItem4); jMenu1.add(jMenuItem5); bgpchaxun.add(rbnKoufenchaxun); bgpchaxun.add(rbnJifenchaxun); topPanel.add(lblId1); topPanel.add(lblCausation1); topPanel.add(lblNumeric1); topPanel.add(lblDate1); this.getDate(); lblName.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12)); lblName.setText("姓名"); lblName.setBounds(new Rectangle(17, 117, 50, 24)); table.setBounds(new Rectangle(0, 160, 453, 240)); topPanel.add(lblId1); topPanel.add(lblCausation1); topPanel.add(lblNumeric1); topPanel.add(lblName); topPanel.add(table); table.setEnabled(false); switch (quanxian) { case 1: break; case 2: case 3: jMenuItem2.setEnabled(false); break; } // System.out.println(quanxian); } public void getPuanxian(int num) { this.quanxian = num; } void txtId_focusLost(FocusEvent e) { String id = tx