?? stuinfo.java
字號:
package studentms;
import javax.swing.*;
import java.awt.*;
import com.borland.jbcl.layout.*;
import java.awt.event.*;
import java.sql.*;
import java.lang.*;
import java.util.*;
/**
* <p>Title: </p>
* <p>Description: </p>
* <p>Copyright: Copyright (c) 2003</p>
* <p>Company: </p>
* @author not attributable
* @version 1.0
*/
public class stuInfo extends JFrame {
JPanel jPanel1 = new JPanel();
XYLayout xYLayout1 = new XYLayout();
XYLayout xYLayout2 = new XYLayout();
JLabel jLabel1 = new JLabel();
JLabel jLabel2 = new JLabel();
JLabel jLabel3 = new JLabel();
JLabel jLabel4 = new JLabel();
JLabel jLabel5 = new JLabel();
JLabel jLabel6 = new JLabel();
JLabel jLabel7 = new JLabel();
JTextField jTNum = new JTextField();
JTextField jTName = new JTextField();
JTextField jTSex = new JTextField();
JTextField jTHome = new JTextField();
JTextField jTBirth = new JTextField();
JTextField jTEthnic = new JTextField();
JTextField jTClass = new JTextField();
JButton jBAdd = new JButton();
JButton jBModify = new JButton();
JButton jBDelete = new JButton();
JButton jBCancel = new JButton();
JButton jBSave = new JButton();
private String exeType=new String(); //標志操作類型
// public String currentPeopleID; //標志當前人員
Database DB =new Database(); //連接數據庫
ResultSet rs ; //返回結果
String sql=new String(); //SQL語句
JButton jBSee = new JButton();
JButton jBSearch = new JButton();
JButton jBExit = new JButton();
JButton jBSum = new JButton();
JButton jBGrade = new JButton();
public stuInfo() {
try {
jbInit();
}
catch(Exception e) {
e.printStackTrace();
}
}
private void jbInit() throws Exception {
this.getContentPane().setLayout(xYLayout1);
jPanel1.setLayout(xYLayout2);
jLabel4.setText("民族：");
jLabel4.setFont(new java.awt.Font("Dialog", 0, 12));
jLabel1.setText("姓名：");
jLabel1.setFont(new java.awt.Font("Dialog", 0, 12));
jLabel3.setText("學號：");
jLabel3.setFont(new java.awt.Font("Dialog", 0, 12));
jLabel7.setText("籍貫：");
jLabel7.setFont(new java.awt.Font("Dialog", 0, 12));
jLabel2.setText("性別：");
jLabel2.setFont(new java.awt.Font("Dialog", 0, 12));
jBSave.setFont(new java.awt.Font("Dialog", 0, 12));
jBSave.setMargin(new Insets(2, 2, 2, 2));
jBSave.setText("保存");
jBSave.addActionListener(new stuInfo_jBSave_actionAdapter(this));
jBSave.addMouseListener(new stuInfo_jBSave_mouseAdapter(this));
jLabel6.setText("出生日期：");
jLabel6.setFont(new java.awt.Font("Dialog", 0, 12));
jLabel5.setText("所在班級：");
jLabel5.setFont(new java.awt.Font("Dialog", 0, 12));
jPanel1.setOpaque(true);
jBAdd.setFont(new java.awt.Font("Dialog", 0, 12));
jBAdd.setMargin(new Insets(2, 2, 2, 2));
jBAdd.setText("新增");
jBAdd.addActionListener(new stuInfo_jBAdd_actionAdapter(this));
jBModify.setFont(new java.awt.Font("Dialog", 0, 12));
jBModify.setMargin(new Insets(2, 2, 2, 2));
jBModify.setText("修改");
jBModify.addActionListener(new stuInfo_jBModify_actionAdapter(this));
jBDelete.setFont(new java.awt.Font("Dialog", 0, 12));
jBDelete.setActionCommand("");
jBDelete.setMargin(new Insets(2, 2, 2, 2));
jBDelete.setText("刪除");
jBDelete.addActionListener(new stuInfo_jBDelete_actionAdapter(this));
jBCancel.setFont(new java.awt.Font("Dialog", 0, 12));
jBCancel.setMargin(new Insets(2, 2, 2, 2));
jBCancel.setText("取消");
jBCancel.addActionListener(new stuInfo_jBCancel_actionAdapter(this));
xYLayout1.setWidth(384);
xYLayout1.setHeight(279);
this.setTitle("個人信息管理");
jTHome.setFont(new java.awt.Font("Dialog", 0, 12));
jTSex.setFont(new java.awt.Font("Dialog", 0, 12));
jTName.setFont(new java.awt.Font("Dialog", 0, 12));
jTNum.setFont(new java.awt.Font("Dialog", 0, 12));
jTEthnic.setFont(new java.awt.Font("Dialog", 0, 12));
jTClass.setFont(new java.awt.Font("Dialog", 0, 12));
jTBirth.setFont(new java.awt.Font("Dialog", 0, 12));
jBSee.setFont(new java.awt.Font("Dialog", 0, 12));
jBSee.setMargin(new Insets(2, 2, 2, 2));
jBSee.setText("查看成績");
jBSee.addActionListener(new stuInfo_jBSee_actionAdapter(this));
jBSearch.setFont(new java.awt.Font("Dialog", 0, 12));
jBSearch.setActionCommand("搜 索");
jBSearch.setIcon(null);
jBSearch.setText("查 詢");
jBSearch.addActionListener(new stuInfo_jBSearch_actionAdapter(this));
jBExit.setFont(new java.awt.Font("Dialog", 0, 12));
jBExit.setMargin(new Insets(2, 2, 2, 2));
jBExit.setText("退出");
jBExit.addActionListener(new stuInfo_jBExit_actionAdapter(this));
jBSum.setFont(new java.awt.Font("Dialog", 0, 12));
jBSum.setMargin(new Insets(2, 2, 2, 2));
jBSum.setText("人員統計");
jBSum.addActionListener(new stuInfo_jBSum_actionAdapter(this));
jBGrade.setFont(new java.awt.Font("Dialog", 0, 12));
jBGrade.setMargin(new Insets(2, 2, 2, 2));
jBGrade.setText("成績管理");
jBGrade.addActionListener(new stuInfo_jBGrade_actionAdapter(this));
jPanel1.add(jTNum, new XYConstraints(83, 57, 72, 20));
jPanel1.add(jLabel3, new XYConstraints(39, 57, 38, 19));
jPanel1.add(jTName, new XYConstraints(83, 96, 72, 20));
jPanel1.add(jLabel7, new XYConstraints(41, 174, 44, 19));
jPanel1.add(jTClass, new XYConstraints(268, 96, 72, 20));
jPanel1.add(jLabel4, new XYConstraints(218, 57, 39, 19));
jPanel1.add(jTEthnic, new XYConstraints(267, 55, 72, 20));
jPanel1.add(jBAdd, new XYConstraints(37, 218, 43, 23));
jPanel1.add(jBModify, new XYConstraints(88, 218, 43, 23));
jPanel1.add(jBExit, new XYConstraints(294, 218, 43, 23));
jPanel1.add(jBDelete, new XYConstraints(141, 218, 43, 23));
jPanel1.add(jBSave, new XYConstraints(193, 218, 43, 23));
jPanel1.add(jBCancel, new XYConstraints(244, 218, 43, 23));
jPanel1.add(jBSearch, new XYConstraints(41, 10, 65, 23));
jPanel1.add(jBSee, new XYConstraints(118, 10, 65, 23));
jPanel1.add(jBGrade, new XYConstraints(273, 10, 65, 23));
jPanel1.add(jBSum, new XYConstraints(195, 10, 65, 23));
jPanel1.add(jTSex, new XYConstraints(83, 135, 72, 20));
jPanel1.add(jLabel2, new XYConstraints(40, 135, 45, 17));
jPanel1.add(jLabel6, new XYConstraints(203, 135, 69, 20));
jPanel1.add(jTBirth, new XYConstraints(268, 135, 72, 20));
jPanel1.add(jTHome, new XYConstraints(83, 173, 257, 20));
jPanel1.add(jLabel5, new XYConstraints(202, 96, 61, 17));
jPanel1.add(jLabel1, new XYConstraints(40, 95, -1, -1));
this.getContentPane().add(jPanel1, new XYConstraints(3, 11, 363, 251));
//設置初始化時文本框和按鈕的狀態
setAbled(false);
setButton(true,false,false,false,false);
nullSet();
}
//設置文本框是否可編輯
void setAbled(boolean logic){
jTNum.setEnabled(logic);
jTEthnic.setEnabled(logic);
jTName.setEnabled(logic);
jTClass.setEnabled(logic);
jTSex.setEnabled(logic);
jTBirth.setEnabled(logic);
jTHome.setEnabled(logic);
}
//設置按鈕的狀態
void setButton(boolean add,boolean xiugai,boolean del,boolean save,boolean cancel){
jBAdd.setEnabled(add);
jBModify.setEnabled(xiugai);
jBDelete.setEnabled(del);
jBSave.setEnabled(save);
jBCancel.setEnabled(cancel);
}
//將文本框清空
void setNull(){
jTNum.setText(null);
jTEthnic.setText(null);
jTName.setText(null);
jTClass.setText(null);
jTSex.setText(null);
jTBirth.setText(null);
jTHome.setText(null);
}
//設置操作類型，以使數據庫根據不同類型進行不同的操作
void setExeType(String type){
exeType=type;
}
//新添
void jBAdd_actionPerformed(ActionEvent e) {
setExeType("addnew");
setNull();
this.setAbled(true);
this.setButton(false,false,false,true,true);
}
//取消
void jBCancel_actionPerformed(ActionEvent e) {
this.setAbled(false);
//如果是新建信息，將所有文本框清空
if(exeType=="addnew"){
this.setNull() ;
}
this.setButton(true,true,true,false,false);
nullSet();
}
//查看成績，點擊查看成績按鈕時調用此函數
void seeGrade(){
//調用searchGrade類中查看信息的方法，避免了代碼的重復
searchGrade seegrade=new searchGrade();
seegrade.showResult(rs);
}
void jBSave_mouseClicked(MouseEvent e) {
}
//如果當前人員為空，設置各按鈕屬性
void nullSet(){
if(jTNum.getText().equals("")){
jBModify.setEnabled(false);
jBDelete.setEnabled(false);
jBSee.setEnabled(false);
}
else{
jBModify.setEnabled(true);
jBDelete.setEnabled(true);
jBSee.setEnabled(true);
}
}
//保存信息
void jBSave_actionPerformed(ActionEvent e) {
if (exeType=="addnew"){
if(jTNum.getText().equals("")){
JOptionPane.showMessageDialog(null, "學號不能為空！");
}
else{
sql = "select Num from stuTable where Num=" +
Integer.parseInt(jTNum.getText()) + "";
rs = DB.getResult(sql);
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -