?? kingframe1.java
字號:
jLabel25.setText("Html");
jLabel25.setBounds(new Rectangle(210, 140, 31, 24));
jLabel26.setText("Sql");
jLabel26.setBounds(new Rectangle(49, 185, 26, 25));
jLabel27.setText("Java");
jLabel27.setBounds(new Rectangle(210, 190, 34, 15));
jMenuItem3.setText("刪除學生信息");
jMenuItem3.addActionListener(new kingFrame1_jMenuItem3_actionAdapter(this));
jMenuItem13.setText("修改密碼");
jMenuItem13.addActionListener(new kingFrame1_jMenuItem13_actionAdapter(this));
jPanel9.setLayout(null);
jLabel28.setFont(new java.awt.Font("宋體", Font.PLAIN, 25));
jLabel28.setText("密碼修改");
jLabel28.setBounds(new Rectangle(135, 19, 108, 32));
jLabel29.setText("請輸入帳號");
jLabel29.setBounds(new Rectangle(32, 61, 80, 15));
jLabel30.setText("請輸入原始密碼");
jLabel30.setBounds(new Rectangle(29, 99, 88, 15));
jLabel31.setText("請輸入新密碼");
jLabel31.setBounds(new Rectangle(33, 143, 80, 15));
jLabel32.setText("請確認新密碼");
jLabel32.setBounds(new Rectangle(30, 181, 80, 15));
jTextField12.setBounds(new Rectangle(146, 58, 139, 20));
jPasswordField4.setBounds(new Rectangle(146, 97, 141, 24));
jPasswordField5.setBounds(new Rectangle(147, 136, 141, 24));
jPasswordField6.setBounds(new Rectangle(146, 177, 141, 24));
jButton18.setBounds(new Rectangle(146, 253, 87, 23));
jButton18.setText("重置");
jButton18.addActionListener(new kingFrame1_jButton18_actionAdapter(this));
jButton19.setBounds(new Rectangle(267, 253, 87, 23));
jButton19.setText("退出");
jButton19.addActionListener(new kingFrame1_jButton19_actionAdapter(this));
jButton20.setBounds(new Rectangle(43, 252, 87, 23));
jButton20.setText("確認");
jButton20.addActionListener(new kingFrame1_jButton20_actionAdapter(this));
jScrollPane2.setBounds(new Rectangle(149, 66, 138, 28));
jScrollPane3.setBounds(new Rectangle(182, 121, 167, 29));
contentPane.add(jPanel2, "jPanel2");
jPanel2.add(jLabel4);
jPanel2.add(jLabel5);
contentPane.add(jPanel1, "jPanel1");
jPanel1.add(jLabel1);
jPanel1.add(jLabel3);
jPanel1.add(jButton2);
jPanel1.add(jButton1);
jPanel1.add(jLabel2);
jPanel1.add(jPasswordField1);
jPanel1.add(jTextField1);
jMenuBar1.add(jMenu1);
jMenuBar1.add(jMenu2);
jMenuBar1.add(jMenu3);
jMenuBar1.add(jMenu4);
jMenu1.add(jMenuItem10);
jMenu1.add(jMenuItem1);
jMenu1.add(jMenuItem2);
jMenu1.add(jMenuItem3);
jMenu1.add(jMenuItem12);
jMenu2.add(jMenuItem11);
jMenu2.add(jMenuItem4);
jMenu2.add(jMenuItem5);
jMenu2.add(jMenuItem6);
jMenu2.add(jMenuItem13);
jMenu3.add(jMenuItem7);
jMenu3.add(jMenuItem8);
jMenu4.add(jMenuItem9);
contentPane.add(jPanel3, "jPanel3");
jPanel3.add(jScrollPane1, java.awt.BorderLayout.CENTER);
contentPane.add(jPanel4, "jPanel4");
jPanel4.add(jButton4);
jPanel4.add(jButton3);
jPanel4.add(jButton5);
jPanel4.add(jLabel6);
jPanel4.add(jLabel8);
jPanel4.add(jComboBox1);
jPanel4.add(jLabel9);
jPanel4.add(jComboBox3);
jPanel4.add(jTextField2);
jPanel4.add(jLabel7);
jPanel4.add(jScrollPane2);
contentPane.add(jPanel5, "jPanel5");
jPanel5.add(jButton6);
jPanel5.add(jButton7);
jPanel5.add(jButton8);
jPanel5.add(jLabel12);
jPanel5.add(jLabel11);
jPanel5.add(jLabel10);
jPanel5.add(jScrollPane3);
jPanel6.add(jLabel15);
jPanel6.add(jTextField3);
jPanel6.add(jLabel13);
jPanel6.add(jLabel14);
jPanel6.add(jButton9);
jPanel6.add(jButton10);
jPanel6.add(jButton11);
jPanel6.add(jPasswordField2);
jPanel7.add(jLabel16);
jPanel7.add(jTextField4);
jPanel7.add(jLabel17);
jPanel7.add(jTextField5);
jPanel7.add(jPasswordField3);
jPanel7.add(jButton12);
jPanel7.add(jButton13);
jPanel7.add(jButton14);
jPanel7.add(jLabel18);
jPanel7.add(jLabel19);
contentPane.add(jPanel6, "jPanel6");
contentPane.add(jPanel7, "jPanel7");
contentPane.add(jPanel8, "jPanel8");
jPanel8.add(jLabel21);
jPanel8.add(jTextField6);
jPanel8.add(jLabel23);
jPanel8.add(jTextField9);
jPanel8.add(jButton15);
jPanel8.add(jLabel25);
jPanel8.add(jTextField8);
jPanel8.add(jLabel24);
jPanel8.add(jTextField10);
jPanel8.add(jLabel26);
jPanel8.add(jLabel27);
jPanel8.add(jTextField11);
jPanel8.add(jLabel22);
jPanel8.add(jTextField7);
jPanel8.add(jLabel20);
jPanel8.add(jButton16);
jPanel8.add(jButton17);
contentPane.add(jPanel9, "jPanel9");
jPanel9.add(jLabel28);
jPanel9.add(jLabel29);
jPanel9.add(jLabel32);
jPanel9.add(jLabel31);
jPanel9.add(jTextField12);
jPanel9.add(jPasswordField6);
jPanel9.add(jLabel30);
jPanel9.add(jPasswordField4);
jPanel9.add(jPasswordField5);
jPanel9.add(jButton20);
jPanel9.add(jButton18);
jPanel9.add(jButton19);
}
//退出 (完成)
public void jMenuItem9_actionPerformed(ActionEvent actionEvent) {
System.exit(0);
try {
con.close();
} catch (SQLException ex) {
}
}
//幫助中的版本信息 (完成)
public void jMenuItem7_actionPerformed(ActionEvent actionEvent) {
JOptionPane.showMessageDialog(JF, " 學生管理系統 1.0版", "消息",
JOptionPane.CLOSED_OPTION);
}
//登陸 (完成)
public void jMenuItem10_actionPerformed(ActionEvent e) {
jTextField1.setText("");
jPasswordField1.setText("");
cardLayout1.show(contentPane, "jPanel1");
}
//查詢信息 (完成)
public void jMenuItem1_actionPerformed(ActionEvent e) {
if (kingFrame1obj) {
JTable jTable2 = null;
jTable2 = jtbobj();
JTableHeader jtobj1 = jTable2.getTableHeader();
jPanel3.add(jtobj1,BorderLayout.NORTH);
jScrollPane1.getViewport().add(jTable2);
cardLayout1.show(contentPane, "jPanel3");
} else {
mm();
}
}
public JTable jtbobj(){
Object selsctxs[][] = getTableData();
JTable jTableobj = new JTable(selsctxs, strobj3);
return jTableobj;
}
//查詢并將數據庫結果轉換成二維數組
public Object[][] getTableData() {
ArrayList lstData = new ArrayList();
ArrayList lstRow = null;
Object[][] data = null;
try {
String strSQL = "SELECT * FROM xuesheng";
ResultSet rs = this.con.createStatement().executeQuery(strSQL);
int colCount = rs.getMetaData().getColumnCount();
int rowCount = 0;
while (rs.next()) {
lstRow = new ArrayList();
for (int i = 2; i <= colCount; i++) {
lstRow.add(rs.getObject(i));
}
rowCount++;
lstData.add(lstRow);
}
rs.close();
int maxColCount = 0;
for (int i = 0; i < lstData.size(); i++) {
int s = ((ArrayList) (lstData.get(i))).size();
if (s > maxColCount)
maxColCount = s;
}
data = new Object[lstData.size()][maxColCount];
for (int i = 0; i < lstData.size(); i++) {
ArrayList lstTemp = (ArrayList) (lstData.get(i));
for (int j = 0; j < lstTemp.size(); j++) {
data[i][j] = (lstTemp.get(j) == null ? ("<null>") :
(lstTemp.get(j)));
}
}
} catch (SQLException e) {
e.printStackTrace();
}
return data;
}
//更改信息(完成)
public void jMenuItem2_actionPerformed(ActionEvent e) {
if (kingFrame1obj) {
if (kks) {
jTextField2.setText("");
jComboBox1.setSelectedIndex(0);
jComboBox2.setSelectedIndex(0);
jComboBox3.setSelectedIndex(0);
} else {
jComboBox2 = null;
JComboBox jComboBoxobj = null;
jComboBoxobj = jComboBox2_getjComboBox();
jScrollPane2.getViewport().add(jComboBoxobj);
JComboBox2_Public(jComboBoxobj);
}
cardLayout1.show(contentPane, "jPanel4");
} else {
mm();
}
}
//讓jComboBox2變成全局變量
void JComboBox2_Public(JComboBox obj){
jComboBox2 = obj;
}
//一個返回JComboBox的方法！對jComboBox2添加元素
JComboBox jComboBox2_getjComboBox(){
JComboBox jcbobj = new JComboBox();
try {
jcbobj.addItem("請選擇要更改的用戶");
ss = con.createStatement();
strsql = "select * from xuesheng";
select();
while (result.next()) {
jcbobj.addItem(result.getObject(2));
}
result.close();
ss.close();
return jcbobj;
} catch (SQLException ex) {
ex.printStackTrace();
}
return jcbobj;
}
//刪除信息
public void jMenuItem3_actionPerformed(ActionEvent e) {
if (kingFrame1obj) {
if (kkb) {
jComboBox4.setSelectedIndex(0);
} else {
jComboBox4 = null;
JComboBox jComboBoxobj1 = null;
jComboBoxobj1 = jComboBox4_getjComboBox();
jScrollPane3.getViewport().add(jComboBoxobj1);
JComboBox4_Public(jComboBoxobj1);
}
cardLayout1.show(contentPane, "jPanel5");
} else {
mm();
}
}
//返回一個JComboBox4的內容
JComboBox jComboBox4_getjComboBox(){
JComboBox jcbobj = new JComboBox();
try {
jcbobj.addItem("請選擇要刪除的用戶");
ss = con.createStatement();
strsql = "select * from xuesheng";
select();
while (result.next()) {
jcbobj.addItem(result.getObject(2));
}
result.close();
ss.close();
return jcbobj;
} catch (SQLException ex) {
ex.printStackTrace();
}
return jcbobj;
}
//讓JComboBox4變成共有
void JComboBox4_Public(JComboBox obj){
jComboBox4 = obj;
}
//添加用戶
public void jMenuItem4_actionPerformed(ActionEvent e) {
if (kingFrame1obj) {
jTextField6.setText("");
jTextField7.setText("");
jTextField8.setText("");
jTextField9.setText("");
jTextField10.setText("");
jTextField11.setText("");
cardLayout1.show(contentPane, "jPanel6");
} else {
mm();
}
}
//刪除用戶
public void jMenuItem5_actionPerformed(ActionEvent e) {
if (kingFrame1obj) {
JOptionPane.showMessageDialog(JF, "本功能僅對超級管理員開放！請確認您是超級管理員", "消息",
JOptionPane.CLOSED_OPTION);
cardLayout1.show(contentPane, "jPanel7");
} else {
mm();
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -