井盖程序中获取电信推送数据的java代码

最新推荐文章于 2021-08-12 13:47:40 发布

原创最新推荐文章于 2021-08-12 13:47:40 发布 · 322 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#啊

服务器同时被 2 个专栏收录

24 篇文章

订阅专栏

java

23 篇文章

订阅专栏

本文介绍了一个使用Java开发的RESTful API示例，该API通过Jersey框架实现，并与MySQL数据库集成，用于处理设备数据变化的通知。文章展示了如何通过JSON格式接收和发送数据，以及如何将数据持久化到MySQL数据库。

UserInfo.java

package com.huawei.com;

import java.io.IOException;
import java.io.PrintStream;
import javax.ws.rs.Consumes;
import javax.ws.rs.GET;
import javax.ws.rs.POST;
import javax.ws.rs.Path;
import javax.ws.rs.PathParam;
import javax.ws.rs.Produces;

import com.fasterxml.jackson.core.JsonProcessingException;  
import com.fasterxml.jackson.databind.JsonNode;  
import com.fasterxml.jackson.databind.ObjectMapper;

import java.sql.*;

@Path("UserInfoService")
public class UserInfo
{
  // JDBC 驱动名及数据库 URL
  static final String JDBC_DRIVER = "com.mysql.jdbc.Driver";  
  static final String DB_URL = "jdbc:mysql://localhost:3306/meiqi4?serverTimezone=UTC";///////////////////////////////////YAJUN->meiqi4
 
  // 数据库的用户名与密码，需要根据自己的设置
  static final String USER = "root";
  static final String PASS = "Ali_常用密码";
  
	
  @GET
  @Path("/name/{i}")
  @Produces({"application/json"})
  public String userName(@PathParam("i") String i)
  {
    String name = i;
    return "{\"name\":\"" + name + "\"}";
  }
  
  @GET
  @Path("/age/{j}")
  @Produces({"text/xml"})
  public String userAge(@PathParam("j") int j)
  {
    int age = j;
    return "<User><Age>" + age + "</Age>" + "</User>";
  }
  
  @POST
  @Path("/subscriber")
  @Consumes({"application/json"})
  @Produces({"application/json"})
  public String subscriber(DeviceDataChanged k)
  {
    String result = k.getDeviceId();
    return result;
  }
  
  @POST
  @Path("/subscriber1")
  public String subscriber1(String k) throws IOException
  {
    String result = k;
    
    Connection conn = null;
    Statement stmt = null;
    
    String[] display_str_array = new String[10];
    
    //解析数据
    try{
    	System.out.println("\r\ntry\r\n");
    	ObjectMapper mapper = new ObjectMapper();  
        JsonNode rootNode = mapper.readTree(k);//获取整个json字符串的根节点
        JsonNode dataNode = rootNode.path("service").path("data");
        
        display_str_array[0] = dataNode.path("DiZhiMa").asText();
        display_str_array[1] = dataNode.path("QiTiLeiXing").asText();
        display_str_array[2] = dataNode.path("DanWei").asText();
        display_str_array[3] = dataNode.path("TangCeQiZhuangTai").asText();
        display_str_array[4] = dataNode.path("QiTiNongDu").asText();
        display_str_array[5] = dataNode.path("DiXian").asText();
        display_str_array[6] = dataNode.path("GaoXian").asText();
        display_str_array[7] = dataNode.path("DianLiang").asText();
        display_str_array[8] = dataNode.path("WenDuZhengShu").asText();
        display_str_array[9] = dataNode.path("WenDuXiaoShu").asText();
        //System.out.println("\r\np001: " + dataNode.path("p001").asText());
    } catch (Exception e) {  
    	System.out.println(e.toString());
        e.printStackTrace();  
    }
    
    //将获取到的数据输入到table1数据库中
    try {
    	// 注册 JDBC 驱动
    	Class.forName("com.mysql.jdbc.Driver");
    	// 打开链接
    	conn = DriverManager.getConnection(DB_URL,USER,PASS);
    	// 执行插入
    	stmt = conn.createStatement();
    	String sql = "insert into table1_shijian_jiedian (id, gas, DanWei, status, NongDu, DiXian, GaoXian, DianLiang, WenDu, Date) values (" + display_str_array[0] + ", " + display_str_array[1] + ", " + display_str_array[2] +", " + display_str_array[3] +", " + display_str_array[4] +", " + display_str_array[5] +", " + display_str_array[6] +", " + display_str_array[7] +", " + display_str_array[8] +", now());";
    	stmt.execute(sql);
    	
    	stmt.close();
        conn.close();
    }catch(Exception e){
        // 处理 Class.forName 错误
        e.printStackTrace();
    }finally{
        // 关闭资源
        try{
            if(stmt!=null) stmt.close();
        }catch(SQLException se2){
        }// 什么都不做
        try{
            if(conn!=null) conn.close();
        }catch(SQLException se){
            se.printStackTrace();
        }
    }
    
  //将获取到的数据输入到table1_display数据库中
//    try {
//    	// 注册 JDBC 驱动
//    	Class.forName("com.mysql.jdbc.Driver");
//    	// 打开链接
//    	conn = DriverManager.getConnection(DB_URL,USER,PASS);
//    	// 执行插入
//    	stmt = conn.createStatement();
//    	//对指定节点的数据进行更新
//    	String sql = "update table1_display set p002 = " + display_str_array[1] + ", p003 = " + display_str_array[2] + ", p004 = " + display_str_array[3] + " where p001 = " + display_str_array[0] + ";";
//    	stmt.execute(sql);
//    	
//    	stmt.close();
//        conn.close();
//    }catch(Exception e){
//        // 处理 Class.forName 错误
//        e.printStackTrace();
//    }finally{
//        // 关闭资源
//        try{
//            if(stmt!=null) stmt.close();
//        }catch(SQLException se2){
//        }// 什么都不做
//        try{
//            if(conn!=null) conn.close();
//        }catch(SQLException se){
//            se.printStackTrace();
//        }
//    }
//    
    
    
    
    
    //System.out.println("\r\nlungezuishuai\r\n" + k + "end\r\n");//调试的时候会用到
    return result;
  }
}

DeviceDataChanged.java

package com.huawei.com;

import java.io.Serializable;
import javax.xml.bind.annotation.XmlRootElement;

@XmlRootElement(name="DeviceDataChanged")
public class DeviceDataChanged
  implements Serializable
{
  private static final long serialVersionUID = -6005926332718108639L;
  private String notifyType;
  private String requestId;
  private String deviceId;
  private String gatewayId;
  
  public String getNotifyType()
  {
    return this.notifyType;
  }
  
  public void setNotifyType(String notifyType)
  {
    this.notifyType = notifyType;
  }
  
  public String getRequestId()
  {
    return this.requestId;
  }
  
  public void setRequestId(String requestId)
  {
    this.requestId = requestId;
  }
  
  public String getDeviceId()
  {
    return this.deviceId;
  }
  
  public void setDeviceId(String deviceId)
  {
    this.deviceId = deviceId;
  }
  
  public String getGatewayId()
  {
    return this.gatewayId;
  }
  
  public void setGatewayId(String gatewayId)
  {
    this.gatewayId = gatewayId;
  }
}

pom.xml

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd">
  <modelVersion>4.0.0</modelVersion>
  <groupId>mvn</groupId>
  <artifactId>SSM</artifactId>
  <packaging>war</packaging>
  <version>0.0.1-SNAPSHOT</version>
  <name>SSM Maven Webapp</name>
  <url>http://maven.apache.org</url>
  <properties>
    <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
  </properties>
  <dependencies>
  	
  	<!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java -->
	<dependency>
	    <groupId>mysql</groupId>
	    <artifactId>mysql-connector-java</artifactId>
	    <version>8.0.11</version>
	</dependency>
  	
  	
	<dependency> 
	    <groupId>javax.ws.rs</groupId> 
	    <artifactId>jsr311-api</artifactId> 
	    <version>1.1.1</version> 
	</dependency>
	
	<!-- https://mvnrepository.com/artifact/com.fasterxml.jackson.core/jackson-databind -->
	<dependency>
	    <groupId>com.fasterxml.jackson.core</groupId>
	    <artifactId>jackson-databind</artifactId>
	    <version>2.9.7</version>
	</dependency>
	
	<dependency>
        <groupId>com.sun.jersey</groupId>
        <artifactId>jersey-server</artifactId>
        <version>1.9</version>
    </dependency>
	<dependency>
        <groupId>com.sun.jersey</groupId>
        <artifactId>jersey-client</artifactId>
        <version>1.9</version>
    </dependency>
    <dependency>
        <groupId>com.sun.jersey</groupId>
        <artifactId>jersey-json</artifactId>
        <version>1.9</version>
    </dependency>
    <dependency>
        <groupId>com.sun.jersey.contribs</groupId>
        <artifactId>jersey-multipart</artifactId>
        <version>1.9</version>
    </dependency>
    
    
    
  </dependencies>
  <build>
    <finalName>SSM</finalName>
	<plugins>
 
		<!-- java编译插件 -->
            <plugin>
               <groupId>org.apache.maven.plugins</groupId>
               <artifactId>maven-compiler-plugin</artifactId>
               <configuration>
                   <source>1.8</source>
                   <target>1.8</target>
                   <encoding>UTF-8</encoding>
               </configuration>
           </plugin>
           <plugin>
               <groupId>org.apache.maven.plugins</groupId>
               <artifactId>maven-jar-plugin</artifactId>
               <configuration>
                   <archive>
                       <manifest>
                           <addClasspath>true</addClasspath>
                           <classpathPrefix>lib/</classpathPrefix>
                           <mainClass>com.lunge.wangluo.server_test</mainClass>
                       </manifest>
                   </archive>
               </configuration>
           </plugin>
           <plugin>
               <groupId>org.apache.maven.plugins</groupId>
               <artifactId>maven-dependency-plugin</artifactId>
               <executions>
                   <execution>
                       <id>copy</id>
                       <phase>install</phase>
                       <goals>
                           <goal>copy-dependencies</goal>
                       </goals>
                       <configuration>
                           <outputDirectory>${project.build.directory}/lib</outputDirectory>
                       </configuration>
                   </execution>
               </executions>
           </plugin>
	</plugins>
    
  </build>
</project>