?? j_studentmessage.java
字號(hào):
}
return jDialog;
}
/**
* This method initializes jContentPane1
*
* @return javax.swing.JPanel
*/
private JPanel getJContentPane1() {
if (jContentPane1 == null) {
jLabel3 = new JLabel();
jLabel3.setBounds(new Rectangle(9, 83, 48, 24));
jLabel3.setText("學(xué)號(hào)：");
jLabel2 = new JLabel();
jLabel2.setBounds(new Rectangle(8, 47, 44, 27));
jLabel2.setText("姓名：");
jLabel1 = new JLabel();
jLabel1.setBounds(new Rectangle(14, 12, 203, 29));
jLabel1.setText("請(qǐng)輸入要查找的學(xué)生的姓名和學(xué)號(hào)");
jContentPane1 = new JPanel();
jContentPane1.setLayout(null);
jContentPane1.add(jLabel1, null);
jContentPane1.add(getJtfname(), null);
jContentPane1.add(getJButton3(), null);
jContentPane1.add(getJButton4(), null);
jContentPane1.add(jLabel2, null);
jContentPane1.add(jLabel3, null);
jContentPane1.add(getJtfnumber(), null);
ImageIcon ic=new ImageIcon("hua.jpg");
JLabel jbl=new JLabel();
jbl.setIcon(ic);
jbl.setBounds(new Rectangle(0, 0, 335, 146));
jContentPane1.setOpaque(false);
jContentPane1.add(jbl, null);
}
return jContentPane1;
}
/**
* This method initializes jtfname
*
* @return javax.swing.JTextField
*/
private JTextField getJtfname() {
if (jtfname == null) {
jtfname = new JTextField();
jtfname.setBounds(new Rectangle(59, 47, 162, 26));
}
return jtfname;
}
/**
* This method initializes jButton3
*
* @return javax.swing.JButton
*/
private JButton getJButton3() {
if (jButton3 == null) {
jButton3 = new JButton();
jButton3.setBounds(new Rectangle(193, 117, 62, 27));
jButton3.setText("搜素");
jButton3.addActionListener(new java.awt.event.ActionListener()
{
public void actionPerformed(java.awt.event.ActionEvent e)
{
try
{ if(!jtfname.getText().isEmpty()||!jtfnumber.getText().isEmpty())
{
J_Studentmessagepanel jstdmsgpnl=new J_Studentmessagepanel();
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection c=DriverManager.getConnection("jdbc:odbc:studentSqlDatabase","sa","");
Statement s=c.createStatement(
ResultSet.TYPE_SCROLL_SENSITIVE,
ResultSet.CONCUR_UPDATABLE
);
System.out.println("actd");
ResultSet r=s.executeQuery("select * from "+J_Denglu.choice.getSelectedItem()+" where 學(xué)號(hào)='"+jtfnumber.getText()
+"' or 姓名='"+jtfname.getText()+"'");
r.beforeFirst();
if(r.next())
{
jstdmsgpnl.mb_showstudentmessage(r);jPanel1student.removeAll();
jPanel1student.add(jstdmsgpnl);
jPanel1student.repaint();
jPanel1student.validate();
jPanel1student.setVisible(true);
getJDialog().dispose();
}
else JOptionPane.showMessageDialog(null,"沒有找到所要的學(xué)生記錄");
s.close();
c.close();
}
else JOptionPane.showMessageDialog(null,"請(qǐng)輸入學(xué)號(hào)或姓名！");
}
catch(Exception e1)
{
JOptionPane.showMessageDialog(null,"查找失敗");
}
}
});
}
return jButton3;
}
/**
* This method initializes jButton4
*
* @return javax.swing.JButton
*/
private JButton getJButton4() {
if (jButton4 == null) {
jButton4 = new JButton();
jButton4.setBounds(new Rectangle(268, 116, 62, 26));
jButton4.setText("取消");
jButton4.addActionListener(new java.awt.event.ActionListener()
{
public void actionPerformed(java.awt.event.ActionEvent e)
{
getJDialog().dispose();
}
});
}
return jButton4;
}
/**
* This method initializes jtfnumber
*
* @return javax.swing.JTextField
*/
private JTextField getJtfnumber() {
if (jtfnumber == null) {
jtfnumber = new JTextField();
jtfnumber.setBounds(new Rectangle(65, 80, 155, 30));
}
return jtfnumber;
}
public static void mb_clicktable(Vector vectclick)
{
try {
jPanel1student.removeAll();
J_Studentmessagepanel jst=new J_Studentmessagepanel();
jst.mb_lookmessage(vectclick);
jst.mb_button();
jPanel1student.add(jst);
jPanel1student.repaint();
jPanel1student.validate();
jPanel1student.setVisible(true);
} catch (Exception e) { }
}
/**
* This method initializes jButton5
*
* @return javax.swing.JButton
*/
private JButton getJButton5() {
if (jButton5 == null) {
jButton5 = new JButton();
jButton5.setBounds(new Rectangle(29, 303, 150, 24));
jButton5.setText("刪除");
jButton5.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent e) {
getJDialog1().setVisible(true);
}
});
}
return jButton5;
}
/**
* This method initializes jDialog1
*
* @return javax.swing.JDialog
*/
private JDialog getJDialog1() {
if (jDialog1 == null) {
jDialog1 = new JDialog(this);
jDialog1.setSize(new Dimension(311, 168));
jDialog1.setLocation(new Point(200, 100));
jDialog1.setContentPane(getJContentPane2());
}
return jDialog1;
}
/**
* This method initializes jContentPane2
*
* @return javax.swing.JPanel
*/
private JPanel getJContentPane2() {
if (jContentPane2 == null) {
jLabel6 = new JLabel();
jLabel6.setBounds(new Rectangle(2, 2, 303, 132));
ImageIcon ic=new ImageIcon("hua.jpg");
jLabel6.setIcon(ic);
jLabel6.setBounds(new Rectangle(0, 0, 335, 146));
jLabel5 = new JLabel();
jLabel5.setBounds(new Rectangle(11, 58, 49, 33));
jLabel5.setText("學(xué)號(hào)：");
jLabel4 = new JLabel();
jLabel4.setBounds(new Rectangle(9, 15, 173, 29));
jLabel4.setText("請(qǐng)輸入要?jiǎng)h除的學(xué)生的學(xué)號(hào)：");
jContentPane2 = new JPanel();
jContentPane2.setLayout(null);
jContentPane2.add(jLabel4, null);
jContentPane2.add(jLabel5, null);
jContentPane2.add(getJTextField(), null);
jContentPane2.add(getJButton6(), null);
jContentPane2.add(getJButton7(), null);
jContentPane2.setOpaque(false);
jContentPane2.add(jLabel6, null);
}
return jContentPane2;
}
/**
* This method initializes jTextField
*
* @return javax.swing.JTextField
*/
private JTextField getJTextField() {
if (jTextField == null) {
jTextField = new JTextField();
jTextField.setBounds(new Rectangle(62, 59, 168, 33));
}
return jTextField;
}
/**
* This method initializes jButton6
*
* @return javax.swing.JButton
*/
private JButton getJButton6() {
if (jButton6 == null) {
jButton6 = new JButton();
jButton6.setBounds(new Rectangle(139, 102, 65, 28));
jButton6.setText("確定");
jButton6.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent e) {
System.out.println("actionPerformed()"); // TODO Auto-generated Event stub actionPerformed()
try
{ if(!jTextField.getText().isEmpty())
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection c=DriverManager.getConnection("jdbc:odbc:studentSqlDatabase","sa","");
Statement s=c.createStatement();
int n=0;
n=s.executeUpdate("delete from "+J_Denglu.m_strbanji+" where 學(xué)號(hào)='"+jTextField.getText()+"'");
s.close();
c.close();
if(n>0)
{
JOptionPane.showMessageDialog(null,"刪除成功");
jTextField.setText("");
getJDialog1().dispose();
}
else{
JOptionPane.showMessageDialog(null,"找不到該學(xué)號(hào)的學(xué)生！");
jTextField.setText("");
}
}
else
{
JOptionPane.showMessageDialog(null,"學(xué)號(hào)字段不能為空！");
}
}
catch (Exception e1) {
JOptionPane.showMessageDialog(null,e1.getMessage());
}
}
});
}
return jButton6;
}
/**
* This method initializes jButton7
*
* @return javax.swing.JButton
*/
private JButton getJButton7() {
if (jButton7 == null) {
jButton7 = new JButton();
jButton7.setBounds(new Rectangle(213, 101, 65, 30));
jButton7.setText("取消");
jButton7.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent e) {
getJDialog1().dispose();
}
});
}
return jButton7;
}
} // @jve:decl-index=0:visual-constraint="12,10"
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -