为了处理每日让人烦躁的黑名单号码,开发了个手机号码区号查询工具
 
1.开发环境:jdk1.5,sql2000,eclipse3.5
2.描述:程序实现了单个号码的查询和多个号码的批量查询
 
界面如下:
 
项目文件在附件里。
用到的存储过程如下:
progress:
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
ALTER  proc progress
@table_name varchar(20),@filePath varchar(50)
as
 if exists (select * from sysobjects where name = ''+ @table_name + '' and xtype = 'U')
 begin
  exec('drop table '+@table_name)
 end
 if exists (select * from sysobjects where name = 'sucess_result' and xtype = 'U')
 begin
  exec('drop table sucess_result')
 end
 if exists (select * from sysobjects where name = 'fail_result' and xtype = 'U')
 begin
  exec('drop table fail_result')
 end
 exec('create table '+@table_name+' (phone varchar(20))')
 exec('exec master..xp_cmdshell ''bcp chinasection..'+@table_name+' in '+ @filePath +' -c -T''')
 exec('select c.areacode as areacode, t.phone as phone into sucess_result from '+@table_name+' t, chinahd c where c.sectionno = left(t.phone,7)')
 exec('select * into fail_result from '+@table_name+' where phone not in (select phone from sucess_result)')
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
 
outputphone:
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
ALTER  proc outputphone
as
 exec master..xp_cmdshell 'bcp chinasection..sucess_result out D:\黑名单处理\sucess_result.txt -c -T'
 exec master..xp_cmdshell 'bcp chinasection..fail_result out D:\黑名单处理\fail_result.txt -c -T'

GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO