数据访问接口的实现

数据库的generalUser表
    create table `estate_db`.`t_generaluser`(
        `UserID` int,
       `UserName` varchar(20) default '' not null,
       `UserPwd` varchar(20) default '' not null,
       `UserEmail` varchar(40) unique,
       `PwdQuestion` varchar(40) default '' not null,
       `PwdAnswer` varchar(20) default '' not null,
       `FormRoleID` int,
       `PlatRoleID` int,
       `Tel` varchar(20) default '' not null,
       `qq` varchar(20),
       `RegTime` datetime,
       `EditTime` datetime,
       `LoginTimes` int,
       `LastLoginTime` datetime,
       `LockFlag` bit,
       `CompanyName` varchar(40),
        primary key (`UserName`)
    );

    create unique index `PRIMARY` on `estate_db`.`t_generaluser`(`UserName`);
    create unique index `UserName_UNIQUE` on `estate_db`.`t_generaluser`(`UserName`);
    create unique index `UserEmail_UNIQUE` on `estate_db`.`t_generaluser`(`UserEmail`);

数据库的t_admin表:

    create table `estate_db`.`t_admin`(
        `AdminID` int,
       `AdminName` varchar(20) not null,
       `AdminPwd` varchar(20),
       `RegTime` datetime,
        primary key (`AdminName`)
    );

    create unique index `PRIMARY` on `estate_db`.`t_admin`(`AdminName`);
    create unique index `AdminName_UNIQUE` on `estate_db`.`t_admin`(`AdminName`);

数据库连接工具:ConnectioUtil

generalUser用户：类generalUser

generalUser注册程序的SQL语句：insert t_generalUser(UserName,UserPwd,userEmail,PwdQuestion,PwdAnswer)
values('FenYun','3698741','FenYun@163.com','我喜爱的动物','白鸽');

generalUser登录程序的SQL语句:

select * from t_generalUser where UserName like 'FenYun' and UserPwd like '3698741';

统计当前用户数量的SQL语句:

select  count(*) from t_generalUser;

admin用户:类admin

admin登录程序的SQL 语句:

select * from t_admin where AdminName LIKE 'yantai' AND AdminPwd like 'yantai';