📄 systemoperategui.java
字号:
package GUI;
import java.awt.BorderLayout;
import java.awt.CardLayout;
import java.awt.Color;
import java.awt.Container;
import java.awt.Dimension;
import java.awt.FlowLayout;
import java.awt.Font;
import java.awt.GridLayout;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.event.WindowAdapter;
import java.awt.event.WindowEvent;
import java.io.FileOutputStream;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import javax.swing.BorderFactory;
import javax.swing.JButton;
import javax.swing.JFileChooser;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JPanel;
import javax.swing.JTextArea;
import javax.swing.JTextField;
import javax.swing.border.BevelBorder;
import shujuku.*;
public class SystemOperateGUI extends JFrame implements ActionListener
{
CardLayout dealer;JPanel deckPanel;
private JTextField[] t1=new JTextField[8],
t2=new JTextField[6],t3=new JTextField[3],t4=new JTextField[3],t5=new JTextField[4];
String[] tii=new String[8];
public void actionPerformed(ActionEvent e)
{
String dj=e.getActionCommand();
if(e.getActionCommand().equals("返回主界面"))
dispose();
else if(e.getActionCommand().equals("退出程序"))
{WindowConfirm guig=new WindowConfirm();}
else if (e.getActionCommand().equals("读者库操作")) {
dealer.show(deckPanel, "dzkcz");
}
else if (e.getActionCommand().equals("添加 ")){
try {for (int i=0;i<6;i++){tii[i]=t2[i].getText();//System.out.println(tii[i]);
}SQLMethod sql=new SQLMethod();
sql.addreaderData(tii[0], tii[1], tii[2], tii[3], tii[4], tii[5]);//SQL
JOptionPane.showMessageDialog(this," 添加成功！！！！！！ ");
}
catch (ClassNotFoundException e0) {
//e.printStackTrace();
} catch (Exception e1) {
//e.printStackTrace();
}}
else if (e.getActionCommand().equals("修改 "))
{ try {for (int i=0;i<6;i++){tii[i]=t2[i].getText();
//System.out.println(tii[i]);
}SQLMethod sql=new SQLMethod();
sql.ReaderUpdate(tii[0], tii[1], tii[2], tii[3], tii[4], tii[5]);//SQL
JOptionPane.showMessageDialog(this," 修改成功！！！！！！！ ");
}
catch (ClassNotFoundException e0) {
e0.printStackTrace();
} catch (Exception e1) {
e1.printStackTrace();
}}
else if (e.getActionCommand().equals("删除 ")){
try{SQLMethod sql=new SQLMethod();//System.out.println(t1[0].getText());
sql.deletereader(t2[0].getText());//SQLproblem 改了
JOptionPane.showMessageDialog(this," 删除成功！！！！！！！ ");}
//System.out.println(t1[0].getText());}
catch (ClassNotFoundException e0) {
//e.printStackTrace();
} catch (Exception e1) {
//e.printStackTrace();
}}
else if (e.getActionCommand().equals("上移 ")){
String[] sa1=new String[6];SQLMethod Search=new SQLMethod();
String s=t2[0].getText();int num=Integer.parseInt(s);
String ss=String.valueOf(num-1);String sss=String.valueOf(num);
//System.out.println(ss);
if (num==1001){JOptionPane.showMessageDialog(this," 已经到顶！！！！！ ");
String sr1=Search.xitongdu(sss,0);//System.out.println(sr1);
sa1[0]=sr1.substring(0,sr1.indexOf("读"));//System.out.println(sr1);
sa1[1]=sr1.substring(sr1.indexOf("读"),sr1.indexOf("读者权限"));
sa1[2]=sr1.substring(sr1.indexOf("读者权限"),sr1.indexOf("联系方式"));
sa1[3]=sr1.substring(sr1.indexOf("联系方式"),sr1.indexOf("号码"));
sa1[4]=sr1.substring(sr1.indexOf("号码"),sr1.indexOf("邮箱"));
sa1[5]=sr1.substring(sr1.indexOf("邮箱"));
for (int i=0;i<6;i++){t2[i].setText(sa1[i]);}}
else {String sr1=Search.xitongdu(ss,0);//System.out.println(sr1);
sa1[0]=sr1.substring(0,sr1.indexOf("读"));//System.out.println(sr1);
sa1[1]=sr1.substring(sr1.indexOf("读"),sr1.indexOf("读者权限"));
sa1[2]=sr1.substring(sr1.indexOf("读者权限"),sr1.indexOf("联系方式"));
sa1[3]=sr1.substring(sr1.indexOf("联系方式"),sr1.indexOf("号码"));
sa1[4]=sr1.substring(sr1.indexOf("号码"),sr1.indexOf("邮箱"));
sa1[5]=sr1.substring(sr1.indexOf("邮箱"));
for (int i=0;i<6;i++){t2[i].setText(sa1[i]);}}}
else if (e.getActionCommand().equals("下移 ")){
String[] sa1=new String[6];SQLMethod Search=new SQLMethod();
String s=t2[0].getText();int num=Integer.parseInt(s);
String ss=String.valueOf(num+1);
String sr1=Search.xitongdu(ss,0);//System.out.println(ss);
if (sr1.equals("")){JOptionPane.showMessageDialog(this," 已经到底！！！！！ ");}
else {//System.out.println(sr1);
sa1[0]=sr1.substring(0,sr1.indexOf("读"));//System.out.println(sr1);
sa1[1]=sr1.substring(sr1.indexOf("读"),sr1.indexOf("读者权限"));
sa1[2]=sr1.substring(sr1.indexOf("读者权限"),sr1.indexOf("联系方式"));
sa1[3]=sr1.substring(sr1.indexOf("联系方式"),sr1.indexOf("号码"));
sa1[4]=sr1.substring(sr1.indexOf("号码"),sr1.indexOf("邮箱"));
sa1[5]=sr1.substring(sr1.indexOf("邮箱"));
for (int i=0;i<6;i++){t2[i].setText(sa1[i]);}}}//System.out.println(sa1[i]);}}}
else if (e.getActionCommand().equals("数据统计")) {
dealer.show(deckPanel, "sjtj");
}else if (e.getActionCommand().equals("系统设置")) {
dealer.show(deckPanel, "xtsz");
} else if(e.getActionCommand().equals("数据备份"))
{
JFileChooser c;
c=new JFileChooser();
c.showOpenDialog(this);
PrintWriter out=null;
try
{
out=new PrintWriter(new FileOutputStream(c.getSelectedFile()));
}catch(Exception o)
{
}
try
{
String dbUrl = "jdbc:odbc:db1";
String user = "";
String password = "";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
dj="SELECT * FROM 读者";
Connection cc = DriverManager.getConnection(
dbUrl, user, password);
Statement s = cc.createStatement();
out.println("*WorkId Account Password Level");
ResultSet r=s.executeQuery("SELECT * FROM 读者");// WHERE 读者号='"+iii+"'");
while(r.next())
{
out.print(r.getString(9)+" "+r.getString(10)+" "
+r.getString(11)+" "+r.getString(12)+" ");
out.println("");
}
SystemUse l=new SystemUse();
out.println(l.fan());
out.println(l.fan1());
cc.close();
out.close();
s.close();
r.close();
}
catch(Exception ee) {
//System.out.println("ERROR");
//System.out.println(ee.getMessage());
}}
else if(e.getActionCommand().equals("数据恢复"))
{
JFileChooser c=new JFileChooser();
c.showOpenDialog(this);
}else if (e.getActionCommand().equals("口令更改")) {
dealer.show(deckPanel, "klgg");}
else if (e.getActionCommand().equals("更改")){
try {for (int i=0;i<4;i++){tii[i]=t5[i].getText();//System.out.println(tii[i]);
}SQLMethod sql=new SQLMethod();
sql.changepass(LinkToDB.buildlinktodb(),tii[0], tii[1], tii[2], tii[3]);
JOptionPane.showMessageDialog(this," 更改成功！！！！！！ ");
}
catch (ClassNotFoundException e0) {
//e.printStackTrace();
} catch (Exception e1) {
//e.printStackTrace();
}
}else if (e.getActionCommand().equals("锁定屏幕")) {for(int i=0;i<8;i++)
{
t1[i].setEditable(false);
}
for(int i=0;i<6;i++)
{
t2[i].setEditable(false);
}
for(int i=0;i<3;i++)
{
t3[i].setEditable(false);
}
for(int i=0;i<3;i++)
{
t4[i].setEditable(false);
}
for(int i=0;i<4;i++)
{
t5[i].setEditable(false);
}}
else if (e.getActionCommand().equals("图书库操作")) {
dealer.show(deckPanel, "tskcz");}
else if (e.getActionCommand().equals("上移")){
String[] sa1=new String[8];SQLMethod Search=new SQLMethod();
String s=t1[0].getText();int num=Integer.parseInt(s);
String ss=String.valueOf(num-1);//System.out.println(ss);
String sss=String.valueOf(num);
if (num==1){JOptionPane.showMessageDialog(this," 已经到顶！！！！！ ");
String sr1=Search.xitongcha(2,sss,false);//System.out.println(sr1);
sa1[0]=sr1.substring(0,sr1.indexOf("图"));//System.out.println(sr1);
sa1[1]=sr1.substring(sr1.indexOf("图"),sr1.indexOf("图书作者"));
sa1[2]=sr1.substring(sr1.indexOf("图书作者"),sr1.indexOf("图书出版社"));
sa1[3]=sr1.substring(sr1.indexOf("图书出版社"),sr1.indexOf("图书单价"));
sa1[4]=sr1.substring(sr1.indexOf("图书单价"),sr1.indexOf("关键字"));
sa1[5]=sr1.substring(sr1.indexOf("关键字"),sr1.indexOf("类别"));
sa1[6]=sr1.substring(sr1.indexOf("类别"),sr1.indexOf("图书状态"));
sa1[7]=sr1.substring(sr1.indexOf("图书状态"));
for (int i=0;i<8;i++){t1[i].setText(sa1[i]);}}
else {String sr1=Search.xitongcha(2,ss,false);//System.out.println(sr1);
sa1[0]=sr1.substring(0,sr1.indexOf("图"));//System.out.println(sr1);
sa1[1]=sr1.substring(sr1.indexOf("图"),sr1.indexOf("图书作者"));
sa1[2]=sr1.substring(sr1.indexOf("图书作者"),sr1.indexOf("图书出版社"));
sa1[3]=sr1.substring(sr1.indexOf("图书出版社"),sr1.indexOf("图书单价"));
sa1[4]=sr1.substring(sr1.indexOf("图书单价"),sr1.indexOf("关键字"));
sa1[5]=sr1.substring(sr1.indexOf("关键字"),sr1.indexOf("类别"));
sa1[6]=sr1.substring(sr1.indexOf("类别"),sr1.indexOf("图书状态"));
sa1[7]=sr1.substring(sr1.indexOf("图书状态"));
for (int i=0;i<8;i++){t1[i].setText(sa1[i]);}}}
else if (e.getActionCommand().equals("下移")){
String[] sa1=new String[8];SQLMethod Search=new SQLMethod();
String s=t1[0].getText();int num=Integer.parseInt(s);
String ss=String.valueOf(num+1);
String sr1=Search.xitongcha(2,ss,false);
//System.out.println(ss);
if (sr1.equals("")){JOptionPane.showMessageDialog(this," 已经到底！！！！！ ");}
else {//System.out.println(sr1);
sa1[0]=sr1.substring(0,sr1.indexOf("图"));//System.out.println(sr1);
sa1[1]=sr1.substring(sr1.indexOf("图"),sr1.indexOf("图书作者"));
sa1[2]=sr1.substring(sr1.indexOf("图书作者"),sr1.indexOf("图书出版社"));
sa1[3]=sr1.substring(sr1.indexOf("图书出版社"),sr1.indexOf("图书单价"));
sa1[4]=sr1.substring(sr1.indexOf("图书单价"),sr1.indexOf("关键字"));
sa1[5]=sr1.substring(sr1.indexOf("关键字"),sr1.indexOf("类别"));
sa1[6]=sr1.substring(sr1.indexOf("类别"),sr1.indexOf("图书状态"));
sa1[7]=sr1.substring(sr1.indexOf("图书状态"));
for (int i=0;i<8;i++){t1[i].setText(sa1[i]);}}}
else if (e.getActionCommand().equals("添加")){
try {for (int i=0;i<8;i++){tii[i]=t1[i].getText();//System.out.println(tii[i]);
}SQLMethod sql=new SQLMethod();
sql.addbookData(tii[0], tii[1], tii[2], tii[3], tii[4], tii[5], tii[6], tii[7]);
JOptionPane.showMessageDialog(this," 添加成功！！！！！！！！ ");
}
catch (ClassNotFoundException e0) {
//e.printStackTrace();
} catch (Exception e1) {
//e.printStackTrace();
}}
else if (e.getActionCommand().equals("删除")){
try{SQLMethod sql=new SQLMethod();//System.out.println(t1[0].getText());
sql.deletebook(t1[0].getText());//SQLproblem 改了
JOptionPane.showMessageDialog(this," 删除成功！！！！！！！ ");}
//System.out.println(t1[0].getText());}
catch (ClassNotFoundException e0) {
//e.printStackTrace();
} catch (Exception e1) {
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -