Question

求这段SQL语句 在 mybatis 里面怎么写

Declare @khno varchar(15) , @Fieldstr varchar(1000), @querystr varchar(1000);
select @khno = '', @Fieldstr = '', @querystr = ' and quyu = ''A1AA'' '
select @Fieldstr = 'substring(customerno, 1+4, len(customerno)-4) '
Exec p_AutoNewId_str 'basecustomer', @Fieldstr, @khno output, @querystr, 1
Select 'A1AA' + @khno -- A1AA13
存储过程

ALTER Procedure [dbo].[P_AutoNewID_str]
(
@TableName varchar(50),
@FieldName varchar(50),
@OldID varchar(50) output,
@Qfactor varchar(150),
@delete int=1
)

Answer 1

public User(String mima){//构造方法
super();
this.mima=mima;
}
public String getMima() {//get，set方法
return mima;
}
public void setMima(String mima) {
this.mima = mima;
}