busmanager.java~2~

来自「cs结构的一个公交车系统好有使用价值啊下吧--- --- ---」· JAVA~2~ 代码 · 共 74 行

package bus;


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

public class BusManager
 {
  Connection conn=null;
  Statement st=null;
  public BusManager()
  {
    try
    {
      Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
    }
    catch (ClassNotFoundException ex)
    {
      System.out.print("驱动加载失败！");
    }
    try
    {
      String url = "jdbc:micrsoft: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();

                System.out.println (rsmd.getTableName(2));
                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;

    }
}