?? studentinfopanel.java~18~
字號:
package superframe.factionpanels.infopanel;
import javax.swing.JFormattedTextField;
import javax.swing.JComboBox;
import javax.swing.JTextField;
import javax.swing.JLabel;
import com.borland.jbcl.layout.XYConstraints;
import superframe.link.SQLRunner;
import java.sql.ResultSet;
import javax.swing.JOptionPane;
import java.sql.SQLException;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
public class StudentInfoPanel extends InfoPanel {
JLabel jLabel_name = new JLabel();
JLabel jLabel_nation = new JLabel();
JLabel jLabel_source = new JLabel();
JLabel jLabel_home_phone = new JLabel();
JLabel jLabel_stu_no = new JLabel();
JLabel jLabel_birthday = new JLabel();
JLabel jLabel_score = new JLabel();
JLabel jLabel_address = new JLabel();
JLabel jLabel_sex = new JLabel();
JLabel jLabel_polity = new JLabel();
JLabel jLabel_college = new JLabel();
JLabel jLabel13 = new JLabel();
JLabel jLabel14 = new JLabel();
JLabel jLabel11 = new JLabel();
JLabel jLabel15 = new JLabel();
JTextField jTextField_name = new JTextField();
JTextField jTextField_stu_no = new JTextField();
JComboBox jComboBox_sex = new JComboBox();
JComboBox jComboBox_nation = new JComboBox();
JFormattedTextField jFormattedTextField_birthday = new JFormattedTextField();
JComboBox jComboBox_polity = new JComboBox();
JTextField jTextField_score = new JTextField();
JTextField jTextField_home_phone = new JTextField();
JComboBox jComboBox_source = new JComboBox();
JTextField jTextField_address = new JTextField();
JComboBox jComboBox_college = new JComboBox();
JComboBox jComboBox_department = new JComboBox();
JComboBox jComboBox_class = new JComboBox();
JComboBox jComboBox_Build_no = new JComboBox();
JComboBox jComboBox_apartment_no = new JComboBox();
public StudentInfoPanel(boolean e){
try {
initialize(e);//初始化父類
//jPanel_text.setLayout();
/*jPanel_text.add(jLabel_birthday, new XYConstraints(38, 102, 97, 42));
jPanel_text.add(jLabel_score, new XYConstraints(448, 106, 98, 35));
jPanel_text.add(jLabel_address, new XYConstraints(38, 240, 97, 35));
jPanel_text.add(jLabel_stu_no, new XYConstraints(183, 38, 36, 38));
jPanel_text.add(jLabel_name, new XYConstraints(38, 38, 37, 39));
jPanel_text.add(jLabel_nation, new XYConstraints(505, 40, 46, 36));
jPanel_text.add(jLabel_source, new XYConstraints(38, 171, 73, 42));
jPanel_text.add(jLabel_home_phone, new XYConstraints(259, 175, -1, 35));
jPanel_text.add(jLabel_polity, new XYConstraints(253, 101, 58, 42));
jPanel_text.add(jTextField_home_phone, new XYConstraints(354, 175, 185, 33));
jPanel_text.add(jComboBox_source, new XYConstraints(128, 177, 102, 30));
jPanel_text.add(jComboBox_polity, new XYConstraints(318, 105, 94, 31));
jPanel_text.add(jComboBox_nation, new XYConstraints(552, 40, 100, 30));
jPanel_text.add(jTextField_name, new XYConstraints(85, 39, 76, 31));
jPanel_text.add(jTextField_stu_no, new XYConstraints(218, 40, 94, 30));
jPanel_text.add(jFormattedTextField_birthday, new XYConstraints(104, 107, 140, 32));
jPanel_text.add(jTextField_score, new XYConstraints(530, 107, 89, 29));
jPanel_text.add(jTextField_address, new XYConstraints(113, 242, 532, 32));
jPanel_text.add(jLabel13, new XYConstraints(573, 302, 92, 36));
jPanel_text.add(jLabel_college, new XYConstraints(274, 302, 103, 36));
jPanel_text.add(jComboBox_class, new XYConstraints(23, 358, 224, 30));
jPanel_text.add(jLabel14, new XYConstraints(276, 353, 89, 36));
jPanel_text.add(jLabel11, new XYConstraints(423, 358, 86, 33));
jPanel_text.add(jLabel15, new XYConstraints(579, 354, 86, 41));
jPanel_text.add(jComboBox_college, new XYConstraints(24, 302, 238, 32));
jPanel_text.add(jComboBox_department, new XYConstraints(386, 304, 175, 31));
jPanel_text.add(jComboBox_Build_no, new XYConstraints(355, 358, 65, 32));
jPanel_text.add(jComboBox_apartment_no, new XYConstraints(474, 358, 99, 32));
jPanel_text.add(jComboBox_sex, new XYConstraints(395, 40, 59, 29));
jPanel_text.add(jLabel_sex, new XYConstraints(345, 35, 51, 36));*/
//initialize(e);//初始化父類
//setSwingEnable(e)
} catch (Exception ex) {
}
}
protected void initialize(boolean e){
try {
super.initialize(e);
jLabel_name.setText("姓名");
jLabel_nation.setText("民族");
jLabel_source.setText("學(xué)生來源");
jLabel_home_phone.setText("家庭聯(lián)系電話");
jLabel_stu_no.setText("學(xué)號");
jLabel_birthday.setText("出生日期");
jLabel_score.setText("入學(xué)成績");
jLabel_address.setText("家庭住址");
jLabel_sex.setText("性別");
jLabel_polity.setText("政治面貌");
jLabel_college.setText("學(xué)院");
jLabel13.setText("系");
jLabel14.setText("班");
jLabel11.setText("號樓");
jLabel15.setText("宿舍");
jPanel_text.add(jLabel_birthday, new XYConstraints(38, 102, 97, 42));
jPanel_text.add(jLabel_score, new XYConstraints(448, 106, 98, 35));
jPanel_text.add(jLabel_address, new XYConstraints(38, 240, 97, 35));
jPanel_text.add(jLabel_stu_no, new XYConstraints(183, 38, 36, 38));
jPanel_text.add(jLabel_name, new XYConstraints(38, 38, 37, 39));
jPanel_text.add(jLabel_nation, new XYConstraints(505, 40, 46, 36));
jPanel_text.add(jLabel_source, new XYConstraints(38, 171, 73, 42));
jPanel_text.add(jLabel_home_phone, new XYConstraints(259, 175, -1, 35));
jPanel_text.add(jLabel_polity, new XYConstraints(253, 101, 58, 42));
jPanel_text.add(jTextField_home_phone, new XYConstraints(354, 175, 185, 33));
jPanel_text.add(jComboBox_source, new XYConstraints(128, 177, 102, 30));
jPanel_text.add(jComboBox_polity, new XYConstraints(318, 105, 94, 31));
jPanel_text.add(jComboBox_nation, new XYConstraints(552, 40, 100, 30));
jPanel_text.add(jTextField_name, new XYConstraints(85, 39, 76, 31));
jPanel_text.add(jTextField_stu_no, new XYConstraints(218, 40, 94, 30));
jPanel_text.add(jFormattedTextField_birthday, new XYConstraints(104, 107, 140, 32));
jPanel_text.add(jTextField_score, new XYConstraints(530, 107, 89, 29));
jPanel_text.add(jTextField_address, new XYConstraints(113, 242, 532, 32));
jPanel_text.add(jLabel13, new XYConstraints(573, 302, 92, 36));
jPanel_text.add(jLabel_college, new XYConstraints(274, 302, 103, 36));
jPanel_text.add(jComboBox_class, new XYConstraints(23, 358, 224, 30));
jPanel_text.add(jLabel14, new XYConstraints(276, 353, 89, 36));
jPanel_text.add(jLabel11, new XYConstraints(423, 358, 86, 33));
jPanel_text.add(jLabel15, new XYConstraints(579, 354, 86, 41));
jPanel_text.add(jComboBox_college, new XYConstraints(24, 302, 238, 32));
jPanel_text.add(jComboBox_department, new XYConstraints(386, 304, 175, 31));
jPanel_text.add(jComboBox_Build_no, new XYConstraints(355, 358, 65, 32));
jPanel_text.add(jComboBox_apartment_no, new XYConstraints(474, 358, 99, 32));
jPanel_text.add(jComboBox_sex, new XYConstraints(395, 40, 59, 29));
jPanel_text.add(jLabel_sex, new XYConstraints(345, 35, 51, 36));
} catch (Exception ex) {
}
jComboBox_college.addActionListener(new
MyStudentInfoPanel_jComboBox_college_actionAdapter(this));
jComboBox_department.addActionListener(new
MyStudentInfoPanel_jComboBox_department_actionAdapter(this));
jComboBox_Build_no.addActionListener(new
MyStudentInfoPanel_jComboBox_Build_no_actionAdapter(this));
}
public void setSwingEnable(boolean e) {//父類初始化調(diào)用
jTextField_home_phone.setEnabled(e);
jComboBox_source.setEnabled(e);
jComboBox_polity.setEnabled(e);
jComboBox_nation.setEnabled(e);
jTextField_name.setEnabled(e);
jTextField_stu_no.setEnabled(e);
jFormattedTextField_birthday.setEnabled(e);
jTextField_score.setEnabled(e);
jTextField_address.setEnabled(e);
jComboBox_class.setEnabled(e);
jComboBox_college.setEnabled(e);
jComboBox_department.setEnabled(e);
jComboBox_Build_no.setEnabled(e);
jComboBox_apartment_no.setEnabled(e);
jComboBox_sex.setEnabled(e);
//jButton_ref.setVisible(e);
//jButton_sav.setVisible(e);
//jButton_remove.setVisible(e);
}
public boolean delete() {//父類按鈕響應(yīng)
return SQLRunner.executSql("delete from student where stu_no='"+keyValue+"'");
}
public boolean update() {//父類按鈕響應(yīng)
try{
String class_no;
if(jComboBox_class.getSelectedItem()==null){
class_no="";
}else{
String clname=(String)(jComboBox_class.getSelectedItem());
ResultSet rs=SQLRunner.getResult("select * from class where clname='"+clname+"'");
if(!rs.next())System.out.println("can't find clname");
class_no=rs.getString("class_no").trim();
}
String score=jTextField_score.getText().trim();
if(score.equals(""))score="null";
String sname=jTextField_name.getText().trim();
String stu_no=jTextField_stu_no.getText().trim();
String home_phone=jTextField_home_phone.getText().trim();
String address=jTextField_address.getText().trim();
String nation;
if(jComboBox_nation.getSelectedItem()==null){
nation="";
}else{
nation=((String)jComboBox_nation.getSelectedItem()).trim();
}String Build_no;
if(jComboBox_Build_no.getSelectedItem()==null){
Build_no="";
}else{
Build_no=((String)jComboBox_Build_no.getSelectedItem()).trim();
}String sex;
if(jComboBox_sex.getSelectedItem()==null){
sex="";
}else{
sex=((String)jComboBox_sex.getSelectedItem()).trim();
}String polity;
if(jComboBox_polity.getSelectedItem()==null){
polity="";
}else{
polity=((String)jComboBox_polity.getSelectedItem()).trim();
}String source;
if(jComboBox_source.getSelectedItem()==null){
source="";
}else{
source=((String)jComboBox_source.getSelectedItem()).trim();
}String dorm_no;
if(jComboBox_Build_no.getSelectedItem()==null||jComboBox_apartment_no.getSelectedItem()==null){
dorm_no="";
}else{
dorm_no=((String)jComboBox_Build_no.getSelectedItem()).trim()+((String)jComboBox_apartment_no.getSelectedItem()).trim();
}String updatesql="update student set class_no='"+class_no+"',dorm_no='"+dorm_no+"',nation='"+nation+"',polity='"+polity+"',sex='"+sex+"',source='"+source+"',home_phone='"+home_phone+"',address='"+address+"',score="+score+",sname='"+sname+"' where stu_no='"+stu_no+"'";
return SQLRunner.executSql(updatesql);
}catch(Exception e){
JOptionPane.showMessageDialog(null,e.toString(),"系統(tǒng)提示",JOptionPane.ERROR_MESSAGE);
return false;
}
}
public boolean insert() {//父類按鈕響應(yīng)
try{
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -