利用freemaker，生成数据库的所有表操作代码,Java代码库,德仔网

代码语言
代码分类
【Java】利用freemaker，生成数据库的所有表操作
作者:问题少年_daxia / 发布于2012/4/7/ 531
纯jdbc操作、sql语句只拼了mysql的
<div>生成的model</div>
<div>package com.xxtiandi.model;</div>
<div>public class Codecomment {</div>
<div>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;

}
}
</div>
<div></div>
<div></div>
<div>生成的Dao操作</div>
<div>package com.xxtiandi.dao;</div>
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;</div>
import com.xxtiandi.model.Codecomment;
import com.xxtiandi.util.ModelHelper;
import com.xxtiandi.util.ModelToSQL;</div>
<div>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;
}
<div>/**
 * 更新一行记录
 */
public boolean update(Codecomment t) {
int rst = -1;
String sql = ModelToSQL.getUpdateSQL(t);
rst = DBUtil.executeUpdate(sql, t.getComId());
return rst > 0;
}
<div>/**
 * 删除一行记录
 */
public boolean delete(Codecomment t) {
int rst = -1;
String sql = ModelToSQL.getDeleteSQL(t);
rst = DBUtil.executeUpdate(sql, t.getComId());
return rst > 0;
}
<div>/**
 * 根据ID删除一行记录
 */
public boolean delete(String id) {
int rst = -1;
String sql = ModelToSQL.getDeleteSQL("Codecomment", "ComId");
rst = DBUtil.executeUpdate(sql, id);
return rst > 0;
}
<div>/**
 * 根据IDs删除多行记录
 */
public boolean delete(String[] ids) {
for (String id : ids) {
if (delete(id) == false) {
return false;
}
}
return true;
}
<div>/**
 * 根据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;
}
<div>/**
 * 分页查询
 */
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;
}
<div>/**
 * 根据条件分页查询
 */
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;
}
<div>/**
 * 查询所有记录
 */
public List<Codecomment> queryAll(String orderBy) {
String sql = ModelToSQL.getQueryAllSQL(new Codecomment(), orderBy);
List<Codecomment> list = commitQuery(sql);
return list;
}
<div>/**
 * 统一上面查询的操作
 * 
 * @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;
}
}
</div>
试试其它关键字
　freemaker　
同语言下
可能有用的
问题少年_daxia贡献的其它代码(1)
.利用freemaker，生成数据库的所有表操作