每日总结-23.3.13

课上内容地铁系统中的前两个查询部分

//线路号查询,String name = 线路名称
    public Pd chaxunxianlu(String name) throws SQLException
    {
        String sql="select * from xinxi where mingcheng='"+name+"'";
        Statement stmt = connect.createStatement();
        ResultSet rs = stmt.executeQuery(sql);
        Pd pdd = new Pd();
        while(rs.next())
        {
            String zhan="";
            int i=3;
            while(zhan!=null)
            {
                zhan=rs.getString(i);
                pdd.zhan[i-3]=zhan;
                i++;
            }
        }
        stmt.close();
        return pdd;
    }
    //站点查询,String name = 站点名称
    public Pd[] chaxunxianlu2(String name) throws SQLException
    {
        Pd[] pdd = new Pd[20];
        for(int i=0;i<20;i++)
        {
            Pd pd = new Pd();
            pdd[i]=pd;
        }
        int num=0;
        Statement stmt = connect.createStatement();
        for(int i=1;i<36;i++)
        {
            String sql="select * from xinxi where a"+i+" ='"+name+"'";
            ResultSet rs = stmt.executeQuery(sql);
            while(rs.next())
            {
                String n=rs.getString(2);
                pdd[num].mingcheng=n;
                String zhan="";
                int x=3;
                while(zhan!=null)
                {
                    zhan=rs.getString(x);
                    pdd[num].zhan[x-3]=zhan;
                    x++;
                }
            }
            if(pdd[num].mingcheng!=null)
                num++;
        }
        stmt.close();
        return pdd;
    }