最近接触使用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;
}
}
有兴趣的朋友可以参考使用一下。欢迎与我讨论。![]()
本文介绍了一款针对iBATIS的小工具,该工具可以根据数据库表自动生成实体类及映射文件,极大提升了开发效率。文中提供了生成的XML映射文件和Java实体类样例。
3658

被折叠的 条评论
为什么被折叠?



