生成iBATIS实体类和映射文件的工具

最近接触使用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;  
        }  
    }  

 有兴趣的朋友可以参考使用一下。欢迎与我讨论。

评论

3 楼 awoshiwo 2013-07-09  

怎么使用啊？求指导

2 楼 yuaihui 2012-11-29  

怎么用啊，老哥。

1 楼 tempestlxc 2011-08-15  

=。=~~~
刚被逼手写了个50多个字段的实体类~~
太郁闷了~~~