?? operatorconfig.java
字號:
package com.csbook.restaurant;
import java.awt.*;
import javax.swing.*;
import java.awt.event.*;
import java.sql.*;
import com.csbook.restaurant.utility.*;
import com.borland.dbswing.*;
import com.borland.dx.sql.dataset.*;
import com.borland.dx.dataset.*;
/**
* <p>Title: </p>
* <p>Description: </p>
* <p>Copyright: Copyright (c) 2003</p>
* <p>Company: </p>
* @author pengtao
* @version 1.0
*/
public class OperatorConfig extends JInternalFrame {
JPanel jPanel1 = new JPanel();
JPanel jPanel3 = new JPanel();
JTextField PICNo = new JTextField();
JPasswordField password = new JPasswordField();
JLabel jLabel4 = new JLabel();
JTextField userID = new JTextField();
JComboBox userType = new JComboBox();
JTextField address = new JTextField();
JLabel jLabel1 = new JLabel();
JLabel jLabel3 = new JLabel();
JLabel jLabel7 = new JLabel();
GridLayout gridLayout1 = new GridLayout(4,4);
JLabel jLabel2 = new JLabel();
JLabel jLabel6 = new JLabel();
JTextField username = new JTextField();
JPanel panel1 = new JPanel();
JLabel jLabel9 = new JLabel();
JTextField tel = new JTextField();
JLabel jLabel5 = new JLabel();
JLabel jLabel8 = new JLabel();
JPanel jPanel2 = new JPanel();
BorderLayout borderLayout1 = new BorderLayout();
Database database1 = new Database();
JPanel jPanel4 = new JPanel();
TableScrollPane tableScrollPane1 = new TableScrollPane();
BorderLayout borderLayout2 = new BorderLayout();
JButton cancel = new JButton();
JPanel jPanel5 = new JPanel();
FlowLayout flowLayout1 = new FlowLayout();
JButton ok = new JButton();
JButton deleteUser = new JButton();
JdbNavToolBar DBNavToolBar = new JdbNavToolBar();
JTextField remark = new JTextField();
QueryDataSet queryDataSet1 = new QueryDataSet();
JdbTable jdbTable1 = new JdbTable();
Column column1 = new Column();
Column column2 = new Column();
Column column3 = new Column();
Column column4 = new Column();
Column column5 = new Column();
Column column6 = new Column();
Column column7 = new Column();
JButton modify = new JButton(); DBDisposeMonitor dBDisposeMonitor1 = new DBDisposeMonitor();
public OperatorConfig(String title,boolean resizable,boolean closable,boolean maximizable,boolean iconifiable) {
super(title,resizable,closable,maximizable,iconifiable);
try {
jbInit();
pack();
}
catch(Exception ex) {
ex.printStackTrace();
}
}
private void jbInit() throws Exception {
PICNo.setText("");
password.setText("");
jLabel4.setRequestFocusEnabled(true);
jLabel4.setText("用戶初始密碼：");
userID.setText("");
address.setText("");
jLabel1.setText("用戶ID：");
jLabel3.setText("聯(lián)系電話：");
jLabel7.setText("身份證號：");
jLabel2.setText("聯(lián)系地址：");
jLabel6.setText("用戶姓名：");
username.setText("");
panel1.setLayout(gridLayout1);
jLabel9.setText("備注");
tel.setText("");
jLabel5.setText("用戶類型：");
jLabel8.setText("請輸入新用戶的信息");
jPanel3.setLayout(borderLayout1);
database1.setConnection(new com.borland.dx.sql.dataset.ConnectionDescriptor("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=Restaurant", "user", "user", false, "com.microsoft.jdbc.sqlserver.SQLServerDriver"));
jPanel4.setLayout(borderLayout2);
cancel.setText("關閉窗口");
cancel.addActionListener(new OperatorConfig_cancel_actionAdapter(this));
jPanel5.setLayout(flowLayout1);
ok.setText("增加用戶");
ok.addActionListener(new OperatorConfig_ok_actionAdapter(this));
deleteUser.setActionCommand("jButton1");
deleteUser.setText("刪除用戶");
deleteUser.addActionListener(new OperatorConfig_deleteUser_actionAdapter(this));
remark.setText("");
queryDataSet1.setMetaDataUpdate(MetaDataUpdate.NONE);
queryDataSet1.setTableName("operator");
queryDataSet1.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "SELECT operator.id,operator.name,operator.type,operator.tel,operator.addr,operator.PICNo,operator.rem" +
"ark FROM Restaurant.dbo.operator", null, true, Load.ALL));
jdbTable1.setDataSet(queryDataSet1);
column1.setColumnName("id");
column1.setDataType(com.borland.dx.dataset.Variant.STRING);
column1.setPrecision(25);
column1.setRowId(true);
column1.setSchemaName("dbo");
column1.setTableName("operator");
column1.setServerColumnName("id");
column1.setSqlType(1);
column2.setColumnName("name");
column2.setDataType(com.borland.dx.dataset.Variant.STRING);
column2.setPrecision(25);
column2.setSchemaName("dbo");
column2.setTableName("operator");
column2.setServerColumnName("name");
column2.setSqlType(1);
column3.setColumnName("type");
column3.setDataType(com.borland.dx.dataset.Variant.STRING);
column3.setPrecision(10);
column3.setSchemaName("dbo");
column3.setTableName("operator");
column3.setServerColumnName("type");
column3.setSqlType(1);
column4.setColumnName("tel");
column4.setDataType(com.borland.dx.dataset.Variant.STRING);
column4.setPrecision(15);
column4.setSchemaName("dbo");
column4.setTableName("operator");
column4.setServerColumnName("tel");
column4.setSqlType(1);
column5.setColumnName("addr");
column5.setDataType(com.borland.dx.dataset.Variant.STRING);
column5.setPrecision(50);
column5.setSchemaName("dbo");
column5.setTableName("operator");
column5.setServerColumnName("addr");
column5.setSqlType(1);
column6.setColumnName("PICNo");
column6.setDataType(com.borland.dx.dataset.Variant.STRING);
column6.setPrecision(18);
column6.setSchemaName("dbo");
column6.setTableName("operator");
column6.setServerColumnName("PICNo");
column6.setSqlType(1);
column7.setColumnName("remark");
column7.setDataType(com.borland.dx.dataset.Variant.STRING);
column7.setPrecision(255);
column7.setSchemaName("dbo");
column7.setTableName("operator");
column7.setServerColumnName("remark");
column7.setSqlType(1);
queryDataSet1.setColumns(new Column[] {column1, column2, column3, column4, column5, column6, column7});
modify.setText("修改用戶信息");
modify.addActionListener(new OperatorConfig_modify_actionAdapter(this));
DBNavToolBar.setVisible(false);
DBNavToolBar.setButtonStatePost(JdbNavToolBar.AUTO_ENABLED);
this.getContentPane().add(jPanel1, BorderLayout.SOUTH);
jPanel1.add(modify, null);
jPanel1.add(cancel, null);
this.getContentPane().add(jPanel3, BorderLayout.NORTH);
jPanel3.add(jPanel2, BorderLayout.NORTH);
jPanel2.add(jLabel8, null);
jPanel3.add(panel1, BorderLayout.CENTER);
panel1.add(jLabel1, null);
panel1.add(userID, null);
panel1.add(jLabel6, null);
panel1.add(username, null);
panel1.add(jLabel5, null);
panel1.add(userType, null);
panel1.add(jLabel4, null);
panel1.add(password, null);
panel1.add(jLabel3, null);
panel1.add(tel, null);
panel1.add(jLabel2, null);
panel1.add(address, null);
panel1.add(jLabel7, null);
panel1.add(PICNo, null);
panel1.add(jLabel9, null);
panel1.add(remark, null);
this.getContentPane().add(jPanel4, BorderLayout.CENTER);
jPanel4.add(tableScrollPane1, BorderLayout.CENTER);
tableScrollPane1.getViewport().add(jdbTable1, null);
jPanel4.add(jPanel5, BorderLayout.NORTH);
jPanel5.add(ok, null);
jPanel5.add(deleteUser, null);
jPanel4.add(DBNavToolBar, BorderLayout.SOUTH);
userType.addItem("operator");
userType.addItem("manager");
userType.addItem("sa");
}
void ok_actionPerformed(ActionEvent e) {
String id = userID.getText();
//檢查用戶名是否為空,如為空,提示用戶輸入用戶名
if(id.trim().equals("")){
JOptionPane.showMessageDialog(this, "用戶名不能為空！", "警告",
JOptionPane.ERROR_MESSAGE);
return;
}
String name = username.getText();
String userT = (String) userType.getSelectedItem();
String telephone = tel.getText();
String addr = address.getText();
char temp[]=password.getPassword();
String pass=new String(temp);
String PIC = PICNo.getText();
String note = remark.getText();
CheckUser cUser = new CheckUser();
boolean userExist=cUser.userExist(id);
if(userExist)
{
JOptionPane.showMessageDialog(this, "系統(tǒng)中已存在該用戶！", "錯誤",
JOptionPane.ERROR_MESSAGE);
return;
}
//調(diào)用CheckUser類中的方法添加用戶
cUser.addOperator(id,name,userT,pass,PIC,telephone,addr,note);
//刷新列表顯示
JButton refreshButton=DBNavToolBar.getRefreshButton();
refreshButton.doClick();
//提示用戶添加成功
JOptionPane.showMessageDialog(this,"該用戶已成功添加","提示",JOptionPane.PLAIN_MESSAGE);
}
void cancel_actionPerformed(ActionEvent e) {
this.dispose();
}
void deleteUser_actionPerformed(ActionEvent e) {
String id = userID.getText();
//檢查用戶名是否為空,如為空,提示用戶輸入用戶名
if(id.trim().equals("")){
JOptionPane.showMessageDialog(this, "用戶名不能為空！", "警告",
JOptionPane.ERROR_MESSAGE);
return;
}
CheckUser cUser = new CheckUser();
//檢查系統(tǒng)中是否存在該用戶
if(!cUser.userExist(id))
{
JOptionPane.showMessageDialog(this, "系統(tǒng)中不存在該用戶！", "錯誤",
JOptionPane.ERROR_MESSAGE);
return;
}
//調(diào)用CheckUser類中的方法刪除用戶
boolean succeed=cUser.deleteOperator(id);
if(!succeed)
JOptionPane.showMessageDialog(this, "系統(tǒng)中存在與該用戶相關的信息，現(xiàn)在不能刪除該用戶！", "錯誤",
JOptionPane.ERROR_MESSAGE);
else
{
//刷新列表顯示
JButton refreshButton=DBNavToolBar.getRefreshButton();
refreshButton.doClick();
JOptionPane.showMessageDialog(this, "已成功刪除該用戶！", "提示",
JOptionPane.PLAIN_MESSAGE);
}
}
void modify_actionPerformed(ActionEvent e) {
JButton postButton=DBNavToolBar.getPostButton();
postButton.doClick();
JButton saveButton=DBNavToolBar.getSaveButton();
saveButton.doClick();
JOptionPane.showMessageDialog(this, "已成功提交修改信息！", "提示",
JOptionPane.PLAIN_MESSAGE);
}
}
class OperatorConfig_cancel_actionAdapter implements java.awt.event.ActionListener {
OperatorConfig adaptee;
OperatorConfig_cancel_actionAdapter(OperatorConfig adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.cancel_actionPerformed(e);
}
}
class OperatorConfig_ok_actionAdapter implements java.awt.event.ActionListener {
OperatorConfig adaptee;
OperatorConfig_ok_actionAdapter(OperatorConfig adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.ok_actionPerformed(e);
}
}
class OperatorConfig_deleteUser_actionAdapter implements java.awt.event.ActionListener {
OperatorConfig adaptee;
OperatorConfig_deleteUser_actionAdapter(OperatorConfig adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.deleteUser_actionPerformed(e);
}
}
class OperatorConfig_modify_actionAdapter implements java.awt.event.ActionListener {
OperatorConfig adaptee;
OperatorConfig_modify_actionAdapter(OperatorConfig adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.modify_actionPerformed(e);
}
}?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -