最近一直觉得注册的账户越来越多,帐号密码神马的容易弄混。自己就折腾了一个简单的账户管理工具,其实实现也挺简单,将每个账户的密码及相关密码提示信息,经aes算法加密之后保存到数据库,当前登录用户可以查询自己的账户信息,而不是别人的。界面如下:
数据表sql语句:
1 GO 2 3 /****** Object: Table [dbo].[tb_Account] Script Date: 10/23/2013 14:00:39 ******/ 4 SET ANSI_NULLS ON 5 GO 6 7 SET QUOTED_IDENTIFIER ON 8 GO 9 10 SET ANSI_PADDING ON 11 GO 12 13 CREATE TABLE [dbo].[tb_Account]( 14 [typeId] [int] NOT NULL, 15 [Id] [int] IDENTITY(1,1) NOT NULL, 16 [userId] [int] NOT NULL, 17 [AcountName] NVARCHAR(50)NOT NULL, 18 [AcountMessage] [nvarchar](100) NULL, 19 [Pwd] [varchar](50) NOT NULL 20 ) ON [PRIMARY] 21 22 GO 23 24 SET ANSI_PADDING OFF 25 GO
1 USE AcountManager 2 GO 3 4 /****** Object: Table [dbo].[tb_type] Script Date: 10/23/2013 14:00:58 ******/ 5 SET ANSI_NULLS ON 6 GO 7 8 SET QUOTED_IDENTIFIER ON 9 GO 10 11 CREATE TABLE [dbo].[tb_type]( 12 [typeName] [nvarchar](50) NOT NULL, 13 [Id] [int] IDENTITY(1,1) NOT NULL 14 ) ON [PRIMARY] 15 16 GO
1 USE AcountManager 2 GO 3 4 /****** Object: Table [dbo].[tb_Account] Script Date: 10/23/2013 14:00:39 ******/ 5 SET ANSI_NULLS ON 6 GO 7 8 SET QUOTED_IDENTIFIER ON 9 GO 10 11 SET ANSI_PADDING ON 12 GO 13 14 CREATE TABLE [dbo].[tb_Account]( 15 [typeId] [int] NOT NULL, 16 [Id] [int] IDENTITY(1,1) NOT NULL, 17 [userId] [int] NOT NULL, 18 [AcountMessage] [nvarchar](100) NULL, 19 [Pwd] [varchar](50) NOT NULL 20 ) ON [PRIMARY] 21 22 GO 23 24 SET ANSI_PADDING OFF 25 GO
有个小工具,总比放在文本文件中好些,管理起来也方便点,关于密码等信息,也是经过md5或者aes加密算法处理的。