framewebdatabase.java

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

           String Latitude="";
           String Longitude="";
           String Speed="";
           String Date="";
           v.addElement(Latitude);
           v.addElement(Longitude);
           v.addElement(Speed);
           v.addElement(Date);
         }


//        v.addElement(ConvertString(RS.getString("speed")));
//        v.addElement(ConvertString(RS.getString("status")));
//        v.addElement(ConvertString(RS.getString("gpsstyle")));
//        v.addElement(ConvertString(RS.getString("province")));
//        v.addElement(ConvertString(RS.getString("registerdate")));
//        v.addElement(ConvertString(RS.getString("latitude")));
//        v.addElement(ConvertString(RS.getString("longitude")));
//        System.out.println(RS.getString("latitude")+":"+RS.getString("longitude"));
        //b.latitude,b.longitude

        //System.out.println(RS.getString("cardid"));
 //       System.out.println(RS.getString("SPEED")+":"+RS.getString("CreateDatime"));
      }
      RS.close();
    }catch(Exception e){
      e.printStackTrace();
    }

    return v;
  }

  ////解析车辆定位信息
  public  Vector getPosMessage(String Msg)//解析收到的定位信息
   {

        Vector v=new Vector();
        String k="";
        double j=0.0;
        String ff="";

        String sub="/";
        String result="";
        String dd="";
//          0000000000000000$GPRMC 064935.000 A 3955.5850 N 11619.6262 E 009 312 281004  *FF
//          0000000000000400$GPRMC 221018.000 V 4057.3118 N 11757.6691 E 000 120 031104  *FF
//in_string=0000000000000000$GPRMC 084754.000 V 4057.3174 N 11757.6659 E 000 144 051104  *FF
        int index1=Msg.indexOf(" ");
        int index2=Msg.indexOf(" ",index1+1);
        int index3=Msg.indexOf(" ",index2+1);
        int index4=Msg.indexOf(" ",index3+1);
               k=Msg.substring(index3+3,index4);
               j = Double.valueOf(k).doubleValue()/60;
               DecimalFormat nf = new DecimalFormat("0.####");
               ff =nf.format(j);
               ff = ff.substring(2,ff.length());
//               ff = Integer.toString(j);

        String Latitude=Msg.substring(index3+1,index3+3)+"."+ff;
//               double Lati=Double.parseDouble(Latitude)*0.01;
//               Latitude=String.valueOf(Lati);
        int index5=Msg.indexOf(" ",index4+1);
        int index6=Msg.indexOf(" ",index5+1);

        k=Msg.substring(index5+4,index6);
        j =  Double.valueOf(k).doubleValue()/60;
//        DecimalFormat nf = new DecimalFormat("0.####");
        ff =nf.format(j);
        ff = ff.substring(2,ff.length());

//        ff = Integer.toString(j);
        String Longitude=Msg.substring(index5+1,index5+4)+"."+ff;
//               double Longi=Double.parseDouble(Longitude)*0.01;
//               Longitude=String.valueOf(Longi);
        int index7=Msg.indexOf(" ",index6+1);
        int index8=Msg.indexOf(" ",index7+1);
        String Speed=Msg.substring(index7+1,index8);
               double Sp=Double.parseDouble(Speed)*1.85;
        nf = new DecimalFormat("##0.##");
      //double speed =(  Double.parseDouble(m_speed)));

        Speed=nf.format(Sp);
        int index9=Msg.indexOf(" ",index8+1);
        int index10=Msg.indexOf(" ",index9+1);

        String Date=Msg.substring(index9+1,index10);
               Date = Date.substring(0,2)+"/"+Date.substring( 2,4)+"/" +Date.substring(4);
        String Time = Msg.substring(index1+1,index2);
        String OriginalHours = Time.substring(0,2);
        int Add_Hours = (Integer.parseInt(OriginalHours)+8);
               if(Add_Hours>24){
                 Add_Hours = Add_Hours-24;
               }
         String AlterHours=String.valueOf(Add_Hours);
               Time = AlterHours+":"+Time.substring(2,4)+":" +Time.substring(4,6);
        Date = Date+" "+Time;
         v.addElement(Latitude);
         v.addElement(Longitude);
         v.addElement(Speed);
         v.addElement(Date);

         return v;
   }



public String ConvertString(String s)
{
  if(s == null)
    return s="";
  else
    return s;
}
 /*//////////////////////////////////////////////////////////////////////////////////////////////////
  查询车辆历史轨迹信息--SMSG——INFO CARMASTER
///////////////////////////////////////////////////////////////////////////////////////////////////*/
  public Vector getSearchResult(String strSQL){

    Vector v = new Vector();
    try{
      System.out.println(strSQL);
      java.sql.ResultSet RS = Stmt.executeQuery(strSQL);
      while(RS.next()){
        v.addElement(RS.getString("LONGITUDE"));
        v.addElement(RS.getString("LATITUDE"));
        v.addElement(RS.getString("SPEED"));
        v.addElement(RS.getString("SENTTIME"));
       System.out.println(RS.getString("LATITUDE") +":"+RS.getString("LONGITUDE"));
        System.out.println(RS.getString("SPEED")+":"+RS.getString("SENTTIME"));
      }
      RS.close();
    }catch(Exception e){
      e.printStackTrace();
    }

    return v;
  }
  /////////////////////////////////////////////////////////////////////////////
  //查询报警信息
  /////////////////////////////////////////////////////////////////////////////
  public Vector getAlarmResult(String strSQL){
  //strSQL="select * from track where carnumber='13801135733' and TO_CHAR(createdatime,'YYYY-MM-DD')='2003-06-24'";
  Vector v = new Vector();
  try{
    System.out.println(strSQL);
    java.sql.ResultSet RS = Stmt.executeQuery(strSQL);
    while(RS.next()){
// select CARDID,USER_NAME,CAR_NO,INFO_DATE,ALERT_TYPE FROM ALERT_HST where CardId='"+"10000012" +"'  and TO_CHAR(INFO_DATE,'YYYYMMDDHH24MI')>='"+m_BeginDateTime+ "' and TO_CHAR(INFO_DATE,'YYYYMMDD HH24MI')<='"+ m_EndDateTime+"' order by INFO_DATE";
      v.addElement(RS.getString("CARDID"));
      v.addElement(RS.getString("USER_NAME"));
      v.addElement(RS.getString("CAR_NO"));
      v.addElement(RS.getString("INFO_DATE"));
      v.addElement(RS.getString("ALERT_TYPE"));
      //System.out.println(RS.getString("ALERT_TYPE"));
      //System.out.println(RS.getString("SPEED")+":"+RS.getString("SENTTIME"));
    }
    RS.close();
  }catch(Exception e)
  {
    e.printStackTrace();
  }

  return v;
}

  private String getTime()
      {
       Date currentTime=new Date();
       //SimpleDateFormat dateFormat=new SimpleDateFormat("yyyy MMMM dd,EEEE, HH:mm:ss");
       SimpleDateFormat dateFormat=new SimpleDateFormat("yyyy\\MM\\dd HH:mm:ss ");
       String timeString=dateFormat.format(currentTime);
       return timeString;
      }
     public void WriteFile(String sMessage)
     {
      try{
// 在StringWriter 上建立一个PrintWriter。
      StringWriter sw = new StringWriter();
      PrintWriter pw = new PrintWriter(sw);
// 输出一些东西到StringWriter
      pw.println(sMessage);
// 得到被写入的字符串
      String str = sw.toString();
// 显式它
      System.out.print(str);
// 将字符串输出到文件，使用 UTF-8 编码
      FileOutputStream fos =new FileOutputStream(FileName);
      OutputStreamWriter osw =new OutputStreamWriter(fos, "UTF-8");
      BufferedWriter bw =new BufferedWriter(osw);
      bw.write(str);
      bw.close();
    }
    catch (Exception e)
    {
     System.out.println(e);
     }
    }
  }
  //the end of TCPconnetServer
  private String getTime()
  {
    Date currentTime=new Date();
    //SimpleDateFormat dateFormat=new SimpleDateFormat("yyyy MMMM dd,EEEE, HH:mm:ss");
    SimpleDateFormat dateFormat=new SimpleDateFormat("yyyyMMddHHmmss");
    String timeString=dateFormat.format(currentTime);
    return timeString;
  }
  private String getDateTime()
  {
   Date currentTime=new Date();
   //SimpleDateFormat dateFormat=new SimpleDateFormat("yyyy MMMM dd,EEEE, HH:mm:ss");
   SimpleDateFormat dateFormat=new SimpleDateFormat("yyyy\\MM\\dd HH:mm:ss ");
   String timeString=dateFormat.format(currentTime);
   return timeString;
  }
 public void WriteMyFile(String sMessage)
 {
  try{
// 输出一些东西到StringWriter
  pw.println(sMessage);
  System.out.println(sMessage);
// 得到被写入的字符串
  String str = sw.toString();
// 显式它
  System.out.print(str);
// 将字符串输出到文件，使用 UTF-8 编码
  bw.write(str);
}
catch (Exception e)
{
 System.out.println(e);
 }
}

void WriteFile(String sMessage)
{
try
  {
  FileWriter file = new FileWriter(FileName,true);
  PrintWriter out = new PrintWriter(file);
  out.println(sMessage);
  out.close();
  file.close();
  } catch (IOException e)
  {
   System.out.println("错了!");
   e.printStackTrace();
  }
}


}


/*
// 在StringWriter 上建立一个PrintWriter。
StringWriter sw = new StringWriter();
PrintWriter pw = new PrintWriter(sw);
// 输出一些东西到StringWriter
pw.println("This is a test\u4321");
int n = 37;
pw.println("The square of " + n + " is " + (n * n));
// 得到被写入的字符串
String str = sw.toString();
// 显式它
System.out.print(str);
// 将字符串输出到文件，使用 UTF-8 编码

FileOutputStream fos =
new FileOutputStream("c:\\test.txt");
OutputStreamWriter osw =
new OutputStreamWriter(fos, "UTF-8");
BufferedWriter bw =
new BufferedWriter(osw);
bw.write(str);
bw.close();
// 读回字符串并检查
FileInputStream fis=new FileInputStream("out.txt");
InputStreamReader isr =new InputStreamReader(fis, "UTF-8");
BufferedReader br =new BufferedReader(isr);
String s1 = br.readLine();
String s2 = br.readLine();
br.close();
String linesep = System.getProperty("line.separator");
if (!str.equals(s1 + linesep + s2 + linesep))
System.err.println("equals check failed");*/