一、数据查询
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" :正在发�
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& ......
