¼±ÇómysqlÓï¾ä - Java / Web ¿ª·¢
Ò»¡¢Êý¾Ý²éѯ
SMSServer uses three database tables to do:
One for sending the outbound messages.
create table smsserver_out (
id int(10) unsigned not null auto_increment,
`type` varchar(1) not null default 'o',
recipient varchar(16) not null,
`text` varchar(1000) not null,
wap_url varchar(100) null default null,
wap_expiry_date datetime null default null,
wap_signal varchar(1) null default null,
create_date datetime not null,
originator varchar(16) not null default ' ',
encoding varchar(1) not null default '7',
status_report int(1) not null default 0,
flash_sms int(1) not null default 0,
src_port int(6) not null default -1,
dst_port int(6) not null default -1,
sent_date datetime null default null,
ref_no varchar(64) null default null,
priority int(5) not null default 0,
`status` varchar(1) not null default 'u',
`errors` int(2) not null default 0,
gateway_id varchar(64) not null default '*',
primary key (id)
)
engine=myisam
row_format=default
auto_increment=33
˵Ã÷:
ÕâÊÇÒ»ÕŶÌÐżÇ¼±í£¨mysql£©£¬
Id:Ö÷¼ü
type:¶ÌÐÅÀàÐÍ£¨¡¯O¡¯ÎªÆÕͨ¶ÌÐÅ,¡¯W¡¯Îªwap¶ÌÐÅ£©
recipient:¶ÌÐŽÓÊÕÕß(ÊÖ»úºÅ)
text:¶ÌÐÅÄÚÈÝ
create_date:¶ÌÐżÇ¼Ìí¼Óʱ¼ä
status_report:ÊÇ·ñÐèÒª»ØÖ´(0ΪÐèÒª»ØÖ´¡¢£±ÎªÐèÒª»ØÖ´)
sent_date:¶ÌÐÅ·¢ËÍʱ¼ä
status:¶ÌÐÅ״̬£¬"U" : δ·¢ËÍ, "Q" :ÕýÔÚ·¢Ë
Ïà¹ØÎÊ´ð£º
ÔÚaspÀïÔõôµ÷ÓÃjavaдµÄwebservice·½·¨£¬Óкܶ෽·¨
- <message name="RtPnrIn">
<part name="bstrPnrNO" type="s:string" />
<part name ......
±¾ÈËÕýÔÚÓÃJava×öÒ»¸öC/S¼Ü¹¹µÄÏîÄ¿£¬
¿ÉÊÇÓÉÓÚÏîÄ¿±È½Ï´ó£¬Ç°ÆÚ¶Ô¼Ü¹¹µÄÉè¼ÆÓÈÆäÖØÒª£¬ÒòΪºóÆÚ¿ÉÄÜËæÊ±»á¼Ó¸ö¹¦ÄÜ»òÕßÈ¥µôijЩ¹¦ÄÜ¡£
ËùÒÔÌØµØÑ°ÇóÈçºÎÉè¼ÆC/SµÄ¼Ü¹¹Ê¹³ÌÐò¸ü¼ÓÃæÏò¶ÔÏó¸ü¼ÓÒ×ÓÚά ......
org.apache.jasper.JasperException: Unable to compile class for JSP:
An error occurred at line: 52 in the jsp file: /vip_info.jsp
ÕË cannot be resolved
49: <table border="1& ......
ÔÚJSPÒ³ÃæÓÐÒ»¸ö<input type="hidden" name="index" value="0">/>¿Ø¼þ
µ±ÎÒÓÃÏÂÃæµÄJavaScriptº¯Êý¸Ä±äÆävalueµÄÖµµÄʱºò Èç¹ûÂú×ãÌõ¼þ£¨¼´i>=3µÄʱºò£©ÎªÊ²Ã´valueµÄ ......
ÎÒÊǸöÐÂÊÖ£¬Íû¸ßÊÖ½â´ð
ÎÒÏÖÔÚÒѾ°²×°ÁËmysql£¬Ò²ÓÐmysqlµÄjdbc¡£µ«ÎÒÔõôÅäÖú󣬲ÅÄÜÔÚMyEclipseÀï²Ù×÷mysqlÄØ£¿Çë¸ßÊÖ˵Ïêϸµã
´ò¿ªMyeclipse----window---open perspective---MyEclipse database explorer-- ......