new_database_com.java

实现网络GPS定位车辆的位置

package webgisserver;

/**
 * <p>Title: </p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2003</p>
 * <p>Company: </p>
 * @author not attributable
 * @version 1.0
 */
import java.util.Date;
import java.net.*;
import java.io.*;
import java.text.*;
import java.util.Vector;
import java.sql.*;





public class new_Database_com {
  public new_Database_com() {
  }
  public static Vector getPosMessage(String Msg)
   {

        Vector v=new Vector();

        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
        int index1=Msg.indexOf(" ");
        int index2=Msg.indexOf(" ",index1+1);
        int index3=Msg.indexOf(" ",index2+1);
        int index4=Msg.indexOf(" ",index3+1);
        String Latitude=Msg.substring(index3+1,index4);
               double Lati=Double.parseDouble(Latitude)*0.01;
               Latitude=String.valueOf(Lati);
               System.out.println(Latitude);
        int index5=Msg.indexOf(" ",index4+1);

        int index6=Msg.indexOf(" ",index5+1);
        String Longitude=Msg.substring(index5+1,index6);
               double Longi=Double.parseDouble(Longitude)/100.00;
               Longitude=String.valueOf(Longi);
               System.out.println(Longitude);
        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;
               Speed=String.valueOf(Sp);

               System.out.println(Speed);

        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);
               System.out.println(Date);
        String Time = Msg.substring(index1+1,index2);
               System.out.println(Time);
               Time = Time.substring(0,2)+":"+Time.substring(2,4)+":" +Time.substring(4,6);
               System.out.println(Time);
        Date = Date+" "+Time;
        System.out.println(Date);
         v.addElement("Latitude");
         v.addElement("Longitude");
         v.addElement("Speed");
         v.addElement("Date");

         return v;
   }

  public static void main(String[] args) {
    new_Database_com new_Database_com1 = new new_Database_com();

    Connection Conn;
    Statement Stmt;


    try {
          Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
          String url="jdbc:microsoft:sqlserver://192.110.0.20:1433;DatabaseName=SubGPS";

          String user="gps";
          String password="topeak";
          Conn= DriverManager.getConnection(url,user,password);

        //        DriverManager.registerDriver(new com.microsoft.SQLServerDriver());
         //Conn= DriverManager.getConnection ("jdbc:oracle:thin:@211.101.210.162:1521:webgis",
         //                  "webgis", "webgis");
        //         Conn= DriverManager.getConnection ("jdbc:oracle:thin:@192.168.0.163:1521:gpsdata",
        //                           "test", "test");
         Stmt= Conn.createStatement();
    String strSQL= "SELECT VEHICLE.SIMNum, VEHICLE.CarPlate,VEHICLE.Style, VEHICLE.Color, CUSTOMER.Name, CUSTOMER.Type, NEWDATA.Msg FROM VEHICLE INNER JOIN "+
        " CUSTOMER ON VEHICLE.UserID = CUSTOMER.UserID LEFT OUTER JOIN NEWDATA ON VEHICLE.SIMNum = NEWDATA.SIMNum WHERE VEHICLE.SIMNum = '13931408185'";

         ResultSet RS = Stmt.executeQuery(strSQL);
         Vector v=new Vector();

         while(RS.next()){
           System.out.println(RS.getString("Name"));
           System.out.println(RS.getString("CarPlate"));
           System.out.println(RS.getString("Style"));
           System.out.println(RS.getString("Msg"));
           v=getPosMessage(RS.getString("Msg"));
/*              v.addElement(ConvertString(RS.getString("Name")));
              v.addElement(ConvertString(RS.getString("CarPlate")));
              v.addElement(ConvertString(RS.getString("Style")));
              v.addElement(ConvertString(RS.getString("Color")));
              v.addElement(ConvertString(RS.getString("Type")));
            //       System.out.println(RS.getString("cardid")+"*"+RS.getString("phoneno")+"*");
              v.addElement(ConvertString(RS.getString("SIMNum")));


               Msg=RS.getString("Msg");
               if(Msg!=null){
                   Pos=getPosMessage(Msg);
               v.addElement(Pos.elementAt(0) );//Latitude
               v.addElement(Pos.elementAt(1) );//Longitude
               v.addElement(Pos.elementAt(2) );//Speed
               v.addElement(Pos.elementAt(3) );//Date
               }
               else{
                 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 ae )
         {
            System.out.println (ae);
         }


  }

}