Java中ModBus的使用方法

實例說明ModBus的使用方法：

主要用于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");

}

}