yonghuliebiao.java

Bug管理系统

package yonghu;

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

public class yonghuliebiao {
    public Vector yonghuitems=new Vector();   //xiangmu列表集合
    public yonghuliebiao() {
    }
    //把所有用户提取出来，放到列表集合中
    public void addyonghu()throws Exception
    {
            //连接数据库
            Db db1 = new Db();
            db1.getCon("bugBarrier");
            //获得表中数据
            Statement stmt = db1.conn.createStatement();
            ResultSet rs = stmt.executeQuery("execute addyonghu1"); //把所有的bug添加到记录集中
            while(rs.next())
            {
                //声明一个bug对象
                yonghu y=new yonghu();
                y.setYonghuId(rs.getString("yonghuId"));
                y.setYonghuming(rs.getString("yonghuming"));
                y.setMima(rs.getString("mima"));
                y.setMimatishi(rs.getString("mimatishi"));
                y.setZhenshixingming(rs.getString("zhenshixingming"));
                y.setBangongdianhua(rs.getString("bangongdianhua"));
                y.setYidongdianhua(rs.getString("yidongdianhua"));
                y.setMsn(rs.getString("msn"));
                y.setBeizhu(rs.getString("beizhu"));
                y.setXitongquanxian(rs.getString("quanxianZhi"));
                y.setQq(rs.getString("qq"));
                y.setJinyong(rs.getString("jinyong"));
                yonghuitems.add(y);
              }
/*
              Iterator i1=yonghuitems.iterator();

              while(i1.hasNext())
              {
                  yonghu y1=(yonghu)i1.next();
                  System.out.println(y1.getZhenshixingming());
              }
  */
          db1.closeConnection();
    }

    //通过查询提取用户放到用户列表中
        public void addyonghu(String qq,String zhenshixingming)throws Exception
        {
                //生成查询字符串
                String s=new String();
                //基础字符串
                s="select y.yonghuId,y.yonghuming,y.mima,y.mimatishi,y.zhenshixingming,y.bangongdianhua,y.yidongdianhua,y.msn,y.beizhu,x.quanxianZhi,y.qq,y.jinyong from yonghu y,xitongquanxian x where y.xitongquanxianId=x.xitongquanxianId and y.yonghuid<>0";
                //查询字符串
                if(!qq.trim().equals(""))
                     s=s+" and y.qq='"+qq.trim()+"' ";
                if(!zhenshixingming.trim().equals(""))
                     s=s+" and y.zhenshixingming='"+zhenshixingming.trim()+"' ";
                //连接数据库
                Db db1 = new Db();
                db1.getCon("bugBarrier");
//                System.out.println(s);

                //获得表中数据
                Statement stmt = db1.conn.createStatement();
                ResultSet rs = stmt.executeQuery(s); //把所有的bug添加到记录集中

                while(rs.next())
                {
                    //声明一个bug对象
                    yonghu y=new yonghu();
                    y.setYonghuId(rs.getString("yonghuId"));
//                    System.out.println("1");
                    y.setYonghuming(rs.getString("yonghuming"));
//                    System.out.println("2");
                    y.setMima(rs.getString("mima"));
//                    System.out.println("3");
                    y.setMimatishi(rs.getString("mimatishi"));
//                    System.out.println("4");
                    y.setZhenshixingming(rs.getString("zhenshixingming"));
//                    System.out.println("5");
                    y.setBangongdianhua(rs.getString("bangongdianhua"));
//                    System.out.println("6");
                    y.setYidongdianhua(rs.getString("yidongdianhua"));
//                    System.out.println("7");
                    y.setMsn(rs.getString("msn"));
//                    System.out.println("8");
                    y.setBeizhu(rs.getString("beizhu"));
//                    System.out.println("9");
                    y.setXitongquanxian(rs.getString("quanxianZhi"));
//                    System.out.println("10");
                    y.setQq(rs.getString("qq"));
//                    System.out.println("11");
                    y.setJinyong(rs.getString("jinyong"));
//                    System.out.println("333333333333333333333333");
                    yonghuitems.add(y);
                  }
/*
                  Iterator i1=yonghuitems.iterator();

                  while(i1.hasNext())
                  {
                      yonghu y1=(yonghu)i1.next();
                      System.out.println(y1.getZhenshixingming());
                  }
  */
              db1.closeConnection();
        }
        //通过查询提取用户放到用户列表中
            public void addyonghu(String yonghuid)throws Exception
            {
                    //生成查询字符串
                    String s=new String();
                    //基础字符串
                    s="select y.yonghuId,y.yonghuming,y.mima,y.mimatishi,y.zhenshixingming,y.bangongdianhua,y.yidongdianhua,y.msn,y.beizhu,x.quanxianZhi,y.qq ,y.jinyong from yonghu y,xitongquanxian x where y.xitongquanxianId=x.xitongquanxianId and y.yonghuid<>0";
                    //查询字符串
                    if(!yonghuid.trim().equals(""))
                         s=s+" and y.yonghuId='"+yonghuid.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对象
                        yonghu y=new yonghu();
                        y.setYonghuId(rs.getString("yonghuId"));
                        y.setYonghuming(rs.getString("yonghuming"));
                        y.setMima(rs.getString("mima"));
                        y.setMimatishi(rs.getString("mimatishi"));
                        y.setZhenshixingming(rs.getString("zhenshixingming"));
                        y.setBangongdianhua(rs.getString("bangongdianhua"));
                        y.setYidongdianhua(rs.getString("yidongdianhua"));
                        y.setMsn(rs.getString("msn"));
                        y.setBeizhu(rs.getString("beizhu"));
                        y.setXitongquanxian(rs.getString("quanxianZhi"));
                        y.setQq(rs.getString("qq"));
                        y.setJinyong(rs.getString("jinyong"));
                        yonghuitems.add(y);
                      }
    /*
                      Iterator i1=yonghuitems.iterator();

                      while(i1.hasNext())
                      {
                          yonghu y1=(yonghu)i1.next();
                          System.out.println(y1.getZhenshixingming());
                      }
      */
                  db1.closeConnection();
            }
            //判断用户是否存在,存在返回true
                public boolean panduanyonghu(String yonghuming)throws Exception
                {
                        //连接数据库
                        Db db1 = new Db();
                        db1.getCon("bugBarrier");
                        //获得表中数据
                        Statement stmt=db1.conn.createStatement();
                        ResultSet rs=stmt.executeQuery("select * from yonghu where yonghuming='"+yonghuming+"' and jinyong=1");//提取用户
                        int n=0;
                        while(rs.next())
                        {
                            n++;
                        }
                        db1.closeConnection();
                        if(n==0)
                            return false;
                        else
                            return true;
                }

    public static void main(String args[])throws Exception
    {
        yonghuliebiao yl1 = new yonghuliebiao();
        yl1.addyonghu();
        //yl1.addyonghu("7");
        fenye f=new fenye();

        fenye fy=new fenye();
        yl1=fy.yonghufenye(yl1,"1","4");

        Iterator i1=yl1.yonghuitems.iterator();
        while(i1.hasNext())
        {
            yonghu y1=(yonghu)i1.next();
            System.out.println(y1.getYonghuming());
        }

        System.out.println("第"+(fy.n+1)+"页  总共"+fy.nn+"页");
        System.out.println(fy.tishi1+" "+fy.tishi2+" "+fy.tishi3+" "+fy.tishi4+" "+fy.tishi5);
    }

}