利用freemaker，生成数据库的所有表操作，freemaker数据库,纯jdbc操作、sql语

利用freemaker，生成数据库的所有表操作，freemaker数据库,纯jdbc操作、sql语

纯jdbc操作、sql语句只拼了mysql的。

[Java]代码

生成的modelpackage com.xxtiandi.model;public class Codecomment {    private int  ComId;    private int  CodeId;    private String  UserId;    private String  UserName;    private String  SImage;    private String  BImage;    private String  Content;    private String  ComTime;    private int  Verify;    private String  IPAddress;    private int  State;    public int getComId() {        return ComId;    }    public void setComId(int ComId) {        this.ComId = ComId;    }    public int getCodeId() {        return CodeId;    }    public void setCodeId(int CodeId) {        this.CodeId = CodeId;    }    public String getUserId() {        return UserId;    }    public void setUserId(String UserId) {        this.UserId = UserId;    }    public String getUserName() {        return UserName;    }    public void setUserName(String UserName) {        this.UserName = UserName;    }    public String getSImage() {        return SImage;    }    public void setSImage(String SImage) {        this.SImage = SImage;    }    public String getBImage() {        return BImage;    }    public void setBImage(String BImage) {        this.BImage = BImage;    }    public String getContent() {        return Content;    }    public void setContent(String Content) {        this.Content = Content;    }    public String getComTime() {        return ComTime;    }    public void setComTime(String ComTime) {        this.ComTime = ComTime;    }    public int getVerify() {        return Verify;    }    public void setVerify(int Verify) {        this.Verify = Verify;    }    public String getIPAddress() {        return IPAddress;    }    public void setIPAddress(String IPAddress) {        this.IPAddress = IPAddress;    }    public int getState() {        return State;    }    public void setState(int State) {        this.State = State;    }}

[Java]代码

生成的Dao操作package com.xxtiandi.dao;import java.sql.Connection;import java.sql.ResultSet;import java.sql.SQLException;import java.util.ArrayList;import java.util.List;import com.xxtiandi.model.Codecomment;import com.xxtiandi.util.ModelHelper;import com.xxtiandi.util.ModelToSQL;public class CodecommentDao implements DaoInterface<Codecomment> {    /**     * 插入一行记录     */    public boolean insert(Codecomment t) {        int rst = -1;        String sql = ModelToSQL.getInsertSQL(t);        rst = DBUtil.executeUpdate(sql);        return rst > 0;    }    /**     * 更新一行记录     */    public boolean update(Codecomment t) {        int rst = -1;        String sql = ModelToSQL.getUpdateSQL(t);        rst = DBUtil.executeUpdate(sql, t.getComId());        return rst > 0;    }    /**     * 删除一行记录     */    public boolean delete(Codecomment t) {        int rst = -1;        String sql = ModelToSQL.getDeleteSQL(t);        rst = DBUtil.executeUpdate(sql, t.getComId());        return rst > 0;    }    /**     * 根据ID删除一行记录     */    public boolean delete(String id) {        int rst = -1;        String sql = ModelToSQL.getDeleteSQL("Codecomment", "ComId");        rst = DBUtil.executeUpdate(sql, id);        return rst > 0;    }    /**     * 根据IDs删除多行记录     */    public boolean delete(String[] ids) {        for (String id : ids) {            if (delete(id) == false) {                return false;            }        }        return true;    }    /**     * 根据ID查询一行记录     */    public Codecomment queryById(String id) {        Connection conn = null;        ResultSet rs = null;        String sql = ModelToSQL.getQueryByIdSQL("Codecomment", "ComId");        Codecomment model = new Codecomment();        try {            conn = DBUtil.getConn();            rs = DBUtil.executeQuery(conn, sql, id);            while (rs.next()) {                ModelHelper.rsToModel(rs, model);            }        } catch (SQLException e) {            e.printStackTrace();        } finally {            DBUtil.close(conn, null, rs);        }        return model;    }    /**     * 分页查询     */    public List<Codecomment> query(int limit, int page, String orderBy) {        String sql = ModelToSQL.getQuery(new Codecomment(), null, null, limit,                page, orderBy);        List<Codecomment> list = commitQuery(sql);        return list;    }    /**     * 根据条件分页查询     */    public List<Codecomment> query(String where, int limit, int page,            String orderBy) {        String sql = ModelToSQL.getQuery(new Codecomment(), null, where, limit,                page, orderBy);        List<Codecomment> list = commitQuery(sql);        return list;    }    /**     * 查询所有记录     */    public List<Codecomment> queryAll(String orderBy) {        String sql = ModelToSQL.getQueryAllSQL(new Codecomment(), orderBy);        List<Codecomment> list = commitQuery(sql);        return list;    }    /**     * 统一上面查询的操作     *      * @param sql     * @return     */    private List<Codecomment> commitQuery(String sql) {        List<Codecomment> list = new ArrayList<Codecomment>();        Connection conn = null;        ResultSet rs = null;        try {            conn = DBUtil.getConn();            rs = DBUtil.executeQuery(conn, sql);            while (rs.next()) {                Codecomment model = new Codecomment();                ModelHelper.rsToModel(rs, model);                list.add(model);            }        } catch (SQLException e) {            e.printStackTrace();        } finally {            DBUtil.close(conn, null, rs);        }        return list;    }}