xiangmuliebiao.java~6~

Bug管理系统

package xiangmu;

import java.util.Vector;
import java.sql.Statement;
import java.sql.ResultSet;
import db.Db;
import java.util.Iterator;

public class xiangmuliebiao {
    public Vector xiangmuitems=new Vector();   //xiangmu列表集合
    public xiangmuliebiao() {
    }
    //把所有的项目添加到项目列表中
       public void addxiangmu()throws Exception
       {
           //连接数据库
           Db db1=new Db();
           db1.getCon("bugBarrier");
           //获得表中数据
           Statement stmt=db1.conn.createStatement();
           ResultSet rs=stmt.executeQuery("execute addxiangmu1");//把所有的bug添加到记录集中
           while(rs.next())
           {
               //声明一个bug对象
               xiangmu x=new xiangmu();
               x.setXiangmuId(rs.getString("xiangmuId"));
               x.setXiangmumingcheng(rs.getString("xiangmumingcheng"));
               x.setXiangmuJingli(rs.getString("yonghuming"));
               x.setXiangmuChuangjianriqi(rs.getString("xiangmuChuangjianriqi"));
               x.setXiangmuYujiezhiriqi(rs.getString("xiangmuYujiezhiriqi"));
               x.setXiangmuMiaoshu(rs.getString("xiangmuMiaoshu"));
               x.setXiangmuzhuangtai(rs.getString("xiangmuzhuangtaiZhi"));
               xiangmuitems.add(x);
          }
  /*
          Iterator i1=xiangmuitems.iterator();

          while(i1.hasNext())
          {
              xiangmu x1=(xiangmu)i1.next();
              System.out.println(x1.getXiangmumingcheng());
          }
   */
          db1.closeConnection();
    }
    //把所有的项目添加到项目列表中 6个参数
       public void addxiangmu(String xiangmuid,String xiangmumingcheng,String xiangmuJingliId,
               String xiangmuChuangjianriqi,String xiangmuYujiezhiriqi,String xiangmuzhuangtaiId
              )throws Exception
       {
           //生成查询字符串
           String s=new String();
           //基础字符串
           s="select x.xiangmuId,x.xiangmumingcheng,y.yonghuming,x.xiangmuChuangjianriqi,x.xiangmuYujiezhiriqi,x.xiangmuMiaoshu,xz.xiangmuzhuangtaiZhi from xiangmu x,yonghu y,xiangmuzhuangtai xz where x.xiangmuJingliId=y.yonghuid and x.xiangmuzhuangtaiId=xz.xiangmuzhuangtaiId";
           //查询字符串
           if(!xiangmuid.trim().equals(""))
               s=s+" and x.xiangmuid='"+xiangmuid.trim()+"' ";
           if(!xiangmumingcheng.trim().equals(""))
               s=s+" and x.xiangmumingcheng='"+xiangmumingcheng.trim()+"' ";
           if(!xiangmuJingliId.trim().equals(""))
               s=s+" and xiangmuJingliId='"+xiangmuJingliId.trim()+"' ";
           if(!xiangmuChuangjianriqi.trim().equals(""))
               s=s+" and xiangmuChuangjianriqi='"+xiangmuChuangjianriqi.trim()+"' ";
           if(!xiangmuYujiezhiriqi.trim().equals(""))
               s=s+" and xiangmuYujiezhiriqi='"+xiangmuYujiezhiriqi.trim()+"' ";
           if(!xiangmuzhuangtaiId.trim().equals(""))
               s=s+" and x.xiangmuzhuangtaiId='"+xiangmuzhuangtaiId.trim()+"' ";
           System.out.println(s);

           //连接数据库
           Db db1=new Db();
           db1.getCon("bugBarrier");
           //获得表中数据
           Statement stmt=db1.conn.createStatement();
           ResultSet rs=stmt.executeQuery(s);//把所有的bug添加到记录集中
           while(rs.next())
           {
               //声明一个bug对象
               xiangmu x=new xiangmu();
               x.setXiangmuId(rs.getString("xiangmuId"));
               x.setXiangmumingcheng(rs.getString("xiangmumingcheng"));
               x.setXiangmuJingli(rs.getString("yonghuming"));
               x.setXiangmuChuangjianriqi(rs.getString("xiangmuChuangjianriqi"));
               x.setXiangmuYujiezhiriqi(rs.getString("xiangmuYujiezhiriqi"));
               x.setXiangmuMiaoshu(rs.getString("xiangmuMiaoshu"));
               x.setXiangmuzhuangtai(rs.getString("xiangmuzhuangtaiZhi"));
               xiangmuitems.add(x);
          }

          Iterator i1=xiangmuitems.iterator();

          while(i1.hasNext())
          {
              xiangmu x1=(xiangmu)i1.next();
              System.out.println(x1.getXiangmumingcheng());
          }

          db1.closeConnection();
    }

    //项目统计
    public void xiangmutongji(String xiangmuid,String startdate,String enddate) throws Exception
    {
        //连接数据库
        Db db1=new Db();
        db1.getCon("bugBarrier");
        //获得表中数据
        Statement stmt=db1.conn.createStatement();
        ResultSet rs=stmt.executeQuery("execute addxiangmu1");//把所有的bug添加到记录集中


        db1.closeConnection();
    }

   public static void main(String args[])throws Exception
{

   xiangmuliebiao xl1=new xiangmuliebiao();
   xl1.addxiangmu("","","","","","1");
}
}