📄 systemmanagewindow.java
字号:
t3.setText(sss2);
t4.setText(sss3);
t5.setText(sss4);
t6.setText(sss5);
t7.setText(sss6);
}
else{
JOptionPane.showMessageDialog(null, "已经到底了");return;
}
}
}
}
else if(bank.equals("administer")){
ss1=t21.getText().trim();
ss2=t22.getText().trim();
ss3=t23.getText().trim();
ss4=t24.getText().trim();
ss5=t25.getText().trim();
Vector v=new Vector();
String sss1="";
String sss2="";
String sss3="";
if(ss1.trim().equals("")&&ss2.trim().equals("")&&ss3.trim().equals("")&&ss4.trim().equals("")&&ss5.trim().equals("")){
JOptionPane.showMessageDialog(null, "输入内容不能为空!");return;
}
else if(ss1.trim().equals("")||!ss3.trim().equals("")||!ss5.trim().equals("")){
JOptionPane.showMessageDialog(null, "只能根据ID下移");return;
}
else{
if(ss1.trim().equals("")){sss1="";}else{if(ss2.trim().equals("")
)sss1="WorkerID='"+ss1+"'";
else sss1="WorkerID='"+ss1+"' and ";}
if(ss2.trim().equals("")){sss2="";}else{
sss2="Account='"+ss2+"' ";}
int count=0;
DataBase_Sever d=new DataBase_Sever();
d.select(bank, "where "+sss1+sss2);
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<v.size()-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(3);
t21.setText(sss1);
t22.setText(sss2);
t24.setText(sss3);
}
else{
JOptionPane.showMessageDialog(null, "已经到底了");return;
}
}
}
}
}
else if(e.getActionCommand().equals("添加"))
{
if(bank.equals("book")){
t19.setText("在库");
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();
ss8=t19.getText().trim();
int n1=0;
double n2=0;
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(ss2.equals("")){
JOptionPane.showMessageDialog(null, "图书书名为必填内容");
}
else if(!ss8.equals("在库")){
JOptionPane.showMessageDialog(null, "添加图书状态只能为在库");
}
else{
try{
n1=Integer.parseInt(ss1);
if(n1<0){
JOptionPane.showMessageDialog(null, "图书编号不能为负");return;
}
}catch(NumberFormatException e0){JOptionPane.showMessageDialog(null, "图书编号应为整数");return;}
try{
n2=Double.parseDouble(ss5);
if(n2<0){
JOptionPane.showMessageDialog(null, "图书单价不能为负");return;
}
}catch(NumberFormatException e0){JOptionPane.showMessageDialog(null, "图书单价应为实数");return;}
int count=0;
DataBase_Sever d=new DataBase_Sever();
d.select(bank, "where BookID='"+ss1+"'");
try{
while(d.rs.next()){
count++;
}
d.rs.close();
}catch(SQLException ex1){}
d.closeDB();
if(count!=0)
{
JOptionPane.showMessageDialog(null, "帐号已存在");
}
else{
d.insert(bank, "('"+ss1+"','"+ss2+"','"+ss3+"','"
+ss4+"','"+ss5+"','"+ss6+"','"+ss7+"','在库')");
JOptionPane.showMessageDialog(null, "添加成功");
}
}
}
else if(bank.equals("reader")){
ss1=t1.getText().trim();
ss2=t3.getText().trim();
ss3=t4.getText().trim();
ss4=t5.getText().trim();
ss5=t6.getText().trim();
ss6=t7.getText().trim();
long n1=0;
if(ss1.equals("")&&ss2.equals("")&&ss3.equals("")
&&ss4.equals("")&&ss5.equals("")&&ss6.equals("")){
JOptionPane.showMessageDialog(null, "输入内容不能为空!");
}
else if(ss1.equals("")){
JOptionPane.showMessageDialog(null, "请输入读者编号");
}
else if(ss2.equals("")){
JOptionPane.showMessageDialog(null, "读者姓名为必填内容");
}
else if(ss3.equals("")){
JOptionPane.showMessageDialog(null, "读者权限为必填内容");
}
else{
try{
try{
n1=Long.parseLong(ss1);
if(n1<0){
JOptionPane.showMessageDialog(null, "读者编号不能为负");return;
}
}catch(NumberFormatException e0){JOptionPane.showMessageDialog(null, "读者编号应为整数");return;}
if(!ss5.equals("")){
try{
n1=Long.parseLong(ss5);
if(n1<0){
JOptionPane.showMessageDialog(null, "电话号码不能为负");return;
}
}catch(NumberFormatException e0){JOptionPane.showMessageDialog(null, "电话号码应只由数字组成");return;}
}
int count=0;
DataBase_Sever d=new DataBase_Sever();
d.select(bank, "where ReaderID='"+ss1+"'");
try{
while(d.rs.next()){
count++;
}
d.rs.close();
}catch(SQLException ex1){}
d.closeDB();
if(count!=0)
{
JOptionPane.showMessageDialog(null, "帐号已存在");
}
else{
n1=Long.parseLong(ss3);
if(n1<0){
JOptionPane.showMessageDialog(null, "权限不能为负");return;
}
if(n1!=1&&n1!=2){
JOptionPane.showMessageDialog(null, "读者权限只有1、2等级");
}
else{d.insert(bank, "('"+ss1+"','"+ss2+"','"+ss3+"','"
+ss4+"','"+ss5+"','"+ss6+"')");
d.insert("configuration", "('"+ss1+"','4','30')");
JOptionPane.showMessageDialog(null, "添加成功");}
}
}catch(NumberFormatException e0){JOptionPane.showMessageDialog(null, "权限应为整数");}
}
}
else if(bank.equals("administer")){
ss1=t21.getText().trim();
ss2=t22.getText().trim();
ss3=t23.getText().trim();
ss4=t24.getText().trim();
ss5=t25.getText().trim();
long n1=0;
if(ss1.equals("")||ss2.equals("")||ss3.equals("")||ss4.equals("")||ss5.equals("")){
JOptionPane.showMessageDialog(null, "各项均为必填内容");return;
}
if(!(ss3.equals(ss5))){
JOptionPane.showMessageDialog(null, "密码确认不一致");return;
}
else{
try{
try{
n1=Long.parseLong(ss1);
if(n1<0){
JOptionPane.showMessageDialog(null, "管理员编号不能为负");return;
}
}catch(NumberFormatException e0){JOptionPane.showMessageDialog(null, "管理员编号应为整数");return;}
int count=0;
DataBase_Sever d=new DataBase_Sever();
d.select(bank, "where WorkerID='"+ss1+"'");
try{
while(d.rs.next()){
count++;
}
d.rs.close();
}catch(SQLException ex1){}
d.closeDB();
int count1=0;
d.select(bank, "where Account='"+ss2+"'");
try{
while(d.rs.next()){
count1++;
}
d.rs.close();
}catch(SQLException ex1){}
d.closeDB();
if(count!=0)
{
JOptionPane.showMessageDialog(null, "ID已存在");
}
else if(count!=0)
{
JOptionPane.showMessageDialog(null, "帐号已存在");
}
else{
n1=Long.parseLong(ss4);
if(n1<0){
JOptionPane.showMessageDialog(null, "权限不能为负");return;
}
if(n1!=1&&n1!=2){
JOptionPane.showMessageDialog(null, "管理员权限只有1、2等级");
}
else {d.insert(bank, "('"+ss1+"','"+ss2+"','"+ss3+"','"
+ss4+"')");
JOptionPane.showMessageDialog(null, "添加成功");
}
}
}catch(NumberFormatException e0){JOptionPane.showMessageDialog(null, "权限应为整数");}
}
}
}
else if(e.getActionCommand().equals("删除"))
{
if(bank.equals("book")){
t19.setText("在库");
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();
String sss1="";
String sss2="";
String sss3="";
String sss4="";
String sss5="";
String sss6="";
String sss7="";
if(ss1.equals("")&&ss2.equals("")&&ss3.equals("")
&&ss4.equals("")&&ss5.equals("")&&ss6.equals("")&&ss7.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.delete(bank, "where "+sss1+sss2+sss3+sss4+sss5+sss6+sss7);
JOptionPane.showMessageDialog(null, "删除成功");
}
}
}
else if(bank.equals("reader")){
ss1=t1.getText().trim();
ss2=t3.getText().trim();
ss3=t4.getText().trim();
ss4=t5.getText().trim();
ss5=t6.getText().trim();
ss6=t7.getText().trim();
String sss1="";
String sss2="";
String sss3="";
String sss4="";
String sss5="";
String sss6="";
if(ss1.equals("")&&ss2.equals("")&&ss3.equals("")
&&ss4.trim().equals("")&&ss5.trim().equals("")&&ss6.trim().equals("")){
JOptionPane.showMessageDialog(null, "输入内容不能为空!");
}
else{
if(ss1.trim().equals("")){sss1="";}else{if(ss2.trim().equals("")&&ss3.trim().equals("")
&&ss4.trim().equals("")&&ss5.trim().equals("")&&ss6.trim().equals(""))sss1="ReaderID='"+ss1+"'";
else sss1="ReaderID='"+ss1+"' and ";}
if(ss2.trim().equals("")){sss2="";}else{if(ss3.trim().equals("")&&ss4.trim().equals(⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -