程序员必备Java ModBus的使用方法和操作实例

时间:2022-03-08 20:23:28

程序员必备Java ModBus的使用方法和操作实例

程序员必备Java ModBus的使用方法和操作实例
最近有很多程序员朋友说关于Java ModBus的使用方法要怎么要怎么操作,问我有没有实际的操作案例,今天刚好有时间就来和大家分享一下这个操作案例,希望能帮到大家。

专注于Java架构师技术分享,撩我免费送全套架构师晋级资料

(欢迎撩我wei?心:前面是1253后面是8552)

实例说明:

主要用于JAVA 对ModBus以及串口的通讯操作

1,Test类用于接收数采仪数据,然后核对其CRC校验是否正确,不正确便丢弃,不作任何操作,正确就查找其设备号对应哪个站点,以及其检测指标。然后到DB中查找实时检测值,若未有实时数据可用本实例中的随机数代替,然后保存发送数据到数据库中。得到值后通过CRC16得到其校验码组成其要发送的字节,发送完毕。

2,主要涉及到的类有3个

DB.java 用户得到实时数据,保存发送数据到数据库中

Test.java 用户接收数采仪值,通过com串口发送到数采仪

ModBus的CRC16校验法

数采仪是参照国际HJ/T212-2005

CRC.javal类代码如下:

public class CRC16 {

static final String HEXES = "0123456789ABCDEF";

byte uchCRCHi = (byte) 0xFF;

byte uchCRCLo = (byte) 0xFF;

private static byte[] auchCRCHi = { 0x00, (byte) 0xC1, (byte) 0x81,

(byte) 0x40, (byte) 0x01, (byte) 0xC0, (byte) 0x80, (byte) 0x41,

(byte) 0x01, (byte) 0xC0, (byte) 0x80, (byte) 0x41, (byte) 0x00,

(byte) 0xC1, (byte) 0x81, (byte) 0x40, (byte) 0x01, (byte) 0xC0,

(byte) 0x80, (byte) 0x41, (byte) 0x00, (byte) 0xC1, (byte) 0x81,

(byte) 0x40, (byte) 0x00, (byte) 0xC1, (byte) 0x81, (byte) 0x40,

(byte) 0x01, (byte) 0xC0, (byte) 0x80, (byte) 0x41, (byte) 0x01,

(byte) 0xC0, (byte) 0x80, (byte) 0x41, (byte) 0x00, (byte) 0xC1,

(byte) 0x81, (byte) 0x40, (byte) 0x00, (byte) 0xC1, (byte) 0x81,

(byte) 0x40, (byte) 0x01, (byte) 0xC0, (byte) 0x80, (byte) 0x41,

(byte) 0x00, (byte) 0xC1, (byte) 0x81, (byte) 0x40, (byte) 0x01,

(byte) 0xC0, (byte) 0x80, (byte) 0x41, (byte) 0x01, (byte) 0xC0,

(byte) 0x80, (byte) 0x41, (byte) 0x00, (byte) 0xC1, (byte) 0x81,

(byte) 0x40, (byte) 0x01, (byte) 0xC0, (byte) 0x80, (byte) 0x41,

(byte) 0x00, (byte) 0xC1, (byte) 0x81, (byte) 0x40, (byte) 0x00,

(byte) 0xC1, (byte) 0x81, (byte) 0x40, (byte) 0x01, (byte) 0xC0,

(byte) 0x80, (byte) 0x41, (byte) 0x00, (byte) 0xC1, (byte) 0x81,

(byte) 0x40, (byte) 0x01, (byte) 0xC0, (byte) 0x80, (byte) 0x41,

(byte) 0x01, (byte) 0xC0, (byte) 0x80, (byte) 0x41, (byte) 0x00,

(byte) 0xC1, (byte) 0x81, (byte) 0x40, (byte) 0x00, (byte) 0xC1,

(byte) 0x81, (byte) 0x40, (byte) 0x01, (byte) 0xC0, (byte) 0x80,

(byte) 0x41, (byte) 0x01, (byte) 0xC0, (byte) 0x80, (byte) 0x41,

(byte) 0x00, (byte) 0xC1, (byte) 0x81, (byte) 0x40, (byte) 0x01,

(byte) 0xC0, (byte) 0x80, (byte) 0x41, (byte) 0x00, (byte) 0xC1,

(byte) 0x81, (byte) 0x40, (byte) 0x00, (byte) 0xC1, (byte) 0x81,

(byte) 0x40, (byte) 0x01, (byte) 0xC0, (byte) 0x80, (byte) 0x41,

(byte) 0x01, (byte) 0xC0, (byte) 0x80, (byte) 0x41, (byte) 0x00,

(byte) 0xC1, (byte) 0x81, (byte) 0x40, (byte) 0x00, (byte) 0xC1,

(byte) 0x81, (byte) 0x40, (byte) 0x01, (byte) 0xC0, (byte) 0x80,

(byte) 0x41, (byte) 0x00, (byte) 0xC1, (byte) 0x81, (byte) 0x40,

(byte) 0x01, (byte) 0xC0, (byte) 0x80, (byte) 0x41, (byte) 0x01,

(byte) 0xC0, (byte) 0x80, (byte) 0x41, (byte) 0x00, (byte) 0xC1,

(byte) 0x81, (byte) 0x40, (byte) 0x00, (byte) 0xC1, (byte) 0x81,

(byte) 0x40, (byte) 0x01, (byte) 0xC0, (byte) 0x80, (byte) 0x41,

(byte) 0x01, (byte) 0xC0, (byte) 0x80, (byte) 0x41, (byte) 0x00,

(byte) 0xC1, (byte) 0x81, (byte) 0x40, (byte) 0x01, (byte) 0xC0,

(byte) 0x80, (byte) 0x41, (byte) 0x00, (byte) 0xC1, (byte) 0x81,

(byte) 0x40, (byte) 0x00, (byte) 0xC1, (byte) 0x81, (byte) 0x40,

(byte) 0x01, (byte) 0xC0, (byte) 0x80, (byte) 0x41, (byte) 0x00,

(byte) 0xC1, (byte) 0x81, (byte) 0x40, (byte) 0x01, (byte) 0xC0,

(byte) 0x80, (byte) 0x41, (byte) 0x01, (byte) 0xC0, (byte) 0x80,

(byte) 0x41, (byte) 0x00, (byte) 0xC1, (byte) 0x81, (byte) 0x40,

(byte) 0x01, (byte) 0xC0, (byte) 0x80, (byte) 0x41, (byte) 0x00,

(byte) 0xC1, (byte) 0x81, (byte) 0x40, (byte) 0x00, (byte) 0xC1,

(byte) 0x81, (byte) 0x40, (byte) 0x01, (byte) 0xC0, (byte) 0x80,

(byte) 0x41, (byte) 0x01, (byte) 0xC0, (byte) 0x80, (byte) 0x41,

(byte) 0x00, (byte) 0xC1, (byte) 0x81, (byte) 0x40, (byte) 0x00,

(byte) 0xC1, (byte) 0x81, (byte) 0x40, (byte) 0x01, (byte) 0xC0,

(byte) 0x80, (byte) 0x41, (byte) 0x00, (byte) 0xC1, (byte) 0x81,

(byte) 0x40, (byte) 0x01, (byte) 0xC0, (byte) 0x80, (byte) 0x41,

(byte) 0x01, (byte) 0xC0, (byte) 0x80, (byte) 0x41, (byte) 0x00,

(byte) 0xC1, (byte) 0x81, (byte) 0x40 };

private static byte[] auchCRCLo = { (byte) 0x00, (byte) 0xC0, (byte) 0xC1,

(byte) 0x01, (byte) 0xC3, (byte) 0x03, (byte) 0x02, (byte) 0xC2,

(byte) 0xC6, (byte) 0x06, (byte) 0x07, (byte) 0xC7, (byte) 0x05,

(byte) 0xC5, (byte) 0xC4, (byte) 0x04, (byte) 0xCC, (byte) 0x0C,

(byte) 0x0D, (byte) 0xCD, (byte) 0x0F, (byte) 0xCF, (byte) 0xCE,

(byte) 0x0E, (byte) 0x0A, (byte) 0xCA, (byte) 0xCB, (byte) 0x0B,

(byte) 0xC9, (byte) 0x09, (byte) 0x08, (byte) 0xC8, (byte) 0xD8,

(byte) 0x18, (byte) 0x19, (byte) 0xD9, (byte) 0x1B, (byte) 0xDB,

(byte) 0xDA, (byte) 0x1A, (byte) 0x1E, (byte) 0xDE, (byte) 0xDF,

(byte) 0x1F, (byte) 0xDD, (byte) 0x1D, (byte) 0x1C, (byte) 0xDC,

(byte) 0x14, (byte) 0xD4, (byte) 0xD5, (byte) 0x15, (byte) 0xD7,

(byte) 0x17, (byte) 0x16, (byte) 0xD6, (byte) 0xD2, (byte) 0x12,

(byte) 0x13, (byte) 0xD3, (byte) 0x11, (byte) 0xD1, (byte) 0xD0,

(byte) 0x10, (byte) 0xF0, (byte) 0x30, (byte) 0x31, (byte) 0xF1,

(byte) 0x33, (byte) 0xF3, (byte) 0xF2, (byte) 0x32, (byte) 0x36,

(byte) 0xF6, (byte) 0xF7, (byte) 0x37, (byte) 0xF5, (byte) 0x35,

(byte) 0x34, (byte) 0xF4, (byte) 0x3C, (byte) 0xFC, (byte) 0xFD,

(byte) 0x3D, (byte) 0xFF, (byte) 0x3F, (byte) 0x3E, (byte) 0xFE,

(byte) 0xFA, (byte) 0x3A, (byte) 0x3B, (byte) 0xFB, (byte) 0x39,

(byte) 0xF9, (byte) 0xF8, (byte) 0x38, (byte) 0x28, (byte) 0xE8,

(byte) 0xE9, (byte) 0x29, (byte) 0xEB, (byte) 0x2B, (byte) 0x2A,

(byte) 0xEA, (byte) 0xEE, (byte) 0x2E, (byte) 0x2F, (byte) 0xEF,

(byte) 0x2D, (byte) 0xED, (byte) 0xEC, (byte) 0x2C, (byte) 0xE4,

(byte) 0x24, (byte) 0x25, (byte) 0xE5, (byte) 0x27, (byte) 0xE7,

(byte) 0xE6, (byte) 0x26, (byte) 0x22, (byte) 0xE2, (byte) 0xE3,

(byte) 0x23, (byte) 0xE1, (byte) 0x21, (byte) 0x20, (byte) 0xE0,

(byte) 0xA0, (byte) 0x60, (byte) 0x61, (byte) 0xA1, (byte) 0x63,

(byte) 0xA3, (byte) 0xA2, (byte) 0x62, (byte) 0x66, (byte) 0xA6,

(byte) 0xA7, (byte) 0x67, (byte) 0xA5, (byte) 0x65, (byte) 0x64,

(byte) 0xA4, (byte) 0x6C, (byte) 0xAC, (byte) 0xAD, (byte) 0x6D,

(byte) 0xAF, (byte) 0x6F, (byte) 0x6E, (byte) 0xAE, (byte) 0xAA,

(byte) 0x6A, (byte) 0x6B, (byte) 0xAB, (byte) 0x69, (byte) 0xA9,

(byte) 0xA8, (byte) 0x68, (byte) 0x78, (byte) 0xB8, (byte) 0xB9,

(byte) 0x79, (byte) 0xBB, (byte) 0x7B, (byte) 0x7A, (byte) 0xBA,

(byte) 0xBE, (byte) 0x7E, (byte) 0x7F, (byte) 0xBF, (byte) 0x7D,

(byte) 0xBD, (byte) 0xBC, (byte) 0x7C, (byte) 0xB4, (byte) 0x74,

(byte) 0x75, (byte) 0xB5, (byte) 0x77, (byte) 0xB7, (byte) 0xB6,

(byte) 0x76, (byte) 0x72, (byte) 0xB2, (byte) 0xB3, (byte) 0x73,

(byte) 0xB1, (byte) 0x71, (byte) 0x70, (byte) 0xB0, (byte) 0x50,

(byte) 0x90, (byte) 0x91, (byte) 0x51, (byte) 0x93, (byte) 0x53,

(byte) 0x52, (byte) 0x92, (byte) 0x96, (byte) 0x56, (byte) 0x57,

(byte) 0x97, (byte) 0x55, (byte) 0x95, (byte) 0x94, (byte) 0x54,

(byte) 0x9C, (byte) 0x5C, (byte) 0x5D, (byte) 0x9D, (byte) 0x5F,

(byte) 0x9F, (byte) 0x9E, (byte) 0x5E, (byte) 0x5A, (byte) 0x9A,

(byte) 0x9B, (byte) 0x5B, (byte) 0x99, (byte) 0x59, (byte) 0x58,

(byte) 0x98, (byte) 0x88, (byte) 0x48, (byte) 0x49, (byte) 0x89,

(byte) 0x4B, (byte) 0x8B, (byte) 0x8A, (byte) 0x4A, (byte) 0x4E,

(byte) 0x8E, (byte) 0x8F, (byte) 0x4F, (byte) 0x8D, (byte) 0x4D,

(byte) 0x4C, (byte) 0x8C, (byte) 0x44, (byte) 0x84, (byte) 0x85,

(byte) 0x45, (byte) 0x87, (byte) 0x47, (byte) 0x46, (byte) 0x86,

(byte) 0x82, (byte) 0x42, (byte) 0x43, (byte) 0x83, (byte) 0x41,

(byte) 0x81, (byte) 0x80, (byte) 0x40 };

public int value;

public CRC16() {

value = 0;

}

public void update(byte[] puchMsg, int usDataLen) {

int uIndex;

// int i = 0;

for (int i = 0; i < usDataLen; i ) {

uIndex = (uchCRCHi ^ puchMsg[i]) & 0xff;

uchCRCHi = (byte) (uchCRCLo ^ auchCRCHi[uIndex]);

uchCRCLo = auchCRCLo[uIndex];

}

value = ((((int) uchCRCHi) << 8 | (((int) uchCRCLo) & 0xff))) & 0xffff;

return;

}

public void reset() {

value = 0;

uchCRCHi = (byte) 0xff;

uchCRCLo = (byte) 0xff;

}

public int getValue() {

return value;

}

private static byte uniteBytes(byte src0, byte src1) {

byte _b0 = Byte.decode("0x" new String(new byte[] { src0 }))

.byteValue();

_b0 = (byte) (_b0 << 4);

byte _b1 = Byte.decode("0x" new String(new byte[] { src1 }))

.byteValue();

byte ret = (byte) (_b0 ^ _b1);

return ret;

}

private static byte[] HexString2Buf(String src) {

int len = src.length();

byte[] ret = new byte[len / 2 2];

byte[] tmp = src.getBytes();

for (int i = 0; i < len; i = 2) {

ret[i / 2] = uniteBytes(tmp[i], tmp[i 1]);

}

return ret;

}

public static byte[] getSendBuf(String toSend){

byte[] bb = HexString2Buf(toSend);

CRC16 crc16 = new CRC16();

crc16.update(bb, bb.length-2);

int ri = crc16.getValue();

bb[bb.length-1]=(byte) (0xff & ri);

bb[bb.length-2]=(byte) ((0xff00 & ri) >> 8);

return bb;

}

public static boolean checkBuf(byte[] bb){

CRC16 crc16 = new CRC16();

crc16.update(bb, bb.length-2);

int ri = crc16.getValue();

if(bb[bb.length-1]==(byte)(ri&0xff)

&& bb[bb.length-2]==(byte) ((0xff00 & ri) >> 8))

return true;

return false;

}

public static String getBufHexStr(byte[] raw){

if ( raw == null ) {

  return null;

}

final StringBuilder hex = new StringBuilder( 2 * raw.length );

for ( final byte b : raw ) {

  hex.append(HEXES.charAt((b & 0xF0) >> 4))

    .append(HEXES.charAt((b & 0x0F)));

}

return hex.toString().toLowerCase();

}

/****

  • 得到CRC验证

  • @param tt

  • @return

*/

public static String getCrc(String tem){

// String tem="";

// for(int i=0;i<tt.length;i ){

// tem =tt[i];

// System.out.println("这是传入的值" tt[i]);

// }

byte[] sbuf = CRC16.getSendBuf(tem);

System.out.println("这是得到的crc" CRC16.getBufHexStr(sbuf));

return CRC16.getBufHexStr(sbuf).substring(12, 16).toLowerCase();

}

/**得到要发送的数据

  • @param args

*/

public static String getSendData(String [] tt) {

String tem="";

for(int i=0;i<tt.length;i ){

tem =tt[i];

}

byte[] sbuf = CRC16.getSendBuf(tem);

return CRC16.getBufHexStr(sbuf);

}

public static byte[] getSendBuf2(String [] tt){

String tem="";

for(int i=0;i<tt.length;i ){

tem =tt[i];

}

byte[] bb = HexString2Buf(tem);

CRC16 crc16 = new CRC16();

crc16.update(bb, bb.length-2);

int ri = crc16.getValue();

bb[bb.length-1]=(byte) (0xff & ri);

bb[bb.length-2]=(byte) ((0xff00 & ri) >> 8);

return bb;

}

public static void main(String[] args) {

// TODO Auto-generated method stub

//0103040a3d3fb739a1----sendB

//010304b8523ffeef32----sendB

byte[] sbuf = CRC16.getSendBuf("0103040a3d3fb7");

System.out.println(CRC16.getBufHexStr(sbuf));

}

}

Test代码如下:

package oldTest;

import java.io.Flushable;

import java.io.InputStream;

import java.io.OutputStream;

import java.util.Enumeration;

import java.util.Random;

import javax.comm.CommPortIdentifier;

import javax.comm.SerialPort;

public class Test {

static Enumeration portList;

static CommPortIdentifier portId;

static SerialPort serialPort;

static OutputStream outputStream;

static InputStream inputStream;

static String nodeIdx="";

static String crc="";

public static StringBuffer open()throws Exception {

CommPortIdentifier commportidentifier = CommPortIdentifier

.getPortIdentifier("COM1");

serialPort = (SerialPort) commportidentifier.open("scy app", 80);

outputStream = serialPort.getOutputStream();

inputStream = serialPort.getInputStream();

InputStream input = serialPort.getInputStream();

while (true) {

StringBuffer content = new StringBuffer();

int i = 0;

String tag = "";

String crcCode1 = "";

String[] inputString = new String[6];

String crcCode2 = "";

String tempString = "";

serialPort.setInputBufferSize(8);

while (i < 8) {

if (i < 6) {

tempString = Integer.toHexString(input.read());

if (tempString.length() < 2) {

tempString = "0" tempString;

}

inputString[i] = tempString;

// inputString[0];得到站点名称

nodeIdx = inputString[0];

// inputString[2] inputString[3];得到检测指标

tag = inputString[2] inputString[3];

content.append(tempString);

System.out.println("==这是数据段" content);

} else {

if (i == 6) {// 得到Crc值的前两位

crcCode1 = Integer.toHexString(input.read());

if (crcCode1.length() < 2) {

crcCode1 = "0" crcCode1;

}

}

if (i == 7) {// 得到Crc值的后两位

crcCode2 = Integer.toHexString(input.read());

if (crcCode2.length() < 2) {

crcCode2 = "0" crcCode2;

}

}

crc=crcCode1 crcCode2;

System.out.println("==这是crc" crc);

}

i ;

}

if (CRC16.getCrc(content.toString()).equals(crc)) {

// System.out.println(crcCode1 crcCode2 "得到的数据段正确"

// CRC16.getCrc(inputString));

String nodeName = "";

if (nodeIdx.equals("01")) {

nodeName = "监测站点1";

checkNode(tag, nodeName);

} else {

System.out.println("这也许是监测站点2的站点");

nodeName = "监测站点2";

checkNode(tag, nodeName);

}

} else {

System.out.println(crc "得到的数据段不正确"

  • CRC16.getCrc(content.toString()));

}

}

}

public static void main(String[] args) {

try {

open();

} catch (Exception e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

}

public static void checkNode(String tag, String nodeName) {

if (tag.equals("012c")) {

// System.out.println("这是说明要查悬浮物");

sendData(nodeName, "悬浮物");

} else if (tag.equals("0064")) {

// System.out.println("这是说明要查PH值");

sendData(nodeName, "PH值");

} else if (tag.equals("0b54")) {

// System.out.println("这是说明要查氨氮");

sendData(nodeName, "氨氮");

} else if (tag.equals("0d48")) {

sendData(nodeName, "污水总量");

} else if (tag.equals("0000")) {

sendData(nodeName, "污水总量");

} else if (tag.equals("01f4")) {

sendData(nodeName, "COD");

} else {

// System.out.println(tag "这个tag不知道是啥");

}

}

public static int getRandom(int min, int max) {

Random random = new Random();

int s = random.nextInt(max) % (max - min 1) min;

return s;

}

public static int getRandomEnd() {

int max = 99;

int min = 01;

Random random = new Random();

int s = random.nextInt(max) % (max - min 1) min;

return s;

}

public static float getFloatNum(int min, int max) {

return Float.valueOf(getRandom(min, max) "." getRandomEnd());

}

public static void sendData(String nodeName, String tagName) {

DB db = new DB();

try {

Float ff = 0f;

// ff = db.onSelect(nodeName, tagName);

ff=getFloatNum(1,99);

java.text.NumberFormat formater = java.text.DecimalFormat

.getInstance();

String[] totalTemp = new String[7];

if (nodeName.equals("检测站点1")) {

totalTemp[0] = "01";

// if(tagName.equals("COD")){

// ff=15f;

// }else{

// ff=11f;

// }

} else {

totalTemp[0] = "02";

}

formater.setMaximumFractionDigits(2);

formater.setMinimumFractionDigits(2);

ff = Float.valueOf(formater.format(ff));

System.out.println("查询完毕," tagName "值为:" ff);

int fi = Float.floatToRawIntBits(ff);

String num = Integer.toHexString(fi).toString();

if (!num.equals("0")) {

totalTemp[1] = "03";

totalTemp[2] = "04";

totalTemp[4] = num.substring(6, 8);

totalTemp[3] = num.substring(4, 6);

totalTemp[6] = num.substring(2, 4);

totalTemp[5] = num.substring(0, 2);

} else {

totalTemp[1] = "03";

totalTemp[2] = "04";

totalTemp[4] = "00";

totalTemp[3] = "00";

totalTemp[6] = "00";

totalTemp[5] = "00";

}

byte[] sendB = CRC16.getSendBuf2(totalTemp);

outputStream.write(sendB);

outputStream.flush();

outputStream.close();

System.out.println("发送完毕");

} catch (Exception e) {

e.printStackTrace();

} finally {

db.close();

}

}

}

DB类如下:

package oldTest;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

import java.util.Calendar;

import java.util.Random;

public class DB {

private Connection con;

private Statement sta;

private ResultSet res;

private String driverName = "com.microsoft.jdbc.sqlserver.SQLServerDriver"; // 加载JDBC驱动

private String dbURL = "jdbc:sqlserver://localhost:1433; DatabaseName=MonitoringSystem"; // 连接服务器和数据库sample

private String userName = "sa"; // 默认用户名

private String userPwd = ""; // 密码

public DB() {

try {

Class.forName(driverName);

con = DriverManager.getConnection(dbURL, userName, userPwd);

// System.out.println("Connection Successful!"); // 如果连接成功

// 控制台输出Connection

// Successful!

} catch (ClassNotFoundException e) {

// TODO Auto-generated catch block

e.printStackTrace();

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

}

public static int getRandom(int min, int max) {

Random random = new Random();

int s = random.nextInt(max) % (max - min 1) min;

return s;

}

public static int getRandomEnd() {

int max = 99;

int min = 01;

Random random = new Random();

int s = random.nextInt(max) % (max - min 1) min;

return s;

}

public static float getFloatNum(int min, int max) {

return Float.valueOf(getRandom(min, max) "." getRandomEnd());

}

public static float getCFZ() {

return getFloatNum(40, 48);

}

public static float getCY() {

return getFloatNum(100, 110);

}

/***

  • 得到N条记录

  • @param tagName

  • @return

*/

public Float onSelect(String nodeName, String tagName) {

Float ff = 0f;

String sql = "select * from DQYT_MacamCore.dbo.tpoints where name=‘"

  • tagName "‘ and fullname like ‘%" nodeName "%‘";

try {

sta = con.createStatement();

res = sta.executeQuery(sql);

while (res.next()) {

int tagid = res.getInt("tagId");

String name = res.getString("Name");

String sql2 = "select top 1 * from DQYT_MacamHisData.dbo."

  • getTBName() " where tagid=" tagid

  • " order by idx desc ";

// System.out.println(sql2);

ResultSet rs2;

Statement sta2 = null;

sta2 = con.createStatement();

rs2 = sta2.executeQuery(sql2);

if (tagName.equals("污水总量")) {

String sql3 = "insert into MonitoringSystem.dbo.UploadInfo values("

  • tagid

  • ",‘"

  • name

  • "‘,"

  • ff

  • ",‘"

  • getEndTime() "‘)";

System.out.println(sql3);

Statement sta3 = null;

sta3 = con.createStatement();

sta3.executeUpdate(sql3);

return ff;

} else {

if (name.equals(tagName)) {

while (rs2.next()) {

if (nodeName.equals("监测站点1")) {

if (rs2.getFloat(4) >= 50) {

ff = getCFZ();

} else {

ff = rs2.getFloat(4);

}

} else if (nodeName.equals("监测站点2")) {

if (rs2.getFloat(4) >= 120) {

ff = getCY();

} else {

ff = rs2.getFloat(4);

}

}

String sql3 = "insert into MonitoringSystem.dbo.UploadInfo values("

  • tagid

  • ",‘"

  • name

  • "‘,"

  • ff

  • ",‘"

  • getEndTime() "‘)";

System.out.println(sql3);

Statement sta3 = null;

sta3 = con.createStatement();

sta3.executeUpdate(sql3);

return ff;

}

}

}

}

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

return 0f;

}

/***

  • 根据站点名称,得到其污水总量

  • @param tagName

  • @return

*/

public Float getTagAndTypeLayerId(String nodeName, String tagName) {

String sql = "select * from DQYT_MacamCore.dbo.tpoints where name=‘"

  • tagName "‘ and fullname like ‘%" nodeName "%‘";

try {

sta = con.createStatement();

res = sta.executeQuery(sql);

// System.out.println(sql);

while (res.next()) {

int tagid = res.getInt("tagId");

String name = res.getString("Name");

String errorAmount = getErrorAmount(res.getInt("nodeIdx"));

Long tSewage = getTSewage(tagid);

ResultSet rs2;

Statement sta2 = null;

sta2 = con.createStatement();

sql = "insert into MonitoringSystem.dbo.UploadInfo values("

  • tagid

  • ",‘"

  • name

  • "‘,"

  • Float

.valueOf((Long.parseLong(errorAmount) tSewage))

  • ",‘" getEndTime() "‘)";

sta2.executeUpdate(sql);

return Float.valueOf((Long.parseLong(errorAmount) tSewage));

}

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

return null;

}

/***

  • 得到污水总量

  • @param tagId

  • @return

*/

public Long getTSewage(int tagId) {

try {

String sql = "select sum(tSewage) from MonitoringSystem.dbo.TotalSewage where tagId="

  • tagId;

sta = con.createStatement();

res = sta.executeQuery(sql);

if (res.next()) {

Long tSewage = res.getLong(1);

return tSewage;

}

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

return new Long(0);

}

/***

  • 得到该站点的误差值

  • @param typeLayerIdx

  • @return

*/

public String getErrorAmount(int typeLayerIdx) {

try {

String sql = "select * from MonitoringSystem.dbo.SiteMessage where typeLayerIdx="

  • typeLayerIdx;

sta = con.createStatement();

res = sta.executeQuery(sql);

while (res.next()) {

String errorAmount = res.getString("errorAmount");

return errorAmount;

}

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

} catch (Exception ee) {

ee.printStackTrace();

}

return "0";

}

public void close() {

try {

if (sta != null) {

sta.close();

}

if (con != null) {

con.close();

}

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

}

public String getTBName() {

java.util.Date d = new java.util.Date();

java.text.SimpleDateFormat sdf = new java.text.SimpleDateFormat();

sdf.applyPattern("yyyyMMdd");

String table = "THisData" sdf.format(d);

table = "THisData20091218";

return table;

}

public String getStartTime() {

java.util.Date d = new java.util.Date();

Calendar cal1 = Calendar.getInstance();

// cal1.set(2010, 04, 21);

d.setMinutes(d.getMinutes() - 1);

java.text.SimpleDateFormat sdf = new java.text.SimpleDateFormat();

sdf.applyPattern("yyyy-MM-dd HH:mm");

String ttime = sdf.format(d.getTime());

return ttime;

}

public static String getEndTime() {

java.util.Date d = new java.util.Date();

Calendar cal1 = Calendar.getInstance();

// cal1.set(2010, 04, 21);

java.text.SimpleDateFormat sdf = new java.text.SimpleDateFormat();

sdf.applyPattern("yyyy-MM-dd HH:mm");

String ttime = sdf.format(d.getTime());

return ttime;

}

public static void main(String[] args) {

DB db = new DB();

db.onSelect("监测站点1", "COD");

}

}

转发 关注后私信我回复【架构资料】即可免费领取全套架构师学习资料