package Frame;
|
import java.awt.BorderLayout;
|
import java.awt.Color;
|
import java.awt.Container;
|
import java.awt.Dimension;
|
import java.awt.Toolkit;
|
import java.awt.event.ActionEvent;
|
import java.awt.event.ActionListener;
|
import java.awt.event.KeyEvent;
|
import java.awt.event.KeyListener;
|
import java.util.Iterator;
|
import java.util.List;
|
import java.util.Vector;
|
import javax.swing.Box;
|
import javax.swing.ButtonGroup;
|
import javax.swing.ImageIcon;
|
import javax.swing.JCheckBox;
|
import javax.swing.JDialog;
|
import javax.swing.JPanel;
|
import javax.swing.JPasswordField;
|
import javax.swing.JRadioButton;
|
import javax.swing.JScrollPane;
|
import javax.swing.JTable;
|
import javax.swing.JTextField;
|
import javax.swing.table.DefaultTableModel;
|
|
import ColorAndFont.English;
|
import ColorAndFont.UIColor;
|
import ColorAndFont.buttonTitle;
|
import DataBase.DatabaseManagement;
|
import Method.GetNowTime;
|
import PbuliClass.ImExport;
|
import PbuliClass.JButtonModel;
|
import PbuliClass.JlableModel;
|
import PbuliClass.ShowMessage;
|
import PbuliClass.Systems;
|
import PbuliClass.WarningMessage;
|
import PbuliClass.greateTables;
|
import PbuliClass.jinternalFrame;
|
|
/**´ËÀàÓÃÓÚÓû§¹ÜÀí*/
|
@SuppressWarnings("rawtypes")
|
public class UserManage extends jinternalFrame {
|
|
/**
|
*
|
*/
|
private static final long serialVersionUID = 1L;
|
|
JPanel northJpanel=null;//±±²¿Ãæ°å
|
JTextField searchFileld=null;//ËÑË÷Îı¾¿ò
|
JButtonModel search=null;//ËÑË÷°´Å¥
|
JButtonModel shuaxin=null;//ˢа´Å¥
|
JButtonModel xiu_gai=null;//Ð޸İ´Å¥
|
JButtonModel delete=null;//ɾ³ý°´Å¥
|
JButtonModel deleteAll=null;//È«²¿É¾³ý°´Å¥
|
JButtonModel outport=null;//µ¼³ö±í¸ñ°´Å¥
|
JButtonModel add=null;
|
JTable table=null;//ÉêÃ÷±í¸ñ
|
Vector rowData=null;
|
DefaultTableModel tableModel;//±í¸ñÄ£ÐÍ
|
int selectedRow;//±»Ñ¡ÖеÄÐÐ
|
List list;
|
|
public UserManage() {
|
rowData=new Vector();
|
String title="Óû§¹ÜÀí";
|
if(Systems.sys().getLanguage().equals("English")) {
|
title="User Management";
|
}
|
this.setTitle(title);
|
Container rq=getContentPane();//»ñÈ¡ÈÝÆ÷
|
rq.setLayout(new BorderLayout());
|
rq.setBackground(Color.white);
|
rq.add(getNorthJpanel(),BorderLayout.NORTH);
|
rq.add(getGd());
|
this.setFrameIcon(new ImageIcon("image/icon/usericon.png"));//ÉèÖô°Ìåͼ±ê
|
|
}
|
|
/**»ñÈ¡±±²¿Ãæ°å*/
|
public JPanel getNorthJpanel() {
|
if(northJpanel==null) {
|
northJpanel=new JPanel();
|
Box topicBox = Box.createHorizontalBox();// ´´½¨Ò»¸öˮƽÏäÈÝÆ÷
|
topicBox.add(getSearchFileld());//Ìí¼ÓËÑË÷Îı¾¿ò
|
topicBox.add(Box.createHorizontalStrut(3));// Ìí¼ÓÒ»¸ö3ÏñËØ¿íµÄˮƽ֧Öù
|
topicBox.add(getSearch());//Ìí¼ÓËÑË÷°´Å¥
|
topicBox.add(Box.createHorizontalStrut(5));// Ìí¼ÓÒ»¸ö5ÏñËØ¿íµÄˮƽ֧Öù
|
topicBox.add(getShuaxin());//Ìí¼Óˢа´Å¥
|
topicBox.add(Box.createHorizontalStrut(5));// Ìí¼ÓÒ»¸ö5ÏñËØ¿íµÄˮƽ֧Öù
|
topicBox.add(getAdd());//Ìí¼Óˢа´Å¥
|
topicBox.add(Box.createHorizontalStrut(5));// Ìí¼ÓÒ»¸ö5ÏñËØ¿íµÄˮƽ֧Öù
|
topicBox.add(getXiu_gai());//Ìí¼ÓÐ޸İ´Å¥
|
topicBox.add(Box.createHorizontalStrut(5));// Ìí¼ÓÒ»¸ö5ÏñËØ¿íµÄˮƽ֧Öù
|
topicBox.add(getDelete());//Ìí¼Óɾ³ý°´Å¥
|
topicBox.add(Box.createHorizontalStrut(5));// Ìí¼ÓÒ»¸ö5ÏñËØ¿íµÄˮƽ֧Öù
|
topicBox.add(getDeleteAll());//Ìí¼Óɾ³ýÈ«²¿°´Å¥
|
topicBox.add(Box.createHorizontalStrut(5));// Ìí¼ÓÒ»¸ö5ÏñËØ¿íµÄˮƽ֧Öù
|
topicBox.add(getOutport());//Ìí¼Óµ¼³ö°´Å¥
|
northJpanel.add(topicBox );
|
}
|
|
return northJpanel;
|
}
|
|
|
|
/**»ñÈ¡ËÑË÷Îı¾¿òµÄ·½·¨*/
|
public JTextField getSearchFileld() {
|
if(searchFileld==null){
|
searchFileld=new JTextField(10);
|
searchFileld.addKeyListener(new KeyListener() { //¼üÅÌʼþ¼àÌý
|
public void keyTyped(KeyEvent e) {
|
}
|
public void keyReleased(KeyEvent e) {
|
int keyCode=e.getKeyCode();
|
if(keyCode==KeyEvent.VK_ENTER) {
|
getSearch().doClick();//ËÑË÷°´Å¥±»µã»÷
|
}
|
}
|
public void keyPressed(KeyEvent e) {
|
}
|
});
|
}
|
return searchFileld;
|
}
|
|
|
/**»ñÈ¡ËÑË÷°´Å¥µÄ·½·¨*/
|
public JButtonModel getSearch() {
|
if(search==null){
|
search=new JButtonModel(buttonTitle.getSerch());
|
search.addActionListener(new ActionListener() {
|
public void actionPerformed(ActionEvent e) {
|
// Ö´ÐÐSQL²éѯÓï¾ä»ñµÃµÄ½á¹û¼¯
|
try {
|
|
if(getSearchFileld().getText().length()>=1) {
|
String go=getSearchFileld().getText();
|
String serch="select id,username,superuser,deleteq,alertq,deleteall,justlook,addtime "
|
+ "from tb_user where username like'"+go+"%'";
|
updateSerch(serch);
|
}
|
} catch (Exception er) {
|
er.printStackTrace();
|
}
|
}
|
});
|
}
|
return search;
|
}
|
|
|
/**»ñȡˢа´Å¥µÄ·½·¨*/
|
public JButtonModel getShuaxin() {
|
if(shuaxin==null){
|
shuaxin=new JButtonModel(buttonTitle.getRefresh());
|
shuaxin.addActionListener(new ActionListener() {
|
public void actionPerformed(ActionEvent e) {
|
updateTable();
|
}
|
});
|
|
}
|
return shuaxin;
|
}
|
|
/**ÐÂÔöÓû§°´Å¥µÄ·½·¨*/
|
public JButtonModel getAdd() {
|
if(add==null){
|
add=new JButtonModel(buttonTitle.getAddOne());
|
add.addActionListener(new ActionListener() {
|
public void actionPerformed(ActionEvent e) {
|
new add_Dialog(buttonTitle.getAddOne());
|
}
|
});
|
}
|
return add;
|
}
|
|
/**»ñÈ¡Ð޸İ´Å¥µÄ·½·¨*/
|
public JButtonModel getXiu_gai() {
|
if(xiu_gai==null){
|
xiu_gai=new JButtonModel(buttonTitle.getAlert());
|
xiu_gai.addActionListener(new ActionListener() {
|
public void actionPerformed(ActionEvent e) {
|
int[] selectedRows=table.getSelectedRows();//±»Ñ¡ÖÐÐеÄË÷Òý¼¯ºÏ
|
if(selectedRows.length !=0) {
|
new xiu_gai("ÐÞ¸ÄÓû§ÐÅÏ¢");
|
}
|
else {
|
ShowMessage.zidingyi("ÇëÑ¡ÖÐÐèÒªÐ޸ĵÄÐУ¡");
|
}
|
updateTable();
|
|
}
|
});
|
}
|
return xiu_gai;
|
}
|
|
/**»ñȡɾ³ý°´Å¥µÄ·½·¨*/
|
public JButtonModel getDelete() {
|
if(delete==null){
|
delete=new JButtonModel(buttonTitle.getDelete());
|
delete.addActionListener(new ActionListener() {
|
public void actionPerformed(ActionEvent e) {
|
|
int[] selectedRows=table.getSelectedRows();//±»Ñ¡ÖÐÐеÄË÷Òý¼¯ºÏ
|
int ok=0;
|
if(selectedRows.length !=0) {
|
for(int i=0;i<selectedRows.length;i++){
|
String hang=(String)table.getValueAt(selectedRows[i], 0);
|
if(hang.equals("1")) {
|
ShowMessage.zidingyi("³¬¼¶¹ÜÀíÔ±²»ÄÜɾ³ý");
|
return;
|
}
|
String deleteSql="DELETE FROM tb_user WHERE id='"+hang+"'";
|
ok=DatabaseManagement.update(deleteSql);// ɾ³ýÓû§¹ÜÀíÊý¾Ý¿âÐÅÏ¢
|
}
|
//ɾ³ý³É¹¦ÌáʾÐÅÏ¢
|
if(ok==1) {
|
updateTable();//ˢбí¸ñ
|
ShowMessage.zidingyi(selectedRows.length+"Ìõ¼Ç¼ɾ³ý³É¹¦£¡");
|
}else {
|
ShowMessage.zidingyi("ɾ³ýÊý¾Ý³ö´í£¡");
|
}
|
}
|
else {
|
ShowMessage.zidingyi( "ÇëÑ¡ÖÐÐèҪɾ³ýµÄÐУ¡");
|
}
|
updateTable();
|
}
|
});
|
}
|
return delete;
|
}
|
|
|
/**»ñÈ¡È«²¿É¾³ý°´Å¥µÄ·½·¨*/
|
public JButtonModel getDeleteAll() {
|
if(deleteAll==null){
|
deleteAll=new JButtonModel(buttonTitle.getDeleteall());
|
deleteAll.setEnabled(false);
|
deleteAll.addActionListener(new ActionListener() {
|
public void actionPerformed(ActionEvent e) {
|
//Ñ¡Ôñ¶Ô»°¿òÈçyes·µ»Ø0£¬NO·µ»Ø1£¬È¡Ïû·µ»Ø2
|
WarningMessage warning=new WarningMessage();
|
warning.setMessage("Ñ¡Ôñɾ³ýÈ«²¿½«»á°Ñ±í¸ñÊý¾ÝÈ«²¿É¾³ýÈ·¶¨Âð£¿");
|
int warn=warning.getwarMss(northJpanel );
|
int tagnum=table.getRowCount();//±í¸ñ×ÜÐÐÊý
|
if(tagnum!=0 && warn==0) {
|
String deleteSql="TRUNCATE TABLE tb_user";
|
DatabaseManagement.update(deleteSql);// ɾ³ýËùÓмǼ
|
ShowMessage.zidingyi("È«²¿É¾³ý³É¹¦£¡");
|
}
|
updateTable();//ˢбí¸ñ
|
}
|
});
|
|
}
|
return deleteAll;
|
}
|
|
/**»ñÈ¡µ¼³ö±í¸ñ°´Å¥µÄ·½·¨*/
|
public JButtonModel getOutport() {
|
if(outport==null){
|
outport=new JButtonModel("µ¼³ö±í¸ñ");
|
outport.setEnabled(false);
|
outport.addActionListener(new ActionListener() {
|
public void actionPerformed(ActionEvent e) {
|
WarningMessage warning=new WarningMessage();
|
warning.setMessage("µ¼ÈëÊý¾Ý±ØÐëÏÈÏÂÔØÄ£°å£¬°´ÕÕÄ£°å¸ñʽµ¼Èë...");
|
int warn=warning.getwarMss(getNorthJpanel());
|
if( warn==0) {
|
String sql= "select * from tb_user";
|
new ImExport().export(northJpanel, sql);
|
}
|
}
|
});
|
|
}
|
return outport;
|
}
|
|
/**»ñÈ¡¹ö¶¯Ãæ°åµÄ·½·¨*/
|
public JScrollPane getGd() {
|
JScrollPane gd=new JScrollPane(getTable());
|
gd.getViewport().setBackground(UIColor.getNorth_color());
|
return gd;
|
}
|
|
|
/**Ìí¼Ó±í¸ñÐÐÏòÁ¿Êý¾Ý·½·¨*/
|
@SuppressWarnings("unchecked")
|
public void getRowData(List list ) {
|
Iterator iterator = list.iterator();//´´½¨µü´úÆ÷
|
while (iterator.hasNext()) {//µü´úÆ÷´æÔÚÔªËØ
|
List info = (List) iterator.next();//½«µü´úÆ÷ÀïÃæµÄÔªËظøµ½info¼¯ºÏ
|
Vector<String> row = new Vector<>();
|
for(int i=0;i<info.size();i++) {
|
row.add(String.valueOf(info.get(i)));
|
}
|
rowData.add(row);// Ïò±í¸ñ¶ÔÏóÌí¼ÓÐÐÊý¾Ý
|
}
|
|
}
|
|
|
/**»ñÈ¡¸ñµÄ·½·¨*/
|
@SuppressWarnings("serial")
|
public JTable getTable() {
|
if(table==null) {
|
String[] name1= {"ÐòºÅ","Óû§Ãû","¼¶±ð","ɾ³ý","ÐÞ¸Ä","È«²¿É¾³ý","½ö¹Û¿´","Ìí¼Óʱ¼ä"};//±í¸ñÁÐÃû
|
String[] name2= {"Serial Number","User Name","Level","Delete","Modify",
|
"Delete All","View Only","Add Time"};//±í¸ñÁÐÃû
|
String[] columnNames=English.columnNames(name1, name2);
|
//Ìí¼Ó±í¸ñÁÐÏòÁ¿
|
Vector<String> columnName=new Vector<>();
|
for(int i=0;i<columnNames.length;i++){
|
columnName.add(columnNames[i]);
|
}
|
String sql="select id,username,superuser,deleteq,alertq,deleteall,justlook,addtime from tb_user";
|
list = DatabaseManagement.serch(sql);//½«ÁбíÖÐËùÓнá¹û¼¯¸øµ½list¼¯ºÏ
|
getRowData(list );
|
greateTables tables=new greateTables();
|
tableModel=new DefaultTableModel(rowData, columnName){
|
// ʵÏÖÈÃÕû¸ö±í¸ñ²»²»ÔÊÐí±»±à¼
|
public boolean isCellEditable(int row,int column){
|
return false;
|
}
|
};
|
table=tables.getTable(tableModel);
|
}
|
return table;
|
}
|
|
|
/**ˢбí¸ñ·½·¨*/
|
public void updateTable() {
|
int tagnum=getTable().getRowCount();//±í¸ñ×ÜÐÐÊý
|
if(tagnum !=0 ) {
|
for (int i = 0; i < tagnum; i++) {//ɾ³ýËùÓÐÐÐ
|
tableModel.removeRow(0);//ɾ³ýËùÓÐÐÐ
|
}
|
String sql="select id,username,superuser,deleteq,alertq,deleteall,justlook,addtime from tb_user";
|
list = DatabaseManagement.serch(sql);//½«ÁбíÖÐËùÓнá¹û¼¯¸øµ½list¼¯ºÏ
|
getRowData(list);
|
}
|
}
|
|
/**»ñÈ¡±í¸ñ±»Ñ¡ÖеÄÐз½·¨*/
|
public int getSelectedRow() {
|
selectedRow=getTable().getSelectedRow();
|
return selectedRow;
|
|
}
|
|
/**ËÑË÷·½·¨*/
|
public void updateSerch(String serch) {
|
int tagnum=getTable().getRowCount();//±í¸ñ×ÜÐÐÊý
|
if(tagnum !=0 ) {
|
for (int i = 0; i < tagnum; i++) {//ɾ³ýËùÓÐÐÐ
|
tableModel.removeRow(0);
|
}
|
list = DatabaseManagement.serch(serch);//½«ÁбíÖÐËùÓнá¹û¼¯¸øµ½list¼¯ºÏ
|
getRowData(list);
|
}
|
}
|
|
//ÄÚ²¿Àà
|
class add_Dialog extends JDialog{
|
|
/**
|
*
|
*/
|
private static final long serialVersionUID = 1L;
|
|
|
JButtonModel que_ding=null;//È·¶¨°´Å¥
|
JButtonModel qu_xiao=null;//È¡Ïû°´Å¥
|
JPanel mb=null;//ÉêÃ÷Ò»¸öÃæ°å
|
JTextField userNameText=null;//ÊäÈëÓû§Ãû
|
JPasswordField passwordText=null;//ÃÜÂë
|
JPasswordField password2Text=null;//ÔÙ´ÎÊäÈëÃÜÂë
|
JRadioButton manage=new JRadioButton("¹ÜÀíÔ±");
|
JRadioButton fang_ke=new JRadioButton("·Ã¿Í");
|
JCheckBox delete=new JCheckBox("ɾ³ý");
|
JCheckBox alert=new JCheckBox(buttonTitle.getAlert());
|
JCheckBox alldelete=new JCheckBox("ȫɾ");
|
ButtonGroup group=new ButtonGroup();
|
String id;
|
|
|
public add_Dialog(String title) {
|
this.setAlwaysOnTop(true);//×ÜÊÇÖö¥
|
group.add(manage);
|
group.add(fang_ke);
|
Toolkit toolkit = getToolkit();// »ñµÃ´°Ì幤¾ß°ü
|
Dimension screenSize = toolkit.getScreenSize();// »ñÈ¡ÆÁÄ»´óС
|
int width = (int) (screenSize.width* 0.5);// ¼ÆËã´°Ìåпí¶È
|
int height = (int) (screenSize.height * 0.5);// ¼ÆËã´°Ìåпí¶È
|
int x0=width-180;//´°Ìåx0×ø±ê
|
int y0=height-175;//´°Ìåy0×ø±ê
|
Container rq=getContentPane();
|
rq.add(getMb());
|
this.setTitle(title);
|
this.setBounds(x0, y0, 360,350);
|
this.setVisible(true);
|
}
|
|
/**»ñÈ¡Ãæ°å*/
|
public JPanel getMb() {
|
if(mb==null){
|
mb=new JPanel();
|
mb.setLayout(null);
|
JlableModel userName=new JlableModel("Óû§Ãû£º ");
|
JlableModel password=new JlableModel("ÃÜÂ룺");
|
JlableModel password2=new JlableModel("Öظ´ÃÜÂ룺");
|
JlableModel ji_bie=new JlableModel("¼¶±ð£º");
|
JlableModel quan_xian=new JlableModel("ȨÏÞ£º");
|
passwordText=new JPasswordField(25);//ÃÜÂë
|
password2Text=new JPasswordField(25);//ÔÙ´ÎÊäÈëÃÜÂë
|
|
userName.setBounds(30, 20, 80, 25);
|
password.setBounds(30, 65, 80, 25);
|
password2.setBounds(30, 110, 80, 25);
|
ji_bie.setBounds(30, 155, 50, 25);
|
quan_xian.setBounds(30, 200, 50, 25);
|
|
getUserNameText().setBounds(120, 20, 80, 25);
|
passwordText.setBounds(120, 65, 80, 25);
|
password2Text.setBounds(120, 110, 80, 25);
|
manage.setSelected(true);
|
manage.setBounds(80, 155, 80, 25);
|
fang_ke.setBounds(170, 155,70, 25);
|
delete.setBounds(80, 200, 60, 25);
|
alert.setBounds(160, 200, 60, 25);
|
alldelete.setBounds(240, 200,60, 25);
|
getQue_ding().setBounds(80, 255, 50, 25);
|
getQu_xiao().setBounds(150, 255, 50, 25);
|
|
|
mb.add(userName);
|
mb.add(password);
|
mb.add(password2);
|
mb.add(ji_bie);
|
mb.add(quan_xian);
|
mb.add(getUserNameText());
|
mb.add(passwordText);
|
mb.add(password2Text);
|
mb.add(manage);
|
mb.add(fang_ke);
|
mb.add(delete);
|
mb.add(alert);
|
mb.add(alldelete);
|
mb.add(getQue_ding());
|
mb.add(getQu_xiao());
|
|
}
|
|
return mb;
|
}
|
|
/**»ñÈ¡È·¶¨°´Å¥µÄ·½·¨*/
|
public JButtonModel getQue_ding() {
|
if(que_ding==null){
|
que_ding=new JButtonModel("È·¶¨");
|
que_ding.addActionListener(new ActionListener() {
|
public void actionPerformed(ActionEvent e) {
|
String name=userNameText.getText().trim();
|
if(name.equals("")) {
|
ShowMessage.zidingyi("Óû§Ãû²»ÄÜΪ¿Õ£¡");
|
return;
|
}
|
if(name.length()>15) {
|
ShowMessage.zidingyi("Óû§Ãû¹ý³¤£¡");
|
return;
|
}
|
String pass1= String.valueOf(passwordText.getPassword());
|
String pass2= String.valueOf(password2Text.getPassword());
|
if(pass1.equals("")) {
|
ShowMessage.zidingyi("ÃÜÂë²»ÄÜΪ¿Õ£¡");
|
return;
|
}
|
if(!pass1.equals(pass2)) {
|
ShowMessage.zidingyi("Á½´ÎÊäÈëµÄÃÜÂë²»Ò»ÑùÇë´ÓÐÂÊäÈëÃÜÂ룡");
|
return;
|
}
|
String justlook="·ñ";
|
String deletet="·ñ";
|
String alertt="·ñ";
|
String deleteallt="·ñ";
|
|
String superuser="·Ã¿Í";
|
if(manage.isSelected()) {
|
superuser="¹ÜÀíÔ±";
|
}
|
|
if(fang_ke.isSelected()) {
|
justlook="ÊÇ";
|
}
|
if(delete.isSelected()) {
|
deletet="ÊÇ";
|
}
|
if(alert.isSelected()) {
|
alertt="ÊÇ";
|
}
|
if(alldelete.isSelected()) {
|
deleteallt="ÊÇ";
|
}
|
insertData(name, pass1, superuser, deletet, alertt, deleteallt, justlook);
|
}
|
});
|
|
}
|
return que_ding;
|
}
|
|
public void insertData(String name,String pass1,String superuser,String deletet,String alertt,String deleteallt,String justlook) {
|
String insertSql="INSERT tb_user VALUES (default,'"+name+
|
"',PASSWORD('"+pass1+
|
"'),'"+superuser+
|
"','"+deletet+
|
"','"+alertt+
|
"','"+deleteallt+
|
"','"+justlook+
|
"','"+GetNowTime.now()+"')";
|
|
int ok=DatabaseManagement.update(insertSql);
|
if(ok==1) {
|
updateTable();//ˢбí¸ñ
|
ShowMessage.zidingyi("Êý¾ÝдÈë³É¹¦£¡");
|
}else {
|
ShowMessage.zidingyi("дÈëÊý¾Ý¿â³ö´í£¡");
|
}
|
|
}
|
|
/**»ñÈ¡È¡Ïû°´Å¥µÄ·½·¨*/
|
public JButtonModel getQu_xiao() {
|
if(qu_xiao==null){
|
qu_xiao=new JButtonModel("È¡Ïû");
|
qu_xiao.addActionListener(new ActionListener() {
|
public void actionPerformed(ActionEvent e) {
|
closeTagDialog();
|
}
|
});
|
|
}
|
return qu_xiao;
|
}
|
|
public JTextField getUserNameText() {
|
if(userNameText==null) {
|
userNameText=new JTextField(25);
|
}
|
return userNameText;
|
|
}
|
|
|
/**¹Ø±Õ¶Ô»°¿ò·½·¨*/
|
public void closeTagDialog() {
|
this.dispose();
|
}
|
|
}
|
|
class xiu_gai extends add_Dialog{
|
|
/**
|
*
|
*/
|
private static final long serialVersionUID = 1L;
|
|
String xu_hao;
|
|
|
public xiu_gai(String title) {
|
super(title);
|
// TODO ×Ô¶¯Éú³ÉµÄ¹¹Ô캯Êý´æ¸ù
|
selectedRow=table.getSelectedRow();
|
xu_hao=(String)table.getValueAt(selectedRow,0);
|
String name=(String)table.getValueAt(selectedRow,1);
|
getUserNameText().setText(name);
|
getUserNameText().setEnabled(false);
|
String row3=(String)table.getValueAt(selectedRow,2);
|
String row4=(String)table.getValueAt(selectedRow,3);
|
String row5=(String)table.getValueAt(selectedRow,4);
|
String row6=(String)table.getValueAt(selectedRow,5);
|
if(row3.equals("¹ÜÀíÔ±")) {
|
manage.setSelected(true);
|
}else {
|
fang_ke.setSelected(true);
|
}
|
if(row4.equals("ÊÇ")) {
|
delete.setSelected(true);
|
}
|
if(row5.equals("ÊÇ")) {
|
alert.setSelected(true);
|
}
|
if(row6.equals("ÊÇ")) {
|
alldelete.setSelected(true);
|
}
|
}
|
|
|
/**»ñÈ¡È·¶¨°´Å¥µÄ·½·¨*/
|
public JButtonModel getQue_ding() {
|
if(que_ding==null){
|
que_ding=new JButtonModel("È·¶¨");
|
que_ding.addActionListener(new ActionListener() {
|
public void actionPerformed(ActionEvent e) {
|
String pass1= String.valueOf(passwordText.getPassword());
|
String pass2= String.valueOf(password2Text.getPassword());
|
if(pass1.equals("")) {
|
ShowMessage.zidingyi("ÃÜÂë²»ÄÜΪ¿Õ£¡");
|
return;
|
}
|
if(!pass1.equals(pass2)) {
|
ShowMessage.zidingyi("Á½´ÎÊäÈëµÄÃÜÂë²»Ò»ÑùÇë´ÓÐÂÊäÈëÃÜÂ룡");
|
return;
|
}
|
String justlook="·ñ";
|
String deletet="·ñ";
|
String alertt="·ñ";
|
String deleteallt="·ñ";
|
|
String superuser="·Ã¿Í";
|
if(manage.isSelected()) {
|
superuser="¹ÜÀíÔ±";
|
}
|
|
if(fang_ke.isSelected()) {
|
justlook="ÊÇ";
|
}
|
if(delete.isSelected()) {
|
deletet="ÊÇ";
|
}
|
if(alert.isSelected()) {
|
alertt="ÊÇ";
|
}
|
if(alldelete.isSelected()) {
|
deleteallt="ÊÇ";
|
}
|
String update="UPDATE tb_user SET password=PASSWORD('"+pass1+
|
"'),superuser='"+superuser+
|
"',deleteq='"+deletet+
|
"',alertq='"+alertt+
|
"',deleteall='"+deleteallt+
|
"',justlook='"+justlook+
|
"'where id='"+xu_hao+"'";
|
ShowMessage.save(DatabaseManagement.update(update));
|
updateTable();//ˢбí¸ñ
|
}
|
});
|
|
}
|
return que_ding;
|
}
|
|
}
|
|
|
}
|
