busmanager.java

cs结构的一个公交车系统好有使用价值啊下吧--- --- ---

package bus;

import java.util.*;
import java.sql.*;

public class BusManager
 {
  Connection conn=null;
  Statement st=null;
  public BusManager()
  {
    try
    {
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    }
    catch (ClassNotFoundException ex)
    {
      System.out.print("驱动加载失败！");
    }
    try
    {
      String url = "jdbc:odbc:sqlserver://localhost:1433;databaseName=Bus";
      conn = DriverManager.getConnection(url, "sa", "");
      st = conn.createStatement();
    }
    catch (Exception ex1)
    {
      System.out.print("连接数据库失败！");
      ex1.printStackTrace();
    }
  }
  public void updateBus(String s)
  {
        try
        {
                st.execute(s);
        }catch(Exception e)
        {
                System.out.println ("更新数据失败！");
                e.printStackTrace();
        }
}

//==========查询方法==========
      public Vector selectBus(String s)
      {
        Vector all = new Vector();
        try{
                ResultSet rs = st.executeQuery(s);
                ResultSetMetaData rsmd=rs.getMetaData();
                while(rs.next())
                {
                        Vector row = new Vector();
                        for(int i=1;i<=rsmd.getColumnCount();i++)
                        {
                                row.add(rs.getObject(i));
                        }
                        all.add(row);
                }

        }
        catch(Exception e)
        {
                e.printStackTrace();
                System.out.println ("查询失败！");
        }
        return all;

    }
    //删除方法
    public boolean delectedBus(String s){
      boolean b1=true;
      try{
          b1=st.execute(s);
      }
      catch(Exception e){}return b1;
    }
    //添加方法
    public boolean insertBus(String s){
      boolean b2 = true;
      try {
        b2 = st.execute(s);
      }
      catch (Exception e) {}
      return b2;
    }


}