java微信公共账号后台服务开发

create table T_TextMatch ( MatchContent VARCHAR(512), MatchWay VARCHAR(10), MatchOrder VARCHAR(20), RETURNObject VARCHAR(25), UpdataStaff VARCHAR(40), UpdateTime Date, weixin_id VARCHAR(256) ) create table T_ObjectType ( ObjectID VARCHAR(25), MsgType VARCHAR(10), weixin_id VARCHAR(256) ) create table T_ObjectText ( ObjectID VARCHAR(25), Content VARCHAR(512), weixin_id VARCHAR(256) ) create table T_ObjectImage ( ObjectID VARCHAR(25), MediaId VARCHAR(512), weixin_id VARCHAR(256) ) create table T_ObjectVoice ( ObjectID VARCHAR(25), MediaId VARCHAR(512), weixin_id VARCHAR(256) ) create table T_ObjectVideo ( ObjectID VARCHAR(25), MediaId VARCHAR(512), Title VARCHAR(50), Description VARCHAR(256), weixin_id VARCHAR(256) ) create table T_ObjectMusic ( ObjectID VARCHAR(25), Title VARCHAR(50), Description VARCHAR(256), MusicUrl VARCHAR(500), HQMusicUrl VARCHAR(500), ThumbMediaId VARCHAR(512), weixin_id VARCHAR(256) ) create table T_ObjectItem ( ObjectID VARCHAR(25), Title VARCHAR(50), Description VARCHAR(256), PicUrl VARCHAR(500), Url VARCHAR(500), weixin_id VARCHAR(256) ) create table T_ObjectArticles ( ObjectID VARCHAR(25), Description VARCHAR(256), weixin_id VARCHAR(256) ) create table T_ArticlesItem ( ArticlesObjectID VARCHAR(25), ItemObjectID VARCHAR(25), ShowOrder VARCHAR(2), weixin_id VARCHAR(256) ) create table T_EventMatch ( MatchContent VARCHAR(512), MatchWay VARCHAR(10), MatchOrder VARCHAR(20), RETURNObject VARCHAR(25), UpdataStaff VARCHAR(40), UpdateTime Date, weixin_id VARCHAR(256) ) create table T_interlog ( TradeSeq int(10) not null auto_increment, TradeTime date, FromUserName VARCHAR(200), ToUserName VARCHAR(200), InXml VARCHAR(8000), OutXml VARCHAR(8000), PRIMARY KEY (`TradeSeq`), weixin_id VARCHAR(256) ) create table T_weixin_userinfo ( username VARCHAR(20), weixin_id VARCHAR(256), weixin_type VARCHAR(2), weixin_appid VARCHAR(256), weixin_AppSecret VARCHAR(256), weixin_token VARCHAR(256), weixin_EncodingAESKey VARCHAR(128), weixin_secrettype VARCHAR(2), update_time datetime )