📄 busxiugai.java.bak
字号:
package pro;
import java.awt.*;
import java.util.*;
import javax.swing.*;
import java.sql.*;
import java.awt.event.*;
import javax.swing.table.*;
//此类用于数据处理
public class BusXiuGai
{
private Connection con;
private java.sql.Statement st;
String seendand;
public BusXiuGai()
{
try
{
con=DatabaseConnection.getConnection();
st=con.createStatement();
}
catch(Exception ex)
{
ex.printStackTrace();
}
}
public int sleSCompany(String ststa) //获得表名
{
int i=3;
if(ststa.equals("长沙巴士股份有限公司"))
{
i=0;
}
if(ststa.equals("湖南巴士公共交通有限公司"))
{
i=1;
}
if(ststa.equals("湖南龙骧巴士有限责任公司"))
{
i=2;
}
return i;
}
public boolean busdele(String ststa) //删除线路
{
int is=0,i=0;
String stdel="";
String stsle="select SCompany from SumBus where SBusName='"+ststa+"'";
String[] strin={"CSBashi","HNBashi","Longxiang","QiTa"};
try
{
ResultSet re=st.executeQuery(stsle);
if(re.next())
{
stdel=re.getString(1);
}
re.close();
i=this.sleSCompany(stdel);
String str="delete from SumBus where SBusName='"+ststa+"'";
is=st.executeUpdate(str);
str="delete from "+strin[i] +" where "+strin[i].substring(0,1)+"BusName='"+ststa+"'";
System.out.println(str);
is=is+st.executeUpdate(str);
}
catch(Exception ex)
{
ex.printStackTrace();
}
if(is==2)
{
return true;
}
else
{
return false;
}
}
public boolean businsert(VoSumBus bus) //新线路插入
{
int i=0;
String str="insert SumBus values(?,?,?,?,?,?,?,?,?,default,?)";
String[] strin={"CSBashi","HNBashi","Longxiang","QiTa"};
try
{
PreparedStatement pre=con.prepareStatement(str);
pre.setString(1,bus.getSBusName());
pre.setString(2,bus.getSStartArea());
pre.setString(3,bus.getSEndArea());
pre.setString(4,bus.getSGoUp());
pre.setString(5,bus.getSGoDown());
pre.setString(6,bus.getSStartTime());
pre.setString(7,bus.getSendTime());
pre.setInt(8,bus.getScarfare());
pre.setFloat(9,bus.getSLength());
pre.setString(10,bus.getSCompany());
i=pre.executeUpdate();
pre.close();
str="insert "+strin[sleSCompany(bus.getSCompany())]+" values(?,?,?,?,?,?,?,?,?,default,?)";
System.out.println(str);
PreparedStatement pre2=con.prepareStatement(str);
pre2.setString(1,bus.getSBusName());
pre2.setString(2,bus.getSStartArea());
pre2.setString(3,bus.getSEndArea());
pre2.setString(4,bus.getSGoUp());
pre2.setString(5,bus.getSGoDown());
pre2.setString(6,bus.getSStartTime());
pre2.setString(7,bus.getSendTime());
pre2.setInt(8,bus.getScarfare());
pre2.setFloat(9,bus.getSLength());
pre2.setString(10,bus.getSCompany());
i=i+pre2.executeUpdate();
pre2.close();
}
catch(Exception ec)
{
ec.printStackTrace();
}
if(i==2)
{
return true;
}
else
{
return false;
}
}
public boolean busupdate(VoSumBus bus) //修改线路
{
String[] strin={"CSBashi","HNBashi","Longxiang","QiTa"};
String ste="update SumBus set SBusName=?,SStartArea=?,SEndArea=?,SGoUp=?,SGoDown=?,";
ste=ste+"SStartTime=?,SendTime=?,Scarfare=?,SLength=?,SCompany=? ";
ste=ste+" where SBusName=?";
System.out.println(ste);
int i=0,t=0;
try
{
PreparedStatement pre=con.prepareStatement(ste);
pre.setString(1,bus.getSBusName());
pre.setString(2,bus.getSStartArea().trim());
pre.setString(3,bus.getSEndArea().trim());
pre.setString(4,bus.getSGoUp().trim());
pre.setString(5,bus.getSGoDown());
pre.setString(6,bus.getSStartTime().trim());
pre.setString(7,bus.getSendTime().trim());
pre.setInt(8,bus.getScarfare());
pre.setFloat(9,bus.getSLength());
pre.setString(10,bus.getSCompany().trim());
pre.setString(11,bus.getSBusName().trim());
i=pre.executeUpdate();
pre.close();
t=sleSCompany(bus.getSCompany());
System.out.println("----------"+t+"-----"+bus.getSCompany());
String ev=strin[t].substring(0,1);
ste="update "+strin[t] +" set "+ev+"BusName=?,"+ev+"StartArea=?,"+ev+"EndArea=?,"+ev+"GoUp=?,"+ev+"GoDown=?,";
ste=ste+ev+"StartTime=?,"+ev+"endTime=?,"+ev+"carfare=?,"+ev+"Length=?,"+ev+"Company=?";
ste=ste+" where "+ev+"BusName=?";
System.out.println(ste);
PreparedStatement pre2=con.prepareStatement(ste);
pre2.setString(1,bus.getSBusName());
pre2.setString(2,bus.getSStartArea().trim());
pre2.setString(3,bus.getSEndArea().trim());
pre2.setString(4,bus.getSGoUp().trim());
pre2.setString(5,bus.getSGoDown());
pre2.setString(6,bus.getSStartTime().trim());
pre2.setString(7,bus.getSendTime().trim());
pre2.setInt(8,bus.getScarfare());
pre2.setFloat(9,bus.getSLength());
pre2.setString(10,bus.getSCompany().trim());
pre2.setString(11,bus.getSBusName().trim());
i=i+pre2.executeUpdate();
pre2.close();
}
catch(Exception ec)
{
ec.printStackTrace();
}
if(i>=2)
{
return true;
}
else
{
return false;
}
}
public boolean Zhandelete(String Zhan) //站点删除
{
int i=0;
String[] strin={"AE","FK","LQ","RW","XX"};
String ste="delete from AZ where AEname='"+Zhan+"'" ;
try
{
i=st.executeUpdate(ste);
for(int g=0;g<strin.length;g++)
{
ste="delete from "+strin[g]+" where "+strin[g]+"name='"+Zhan+"'" ;
i=i+st.executeUpdate(ste);
}
}
catch(Exception ec)
{
ec.printStackTrace();
}
if(i==2)
{
return true;
}
else
{
return false;
}
}
public boolean Zhanupdate(String Zhan,String newZhan) //站点修改
{
int i=0;
String[] strin={"AE","FK","LQ","RW","XX"};
String ste="update SumBus set SGoUp=";
ste=ste+"replace(SGoUp,'- "+Zhan+" -','- "+newZhan+" -')";
ste=ste+", SGoDown=replace(SGoUp,'- "+Zhan+" -','- "+newZhan+" -'),";
ste=ste+"SStartArea=replace(SStartArea,'"+Zhan+"','"+newZhan+"'),";
ste=ste+"SEndArea=replace(SEndArea,'"+Zhan+"','"+newZhan+"')";
try
{
i=st.executeUpdate(ste);
for(int ii=0;ii<strin.length;ii++)
{
ste="update "+strin[ii]+" set "+strin[ii].substring(0,2)+"name=replace("+strin[ii].substring(0,2)+"name,'"+Zhan+"','"+newZhan+"')";
i=i+st.executeUpdate(ste);
}
ste="update AZ set AEname=replace(AEname,'"+Zhan+"','"+newZhan+"')";
i=st.executeUpdate(ste);
}
catch(Exception ex)
{
ex.printStackTrace();
}
if(i>=2)
{
return true;
}
else
{
return false;
}
}
public boolean Zhaninsert(String Zhan,String tt) //新站点插入
{
int i=0,g=0;
String see=",";
char xx=tt.charAt(0);
String[] strin={"AE","FK","LQ","RW","XX"};
String str="insert AZ values(?,?,?)";
for(int ii=0;ii<strin.length;ii++)
{
if(ii==4&&xx>=strin[ii].charAt(ii) && xx<='Z')
{
g=ii;
break;
}
if(xx>=strin[ii].charAt(0) && xx<=strin[ii].charAt(1))
{
g=ii;
break;
}
}
try
{
PreparedStatement pre=con.prepareStatement(str);
pre.setString(1,Zhan);
pre.setString(2,"");
pre.setString(3,tt);
i=pre.executeUpdate();
pre.close();
str="insert "+strin[g]+" values(?,?,?)";
PreparedStatement pre1=con.prepareStatement(str);
pre1.setString(1,Zhan);
pre1.setString(2,"");
pre1.setString(3,tt);
i=pre1.executeUpdate();
pre1.close();
str="select SBusName from SumBus ";//SGoUp like '%- "+Zhan+" -%'"+" or SGoDown like '%- "+Zhan+" -%'";
str=str+" where (SGoUp like '%- %[(]"+Zhan+"[)] -%' or SGoUp like '%- "+Zhan+"(%) -%' or SGoUp like '%- "+Zhan+" -%') or ";
str=str+"(SGoDown like '%- %[(]"+Zhan+"[)] -%' or SGoDown like '%- "+Zhan+"(%) -%' or SGoDown like '%- "+Zhan+" -%')";
ResultSet re=st.executeQuery(str);
while(re.next())
{
see=see+re.getString(1)+",";
}
str="update AZ set AEbus='"+see+"'"+" where AEname='"+Zhan+"'";
i=st.executeUpdate(str);
str="update "+strin[g]+" set "+strin[g]+"bus='"+see+"'"+" where "+strin[g]+"name='"+Zhan+"'";
i=st.executeUpdate(str);
}
catch(java.lang.Exception ex)
{
ex.printStackTrace();
}
if(i<=1)
{
return true;
}
else
{
return false;
}
}
}⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -