dbbeancarinfo.java

来自「实现网络GPS定位车辆的位置」· Java 代码 · 共 503 行 · 第 1/2 页

      return true;
    }
    //删除车辆
    public boolean sysdelCar(String cardid)throws Exception
   {
     try
     {
       String sql="delete from CARMASTER where cardid='"+cardid+"'";
       System.out.println(sql);
       sqlStatement.execute(sql);
     }catch(Exception e){
       System.out.println("delete car 执行失败! "+e.getStackTrace());
       return false;
     }
     return true;
   }
   //com_Manager增加车辆
public boolean com_addCar()throws Exception
{

  try{
   pstmt =dbCon.prepareStatement("insert into CARMASTER(USERNAME,PASSWORD,CARDID,PROVINCE,"+
    "CITY,CARMOBILENO,CARLICENCENO,CONTACNAME,ADDRESS,CARCOLOR,REGISTERDATE,COMPANYID,WEBTYPE) values(?,?,?,?,?,?,?,?,?,?,?,?,?)");
   pstmt.setString(1,com_userInfo.getUsername());
   System.out.println("the fucking carbeans com_addcar!!!!! "+com_userInfo.getUsername());
   pstmt.setString(2,com_userInfo.getPassword());
   pstmt.setString(3,com_userInfo.getCardid());
   pstmt.setString(4,com_userInfo.getCarstyle());
   pstmt.setString(5,com_userInfo.getCity());
   pstmt.setString(6,com_userInfo.getCarmobileno());
   pstmt.setString(7,com_userInfo.getCarlicenceno());
   pstmt.setString(8,com_userInfo.getContacname());
   pstmt.setString(9,com_userInfo.getAddress());
   pstmt.setString(10,com_userInfo.getCarcolor());
   //System.out.println(userInfo.getCarcolor());
   //pstmt.setString(11,sysdate);
   pstmt.setDate(11,new java.sql.Date(new java.util.Date().getTime()));

   pstmt.setString(12,com_userInfo.getCompanyid());

   pstmt.setInt(13,1);

    pstmt.executeQuery();
    System.out.println("com_manager Carmaster has update!!!");

    pstmt =dbCon.prepareStatement("insert into TRACKINFO(CARDID,LATESTSEND,LATITUDE,LONGITUDE,SPEED,DIRECTION,STATUS)values(?,?,?,?,?,?,?)");

    pstmt.setString(1,com_userInfo.getCardid());
    pstmt.setDate(2,new java.sql.Date(new java.util.Date().getTime()));
    pstmt.setFloat(3,centerLati);
    pstmt.setFloat(4,centerLong);
    pstmt.setFloat(5,0);
    pstmt.setString(6,"00");
    pstmt.setString(7,"001");
    pstmt.executeQuery();

    System.out.println("TrackInfo has update!!!");
   }
  catch(Exception e)
  {
    e.printStackTrace();
    return false;
  }
  return true;
}


    //superManager增加车辆
    public boolean sysaddCar()throws Exception
    {
          int m_callcar=0;
          int m_stopcar=0;
          int m_tracecar=0;
          int m_findalarm=0;
          int m_ismanager=0;
      try{

        //System.out.println(java.sql.Date(new java.util.Date().getTime()));
        m_ismanager=Integer.parseInt(userInfo.getIsmanager());
        System.out.println("this is the manager: "+m_ismanager);
        if((userInfo.getCallcar())==null)
        {
          m_callcar=0;
        }
        else
        {
          m_callcar=1;
        }


        System.out.println("this is the callcar:"+m_callcar);
        if((userInfo.getStopcar())==null)
        {
          m_stopcar=0;
        }
        else
        {
          m_stopcar=1;
        }
        System.out.println("this is the stopcar: "+m_stopcar);
        if((userInfo.getTracecar())==null)
        {
          m_tracecar=0;
        }
        else
        {
          m_tracecar=1;
        }
        System.out.println("this is the tracecar: "+m_tracecar);
        if((userInfo.getFindalarm())==null)
        {
          m_findalarm=0;
        }
        else
        {
          m_findalarm=1;
        }


       pstmt =dbCon.prepareStatement("insert into CARMASTER(USERNAME,PASSWORD,CARDID,CARSTYLE,"+
        "CITY,CARMOBILENO,CARLICENCENO,CONTACNAME,ADDRESS,CARCOLOR,REGISTERDATE,ISMANAGER,COMPANYID,CALLCAR,STOPCAR,TRACECAR,WEBTYPE,FINDALARM) values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)");
       pstmt.setString(1,userInfo.getUsername());
       //System.out.println(userInfo.getUsername());
       pstmt.setString(2,userInfo.getPassword());
       pstmt.setString(3,userInfo.getCardid());
       pstmt.setString(4,userInfo.getCarstyle());
       pstmt.setString(5,userInfo.getCity());
       pstmt.setString(6,userInfo.getCarmobileno());
       pstmt.setString(7,userInfo.getCarlicenceno());
       pstmt.setString(8,userInfo.getContacname());
       pstmt.setString(9,userInfo.getAddress());
       pstmt.setString(10,userInfo.getCarcolor());
       //System.out.println(userInfo.getCarcolor());
       //pstmt.setString(11,sysdate);
       pstmt.setDate(11,new java.sql.Date(new java.util.Date().getTime()));
       pstmt.setInt(12,m_ismanager);
       //System.out.println("this is companyname: "+userInfo.getCompanyname());
       pstmt.setString(13,userInfo.getCompanyid());
       pstmt.setInt(14,m_callcar);
       pstmt.setInt(15,m_stopcar);
       pstmt.setInt(16,m_tracecar);
       pstmt.setInt(17,1);
       pstmt.setInt(18,m_findalarm);
        pstmt.executeQuery();
        System.out.println("Carmaster has update!!!");

        pstmt =dbCon.prepareStatement("insert into TRACKINFO(CARDID,LATESTSEND,LATITUDE,LONGITUDE,SPEED,DIRECTION,STATUS)values(?,?,?,?,?,?,?)");

        pstmt.setString(1,userInfo.getCardid());
        pstmt.setDate(2,new java.sql.Date(new java.util.Date().getTime()));
        pstmt.setFloat(3,centerLati);
        pstmt.setFloat(4,centerLong);
        pstmt.setFloat(5,0);
        pstmt.setString(6,"00");
        pstmt.setString(7,"001");
        pstmt.executeQuery();

        System.out.println("TrackInfo has update!!!");
       }
      catch(Exception e)
      {
        e.printStackTrace();
        return false;
      }
      return true;
    }

    public boolean alterCar(String username,String password,String contacname,String address,String cardid) throws java.sql.SQLException
    {
        int flag=0;
        String u=convertToChinese(username);
        String p=password;
        String c=convertToChinese(contacname);
        String a=convertToChinese(address);
        System.out.println("fucking username"+u);
        System.out.println("fucking password"+ p);
        System.out.println("fucking contacname "+c);
        System.out.println("fucking address "+a);
        try{
            String sql="update CARMASTER set USERNAME ='"+u+"', PASSWORD='"+p+"',CONTACNAME='"+c+"',ADDRESS='"+a+"' where CARDID='"+cardid+"'";
            System.out.println(sql);
            flag=sqlStatement.executeUpdate(sql);
        }catch (Exception e)
        {
          System.out.println("更新车辆信息失败："+e.getMessage());
          return false;
        }
        return true;
    }
    //系通管理员修改
    public boolean sysalterCar(String username,String password,String carmobileno,String contacname,String address,String ismanager,String callcar,String stopcar,String tracecar,String findalarm,String cardid) throws java.sql.SQLException
    {
        int flag=0;
        int manager;
        int call;
        int stop;
        int trace;
        int alarm;
        String uname=convertToChinese(username);
        String pwd=password;
        String mobileno=carmobileno;
        String contac=convertToChinese(contacname);
        String addr=convertToChinese(address);
        manager=Integer.parseInt(ismanager);
        call=Integer.parseInt(callcar);
        stop=Integer.parseInt(stopcar);
        trace=Integer.parseInt(tracecar);
        alarm=Integer.parseInt(findalarm);


        try{
            String sql="update CARMASTER set USERNAME ='"+uname+"', PASSWORD='"+pwd+"',CARMOBILENO='"+mobileno+"',CONTACNAME='"+contac+"',ADDRESS='"+addr+"',ISMANAGER='"+manager+"',CALLCAR='"+call+"',STOPCAR='"+stop+"',TRACECAR='"+trace+"',FINDALARM='"+alarm+"' where CARDID='"+cardid+"'";
            System.out.println(sql);
            flag=sqlStatement.executeUpdate(sql);
        }catch (Exception e)
        {
          System.out.println("更新车辆信息失败："+e.getMessage());
          return false;
        }
        return true;
    }


  public void close(){
    try {
         dbCon.close();
         sqlStatement=null;
         dbCon=null;
    }
    catch (Exception e) {
    }
  }
  /*//////////////////////////////////////////////////////////////////////////////////////////////////
转换字符
///////////////////////////////////////////////////////////////////////////////////////////////////*/
 public String convertToChinese(String chineseStr)
  {
   if(chineseStr != null)
   {
          try
          {
          chineseStr = new String(chineseStr.getBytes("ISO-8859-1"), "GBK");
          }
          catch(Exception e)
          {
            e.printStackTrace();
          }
   }
   return chineseStr;
  }
}