设计表时增加一个索引就可以了
 
索引属性为unique
 
 
 
 
 

1.若设置字符串默认值为'否'，可以如下操作：
 
在navicat 的表设计界面中，选中字段，在默认值里面输入
 
 
 
'否'::character varying
 
 
 
2.设置uuid默认值
 
 
 
uuid_generate_v4()
 
 
3.设置自动增长列
 
有两种方法，第一种：可以在默认框输入公式
 
 
 
 nextval('t_sys_dic_fid_seq'::regclass)
 
 
第二种：勾选标识，并选择生成的方式"GENRATED BY DEFAULT"
 

create schema DM
 go
 
CREATE TABLE DM.DIM_PP_Co_borrower(
     PP_Co_borrower_Key int identity(1,1) not null,
     Marital_Status Nvarchar(100),
     PP_as_Co_borrower Nvarchar(20),
     ID  int,
     [SRS_SYS_INSERTDATE] [datetime] NULL,
     [SRS_SYS_UPDATEDATE] [datetime] null,
     [SRS_SYS_ISCURRENTFLAG] int NULL,
     [EFFECTIVE_DATE] int NULL,
     [INEFFECTIVE_DATE] int NULL
 ) ON [PRIMARY]
 
GO
 
ALTER TABLE DM.DIM_PP_Co_borrower ADD  DEFAULT (getdate()) FOR [SRS_SYS_INSERTDATE]
 GO
 ALTER TABLE DM.DIM_PP_Co_borrower ADD  DEFAULT (getdate()) FOR [SRS_SYS_UPDATEDATE]
 GO
 ALTER TABLE DM.DIM_PP_Co_borrower ADD  DEFAULT (1) FOR [SRS_SYS_ISCURRENTFLAG]
 GO
 ALTER TABLE DM.DIM_PP_Co_borrower ADD  DEFAULT (cast(CONVERT(varchar(8), GETDATE(), 112) as int)) FOR [EFFECTIVE_DATE]
 GO
 ALTER TABLE DM.DIM_PP_Co_borrower ADD  DEFAULT (99991231) FOR [INEFFECTIVE_DATE]
 GO
 
insert DM.DIM_PP_Co_borrower(Marital_Status,PP_as_Co_borrower,ID)values('F','AGG',1234)

定义测试对象
 
public class User {

    private int age;
    private String name;
    private Date birthday;
    private boolean adult;

    public int getAge() {
        return age;
    }

    public void setAge(int age) {
        this.age = age;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public Date getBirthday() {
        return birthday;
    }

    public void setBirthday(Date birthday) {
        this.birthday = birthday;
    }

    public boolean isAdult() {
        return adult;
    }

    public void setAdult(boolean adult) {
        this.adult = adult;
    }

    @Override
    public String toString() {
        return "User{" +
                "age=" + age +
                ", name='" + name + '\'' +
                ", birthday=" + birthday +
                ", adult=" + adult +
                '}';
    }
}
 
测试代码
 
    private static Object getValue(Object object, String fieldName) {
        try {
            Field field = object.getClass().getDeclaredField(fieldName);
            field.setAccessible(true);
            return field.get(object);
        } catch (NoSuchFieldException e) {

        } catch (IllegalAccessException e) {

        }
        return null;
    }

    public static <T> void setValue(T t, String fieldName, Object value) {
        try {
            Class<T> tClass = (Class<T>) t.getClass();
            Field declaredField = tClass.getDeclaredField(fieldName);
            declaredField.setAccessible(true);
            declaredField.set(t, value);
        } catch (NoSuchFieldException e) {

        } catch (SecurityException e) {

        } catch (IllegalArgumentException e) {

        } catch (IllegalAccessException e) {

        }
    }


    public static void main(String[] args){
        User user = new User();
        user.setAge(11);
        user.setBirthday(new Date());
        user.setAdult(false);
        user.setName("张三");

        Object age = getValue(user, "age");
        Object name = getValue(user, "name");
        Object birthday = getValue(user, "birthday");
        Object adult = getValue(user, "adult");

        User copyUser = new User();
        setValue(copyUser, "age", age);
        setValue(copyUser, "name", name);
        setValue(copyUser, "birthday", birthday);
        setValue(copyUser, "adult", adult);

        System.out.println(user);
        System.out.println(copyUser);

    }
 
运行man函数结果
 
User{age=11, name='张三', birthday=Wed Jan 13 10:34:39 CST 2021, adult=false}
 User{age=11, name='张三', birthday=Wed Jan 13 10:34:39 CST 2021, adult=false}