最近接触使用iBATIS,但是手工写实体类太麻烦,就自己写了小工具根据数据库表生成实体类和映射文件。
工具生成的XML片段如下:
<select id="BdUser.queryAll" resultClass="com.rickysun.entity.BdUser"> select * from bd_user </select> <select id="BdUser.queryByID" resultClass="com.rickysun.entity.BdUser"> select * from bd_user where UserID=#UserID# </select> <insert id="BdUser.insert" parameterClass="com.rickysun.entity.BdUser"> insert into bd_user (UserName,UserPass,RegTime,RegIP,LastTime,LastIP,UserScore) values (#userName#,#userPass#,#regTime#,#regIP#,#lastTime#,#lastIP#,#userScore#) <selectKey resultClass="Integer" keyProperty="UserID"> select last_insert_id() </selectKey> </insert> <update id="BdUser.update" parameterClass="com.rickysun.entity.BdUser"> update bd_user set UserName=#userName#,UserPass=#userPass#,RegTime=#regTime#,RegIP=#regIP#,LastTime=#lastTime#,LastIP=#lastIP#,UserScore=#userScore# where UserID=#userID# </update> <delete id="BdUser.delete" parameterClass="com.rickysun.entity.BdUser"> delete from bd_user where UserID=#userID# </delete>
生成的Java实体类如下:
package com.rickysun.entity;
public class BdUser implements com.rickysun.framework.BasicEntity,java.io.Serializable {
private static final long serialVersionUID=1L;
protected java.lang.Integer userID = null;
protected java.lang.String userName = null;
protected java.lang.String userPass = null;
protected java.sql.Timestamp regTime = null;
protected java.lang.String regIP = null;
protected java.sql.Timestamp lastTime = null;
protected java.lang.String lastIP = null;
protected java.math.BigDecimal userScore = null;
public BdUser() {
}
public String getTableName() {
return "bd_user";
}
public java.lang.Integer getUserID() {
return userID;
}
public void setUserID(java.lang.Integer userID) {
this.userID=userID;
}
public java.lang.String getUserName() {
return userName;
}
public void setUserName(java.lang.String userName) {
this.userName=userName;
}
public java.lang.String getUserPass() {
return userPass;
}
public void setUserPass(java.lang.String userPass) {
this.userPass=userPass;
}
public java.sql.Timestamp getRegTime() {
return regTime;
}
public void setRegTime(java.sql.Timestamp regTime) {
this.regTime=regTime;
}
public java.lang.String getRegIP() {
return regIP;
}
public void setRegIP(java.lang.String regIP) {
this.regIP=regIP;
}
public java.sql.Timestamp getLastTime() {
return lastTime;
}
public void setLastTime(java.sql.Timestamp lastTime) {
this.lastTime=lastTime;
}
public java.lang.String getLastIP() {
return lastIP;
}
public void setLastIP(java.lang.String lastIP) {
this.lastIP=lastIP;
}
public java.math.BigDecimal getUserScore() {
return userScore;
}
public void setUserScore(java.math.BigDecimal userScore) {
this.userScore=userScore;
}
}
有兴趣的朋友可以参考使用一下。欢迎与我讨论。