jianzhudatabase.java

长沙公交查询管理系统,主要实现对人员资料的管理以及车辆的分配路线。

/*此类负责建筑查询方面的数据库操作*/
package pro;
import java.sql.*;
import java.util.*;
import javax.swing.table.*;
public class JianZhuDatabase
{
	private java.sql.Connection con;
	public JianZhuDatabase()
	{
		con=DatabaseConnection.getConnection();
	}
   public Vector selectAZ()         //26个字母下拉表值
   {
      	
      	Vector vec=new Vector();
      	 vec.add("请选建筑名首字母");
      	for(int i=65;i<90;i++)
      	{
      		vec.add((char)(i)+"");
      	}
            vec.add("Z其它");
        return vec;
   }
   /*根据建筑物名首字母查建筑物名*/
   public Vector selectJianZhuByLetter(String strAZ)
   {
   	Vector vec=new Vector();
   	vec.add("请选择建筑物名");
   	String strSql="select Nearbuild from Station where NearLetter='"+strAZ+"'";
   	try
   	{
   		java.sql.Statement sta=con.createStatement();
   		java.sql.ResultSet rs=sta.executeQuery(strSql);
   		while(rs.next())
   		{
   			vec.add(rs.getString("Nearbuild"));
   		}
   	
   		for(int i=0;i<vec.size();i++)
   		{
   			System.out.println ("v="+vec.get(i));
   		}
   		rs.close();
   		sta.close();
   	}
   	catch(java.sql.SQLException sqle)
   	{
   		sqle.printStackTrace();
   	}
   		return vec;
   }
   
   
    public String selZhanDianByJianZhu(String nearbuild)//根据建筑查站点的方法
    {
    	String str=new String();
    	try
    	{
    		String strSql="select Stations from Station where Nearbuild='"+nearbuild+"'";
    		java.sql.Statement sta=con.createStatement();
    		java.sql.ResultSet rs=sta.executeQuery(strSql);
    		while(rs.next())
    		{
    			str=rs.getString("Stations");
    			
    		}
    		rs.close();
    		sta.close();
    	}
    	catch(java.sql.SQLException sqle)
    	{
    		sqle.printStackTrace();
    	}
    	return str;
    }
    
    
    
    
    public DefaultTableModel selectZhan(String ststa,String jianZhu)       //按站查询的数据
  { 

         Vector veson=new Vector();
         Vector veou=new Vector();
         veou.add("车次");
         veou.add("起始站");
         veou.add(jianZhu+"附近站点");
        
         veou.add("终点站"); 
         veou.add("票价(元)");
        
        String str="select SBusName,SStartArea,SEndArea,Scarfare from SumBus";
    
        str=str+" where (SGoUp like '%- %[(]"+ststa+"[)] -%' or  SGoUp like '%- "+ststa+"(%) -%' or SGoUp like '%- "+ststa+" -%') or ";
        str=str+"(SGoDown like '%- %[(]"+ststa+"[)] -%' or  SGoDown like '%- "+ststa+"(%) -%' or SGoDown like '%- "+ststa+" -%')";
        try
        {
        	java.sql.Statement sta=con.createStatement();
	        java.sql.ResultSet res=sta.executeQuery(str);
	        while(res.next())
	        {
	        	 Vector vec=new Vector();
	             vec.add(res.getString(1));
	             vec.add(res.getString(2));
	             vec.add(ststa);
	             vec.add(res.getString(3));	
	             vec.add(res.getString(4));
	             veson.add(vec);
	          
	        }

	         
	         res.close();
	         sta.close();
	      
	   }
	   catch(Exception ex)
	   {
	        ex.printStackTrace();	
	   }
	  /* for(int s=0;s<veson.size();s++)
	   {
	        System.out.println(veson.get(s));	
	   }*/
	       
       DefaultTableModel de=new DefaultTableModel(veson,veou);
       return de;
  }
  
  
  public boolean isExistsJianZhu(String strJianZhu)
  {
  	boolean bool=true;
  	String strSql="select * from Station where Nearbuild='"+strJianZhu+"'";
  	try
  	{
  		java.sql.Statement sta=con.createStatement();
  		java.sql.ResultSet rs=sta.executeQuery(strSql);
  		if(rs.next())
  		{
  			bool=true;
  		}else
  		{
  			bool=false;
  		}
  		rs.close();
  		sta.close();
  		
  	}catch(java.sql.SQLException sqle)
  	{
  		bool=false;
  		sqle.printStackTrace();
  	}
  	return bool;
  }
}