基于温湿度传感器物联网应用实时数据处理系统开发(个人版 4)(2)

来源：网络收集时间：2026-04-11

导读： +---------------+----------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------------+----------+------+-----+---------+-------+ | StId | int(11) | NO | | | | |

+---------------+----------+------+-----+---------+-------+

+---------------+----------+------+-----+---------+-------+

| StId | int(11) | NO | | | | | Stdatetime | char(50) | NO | | | | | Sttemperature | char(50) | NO | | | | | Sthumidity | char(50) | NO | | | | +---------------+----------+------+-----+---------+-------+

TCPServer.java代码源：

import java.io.*;

import .*;

import java.sql.*;

import java.util.StringTokenizer;

课程设计

class TCPServer

{

public static void main(String argv[]) throws Exception

{

int qq=-1,pp;

String clientSentence;

String capitalizedSentence;

ServerSocket welcomeSocket = new ServerSocket

(6789);

String driver = "com.mysql.jdbc.Driver";

String url = "jdbc:mysql://127.0.0.1:3306/test_db"; String user = "root";

String password = "123456";

while(true)

{

Socket connectionSocket = welcomeSocket.

accept();

BufferedReader inFromClient =

new BufferedReader(new InputStreamReader(

connectionSocket.getInputStream()));

DataOutputStream outToClient =

new DataOutputStream(

connectionSocket.getOutputStream());

clientSentence = inFromClient.readLine();

StringTokenizer st = new

StringTokenizer(clientSentence,"#");

try {

Class.forName(driver);

课程设计

Connection conn = DriverManager.getConnection(url, user, password);

if(!conn.isClosed())

System.out.println("Succeeded connecting to the Database!");

Statement statement = conn.createStatement(); while (st.hasMoreTokens()) {

//System.out.println(st.nextToken());

StringTokenizer st1 = new

StringTokenizer(st.nextToken(),"$");

while (st1.hasMoreTokens()) {

//System.out.println(st1.nextToken()); String StId=st1.nextToken();

String Stdatetime=st1.nextToken();

String Sttemperature=st1.nextToken();

String

Sthumidity=st1.nextToken();

//String

StSize=st1.nextToken();

// String

StUsed=st1.nextToken();

System.out.println("StId="+StId);

System.out.println("Stdatetime="+Stdatetime);

System.out.println("Sttemperature="+Sttemperature);

System.out.println("Sthumidity="+Sthumidity);

//System.out.println("StSize="+StSize);

课程设计

//System.out.println("StUsed="+StUsed);

pp=Integer.parseInt(StId); if(qq<pp){ String sql = "INSERT INTO Sdata

VALUES('"+StId+"','"+Stdatetime+"','"+Sttemperature+"','"+Sthumidity+"')";

System.out.println(clientSentence);

capitalizedSentence =

clientSentence.toUpperCase() + '\n';

outToClient.writeBytes(capitalizedSentence);

}

qq=pp; statement.executeUpdate(sql); } } } conn.close(); } catch(ClassNotFoundException e) { System.out.println("Sorry,can`t find the Driver!"); e.printStackTrace(); } catch(SQLException e) { e.printStackTrace(); } catch(Exception e) { e.printStackTrace(); }

课程设计

2. 实时数据显示（给出实时以曲线形式显示MySql数据库中实时数据的JSP源代码及显示曲线截图）

JSP源代码：

<%@page contentType="text/html" pageEncoding="UTF-8"%>

<%@page import = "java.sql.*" %>

<%@page import="java.util.Properties"%>

<%@ page import="java.text.SimpleDateFormat" %>

<%@ page import="java.util.Date" %>

<%@ page import="java.awt.*" %>

<%@ page import="java.io.*" %>

<%@ page import="org.jfree.chart.*" %>

<%@ page import="org.jfree.chart.axis.*" %>

<%@ page import="org.jfree.chart.entity.*" %>

<%@ page import="bels.*" %>

<%@ page import="org.jfree.chart.plot.*" %>

<%@ page import="org.jfree.chart.renderer.category.*" %>

<%@ page import="org.jfree.chart.urls.*" %>

<%@ page import="org.jfree.data.category.*" %>

<%@ page import="org.jfree.data.general.*" %>

<%@ page import="org.jfree.data.category.DefaultCategoryDataset" %> <%@ page import="org.jfree.data.general.DefaultPieDataset" %> <%@ page import="org.jfree.data.xy.*" %>

<%@ page import="org.jfree.data.*" %>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "/TR/html4/loose.dtd">

SimpleDateFormat sdf1 = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");

SimpleDateFormat sdf2 = new

SimpleDateFormat("yyyyMMddHHmmss");

课程设计

XYSeries series = new XYSeries("Time Temperature"); try{

String databaseURL =

"jdbc:mysql://localhost:3306/test_db";

Class.forName("com.mysql.jdbc.Driver");

Properties properties = new Properties();

properties.put("user", "root");

properties.put("password", "123456");

Connection conn = DriverManager.getConnection(databaseURL, properties);

Statement Stmt = conn.createStatement();

ResultSet RS = Stmt.executeQuery("SELECT * from Sdata");

while (RS.next()) { //Date date = new Date(RS.getString(2););

String nowTime1 =RS.getString(2);

String nowTime2 …… 此处隐藏：3666字，全部文档内容请下载后查看。喜欢就下载吧 ……

基于温湿度传感器物联网应用实时数据处理系统开发(个人版 4)(2).doc 将本文的Word文档下载到电脑，方便复制、编辑、收藏和打印

下载这篇word文档

本文链接：https://www.jiaowen.net/wenku/98079.html（转载请注明文章来源）

上一篇：Unit 1_your_college_years,大学英语精读3第一课
下一篇：4校本研修个人成长档案

基于温湿度传感器物联网应用实时 数据处理系统开发(个人版 4)(2)

基于温湿度传感器物联网应用实时数据处理系统开发(个人版 4)(2)