1 测试数据库搭建
本文是《.NET/JAVA/PHP/Python 企业级Web开发框架整合系列》之中的一个框架,使用的数据库与其他框架相同。
这里再提供一下本文使用到的SYS_USER表的建表SQL:
-- Create table
create table SYS_USER
(
user_code VARCHAR2(36) PRIMARY KEY,
login_name VARCHAR2(50) not null,
login_pwd VARCHAR2(50) not null,
user_level NUMBER(2) not null,
user_type NUMBER(2) not null,
telephone VARCHAR2(50),
position VARCHAR2(50),
user_name VARCHAR2(50) not null,
org_code VARCHAR2(50) not null,
head_portrait VARCHAR2(200),
user_sex NUMBER(2) not null,
register_time DATE not null,
last_logon_type NUMBER(2),
last_logon_time DATE,
last_logon_ip VARCHAR2(50),
logon_count NUMBER(8) not null,
logon_error_count NUMBER(8) not null,
user_state NUMBER(2) not null,
expire_policy NUMBER(2) not null,
allow_logined_count NUMBER(8) not null,
expire_date DATE not null
);
-- Add comments to the columns
comment on column SYS_USER.user_code is '用户编码,可以是手机号码等';
comment on column SYS_USER.login_name is '登录名称';
comment on column SYS_USER.login_pwd is '登录密码';
comment on column SYS_USER.user_level is '用户级别,1:总经理,2:部门经理,3:部门主管,4:客户经理';
comment on column SYS_USER.user_type is '用户类型,1:普通用户,2:管理员';
comment on column SYS_USER.telephone is '联系电话';
comment on column SYS_USER.position is '职位';
comment on column SYS_USER.user_name is '用户姓名';
comment on column SYS_USER.org_code is '机构编码,指向sys_org表';
comment on column SYS_USER.head_portrait is '用户头像';
comment on column SYS_USER.user_sex is '用户性别,1:男,2:女';
comment on column SYS_USER.register_time is '注册时间';
comment on column SYS_USER.last_logon_type is '最后登录方式,1:android,2:web,3:IOS';
comment on column SYS_USER.last_logon_time is '最后登录时间';
comment on column SYS_USER.last_logon_ip is '最后登录IP';
comment on column SYS_USER.logon_count is '登录总数';
comment on column SYS_USER.logon_error_count is '登录错误总数,同一天错误指定次数后锁定';
comment on column SYS_USER.user_state is '1:新注册未审核,2:正常,3:锁定';
comment on column SYS_USER.expire_policy is '密码过期策略,1:永不过期,2:登陆次数,3:指定日期,4:下次登陆修改密码';
comment on column SYS_USER.allow_logined_count is '允许登陆次数,在EXPIRE_POLICY为2时有效';
comment on column SYS_USER.expire_date is '账户过期日期,在EXPIRE_POLICY为3时有效';
2 jar包导入
需要导入的包如下:
c3p0-0.9.2.1.jar
mybatis-3.2.5.jar
mybatis-generator-core-1.3.1.jar
mybatis-spring-1.2.1.jar
ojdbc14.jar
本文结束将附完整的项目代码,包含所有jar。
3 编写java类
A.创建javabean
创建包:com.whowii.core.bean,并在其中创建类:User,代码如下:
package com.whowii.core.bean;
import java.util.Date;
public class User implements java.io.Serializable {
private static final long serialVersionUID = 7442514800601880744L;
private String userCode;
private String loginName;
private String loginPwd;
private Byte userLevel;
private Byte userType;
private String telephone;
private String position;
private String userName;
pr