?? stuframe.java~223~
字號(hào):
return;
}
//————————更改界面
jTextField1.setEnabled(true);
jComboBox2.setEnabled(true);
jComboBox3.setEnabled(true);
jTextField4.setEnabled(true);
jTextField5.setEnabled(true);
jTextArea1.setEnabled(true);
jButton6.setEnabled(true);
jButton3.setEnabled(true);
jButton1.setEnabled(false);
jButton2.setEnabled(false);
jButton5.setEnabled(true);
jButton4.setText("確定");
xh=String.valueOf(jComboBox4.getSelectedItem());
jComboBox4.setVisible(false);
jTextField2.setVisible(true);
jTextField2.setText(xh);
//————————————————
}else if (jButton4.getText().equals("確定")){//當(dāng)按鈕變?yōu)榇_定時(shí)
//——————————恢復(fù)界面
jTextField1.setEnabled(false);
jComboBox4.setVisible(true);
jTextField2.setVisible(false);
jComboBox2.setEnabled(false);
jComboBox3.setEnabled(false);
jTextField4.setEnabled(false);
jTextField5.setEnabled(false);
jTextArea1.setEnabled(false);
jButton6.setEnabled(false);
jButton3.setEnabled(false);
jButton1.setEnabled(true);
jButton2.setEnabled(true);
jButton5.setEnabled(false);
jButton4.setText("修改");
//————————————————
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); //驅(qū)動(dòng)加載
con = DriverManager.getConnection("jdbc:odbc:glxt"); //數(shù)據(jù)橋連名子為ＯＤＢＣ名為glxt
//修改SQL語(yǔ)句
sql = "update stutable set stu_name=?,stu_xl=?,stu_sex=?,stu_tel=?,stu_address=?,stu_birthday=?,stu_td=?,stu_xh=?,stu_photo=? where stu_xh=?";
pre = con.prepareStatement(sql);
pre.setString(1,jTextField1.getText().trim());
pre.setString(2,String.valueOf(jComboBox2.getSelectedItem()));
pre.setString(3,String.valueOf(jComboBox3.getSelectedItem()));
pre.setString(4,jTextField4.getText().trim());
pre.setString(5,jTextField5.getText().trim());
pre.setString(6,jTextField3.getText().trim());
pre.setString(7,jTextArea1.getText().trim());
pre.setString(8,jTextField2.getText());
pre.setString(9,Url);
pre.setString(10,xh);
// //***********************************************************
// System.out.println(jTextField1.getText().trim());
// System.out.println(String.valueOf(jComboBox2.getSelectedItem()));
// System.out.println(String.valueOf(jComboBox3.getSelectedItem()));
// System.out.println(jTextField4.getText().trim());
// System.out.println(jTextField5.getText().trim());
// System.out.println(jTextField3.getText().trim());
// System.out.println(jTextArea1.getText().trim());
// System.out.println(jTextField2.getText());
// System.out.println(xh);
// //******************************
Url=null;
pre.executeUpdate();
pre.close();
con.close();
} catch (ClassNotFoundException ex) {
ex.printStackTrace();
}catch (SQLException ex1) {
ex1.printStackTrace();
}
}
}
//增加新學(xué)生
public void jButton1_actionPerformed(ActionEvent e) {
if (jButton1.getText().equals("增加") ){//如果為增加時(shí)
//——————————————————————更改界面
jTextField1.setEnabled(true);
jTextField1.setText("");
jComboBox2.setEnabled(true);
jComboBox2.setSelectedItem("");
jComboBox3.setEnabled(true);
jComboBox3.setSelectedItem("");
jTextField4.setEnabled(true);
jTextField4.setText("");
jTextField5.setEnabled(true);
jTextField5.setText("");
jTextArea1.setEnabled(true);
jTextArea1.setText("");
jButton6.setEnabled(true);
jTextField3.setText("");
jTextField2.setText("");
jButton3.setEnabled(true);
jButton4.setEnabled(false);
jButton2.setEnabled(false);
jButton5.setEnabled(true);
jButton1.setText("確定");
xh=String.valueOf(jComboBox4.getSelectedItem());
jComboBox4.setVisible(false);
jTextField2.setVisible(true);
jTextField2.setText(xh);
//——————————————————————————
}else if (jButton1.getText().equals("確定")){//如果為確定時(shí)
//——————————————恢復(fù)界面
jTextField1.setEnabled(false);
jComboBox4.setVisible(true);
jTextField2.setVisible(false);
jComboBox2.setEnabled(false);
jComboBox3.setEnabled(false);
jTextField4.setEnabled(false);
jTextField5.setEnabled(false);
jTextArea1.setEnabled(false);
jButton6.setEnabled(false);
jButton3.setEnabled(false);
jButton4.setEnabled(true);
jButton2.setEnabled(true);
jButton5.setEnabled(false);
jButton1.setText("增加");
//————————————————————
try {
int class_id=0;
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); //驅(qū)動(dòng)加載
con = DriverManager.getConnection("jdbc:odbc:glxt"); //數(shù)據(jù)橋連名子為ＯＤＢＣ名為glxt
String sql1="select class_id from classtable where class_name=?";
PreparedStatement pre1=con.prepareStatement(sql1);
pre1.setString(1,String.valueOf(jComboBox1.getSelectedItem()));
ResultSet sult1=pre1.executeQuery();
if(sult1.next()){
class_id=sult1.getInt(1);
}
sult1.close();
pre1.close();
sql = "insert into stutable(stu_name,stu_xl,stu_sex,stu_tel,stu_address,stu_birthday,stu_td,stu_xh,class_id,stu_photo)values (?,?,?,?,?,?,?,?,?,?)";
pre = con.prepareStatement(sql);
pre.setString(1,jTextField1.getText().trim());
pre.setString(2,String.valueOf(jComboBox2.getSelectedItem()));
pre.setString(3,String.valueOf(jComboBox3.getSelectedItem()));
pre.setString(4,jTextField4.getText().trim());
pre.setString(5,jTextField5.getText().trim());
pre.setString(6,jTextField3.getText().trim());
pre.setString(7,jTextArea1.getText().trim());
pre.setString(8,jTextField2.getText());
pre.setInt(9,class_id);
pre.setString(10,Url);
// System.out.println(Url);
// //***********************************************************
// System.out.println(jTextField1.getText().trim());
// System.out.println(String.valueOf(jComboBox2.getSelectedItem()));
// System.out.println(String.valueOf(jComboBox3.getSelectedItem()));
// System.out.println(jTextField4.getText().trim());
// System.out.println(jTextField5.getText().trim());
// System.out.println(jTextField3.getText().trim());
// System.out.println(jTextArea1.getText().trim());
// System.out.println(jTextField2.getText());
// System.out.println(class_id);
// //******************************
pre.executeUpdate();
result.close();
pre.close();
con.close();
} catch (ClassNotFoundException ex) {
}catch (SQLException ex1) {
}
}
}
public void jButton2_actionPerformed(ActionEvent e) {
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); //驅(qū)動(dòng)加載
con = DriverManager.getConnection("jdbc:odbc:glxt"); //數(shù)據(jù)橋連名子為ＯＤＢＣ名為glxt
sql="delete from stutable where stu_xh=?";
pre=con.prepareStatement(sql);
pre.setString(1,String.valueOf(jComboBox4.getSelectedItem()));
pre.executeUpdate();
{
jTextField1.setText("");
jComboBox2.setSelectedItem("");
jComboBox3.setSelectedItem("");
jTextField4.setText("");
jTextField5.setText("");
jTextArea1.setText("");
jTextField3.setText("");
jTextField2.setText("");
}
} catch (ClassNotFoundException ex) {
ex.printStackTrace();
} catch (SQLException ex1) {
ex1.printStackTrace();
}
}
//選擇圖片按鈕
public void jButton5_actionPerformed(ActionEvent e) {
fileDialog = new FileDialog(new JFrame(),"選擇圖片");
fileDialog.setVisible(true);
Url = fileDialog.getDirectory()+fileDialog.getFile();
Image img = Toolkit.getDefaultToolkit().getImage(Url);
ImageIcon imgIcon = new ImageIcon(img.getScaledInstance(125,145,1));
jLabel11.setIcon(imgIcon);
}
}
class StuFrame_jButton5_actionAdapter implements ActionListener {
private StuFrame adaptee;
StuFrame_jButton5_actionAdapter(StuFrame adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.jButton5_actionPerformed(e);
}
}
class StuFrame_jButton2_actionAdapter implements ActionListener {
private StuFrame adaptee;
StuFrame_jButton2_actionAdapter(StuFrame adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.jButton2_actionPerformed(e);
}
}
class StuFrame_jButton1_actionAdapter implements ActionListener {
private StuFrame adaptee;
StuFrame_jButton1_actionAdapter(StuFrame adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.jButton1_actionPerformed(e);
}
}
class StuFrame_jButton4_actionAdapter implements ActionListener {
private StuFrame adaptee;
StuFrame_jButton4_actionAdapter(StuFrame adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.jButton4_actionPerformed(e);
}
}
class StuFrame_jComboBox4_actionAdapter implements ActionListener {
private StuFrame adaptee;
StuFrame_jComboBox4_actionAdapter(StuFrame adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.jComboBox4_actionPerformed(e);
}
}
class StuFrame_jComboBox1_actionAdapter implements ActionListener {
private StuFrame adaptee;
StuFrame_jComboBox1_actionAdapter(StuFrame adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.jComboBox1_actionPerformed(e);
}
}
class StuFrame_jButton6_actionAdapter implements ActionListener {
private StuFrame adaptee;
StuFrame_jButton6_actionAdapter(StuFrame adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.jButton6_actionPerformed(e);
}
}
class StuFrame_jTextField3_actionAdapter implements ActionListener {
private StuFrame adaptee;
StuFrame_jTextField3_actionAdapter(StuFrame adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.jTextField3_actionPerformed(e);
}
}
class StuFrame_jButton3_actionAdapter implements ActionListener {
private StuFrame adaptee;
StuFrame_jButton3_actionAdapter(StuFrame adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.jButton3_actionPerformed(e);
}
}
?? 快捷鍵說(shuō)明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -