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ù)庫連接成功“）;
????????????
????????????}
???????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ù)庫中有短信取出指定條記錄（默認(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í)間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2018-11-01?17:28??鍗庝負(fù)smproxy璋冪敤鏍蜂緥\
?????目錄???????????0??2013-01-24?16:46??鍗庝負(fù)smproxy璋冪敤鏍蜂緥\javaSGIP\
?????文件????????3410??2009-04-07?20:05??鍗庝負(fù)smproxy璋冪敤鏍蜂緥\javaSGIP\DbMonitor.class
?????文件????????1193??2009-04-07?23:53??鍗庝負(fù)smproxy璋冪敤鏍蜂緥\javaSGIP\MySgipProxy.class
?????文件????????1174??2009-04-03?21:19??鍗庝負(fù)smproxy璋冪敤鏍蜂緥\javaSGIP\SGIP.class
?????文件?????????838??2009-03-20?11:27??鍗庝負(fù)smproxy璋冪敤鏍蜂緥\javaSGIP\MySgipProxy.java
?????文件?????????628??2009-03-20?09:49??鍗庝負(fù)smproxy璋冪敤鏍蜂緥\javaSGIP\SGIP.java
?????文件????????3653??2009-04-07?20:05??鍗庝負(fù)smproxy璋冪敤鏍蜂緥\javaSGIP\DbMonitor.java
?????文件????????1008??2009-04-19?12:19??鍗庝負(fù)smproxy璋冪敤鏍蜂緥\app.xml
?????文件????????6148??2018-11-01?17:29??鍗庝負(fù)smproxy璋冪敤鏍蜂緥\.DS_Store
?????目錄???????????0??2018-11-01?17:29??__MACOSX\
?????目錄???????????0??2018-11-01?17:29??__MACOSX\鍗庝負(fù)smproxy璋冪敤鏍蜂緥\
?????文件?????????120??2018-11-01?17:29??__MACOSX\鍗庝負(fù)smproxy璋冪敤鏍蜂緥\._.DS_Store
?????文件???????????0??2018-11-01?17:27??鍗庝負(fù)smproxy璋冪敤鏍蜂緥\smproxy鍗庝負(fù)婧愮爜鍖?
?????文件????????6148??2018-11-01?17:27??鍗庝負(fù)smproxy璋冪敤鏍蜂緥\smproxy鍗庝負(fù)婧愮爜鍖?.DS_Store
?????文件???????????0??2018-11-01?17:29??__MACOSX\鍗庝負(fù)smproxy璋冪敤鏍蜂緥\smproxy鍗庝負(fù)婧愮爜鍖?
?????文件?????????120??2018-11-01?17:27??__MACOSX\鍗庝負(fù)smproxy璋冪敤鏍蜂緥\smproxy鍗庝負(fù)婧愮爜鍖?._.DS_Store
?????目錄???????????0??2013-01-24?16:46??鍗庝負(fù)smproxy璋冪敤鏍蜂緥\smproxy鍗庝負(fù)婧愮爜鍖?com\
?????目錄???????????0??2013-01-24?16:46??鍗庝負(fù)smproxy璋冪敤鏍蜂緥\smproxy鍗庝負(fù)婧愮爜鍖?com\huawei\
?????目錄???????????0??2013-01-24?16:46??鍗庝負(fù)smproxy璋冪敤鏍蜂緥\smproxy鍗庝負(fù)婧愮爜鍖?com\huawei\insa2\
?????目錄???????????0??2013-01-24?16:46??鍗庝負(fù)smproxy璋冪敤鏍蜂緥\smproxy鍗庝負(fù)婧愮爜鍖?com\huawei\insa2\util\
?????文件????????3741??2004-07-30?20:35??鍗庝負(fù)smproxy璋冪敤鏍蜂緥\smproxy鍗庝負(fù)婧愮爜鍖?com\huawei\insa2\util\base64.java
?????文件????????3877??2004-07-30?20:35??鍗庝負(fù)smproxy璋冪敤鏍蜂緥\smproxy鍗庝負(fù)婧愮爜鍖?com\huawei\insa2\util\Resource.java
?????文件???????21521??2004-07-30?20:35??鍗庝負(fù)smproxy璋冪敤鏍蜂緥\smproxy鍗庝負(fù)婧愮爜鍖?com\huawei\insa2\util\Cfg.java
?????文件????????2285??2006-03-13?11:00??鍗庝負(fù)smproxy璋冪敤鏍蜂緥\smproxy鍗庝負(fù)婧愮爜鍖?com\huawei\insa2\util\WatchThread.java
?????文件???????23103??2004-07-30?20:35??鍗庝負(fù)smproxy璋冪敤鏍蜂緥\smproxy鍗庝負(fù)婧愮爜鍖?com\huawei\insa2\util\Debug.java
?????文件????????6221??2004-07-30?20:35??鍗庝負(fù)smproxy璋冪敤鏍蜂緥\smproxy鍗庝負(fù)婧愮爜鍖?com\huawei\insa2\util\SecurityTools.java
?????文件????????5758??2004-07-30?20:35??鍗庝負(fù)smproxy璋冪敤鏍蜂緥\smproxy鍗庝負(fù)婧愮爜鍖?com\huawei\insa2\util\Args.java
?????文件????????3933??2004-09-24?15:39??鍗庝負(fù)smproxy璋冪敤鏍蜂緥\smproxy鍗庝負(fù)婧愮爜鍖?com\huawei\insa2\util\TypeConvert.java
?????目錄???????????0??2013-01-24?16:46??鍗庝負(fù)smproxy璋冪敤鏍蜂緥\smproxy鍗庝負(fù)婧愮爜鍖?com\huawei\insa2\comm\
?????目錄???????????0??2013-01-24?16:46??鍗庝負(fù)smproxy璋冪敤鏍蜂緥\smproxy鍗庝負(fù)婧愮爜鍖?com\huawei\insa2\comm\cmpp30\
............此處省略157個(gè)文件信息