📄 systemmanagewindow.java
字号:
dealer.show(deck,"c3");
}
else if(e.getActionCommand().equals("系统设置"))
{
dealer.show(deck,"c4");
count=0;
}
else if(e.getActionCommand().equals("数据备份"))
{
DataBase_Sever d=new DataBase_Sever();
/*DataBase_Sever d1=new DataBase_Sever();
d.select("oldPath", "");
File file;
String s="";
//try{
try {
while(d.rs.next()){
s=d.rs.getString("OldPath");
file=new File(s.replace('\\', '/'));
if(file.exists()==false){
d1.delete("oldPath", " where OldPath='"+s+"'");
}
}
d.rs.close();
} catch (SQLException ex) {
// TODO Auto-generated catch block
ex.printStackTrace();
}
//}catch(SQLException ex1){}
d.closeDB();*/
String path="";
d.select("oldPath", "");
int c1=0;
try{
while(d.rs.next()){
path=d.rs.getString("OldPath").replace('\\', '/');
c1++;
}
d.rs.close();
}catch(SQLException ex1){}
d.closeDB();
if(c1==0){
JOptionPane.showMessageDialog(null, "数据库中没有当前数据库路径");
}
else{
fileChooser.setFileSelectionMode
(JFileChooser.DIRECTORIES_ONLY);
result=fileChooser.showSaveDialog(this);
fileChooser.setApproveButtonText("备份");
if(result==JFileChooser.CANCEL_OPTION)
{
return;
}
else if(result==JFileChooser.APPROVE_OPTION){
File fileName = fileChooser.getSelectedFile();
File file=new File(fileName.getAbsolutePath());
if(fileName.getAbsolutePath().trim().endsWith("\\")){
JOptionPane.showMessageDialog(null, "您未输入复制出的文件名");
}
else if(fileName == null || fileName.getAbsolutePath().trim().equals(""))
{
JOptionPane.showMessageDialog(this,"无效的文件名",
"无效的文件名",JOptionPane.ERROR_MESSAGE);
}
else if(fileName.isDirectory()){
JOptionPane.showMessageDialog(null, "请打开您选择的路径");
}
else if(file.exists()){
JOptionPane.showMessageDialog(null, "文件已存在");
}
else{
if(!fileName.getAbsolutePath().trim().endsWith(".mdb")){
JOptionPane.showMessageDialog(null, "复制文件扩展名非.mdb 请记住用Windows Access打开");
}
try{
copyFile(path, fileName.getAbsolutePath());
}catch (java.io.FileNotFoundException e1) {
JOptionPane.showMessageDialog(null, "复制文件操作出错,或许路径选择为光驱或移动设备且设备未就绪");
return;
}
catch (Exception e2) {
JOptionPane.showMessageDialog(null, "复制文件操作出错");
return;
}
d.insert("newPath", "('"+fileName.getAbsolutePath()+"')");
JOptionPane.showMessageDialog(null, "备份成功");
}
}
}
}
else if(e.getActionCommand().equals("锁定屏幕"))
{
frame.show();
}
else if(e.getActionCommand().equals("确定"))
{
String s1="",s2="";
if (t111.getText().trim().equals(""))
{
JOptionPane.showMessageDialog(null, "请先输入管理员帐号");
}
else {
s1=t111.getText().trim();
s2=t211.getText().trim();
if(!s1.equals(Main.manager))
{
JOptionPane.showMessageDialog(null, "帐号错误");
t111.setText("");
t211.setText("");
}
else
{
if(s2.equals(Main.pass)){
frame.dispose();
}
else{
JOptionPane.showMessageDialog(null, "密码错误");
t111.setText("");
t211.setText("");
}
}
}
}
else if(e.getActionCommand().equals("数据恢复"))
{
DataBase_Sever d=new DataBase_Sever();
/*DataBase_Sever d1=new DataBase_Sever();
File file;
String s="";
d.select("newPath", "");
// try{
try {
while(d.rs.next()){
s=d.rs.getString("NewPath");
file=new File(s.replace('\\', '/'));
if(file.exists()==false){
d1.delete("newPath", " where NewPath='"+s+"'");
}
}
d.rs.close();
} catch (SQLException ex) {
// TODO Auto-generated catch block
ex.printStackTrace();
}
// }catch(SQLException ex1){}
d.closeDB();
DataBase_Sever d2=new DataBase_Sever();*/
String path="";
d.select("newPath", "");
int c1=0;
try{
while(d.rs.next()){
path=d.rs.getString("NewPath").replace('\\', '/');
c1++;
}
d.rs.close();
}catch(SQLException ex1){}
d.closeDB();
if(c1==0){
JOptionPane.showMessageDialog(null, "数据未曾备份,无法恢复");
}
else{
String[] doc = new String[]{"mdb"};
fileChooser.addChoosableFileFilter
(new SimpleFileFilter(doc,"Document (*.mdb)"));
fileChooser.setFileSelectionMode
(JFileChooser.FILES_AND_DIRECTORIES);
fileChooser.setApproveButtonText("恢复");
result=fileChooser.showSaveDialog(this);
if(result==JFileChooser.APPROVE_OPTION){
File fileName = fileChooser.getSelectedFile();
if(fileName.getAbsolutePath().trim().endsWith("\\")){
JOptionPane.showMessageDialog(null, "您未输入复制出的文件名");
}
else if(fileName == null || fileName.getAbsolutePath().trim().equals(""))
{
JOptionPane.showMessageDialog(this,"无效的文件名",
"无效的文件名",JOptionPane.ERROR_MESSAGE);
}
else if(fileName.isDirectory()){
JOptionPane.showMessageDialog(null, "请打开您选择的路径");
}
else{ if(!fileName.getAbsolutePath().trim().endsWith(".mdb")){
JOptionPane.showMessageDialog(null, "复制文件扩展名非.mdb 请记住用Windows Access打开");
}
try{
copyFile(fileName.getAbsolutePath(), "D:/workspace/LabraryManageSystem/labraryManager/library.mdb");
}catch (java.io.FileNotFoundException e1) {
JOptionPane.showMessageDialog(null, "复制文件操作出错,或许路径选择为光驱或移动设备且设备未就绪");
return;
}
catch (Exception e2) {
JOptionPane.showMessageDialog(null, "复制文件操作出错");
return;
}
JOptionPane.showMessageDialog(null, "恢复成功");
}
}
else if(result==JFileChooser.CANCEL_OPTION)
{
return;
}
}
}
else if(e.getActionCommand().equals("口令更改"))
{
dealer.show(deck,"c7");
count=1;
}
else if(e.getActionCommand().equals("锁定屏幕"))
{
}
else if(e.getActionCommand().equals("管理员操作"))
{
if(Main.level!=1){
JOptionPane.showMessageDialog(null, "管理员权限不足");
}
else {dealer.show(deck,"c5");
bank="administer";}
}
else if(e.getActionCommand().equals("返回主界面"))
{
MainWindow x=new MainWindow();
x.setVisible(true);
dispose();
}
else if(e.getActionCommand().equals("退出程序"))
{
ConfirmWindow x=new ConfirmWindow();
x.setVisible(true);
}
else if(e.getActionCommand().equals("上移"))
{
if(bank.equals("book")){
ss1=t11.getText().trim();
ss2=t13.getText().trim();
ss3=t14.getText().trim();
ss4=t15.getText().trim();
ss5=t16.getText().trim();
ss6=t17.getText().trim();
ss7=t18.getText().trim();
Vector v=new Vector();
String sss1="";
String sss2="";
String sss3="";
String sss4="";
String sss5="";
String sss6="";
String sss7="";
String sss8="";
if(ss1.equals("")&&ss2.equals("")&&ss3.equals("")
&&ss4.equals("")&&ss5.equals("")&&ss6.equals("")&&ss7.equals("")){
JOptionPane.showMessageDialog(null, "输入内容不能为空!");
}
else if(ss1.equals("")){
JOptionPane.showMessageDialog(null, "请输入图书编号");
}
else{
if(ss1.equals("")){sss1="";}else{if(ss2.equals("")&&ss3.equals("")
&&ss4.equals("")&&ss5.equals("")&&ss6.equals("")&&ss7.equals("")&&ss8.equals(""))sss1="BookID='"+ss1+"'";
else sss1="BookID='"+ss1+"' and ";}
if(ss2.equals("")){sss2="";}else{if(ss3.equals("")&&ss4.equals("")
&&ss5.equals("")&&ss6.equals("")&&ss7.equals("")&&ss8.equals(""))sss2="BookName='"+ss2+"'";
else sss2="BookName='"+ss2+"' and ";}
if(ss3.equals("")){sss3="";}else{if(ss4.equals("")&&ss5.equals("")
&&ss6.equals("")&&ss7.equals("")&&ss8.equals(""))sss3="Author='"+ss3+"'";
else sss3="Author='"+ss3+"' and ";}
if(ss4.equals("")){sss4="";}else{if(ss5.equals("")
&&ss6.equals("")&&ss7.equals("")&&ss8.equals(""))sss4="Publisher='"+ss4+"'";
else sss4="Publisher='"+ss4+"' and ";}
if(ss5.equals("")){sss5="";}else{if(ss6.equals("")&&ss7.equals("")
&&ss8.equals(""))sss5="BookPrice='"+ss5+"'";
else sss5="BookPrice='"+ss5+"' and ";}
if(ss6.equals("")){sss6="";}else{if(ss7.equals("")
&&ss8.equals(""))sss6="Abstract='"+ss6+"'";
else sss6="Abstract='"+ss6+"' and ";}
if(ss7.equals("")){sss7="";}else{sss7="Class='"+ss7+"'";}
int count=0;
DataBase_Sever d=new DataBase_Sever();
d.select(bank, "where "+sss1+sss2+sss3+sss4+sss5+sss6+sss7);
try{
while(d.rs.next()){
count++;
}
d.rs.close();
}catch(SQLException ex1){}
d.closeDB();
if(count==0)
{
JOptionPane.showMessageDialog(null, "符合条件内容不存在");
}
else{
d.select(bank, "");
v=d.getData(d.rs);
v.trimToSize();
try {
d.rs.close();
} catch (SQLException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}
d.closeDB();
int i;
for ( i=1;i<v.size();i++){
if(ss1.equals(((Vector)v.elementAt(i)).elementAt(0))){
break;
}
}
if(i>1){
sss1=(String)((Vector)v.elementAt(i-1)).elementAt(0);
sss2=(String)((Vector)v.elementAt(i-1)).elementAt(1);
sss3=(String)((Vector)v.elementAt(i-1)).elementAt(2);
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -