package?rs232;

import?java.io.IOException;
import?java.io.InputStream;
import?java.io.OutputStream;
import?java.sql.PreparedStatement;
import?java.util.TooManyListenersException;

import?javax.comm.CommPortIdentifier;
import?javax.comm.NoSuchPortException;
import?javax.comm.PortInUseException;
import?javax.comm.SerialPort;
import?javax.comm.SerialPortEvent;
import?javax.comm.SerialPortEventListener;
import?javax.comm.UnsupportedCommOperationException;
import?javax.swing.JComponent;

import?com.sun.corba.se.pept.transport.Connection;

import?util.DBHelper;

public??abstract?class?Rs232?implements?SerialPortEventListener
{
	private?CommPortIdentifier?portId;//用于管理端口
	private?SerialPort?sp;//用于串口通信
	private?int?BaudRate=9600;
	private?int?WordSize=8;
	private?int?StopBit=1;
	private?int?Pariy=0;
	private?boolean?state=true;
	private?String?com=“COM3“;
	java.sql.Connection?conn?=?null;
	PreparedStatement?stmt?=?null;
	/////////////////////初始化//////////////////////////////////////
	public?Rs232（）?
	{
//		openCom（“COM3“）;
//		setParamas（19200?8?1?0）;
	}
????//////////////////讀信息/////////////////////////////////////////
	public??String??read（）?
	{
		String?s=null;
		int?temp?=?0;
		int?humi?=?0;
		try?
		{
			
			InputStream?inp=sp.getInputStream（）;
			if?（inp.available（）>0）?
			{
				byte[]?readBuffer?=?new?byte[inp.available（）];
				inp.read（readBuffer）;
				s=new?String（readBuffer）;
				//解析收到的數據
				temp?=?Integer.parseInt（s.substring（s.indexOf（“:“）+1?s.indexOf（“:“）+3））;
				humi?=?Integer.parseInt（s.substring（s.lastIndexOf（“:“）+1s.length（）-1））;
				System.out.println（s）;
				System.out.println（“溫度：“?+?temp?+?“；濕度:“?+?humi）;
				//使用的sql語句
				String?sql?=?“insert?into?tempahumi（temphumi）values（“+temp+““+humi+“）“;
				//獲得數據庫連接
				try?{
					conn?=?DBHelper.getConnection（）;
					stmt?=?conn.prepareStatement（sql）;
					stmt.executeUpdate（）;		
				}?catch?（Exception?e）?{

					e.printStackTrace（）;
				}
			}
		}?
		catch?（IOException?e）?
		{
			e.printStackTrace（）;
		}
		
		return?s;
		
		
	}
????///////////////////寫信息////////////////////////////////////////
	public?void?write（byte[]?b）?
	{
		if?（state==true）?
		{
			try?
			{
				OutputStream?out=sp.getOutputStream（）;
				out.write（b）;
			}?
			catch?（IOException?e）?
			{
				e.printStackTrace（）;
			}
		}
		
	}
///////////////////打開端口//////////////////////////////////////
	public?boolean?openCom（String?p）
	{
		com=p;
		try?
		{
			
			portId=CommPortIdentifier.getPortIdentifier（com）;
			sp=（SerialPort）portId.open（“rs232“?2000）;
			sp.addEventListener（this）;
			sp.notifyondataavailable（true）;
		}?
		catch?（PortInUseException?e）?
		{
			state=false;
			e.printStackTrace（）;
			System.out.println（“不能?“）;
		}
????????catch?（TooManyListenersException?e）?
????????{
			e.printStackTrace（）;
		}?
????????catch?（NoSuchPortException?e）?
????????{
			e.printStackTrace（）;
		}
		retu

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件????????305??2017-12-18?13:52??AssistantAnd2MySQL\.classpath

?????文件????????394??2018-01-23?17:15??AssistantAnd2MySQL\.project

?????文件????????598??2017-12-18?13:46??AssistantAnd2MySQL\.settings\org.eclipse.jdt.core.prefs

?????文件???????5171??2018-01-23?17:25??AssistantAnd2MySQL\bin\rs232\Rs232.class

?????文件????????753??2018-01-23?17:24??AssistantAnd2MySQL\bin\ui\Ui$1.class

?????文件????????723??2018-01-23?17:24??AssistantAnd2MySQL\bin\ui\Ui$10.class

?????文件????????779??2018-01-23?17:24??AssistantAnd2MySQL\bin\ui\Ui$11.class

?????文件????????958??2018-01-23?17:24??AssistantAnd2MySQL\bin\ui\Ui$12.class

?????文件????????875??2018-01-23?17:24??AssistantAnd2MySQL\bin\ui\Ui$2.class

?????文件????????994??2018-01-23?17:24??AssistantAnd2MySQL\bin\ui\Ui$3.class

?????文件????????994??2018-01-23?17:24??AssistantAnd2MySQL\bin\ui\Ui$4.class

?????文件????????994??2018-01-23?17:24??AssistantAnd2MySQL\bin\ui\Ui$5.class

?????文件????????994??2018-01-23?17:24??AssistantAnd2MySQL\bin\ui\Ui$6.class

?????文件????????843??2018-01-23?17:24??AssistantAnd2MySQL\bin\ui\Ui$7.class

?????文件????????838??2018-01-23?17:24??AssistantAnd2MySQL\bin\ui\Ui$8$1.class

?????文件???????1058??2018-01-23?17:24??AssistantAnd2MySQL\bin\ui\Ui$8.class

?????文件????????718??2018-01-23?17:24??AssistantAnd2MySQL\bin\ui\Ui$9.class

?????文件????????755??2018-01-23?17:24??AssistantAnd2MySQL\bin\ui\Ui$Shapes.class

?????文件???????6881??2018-01-23?17:24??AssistantAnd2MySQL\bin\ui\Ui.class

?????文件???????1624??2018-01-23?17:25??AssistantAnd2MySQL\bin\util\DBHelper.class

?????文件?????540852??2015-01-14?00:02??AssistantAnd2MySQL\lib\mysql-connector-java-5.0.8.jar

?????文件????????231??2018-01-23?17:20??AssistantAnd2MySQL\README.txt

?????文件???????5244??2018-01-23?17:25??AssistantAnd2MySQL\src\rs232\Rs232.java

?????文件??????10245??2017-12-18?19:29??AssistantAnd2MySQL\src\ui\Ui.java

?????文件???????1373??2018-01-23?17:25??AssistantAnd2MySQL\src\util\DBHelper.java

?????目錄??????????0??2018-01-23?17:24??AssistantAnd2MySQL\bin\rs232

?????目錄??????????0??2018-01-23?17:24??AssistantAnd2MySQL\bin\ui

?????目錄??????????0??2018-01-23?17:24??AssistantAnd2MySQL\bin\util

?????目錄??????????0??2018-01-23?17:13??AssistantAnd2MySQL\src\rs232

?????目錄??????????0??2018-01-23?17:13??AssistantAnd2MySQL\src\ui

............此處省略9個文件信息