package?javaSGIP;


import?java.util.Date;
import?java.util.Calendar;
import?java.sql.*;
import?java.text.SimpleDateFormat;
import?com.huawei.insa2.comm.sgip.message.*;
import?com.huawei.insa2.util.*;

public?class?DbMonitor?extends?Thread?{
	private?MySgipProxy?smproxy;
	private?Args?args;
	private?SimpleDateFormat?df=new?SimpleDateFormat（“yyyy-MM-dd?HH:mm:ss“）;
	public?DbMonitor（MySgipProxy?smproxyArgs?args）{
		this.smproxy=smproxy;
		this.args=args;
	}
	private?Statement?getConnection（）{
		?Statement?stmt=null;
?????????Connection?conn=null;
?????????try{?
????????????Class.forName（“com.mysql.jdbc.Driver“）.newInstance（）;?
????????????conn?=?DriverManager.getConnection（“jdbc:mysql://127.0.0.1:3306/sgip?“?+?
????????????“user=sgip&password=sgip123“）;
?????????????stmt?=?conn.createStatement（ResultSet.TYPE_SCROLL_INSENSITIVE
			????????ResultSet.CONCUR_UPDATABLE）;
?????????????System.out.println（df.format（new?Date（））+“?數(shù)據(jù)庫(kù)連接成功“）;
????????????
????????????}
???????catch（Exception?e）?
????????????{?
?????????
????????????e.printStackTrace（）;?
????????????}?
???????
?????????return?stmt;
	}
	public?void?run（）{
		Statement?stmt=getConnection（）;
		ResultSet?rs?=?null;
		while（true）{
		try{
		if?（stmt.execute（“SELECT?*?FROM?sgipsubmits??where?Status=0?limit?10“））???//如果數(shù)據(jù)庫(kù)中有短信取出指定條記錄（默認(rèn)10條）
	?????????rs?=?stmt.getResultSet（）;
		if（rs.next（））{
		????if?（smproxy.connect（nullnull））{
			?????do{
			???????//?Calendar?rightnow=Calendar.getInstance（）;
//Date?schdate=rightnow.getTime（）;
//rightnow.set（Calendar.HOUR_OF_DAYrightnow.get（Calendar.HOUR_OF_DAY）+1）;
//Date?expdate=rightnow.getTime（）;
????????????????????????????????//?Calendar?rightnow=Calendar.getInstance（）;
?????????????????????????????????SGIPSubmitMessage?message=new?SGIPSubmitMessage（
				????args.get（“SPNumber“?“10655717“）//	String?SPNumber
			????	rs.getString（“DestTermID“）.split（““）[0]//?String?ChargeNumber
			????	rs.getString（“DestTermID“）.split（““）//String[]?UserNumber
			????	args.get（“CorpId“?“15576“）//?String?CorpId
			????	“11“?//?????String?ServiceType
				????2//?????int?FeeType
			????	?“00“?//????String?FeeValue
			????	?“00“//?????String?GivenValue
			????	??1//????int?AgentFlag
			????	??1//????int?MorelatetoMTFlag
			????	??1//????int?Priority
??????????????????????????????????null??????//???Date?ExpireTime
			????	?null//????Date?ScheduleTime
			????	??1//????int?ReportFlag
			????	??0//?????int?TP_pid
			????	??0//????int?TP_udhi
			????	??8//????int?MessageCoding
			????	??1//????int?MessageType
			????	??rs.getString（“MsgContent“）.getBytes（）.length//????int?MessageLen
			????	??rs.getString（“MsgContent“）.getBytes（）//????byte[]?MessageContent
			????	??“?“?//????String?reserve?
			????	??）;
			??????????//message.setSrcNodeId（2047115576）;
			??????????if（（（SGIPSubmitRepMessage）smproxy.send（message））.getResult（）==0）{
			????????	??System.out.println（d

?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----

?????文件????????872??2009-04-08?02:59??sgipdb.sql

?????文件???????1008??2009-04-19?12:19??app.xml

?????文件???????3410??2009-04-07?20:05??javaSGIP\DbMonitor.class

?????文件???????3653??2009-04-07?20:05??javaSGIP\DbMonitor.java

?????文件???????1193??2009-04-07?23:53??javaSGIP\MySgipProxy.class

?????文件????????838??2009-03-20?11:27??javaSGIP\MySgipProxy.java

?????文件???????1174??2009-04-03?21:19??javaSGIP\SGIP.class

?????文件????????628??2009-03-20?09:49??javaSGIP\SGIP.java

?????文件?????566623??2008-03-04?11:48??lib\mysql-connector-java-5.1.0-bin.jar

?????文件?????480026??2009-04-07?23:47??lib\smproxy.jar

?????文件?????????86??2009-03-16?15:02??sgip.bat

?????目錄??????????0??2009-04-07?23:56??javaSGIP

?????目錄??????????0??2009-04-07?23:47??lib

?????文件???????1008??2009-04-19?12:19??聯(lián)通網(wǎng)關(guān)\app.xml

?????文件???????3410??2009-04-07?20:05??聯(lián)通網(wǎng)關(guān)\javaSGIP\DbMonitor.class

?????文件???????3653??2009-04-07?20:05??聯(lián)通網(wǎng)關(guān)\javaSGIP\DbMonitor.java

?????文件???????1193??2009-04-07?23:53??聯(lián)通網(wǎng)關(guān)\javaSGIP\MySgipProxy.class

?????文件????????838??2009-03-20?11:27??聯(lián)通網(wǎng)關(guān)\javaSGIP\MySgipProxy.java

?????文件???????1174??2009-04-03?21:19??聯(lián)通網(wǎng)關(guān)\javaSGIP\SGIP.class

?????文件????????628??2009-03-20?09:49??聯(lián)通網(wǎng)關(guān)\javaSGIP\SGIP.java

?????文件?????566623??2008-03-04?11:48??聯(lián)通網(wǎng)關(guān)\lib\mysql-connector-java-5.1.0-bin.jar

?????文件?????480026??2009-04-07?23:47??聯(lián)通網(wǎng)關(guān)\lib\smproxy.jar

?????文件???????8902??2013-01-24?11:06??聯(lián)通網(wǎng)關(guān)\momt.txt

?????文件?????????86??2009-03-16?15:02??聯(lián)通網(wǎng)關(guān)\sgip.bat

?????文件????????872??2009-04-08?02:59??聯(lián)通網(wǎng)關(guān)\sgipdb.sql

?????文件???????5688??2005-12-30?15:54??聯(lián)通網(wǎng)關(guān)\smproxy華為源碼包\com\huawei\insa2\comm\cmpp\CMPPConnection.java

?????文件???????4230??2005-12-30?10:53??聯(lián)通網(wǎng)關(guān)\smproxy華為源碼包\com\huawei\insa2\comm\cmpp\CMPPConstant.java

?????文件???????2584??2006-01-09?17:41??聯(lián)通網(wǎng)關(guān)\smproxy華為源碼包\com\huawei\insa2\comm\cmpp\CMPPReader.java

?????文件???????1677??2005-07-11?17:43??聯(lián)通網(wǎng)關(guān)\smproxy華為源碼包\com\huawei\insa2\comm\cmpp\CMPPTransaction.java

?????文件????????909??2005-07-11?17:43??聯(lián)通網(wǎng)關(guān)\smproxy華為源碼包\com\huawei\insa2\comm\cmpp\CMPPWriter.java

............此處省略167個(gè)文件信息