📄 busxiugai.java
字号:
/*此类负责线路与站点的增,删,改的数据库操作*/
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) //删除线路
{
// String strSql="delete from SumBus where SBusName='"+ststa+"'";
// try
// {
// int count=st.executeUpdate(strSql);
// return(count>0?true:false);
//
// }catch(java.sql.SQLException sqle){
// sqle.printStackTrace();
// return false;
// }
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());
try{
pre.setString(6,bus.getSStartTime());
}catch(java.sql.SQLException sqle)
{
javax.swing.JOptionPane.showMessageDialog(null,"请输入上行路径经过的站点！","提示",JOptionPane.INFORMATION_MESSAGE);
}
try
{
pre.setString(7,bus.getSendTime());
}catch(java.sql.SQLException sqle)
{
javax.swing.JOptionPane.showMessageDialog(null,"请输入上行路径经过的站点！","提示",JOptionPane.INFORMATION_MESSAGE);
}
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)
{javax.swing.JOptionPane.showMessageDialog(null,"时间的输入格式不对!请输入正确的格式(如6:00或者6:00:00)","提示",1);
// 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=?";
int i=0,t=0;
try
{
PreparedStatement pre=con.prepareStatement(ste);
pre.setString(1,bus.getSBusName().trim());
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)
{
javax.swing.JOptionPane.showMessageDialog(null,"时间的输入格式不对!请输入正确的格式(如6:00或者6:00:00)","提示",1);
return false;
}
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++)
{
String strFirst=CnToSpell.getFirstSpell(Zhan);
String strf=CnToSpell.getFirstSpell(newZhan);
// if(strFirst.equals(strf))
// {
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);
// }
// else
// {
// String s=strin[ii]+"name";
// String strdelete="delete strin[ii] where s='"+Zhan+"'";
//
// String strSql="insert into ";
// i=i+st.executeUpdate(strdelete);
//
// }
}
String strFirst=CnToSpell.getFirstSpell(Zhan);
String strf=CnToSpell.getFirstSpell(newZhan);
ste="update AZ set AEname='"+newZhan+"'"+",AEmark='"+strf+"'"+"where AEname='"+Zhan+"'";
i+=st.executeUpdate(ste);
}
catch(Exception ex)
{
ex.printStackTrace();
}
if(i>=2)
{
return true;
}
else
{
return false;
}
}
public boolean Zhaninsert(String Zhan) //新站点插入
{
String strAZ=CnToSpell.getFirstSpell(Zhan);
String strSql="insert into AZ(AEname,AEmark) values(?,?)";
try
{
java.sql.PreparedStatement ps=con.prepareStatement(strSql);
ps.setString(1,Zhan.trim());
ps.setString(2,strAZ.trim());
int count=ps.executeUpdate();
return(count>0?true:false);
}catch(java.sql.SQLException sqle)
{
sqle.printStackTrace();
return false;
}
// 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.trim());
// pre.setString(2,"");
// pre.setString(3,tt.trim());
// i=pre.executeUpdate();
// pre.close();
// str="insert "+strin[g]+" values(?,?,?)";
// PreparedStatement pre1=con.prepareStatement(str);
// pre1.setString(1,Zhan.trim());
// pre1.setString(2,"");
// pre1.setString(3,tt.trim());
// 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 + -