📄 systemmanagewindow.java
字号:
sss4=(String)((Vector)v.elementAt(i-1)).elementAt(3);
sss5=(String)((Vector)v.elementAt(i-1)).elementAt(4);
sss6=(String)((Vector)v.elementAt(i-1)).elementAt(5);
sss7=(String)((Vector)v.elementAt(i-1)).elementAt(6);
sss8=(String)((Vector)v.elementAt(i-1)).elementAt(7);
t11.setText(sss1);
t13.setText(sss2);
t14.setText(sss3);
t15.setText(sss4);
t16.setText(sss5);
t17.setText(sss6);
t18.setText(sss7);
t19.setText(sss8);
}
else{
JOptionPane.showMessageDialog(null, "已经到顶了");return;
}
}
}
}
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();
Vector v=new Vector();
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.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("")
&&ss5.trim().equals("")&&ss6.trim().equals(""))sss2="Name='"+ss2+"'";
else sss2="Name='"+ss2+"' and ";}
if(ss3.trim().equals("")){sss3="";}else{if(ss4.trim().equals("")&&ss5.trim().equals("")
&&ss6.trim().equals(""))sss3="ReaderLevel='"+ss3+"'";
else sss3="ReaderLevel='"+ss3+"' and ";}
if(ss4.trim().equals("")){sss4="";}else{if(ss5.trim().equals("")
&&ss6.trim().equals(""))sss4="Address='"+ss4+"'";
else sss4="Address='"+ss4+"' and ";}
if(ss5.trim().equals("")){sss5="";}else{if(ss6.trim().equals(""))sss5="TelephoneNumber='"+ss5+"'";
else sss5="TelephoneNumber='"+ss5+"' and ";}
if(ss6.trim().equals("")){sss6="";}else{ sss6="Email='"+ss6+"'";}
int count=0;
DataBase_Sever d=new DataBase_Sever();
d.select(bank, "where "+sss1+sss2+sss3+sss4+sss5+sss6);
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);
sss4=(String)((Vector)v.elementAt(i-1)).elementAt(3);
sss5=(String)((Vector)v.elementAt(i-1)).elementAt(4);
sss6=(String)((Vector)v.elementAt(i-1)).elementAt(5);
t1.setText(sss1);
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>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")){
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<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(2);
sss4=(String)((Vector)v.elementAt(i+1)).elementAt(3);
sss5=(String)((Vector)v.elementAt(i+1)).elementAt(4);
sss6=(String)((Vector)v.elementAt(i+1)).elementAt(5);
sss7=(String)((Vector)v.elementAt(i+1)).elementAt(6);
sss8=(String)((Vector)v.elementAt(i+1)).elementAt(7);
t11.setText(sss1);
t13.setText(sss2);
t14.setText(sss3);
t15.setText(sss4);
t16.setText(sss5);
t17.setText(sss6);
t18.setText(sss7);
t19.setText(sss8);
}
else{
JOptionPane.showMessageDialog(null, "已经到底了");return;
}
}
}
}
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();
Vector v=new Vector();
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.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("")
&&ss5.trim().equals("")&&ss6.trim().equals(""))sss2="Name='"+ss2+"'";
else sss2="Name='"+ss2+"' and ";}
if(ss3.trim().equals("")){sss3="";}else{if(ss4.trim().equals("")&&ss5.trim().equals("")
&&ss6.trim().equals(""))sss3="ReaderLevel='"+ss3+"'";
else sss3="ReaderLevel='"+ss3+"' and ";}
if(ss4.trim().equals("")){sss4="";}else{if(ss5.trim().equals("")
&&ss6.trim().equals(""))sss4="Address='"+ss4+"'";
else sss4="Address='"+ss4+"' and ";}
if(ss5.trim().equals("")){sss5="";}else{if(ss6.trim().equals(""))sss5="TelephoneNumber='"+ss5+"'";
else sss5="TelephoneNumber='"+ss5+"' and ";}
if(ss6.trim().equals("")){sss6="";}else{ sss6="Email='"+ss6+"'";}
int count=0;
DataBase_Sever d=new DataBase_Sever();
d.select(bank, "where "+sss1+sss2+sss3+sss4+sss5+sss6);
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(2);
sss4=(String)((Vector)v.elementAt(i+1)).elementAt(3);
sss5=(String)((Vector)v.elementAt(i+1)).elementAt(4);
sss6=(String)((Vector)v.elementAt(i+1)).elementAt(5);
t1.setText(sss1);
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -