mybatis 使用in 查询时报错_MyBatis(四)：mybatis中使用in查询时的注意事项

packagecom.boco.jobmonitor.model;importjava.util.Date;importjavax.persistence.GeneratedValue;importjavax.persistence.GenerationType;importjavax.persistence.Id;public classJobitem {/*** 唯一键 pk

* 列名:id 类型:INTEGER(10) 允许空:false 缺省值:null*/@Id

@GeneratedValue(strategy=GenerationType.IDENTITY)privateLong id;/*** yarn任务id(applicationId)

* 列名:appId 类型:VARCHAR(32) 允许空:false 缺省值:null*/

privateString appid;/*** 提交脚本路径

* 列名:submitFilePath 类型:VARCHAR(256) 允许空:false 缺省值:null*/

privateString submitfilepath;/*** 任务状态

* 列名:state 类型:VARCHAR(16) 允许空:true 缺省值:null*/

privateString state;/*** 监控列表

* 列名:monitorType 类型:VARCHAR(512) 允许空:true 缺省值:null*/

privateString monitortype;/*** 创建者关联Id

* 列名:createUserId 类型:VARCHAR(32) 允许空:false 缺省值:null*/

privateString createuserid;/*** 创建者用户名

* 列名:createUserName 类型:VARCHAR(32) 允许空:false 缺省值:null*/

privateString createusername;/*** 创建时间

* 列名:createTime 类型:TIMESTAMP(19) 允许空:false 缺省值:null*/

privateDate createtime;publicJobitem() {

}publicJobitem(String appid, String submitfilepath, String state, String monitortype, String createuserid,

String createusername, Date createtime) {super();this.appid =appid;this.submitfilepath =submitfilepath;this.state =state;this.monitortype =monitortype;this.createuserid =createuserid;this.createusername =createusername;this.createtime =createtime;

}publicJobitem(Long id, String appid, String submitfilepath, String state, String monitortype,

String createuserid, String createusername, Date createtime) {super();this.id =id;this.appid =appid;this.submitfilepath =submitfilepath;this.state =state;this.monitortype =monitortype;this.createuserid =createuserid;this.createusername =createusername;this.createtime =createtime;

}/*** 唯一键 pk

*

*@authorboco

*@returnid 唯一键 pk*/

publicLong getId() {returnid;

}/*** 唯一键 pk

*

*@authorboco

*@paramid

* 唯一键 pk*/

public voidsetId(Long id) {this.id =id;

}/*** yarn任务id(applicationId)

*

*@authorboco

*@returnappId yarn任务id(applicationId)*/

publicString getAppid() {returnappid;

}/*** yarn任务id(applicationId)

*

*@authorboco

*@paramappid

* yarn任务id(applicationId)*/

public voidsetAppid(String appid) {this.appid = appid == null ? null: appid.trim();

}/*** 提交脚本路径

*

*@authorboco

*@returnsubmitFilePath 提交脚本路径*/

publicString getSubmitfilepath() {returnsubmitfilepath;

}/*** 提交脚本路径

*

*@authorboco

*@paramsubmitfilepath

* 提交脚本路径*/

public voidsetSubmitfilepath(String submitfilepath) {this.submitfilepath = submitfilepath == null ? null: submitfilepath.trim();

}/*** 任务状态

*

*@authorboco

*@returnstate 任务状态*/

publicString getState() {returnstate;

}/*** 任务状态

*

*@authorboco

*@paramstate

* 任务状态*/

public voidsetState(String state) {this.state = state == null ? null: state.trim();

}/*** 监控列表

*

*@authorboco

*@returnmonitorType 监控列表*/

publicString getMonitortype() {returnmonitortype;

}/*** 监控列表

*

*@authorboco

*@parammonitortype

* 监控列表*/

public voidsetMonitortype(String monitortype) {this.monitortype = monitortype == null ? null: monitortype.trim();

}/*** 创建者关联Id

*

*@authorboco

*@returncreateUserId 创建者关联Id*/

publicString getCreateuserid() {returncreateuserid;

}/*** 创建者关联Id

*

*@authorboco

*@paramcreateuserid

* 创建者关联Id*/

public voidsetCreateuserid(String createuserid) {this.createuserid = createuserid == null ? null: createuserid.trim();

}/*** 创建者用户名

*

*@authorboco

*@returncreateUserName 创建者用户名*/

publicString getCreateusername() {returncreateusername;

}/*** 创建者用户名

*

*@authorboco

*@paramcreateusername

* 创建者用户名*/

public voidsetCreateusername(String createusername) {this.createusername = createusername == null ? null: createusername.trim();

}/*** 创建时间

*

*@authorboco

*@returncreateTime 创建时间*/

publicDate getCreatetime() {returncreatetime;

}/*** 创建时间

*

*@authorboco

*@paramcreatetime

* 创建时间*/

public voidsetCreatetime(Date createtime) {this.createtime =createtime;

}

}